home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 14951

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
31430 31430 14951 14951 PubChem (compound) 1 4045 4045 1
299377 299377 14951 14951 PubChem (substance) 2 2662 2662 6
307296 307296 14951 14951 PubChem (substance) 2 11441 11441 4
307592 307592 14951 14951 PubChem (substance) 2 3489 3489 8
312259 312259 14951 14951 PubChem (substance) 2 3709 3709 3
312875 312875 14951 14951 PubChem (substance) 2 3331 3331 20
314138 314138 14951 14951 PubChem (substance) 2 73287 73287 21
339963 339963 14951 14951 PubChem (substance) 2 3728 3728 7
340286 340286 14951 14951 PubChem (substance) 2 4045 4045 1
343194 343194 14951 14951 PubChem (substance) 2 7017 7017 2
357906 357906 14951 14951 PubChem (substance) 2 4103 4103 5
358752 358752 14951 14951 PubChem (substance) 2 6183 6183 22
668104 668104 14951 14951 PubChem (substance) 2 20697 20697 9
709790 709790 14951 14951 PubChem (substance) 2 261389 261389 13
709800 709800 14951 14951 PubChem (substance) 2 261390 261390 12
712575 712575 14951 14951 PubChem (substance) 2 222032 222032 14
712629 712629 14951 14951 PubChem (substance) 2 232485 232485 10
712630 712630 14951 14951 PubChem (substance) 2 187187 187187 11
712631 712631 14951 14951 PubChem (substance) 2 326803 326803 15
712632 712632 14951 14951 PubChem (substance) 2 326829 326829 16
712633 712633 14951 14951 PubChem (substance) 2 291790 291790 17
712634 712634 14951 14951 PubChem (substance) 2 323543 323543 18
712635 712635 14951 14951 PubChem (substance) 2 179751 179751 19
961293 961293 14951 14951 CAS Common Chemistry 3 4045 4045 1
1162254 1162254 14951 14951 Computational Toxicology and Exposure Data 4 4045 4045 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 485.489ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website