consensus_index

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

15 rows where inventory_id = 37959

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108240 108240 37959 37959 47902 2 0.180888577033858
108241 108241 37959 37959 91910 4 0.137445595957062
108242 108242 37959 37959 136302 2 0.0738474523385131
108243 108243 37959 37959 138100 4 0.215113982831381
108244 108244 37959 37959 167483 1 0.0511630157839303
108245 108245 37959 37959 191920 1 0.0319768848649565
108246 108246 37959 37959 198142 1 0.0255815078919652
108247 108247 37959 37959 198143 1 0.0232559162654229
108248 108248 37959 37959 206967 1 0.0213179232433043
108249 108249 37959 37959 206968 1 0.0196780829938194
108250 108250 37959 37959 207043 1 0.018272505637118
108251 108251 37959 37959 218160 2 0.052218034321913
108252 108252 37959 37959 231795 2 0.0295389809354052
108253 108253 37959 37959 253221 1 0.036545011274236
108254 108254 37959 37959 298020 2 0.0348120228812753 
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)
);