api_results

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

23 rows where inchi_id = 34

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28460 28460 13820 13820 PubChem (compound) 1 34 34 1
28461 28461 13821 13821 PubChem (compound) 1 34 34 1
28462 28462 320015 320015 PubChem (compound) 1 34 34 1
28463 28463 107508 107508 PubChem (compound) 1 34 34 1
28464 28464 327587 327587 PubChem (compound) 1 34 34 1
28465 28465 406250 406250 PubChem (compound) 1 34 34 1
336167 336167 13820 13820 PubChem (substance) 2 34 34 1
336168 336168 13821 13821 PubChem (substance) 2 34 34 1
336169 336169 108456 108456 PubChem (substance) 2 34 34 2
336170 336170 107508 107508 PubChem (substance) 2 34 34 1
336171 336171 327587 327587 PubChem (substance) 2 34 34 1
336172 336172 406250 406250 PubChem (substance) 2 34 34 1
336173 336173 320015 320015 PubChem (substance) 2 34 34 1
959070 959070 13820 13820 CAS Common Chemistry 3 34 34 1
959071 959071 13821 13821 CAS Common Chemistry 3 34 34 1
959072 959072 406250 406250 CAS Common Chemistry 3 34 34 1
1159534 1159534 13820 13820 Computational Toxicology and Exposure Data 4 34 34 1
1159535 1159535 406250 406250 Computational Toxicology and Exposure Data 4 34 34 1
1159536 1159536 320015 320015 Computational Toxicology and Exposure Data 4 34 34 1
1159537 1159537 346502 346502 Computational Toxicology and Exposure Data 4 34 34 1
1159538 1159538 107508 107508 Computational Toxicology and Exposure Data 4 34 34 1
1159539 1159539 327587 327587 Computational Toxicology and Exposure Data 4 34 34 1
1159540 1159540 13821 13821 Computational Toxicology and Exposure Data 4 34 34 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)
);