consensus_index

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

10 rows where inventory_id = 231637

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
594631 594631 231637 231637 1531 12 0.284527873449799
594632 594632 231637 231637 1860 1 0.0474213122416332
594633 594633 231637 231637 6593 2 0.0580790089625995
594634 594634 231637 231637 48021 1 0.0948426244832664
594635 594635 231637 231637 56566 1 0.0948426244832664
594636 594636 231637 231637 72626 1 0.0569055746899599
594637 594637 231637 231637 129517 2 0.0821361221640967
594638 594638 231637 231637 184227 3 0.1422639367249
594639 594639 231637 231637 200635 1 0.0711319683624498
594640 594640 231637 231637 202666 1 0.0569055746899599 
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)
);