consensus_index

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

12 rows where inventory_id = 49724

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
139576 139576 49724 49724 19130 12 0.205971611438565
139577 139577 49724 49724 19131 1 0.068657203812855
139578 139578 49724 49724 19135 1 0.0343286019064275
139579 139579 49724 49724 19136 1 0.041194322287713
139580 139580 49724 49724 22057 1 0.029424515919795
139581 139581 49724 49724 32106 1 0.102985805719283
139582 139582 49724 49724 49659 1 0.102985805719283
139583 139583 49724 49724 128572 4 0.17320078970272
139584 139584 49724 49724 169470 1 0.0514929028596413
139585 139585 49724 49724 171486 2 0.072821961590065
139586 139586 49724 49724 177156 2 0.0840875582538813
139587 139587 49724 49724 211715 1 0.0257464514298206 
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)
);