api_results

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

12 rows where query_id = 376171

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
269555 269555 376171 376171 PubChem (compound) 1 4134 4134 1
659145 659145 376171 376171 PubChem (substance) 2 175812 175812 9
659216 659216 376171 376171 PubChem (substance) 2 4134 4134 1
699891 699891 376171 376171 PubChem (substance) 2 155174 155174 2
919168 919168 376171 376171 PubChem (substance) 2 197711 197711 3
919169 919169 376171 376171 PubChem (substance) 2 243012 243012 4
919170 919170 376171 376171 PubChem (substance) 2 238508 238508 5
919171 919171 376171 376171 PubChem (substance) 2 219973 219973 6
919172 919172 376171 376171 PubChem (substance) 2 284914 284914 7
919173 919173 376171 376171 PubChem (substance) 2 197710 197710 8
1117975 1117975 376171 376171 CAS Common Chemistry 3 4134 4134 1
1329610 1329610 376171 376171 Computational Toxicology and Exposure Data 4 4134 4134 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)
);