Use this program to retrieve the data associated with a track in text format, to calculate intersections between tracks, and to retrieve DNA sequence covered by a track. For help in using this application see Using the Table Browser for a description of the controls in this form, the User's Guide for general information and sample queries, and the OpenHelix Table Browser tutorial for a narrated presentation of the software features and usage. For more complex queries, you may want to use Galaxy or our public MySQL server. Refer to the Credits page for the list of contributors and usage restrictions associated with these data.
This section provides brief line-by-line descriptions of the Table
Browser controls. For more information on using this program, see the
Browser User's Guide.
- 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
- table: Selects the SQL table data to use. This list shows
all tables associated with the track specified in the track
- 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
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
- 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
- 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
- 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.
- selected fields from primary 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.
- 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).
- CDS FASTA alignment from multiple alignment
- FASTA alignments of the CDS regions of a gene prediction track
using any of the multiple alignment tracks for the current database.
Output sequence can be in either nucleotide-space or translated to
protein-space. Available only for genePred 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
- Send output to Galaxy: displays results of query in
Galaxy, a framework for
interactive genome analysis.
- 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.