consensus_index

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

15 rows where inventory_id = 57248

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
159020 159020 57248 57248 31905 1 0.0220700462709996
159021 159021 57248 57248 38144 1 0.0176560370167997
159022 159022 57248 57248 110552 2 0.059220148474225
159023 159023 57248 57248 129484 2 0.0299872878421937
159024 159024 57248 57248 141047 4 0.264840555251995
159025 159025 57248 57248 159052 2 0.059220148474225
159026 159026 57248 57248 168965 1 0.0331050694064994
159027 159027 57248 57248 169117 1 0.0294267283613328
159028 159028 57248 57248 182196 1 0.0882801850839983
159029 159029 57248 57248 184020 2 0.0624235175172987
159030 159030 57248 57248 197802 1 0.0240764141138177
159031 159031 57248 57248 199807 1 0.0264840555251995
159032 159032 57248 57248 204031 1 0.0378343650359993
159033 159033 57248 57248 224958 4 0.132420277625997
159034 159034 57248 57248 309827 2 0.0267529360788423 
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)
);