consensus_index

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

11 rows where inventory_id = 499941

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1650734 1650734 499941 499941 27338 2 0.050134016255575
1650735 1650735 499941 499941 36281 1 0.0752010243833625
1650736 1650736 499941 499941 54637 1 0.0752010243833625
1650737 1650737 499941 499941 56959 2 0.150402048766725
1650738 1650738 499941 499941 67271 8 0.30080409753345
1650739 1650739 499941 499941 186021 1 0.04297201393335
1650740 1650740 499941 499941 188267 2 0.10026803251115
1650741 1650741 499941 499941 197596 1 0.0334226775037166
1650742 1650742 499941 499941 217094 1 0.06016081950669
1650743 1650743 499941 499941 243099 1 0.06016081950669
1650744 1650744 499941 499941 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)
);