consensus_index

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

12 rows where inventory_id = 78970

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
230516 230516 78970 78970 31616 3 0.216597668723488
230517 230517 78970 78970 83486 1 0.0312570333805022
230518 230518 78970 78970 101942 8 0.274834681352298
230519 230519 78970 78970 184985 4 0.10388315481523
230520 230520 78970 78970 201630 1 0.0687654734371049
230521 230521 78970 78970 218406 1 0.0286522805987937
230522 230522 78970 78970 230862 2 0.041095230593226
230523 230523 78970 78970 231044 2 0.0573045611975874
230524 230524 78970 78970 277974 1 0.0382030407983916
230525 230525 78970 78970 295378 2 0.0459458645787412
230526 230526 78970 78970 296509 1 0.0429784208981906
230527 230527 78970 78970 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)
);