api_results

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

11 rows where query_id = 25802

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
56781 56781 25802 25802 PubChem (compound) 1 111793 111793 1
336493 336493 25802 25802 PubChem (substance) 2 670 670 7
358885 358885 25802 25802 PubChem (substance) 2 117376 117376 4
376050 376050 25802 25802 PubChem (substance) 2 111793 111793 1
518661 518661 25802 25802 PubChem (substance) 2 55405 55405 5
725359 725359 25802 25802 PubChem (substance) 2 57513 57513 2
725360 725360 25802 25802 PubChem (substance) 2 248147 248147 3
725361 725361 25802 25802 PubChem (substance) 2 146691 146691 6
725363 725363 25802 25802 PubChem (substance) 2 296588 296588 8
979691 979691 25802 25802 CAS Common Chemistry 3 57513 57513 1
1182584 1182584 25802 25802 Computational Toxicology and Exposure Data 4 111793 111793 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)
);