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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
138622 138622 142243 142243 PubChem (compound) 1 76982 76982 1
162330 162330 142243 142243 PubChem (compound) 1 209563 209563 3
162332 162332 142243 142243 PubChem (compound) 1 137304 137304 4
162334 162334 142243 142243 PubChem (compound) 1 189146 189146 2
162336 162336 142243 142243 PubChem (compound) 1 215545 215545 5
162338 162338 142243 142243 PubChem (compound) 1 255513 255513 6
162340 162340 142243 142243 PubChem (compound) 1 261938 261938 7
162343 162343 142243 142243 PubChem (compound) 1 286565 286565 8
162345 162345 142243 142243 PubChem (compound) 1 334593 334593 9
490323 490323 142243 142243 PubChem (substance) 2 76982 76982 1
521304 521304 142243 142243 PubChem (substance) 2 209563 209563 3
521308 521308 142243 142243 PubChem (substance) 2 137304 137304 4
521311 521311 142243 142243 PubChem (substance) 2 189146 189146 2
521313 521313 142243 142243 PubChem (substance) 2 215545 215545 5
521316 521316 142243 142243 PubChem (substance) 2 255513 255513 7
521319 521319 142243 142243 PubChem (substance) 2 261938 261938 14
521321 521321 142243 142243 PubChem (substance) 2 286565 286565 12
521325 521325 142243 142243 PubChem (substance) 2 334593 334593 15
800042 800042 142243 142243 PubChem (substance) 2 240261 240261 6
800044 800044 142243 142243 PubChem (substance) 2 240621 240621 8
800046 800046 142243 142243 PubChem (substance) 2 274389 274389 9
800047 800047 142243 142243 PubChem (substance) 2 238231 238231 10
800050 800050 142243 142243 PubChem (substance) 2 291127 291127 11
800051 800051 142243 142243 PubChem (substance) 2 176191 176191 13
1056942 1056942 142243 142243 CAS Common Chemistry 3 61839 61839 1
1242140 1242140 142243 142243 Computational Toxicology and Exposure Data 4 76982 76982 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 489.391ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website