consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

10 rows where inventory_id = 74062

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
211409 211409 74062 74062 55070 7 0.334695344422135
211410 211410 74062 74062 136296 1 0.167347672211067
211411 211411 74062 74062 195366 1 0.0478136206317336
211412 211412 74062 74062 195757 1 0.066939068884427
211413 211413 74062 74062 197903 1 0.0836738361055337
211414 211414 74062 74062 228793 1 0.111565114807378
211415 211415 74062 74062 233264 1 0.0557825574036891
211416 211416 74062 74062 250805 1 0.0418369180527669
211417 211417 74062 74062 264645 1 0.0334695344422135
211418 211418 74062 74062 291898 1 0.0371883716024594 
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);