home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 142242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
138621 138621 142242 142242 PubChem (compound) 1 76982 76982 1
162329 162329 142242 142242 PubChem (compound) 1 209563 209563 2
162331 162331 142242 142242 PubChem (compound) 1 137304 137304 3
162333 162333 142242 142242 PubChem (compound) 1 189146 189146 4
162335 162335 142242 142242 PubChem (compound) 1 215545 215545 5
162337 162337 142242 142242 PubChem (compound) 1 255513 255513 6
162339 162339 142242 142242 PubChem (compound) 1 261938 261938 7
162341 162341 142242 142242 PubChem (compound) 1 195184 195184 8
162342 162342 142242 142242 PubChem (compound) 1 286565 286565 9
162344 162344 142242 142242 PubChem (compound) 1 334593 334593 10
490319 490319 142242 142242 PubChem (substance) 2 76982 76982 1
521303 521303 142242 142242 PubChem (substance) 2 209563 209563 2
521305 521305 142242 142242 PubChem (substance) 2 137304 137304 3
521312 521312 142242 142242 PubChem (substance) 2 189146 189146 5
521314 521314 142242 142242 PubChem (substance) 2 215545 215545 6
521315 521315 142242 142242 PubChem (substance) 2 255513 255513 7
521318 521318 142242 142242 PubChem (substance) 2 261938 261938 10
521320 521320 142242 142242 PubChem (substance) 2 195184 195184 14
521323 521323 142242 142242 PubChem (substance) 2 286565 286565 15
521324 521324 142242 142242 PubChem (substance) 2 334593 334593 16
745168 745168 142242 142242 PubChem (substance) 2 286558 286558 11
800041 800041 142242 142242 PubChem (substance) 2 240261 240261 4
800043 800043 142242 142242 PubChem (substance) 2 240621 240621 8
800045 800045 142242 142242 PubChem (substance) 2 274389 274389 9
800048 800048 142242 142242 PubChem (substance) 2 238231 238231 12
800049 800049 142242 142242 PubChem (substance) 2 291127 291127 13
1056941 1056941 142242 142242 CAS Common Chemistry 3 61839 61839 1
1259534 1259534 142242 142242 Computational Toxicology and Exposure Data 4 61839 61839 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 1313.736ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website