consensus_index

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

11 rows where inventory_id = 59509

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166092 166092 59509 59509 3523 12 0.300230883401551
166093 166093 59509 59509 53462 2 0.106147646787432
166094 166094 59509 59509 124473 1 0.0600461766803102
166095 166095 59509 59509 129720 1 0.10007696113385
166096 166096 59509 59509 149674 1 0.0375288604251939
166097 166097 59509 59509 159065 1 0.0333589870446168
166098 166098 59509 59509 184950 2 0.122568744893139
166099 166099 59509 59509 200963 1 0.0600461766803102
166100 166100 59509 59509 233383 1 0.0750577208503878
166101 166101 59509 59509 241463 1 0.0500384805669252
166102 166102 59509 59509 309920 1 0.0428901262002216 
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)
);