home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 113791

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133134 133134 113791 113791 PubChem (compound) 1 47316 47316 1
133140 133140 113791 113791 PubChem (compound) 1 137097 137097 2
133142 133142 113791 113791 PubChem (compound) 1 138091 138091 3
133144 133144 113791 113791 PubChem (compound) 1 176453 176453 4
133147 133147 113791 113791 PubChem (compound) 1 178079 178079 5
133148 133148 113791 113791 PubChem (compound) 1 206692 206692 6
133149 133149 113791 113791 PubChem (compound) 1 173445 173445 7
133151 133151 113791 113791 PubChem (compound) 1 237381 237381 8
133153 133153 113791 113791 PubChem (compound) 1 237392 237392 9
482603 482603 113791 113791 PubChem (substance) 2 45859 45859 8
483041 483041 113791 113791 PubChem (substance) 2 47316 47316 1
483048 483048 113791 113791 PubChem (substance) 2 137097 137097 2
483050 483050 113791 113791 PubChem (substance) 2 138091 138091 4
483053 483053 113791 113791 PubChem (substance) 2 176453 176453 5
483055 483055 113791 113791 PubChem (substance) 2 178079 178079 3
483056 483056 113791 113791 PubChem (substance) 2 206692 206692 6
483057 483057 113791 113791 PubChem (substance) 2 173445 173445 7
483059 483059 113791 113791 PubChem (substance) 2 237381 237381 13
483060 483060 113791 113791 PubChem (substance) 2 237392 237392 12
496476 496476 113791 113791 PubChem (substance) 2 196023 196023 9
516631 516631 113791 113791 PubChem (substance) 2 154746 154746 11
780419 780419 113791 113791 PubChem (substance) 2 320995 320995 10
1034846 1034846 113791 113791 CAS Common Chemistry 3 47316 47316 1
1237820 1237820 113791 113791 Computational Toxicology and Exposure Data 4 47316 47316 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 1616.37ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website