api_results

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

13 rows where query_id = 41346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
80330 80330 41346 41346 PubChem (compound) 1 133511 133511 1
80332 80332 41346 41346 PubChem (compound) 1 61606 61606 2
80333 80333 41346 41346 PubChem (compound) 1 133511 133511 3
409500 409500 41346 41346 PubChem (substance) 2 133511 133511 1
409502 409502 41346 41346 PubChem (substance) 2 61606 61606 4
409503 409503 41346 41346 PubChem (substance) 2 133511 133511 5
410009 410009 41346 41346 PubChem (substance) 2 62522 62522 7
738708 738708 41346 41346 PubChem (substance) 2 277899 277899 2
738709 738709 41346 41346 PubChem (substance) 2 154753 154753 3
738710 738710 41346 41346 PubChem (substance) 2 292701 292701 6
738711 738711 41346 41346 PubChem (substance) 2 260867 260867 8
996934 996934 41346 41346 CAS Common Chemistry 3 61606 61606 1
1199971 1199971 41346 41346 Computational Toxicology and Exposure Data 4 133511 133511 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)
);