consensus_index

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

11 rows where inventory_id = 99181

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
292927 292927 99181 99181 27338 2 0.050134016255575
292928 292928 99181 99181 36281 1 0.0752010243833625
292929 292929 99181 99181 54637 1 0.0752010243833625
292930 292930 99181 99181 56959 2 0.150402048766725
292931 292931 99181 99181 67271 8 0.30080409753345
292932 292932 99181 99181 186021 1 0.04297201393335
292933 292933 99181 99181 188267 2 0.10026803251115
292934 292934 99181 99181 197596 1 0.0334226775037166
292935 292935 99181 99181 217094 1 0.06016081950669
292936 292936 99181 99181 243099 1 0.06016081950669
292937 292937 99181 99181 247369 1 0.0376005121916812 
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)
);