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 = 317810

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
92926 92926 317810 317810 PubChem (compound) 1 7019 7019 1
306261 306261 317810 317810 PubChem (substance) 2 74051 74051 9
338273 338273 317810 317810 PubChem (substance) 2 2831 2831 11
426946 426946 317810 317810 PubChem (substance) 2 7019 7019 1
442516 442516 317810 317810 PubChem (substance) 2 34633 34633 3
525836 525836 317810 317810 PubChem (substance) 2 76322 76322 8
527798 527798 317810 317810 PubChem (substance) 2 2473 2473 19
670738 670738 317810 317810 PubChem (substance) 2 114931 114931 10
745017 745017 317810 317810 PubChem (substance) 2 196806 196806 2
822208 822208 317810 317810 PubChem (substance) 2 103087 103087 5
848232 848232 317810 317810 PubChem (substance) 2 202848 202848 4
848233 848233 317810 317810 PubChem (substance) 2 143592 143592 6
848234 848234 317810 317810 PubChem (substance) 2 289666 289666 7
848235 848235 317810 317810 PubChem (substance) 2 332322 332322 12
848236 848236 317810 317810 PubChem (substance) 2 332323 332323 13
848237 848237 317810 317810 PubChem (substance) 2 332324 332324 14
848238 848238 317810 317810 PubChem (substance) 2 203337 203337 15
848239 848239 317810 317810 PubChem (substance) 2 333039 333039 16
848240 848240 317810 317810 PubChem (substance) 2 333040 333040 17
848241 848241 317810 317810 PubChem (substance) 2 343813 343813 18
1007016 1007016 317810 317810 CAS Common Chemistry 3 7019 7019 1
1208944 1208944 317810 317810 Computational Toxicology and Exposure Data 4 7019 7019 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 700.748ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website