Skip to main content
Schema for ucscRetroAli5
  Database: hg19    Primary Table: ucscRetroAli5    Row Count: 13,742   Data last updated: 2013-03-12
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
matches 2032int(10) unsigned range Number of bases that match that aren't repeats
misMatches 25int(10) unsigned range Number of bases that don't match
repMatches 0int(10) unsigned range Number of bases that match but are part of repeats
nCount 0int(10) unsigned range Number of 'N' bases
qNumInsert 0int(10) unsigned range Number of inserts in query
qBaseInsert 0int(10) unsigned range Number of bases inserted in query
tNumInsert 0int(10) unsigned range Number of inserts in target
tBaseInsert 0int(10) unsigned range Number of bases inserted in target
strand -char(2) values + or - for strand. First character query, second target (optional)
qName AK021903.1-1varchar(255) values Query sequence name
qSize 2057int(10) unsigned range Query sequence size
qStart 0int(10) unsigned range Alignment start position in query
qEnd 2057int(10) unsigned range Alignment end position in query
tName chr1varchar(255) values Target sequence name
tSize 249250621int(10) unsigned range Target sequence size
tStart 87548int(10) unsigned range Alignment start position in target
tEnd 89605int(10) unsigned range Alignment end position in target
blockCount 1int(10) unsigned range Number of blocks in alignment
blockSizes 2057,longblob   Size of each block
qStarts 0,longblob   Start of each block in query.
tStarts 87548,longblob   Start of each block in target.

To download this table in different text formats or to intersect or correlate it with other tables, use the Table Browser.

