consensus_index

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

18 rows where inventory_id = 73835

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
209341 209341 73835 73835 4179 2 0.0972449695778305
209342 209342 73835 73835 13899 1 0.0250045736090049
209343 209343 73835 73835 37045 1 0.0196464506927896
209344 209344 73835 73835 39693 1 0.0275050309699054
209345 209345 73835 73835 50396 8 0.275050309699054
209346 209346 73835 73835 155149 1 0.0152805727610585
209347 209347 73835 73835 169822 1 0.0550100619398108
209348 209348 73835 73835 182791 1 0.0183366873132703
209349 209349 73835 73835 204864 1 0.0161794299822973
209350 209350 73835 73835 205328 1 0.0305611455221171
209351 209351 73835 73835 208099 1 0.137525154849527
209352 209352 73835 73835 208100 1 0.0458417182831756
209353 209353 73835 73835 218140 1 0.0171906443561909
209354 209354 73835 73835 232897 1 0.0392929013855791
209355 209355 73835 73835 254152 1 0.0916834365663513
209356 209356 73835 73835 258801 1 0.0343812887123817
209357 209357 73835 73835 322972 1 0.0229208591415878
209358 209358 73835 73835 322973 1 0.0211577161306964 
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)
);