consensus_index

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

11 rows where inventory_id = 400327

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1204151 1204151 400327 400327 3523 8 0.29954568062583
1204152 1204152 400327 400327 53462 2 0.105905391022832
1204153 1204153 400327 400327 124473 1 0.059909136125166
1204154 1204154 400327 400327 129720 1 0.09984856020861
1204155 1204155 400327 400327 149674 1 0.0374432100782287
1204156 1204156 400327 400327 159065 1 0.03328285340287
1204157 1204157 400327 400327 184950 2 0.122289012031329
1204158 1204158 400327 400327 200963 1 0.059909136125166
1204159 1204159 400327 400327 233383 1 0.0748864201564575
1204160 1204160 400327 400327 241463 1 0.049924280104305
1204161 1204161 400327 400327 309920 1 0.0427922400894043 
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)
);