consensus_index

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

15 rows where inchi_id = 27820

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30890 30890 9037 9037 27820 1 0.3125
244121 244121 83068 83068 27820 1 0.239130434782609
267406 267406 90646 90646 27820 7 0.620689655172414
694926 694926 247853 247853 27820 12 0.636363636363636
718070 718070 253958 253958 27820 1 0.318181818181818
784228 784228 274133 274133 27820 8 0.625
784230 784230 274134 274134 27820 4 0.6
784232 784232 274135 274135 27820 6 0.615384615384615
821819 821819 285347 285347 27820 1 0.3125
821821 821821 285348 285348 27820 1 0.307692307692308
821823 821823 285349 285349 27820 1 0.3125
892602 892602 313138 313138 27820 1 0.3
1628265 1628265 491900 491900 27820 1 0.3125
1639640 1639640 495998 495998 27820 8 0.625
1727198 1727198 528912 528912 27820 1 0.3125 
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)
);