consensus_index

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

10 rows where inchi_id = 189810

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
64097 64097 20779 20779 189810 4 0.473684210526316
89328 89328 31922 31922 189810 4 0.473684210526316
193189 193189 68707 68707 189810 4 0.473684210526316
369178 369178 125596 125596 189810 4 0.466666666666667
488758 488758 182456 182456 189810 4 0.466666666666667
496524 496524 189767 189767 189810 2 0.153125205892123
550425 550425 217585 217585 189810 4 0.466666666666667
818417 818417 284133 284133 189810 4 0.473684210526316
818419 818419 284134 284134 189810 2 0.454545454545455
1686240 1686240 512861 512861 189810 4 0.473684210526316 
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)
);