consensus_index

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

9 rows where inventory_id = 249824

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
701342 701342 249824 249824 37947 6 0.274710014951453
701343 701343 249824 249824 167645 2 0.233281180219028
701344 701344 249824 249824 170632 1 0.0366566009902391
701345 701345 249824 249824 173147 1 0.0549849014853586
701346 701346 249824 249824 173644 1 0.041238676114019
701347 701347 249824 249824 174088 2 0.116640590109514
701348 701348 249824 249824 175285 1 0.109969802970717
701349 701349 249824 249824 175287 1 0.0659818817824304
701350 701350 249824 249824 238512 1 0.0471299155588788 
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)
);