consensus_index

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

10 rows where inventory_id = 228784

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
585894 585894 228784 228784 7323 7 0.232961176431247
585895 585895 228784 228784 139375 3 0.225397341359543
585896 585896 228784 228784 149681 1 0.0354978568711535
585897 585897 228784 228784 218538 3 0.0781408939201488
585898 585898 228784 228784 226980 1 0.0567965709938456
585899 585899 228784 228784 227386 1 0.070995713742307
585900 585900 228784 228784 236069 1 0.0946609516564094
585901 585901 228784 228784 247184 1 0.0946609516564094
585902 585902 228784 228784 295355 1 0.0567965709938456
585903 585903 228784 228784 309692 1 0.0405689792813183 
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)
);