home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 362002

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21374 21374 362002 362002 PubChem (compound) 1 45333 45333 1
326012 326012 362002 362002 PubChem (substance) 2 45333 45333 1
694670 694670 362002 362002 PubChem (substance) 2 232032 232032 4
694674 694674 362002 362002 PubChem (substance) 2 232033 232033 5
694682 694682 362002 362002 PubChem (substance) 2 232034 232034 6
694687 694687 362002 362002 PubChem (substance) 2 149542 149542 7
694691 694691 362002 362002 PubChem (substance) 2 232035 232035 8
706884 706884 362002 362002 PubChem (substance) 2 182692 182692 2
706887 706887 362002 362002 PubChem (substance) 2 208438 208438 3
771939 771939 362002 362002 PubChem (substance) 2 232037 232037 10
775814 775814 362002 362002 PubChem (substance) 2 232038 232038 11
775817 775817 362002 362002 PubChem (substance) 2 230850 230850 12
840312 840312 362002 362002 PubChem (substance) 2 232036 232036 9
840316 840316 362002 362002 PubChem (substance) 2 232039 232039 13
840319 840319 362002 362002 PubChem (substance) 2 232040 232040 14
840321 840321 362002 362002 PubChem (substance) 2 232041 232041 15
840323 840323 362002 362002 PubChem (substance) 2 232042 232042 16
840325 840325 362002 362002 PubChem (substance) 2 169903 169903 17
953957 953957 362002 362002 CAS Common Chemistry 3 45333 45333 1
1153425 1153425 362002 362002 Computational Toxicology and Exposure Data 4 45333 45333 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 488.63ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website