consensus_index

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

11 rows where inventory_id = 59739

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
167012 167012 59739 59739 48309 3 0.207182904613977
167013 167013 59739 59739 111164 6 0.261034102701511
167014 167014 59739 59739 183235 1 0.0652585256753779
167015 167015 59739 59739 220088 2 0.106566726180661
167016 167016 59739 59739 231055 1 0.0870113675671705
167017 167017 59739 59739 248430 1 0.0652585256753779
167018 167018 59739 59739 314033 1 0.0522068205403023
167019 167019 59739 59739 314035 1 0.0435056837835852
167020 167020 59739 59739 314038 1 0.0372905861002159
167021 167021 59739 59739 314085 1 0.0326292628376889
167022 167022 59739 59739 314653 1 0.0290037891890568 
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)
);