consensus_index

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

11 rows where inventory_id = 8790

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30254 30254 8790 8790 55432 5 0.267510366412728
30255 30255 8790 8790 138165 2 0.136047085353203
30256 30256 8790 8790 157915 2 0.16662297005411
30257 30257 8790 8790 162236 1 0.037027326678691
30258 30258 8790 8790 197778 1 0.0416557425135274
30259 30259 8790 8790 203716 2 0.0745160575307802
30260 30260 8790 8790 205496 2 0.0563288448306932
30261 30261 8790 8790 208896 2 0.078546821351136
30262 30262 8790 8790 227596 1 0.0333245940108219
30263 30263 8790 8790 247954 2 0.0629775630677338
30264 30264 8790 8790 297931 1 0.0302950854643836 
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)
);