Hello, Below is the help for the Table browser. It includes a query for a search by an identifier and also help for linking tables in the output.
Since your sequence is a RefSeq, then start with the refGene table, paste in your identifiers, and link in other data as desired in the output (selected fields from primary and related tables). You can find out which tables are related by using the "schema" link from either the track description page or from the Table browser. The data format and common keys are noted. All mySQL tables are available in the Downloads are under the assembly in the ?"Annotation Database" link. Or, the ftp location goldenPath/<db>/database. A table name is the same as a file name, with .txt.gz added for the data and .sql added for the schema. Key tables: refGene, kgXref, kgAlias, refLink http://genome.ucsc.edu/goldenPath/help/hgTracksHelp.html#TableBrowser http://genome.ucsc.edu/FAQ/FAQdownloads#download1 And this similar question may be have some pointers helpful for understanding the data and for investigating any missing data points. https://lists.soe.ucsc.edu/pipermail/genome/2009-August/019721.html Good luck, Jennifer ------------------------------------------------ Jennifer Jackson UCSC Genome Bioinformatics Group ----- "Manisha Brahmachary" <[email protected]> wrote: > From: "Manisha Brahmachary" <[email protected]> > To: [email protected] > Sent: Monday, November 9, 2009 9:09:05 AM GMT -08:00 US/Canada Pacific > Subject: [Genome] Urgent query about getting gene names > > Hello, > > > > I will be very obliged if you can send me an answer to the following > queries: > > > > How do I do the following: > > > > I have a list of mRNA IDs such as : NM_014945 and I want to extract > the > official gene symbol such as ABLIM3 for this. > > a. I want to do to this through the tables > > b. also download the appropriate data from the download section to > do the > search separately outside UCSC genome browser. > > > > Thanks > > Manisha > > > > Associate Research Scientist > > 1130 St Nicholas Avenue > > ICRC,Room 802,Columbia University > > New York, NY 10032 > > > > > > > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
