consensus_index

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

12 rows where inventory_id = 16705

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
53650 53650 16705 16705 17909 8 0.252951464045076
53651 53651 16705 16705 46336 1 0.100270560264253
53652 53652 16705 16705 138072 1 0.0334235200880843
53653 53653 16705 16705 157358 1 0.0250676400660632
53654 53654 16705 16705 222493 1 0.0601623361585518
53655 53655 16705 16705 226562 3 0.104285585167012
53656 53656 16705 16705 240129 3 0.208571170334024
53657 53657 16705 16705 261968 1 0.0376014600990949
53658 53658 16705 16705 264584 3 0.0656958019762614
53659 53659 16705 16705 289998 1 0.0429730972561084
53660 53660 16705 16705 294484 1 0.0300811680792759
53661 53661 16705 16705 308145 1 0.0273465164357054 
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)
);