api_results

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

14 rows where query_id = 337342

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22012 22012 337342 337342 PubChem (compound) 1 56071 56071 1
327217 327217 337342 337342 PubChem (substance) 2 56071 56071 1
347151 347151 337342 337342 PubChem (substance) 2 34121 34121 2
355231 355231 337342 337342 PubChem (substance) 2 66787 66787 7
479147 479147 337342 337342 PubChem (substance) 2 34120 34120 6
708096 708096 337342 337342 PubChem (substance) 2 56071 56071 3
910869 910869 337342 337342 PubChem (substance) 2 206057 206057 4
910871 910871 337342 337342 PubChem (substance) 2 172506 172506 5
910873 910873 337342 337342 PubChem (substance) 2 148613 148613 8
910875 910875 337342 337342 PubChem (substance) 2 188332 188332 9
954435 954435 337342 337342 CAS Common Chemistry 3 56071 56071 2
964402 964402 337342 337342 CAS Common Chemistry 3 34121 34121 1
1154062 1154062 337342 337342 Computational Toxicology and Exposure Data 4 56071 56071 2
1165999 1165999 337342 337342 Computational Toxicology and Exposure Data 4 94314 94314 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)
);