api_results

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

11 rows where query_id = 395916

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
103597 103597 395916 395916 PubChem (compound) 1 9243 9243 1
442476 442476 395916 395916 PubChem (substance) 2 120118 120118 3
442483 442483 395916 395916 PubChem (substance) 2 9243 9243 1
617282 617282 395916 395916 PubChem (substance) 2 194773 194773 7
753954 753954 395916 395916 PubChem (substance) 2 136676 136676 2
930345 930345 395916 395916 PubChem (substance) 2 240531 240531 4
930346 930346 395916 395916 PubChem (substance) 2 261872 261872 5
930347 930347 395916 395916 PubChem (substance) 2 190094 190094 6
930348 930348 395916 395916 PubChem (substance) 2 265868 265868 8
1123729 1123729 395916 395916 CAS Common Chemistry 3 9243 9243 1
1337615 1337615 395916 395916 Computational Toxicology and Exposure Data 4 9243 9243 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)
);