api_results

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

25 rows where inchi_id = 41

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28466 28466 107511 107511 PubChem (compound) 1 41 41 1
28467 28467 13824 13824 PubChem (compound) 1 41 41 1
28468 28468 13823 13823 PubChem (compound) 1 41 41 1
28469 28469 398624 398624 PubChem (compound) 1 41 41 1
28470 28470 230780 230780 PubChem (compound) 1 41 41 1
28471 28471 346546 346546 PubChem (compound) 1 41 41 1
336174 336174 13823 13823 PubChem (substance) 2 41 41 1
336175 336175 230780 230780 PubChem (substance) 2 41 41 1
336176 336176 13824 13824 PubChem (substance) 2 41 41 1
336177 336177 107511 107511 PubChem (substance) 2 41 41 1
336178 336178 436372 436372 PubChem (substance) 2 41 41 1
336179 336179 398624 398624 PubChem (substance) 2 41 41 1
336180 336180 346546 346546 PubChem (substance) 2 41 41 1
959073 959073 13823 13823 CAS Common Chemistry 3 41 41 1
959074 959074 230780 230780 CAS Common Chemistry 3 41 41 1
959075 959075 13824 13824 CAS Common Chemistry 3 41 41 1
959076 959076 107511 107511 CAS Common Chemistry 3 41 41 1
959077 959077 346546 346546 CAS Common Chemistry 3 41 41 1
1124162 1124162 398624 398624 CAS Common Chemistry 3 41 41 1
1159541 1159541 13824 13824 Computational Toxicology and Exposure Data 4 41 41 1
1159542 1159542 13823 13823 Computational Toxicology and Exposure Data 4 41 41 1
1159543 1159543 230780 230780 Computational Toxicology and Exposure Data 4 41 41 1
1159544 1159544 107511 107511 Computational Toxicology and Exposure Data 4 41 41 1
1159545 1159545 346546 346546 Computational Toxicology and Exposure Data 4 41 41 1
1159546 1159546 436372 436372 Computational Toxicology and Exposure Data 4 41 41 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)
);