consensus_index

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

10 rows where inventory_id = 240531

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
672242 672242 240531 240531 2302 1 0.036045673538814
672243 672243 240531 240531 2592 1 0.0811027654623315
672244 672244 240531 240531 2595 12 0.324411061849326
672245 672245 240531 240531 2596 2 0.0837625759911936
672246 672246 240531 240531 57816 2 0.162205530924663
672247 672247 240531 240531 65121 1 0.0405513827311657
672248 672248 240531 240531 138170 1 0.0648822123698652
672249 672249 240531 240531 139790 1 0.0463444374070466
672250 672250 240531 240531 170918 1 0.054068510308221
672251 672251 240531 240531 266944 2 0.0936494069434004 
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)
);