Spreadsheet links to Genome Browser views: Difference between revisions

From genomewiki
Jump to navigationJump to search
(New page: 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 geneti...)
 
Line 27: Line 27:
   knownGene=pack
   knownGene=pack
   omimGene=pack
   omimGene=pack
  snp131=dense


Any track that has been open in a session will remain in the view when the new browser window opens.
Any track that has been open in a session will remain in the view when the new browser window opens.


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
A new track can be added using the tableName and a visibility of choice:
 
  &snp131=dense
 
Simply add to the end of the url any other desired tableName=visibility, connected 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
   g=tableName


Simply add to the end of the url any other desired tableName=visibility, connected to the url by an ampersand (&).
Visibility options include:


[[Category:User Developed Scripts]]
  hide
  dense
  squish
  pack
  full

Revision as of 04:02, 25 November 2010

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 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: ucscLinks.xls

UcscLinks.gif

Careful use of Excel's "copy" and "move" functions should allow the links on this sheet to be used without modification.

Customizing the links

The contents of the last cell in the image above (cell G22 in the actual spreadsheet) are as follows:

 =HYPERLINK("http://genome.ucsc.edu/cgi-bin/hgTracks?db=hg19&position="&E22&"&dgv=pack&knownGene=pack&omimGene=pack","ucsc")

This example shows how to create a link that turns on specific tracks of interest. In this case, three tracks are explicitly turned on:

 Database of Genomic Variants (table: dgv)
 UCSC Genes (table: knownGene)
 OMIM Genes (table: omimGene) 

Each track is set to "pack" in the link as follows:

 dgv=pack
 knownGene=pack
 omimGene=pack

Any track that has been open in a session will remain in the view when the new browser window opens.

A new track can be added using the tableName and a visibility of choice:

 &snp131=dense

Simply add to the end of the url any other desired tableName=visibility, connected 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

Visibility options include:

 hide
 dense
 squish
 pack
 full