consensus_index

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

16 rows where inventory_id = 17789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
56652 56652 17789 17789 27174 5 0.241885410577979
56653 56653 17789 17789 54002 1 0.0694633433071768
56654 56654 17789 17789 136409 1 0.0185235582152471
56655 56655 17789 17789 139450 2 0.196472004385576
56656 56656 17789 17789 200103 1 0.0277853373228707
56657 56657 17789 17789 216635 1 0.0463088955381179
56658 56658 17789 17789 217312 2 0.0606325769009223
56659 56659 17789 17789 235026 1 0.0926177910762357
56660 56660 17789 17789 243348 2 0.062129903031701
56661 56661 17789 17789 270294 1 0.0347316716535884
56662 56662 17789 17789 275726 1 0.0308725970254119
56663 56663 17789 17789 294537 1 0.0252593975662461
56664 56664 17789 17789 308806 1 0.0213733364022083
56665 56665 17789 17789 310258 1 0.0231544477690589
56666 56666 17789 17789 320769 1 0.0198466695163362
56667 56667 17789 17789 331472 1 0.0173658358267942 
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)
);