api_results

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

11 rows where query_id = 21163

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14456 14456 21163 21163 PubChem (compound) 1 75450 75450 2
46861 46861 21163 21163 PubChem (compound) 1 201145 201145 1
46862 46862 21163 21163 PubChem (compound) 1 206515 206515 3
46863 46863 21163 21163 PubChem (compound) 1 238920 238920 4
315995 315995 21163 21163 PubChem (substance) 2 75450 75450 2
362542 362542 21163 21163 PubChem (substance) 2 201145 201145 1
362547 362547 21163 21163 PubChem (substance) 2 206515 206515 3
362553 362553 21163 21163 PubChem (substance) 2 238920 238920 4
720700 720700 21163 21163 PubChem (substance) 2 340273 340273 5
972149 972149 21163 21163 CAS Common Chemistry 3 17777 17777 1
1174791 1174791 21163 21163 Computational Toxicology and Exposure Data 4 123204 123204 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)
);