[Genome] hg18, is static data?

Enrique M. Muro enrique.muro at mdc-berlin.de
Mon Feb 11 05:15:58 PST 2008


We downloaded long time ago (2006) the hg18 and set up a mysql database.
Now we have downloaded again hg18 (febr. 2008) in another lab setting up
again a mysql database.

we were comparing the 2006 and 2008 mysql versions realizing that the
mysql data is different in the diff. versions (see for instance chromEnd
in the next example)

OLD hg18 download (2006)

mysql> select * from estOrientInfo where name='DB511739';
+-----+--------------+------------+----------+----------+-------------------+-----------+--------------+-----------+--------------+
| bin | chrom        | chromStart | chromEnd | name     |
intronOrientation | sizePolyA | revSizePolyA | signalPos | revSignalPos
|
+-----+--------------+------------+----------+----------+-------------------+-----------+--------------+-----------+--------------+
...
| 827 | chr17        |   31820231 | 31820657 | DB511739 |
0 |         0 |            2 |         0 |            
...


NEW hg18 download (2008)
mysql> select * from estOrientInfo where name='DB511739';
+-----+--------------+------------+----------+----------+-------------------+-----------+--------------+-----------+--------------+
| bin | chrom        | chromStart | chromEnd | name     |
intronOrientation | sizePolyA | revSizePolyA | signalPos | revSignalPos
|
+-----+--------------+------------+----------+----------+-------------------+-----------+--------------+-----------+--------------+
...
| 827 | chr17        |   31820231 | 31820891 | DB511739 |
0 |         0 |            0 |         0 |            0 | 
...


is hg18 data static and we committed some kind of mistake with the mysql
set up? or the hg18 data could be modified over time?

Thanks in advance,
Enrique Muro



More information about the Genome mailing list