consensus_index

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

10 rows where inventory_id = 98311

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
290262 290262 98311 98311 60138 2 0.115147948506096
290263 290263 98311 98311 94164 2 0.0940179062560695
290264 290264 98311 98311 114896 6 0.32568758091352
290265 290265 98311 98311 228466 2 0.0767652990040642
290266 290266 98311 98311 248619 3 0.16284379045676
290267 290267 98311 98311 248863 1 0.04652679727336
290268 290268 98311 98311 262108 1 0.0651375161827041
290269 290269 98311 98311 264830 1 0.032568758091352
290270 290270 98311 98311 309531 1 0.0361875089903911
290271 290271 98311 98311 334479 1 0.0296079619012291 
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)
);