home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 313305

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
259843 259843 313305 313305 PubChem (compound) 1 27085 27085 1
431239 431239 313305 313305 PubChem (substance) 2 24610 24610 8
644494 644494 313305 313305 PubChem (substance) 2 27085 27085 1
652196 652196 313305 313305 PubChem (substance) 2 51679 51679 11
652201 652201 313305 313305 PubChem (substance) 2 224086 224086 2
652208 652208 313305 313305 PubChem (substance) 2 139441 139441 3
652229 652229 313305 313305 PubChem (substance) 2 232294 232294 13
813825 813825 313305 313305 PubChem (substance) 2 314239 314239 12
847636 847636 313305 313305 PubChem (substance) 2 258095 258095 4
847639 847639 313305 313305 PubChem (substance) 2 238935 238935 5
847642 847642 313305 313305 PubChem (substance) 2 310651 310651 6
847643 847643 313305 313305 PubChem (substance) 2 139441 139441 7
847644 847644 313305 313305 PubChem (substance) 2 270207 270207 9
847645 847645 313305 313305 PubChem (substance) 2 292059 292059 10
847646 847646 313305 313305 PubChem (substance) 2 308568 308568 14
847647 847647 313305 313305 PubChem (substance) 2 309934 309934 15
847648 847648 313305 313305 PubChem (substance) 2 323934 323934 16
847649 847649 313305 313305 PubChem (substance) 2 334239 334239 17
847650 847650 313305 313305 PubChem (substance) 2 149833 149833 18
847651 847651 313305 313305 PubChem (substance) 2 27085 27085 19
1113537 1113537 313305 313305 CAS Common Chemistry 3 27085 27085 1
1324420 1324420 313305 313305 Computational Toxicology and Exposure Data 4 27085 27085 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)
);
Powered by Datasette · Queries took 1679.079ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website