consensus_index

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

15 rows where inchi_id = 28942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
57416 57416 18050 18050 28942 6 0.615384615384615
119186 119186 41492 41492 28942 6 0.615384615384615
145717 145717 51965 51965 28942 4 0.6
147060 147060 52794 52794 28942 3 0.36045366724938
338277 338277 114054 114054 28942 5 0.608695652173913
477326 477326 174066 174066 28942 5 0.608695652173913
489439 489439 183268 183268 28942 3 0.36045366724938
596737 596737 233723 233723 28942 1 0.386876596835389
785926 785926 274619 274619 28942 5 0.380952380952381
785929 785929 274620 274620 28942 4 0.6
913821 913821 323091 323091 28942 3 0.36045366724938
919868 919868 326326 326326 28942 4 0.6
944327 944327 338181 338181 28942 1 0.226415094339623
1673465 1673465 507853 507853 28942 6 0.615384615384615
1757482 1757482 538877 538877 28942 4 0.383192366949198 
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)
);