consensus_index

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

17 rows where inventory_id = 477344

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1582483 1582483 477344 477344 19319 1 0.0579847259764973
1582484 1582484 477344 477344 105684 3 0.231938903905989
1582485 1582485 477344 477344 147618 2 0.115969451952995
1582486 1582486 477344 477344 147619 1 0.0144961814941243
1582487 1582487 477344 477344 169623 1 0.0257709893228877
1582488 1582488 477344 477344 189973 1 0.0193282419921658
1582489 1582489 477344 477344 190442 1 0.0210853549005445
1582490 1582490 477344 477344 193072 1 0.0463877807811978
1582491 1582491 477344 477344 193567 2 0.041001392943225
1582492 1582492 477344 477344 195792 1 0.115969451952995
1582493 1582493 477344 477344 216577 2 0.0773129679686631
1582494 1582494 477344 477344 231646 1 0.0178414541466146
1582495 1582495 477344 477344 237718 1 0.0386564839843315
1582496 1582496 477344 477344 240733 1 0.0165670645647135
1582497 1582497 477344 477344 243322 1 0.033134129129427
1582498 1582498 477344 477344 296001 2 0.03280111435458
1582499 1582499 477344 477344 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)
);