consensus_index

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

10 rows where inventory_id = 31998

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
89586 89586 31998 31998 46097 6 0.256500062526666
89587 89587 31998 31998 57065 1 0.0970266473337954
89588 89588 31998 31998 106356 1 0.0431229543705757
89589 89589 31998 31998 136413 1 0.194053294667591
89590 89590 31998 31998 140820 1 0.129368863111727
89591 89591 31998 31998 149684 1 0.0776213178670363
89592 89592 31998 31998 169069 1 0.0554437984764545
89593 89593 31998 31998 172093 1 0.0352824172122892
89594 89594 31998 31998 237459 1 0.0485133236668977
89595 89595 31998 31998 247645 1 0.0388106589335182 
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)
);