Home   -   Genomes   -   searchdbRIP   -   Gene Sorter   -   Blat   -   PCR   -   Tables   -   FAQ   -   Help  
  Table Browser
  Use this program to get the data associated with a track in text format, to calculate intersections between tracks, and to retrieve DNA sequence covered by a track. See Using the Table Browser for a description of the controls in this form. The old Table Browser Page is still available for a limited period.
clade:    genome:    assembly:
group:    track:
table:  
region: genome ENCODE position
identifiers (names/accessions):
filter:
intersection:
output format:
output file:  (leave blank to keep output in browser)
file type returned:  plain text   gzip compressed

To reset all user cart settings (including custom tracks), click here.



  Using the Table Browser
 

Here is a line-by-line description of the table browser controls:

  • clade: Specifies which clade the organism is in.
  • genome: Specifies which organism data to use.
  • assembly: Specifies which version of the organism's genome sequence to use.
  • group: Selects the type of tracks to be displayed in the track list. The options correspond to the track groupings shown in the Genome Browser. Select 'All Tracks' for an alphabetical list of all available tracks in all groups. Select 'All Tables' to see all tables including those not associated with a track.
  • database: (with "All Tables" group option) Determines which database should be used for options in table menu.
  • track: Selects the annotation track data to work with. This list displays all tracks belonging to the group specified in the group list.
  • table: Selects the SQL table data to use. This list shows all tables associated with the track specified in the track list.
  • Describe Table Schema: Displays schema information for the tables associated with the selected track.
  • region: Restricts the query to a particular chromosome or region. Select genome to apply the query to the entire genome or ENCODE to examine only the ENCODE regions. To limit the query to a specific position, type a chromosome name, e.g. chrX, or a chromosome coordinate range, such as chrX:100000-200000, or a gene name or other id in the text box.
  • Lookup: Press this button after typing in a gene name or other id in the position text box to look up the chromosome position
  • identifiers (selected tracks only): Restricts the output to table data that match a list of identifiers, for instance RefSeq accessions for the RefSeq track. If no identifiers are entered, all table data within the specified region will be displayed.
  • filter: Restricts the query to only those items that match certain criteria, e.g. genes with a single exon. Click the Create button to add a filter, the Edit button to modify an existing filter, or the Clear button to remove an existing filter.
  • intersection (selected tracks only): Combines the output of two queries into a single set of data based on specific join criteria. For example, this can be used to find all SNPs that intersect with RefSeq coding regions. The intersection can be configured to retain the existing alignment structure of the table with a specified amount of overlap, or discard the structure in favor of a simple list of position ranges using a base-pair intersection or union of the two data sets. The button functionalities are similar to those of the filter option.
  • output: Specifies the output format (not all options are available for some tracks). Formats include:
    • all fields from selected table - data from the selected table displayed in a tab-separated format suitable for import into spreadsheets and relational databases. The ASCII format may be read in any web browser or text editor.
    • chosen fields from selected and related tables - user-selected set of tab-separated fields from the selected table and (optionally) other related tables as well.
    • sequence - DNA (or protein sequence, in some cases) associated with the table.
    • BED - positions of data items in a standard UCSC Browser format.
    • query results to GALA - displays results of query in the Genome Alignment and Annotation database browser (GALA).
    • GTF - positions of all data items in a standard gene prediction format. (Both BED and GTF formats can be used as the basis for custom tracks).
    • custom track - customized Genome Browser annotation track based on the results of the query.
    • hyperlinks to Genome Browser - returns a page full of hyperlinks to the UCSC Genome Browser, one for each item in the table.
    • data points - the data points that make up a graph (aka wiggle) track.
    • MAF - multiple alignments in MAF format
  • file type returned: When a filename is entered in the "output file" text box, specifies the format of the output file:
    • plain text - data is in ASCII format
    • gzip compressed - data is compressed in gzip format
  • Get Output: Submits a data query based on the specified parameters and returns the output.
  • Summary/Statistics: Displays statistics about the data specified by the parameters.