consensus_index

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

20 rows where inchi_id = 1231

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58336 58336 18400 18400 1231 1 0.0699133591088548
65212 65212 21351 21351 1231 1 0.310344827586207
120089 120089 41802 41802 1231 1 0.0731586439313742
131431 131431 46665 46665 1231 1 0.0728160452177269
241105 241105 81946 81946 1231 1 0.22369649472762
282002 282002 95650 95650 1231 1 0.113636363636364
341739 341739 115328 115328 1231 1 0.0657636713363449
374163 374163 127585 127585 1231 1 0.307692307692308
439119 439119 157378 157378 1231 1 0.22369649472762
462471 462471 166129 166129 1231 7 0.888888888888889
478846 478846 174926 174926 1231 1 0.0699133591088548
551420 551420 217895 217895 1231 1 0.22369649472762
566067 566067 222270 222270 1231 2 0.0861730080048681
697132 697132 248519 248519 1231 1 0.0738162363993571
714683 714683 252965 252965 1231 1 0.225522689665529
805319 805319 280604 280604 1231 1 0.18856886307411
927514 927514 329896 329896 1231 1 0.0699133591088548
1690001 1690001 514382 514382 1231 1 0.310344827586207
1752568 1752568 536910 536910 1231 1 0.0699133591088548
1757761 1757761 539005 539005 1231 2 0.275868957849537 
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)
);