consensus_index

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

10 rows where inventory_id = 99999

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
295383 295383 99999 99999 13296 3 0.0830161388666025
295384 295384 99999 99999 24277 2 0.0733055569613391
295385 295385 99999 99999 61362 1 0.0315456890328584
295386 295386 99999 99999 73208 6 0.283911201295725
295387 295387 99999 99999 149550 1 0.0946370670985752
295388 295388 99999 99999 168916 2 0.0536541737895777
295389 295389 99999 99999 190281 1 0.0473185335492876
295390 295390 99999 99999 209755 1 0.0946370670985752
295391 295391 99999 99999 209757 2 0.141955600647863
295392 295392 99999 99999 209758 1 0.0354889001619657 
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)
);