home

masst_records

Custom SQL query

Tables

dataset_table

Dataset, dataset_id_int, title

4,990 rows

libmasst_table

spectrum_id_int, spectrum_id_int_masst

0 rows

library_table

scan, spectrum_id, collision_energy, Adduct, Compound_Source, Compound_Name, Precursor_MZ, ExactMass, Charge, Ion_Mode, Smiles, INCHI, InChIKey_smiles, msManufacturer, msMassAnalyzer, msIonisation, msDissociationMethod, GNPS_library_membership, ppmBetweenExpAndThMass, classyfire_kingdom, classyfire_superclass, classyfire_class, classyfire_subclass, classyfire_direct_parent, np_classifier_nplikeness, falcon_cluster, spectrum_id_int, representative_spectrum_int, InChIKey_smiles_firstBlock, fp_pattern, fp_popcnt, fp_morgan, fp_morgan_popcnt

1,565,620 rows

masst_table

cosine, matching_peaks, spectrum_id_int, mri_id_int, scan_id, dataset_id_int, annotation_rank

1,204,350,873 rows

mri_table

mri, mri_id_int

920,790 rows

redu_table

ATTRIBUTE_DatasetAccession, filename, SampleType, SampleTypeSub1, NCBITaxonomy, YearOfAnalysis, SampleCollectionMethod, SampleExtractionMethod, InternalStandardsUsed, MassSpectrometer, IonizationSourceAndPolarity, ChromatographyAndPhase, SubjectIdentifierAsRecorded, AgeInYears, BiologicalSex, UBERONBodyPartName, TermsofPosition, HealthStatus, DOIDCommonName, ComorbidityListDOIDIndex, SampleCollectionDateandTime, Country, HumanPopulationDensity, LatitudeandLongitude, DepthorAltitudeMeters, qiita_sample_name, UniqueSubjectID, LifeStage, UBERONOntologyIndex, DOIDOntologyIndex, NCBIRank, NCBIDivision, ENVOEnvironmentBiome, ENVOEnvironmentMaterial, ENVOBroadScale, ENVOLocalScale, ENVOMediumScale, ENVOEnvironmentBiomeIndex, ENVOEnvironmentMaterialIndex, ENVOLocalScaleIndex, ENVOBroadScaleIndex, ENVOMediumScaleIndex, DataSource, USI, NCBISuperkingdom, NCBIKingdom, NCBIPhylum, NCBIClass, NCBIOrder, NCBIFamily, NCBIGenus, NCBISpecies, OpenTreeOfLifeTaxonomyID, classification, MS2spectra_count, mri_id_int

412,159 rows

... and 2 hidden tables

Download SQLite DB: masst_records.db 131.6 GB

Powered by Datasette · Queries took 13.045ms