home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 323202

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14144 14144 323202 323202 PubChem (compound) 1 75177 75177 1
315572 315572 323202 323202 PubChem (substance) 2 75177 75177 1
380767 380767 323202 323202 PubChem (substance) 2 75665 75665 17
382407 382407 323202 323202 PubChem (substance) 2 274 274 12
383629 383629 323202 323202 PubChem (substance) 2 123602 123602 5
440296 440296 323202 323202 PubChem (substance) 2 241343 241343 13
444916 444916 323202 323202 PubChem (substance) 2 7710 7710 9
450992 450992 323202 323202 PubChem (substance) 2 77231 77231 11
457045 457045 323202 323202 PubChem (substance) 2 12920 12920 3
496279 496279 323202 323202 PubChem (substance) 2 192032 192032 14
570025 570025 323202 323202 PubChem (substance) 2 168956 168956 18
702573 702573 323202 323202 PubChem (substance) 2 75177 75177 2
727197 727197 323202 323202 PubChem (substance) 2 186046 186046 4
727200 727200 323202 323202 PubChem (substance) 2 188379 188379 6
727203 727203 323202 323202 PubChem (substance) 2 188380 188380 7
727206 727206 323202 323202 PubChem (substance) 2 284659 284659 8
727209 727209 323202 323202 PubChem (substance) 2 139279 139279 10
727212 727212 323202 323202 PubChem (substance) 2 140716 140716 15
727222 727222 323202 323202 PubChem (substance) 2 233012 233012 16
948708 948708 323202 323202 CAS Common Chemistry 3 75177 75177 1
1147264 1147264 323202 323202 Computational Toxicology and Exposure Data 4 75177 75177 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 871.823ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website