consensus_index

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

11 rows where inventory_id = 42451

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
122168 122168 42451 42451 16458 1 0.0265053823784939
122169 122169 42451 42451 19157 1 0.0291559206163433
122170 122170 42451 42451 75493 8 0.24517109129705
122171 122171 42451 42451 75990 2 0.291559206163433
122172 122172 42451 42451 140554 2 0.0971864020544778
122173 122173 42451 42451 149199 2 0.0651946204447312
122174 122174 42451 42451 149200 1 0.0416513151662048
122175 122175 42451 42451 149226 1 0.0728898015408583
122176 122176 42451 42451 149289 1 0.0364449007704292
122177 122177 42451 42451 149321 1 0.0323954673514926
122178 122178 42451 42451 188298 1 0.0485932010272389 
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)
);