Hello Joshua, Your counts are correct. The data on the public mySQL server has the data associated with Genbank (EST, mRNA, RefSeq, etc) updated weekly. The Browser hosted at http://genome.ucsc.edu is updated daily.
This means that there will be slight differences as you noted. Thanks, Jennifer --------------------------------- Jennifer Jackson UCSC Genome Informatics Group http://genome.ucsc.edu/ On 3/18/10 2:57 PM, Josh Gagnon wrote: > I couldn't find any reference to this in the archives: > > Im working on hg18, using the refGene table. There appears to be a > difference between the table browser results ( > http://genome.ucsc.edu/cgi-bin/hgTables) and the public mysql database ( > genome-mysql.cse.ucsc.edu). Specifically, fetching all rows where name not > like 'NR%' returns 30313 results from the table browser, and only 30269 from > the public database. In addition, 44 results have different values, and a > brief check by eye suggests they are mostly in the txStart column. > > Any insight would be appreciated. > > Thanks > Joshua Gagnon > > Dept of Biochemistry > University of Otago > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
