Question: How To Know When A Ucsc Annotation Track Has Been Updated
gravatar for User 6659
9.6 years ago by
User 6659970
User 6659970 wrote:

Dear All

How do you know when a UCSC annotation track has been updated or when new tracks have been released. I have looked on the FAQ but I can't see any obvious answers except for the section about when Genbank updates are done. I imagine in some cases it might depend on the specific data source (e.g. dbSNP tracks are probably updated for each dbSNP release). Is there a mailing list or anything equivalent?

thanks a lot

ucsc • 2.0k views
ADD COMMENTlink modified 7.2 years ago by Biostar ♦♦ 20 • written 9.6 years ago by User 6659970
gravatar for Mary
9.6 years ago by
Boston MA area
Mary11k wrote:

You can check the release log.

We've asked in the past for something like an RSS feed of this, but I don't remember that ever coming together.

There are mailing lists of various types. But the "announce" is usually only big things like a whole new species. ENCODE announce sometimes does individual tracks. But not consistently.

Release log is your best best.

Mailing lists:

There's also a mirror list if you maintain a mirror site, probably not relevant--but FYI.

ADD COMMENTlink modified 12 months ago by RamRS30k • written 9.6 years ago by Mary11k

good idea about the RSS, too bad they didn't implement it.

ADD REPLYlink written 9.5 years ago by Giovanni M Dall'Olio27k

thanks mary (and also for the excellent open helix tutorials too which i watched the other week!)

ADD REPLYlink written 9.5 years ago by User 6659970

Yeah, we had people ask us for that in workshops and at a conference, I remember mentioning it to the UCSC team. I'll use this opportunity to mention it again :)

ADD REPLYlink written 9.5 years ago by Mary11k
gravatar for Jennifer Hillman Jackson
9.5 years ago by
Bay Area, CA
Jennifer Hillman Jackson390 wrote:

To add to Mary's great answer, there is a field on each track's description page called "Data last updated:" that may be helpful for those wanting update information directly from the Genome Browser [GB] or database tables.

To web browse/extract this update tag in the GB, and example would be: [?]- UCSC browser [?]- select "Human Feb. 2009 (GRCh37/hg19)" aka hg19 [?]- on the assembly browser page, click on any track name [?]- in the top section, bottom field is "Data last updated:"

Please note that for composite tracks you will need to click into one of the sub-tracks to view the update date, as each is independently created/updated.

A way to retrieve the data in a table/file format is to use the Table Browser [TB] (or direct FTP, or the public mySQL database) and navigate to the database.table == hgFixed.trackVersion. The database, track name, update time, etc. is all there.

The path in the TB is a bit different than a regular database query: [?]- start with any database [?]- select group: all tables, database: hgFixed, and table: hgFixed.trackVersion [?]- download the table

Hopefully this is helpful! [?]jen

ADD COMMENTlink written 9.5 years ago by Jennifer Hillman Jackson390

Excellent--thanks for coming by! I was going to mail this thread to you guys with a request for the RSS feed again. That could be handy way to push that info out to the people who might need to know that.

ADD REPLYlink written 9.5 years ago by Mary11k

hi - i don't know if you are still looking at this question but the table hgFixed.trackVersion seems to give the date when the assembly track e.g. Hg18, hg19 etc was last modified and not the annotation tracks?

ADD REPLYlink written 9.5 years ago by User 6659970

hi i don't know if you are still looking at this question but i'm a bit confused by the database structure. there looks as if there is one database per genome assembly which has tables per annotation tracks (e.g. there are databases hg18, hg19 etc). But what is the hgFixed database? The trackVersion table looks like it contains information for each assembly, not the annotation tracks of an assembly which was what the question was about. Is this correct? Thanks for taking the time to answer this post :)

ADD REPLYlink written 9.5 years ago by User 6659970

Wow - two year later - but to see what the table contains, click on "describe table schema" (once you have navigated to it). The top of the page has the schema, sample rows will be underneath. There are multiple rows per database, one per track, tagged by date the data was loaded along with other comments (data author, etc.). The database "hgFixed" is a global database - it spans across assemblies/genomes. One way to understand it is to pick a small region and download a slice - is a 9 column tab file (if you count the bin/index leading field). - J

ADD REPLYlink written 7.5 years ago by Jennifer Hillman Jackson390
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1583 users visited in the last hour