consensus_index

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

12 rows where inchi_id = 186331

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28573 28573 8283 8283 186331 1 0.0704762696484802
83864 83864 30182 30182 186331 1 0.0860321228610145
178062 178062 63455 63455 186331 1 0.0860321228610145
236655 236655 80655 80655 186331 2 0.0643649850114044
437410 437410 156840 156840 186331 2 0.0643649850114044
707734 707734 251355 251355 186331 1 0.0844754765048328
805496 805496 280659 280659 186331 1 0.0860321228610145
805507 805507 280660 280660 186331 2 0.0643649850114044
828918 828918 287554 287554 186331 1 0.0349960348059979
848615 848615 293563 293563 186331 1 0.0571269151117533
1624483 1624483 490559 490559 186331 1 0.0844754765048328
1725284 1725284 528286 528286 186331 1 0.0860321228610145 
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)
);