consensus_index

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

11 rows where inventory_id = 9332

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31752 31752 9332 9332 83250 3 0.140959094100346
31753 31753 9332 9332 183672 2 0.175333864848636
31754 31754 9332 9332 229220 1 0.151843581102627
31755 31755 9332 9332 229468 5 0.129110015734033
31756 31756 9332 9332 230566 1 0.0337430180228059
31757 31757 9332 9332 248174 2 0.0573914791112881
31758 31758 9332 9332 288680 2 0.0876669324243182
31759 31759 9332 9332 294507 1 0.0303687162205253
31760 31760 9332 9332 308808 1 0.0253072635171044
31761 31761 9332 9332 309376 1 0.0276079238368412
31762 31762 9332 9332 320446 1 0.0759217905513133 
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)
);