consensus_index

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

12 rows where inchi_id = 46285

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
179519 179519 64083 64083 46285 1 0.175438596491228
318058 318058 107171 107171 46285 1 0.105214014881345
469269 469269 169735 169735 46285 1 0.105214014881345
484886 484886 179233 179233 46285 4 0.392156862745098
528102 528102 209861 209861 46285 1 0.105214014881345
576508 576508 225976 225976 46285 1 0.136363636363636
687012 687012 245014 245014 46285 1 0.105334917167262
771053 771053 269783 269783 46285 1 0.136363636363636
771064 771064 269785 269785 46285 1 0.105214014881345
805009 805009 280531 280531 46285 4 0.392156862745098
805015 805015 280532 280532 46285 5 0.393559928443649
922653 922653 327483 327483 46285 4 0.392156862745098 
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)
);