consensus_index

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

10 rows where inventory_id = 111318

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
330203 330203 111318 111318 23352 6 0.252479093599374
330204 330204 111318 111318 23494 1 0.0841596978664579
330205 330205 111318 111318 52219 2 0.051537079169905
330206 330206 111318 111318 114889 2 0.126239546799687
330207 330207 111318 111318 119304 2 0.252479093599374
330208 330208 111318 111318 155791 1 0.0280532326221526
330209 330209 111318 111318 202533 1 0.0631197733998434
330210 330210 111318 111318 202699 1 0.0420798489332289
330211 330211 111318 111318 206351 1 0.0504958187198747
330212 330212 111318 111318 226746 1 0.0360684419427677 
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)
);