consensus_index

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

11 rows where inventory_id = 239285

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
667716 667716 239285 239285 28057 3 0.106843070850338
667717 667717 239285 239285 39001 1 0.0370404238801626
667718 667718 239285 239285 97352 2 0.222242543280976
667719 667719 239285 239285 121031 1 0.111121271640488
667720 667720 239285 239285 138537 5 0.150593972749068
667721 667721 239285 239285 187198 1 0.111121271640488
667722 667722 239285 239285 191088 1 0.027780317910122
667723 667723 239285 239285 198741 1 0.0740808477603252
667724 667724 239285 239285 235126 1 0.0555606358202439
667725 667725 239285 239285 314077 2 0.0702792629756434
667726 667726 239285 239285 318239 1 0.0222242543280976 
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)
);