consensus_index

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

12 rows where inventory_id = 60001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
168098 168098 60001 60001 13120 6 0.157476002352378
168099 168099 60001 60001 47697 2 0.0420872319601005
168100 168100 60001 60001 124026 9 0.272756437047155
168101 168101 60001 60001 165490 2 0.0431265793770671
168102 168102 60001 60001 170766 2 0.136378218523578
168103 168103 60001 60001 229218 2 0.0642893087494417
168104 168104 60001 60001 232142 1 0.0681891092617888
168105 168105 60001 60001 232143 1 0.054551287409431
168106 168106 60001 60001 232185 1 0.0454594061745259
168107 168107 60001 60001 255542 2 0.0431265793770671
168108 168108 60001 60001 287506 1 0.0247960397315596
168109 168109 60001 60001 329506 1 0.0389652052924507 
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)
);