api_results

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

13 rows where inchi_id = 4158

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
141583 141583 121660 121660 PubChem (compound) 1 4158 4158 1
141584 141584 408785 408785 PubChem (compound) 1 4158 4158 1
141585 141585 121659 121659 PubChem (compound) 1 4158 4158 1
494124 494124 408785 408785 PubChem (substance) 2 4158 4158 1
494125 494125 121659 121659 PubChem (substance) 2 4158 4158 1
494126 494126 54560 54560 PubChem (substance) 2 4158 4158 4
494127 494127 121660 121660 PubChem (substance) 2 4158 4158 1
1041420 1041420 121659 121659 CAS Common Chemistry 3 4158 4158 1
1041421 1041421 121660 121660 CAS Common Chemistry 3 4158 4158 1
1041422 1041422 408785 408785 CAS Common Chemistry 3 4158 4158 1
1244375 1244375 408785 408785 Computational Toxicology and Exposure Data 4 4158 4158 1
1244376 1244376 121659 121659 Computational Toxicology and Exposure Data 4 4158 4158 1
1244377 1244377 121660 121660 Computational Toxicology and Exposure Data 4 4158 4158 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)
);