consensus_index

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

9 rows where inventory_id = 42991

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
123913 123913 42991 42991 23718 2 0.0995670728618731
123914 123914 42991 42991 45286 1 0.14935060929281
123915 123915 42991 42991 63056 3 0.298701218585619
123916 123916 42991 42991 136811 2 0.0862276144788383
123917 123917 42991 42991 185065 1 0.033189024287291
123918 123918 42991 42991 186242 1 0.0746753046464048
123919 123919 42991 42991 186857 1 0.0597402437171239
123920 123920 42991 42991 203058 1 0.0373376523232024
123921 123921 42991 42991 210340 1 0.0426716026550885 
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)
);