consensus_index

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

14 rows where inventory_id = 245014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
687011 687011 245014 245014 14659 8 0.210669834334524
687012 687012 245014 245014 46285 1 0.105334917167262
687013 687013 245014 245014 46286 2 0.0744830342246943
687014 687014 245014 245014 114907 3 0.210669834334524
687015 687015 245014 245014 182533 1 0.070223278111508
687016 687016 245014 245014 196228 1 0.070223278111508
687017 687017 245014 245014 199976 1 0.0300956906192177
687018 687018 245014 245014 209828 1 0.0191518031213204
687019 687019 245014 245014 229089 1 0.0210669834334524
687020 687020 245014 245014 232082 1 0.0421339668669048
687021 687021 245014 245014 232106 1 0.035111639055754
687022 687022 245014 245014 232131 1 0.0263337292918155
687023 687023 245014 245014 232136 1 0.0234077593705027
687024 687024 245014 245014 266590 1 0.052667458583631 
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)
);