[Genome] File offsets in hg18.multiz17way table

[Dexter Hadley]

Hi there,

In hg17 I was able to use the file offsets from the multiz8way table to
query alignments in the respective maf files.  However, now that I have
migrated to hg18, my scripts no longer work.  I think that the problem is
that the file offsets in hg18.multiz17way are incorrect.  For instance,
please consider these two queries of the first multiz alignment from
hg17.multiz8way and hg18.multiz17way:

mysql> select * from hg17.multiz8way where chrom = 'chrY' order by
chromStart limit 1;
+-----+-------+------------+----------+---------+--------+----------+
| bin | chrom | chromStart | chromEnd | extFile | offset | score    |
+-----+-------+------------+----------+---------+--------+----------+
| 585 | chrY  |        861 |     2250 | 2468793 |    909 | 0.940234 |
+-----+-------+------------+----------+---------+--------+----------+


mysql> select * from hg18.multiz17way where chrom = 'chrY' order by
chromStart limit 1;
+-----+-------+------------+----------+---------+--------+----------+
| bin | chrom | chromStart | chromEnd | extFile | offset | score    |
+-----+-------+------------+----------+---------+--------+----------+
| 585 | chrY  |        667 |      861 | 2389811 |     34 | 0.596211 |
+-----+-------+------------+----------+---------+--------+----------+

The offset in hg17.multiz8way is greater than that in hg18.multiz17way even
though there are many more comment lines in the beginning of
hg18/multiz17way/chrY.maf relative to hg17/multiz8way/chrY.maf.  Something
is wrong.  Please help.  Thanks,

Dexter Hadley