consensus_index

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

16 rows where inventory_id = 153254

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
423749 423749 153254 153254 3469 1 0.0228992783920985
423750 423750 153254 153254 12679 1 0.0249810309731983
423751 423751 153254 153254 58689 1 0.0343489175881477
423752 423752 153254 153254 61360 8 0.274791340705182
423753 423753 153254 153254 136360 2 0.137395670352591
423754 423754 153254 153254 146435 2 0.0274791340705182
423755 423755 153254 153254 146601 1 0.0457985567841969
423756 423756 153254 153254 170071 1 0.0249810309731983
423757 423757 153254 153254 176464 2 0.0346204547590443
423758 423758 153254 153254 185476 1 0.0343489175881477
423759 423759 153254 153254 189203 2 0.0793254272635574
423760 423760 153254 153254 217810 2 0.0549582681410363
423761 423761 153254 153254 231529 2 0.0793254272635574
423762 423762 153254 153254 234975 1 0.0457985567841969
423763 423763 153254 153254 238734 1 0.0392559058150259
423764 423764 153254 153254 257410 1 0.0305323711894646 
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)
);