uniquemri

2,740,335 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: create_time (date)

Next page

CREATE TABLE "uniquemri" ("usi" TEXT NOT NULL PRIMARY KEY, "filepath" TEXT NOT NULL, "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, "RT_Range_in_Min" REAL NOT NULL, "Top_CEs" TEXT NOT NULL, "Top_CE_Counts" TEXT NOT NULL, "MassAnalyzer" TEXT NOT NULL, "Ionization" TEXT NOT NULL, "top_k_prec_mz_diffs" TEXT NOT NULL, "top_k_prec_mz_diff_counts" TEXT NOT NULL, "conseq_ms2_prec_increase" INTEGER NOT NULL, "conseq_ms2_prec_decrease" INTEGER NOT NULL, "conseq_ms2_prec_equal" INTEGER NOT NULL, "prec_prop_equal" REAL NOT NULL, "prec_prop_increase" REAL NOT NULL, "prec_prop_decrease" REAL NOT NULL, "classification" TEXT NOT NULL);
CREATE INDEX "uniquemri_collection" ON "uniquemri" ("collection");
CREATE INDEX "uniquemri_dataset" ON "uniquemri" ("dataset");
CREATE INDEX "uniquemri_filepath" ON "uniquemri" ("filepath");
CREATE INDEX "uniquemri_instrument_model" ON "uniquemri" ("instrument_model");
CREATE INDEX "uniquemri_instrument_vendor" ON "uniquemri" ("instrument_vendor");
CREATE INDEX "uniquemri_sample_type" ON "uniquemri" ("sample_type");
CREATE INDEX "uniquemri_update_name" ON "uniquemri" ("update_name");