Ensembl QA: Difference between revisions

From Genecats
Jump to navigationJump to search
No edit summary
(clarified the moving of lines in the trackVersion table based on steve, hiram, and pauline's input)
Line 12: Line 12:


*To get the links to go to the correct place at Ensembl, you will have to check for the appropriate rows in trackVersion table in hgFixed database
*To get the links to go to the correct place at Ensembl, you will have to check for the appropriate rows in trackVersion table in hgFixed database
**Basically, lines from trackVersion need to be copied over into the hgFixed database on beta and the RR. Do this as you push the tables along. In the end, ask for a push of the hgFixed.trackVersion table from hgwbeta to the RR.
**Lines from hgFixed.trackVersion on hgwdev need to be copied over to the hgFixed.trackVersion table on mysqlbeta. Do this when you push the tables. The latest entry should have "current" in the dateReference field and the previous entry needs to have the dateReference field updated to whatever month the last Ensembl release was dated.
**You can also manipulate the dates so the current version says 'current'. However, that does not seem to be a rule.
**When you push the track to the RR, the entire hgFixed.trackVersion table can be pushed from mysqlbeta to mysqlrr.


* '''New: You also need to update the [[blastTabs]] if the zebrafish assembly used in hgGene got new Ensembl Genes. Talk to Brooke or Mary if this is case.'''
* '''New: You also need to update the [[blastTabs]] if the zebrafish assembly used in hgGene got new Ensembl Genes. Talk to Brooke or Mary if this is case.'''

Revision as of 00:10, 29 August 2012

There are periodic updates to all Ensembl Genes tracks in all dbs. Here is a list of things to do in addition to the regular QA you would do normally for a track:

  • Run qaEnsGenes.csh
    • Run it before you push to beta, as it compares dev to beta. You'll lose that comparison if you push too soon.
  • All Ensembl builds are documented in the single file:
   src/hg/makeDb/doc/makeEnsembl.txt
  • You can find all ensembl gene builds in:
   /hive/data/genomes/<db>/bed/ensGene.NN/
where NN is the ensembl version number.
  • To get the links to go to the correct place at Ensembl, you will have to check for the appropriate rows in trackVersion table in hgFixed database
    • Lines from hgFixed.trackVersion on hgwdev need to be copied over to the hgFixed.trackVersion table on mysqlbeta. Do this when you push the tables. The latest entry should have "current" in the dateReference field and the previous entry needs to have the dateReference field updated to whatever month the last Ensembl release was dated.
    • When you push the track to the RR, the entire hgFixed.trackVersion table can be pushed from mysqlbeta to mysqlrr.
  • New: You also need to update the blastTabs if the zebrafish assembly used in hgGene got new Ensembl Genes. Talk to Brooke or Mary if this is case.