home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 110529

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99447 99447 110529 110529 PubChem (compound) 1 14029 14029 1
436280 436280 110529 110529 PubChem (substance) 2 82954 82954 7
436287 436287 110529 110529 PubChem (substance) 2 224754 224754 5
436320 436320 110529 110529 PubChem (substance) 2 14029 14029 1
643220 643220 110529 110529 PubChem (substance) 2 70662 70662 19
691028 691028 110529 110529 PubChem (substance) 2 234164 234164 23
749671 749671 110529 110529 PubChem (substance) 2 137161 137161 2
749681 749681 110529 110529 PubChem (substance) 2 137840 137840 3
749686 749686 110529 110529 PubChem (substance) 2 173779 173779 4
749689 749689 110529 110529 PubChem (substance) 2 309967 309967 20
749691 749691 110529 110529 PubChem (substance) 2 237858 237858 22
749693 749693 110529 110529 PubChem (substance) 2 200214 200214 6
777176 777176 110529 110529 PubChem (substance) 2 205456 205456 8
777177 777177 110529 110529 PubChem (substance) 2 197750 197750 9
777178 777178 110529 110529 PubChem (substance) 2 197751 197751 10
777179 777179 110529 110529 PubChem (substance) 2 197752 197752 11
777180 777180 110529 110529 PubChem (substance) 2 197753 197753 12
777181 777181 110529 110529 PubChem (substance) 2 188091 188091 13
777182 777182 110529 110529 PubChem (substance) 2 177099 177099 14
777185 777185 110529 110529 PubChem (substance) 2 189131 189131 15
777187 777187 110529 110529 PubChem (substance) 2 195410 195410 16
777188 777188 110529 110529 PubChem (substance) 2 177281 177281 17
777189 777189 110529 110529 PubChem (substance) 2 198049 198049 18
777190 777190 110529 110529 PubChem (substance) 2 310661 310661 21
1011596 1011596 110529 110529 CAS Common Chemistry 3 14029 14029 1
1213681 1213681 110529 110529 Computational Toxicology and Exposure Data 4 14029 14029 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 1985.696ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website