api_results

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

13 rows where query_id = 153607

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
790555 790555 153607 153607 PubChem (substance) 2 12479 12479 1
807694 807694 153607 153607 PubChem (substance) 2 12479 12479 2
807696 807696 153607 153607 PubChem (substance) 2 12479 12479 3
807697 807697 153607 153607 PubChem (substance) 2 142323 142323 4
807698 807698 153607 153607 PubChem (substance) 2 227407 227407 5
807699 807699 153607 153607 PubChem (substance) 2 142323 142323 6
807702 807702 153607 153607 PubChem (substance) 2 142323 142323 7
807703 807703 153607 153607 PubChem (substance) 2 279016 279016 8
807704 807704 153607 153607 PubChem (substance) 2 87092 87092 9
807705 807705 153607 153607 PubChem (substance) 2 279016 279016 10
807706 807706 153607 153607 PubChem (substance) 2 279016 279016 11
1065146 1065146 153607 153607 CAS Common Chemistry 3 12479 12479 1
1266982 1266982 153607 153607 Computational Toxicology and Exposure Data 4 12479 12479 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)
);