consensus_index

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

17 rows where inventory_id = 240142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
670693 670693 240142 240142 1605 7 0.204332308940239
670694 670694 240142 240142 12673 1 0.225601159605675
670695 670695 240142 240142 30468 2 0.112800579802838
670696 670696 240142 240142 49389 1 0.0205091963277887
670697 670697 240142 240142 83484 1 0.0282001449507094
670698 670698 240142 240142 115990 1 0.0282001449507094
670699 670699 240142 240142 136286 2 0.0651254451139142
670700 670700 240142 240142 136425 2 0.0651254451139142
670701 670701 240142 240142 169037 2 0.0284230744668765
670702 670702 240142 240142 198519 1 0.0173539353542827
670703 670703 240142 240142 203736 1 0.0451202319211351
670704 670704 240142 240142 211522 1 0.0188000966338063
670705 670705 240142 240142 214952 1 0.0161143685432625
670706 670706 240142 240142 231788 2 0.0319048219601443
670707 670707 240142 240142 242013 1 0.032228737086525
670708 670708 240142 240142 260074 2 0.0376001932676125
670709 670709 240142 240142 260354 1 0.015040077307045 
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)
);