api_results

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

20 rows where inchi_id = 80

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28589 28589 13873 13873 PubChem (compound) 1 80 80 1
28590 28590 107544 107544 PubChem (compound) 1 80 80 1
28591 28591 13874 13874 PubChem (compound) 1 80 80 1
28592 28592 230787 230787 PubChem (compound) 1 80 80 1
336350 336350 13873 13873 PubChem (substance) 2 80 80 1
336351 336351 13874 13874 PubChem (substance) 2 80 80 1
336352 336352 230787 230787 PubChem (substance) 2 80 80 1
336353 336353 107544 107544 PubChem (substance) 2 80 80 1
336354 336354 346632 346632 PubChem (substance) 2 80 80 1
336355 336355 323901 323901 PubChem (substance) 2 80 80 44658
959177 959177 13873 13873 CAS Common Chemistry 3 80 80 1
959178 959178 346632 346632 CAS Common Chemistry 3 80 80 1
959179 959179 107544 107544 CAS Common Chemistry 3 80 80 1
959180 959180 230787 230787 CAS Common Chemistry 3 80 80 1
959181 959181 13874 13874 CAS Common Chemistry 3 80 80 1
1159658 1159658 13874 13874 Computational Toxicology and Exposure Data 4 80 80 1
1159659 1159659 13873 13873 Computational Toxicology and Exposure Data 4 80 80 1
1159660 1159660 230787 230787 Computational Toxicology and Exposure Data 4 80 80 1
1159661 1159661 107544 107544 Computational Toxicology and Exposure Data 4 80 80 1
1159662 1159662 346632 346632 Computational Toxicology and Exposure Data 4 80 80 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)
);