home / zeropm-v0-0-4

api_results

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

31 rows where query_id = 59783

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99416 99416 59783 59783 PubChem (compound) 1 82954 82954 1
99419 99419 59783 59783 PubChem (compound) 1 224754 224754 2
99423 99423 59783 59783 PubChem (compound) 1 192037 192037 3
99427 99427 59783 59783 PubChem (compound) 1 208696 208696 4
99431 99431 59783 59783 PubChem (compound) 1 239082 239082 5
99435 99435 59783 59783 PubChem (compound) 1 260874 260874 6
99436 99436 59783 59783 PubChem (compound) 1 310252 310252 7
99440 99440 59783 59783 PubChem (compound) 1 320772 320772 8
99441 99441 59783 59783 PubChem (compound) 1 329452 329452 9
99442 99442 59783 59783 PubChem (compound) 1 333211 333211 10
436274 436274 59783 59783 PubChem (substance) 2 82954 82954 1
436281 436281 59783 59783 PubChem (substance) 2 224754 224754 2
436289 436289 59783 59783 PubChem (substance) 2 192037 192037 3
436294 436294 59783 59783 PubChem (substance) 2 208696 208696 5
436298 436298 59783 59783 PubChem (substance) 2 239082 239082 4
436303 436303 59783 59783 PubChem (substance) 2 260874 260874 11
436304 436304 59783 59783 PubChem (substance) 2 310252 310252 9
436308 436308 59783 59783 PubChem (substance) 2 320772 320772 15
436309 436309 59783 59783 PubChem (substance) 2 329452 329452 17
436311 436311 59783 59783 PubChem (substance) 2 333211 333211 18
436315 436315 59783 59783 PubChem (substance) 2 14029 14029 6
749648 749648 59783 59783 PubChem (substance) 2 240597 240597 7
749653 749653 59783 59783 PubChem (substance) 2 82954 82954 8
749657 749657 59783 59783 PubChem (substance) 2 320433 320433 10
749661 749661 59783 59783 PubChem (substance) 2 290044 290044 12
749662 749662 59783 59783 PubChem (substance) 2 270110 270110 13
749667 749667 59783 59783 PubChem (substance) 2 277639 277639 14
749670 749670 59783 59783 PubChem (substance) 2 137161 137161 16
749676 749676 59783 59783 PubChem (substance) 2 82954 82954 19
1011592 1011592 59783 59783 CAS Common Chemistry 3 82954 82954 1
1213679 1213679 59783 59783 Computational Toxicology and Exposure Data 4 82954 82954 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 468.973ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website