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
