consensus_index

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

12 rows where inchi_id = 84023

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19044 19044 5596 5596 84023 8 0.9
120617 120617 41987 41987 84023 8 0.9
216905 216905 75287 75287 84023 8 0.9
218366 218366 75707 75707 84023 1 0.3125
427874 427874 154246 154246 84023 1 0.3125
732821 732821 258445 258445 84023 2 0.0653452927489518
857735 857735 296698 296698 84023 1 0.304347826086957
857737 857737 296699 296699 84023 1 0.3125
884766 884766 308003 308003 84023 1 0.3
1612415 1612415 486777 486777 84023 8 0.9
1613494 1613494 487113 487113 84023 1 0.3125
1762787 1762787 541516 541516 84023 1 0.0873153575055076 
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)
);