I'm trying to retrieve the canonical transcript for each genes using ensembldb package. In the ensembl database there is a fiel canonical transcript in the gene table, which redirect you to the disered row in the transcript table. Therefore it is easy to obtain canonical transcript for each gene. But using ensembldb, I can't find that fiel "canonical transcript or any other way to retrieve the desired information (canonical transcript). Does someone know if there is such an "easy way" to obtain the answer ?
For the moment, based on the ensembldb I made a script implementing the procedure to compute the canonical transcript (as described on the ensembl website), it works, but is not as efficient as simply joining two tables.
Thanks in advance