Schema for xenoRefFlat
  Database: echTel1    Primary Table: xenoRefFlat    Row Count: 888,272   Data last updated: 2020-08-21
Format description: A gene prediction with additional geneName field.
On download server: MariaDB table dump directory
fieldexampleSQL type description
geneName GSKIPvarchar(255) Name of gene as it appears in genome browser.
name NM_001242570varchar(255) Name of gene
chrom scaffold_196245varchar(255) Reference sequence chromosome or scaffold
strand +char(1) + or - for strand
txStart 3583int(10) unsigned Transcription start position (or end position for minus strand item)
txEnd 4759int(10) unsigned Transcription end position (or start position for minus strand item)
cdsStart 3583int(10) unsigned Coding region start (or end position for minus strand item)
cdsEnd 3712int(10) unsigned Coding region end (or start position for minus strand item)
exonCount 2int(10) unsigned Number of exons
exonStarts 3583,4690,longblob Exon start positions (or end positions for minus strand item)
exonEnds 3712,4759,longblob Exon end positions (or start positions for minus strand item)

Connected Tables and Joining Fields
        echTel1.xenoRefGene.name (via xenoRefFlat.name)
      echTel1.xenoRefSeqAli.qName (via xenoRefFlat.name)
      hgFixed.gbCdnaInfo.acc (via xenoRefFlat.name)
      hgFixed.gbSeq.acc (via xenoRefFlat.name)
      hgFixed.imageClone.acc (via xenoRefFlat.name)

Sample Rows
 
geneNamenamechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEnds
GSKIPNM_001242570scaffold_196245+358347593583371223583,4690,3712,4759,
GSKIPNM_001242570scaffold_278093-596098026738980255960,6139,6738,9600,9784,5978,6169,6902,9778,9802,
McidasNM_001037914scaffold_58639+1907581947583190,434,659,311,498,758,
TMEM130NM_001083369scaffold_318169-3747933747931137,291,324,1141,1213,2126,2171,2250,2270,4485,4724,100,294,406,1203,1311,2168,2249,2266,2290,4723,4793,
Avl9NM_030235scaffold_293691-62529626696252962669162529,62669,
was.SNM_001097654scaffold_262811+225368162253681362253,4719,4932,5002,5944,6780,2295,4761,4998,5080,6013,6816,
foxi4.1.LNM_001097651scaffold_160625+297332372973323712973,3237,
LOC100382416NM_001175159scaffold_219504-152416471524164711524,1647,
LOC100382416NM_001175159scaffold_233315-616691876166918726166,9031,6256,9187,
Gnai2NM_008138scaffold_299214+239374612393646992393,2428,2551,6291,7052,7157,7354,7372,7420,2428,2452,2710,6470,7130,7172,7362,7411,7461,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.