consensus_index

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

10 rows where inventory_id = 45622

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
127649 127649 45622 45622 11206 20 0.274129069103369
127650 127650 45622 45622 74051 1 0.0685322672758424
127651 127651 45622 45622 74082 1 0.0685322672758424
127652 127652 45622 45622 161260 1 0.0685322672758424
127653 127653 45622 45622 162276 1 0.0548258138206739
127654 127654 45622 45622 169427 3 0.137064534551685
127655 127655 45622 45622 178154 1 0.0456881781838949
127656 127656 45622 45622 225610 1 0.0913763563677898
127657 127657 45622 45622 246901 1 0.0913763563677898
127658 127658 45622 45622 259644 1 0.0913763563677898 
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)
);