consensus_index

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

26 rows where inchi_id = 30714

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16717 16717 4913 4913 30714 2 0.0447990206577125
17799 17799 5214 5214 30714 1 0.0419292305347446
90593 90593 32336 32336 30714 1 0.0663472214469954
182704 182704 65186 65186 30714 2 0.0447990206577125
182715 182715 65187 65187 30714 1 0.0300503026268121
213284 213284 74303 74303 30714 2 0.0447990206577125
215209 215209 74770 74770 30714 1 0.0419292305347446
228816 228816 78595 78595 30714 3 0.204610024893869
334470 334470 112744 112744 30714 1 0.111571578010697
341156 341156 115111 115111 30714 9 0.462909494802967
424467 424467 153328 153328 30714 2 0.0447990206577125
425858 425858 153655 153655 30714 1 0.0419292305347446
537012 537012 213132 213132 30714 1 0.0419292305347446
542605 542605 214688 214688 30714 1 0.02836812332877
724953 724953 256163 256163 30714 2 0.0447990206577125
836084 836084 290071 290071 30714 1 0.0656651322479159
836090 836090 290072 290072 30714 2 0.0447990206577125
836102 836102 290073 290073 30714 1 0.0309597098304488
836119 836119 290074 290074 30714 1 0.0563146083657386
915106 915106 324127 324127 30714 2 0.312957090771134
915290 915290 324240 324240 30714 1 0.139211136890951
916069 916069 324709 324709 30714 1 0.0663472214469954
917863 917863 325343 325343 30714 5 0.430689385188141
1610128 1610128 486053 486053 30714 2 0.0447990206577125
1716454 1716454 525660 525660 30714 2 0.0447990206577125
1717285 1717285 525947 525947 30714 1 0.0419292305347446 
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)
);