api_results

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

13 rows where query_id = 156426

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
175631 175631 156426 156426 PubChem (compound) 1 16242 16242 1
539232 539232 156426 156426 PubChem (substance) 2 16242 16242 1
659935 659935 156426 156426 PubChem (substance) 2 16373 16373 9
809665 809665 156426 156426 PubChem (substance) 2 137282 137282 2
809667 809667 156426 156426 PubChem (substance) 2 239347 239347 3
809668 809668 156426 156426 PubChem (substance) 2 211262 211262 4
809671 809671 156426 156426 PubChem (substance) 2 189200 189200 5
809674 809674 156426 156426 PubChem (substance) 2 256444 256444 6
809675 809675 156426 156426 PubChem (substance) 2 279721 279721 7
809676 809676 156426 156426 PubChem (substance) 2 237145 237145 8
809678 809678 156426 156426 PubChem (substance) 2 211261 211261 10
1067194 1067194 156426 156426 CAS Common Chemistry 3 16242 16242 1
1268815 1268815 156426 156426 Computational Toxicology and Exposure Data 4 16242 16242 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);