consensus_index

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

13 rows where inventory_id = 47852

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135004 135004 47852 47852 13327 16 0.248270544377191
135005 135005 47852 47852 87490 2 0.0419653813808296
135006 135006 47852 47852 87504 1 0.0827568481257304
135007 135007 47852 47852 123692 1 0.0620676360942978
135008 135008 47852 47852 129527 1 0.0496541088754382
135009 135009 47852 47852 129549 1 0.0413784240628652
135010 135010 47852 47852 137370 3 0.124135272188596
135011 135011 47852 47852 148985 1 0.0620676360942978
135012 135012 47852 47852 154924 1 0.0827568481257304
135013 135013 47852 47852 202301 2 0.0506780126572605
135014 135014 47852 47852 204681 1 0.0827568481257304
135015 135015 47852 47852 223602 2 0.0331765470102609
135016 135016 47852 47852 225354 1 0.0310338180471489 
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)
);