[Genome] Mapping GenomeBrowser assembly names to official assembly names.

[Robert Kuhn]

Hi, again, Chris,

A colleague reminded me that we also have this information
on a page in our FAQs:

 http://genome.ucsc.edu/FAQ/FAQreleases#release1

best,

			--b0b

 
> From genome-bounces at soe.ucsc.edu  Thu Dec 13 09:31:12 2007
> To: chris.wilton at bbsrc.ac.uk, genome at soe.ucsc.edu
> Subject: Re: [Genome] Mapping GenomeBrowser assembly names to official
> 	assembly names.
> 
> Chris, 
> 
> If you wish to do the mapping one-by-one, simply using the pulldown 
> menu on the hgGateway page (http://genome.ucsc.edu/cgi-bin/hgGateway) 
> will give you this information in the pale blue bar just below the 
> navigation controls.
> 
> As the Table Browser is assembly-driven, the global metadata tables
> are not accessible from there.  
> 
> The simplest way to get this information in bulk, is to directly query 
> the dbDb table in the hgcentral database on our public mysql server:
> 
> > mysql -h genome-mysql -u genome -e "SELECT name, sourceName FROM dbDb WHERE name LIKE 'mm%' ORDER BY name" hgcentral
> +------+---------------+
> | name | sourceName    |
> +------+---------------+
> | mm3  | NCBI Build 30 |
> | mm5  | NCBI Build 33 |
> | mm6  | NCBI Build 34 |
> | mm7  | NCBI Build 35 |
> | mm8  | NCBI Build 36 |
> | mm9  | NCBI Build 37 |
> +------+---------------+
> 
> Or you could grab the entire hgcentral database from the download server and
> use the table in your own database:
> 
>  http://hgdownload.cse.ucsc.edu/admin/hgcentral.sql
> 
> bet wishes,
> 
> 			--b0b kuhn
> 
> > From genome at soe.ucsc.edu  Thu Dec 13 08:00:16 2007
> > To: <genome at soe.ucsc.edu>
> > Subject: [Genome] Mapping GenomeBrowser assembly names to official assembly
> > 	names.
> > 
> > Hi,
> > 
> > Do you have information anywhere in your database that would enable me
> > to map GenomeBrowser assembly names such as mm9 to the original assembly
> > name of the source, as found in Ensembl?
> > 
> > Thanks,
> > Chris
> > 
> > 
> > ==================
> > Christopher Wilton
> > Bioinformatics Group
> > The Forum
> > Babraham Research Campus
> > Cambridge
> > CB22 3AT
> > 
> > Office: +44 (0)1223496104
> > Mobile: +44 (0)7929864279
> > 
> > The Babraham Institute
> > (Registered Charity No. 1053902. Registered in England and Wales No.
> > 3011737 as a company limited by guarantee.  Registered office: Babraham
> > Hall, Babraham Research Campus, Cambridge CB22 3AT)
> > 
> > The information transmitted in this email is directed only to the person
> > to whom it is addressed and may contain confidential and/or privileged
> > material. It should not be read, copied, disclosed or used by any person
> > other than the intended recipient. Any review, retransmission,
> > dissemination or other use of, or taking of any action in reliance upon
> > this information by persons or entities other than the intended
> > recipient is forbidden and may be unlawful. If you received this in
> > error, please contact the sender and delete the material from any
> > digital recovery source or other databases.
> >  
> > The contents of this e-mail are the views of the sender and do not
> > necessarily represent the views of the Babraham Institute or the BBSRC.
> > 
> > Although we have taken steps to check that this e-mail and attachments
> > are free from any virus, we advise that in keeping with good computing
> > practice the recipient should also ensure they are actually virus free.
> > 
> > 
> > _______________________________________________
> > Genome maillist  -  Genome at soe.ucsc.edu
> > http://www.soe.ucsc.edu/mailman/listinfo/genome
> > 
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome
>