consensus_index

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

8 rows where inventory_id = 78876

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
230151 230151 78876 78876 16223 2 0.180071120526595
230152 230152 78876 78876 18131 1 0.120047413684396
230153 230153 78876 78876 27936 8 0.360142241053189
230154 230154 78876 78876 44935 1 0.0900355602632973
230155 230155 78876 78876 130244 1 0.0450177801316486
230156 230156 78876 78876 207910 1 0.0720284482106378
230157 230157 78876 78876 223513 1 0.0600237068421982
230158 230158 78876 78876 323016 1 0.051448891579027 
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)
);