Greetings, Thanks to help from Maximilian and Brooke, I now have a Savant plugin which is happily accessing the UCSC database. I do have a couple of questions about parts of the database layout which are still unclear to me:
1) There are a number of tables which are listed in hg19.trackDb which aren't actually tables (e.g. agilentCgh). I thought they might be views, but doing "SELECT * FROM hg19.agilentCgh" from the mysql command prompt tells me "Table 'hg19.agilentCgh' doesn't exist". I would have thought that if agilentCgh were a view, the SELECT * would just work? Or am I missing something here? 2) A number of tables store their info in an external file (e.g. phastCons46way). I recognise that "/gbdb/hg19/multiz46way/phastCons46way.wib" is a path to a WIB file on UCSC's FTP server. Is there a way to access these files via HTTP, or is FTP the only way? Accessing byte-ranges via FTP isn't fun. Thanks again, Eric Smith University of Toronto _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
