home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 17791

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
39362 39362 17791 17791 PubChem (compound) 1 53255 53255 1
39365 39365 17791 17791 PubChem (compound) 1 205570 205570 2
39366 39366 17791 17791 PubChem (compound) 1 157286 157286 3
39370 39370 17791 17791 PubChem (compound) 1 130558 130558 4
39372 39372 17791 17791 PubChem (compound) 1 144631 144631 5
313595 313595 17791 17791 PubChem (substance) 2 190485 190485 13
351855 351855 17791 17791 PubChem (substance) 2 53255 53255 1
351862 351862 17791 17791 PubChem (substance) 2 205570 205570 2
351867 351867 17791 17791 PubChem (substance) 2 157286 157286 3
351874 351874 17791 17791 PubChem (substance) 2 130558 130558 5
351881 351881 17791 17791 PubChem (substance) 2 144631 144631 7
716852 716852 17791 17791 PubChem (substance) 2 222916 222916 4
716855 716855 17791 17791 PubChem (substance) 2 161365 161365 6
716856 716856 17791 17791 PubChem (substance) 2 179616 179616 8
716861 716861 17791 17791 PubChem (substance) 2 224084 224084 9
716862 716862 17791 17791 PubChem (substance) 2 233769 233769 10
716866 716866 17791 17791 PubChem (substance) 2 157398 157398 11
716867 716867 17791 17791 PubChem (substance) 2 247413 247413 12
716869 716869 17791 17791 PubChem (substance) 2 270838 270838 14
716870 716870 17791 17791 PubChem (substance) 2 310147 310147 15
966805 966805 17791 17791 CAS Common Chemistry 3 53255 53255 1
1168719 1168719 17791 17791 Computational Toxicology and Exposure Data 4 130558 130558 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 1252.953ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website