consensus_index

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

13 rows where inventory_id = 528022

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1724301 1724301 528022 528022 4327 2 0.0586686107263044
1724302 1724302 528022 528022 38655 2 0.0908890209152411
1724303 1724303 528022 528022 106246 5 0.287416320394844
1724304 1724304 528022 528022 186681 1 0.0574832640789687
1724305 1724305 528022 528022 195027 2 0.0958054401316145
1724306 1724306 528022 528022 206181 1 0.0718540800987109
1724307 1724307 528022 528022 207106 1 0.0410594743421205
1724308 1724308 528022 528022 215557 2 0.143708160197422
1724309 1724309 528022 528022 243309 1 0.0359270400493555
1724310 1724310 528022 528022 255552 1 0.0319351467105382
1724311 1724311 528022 528022 263104 1 0.0221089477226803
1724312 1724312 528022 528022 309981 1 0.0261287563995312
1724313 1724313 528022 528022 320827 1 0.0239513600329036 
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)
);