consensus_index

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

23 rows where inventory_id = 214158

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
540509 540509 214158 214158 15740 2 0.0455204183288993
540510 540510 214158 214158 41139 1 0.0446007191135353
540511 540511 214158 214158 52262 1 0.0171541227359751
540512 540512 214158 214158 65005 1 0.0139377247229798
540513 540513 214158 214158 66167 1 0.0131178585628045
540514 540514 214158 214158 67204 1 0.0123890886426487
540515 540515 214158 214158 74053 12 0.223003595567677
540516 540516 214158 214158 80608 1 0.0117370313456672
540517 540517 214158 214158 88275 1 0.0111501797783838
540518 540518 214158 214158 149161 1 0.0446007191135353
540519 540519 214158 214158 149304 1 0.111501797783838
540520 540520 214158 214158 187800 1 0.018583632963973
540521 540521 214158 214158 187958 1 0.0278754494459596
540522 540522 214158 214158 192227 1 0.015928828254834
540523 540523 214158 214158 203379 2 0.0643755929656263
540524 540524 214158 214158 205505 1 0.0743345318558922
540525 540525 214158 214158 208033 1 0.0557508988919191
540526 540526 214158 214158 208110 1 0.0743345318558922
540527 540527 214158 214158 210249 1 0.0223003595567677
540528 540528 214158 214158 211245 1 0.0148669063711784
540529 540529 214158 214158 215453 1 0.0247781772852974
540530 540530 214158 214158 244357 1 0.0318576565096681
540531 540531 214158 214158 272877 1 0.0202730541425161 
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)
);