consensus_index

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

13 rows where inchi_id = 180059

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
35365 35365 10505 10505 180059 1 0.0602982003368017
101106 101106 35728 35728 180059 2 0.0922512657274372
183158 183158 65457 65457 180059 1 0.0380324400138768
183441 183441 65557 65557 180059 1 0.0316838495520119
260792 260792 88333 88333 180059 1 0.0602982003368017
316194 316194 106596 106596 180059 1 0.0637270357285377
447051 447051 160183 160183 180059 1 0.0602982003368017
574056 574056 224935 224935 180059 1 0.0602982003368017
577703 577703 226339 226339 180059 1 0.0637270357285377
689381 689381 245833 245833 180059 2 0.0922512657274372
914604 914604 323689 323689 180059 1 0.0579937345581377
1636599 1636599 494847 494847 180059 1 0.0552992389930932
1731694 1731694 530303 530303 180059 2 0.0922512657274372 
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)
);