consensus_index

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

13 rows where inventory_id = 239752

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
669277 669277 239752 239752 379 2 0.129801558932454
669278 669278 239752 239752 75291 1 0.129801558932454
669279 669279 239752 239752 91483 1 0.043267186310818
669280 669280 239752 239752 108010 1 0.129801558932454
669281 669281 239752 239752 110197 3 0.103023565598245
669282 669282 239752 239752 120942 1 0.043267186310818
669283 669283 239752 239752 229181 1 0.0259603117864908
669284 669284 239752 239752 229661 2 0.129801558932454
669285 669285 239752 239752 229745 3 0.103023565598245
669286 669286 239752 239752 229885 1 0.0324503897331135
669287 669287 239752 239752 230545 1 0.064900779466227
669288 669288 239752 239752 238302 1 0.0259603117864908
669289 669289 239752 239752 296632 1 0.0324503897331135 
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)
);