consensus_index

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

10 rows where inventory_id = 310320

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
889074 889074 310320 310320 61820 1 0.046640937634974
889075 889075 310320 310320 84396 4 0.326486563444818
889076 889076 310320 310320 147734 1 0.036276284827202
889077 889077 310320 310320 171486 1 0.054414427240803
889078 889078 310320 310320 238413 2 0.0348035846034583
889079 889079 310320 310320 313737 1 0.0652973126889636
889080 889080 310320 310320 313798 2 0.163243281722409
889081 889081 310320 310320 315698 2 0.0942485526458307
889082 889082 310320 310320 316304 1 0.108828854481606
889083 889083 310320 310320 318233 2 0.0516220582963347 
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)
);