consensus_index

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

12 rows where inventory_id = 258715

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
733606 733606 258715 258715 8125 1 0.0427194651335129
733607 733607 258715 258715 59562 1 0.0640791977002694
733608 733608 258715 258715 79616 1 0.128158395400539
733609 733609 258715 258715 81195 1 0.0427194651335129
733610 733610 258715 258715 83832 13 0.235545830986276
733611 733611 258715 258715 153154 3 0.0978031603451854
733612 733612 258715 258715 170969 2 0.0484393203792728
733613 733613 258715 258715 192124 1 0.0366166844001539
733614 733614 258715 258715 201835 1 0.0512633581602155
733615 733615 258715 258715 202463 1 0.0640791977002694
733616 733616 258715 258715 216526 1 0.128158395400539
733617 733617 258715 258715 224121 1 0.0512633581602155 
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)
);