api_results

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

10 rows where query_id = 302524

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
644213 644213 302524 302524 PubChem (substance) 2 36657 36657 1
775728 775728 302524 302524 PubChem (substance) 2 269714 269714 8
845609 845609 302524 302524 PubChem (substance) 2 273174 273174 5
846131 846131 302524 302524 PubChem (substance) 2 212333 212333 2
846133 846133 302524 302524 PubChem (substance) 2 247922 247922 3
846134 846134 302524 302524 PubChem (substance) 2 146805 146805 4
846136 846136 302524 302524 PubChem (substance) 2 308002 308002 6
846138 846138 302524 302524 PubChem (substance) 2 212332 212332 7
1112583 1112583 302524 302524 CAS Common Chemistry 3 36657 36657 1
1323333 1323333 302524 302524 Computational Toxicology and Exposure Data 4 36657 36657 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)
);