consensus_index

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

13 rows where inchi_id = 47638

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
62076 62076 19967 19967 47638 8 0.625
147182 147182 52949 52949 47638 4 0.6
147184 147184 52950 52950 47638 1 0.599254417849115
232819 232819 79620 79620 47638 1 0.0331265117257335
340385 340385 114817 114817 47638 1 0.19047619047619
360096 360096 122261 122261 47638 6 0.473684210526316
436264 436264 156535 156535 47638 1 0.0331265117257335
478349 478349 174602 174602 47638 1 0.19047619047619
494430 494430 187351 187351 47638 3 0.645027620562502
538926 538926 213705 213705 47638 1 0.599254417849115
842742 842742 292054 292054 47638 1 0.599254417849115
914202 914202 323320 323320 47638 1 0.599254417849115
1682349 1682349 511364 511364 47638 6 0.615384615384615 
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)
);