consensus_index

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

11 rows where inventory_id = 79972

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
234027 234027 79972 79972 146 2 0.075305693873866
234028 234028 79972 79972 34921 1 0.041665385464011
234029 234029 79972 79972 40664 2 0.0348597625078719
234030 234030 79972 79972 43676 10 0.22103520249245
234031 234031 79972 79972 47712 1 0.0486096163746795
234032 234032 79972 79972 49388 1 0.0486096163746795
234033 234033 79972 79972 62774 2 0.0293127015850778
234034 234034 79972 79972 129129 1 0.291657698248077
234035 234035 79972 79972 136255 3 0.0883295349241005
234036 234036 79972 79972 231208 4 0.0741004138656224
234037 234037 79972 79972 263573 1 0.0364572122810096 
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)
);