consensus_index

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

16 rows where inventory_id = 78159

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
227249 227249 78159 78159 9035 7 0.203475576941722
227250 227250 78159 78159 50416 1 0.0248039506589093
227251 227251 78159 78159 84304 2 0.0343968907441447
227252 227252 78159 78159 101084 1 0.124019753294546
227253 227253 78159 78159 137167 2 0.0249289083800275
227254 227254 78159 78159 139918 4 0.175390417111313
227255 227255 78159 78159 155403 2 0.0354342152270132
227256 227256 78159 78159 174878 1 0.0413399177648488
227257 227257 78159 78159 192039 3 0.0496079013178185
227258 227258 78159 78159 205783 1 0.0206699588824244
227259 227259 78159 78159 218193 4 0.0716028379494373
227260 227260 78159 78159 218232 1 0.0225490460535539
227261 227261 78159 78159 231217 1 0.0413399177648488
227262 227262 78159 78159 239315 3 0.055348606210954
227263 227263 78159 78159 278118 3 0.037559807938247
227264 227264 78159 78159 290066 1 0.0310049383236366 
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)
);