consensus_index

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

11 rows where inventory_id = 31838

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
89117 89117 31838 31838 48309 3 0.207182904613977
89118 89118 31838 31838 111164 6 0.261034102701511
89119 89119 31838 31838 183235 1 0.0652585256753779
89120 89120 31838 31838 220088 2 0.106566726180661
89121 89121 31838 31838 231055 1 0.0870113675671705
89122 89122 31838 31838 248430 1 0.0652585256753779
89123 89123 31838 31838 314033 1 0.0522068205403023
89124 89124 31838 31838 314035 1 0.0435056837835852
89125 89125 31838 31838 314038 1 0.0372905861002159
89126 89126 31838 31838 314085 1 0.0326292628376889
89127 89127 31838 31838 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)
);