home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 56354

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
95506 95506 56354 56354 PubChem (compound) 1 22667 22667 1
430576 430576 56354 56354 PubChem (substance) 2 22667 22667 1
438310 438310 56354 56354 PubChem (substance) 2 18897 18897 14
546016 546016 56354 56354 PubChem (substance) 2 192014 192014 5
546020 546020 56354 56354 PubChem (substance) 2 224753 224753 2
546025 546025 56354 56354 PubChem (substance) 2 169158 169158 9
546040 546040 56354 56354 PubChem (substance) 2 240426 240426 3
546045 546045 56354 56354 PubChem (substance) 2 265815 265815 12
546049 546049 56354 56354 PubChem (substance) 2 309835 309835 13
546056 546056 56354 56354 PubChem (substance) 2 334567 334567 15
746683 746683 56354 56354 PubChem (substance) 2 169158 169158 4
746685 746685 56354 56354 PubChem (substance) 2 242999 242999 6
746689 746689 56354 56354 PubChem (substance) 2 240555 240555 7
746691 746691 56354 56354 PubChem (substance) 2 243357 243357 8
746692 746692 56354 56354 PubChem (substance) 2 320456 320456 10
746695 746695 56354 56354 PubChem (substance) 2 262587 262587 11
746698 746698 56354 56354 PubChem (substance) 2 22667 22667 16
1008894 1008894 56354 56354 CAS Common Chemistry 3 22667 22667 1
1210915 1210915 56354 56354 Computational Toxicology and Exposure Data 4 22667 22667 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 2647.226ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website