consensus_index

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

17 rows where inventory_id = 39543

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
113189 113189 39543 39543 19319 1 0.0579847259764973
113190 113190 39543 39543 105684 3 0.231938903905989
113191 113191 39543 39543 147618 2 0.115969451952995
113192 113192 39543 39543 147619 1 0.0144961814941243
113193 113193 39543 39543 169623 1 0.0257709893228877
113194 113194 39543 39543 189973 1 0.0193282419921658
113195 113195 39543 39543 190442 1 0.0210853549005445
113196 113196 39543 39543 193072 1 0.0463877807811978
113197 113197 39543 39543 193567 2 0.041001392943225
113198 113198 39543 39543 195792 1 0.115969451952995
113199 113199 39543 39543 216577 2 0.0773129679686631
113200 113200 39543 39543 231646 1 0.0178414541466146
113201 113201 39543 39543 237718 1 0.0386564839843315
113202 113202 39543 39543 240733 1 0.0165670645647135
113203 113203 39543 39543 243322 1 0.033134129129427
113204 113204 39543 39543 296001 2 0.03280111435458
113205 113205 39543 39543 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)
);