consensus_index

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

9 rows where inventory_id = 14099

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
46297 46297 14099 14099 73485 1 0.0622215038113827
46298 46298 14099 14099 75859 3 0.162633931559435
46299 46299 14099 14099 120116 1 0.103702506352304
46300 46300 14099 14099 133445 7 0.227295139623258
46301 46301 14099 14099 215204 1 0.0518512531761522
46302 46302 14099 14099 220270 2 0.155553759528457
46303 46303 14099 14099 231070 1 0.0777768797642284
46304 46304 14099 14099 248201 1 0.103702506352304
46305 46305 14099 14099 334415 1 0.0388884398821142 
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)
);