consensus_index

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

10 rows where inventory_id = 80109

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
234625 234625 80109 80109 44299 8 0.32615729755382
234626 234626 80109 80109 62852 1 0.0465938996505458
234627 234627 80109 80109 136318 1 0.0652314595107641
234628 234628 80109 80109 138281 1 0.0362396997282022
234629 234629 80109 80109 159528 4 0.108719099184607
234630 234630 80109 80109 195682 4 0.0815393243884551
234631 234631 80109 80109 195692 1 0.0652314595107641
234632 234632 80109 80109 200698 1 0.0543595495923034
234633 234633 80109 80109 231372 4 0.16307864877691
234634 234634 80109 80109 250889 1 0.0407696621942275 
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)
);