api_results

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

11 rows where query_id = 125986

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
146028 146028 125986 125986 PubChem (compound) 1 20530 20530 1
478714 478714 125986 125986 PubChem (substance) 2 31906 31906 2
500084 500084 125986 125986 PubChem (substance) 2 20530 20530 1
777486 777486 125986 125986 PubChem (substance) 2 136807 136807 3
777492 777492 125986 125986 PubChem (substance) 2 195673 195673 7
777508 777508 125986 125986 PubChem (substance) 2 138446 138446 4
789459 789459 125986 125986 PubChem (substance) 2 228318 228318 8
789461 789461 125986 125986 PubChem (substance) 2 233665 233665 6
789464 789464 125986 125986 PubChem (substance) 2 206187 206187 5
1044664 1044664 125986 125986 CAS Common Chemistry 3 20530 20530 1
1247554 1247554 125986 125986 Computational Toxicology and Exposure Data 4 20530 20530 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)
);