consensus_index

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

13 rows where inchi_id = 45999

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
40235 40235 12184 12184 45999 7 0.620689655172414
62024 62024 19940 19940 45999 1 0.243864228693887
151839 151839 54605 54605 45999 1 0.243864228693887
175804 175804 62722 62722 45999 7 0.620689655172414
281830 281830 95589 95589 45999 6 0.615384615384615
359830 359830 122162 122162 45999 1 0.25
454755 454755 163378 163378 45999 4 0.6
707315 707315 251255 251255 45999 7 0.620689655172414
804766 804766 280464 280464 45999 7 0.620689655172414
804768 804768 280465 280465 45999 4 0.6
920160 920160 326456 326456 45999 4 0.6
1646207 1646207 498423 498423 45999 8 0.625
1736267 1736267 531896 531896 45999 7 0.620689655172414 
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)
);