api_results

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

12 rows where query_id = 358428

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
35734 35734 358428 358428 PubChem (compound) 1 30754 30754 1
313737 313737 358428 358428 PubChem (substance) 2 3517 3517 2
346746 346746 358428 358428 PubChem (substance) 2 30754 30754 1
366643 366643 358428 358428 PubChem (substance) 2 30594 30594 6
398337 398337 358428 358428 PubChem (substance) 2 30094 30094 3
402297 402297 358428 358428 PubChem (substance) 2 39265 39265 4
563172 563172 358428 358428 PubChem (substance) 2 39624 39624 5
714817 714817 358428 358428 PubChem (substance) 2 233966 233966 7
714819 714819 358428 358428 PubChem (substance) 2 209095 209095 8
714821 714821 358428 358428 PubChem (substance) 2 136518 136518 9
964199 964199 358428 358428 CAS Common Chemistry 3 30754 30754 1
1165772 1165772 358428 358428 Computational Toxicology and Exposure Data 4 30754 30754 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)
);