consensus_index

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

10 rows where inventory_id = 153038

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421818 421818 153038 153038 46097 9 0.274594154434817
421819 421819 153038 153038 57065 2 0.127954428549291
421820 421820 153038 153038 106356 1 0.0402121973822458
421821 421821 153038 153038 136413 1 0.180954888220106
421822 421822 153038 153038 140820 2 0.120636592146737
421823 421823 153038 153038 149684 1 0.0723819552880424
421824 421824 153038 153038 169069 1 0.051701396634316
421825 421825 153038 153038 172093 1 0.032900888767292
421826 421826 153038 153038 237459 1 0.0452387220550265
421827 421827 153038 153038 247645 1 0.0361909776440212 
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)
);