Table Browser (original) (raw)

Table Browser

| | Use this tool to retrieve and export data from the Genome Browser annotation track database. You can limit retrieval based on data attributes and intersect or merge with data from another track, or retrieve DNA sequence covered by a track. More...For a description of the controls below, see Using the Table Browser (below). General information and sample queries are available from the Table Browser User's Guide. For more complex queries, we recommend Galaxy or our public MySQL server. To examine the biological function of your set through annotation enrichments, send the data to GREAT. Refer to the Credits page for the list of contributors and usage restrictions associated with these data. Bulk download of track data is available from the Sequence and Annotation Downloads page. Less... Select dataset Specify the genome, track and data table to be used as the data source. Help Clade: Genome: Assembly: Group: Track: Table: Note: Most dbSNP tables are huge. Trying to download them through the Table Browser usually leads to a timeout. Please see our Data Access FAQ on how to download dbSNP data. Define region of interest Specify whole genome or restrict to a single or set of genomic regions, defined by coordinates or identifiers. Help Region: Genome Position Identifiers (names/accessions): Optional: Subset, combine, compare with another track Press 'create' button and select parameters for optional operations. Help Filter: Intersection: Retrieve and display data Specify output options and press the 'get output' button. Help Output format: Note: Table Browser GTF files contain transcripts, but no gene identifiers or symbols. If you are looking for fully formatted gene model files for use in genome analysis pipelines,check the bigZips/genes directory on our download server.Signal data points format: The Table Browser outputs signal track data in wiggle format by default. You can also use the Table Browser filter feature to designate a value threshold and then output that as BED format. The Table Browser will then create a BED file with an entry for every value that passes the filter. Our command line tool bigWigToBedGraph can also be used to convert wig files directly. Contact us at genome@soe.ucsc.edu for help with data extraction or conversion. Send output to Galaxy GREAT Output filename: (add .csv extension if opening in Excel, leave blank to keep output in browser) Output field separator: tsv (tab-separated) csv (for excel) File type returned: Plain text Gzip compressed | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |

Using the Table Browser

| | This section provides brief line-by-line descriptions of the Table Browser controls. For more information on using this program, see the Table 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 group list. Some tracks are not available when the region is set to genome due to the data provider's restrictions on sharing. Table: Selects the SQL table data to use. This list shows all tables associated with the track specified in the track list. Some tables may be unavailable due to the data provider's restrictions on sharing. Data format description: Displays format information for the tables or files 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 (not available for certain tracks with restrictions on data sharing). In some Human assemblies, you may select ENCODE to examine only the ENCODE Pilot 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. You can select multiple genomic regions by clicking the "define regions" button and entering up to 1,000 regions in a 3- or 4-field BED file format. 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. 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 with the name column containing exon information separated by underscores. GTF - positions of all data items in alimited gene transfer 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 Note that all start-end coordinate ranges are returned in UCSC's internal zero-based/half-open format, see our FAQ, with the exception of the formats GTF, data points (aka "wiggle") and hyperlinks, which are one-based/closed. Send output to Galaxy: displays results of query in Galaxy, a framework for interactive genome analysis. Send output to GREAT: displays the functional enrichments of the query results in GREAT, a tool for analysis of the biological function of cis-regulatory regions. 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. | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |