home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 16876

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
36807 36807 16876 16876 PubChem (compound) 1 44373 44373 1
36812 36812 16876 16876 PubChem (compound) 1 44373 44373 2
36816 36816 16876 16876 PubChem (compound) 1 343947 343947 3
36817 36817 16876 16876 PubChem (compound) 1 234413 234413 4
36818 36818 16876 16876 PubChem (compound) 1 234413 234413 5
348328 348328 16876 16876 PubChem (substance) 2 44373 44373 1
348336 348336 16876 16876 PubChem (substance) 2 44373 44373 2
348342 348342 16876 16876 PubChem (substance) 2 343947 343947 6
348343 348343 16876 16876 PubChem (substance) 2 234413 234413 15
348344 348344 16876 16876 PubChem (substance) 2 234413 234413 14
435397 435397 16876 16876 PubChem (substance) 2 185065 185065 4
648549 648549 16876 16876 PubChem (substance) 2 192592 192592 5
651508 651508 16876 16876 PubChem (substance) 2 192592 192592 3
651513 651513 16876 16876 PubChem (substance) 2 185632 185632 16
715450 715450 16876 16876 PubChem (substance) 2 289169 289169 7
715452 715452 16876 16876 PubChem (substance) 2 241008 241008 8
715453 715453 16876 16876 PubChem (substance) 2 259965 259965 9
715456 715456 16876 16876 PubChem (substance) 2 185065 185065 10
715460 715460 16876 16876 PubChem (substance) 2 241008 241008 11
715463 715463 16876 16876 PubChem (substance) 2 310196 310196 12
715465 715465 16876 16876 PubChem (substance) 2 330200 330200 13
965014 965014 16876 16876 CAS Common Chemistry 3 44373 44373 1
1166674 1166674 16876 16876 Computational Toxicology and Exposure Data 4 44373 44373 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 722.602ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website