consensus_index

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

9 rows where inventory_id = 153453

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
425096 425096 153453 153453 2522 2 0.0754323390503414
425097 425097 153453 153453 74758 8 0.320032310779555
425098 425098 153453 153453 137013 2 0.160016155389778
425099 425099 153453 153453 158187 2 0.0604804218448599
425100 425100 153453 153453 192259 1 0.0800080776948888
425101 425101 153453 153453 192469 1 0.106677436926518
425102 425102 153453 153453 200901 1 0.064006462155911
425103 425103 153453 153453 234287 1 0.0533387184632592
425104 425104 153453 153453 308089 1 0.064006462155911 
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)
);