Hi Eric, Max is right -- most of the information you are looking for is in the trackDb and grp tables in each assembly database. There is a bit more in the hgcentral database. Take a look at the clade, genomeClade, and dbDb tables there.
-- Brooke Rhead UCSC Genome Bioinformatics Group On 02/14/11 14:10, Maximilian Haussler wrote: > Hi Eric, > > this integration into savant sounds like a very cool idea! A lot more > convenient than having to download tracks as bed files all the time... > > Have a look into the trackDb table and the grp table and - I think - > you will find all the information that you are looking for: > trackDb.tableName - name of mysql table > trackDb.shortLabel . trackDb.longLabel - descriptions > trackDb.grp - index into the grp table which contains descriptions for > track groups. > > Please don't hesitate to email the list again if this doesn't answer > your question. > > cheers > Max > > > > > On Mon, Feb 14, 2011 at 9:41 PM, Eric J. M. Smith > <[email protected]> wrote: >> Greetings, >> >> I'm developing a plugin for the Savant genome browser to allow it to >> access SQL data directly. Naturally, the most useful SQL database is >> the one at UCSC, so I want the plugin to work with that. Everything >> seems to work well enough, but I would like to make the experience a >> little friendlier for end-users. >> >> In particular, when a user goes to UCSC's table browser web-page, the >> tracks are grouped together nicely (e.g. "Mapping and Sequencing >> Tracks", "Genes and Gene Prediction Tracks", etc.), and each of the >> tracks has a human-friendly name (e.g. "RefSeq Genes"). Is this >> information stored in the publicly-accessible MySQL database? I would >> like to present the user with friendly track names and a hierarchy >> similar to the table browser page, but given the information I can >> retrieve from MySQL, all I can give them is a long list of >> cryptically-named SQL tables. >> >> Am I overlooking something within the MySQL database? Or is the >> information which provides the hierarchy and the friendly names coming >> from outside of MySQL? >> >> Thanks, >> >> Eric Smith >> University of Toronto >> _______________________________________________ >> Genome maillist - [email protected] >> https://lists.soe.ucsc.edu/mailman/listinfo/genome >> > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
