consensus_index

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

17 rows where inventory_id = 485146

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1605931 1605931 485146 485146 19319 1 0.0579847259764973
1605932 1605932 485146 485146 105684 3 0.231938903905989
1605933 1605933 485146 485146 147618 2 0.115969451952995
1605934 1605934 485146 485146 147619 1 0.0144961814941243
1605935 1605935 485146 485146 169623 1 0.0257709893228877
1605936 1605936 485146 485146 189973 1 0.0193282419921658
1605937 1605937 485146 485146 190442 1 0.0210853549005445
1605938 1605938 485146 485146 193072 1 0.0463877807811978
1605939 1605939 485146 485146 193567 2 0.041001392943225
1605940 1605940 485146 485146 195792 1 0.115969451952995
1605941 1605941 485146 485146 216577 2 0.0773129679686631
1605942 1605942 485146 485146 231646 1 0.0178414541466146
1605943 1605943 485146 485146 237718 1 0.0386564839843315
1605944 1605944 485146 485146 240733 1 0.0165670645647135
1605945 1605945 485146 485146 243322 1 0.033134129129427
1605946 1605946 485146 485146 296001 2 0.03280111435458
1605947 1605947 485146 485146 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)
);