Database: hg19    Primary Table: refLink    Row Count: 305,914
Format description: Link together a refseq mRNA and other stuff

field	example	SQL type	info	description
name		varchar(255)	values	Name displayed in UI
product		varchar(255)	values	Name of protein product
mrnaAcc	NR_026498	varchar(255)	values	mRNA accession
protAcc		varchar(255)	values	protein accession
geneName	0	int(10) unsigned	range	pointer to geneName table
prodName	0	int(10) unsigned	range	pointer to prodName table
locusLinkId	0	int(10) unsigned	range	Locus Link ID
omimId	0	int(10) unsigned	range	OMIM ID

      hg19.gbCdnaInfo.geneName (via refLink.geneName)
      hg19.geneName.id (via refLink.geneName)
      hg19.keggPathway.locusID (via refLink.locusLinkId)
      hg19.knownToLocusLink.value (via refLink.locusLinkId)
      hg19.ccdsInfo.mrnaAcc (via refLink.mrnaAcc)
      hg19.gbCdnaInfo.acc (via refLink.mrnaAcc)
      hg19.gbSeq.acc (via refLink.mrnaAcc)
      hg19.gbStatus.acc (via refLink.mrnaAcc)
      hg19.imageClone.acc (via refLink.mrnaAcc)
      hg19.kgXref.refseq (via refLink.mrnaAcc)
      hg19.knownToRefSeq.value (via refLink.mrnaAcc)
      hg19.mrnaOrientInfo.name (via refLink.mrnaAcc)
      hg19.refFlat.name (via refLink.mrnaAcc)
      hg19.refGene.name (via refLink.mrnaAcc)
      hg19.refSeqAli.qName (via refLink.mrnaAcc)
      hg19.refSeqStatus.mrnaAcc (via refLink.mrnaAcc)
      hg19.refSeqSummary.mrnaAcc (via refLink.mrnaAcc)
      hg19.seq.acc (via refLink.mrnaAcc)
      hg19.kgAlias.alias (via refLink.name)
      hg19.kgSpAlias.alias (via refLink.name)
      hg19.kgXref.geneSymbol (via refLink.name)
      hg19.omimMorbidMap.geneSymbols (via refLink.name)
      hg19.refFlat.geneName (via refLink.name)
      hg19.omimGene.name (via refLink.omimId)
      hg19.omimGeneMap.omimId (via refLink.omimId)
      hg19.omimMorbidMap.omimId (via refLink.omimId)
      hg19.omimToKnownCanonical.omimId (via refLink.omimId)
      hg19.gbCdnaInfo.productName (via refLink.prodName)
      hg19.productName.id (via refLink.prodName)
      hg19.kgProtAlias.alias (via refLink.protAcc)
      hg19.kgSpAlias.alias (via refLink.protAcc)
      hg19.kgXref.protAcc (via refLink.protAcc)
      hg19.seq.acc (via refLink.protAcc)

name	product	mrnaAcc	protAcc	geneName	prodName	locusLinkId	omimId
		NR_026498		0	0	0	0
		NR_025344		0	0	0	0
		NR_025894		0	0	0	0
		NR_025144		0	0	0	0
		NR_026430		0	0	0	0
		NR_025326		0	0	0	0
		NR_025916		0	0	0	0
		NR_025582		0	0	0	0
		NR_025173		0	0	0	0
		NR_025327		0	0	0	0

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