home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 83247

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113421 113421 83247 83247 PubChem (compound) 1 28468 28468 1
307891 307891 83247 83247 PubChem (substance) 2 48605 48605 23
313344 313344 83247 83247 PubChem (substance) 2 29202 29202 5
379372 379372 83247 83247 PubChem (substance) 2 73291 73291 12
393164 393164 83247 83247 PubChem (substance) 2 20408 20408 17
438023 438023 83247 83247 PubChem (substance) 2 41014 41014 18
438034 438034 83247 83247 PubChem (substance) 2 41660 41660 7
455627 455627 83247 83247 PubChem (substance) 2 28468 28468 1
488174 488174 83247 83247 PubChem (substance) 2 59568 59568 3
488297 488297 83247 83247 PubChem (substance) 2 59933 59933 2
490634 490634 83247 83247 PubChem (substance) 2 40658 40658 16
493580 493580 83247 83247 PubChem (substance) 2 3000 3000 13
505656 505656 83247 83247 PubChem (substance) 2 31008 31008 20
517241 517241 83247 83247 PubChem (substance) 2 52274 52274 6
522782 522782 83247 83247 PubChem (substance) 2 68113 68113 15
563209 563209 83247 83247 PubChem (substance) 2 39645 39645 19
665050 665050 83247 83247 PubChem (substance) 2 58632 58632 8
678179 678179 83247 83247 PubChem (substance) 2 23817 23817 4
761739 761739 83247 83247 PubChem (substance) 2 185912 185912 9
761744 761744 83247 83247 PubChem (substance) 2 138286 138286 10
761746 761746 83247 83247 PubChem (substance) 2 149872 149872 11
761751 761751 83247 83247 PubChem (substance) 2 231092 231092 14
761753 761753 83247 83247 PubChem (substance) 2 223258 223258 21
761754 761754 83247 83247 PubChem (substance) 2 228883 228883 22
1021092 1021092 83247 83247 CAS Common Chemistry 3 28468 28468 1
1223537 1223537 83247 83247 Computational Toxicology and Exposure Data 4 28468 28468 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 451.923ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website