consensus_index

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

10 rows where inventory_id = 29300

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
81294 81294 29300 29300 3978 2 0.0551759611952922
81295 81295 29300 29300 11419 2 0.0822514666377092
81296 81296 29300 29300 71111 5 0.21481218184017
81297 81297 29300 29300 106084 2 0.246754399913128
81298 81298 29300 29300 140900 2 0.0551759611952922
81299 81299 29300 29300 160792 1 0.0352506285590182
81300 81300 29300 29300 185928 4 0.17448170946619
81301 81301 29300 29300 186367 2 0.0411257333188546
81302 81302 29300 29300 204846 2 0.0538462245554911
81303 81303 29300 29300 223748 1 0.030844299989141 
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)
);