consensus_index

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

13 rows where inventory_id = 18791

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
59325 59325 18791 18791 34663 3 0.144863499886908
59326 59326 18791 18791 131332 8 0.182300726652419
59327 59327 18791 18791 231275 2 0.0586288082502911
59328 59328 18791 18791 235095 2 0.0886384264539212
59329 59329 18791 18791 238119 1 0.110551541031111
59330 59330 18791 18791 238288 1 0.0276378852577778
59331 59331 18791 18791 238417 1 0.036850513677037
59332 59332 18791 18791 253162 3 0.106736339317331
59333 59333 18791 18791 266796 1 0.0473792318704762
59334 59334 18791 18791 291097 1 0.0331654623093333
59335 59335 18791 18791 292679 1 0.0301504202812121
59336 59336 18791 18791 332554 2 0.0957404429604599
59337 59337 18791 18791 333607 1 0.0255118940841025 
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)
);