Hi R, First, if you need instructions on accessing our public MySQL database, see: http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29
Second, to find the names of tables that contain the data you are looking for, you can go to the main Genome Browser page (http://genome.ucsc.edu/cgi-bin/hgTracks), click on the blue track names, and hit the "View table schema" link to get the table name, a description of the fields, a row count, and a description of the data. A shortcut for clicking on the table schema links is to hover over the track name in the Genome Browser and look for the table name at the end of the link (where it says "g=ctgPos," for instance). I suspect that you will want to use the Assembly (gold table) or Map Contigs (ctgPos table) from Mapping and Sequencing Tracks section. If you have further questions, please feel free to contact us again at [email protected]. -- Brooke Rhead UCSC Genome Bioinformatics Group On 08/20/11 21:09, Richard Student wrote: > Hello all, > > I would like to select all chromosomes for hg18, select all contigs for a > given chromosome, and query the starting and ending position of any contig > within the DNA for the corresponding chromosome. > > I am pretty good with SQL, the database is pretty large though! > > Cheers, > R Student > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
