home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 60347

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
100219 100219 60347 60347 PubChem (compound) 1 75401 75401 1
437537 437537 60347 60347 PubChem (substance) 2 75401 75401 1
653823 653823 60347 60347 PubChem (substance) 2 171210 171210 3
750509 750509 60347 60347 PubChem (substance) 2 169000 169000 2
750516 750516 60347 60347 PubChem (substance) 2 199605 199605 4
750522 750522 60347 60347 PubChem (substance) 2 173581 173581 5
750528 750528 60347 60347 PubChem (substance) 2 241524 241524 6
750533 750533 60347 60347 PubChem (substance) 2 282133 282133 7
750539 750539 60347 60347 PubChem (substance) 2 237700 237700 8
750542 750542 60347 60347 PubChem (substance) 2 237489 237489 9
750543 750543 60347 60347 PubChem (substance) 2 92545 92545 10
750546 750546 60347 60347 PubChem (substance) 2 288691 288691 11
750552 750552 60347 60347 PubChem (substance) 2 288693 288693 12
750558 750558 60347 60347 PubChem (substance) 2 275153 275153 13
750564 750564 60347 60347 PubChem (substance) 2 197801 197801 14
750569 750569 60347 60347 PubChem (substance) 2 321865 321865 15
750570 750570 60347 60347 PubChem (substance) 2 241857 241857 16
750573 750573 60347 60347 PubChem (substance) 2 264422 264422 17
1012091 1012091 60347 60347 CAS Common Chemistry 3 75401 75401 1
1214224 1214224 60347 60347 Computational Toxicology and Exposure Data 4 92545 92545 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 757.263ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website