home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 104239

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
13135 13135 104239 104239 PubChem (compound) 1 75466 75466 1
295851 295851 104239 104239 PubChem (substance) 2 60357 60357 24
306938 306938 104239 104239 PubChem (substance) 2 60356 60356 21
314202 314202 104239 104239 PubChem (substance) 2 75466 75466 1
314244 314244 104239 104239 PubChem (substance) 2 54569 54569 2
329230 329230 104239 104239 PubChem (substance) 2 28097 28097 25
380514 380514 104239 104239 PubChem (substance) 2 118596 118596 23
426184 426184 104239 104239 PubChem (substance) 2 35682 35682 26
436723 436723 104239 104239 PubChem (substance) 2 59784 59784 15
459642 459642 104239 104239 PubChem (substance) 2 7337 7337 3
459662 459662 104239 104239 PubChem (substance) 2 45518 45518 16
482410 482410 104239 104239 PubChem (substance) 2 45515 45515 17
519532 519532 104239 104239 PubChem (substance) 2 57796 57796 5
646736 646736 104239 104239 PubChem (substance) 2 128634 128634 14
695153 695153 104239 104239 PubChem (substance) 2 232089 232089 8
764238 764238 104239 104239 PubChem (substance) 2 232088 232088 7
770746 770746 104239 104239 PubChem (substance) 2 169699 169699 4
770749 770749 104239 104239 PubChem (substance) 2 176643 176643 6
770753 770753 104239 104239 PubChem (substance) 2 220316 220316 9
770754 770754 104239 104239 PubChem (substance) 2 195937 195937 10
770759 770759 104239 104239 PubChem (substance) 2 241202 241202 11
770761 770761 104239 104239 PubChem (substance) 2 214162 214162 12
770764 770764 104239 104239 PubChem (substance) 2 249156 249156 13
770767 770767 104239 104239 PubChem (substance) 2 270307 270307 18
770770 770770 104239 104239 PubChem (substance) 2 275620 275620 19
770773 770773 104239 104239 PubChem (substance) 2 255149 255149 20
770777 770777 104239 104239 PubChem (substance) 2 194194 194194 22
947905 947905 104239 104239 CAS Common Chemistry 3 75466 75466 1
1146321 1146321 104239 104239 Computational Toxicology and Exposure Data 4 75466 75466 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 469.753ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website