home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 105047

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107532 107532 105047 105047 PubChem (compound) 1 242204 242204 1
447711 447711 105047 105047 PubChem (substance) 2 242204 242204 1
708376 708376 105047 105047 PubChem (substance) 2 248696 248696 14
708401 708401 105047 105047 PubChem (substance) 2 248645 248645 10
708414 708414 105047 105047 PubChem (substance) 2 248688 248688 2
757319 757319 105047 105047 PubChem (substance) 2 248591 248591 3
757323 757323 105047 105047 PubChem (substance) 2 248858 248858 6
757328 757328 105047 105047 PubChem (substance) 2 248632 248632 18
757330 757330 105047 105047 PubChem (substance) 2 292829 292829 20
772444 772444 105047 105047 PubChem (substance) 2 248919 248919 4
772445 772445 105047 105047 PubChem (substance) 2 242204 242204 5
772446 772446 105047 105047 PubChem (substance) 2 207708 207708 7
772447 772447 105047 105047 PubChem (substance) 2 248857 248857 8
772448 772448 105047 105047 PubChem (substance) 2 207689 207689 9
772449 772449 105047 105047 PubChem (substance) 2 248634 248634 11
772452 772452 105047 105047 PubChem (substance) 2 249060 249060 12
772453 772453 105047 105047 PubChem (substance) 2 248801 248801 13
772454 772454 105047 105047 PubChem (substance) 2 249047 249047 15
772455 772455 105047 105047 PubChem (substance) 2 207687 207687 16
772456 772456 105047 105047 PubChem (substance) 2 247528 247528 17
772457 772457 105047 105047 PubChem (substance) 2 292003 292003 19
1017007 1017007 105047 105047 CAS Common Chemistry 3 55060 55060 1
1219270 1219270 105047 105047 Computational Toxicology and Exposure Data 4 55060 55060 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 1448.893ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website