I wonder if there is a smart way to retrieve the codon tables for all sequences from all contigs/scaffolds/chromosomes for all genomes from Ensembl and EnsemblGenomes databases. I suppose that all sequences from this same chromosome share the same codon table. Consequently, the question means that I need to have all contigs/scaffolds/chromosomes with their corresponding NCBI genetic codes number ( https://www.ncbi.nlm.nih.gov/Taxonomy/Utils/wprintgc.cgi ).
I realise that for a specific sequence, using MySQL database search might work. But I hope to obtain all the information for all genomes, which seems impossible to get it done through MySQL query.