consensus_index

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

12 rows where inventory_id = 89095

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
263000 263000 89095 89095 21809 5 0.208123675414089
263001 263001 89095 89095 168345 1 0.0398452205973502
263002 263002 89095 89095 173295 1 0.0265634803982335
263003 263003 89095 89095 174604 4 0.239071323584101
263004 263004 89095 89095 175565 1 0.0796904411947005
263005 263005 89095 89095 186303 1 0.0796904411947005
263006 263006 89095 89095 186672 1 0.0597678308960254
263007 263007 89095 89095 187986 1 0.119535661792051
263008 263008 89095 89095 188573 1 0.0239071323584101
263009 263009 89095 89095 192612 1 0.0298839154480127
263010 263010 89095 89095 194730 1 0.0478142647168203
263011 263011 89095 89095 205744 1 0.0341530462263002 
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)
);