- Genome Browser
- My Data
- About Us
This page was retired long ago when the table descriptions for the annotation database stopped being updated. To retrieve the schemas for tables underlying the Genome Browser annotation tracks one can use the Table Browser using the "describe table schema" button or the REST API.
Gene Predictions and RefSeq Genes with Gene Names
A version of genePred that associates the gene name with the gene prediction information. In alternative splicing situations each transcript has a row in this table.
table refFlat "A gene prediction with additional geneName field." ( string geneName; "Name of gene as it appears in Genome Browser." string name; "Name of gene" string chrom; "Chromosome name" char strand; "+ or - for strand" uint txStart; "Transcription start position" uint txEnd; "Transcription end position" uint cdsStart; "Coding region start" uint cdsEnd; "Coding region end" uint exonCount; "Number of exons" uint[exonCount] exonStarts; "Exon start positions" uint[exonCount] exonEnds; "Exon end positions" )
The text for this entry is deprecated. Please use the below Table Browser method to access this information.
For more information on using the Table Browser, see the Table Browser User's Guide.
You can also access table schema information in JSON notation using our API with a query such as the following:
Please note the response will be in JSON notation and may need parsing to interpret.
There are also links to our source code in src/hg/lib to discover the autoSql files (.as) that define our tables. Here is an example link to the refFlat.as file: http://genome-source.soe.ucsc.edu/gitlist/kent.git/raw/master/src/hg/lib/refFlat.as