api_results

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

10 rows where query_id = 98189

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
121419 121419 98189 98189 PubChem (compound) 1 20429 20429 1
466898 466898 98189 98189 PubChem (substance) 2 20429 20429 1
494069 494069 98189 98189 PubChem (substance) 2 4121 4121 2
534769 534769 98189 98189 PubChem (substance) 2 11760 11760 5
768243 768243 98189 98189 PubChem (substance) 2 20429 20429 3
768247 768247 98189 98189 PubChem (substance) 2 233500 233500 4
768248 768248 98189 98189 PubChem (substance) 2 174462 174462 6
768249 768249 98189 98189 PubChem (substance) 2 178024 178024 7
1026509 1026509 98189 98189 CAS Common Chemistry 3 20429 20429 1
1229127 1229127 98189 98189 Computational Toxicology and Exposure Data 4 20429 20429 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)
);