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 = 119450

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
139183 139183 119450 119450 PubChem (compound) 1 83293 83293 1
139185 139185 119450 119450 PubChem (compound) 1 160714 160714 2
139188 139188 119450 119450 PubChem (compound) 1 183338 183338 3
139191 139191 119450 119450 PubChem (compound) 1 195674 195674 4
139193 139193 119450 119450 PubChem (compound) 1 169252 169252 5
139194 139194 119450 119450 PubChem (compound) 1 237279 237279 6
139196 139196 119450 119450 PubChem (compound) 1 261729 261729 7
139197 139197 119450 119450 PubChem (compound) 1 308107 308107 8
491053 491053 119450 119450 PubChem (substance) 2 83293 83293 1
491060 491060 119450 119450 PubChem (substance) 2 160714 160714 2
491063 491063 119450 119450 PubChem (substance) 2 183338 183338 3
491067 491067 119450 119450 PubChem (substance) 2 195674 195674 4
491071 491071 119450 119450 PubChem (substance) 2 169252 169252 9
491072 491072 119450 119450 PubChem (substance) 2 237279 237279 6
491074 491074 119450 119450 PubChem (substance) 2 261729 261729 10
491076 491076 119450 119450 PubChem (substance) 2 308107 308107 7
784316 784316 119450 119450 PubChem (substance) 2 264237 264237 5
784317 784317 119450 119450 PubChem (substance) 2 309982 309982 8
1039554 1039554 119450 119450 CAS Common Chemistry 3 83293 83293 1
1242548 1242548 119450 119450 Computational Toxicology and Exposure Data 4 83293 83293 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 846.528ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website