Integrating pharmacogenomics and cheminformatics with diverse disease phenotypes for cell type-guided drug discovery