consensus_index

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

11 rows where inventory_id = 3774

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12325 12325 3774 3774 9309 21 0.27006285194334
12326 12326 3774 3774 139143 12 0.165839356794651
12327 12327 3774 3774 170668 3 0.0630053306890414
12328 12328 3774 3774 172022 1 0.041213199655159
12329 12329 3774 3774 183169 2 0.0526712646088877
12330 12330 3774 3774 190629 1 0.0576984795172226
12331 12331 3774 3774 201555 1 0.041213199655159
12332 12332 3774 3774 231844 1 0.0480820662643521
12333 12333 3774 3774 249868 3 0.110080452128394
12334 12334 3774 3774 292118 2 0.0480820662643521
12335 12335 3774 3774 292182 1 0.0961641325287043 
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)
);