[ensembl-dev] Protein feature hit descriptions in older MySQL releases

[Charles Joseph Murphy]

I was looking at the protein_feature.hit_description column for PFAM protein domains. I see there are descriptions for recent releases (e.g. mus_musculus_core_75_38 and homo_sapiens_core_75_37), but not for older releases (e.g. mus_musculus_core_75_38 and homo_sapiens_core_75_37). Instead those older releases just have NULL all protein_feature.hit_description. What is the reason?

Here is an example command I’ am using

mysql -u anonymous -h ensembldb.ensembl.org -e "use homo_sapiens_core_84_38; SELECT translation.translation_id, translation.stable_id, protein_feature.hit_name, protein_feature.seq_start, protein_feature.seq_end, protein_feature.hit_description, analysis.db FROM analysis, analysis_description, protein_feature, translation WHERE protein_feature.translation_id = translation.translation_id AND protein_feature.analysis_id = analysis.analysis_id AND analysis.analysis_id = analysis_description.analysis_id AND analysis.db = 'Pfam';" > pfam_homo_sapiens_core_84_38.txt

Charlie