Hi Stefan, The extFile column is actually a foreign key in the extFile table in the same database. To get the path of the file run the following sql query:
select * from extFile where id like '2389763'; +---------+----------+------------------------------------------+------------+ | id | name | path | size | +---------+----------+------------------------------------------+------------+ | 2389763 | chr1.maf | /gbdb/hg18/multiz17way/anno/maf/chr1.maf | 3117807912 | +---------+----------+------------------------------------------+------------+ Please note that your mirror may be configured slightly differently from our home site - check with whoever maintains your mirror to confirm the actual file path. I hope this information is helpful. Please feel free to contact the mail list again if you require further assistance. Best, Mary ------------------ Mary Goldman UCSC Bioinformatics Group On 1/6/11 7:39 AM, Stefan Seemann wrote: > Hello, > > our group maintains a local mirror of the UCSC browser. > I would like to access MULTIZ alignment blocks directly from our mirror by > a web service. > Therefore, I use a mysql statement like > use hg18; select extFile from multiz17way where chrom="chr1" and > chromStart<1050 and chromEnd>1200; > which returns me the identifier 2389763 > How/where do I get the corresponding external files? > > Thank you for your help > Stefan Seemann > > --- > Phd student > Center for non-coding RNA in Technology and Health (RTH) > University of Copenhagen > Denmark > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome > _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
