consensus_index

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

12 rows where inventory_id = 50522

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
141701 141701 50522 50522 2632 2 0.169151075645042
141702 141702 50522 50522 3162 1 0.0398692908778693
141703 141703 50522 50522 3530 7 0.216663361353044
141704 141704 50522 50522 25347 1 0.059803936316804
141705 141705 50522 50522 124017 2 0.239215745267216
141706 141706 50522 50522 195026 1 0.0797385817557387
141707 141707 50522 50522 196514 1 0.029901968158402
141708 141708 50522 50522 196515 1 0.0265795272519129
141709 141709 50522 50522 196516 1 0.0239215745267216
141710 141710 50522 50522 216851 1 0.0341736778953166
141711 141711 50522 50522 253960 1 0.0217468859333833
141712 141712 50522 50522 309710 1 0.0478431490534432 
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)
);