consensus_index

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

9 rows where inchi_id = 45380

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
266301 266301 90251 90251 45380 1 0.114982578397213
281411 281411 95444 95444 45380 2 0.173341199613246
281466 281466 95464 95464 45380 1 0.0717646678219516
281512 281512 95480 95480 45380 7 0.372010628875111
693887 693887 247494 247494 45380 1 0.115384615384615
781695 781695 273322 273322 45380 1 0.115384615384615
901534 901534 317391 317391 45380 4 0.417633410672854
902749 902749 318080 318080 45380 1 0.0835266821345708
907824 907824 320503 320503 45380 1 0.113207547169811 
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)
);