consensus_index

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

12 rows where inventory_id = 156355

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
435640 435640 156355 156355 31616 3 0.216597668723488
435641 435641 156355 156355 83486 1 0.0312570333805022
435642 435642 156355 156355 101942 8 0.274834681352298
435643 435643 156355 156355 184985 4 0.10388315481523
435644 435644 156355 156355 201630 1 0.0687654734371049
435645 435645 156355 156355 218406 1 0.0286522805987937
435646 435646 156355 156355 230862 2 0.041095230593226
435647 435647 156355 156355 231044 2 0.0573045611975874
435648 435648 156355 156355 277974 1 0.0382030407983916
435649 435649 156355 156355 295378 2 0.0459458645787412
435650 435650 156355 156355 296509 1 0.0429784208981906
435651 435651 156355 156355 297396 1 0.0382030407983916 
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)
);