7,580,098 rows sorted by collection

View and edit SQL

Suggested facets: create_time (date)

filepath dataset collection ▼ is_update update_name create_time size size_mb sample_type spectra_ms1 spectra_ms2 instrument_vendor instrument_model file_processed
MSV000068059/68059/89_ISM3.raw/_FUNC001.DAT MSV000068059 68059 0   2013-06-08 00:00:00 16129476 15 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC001.IDX MSV000068059 68059 0   2013-06-08 00:00:00 48136 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC001.STS MSV000068059 68059 0   2013-06-08 00:00:00 125852 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC002.DAT MSV000068059 68059 0   2013-06-08 00:00:00 955026 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC002.IDX MSV000068059 68059 0   2013-06-08 00:00:00 2156 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC002.STS MSV000068059 68059 0   2013-06-08 00:00:00 6722 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC003.DAT MSV000068059 68059 0   2013-06-08 00:00:00 1086750 1 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC003.IDX MSV000068059 68059 0   2013-06-08 00:00:00 2112 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC003.STS MSV000068059 68059 0   2013-06-08 00:00:00 6608 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC004.DAT MSV000068059 68059 0   2013-06-08 00:00:00 729924 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC004.IDX MSV000068059 68059 0   2013-06-08 00:00:00 2046 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC004.STS MSV000068059 68059 0   2013-06-08 00:00:00 6437 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC005.DAT MSV000068059 68059 0   2013-06-08 00:00:00 538848 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC005.IDX MSV000068059 68059 0   2013-06-08 00:00:00 1408 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNC005.STS MSV000068059 68059 0   2013-06-08 00:00:00 4784 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_FUNCTNS.INF MSV000068059 68059 0   2013-06-08 00:00:00 2080 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_HEADER.TXT MSV000068059 68059 0   2013-06-08 00:00:00 1931 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_INLET.INF MSV000068059 68059 0   2013-06-08 00:00:00 3535 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_auto.txt MSV000068059 68059 0   2013-06-08 00:00:00 1866 0 DEFAULT 0 0     No
MSV000068059/68059/89_ISM3.raw/_extern.inf MSV000068059 68059 0   2013-06-08 00:00:00 9313 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC001.DAT MSV000068066 68066 0   2013-06-08 00:00:00 41180442 39 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC001.IDX MSV000068066 68066 0   2013-06-08 00:00:00 54252 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC001.STS MSV000068066 68066 0   2013-06-08 00:00:00 141698 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC002.DAT MSV000068066 68066 0   2013-06-08 00:00:00 202134 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC002.IDX MSV000068066 68066 0   2013-06-08 00:00:00 1232 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC002.STS MSV000068066 68066 0   2013-06-08 00:00:00 4328 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC003.DAT MSV000068066 68066 0   2013-06-08 00:00:00 10548 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC003.IDX MSV000068066 68066 0   2013-06-08 00:00:00 110 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC003.STS MSV000068066 68066 0   2013-06-08 00:00:00 1421 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC004.DAT MSV000068066 68066 0   2013-06-08 00:00:00 7356 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC004.IDX MSV000068066 68066 0   2013-06-08 00:00:00 66 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC004.STS MSV000068066 68066 0   2013-06-08 00:00:00 1307 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC005.DAT MSV000068066 68066 0   2013-06-08 00:00:00 1440 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC005.IDX MSV000068066 68066 0   2013-06-08 00:00:00 22 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNC005.STS MSV000068066 68066 0   2013-06-08 00:00:00 1193 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_FUNCTNS.INF MSV000068066 68066 0   2013-06-08 00:00:00 2080 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_HEADER.TXT MSV000068066 68066 0   2013-06-08 00:00:00 1922 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_INLET.INF MSV000068066 68066 0   2013-06-08 00:00:00 3395 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_auto.txt MSV000068066 68066 0   2013-06-08 00:00:00 272 0 DEFAULT 0 0     No
MSV000068066/68066/SRM2_8.raw/_extern.inf MSV000068066 68066 0   2013-06-08 00:00:00 9195 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC001.DAT MSV000068075 68075 0   2013-06-08 00:00:00 193974318 184 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC001.IDX MSV000068075 68075 0   2013-06-08 00:00:00 44418 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC001.STS MSV000068075 68075 0   2013-06-08 00:00:00 116219 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC002.DAT MSV000068075 68075 0   2013-06-08 00:00:00 1206570 1 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC002.IDX MSV000068075 68075 0   2013-06-08 00:00:00 4158 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC002.STS MSV000068075 68075 0   2013-06-08 00:00:00 11909 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC003.DAT MSV000068075 68075 0   2013-06-08 00:00:00 1367322 1 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC003.IDX MSV000068075 68075 0   2013-06-08 00:00:00 3146 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC003.STS MSV000068075 68075 0   2013-06-08 00:00:00 9287 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC004.DAT MSV000068075 68075 0   2013-06-08 00:00:00 465576 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC004.IDX MSV000068075 68075 0   2013-06-08 00:00:00 1936 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC004.STS MSV000068075 68075 0   2013-06-08 00:00:00 6152 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC005.DAT MSV000068075 68075 0   2013-06-08 00:00:00 366714 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC005.IDX MSV000068075 68075 0   2013-06-08 00:00:00 1474 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNC005.STS MSV000068075 68075 0   2013-06-08 00:00:00 4955 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_FUNCTNS.INF MSV000068075 68075 0   2013-06-08 00:00:00 2080 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_HEADER.TXT MSV000068075 68075 0   2013-06-08 00:00:00 1944 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_INLET.INF MSV000068075 68075 0   2013-06-08 00:00:00 3535 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_auto.txt MSV000068075 68075 0   2013-06-08 00:00:00 2693 0 DEFAULT 0 0     No
MSV000068075/68075/83_COPIGTPves2v2.raw/_extern.inf MSV000068075 68075 0   2013-06-08 00:00:00 9288 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC001.DAT MSV000068079 68079 0   2013-06-08 00:00:00 43219680 41 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC001.IDX MSV000068079 68079 0   2013-06-08 00:00:00 49566 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC001.STS MSV000068079 68079 0   2013-06-08 00:00:00 129557 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC002.DAT MSV000068079 68079 0   2013-06-08 00:00:00 593592 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC002.IDX MSV000068079 68079 0   2013-06-08 00:00:00 2332 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC002.STS MSV000068079 68079 0   2013-06-08 00:00:00 7178 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC003.DAT MSV000068079 68079 0   2013-06-08 00:00:00 368562 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC003.IDX MSV000068079 68079 0   2013-06-08 00:00:00 1650 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC003.STS MSV000068079 68079 0   2013-06-08 00:00:00 5411 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC004.DAT MSV000068079 68079 0   2013-06-08 00:00:00 118104 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC004.IDX MSV000068079 68079 0   2013-06-08 00:00:00 594 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC004.STS MSV000068079 68079 0   2013-06-08 00:00:00 2675 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC005.DAT MSV000068079 68079 0   2013-06-08 00:00:00 11754 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC005.IDX MSV000068079 68079 0   2013-06-08 00:00:00 132 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNC005.STS MSV000068079 68079 0   2013-06-08 00:00:00 1478 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_FUNCTNS.INF MSV000068079 68079 0   2013-06-08 00:00:00 2080 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_HEADER.TXT MSV000068079 68079 0   2013-06-08 00:00:00 1918 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_INLET.INF MSV000068079 68079 0   2013-06-08 00:00:00 3395 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_auto.txt MSV000068079 68079 0   2013-06-08 00:00:00 1142 0 DEFAULT 0 0     No
MSV000068079/68079/RM2_5.raw/_extern.inf MSV000068079 68079 0   2013-06-08 00:00:00 9195 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC001.DAT MSV000068082 68082 0   2013-06-08 00:00:00 39836706 37 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC001.IDX MSV000068082 68082 0   2013-06-08 00:00:00 52624 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC001.STS MSV000068082 68082 0   2013-06-08 00:00:00 137480 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC002.DAT MSV000068082 68082 0   2013-06-08 00:00:00 3068136 2 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC002.IDX MSV000068082 68082 0   2013-06-08 00:00:00 4620 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC002.STS MSV000068082 68082 0   2013-06-08 00:00:00 13106 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC003.DAT MSV000068082 68082 0   2013-06-08 00:00:00 2211282 2 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC003.IDX MSV000068082 68082 0   2013-06-08 00:00:00 4202 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC003.STS MSV000068082 68082 0   2013-06-08 00:00:00 12023 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC004.DAT MSV000068082 68082 0   2013-06-08 00:00:00 1479606 1 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC004.IDX MSV000068082 68082 0   2013-06-08 00:00:00 3652 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC004.STS MSV000068082 68082 0   2013-06-08 00:00:00 10598 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC005.DAT MSV000068082 68082 0   2013-06-08 00:00:00 1241166 1 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC005.IDX MSV000068082 68082 0   2013-06-08 00:00:00 2860 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNC005.STS MSV000068082 68082 0   2013-06-08 00:00:00 8546 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_FUNCTNS.INF MSV000068082 68082 0   2013-06-08 00:00:00 2080 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_HEADER.TXT MSV000068082 68082 0   2013-06-08 00:00:00 1919 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_INLET.INF MSV000068082 68082 0   2013-06-08 00:00:00 3395 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_auto.txt MSV000068082 68082 0   2013-06-08 00:00:00 3335 0 DEFAULT 0 0     No
MSV000068082/68082/SM2_61.raw/_extern.inf MSV000068082 68082 0   2013-06-08 00:00:00 9195 0 DEFAULT 0 0     No

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "filename" ("filepath" TEXT NOT NULL PRIMARY KEY, "dataset" TEXT NOT NULL, "collection" TEXT NOT NULL, "is_update" INTEGER NOT NULL, "update_name" TEXT NOT NULL, "create_time" DATETIME NOT NULL, "size" INTEGER NOT NULL, "size_mb" INTEGER NOT NULL, "sample_type" TEXT NOT NULL, "spectra_ms1" INTEGER NOT NULL, "spectra_ms2" INTEGER NOT NULL, "instrument_vendor" TEXT NOT NULL, "instrument_model" TEXT NOT NULL, "file_processed" TEXT NOT NULL);
CREATE INDEX "filename_collection" ON "filename" ("collection");
CREATE INDEX "filename_dataset" ON "filename" ("dataset");
CREATE INDEX "filename_instrument_model" ON "filename" ("instrument_model");
CREATE INDEX "filename_instrument_vendor" ON "filename" ("instrument_vendor");
CREATE INDEX "filename_update_name" ON "filename" ("update_name");