consensus_index

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

11 rows where inventory_id = 12778

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
41998 41998 12778 12778 17168 6 0.145967605123607
41999 41999 12778 12778 83486 1 0.03244334713442
42000 42000 12778 12778 130559 9 0.279092400461782
42001 42001 12778 12778 145660 3 0.0795997332209787
42002 42002 12778 12778 216106 3 0.107125571948489
42003 42003 12778 12778 248146 2 0.112387051208819
42004 42004 12778 12778 253117 2 0.0529797640182106
42005 42005 12778 12778 270968 2 0.0556171665161486
42006 42006 12778 12778 276591 2 0.04866502070163
42007 42007 12778 12778 290028 1 0.038932016561304
42008 42008 12778 12778 296452 1 0.0353927423284582 
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)
);