home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 398850

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
218923 218923 398850 398850 PubChem (compound) 1 75111 75111 2
281757 281757 398850 398850 PubChem (compound) 1 79351 79351 1
281759 281759 398850 398850 PubChem (compound) 1 227669 227669 3
281760 281760 398850 398850 PubChem (compound) 1 75111 75111 4
594999 594999 398850 398850 PubChem (substance) 2 75111 75111 2
674578 674578 398850 398850 PubChem (substance) 2 79351 79351 1
674581 674581 398850 398850 PubChem (substance) 2 227669 227669 3
674583 674583 398850 398850 PubChem (substance) 2 75111 75111 6
832628 832628 398850 398850 PubChem (substance) 2 137165 137165 5
832637 832637 398850 398850 PubChem (substance) 2 227817 227817 4
931616 931616 398850 398850 PubChem (substance) 2 234146 234146 7
931617 931617 398850 398850 PubChem (substance) 2 308103 308103 8
931618 931618 398850 398850 PubChem (substance) 2 218887 218887 9
1124199 1124199 398850 398850 CAS Common Chemistry 3 79351 79351 1
1298477 1298477 398850 398850 Computational Toxicology and Exposure Data 4 79351 79351 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 452.924ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website