consensus_index

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

10 rows where inventory_id = 65454

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
183133 183133 65454 65454 15686 4 0.0673587731937008
183134 183134 65454 65454 18253 1 0.177298261889181
183135 183135 65454 65454 27619 1 0.0590994206297271
183136 183136 65454 65454 37178 4 0.095259690595345
183137 183137 65454 65454 94675 4 0.125368803274428
183138 183138 65454 65454 111730 3 0.177298261889181
183139 183139 65454 65454 138641 2 0.0723817123184725
183140 183140 65454 65454 282501 1 0.0354596523778362
183141 183141 65454 65454 314053 2 0.0886491309445906
183142 183142 65454 65454 314644 4 0.095259690595345 
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)
);