Hi Kathleen,
It is on our (long!) list of feature requests to add table timestamps to
the Table Browser display, so that the date that the data in a table was
last changed can be easily seen. In the meantime, however, there are a
couple of ways you can get this information:
1) Many tracks have a "Data last updated" line on their configuration
page. This will tell you the date that the main table for a track
("knownGene" in the case of the UCSC Genes track). This is usually
nearly the same as related tables in the track.
2) Use the public MySQL server to get information about the table.
Instructions for accessing our MySQL server are here:
http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29
You can then look at the table status for any table you are interested
in. For example, if you are trying to find the update time of the
hg19.keggPathway table, do:
mysql> select Update_time FROM information_schema.TABLES WHERE
table_name like 'keggPathway' and table_schema='hg19';
+---------------------+
| Update_time |
+---------------------+
| 2012-01-30 13:04:57 |
+---------------------+
1 row in set (0.36 sec)
I hope this is helpful. f you have further questions, please contact us
again at [email protected].
--
Brooke Rhead
UCSC Genome Bioinformatics Group
On 7/27/12 8:53 AM, kathleen askland wrote:
> Hello,
> I have downloaded a dataset consisting of a linked table matching UCSC gene
> IDs to KEGG pathway annotations.
> However, I cannot seem to find any information about the KEGG pathway
> dataset version/update information, or when the data tables were added to
> the UCSC genome table browser. Any idea how to find this information for
> KEGG and any other annotation tables available in the Table Browser?
> Thanks,
> Kathleen
>
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
