api_results

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

9 rows where query_id = 318394

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
645603 645603 318394 318394 PubChem (substance) 2 117449 117449 2
647773 647773 318394 318394 PubChem (substance) 2 236010 236010 4
848289 848289 318394 318394 PubChem (substance) 2 117449 117449 1
848291 848291 318394 318394 PubChem (substance) 2 277686 277686 3
848292 848292 318394 318394 PubChem (substance) 2 205660 205660 5
848293 848293 318394 318394 PubChem (substance) 2 294995 294995 6
848294 848294 318394 318394 PubChem (substance) 2 307635 307635 7
1113933 1113933 318394 318394 CAS Common Chemistry 3 6062 6062 1
1324823 1324823 318394 318394 Computational Toxicology and Exposure Data 4 117449 117449 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)
);