consensus_index

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

10 rows where inventory_id = 19982

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
62121 62121 19982 19982 46961 1 0.054899964430635
62122 62122 19982 19982 47737 6 0.21959985772254
62123 62123 19982 19982 50233 2 0.10979992886127
62124 62124 19982 19982 50234 2 0.0896512665013346
62125 62125 19982 19982 50235 1 0.043919971544508
62126 62126 19982 19982 57290 1 0.10979992886127
62127 62127 19982 19982 128278 2 0.21959985772254
62128 62128 19982 19982 226007 1 0.0313714082460772
62129 62129 19982 19982 238235 1 0.07319995257418
62130 62130 19982 19982 239052 1 0.03659997628709 
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)
);