Spreadsheet links to Genome Browser views
Many users of the Genome Browser gather data of their own in Excel spreadsheets and would like to create links to the Browser using data in the spreadsheet. For example, a clinical geneticist may have lists of regions or genes for a patient that are duplicated or deleted, as determined by comparative genomic hybridization (CGH). These regions can be the source information for a browser view allowing access to each region with a single click.
|
|
Click to download the spreadsheet: |
Careful use of Excel's "copy" and "move" functions should allow the links on this sheet to be used without modification.
Customizing the links
Postion-based link. The contents of the last cell in the image above are as follows:
=HYPERLINK("http://genome.ucsc.edu/cgi-bin/hgTracks?db=hg19&position="&E22&"&dgv=pack&knownGene=pack&omimGene2=pack","ucsc")
Gene-name link. The URL for a link to a gene name is made in this way:
=HYPERLINK("http://genome.ucsc.edu/cgi-bin/hgTracks?db=hg19&singleSearch=knownCanonical&position="&E16&"&omimGene2=pack&decipher=pack&snp141=dense","ucsc")
Gene details link. A link to the UCSC Genes details page would look like this:
=HYPERLINK("http://genome.ucsc.edu/cgi-bin/hgGene?org=human&db=hg19&hgg_gene="&E16,"ucsc")
Add tracks of choice. The position-based link above shows how to create a link that turns on three specific tracks of interest. In this case, these tracks are explicitly turned on:
Database of Genomic Variants (table: dgv) UCSC Genes (table: knownGene) OMIM Genes (table: omimGene2)
Each track is set to "pack" in the link as follows:
dgv=pack knownGene=pack omimGene2=pack
Any track that has been open in on your Browser will remain in the view when the new browser window opens. Any track that is on by default must be turned off using:
<tablename>=hide
A new track can be added using the tablename and a visibility of choice. e.g.:
&snp141=dense
Simply add to the end of the url any other desired <tablename>=visibility, appended to the url by an ampersand (&). The simplest way to learn the name of the table underlying a track is to do a mouseover in a Genome Browser image and read the url at the bottom of the browser page. The table is shown in the url as
g=tablename
You can also see the tablename by clicking into an item in the track and then clicking "show table schema" on the next page.
Visibility options include:
hide dense squish pack full
Other parameters you can use are documented on the Browser:
http://hgwdev-max.soe.ucsc.edu/goldenPath/help/customTrackText.html#optParams
