consensus_index

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

17 rows where inventory_id = 477345

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1582500 1582500 477345 477345 19319 1 0.0579847259764973
1582501 1582501 477345 477345 105684 3 0.231938903905989
1582502 1582502 477345 477345 147618 2 0.115969451952995
1582503 1582503 477345 477345 147619 1 0.0144961814941243
1582504 1582504 477345 477345 169623 1 0.0257709893228877
1582505 1582505 477345 477345 189973 1 0.0193282419921658
1582506 1582506 477345 477345 190442 1 0.0210853549005445
1582507 1582507 477345 477345 193072 1 0.0463877807811978
1582508 1582508 477345 477345 193567 2 0.041001392943225
1582509 1582509 477345 477345 195792 1 0.115969451952995
1582510 1582510 477345 477345 216577 2 0.0773129679686631
1582511 1582511 477345 477345 231646 1 0.0178414541466146
1582512 1582512 477345 477345 237718 1 0.0386564839843315
1582513 1582513 477345 477345 240733 1 0.0165670645647135
1582514 1582514 477345 477345 243322 1 0.033134129129427
1582515 1582515 477345 477345 296001 2 0.03280111435458
1582516 1582516 477345 477345 308220 1 0.0154625935937326 
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)
);