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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
13133 13133 105631 105631 PubChem (compound) 1 75466 75466 1
295861 295861 105631 105631 PubChem (substance) 2 60357 60357 24
306903 306903 105631 105631 PubChem (substance) 2 60356 60356 21
314196 314196 105631 105631 PubChem (substance) 2 75466 75466 1
314236 314236 105631 105631 PubChem (substance) 2 54569 54569 2
329232 329232 105631 105631 PubChem (substance) 2 28097 28097 25
380518 380518 105631 105631 PubChem (substance) 2 118596 118596 23
426185 426185 105631 105631 PubChem (substance) 2 35682 35682 26
436720 436720 105631 105631 PubChem (substance) 2 59784 59784 15
459638 459638 105631 105631 PubChem (substance) 2 7337 7337 3
459654 459654 105631 105631 PubChem (substance) 2 45518 45518 16
482406 482406 105631 105631 PubChem (substance) 2 45515 45515 17
519527 519527 105631 105631 PubChem (substance) 2 57796 57796 5
646729 646729 105631 105631 PubChem (substance) 2 128634 128634 14
695147 695147 105631 105631 PubChem (substance) 2 232089 232089 8
764234 764234 105631 105631 PubChem (substance) 2 232088 232088 7
770745 770745 105631 105631 PubChem (substance) 2 169699 169699 4
770748 770748 105631 105631 PubChem (substance) 2 176643 176643 6
770752 770752 105631 105631 PubChem (substance) 2 220316 220316 9
770756 770756 105631 105631 PubChem (substance) 2 195937 195937 10
770757 770757 105631 105631 PubChem (substance) 2 241202 241202 11
770760 770760 105631 105631 PubChem (substance) 2 214162 214162 12
770763 770763 105631 105631 PubChem (substance) 2 249156 249156 13
770766 770766 105631 105631 PubChem (substance) 2 270307 270307 18
770769 770769 105631 105631 PubChem (substance) 2 275620 275620 19
770772 770772 105631 105631 PubChem (substance) 2 255149 255149 20
770775 770775 105631 105631 PubChem (substance) 2 194194 194194 22
947902 947902 105631 105631 CAS Common Chemistry 3 75466 75466 1
1146323 1146323 105631 105631 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 1563.313ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website