api_results

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

6 rows where query_id = 58333

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
98075 98075 58333 58333 PubChem (compound) 1 56319 56319 1
434311 434311 58333 58333 PubChem (substance) 2 56319 56319 1
748660 748660 58333 58333 PubChem (substance) 2 157323 157323 2
748661 748661 58333 58333 PubChem (substance) 2 244547 244547 3
1010663 1010663 58333 58333 CAS Common Chemistry 3 56319 56319 1
1212771 1212771 58333 58333 Computational Toxicology and Exposure Data 4 56319 56319 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)
);