home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 338153

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
264313 264313 338153 338153 PubChem (compound) 1 239129 239129 1
264316 264316 338153 338153 PubChem (compound) 1 216909 216909 2
264317 264317 338153 338153 PubChem (compound) 1 39386 39386 3
264319 264319 338153 338153 PubChem (compound) 1 243544 243544 4
264320 264320 338153 338153 PubChem (compound) 1 333468 333468 5
264321 264321 338153 338153 PubChem (compound) 1 259399 259399 6
651141 651141 338153 338153 PubChem (substance) 2 239129 239129 1
651144 651144 338153 338153 PubChem (substance) 2 216909 216909 2
651146 651146 338153 338153 PubChem (substance) 2 39386 39386 3
651148 651148 338153 338153 PubChem (substance) 2 243544 243544 4
651150 651150 338153 338153 PubChem (substance) 2 333468 333468 8
651152 651152 338153 338153 PubChem (substance) 2 259399 259399 19
754471 754471 338153 338153 PubChem (substance) 2 240104 240104 12
911093 911093 338153 338153 PubChem (substance) 2 250506 250506 5
911094 911094 338153 338153 PubChem (substance) 2 113588 113588 6
911095 911095 338153 338153 PubChem (substance) 2 259430 259430 7
911096 911096 338153 338153 PubChem (substance) 2 243343 243343 9
911097 911097 338153 338153 PubChem (substance) 2 259337 259337 10
911098 911098 338153 338153 PubChem (substance) 2 275843 275843 11
911099 911099 338153 338153 PubChem (substance) 2 270667 270667 13
911100 911100 338153 338153 PubChem (substance) 2 287437 287437 14
911101 911101 338153 338153 PubChem (substance) 2 274660 274660 15
911102 911102 338153 338153 PubChem (substance) 2 289594 289594 16
911103 911103 338153 338153 PubChem (substance) 2 309094 309094 17
911104 911104 338153 338153 PubChem (substance) 2 321382 321382 18
911105 911105 338153 338153 PubChem (substance) 2 264823 264823 20
1115284 1115284 338153 338153 CAS Common Chemistry 3 39386 39386 1
1326965 1326965 338153 338153 Computational Toxicology and Exposure Data 4 113588 113588 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 475.524ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website