Connected Tables and Joining Fields
        hg19.ucscRetroCds5.id (via ucscRetroAli5.qName)
      hg19.ucscRetroExpressed5.name (via ucscRetroAli5.qName)
      hg19.ucscRetroInfo5.name (via ucscRetroAli5.qName)
      hg19.ucscRetroOrtho5.name (via ucscRetroAli5.qName)
      hg19.ucscRetroSeq5.acc (via ucscRetroAli5.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
585203225000000-AK021903.1-1205702057chr1249250621875488960512057,0,87548,
732588471000000+NM_015125.3-1547305471chr12492506211310671348364732,28,87,12,246,220,35,95,33,67,112,59,176,7,93,79,92,61,27,112,149,233,21,47,56,7,9,7,7,8,12,11,28,12,6,36,66,53,45,52,22,11,9, ...0,33,70,160,188,435,655,690,788,847,914,1034,1094,1278,1286,1380,1461,1554,1617,1644,1757,4198,4432,4454,4502,4558,4565,4574,458 ...131067,131099,131127,131214,131226,131472,131693,131733,131828,131861,131929,132041,132100,132276,132283,132376,132455,132547,13 ...
58648043000000-AK130965.1-15382538chr1249250621228262228787623,47,48,290,86,29,0,29,77,128,418,507,228262,228285,228332,228380,228672,228758,
58662624000000-AK021903.1-3205701614chr12492506212355162361662198,452,443,1605,235516,235714,
5872404000000+AK302511.1-142066342972chr1249250621321020321264211,233,342,739,321020,321031,
587419131000000-BC018677.1-41161156724chr12492506213214383220241620,40,7,14,32,6,104,33,17,85,35,8,60,23,53,13,437,457,501,509,523,557,563,669,702,719,805,840,848,909,939,992,321438,321473,321513,321520,321535,321567,321578,321682,321716,321734,321819,321859,321869,321929,321952,322011,
587167098000000+BC054485.1-3021382252073chr12492506213265843284121336,31,23,20,30,11,13,7,27,4,12,169,1385,225,268,299,322,358,389,400,413,420,447,457,470,688,326584,326620,326662,326689,326709,326739,326766,326785,326812,326842,326846,326858,327027,
5872595464000000-NM_015125.3-2547305471chr124925062132851733228246404,17,40,18,8,34,52,45,53,66,36,6,12,28,11,12,8,7,7,9,7,56,47,21,233,149,112,27,61,92,79,93,7,176,59,112,67,33,95,35,220,246,12 ...2,418,443,483,501,509,543,598,644,698,772,808,814,826,854,865,877,885,892,899,908,915,972,1020,1042,3567,3717,3829,3858,3920,401 ...328517,328921,328938,329218,329281,329318,329365,329417,329462,329515,329581,329643,329652,329719,329786,329829,329848,329876,32 ...
58737855000000-AK308843.1-113600448chr1249250621379128379568587,124,128,54,40,912,1005,1129,1266,1320,379128,379215,379342,379470,379528,
58843536000000+AK312123.1-24842478chr1249250621470895471368529,86,152,188,16,2,34,120,273,462,470895,470924,471012,471164,471352,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.

Retroposed Genes (ucscRetroAli5) Track Description
 

Description

Retrotransposition is a process involving the copying of DNA by a group of enzymes that have the ability to reverse transcribe spliced mRNAs, resulting in single-exon copies of genes and sometime chimeric genes. RetroGenes can be either functional genes that have acquired a promoter from a neighboring gene, non-functional pseudogenes, or transcribed pseudogenes.

Methods

All mRNAs of a species from GenBank were aligned to the genome using lastz (Miller lab, Pennsylvania State University). mRNAs that aligned twice in the genome (once with introns and once without introns) were initially screened. Next, a series of features were scored to determine candidates for retrotransposition events. These features included position and length of the polyA tail, degree of synteny with mouse, coverage of repetitive elements, number of exons that can still be aligned to the retrogene and degree of divergence from the parent gene. Retrogenes were classified using a threshold score function that is a linear combination of this set of features. Retrogenes in the final set were selected using a score threshold based on a ROC plot against the Vega annotated pseudogenes.

Retrogene Statistics table:

  • Expression of Retrogene: The following values are possible where those that are not expressed are classed as pseudogene or mrna:
    • pseudogene indicates that the parent gene has been annotated by one of NCBI's RefSeq, UCSC Genes or Mammalian Gene Collection (MGC).
    • mrna indicates that the parent gene is a spliced mrna that has no annotation in NCBI's RefSeq, UCSC Genes or Mammalian Gene Collection (MGC). Therefore, the retrogene is a product of a potentially non-annotated parent gene and is a putative pseudogene of that putative parent gene.
    • expressed weak indicates that there is a mRNA overlapping the retrogene, indicating possible transcription. noOrf indicates that an ORF was not identified by BESTORF.
    • expressed indicates that there is a medium level of mRNAs/ESTs mapping to the retrogene locus, indicating possible transcription.
    • expressed strong indicates that there is a mRNA overlapping the retrogene, and at least five spliced ESTs indicating probable transcription. noOrf indicates that an ORF was not identified by BESTORF.
    • expressed shuffle indicates that the retrogene was inserted into a pre-existing annotated gene.
  • Score: Based on features of the potential retrogene.
  • Percent Gene Alignment Coverage (Bases Matching Parent): Shows the percentage of the parent gene aligning to this region.
  • Intron Count: Number of introns is the number of gaps in the alignment between the parent mRNA and the genome where gaps are >80 bp and the ratio of the mRNA alignment gap to the genome alignment gap is less than 30% after removing repeats.
  • Gap Count: Numer of gaps in the alignment of between the parent mRNA and the genome after removing repeats. Gaps are not counted if the gap on the mRNA side of the alignment is a similar size to the gap in the genome alignment.
  • BESTORF Score: BESTORF (written by Victor Solovyev) predicts potential open reading frames (ORFs) in mRNAs/ESTs with very high accuracy using a Markov chain model of coding regions and a probabilistic model of translation start codon potential. The score threshold for finding an ORF is 50 (Jim Kent, personal communication).

Break in Orthology table:

Retrogenes inserted into the genome since the human/mouse divergence show a break in the mouse genome syntenic net alignments to the human genome. The percentage break represents the portion of the genome that is missing in each species relative to the reference genome (human hg19) at the retrogene locus as defined by syntenic alignment nets. Breaks in orthology with mouse and dog tend to be due to genomic insertions in the primate lineage. Relative orthology of dog/human and rhesus macque/human nets are used to avoid false positives due to deletions in the mouse genome. Older retrogenes will not show a break in orthology, so this feature is weighted lower than other features when scoring putative retrogenes.

These features can be downloaded from the table retroMrnaInfo in many formats using the Table Browser option from the Tools menu in the top blue navigation bar.

Credits

The RetroFinder program and browser track were developed by Robert Baertsch at UCSC.

References

Baertsch R, Diekhans M, Kent WJ, Haussler D, Brosius J. Retrocopy contributions to the evolution of the human genome. BMC Genomics. 2008 Oct 8;9:466. PMID: 18842134; PMC: PMC2584115

Kent WJ, Baertsch R, Hinrichs A, Miller W, Haussler D. Evolution's cauldron: duplication, deletion, and rearrangement in the mouse and human genomes. Proc Natl Acad Sci U S A. 2003 Sep 30;100(20):11484-9. PMID: 14500911; PMC: PMC208784

Pei B, Sisu C, Frankish A, Howald C, Habegger L, Mu XJ, Harte R, Balasubramanian S, Tanzer A, Diekhans M et al. The GENCODE pseudogene resource. Genome Biol. 2012 Sep 26;13(9):R51. PMID: 22951037; PMC: PMC3491395

Schwartz S, Kent WJ, Smit A, Zhang Z, Baertsch R, Hardison RC, Haussler D, Miller W. Human-mouse alignments with BLASTZ. Genome Res. 2003 Jan;13(1):103-7. PMID: 12529312; PMC: PMC430961

Zheng D, Frankish A, Baertsch R, Kapranov P, Reymond A, Choo SW, Lu Y, Denoeud F, Antonarakis SE, Snyder M et al. Pseudogenes in the ENCODE regions: consensus annotation, analysis of transcription, and evolution. Genome Res. 2007 Jun;17(6):839-51. PMID: 17568002; PMC: PMC1891343