api_results

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

14 rows where query_id = 117586

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137202 137202 117586 117586 PubChem (compound) 1 60528 60528 1
137206 137206 117586 117586 PubChem (compound) 1 144274 144274 2
137207 137207 117586 117586 PubChem (compound) 1 195839 195839 3
137208 137208 117586 117586 PubChem (compound) 1 207959 207959 4
488424 488424 117586 117586 PubChem (substance) 2 60528 60528 1
488426 488426 117586 117586 PubChem (substance) 2 144274 144274 2
488439 488439 117586 117586 PubChem (substance) 2 195839 195839 4
488440 488440 117586 117586 PubChem (substance) 2 207959 207959 7
717665 717665 117586 117586 PubChem (substance) 2 320384 320384 5
783086 783086 117586 117586 PubChem (substance) 2 258601 258601 3
783087 783087 117586 117586 PubChem (substance) 2 208580 208580 6
783089 783089 117586 117586 PubChem (substance) 2 218413 218413 8
1038009 1038009 117586 117586 CAS Common Chemistry 3 60528 60528 1
1240998 1240998 117586 117586 Computational Toxicology and Exposure Data 4 127659 127659 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)
);