api_results

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

10 rows where query_id = 38197

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
76479 76479 38197 38197 PubChem (compound) 1 131464 131464 1
76480 76480 38197 38197 PubChem (compound) 1 131464 131464 2
76481 76481 38197 38197 PubChem (compound) 1 144975 144975 3
404216 404216 38197 38197 PubChem (substance) 2 131464 131464 1
404220 404220 38197 38197 PubChem (substance) 2 131464 131464 2
404223 404223 38197 38197 PubChem (substance) 2 144975 144975 5
481962 481962 38197 38197 PubChem (substance) 2 44906 44906 3
736853 736853 38197 38197 PubChem (substance) 2 46697 46697 4
994068 994068 38197 38197 CAS Common Chemistry 3 46697 46697 1
1197107 1197107 38197 38197 Computational Toxicology and Exposure Data 4 131464 131464 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)
);