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

[Robert Kuhn]

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
>