<p>I have a long list of Ensembl IDs and am completely unfamiliar with the Ensembl browser. I want to convert these guys to Refseq IDs using the UCSC table browser, mySQL, or some other tool. So given a list like this:</p>

<pre><code>ENSG00000197021
ENSG00000204379
</code></pre>

<p>How do I turn them into this? </p>

<pre><code>CXorf40B
XAGE1A
</code></pre>

<p>I gather from what I've tried that there are not 1-to-1 mappings for Ensembl gene IDs to RefSeq names, but I'd like to be wrong. At a minimum, I'd like to get the hg18 or hg19 coordinates for a list of these genes, but Biomart only comes back with about 3/4 of them. Any help?</p>

using the public mysql server of UCSC:

    mysql  --user=genome --host=genome-mysql.cse.ucsc.edu -A -D hg19
    mysql> select distinct G.gene,N.value from ensGtp as G, ensemblToGeneName as N where 
      G.transcript=N.name and
      G.gene in ("ENSG00000197021", "ENSG00000204379") ;
    +-----------------+----------+
    | gene            | value    |
    +-----------------+----------+
    | ENSG00000197021 | CXorf40B | 
    | ENSG00000204379 | XAGE1A   | 
    +-----------------+----------+
    2 rows in set (0.21 sec)