consensus_index

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

13 rows where inventory_id = 48017

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135483 135483 48017 48017 3 16 0.26488291084473
135484 135484 48017 48017 3193 1 0.044147151807455
135485 135485 48017 48017 6831 1 0.052976582168946
135486 135486 48017 48017 75665 1 0.0331103638555913
135487 135487 48017 48017 91295 2 0.0447733838210596
135488 135488 48017 48017 144565 1 0.0662207277111825
135489 135489 48017 48017 173743 3 0.132441455422365
135490 135490 48017 48017 178127 3 0.0802206986642131
135491 135491 48017 48017 184140 1 0.08829430361491
135492 135492 48017 48017 184417 1 0.0378404158349614
135493 135493 48017 48017 259673 1 0.044147151807455
135494 135494 48017 48017 264706 1 0.044147151807455
135495 135495 48017 48017 281016 2 0.0592296194726833 
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)
);