consensus_index

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

12 rows where inventory_id = 158034

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
440801 440801 158034 158034 59574 8 0.314362809012773
440802 440802 158034 158034 136292 2 0.157181404506387
440803 440803 158034 158034 138513 1 0.0523938015021289
440804 440804 158034 158034 186246 2 0.0907487262033658
440805 440805 158034 158034 189034 2 0.0405840641324485
440806 440806 158034 158034 189606 1 0.0285784371829794
440807 440807 158034 158034 194712 2 0.0497051244064436
440808 440808 158034 158034 223562 1 0.0449089727161105
440809 440809 158034 158034 234202 2 0.0302495754011219
440810 440810 158034 158034 234945 2 0.0396059911474044
440811 440811 158034 158034 259326 2 0.0907487262033658
440812 440812 158034 158034 291718 2 0.0497051244064436 
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)
);