consensus_index

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

25 rows where inchi_id = 74125

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15976 15976 4828 4828 74125 1 0.115384615384615
17137 17137 5009 5009 74125 8 0.625
28517 28517 8267 8267 74125 1 0.209677926507497
118722 118722 41389 41389 74125 1 0.115384615384615
122432 122432 42518 42518 74125 8 0.625
161969 161969 58112 58112 74125 8 0.625
162043 162043 58133 58133 74125 4 0.188840783645315
162140 162140 58156 58156 74125 1 0.209677926507497
211705 211705 74116 74116 74125 1 0.0939759036144578
213948 213948 74432 74432 74125 6 0.615384615384615
247938 247938 84376 84376 74125 1 0.070370928964508
510761 510761 205353 205353 74125 4 0.833333333333333
536255 536255 212822 212822 74125 1 0.070370928964508
707551 707551 251309 251309 74125 1 0.209677926507497
718352 718352 254048 254048 74125 1 0.115384615384615
795653 795653 277651 277651 74125 4 0.130558401156409
805183 805183 280563 280563 74125 1 0.209677926507497
808984 808984 281662 281662 74125 4 0.221220270712453
840609 840609 291480 291480 74125 5 0.365473583956233
840612 840612 291481 291481 74125 8 0.625
843456 843456 292248 292248 74125 4 0.218119982921702
853909 853909 295380 295380 74125 4 0.213856933458396
947896 947896 339828 339828 74125 4 0.6
1716723 1716723 525758 525758 74125 8 0.625
1725250 1725250 528275 528275 74125 1 0.209677926507497 
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)
);