api_results

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

13 rows where inchi_id = 46415

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
157218 157218 137106 137106 PubChem (compound) 1 46415 46415 1
157219 157219 137105 137105 PubChem (compound) 1 46415 46415 1
157220 157220 238110 238110 PubChem (compound) 1 46415 46415 1
514635 514635 38456 38456 PubChem (substance) 2 46415 46415 2
514636 514636 137106 137106 PubChem (substance) 2 46415 46415 1
514637 514637 238110 238110 PubChem (substance) 2 46415 46415 1
514638 514638 137105 137105 PubChem (substance) 2 46415 46415 1
1053165 1053165 238110 238110 CAS Common Chemistry 3 46415 46415 1
1053166 1053166 137105 137105 CAS Common Chemistry 3 46415 46415 1
1053167 1053167 137106 137106 CAS Common Chemistry 3 46415 46415 1
1255890 1255890 137105 137105 Computational Toxicology and Exposure Data 4 46415 46415 1
1255891 1255891 137106 137106 Computational Toxicology and Exposure Data 4 46415 46415 1
1255892 1255892 238110 238110 Computational Toxicology and Exposure Data 4 46415 46415 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)
);