api_results

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

18 rows where inchi_id = 49517

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
92355 92355 54099 54099 PubChem (compound) 1 49517 49517 1
92356 92356 405045 405045 PubChem (compound) 1 49517 49517 1
92357 92357 398364 398364 PubChem (compound) 1 49517 49517 1
92358 92358 114378 114378 PubChem (compound) 1 49517 49517 1
92359 92359 54100 54100 PubChem (compound) 1 49517 49517 1
426160 426160 54099 54099 PubChem (substance) 2 49517 49517 1
426161 426161 14838 14838 PubChem (substance) 2 49517 49517 4
426162 426162 405045 405045 PubChem (substance) 2 49517 49517 1
426163 426163 17436 17436 PubChem (substance) 2 49517 49517 2
426164 426164 422741 422741 PubChem (substance) 2 49517 49517 2
426165 426165 114378 114378 PubChem (substance) 2 49517 49517 1
426166 426166 54100 54100 PubChem (substance) 2 49517 49517 1
426167 426167 398364 398364 PubChem (substance) 2 49517 49517 2
1006595 1006595 54099 54099 CAS Common Chemistry 3 49517 49517 1
1006596 1006596 405045 405045 CAS Common Chemistry 3 49517 49517 1
1006597 1006597 54100 54100 CAS Common Chemistry 3 49517 49517 1
1208535 1208535 54099 54099 Computational Toxicology and Exposure Data 4 49517 49517 1
1208536 1208536 54100 54100 Computational Toxicology and Exposure Data 4 49517 49517 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)
);