Database: hg19    Primary Table: gbStatus    Row Count: 68,430,389
Format description: GenBank version info for alignments in the database

field	example	SQL type	description
acc	NM_001000000	char(12)	GenBank accession
version	1	smallint(5) unsigned	GenBank version number suffix
modDate	2010-04-13	date	last modified date
type	mRNA	enum('EST','mRNA')	Full length ('mRNA') or EST ('EST')
srcDb	RefSeq	enum('GenBank','RefSeq')	Source database: 'GenBank' or 'RefSeq'
orgCat	xeno	enum('native','xeno')	Organism category: this ('native') or other ('xeno')
gbSeq	62341805	int(10) unsigned	ID/index in gbSeq table
numAligns	1	int(10) unsigned	number of alignments of the accession
seqRelease	33	char(8)	release version where the sequence was obtained
seqUpdate	full	char(10)	update where sequence was obtained (date or 'full')
metaRelease	40	char(8)	release version where the metadata was obtained
metaUpdate	full	char(10)	update where metadata was obtained (date or 'full')
extRelease	40	char(8)	release version containing the external file
extUpdate	full	char(10)	update containing the external file (date or 'full')
time	2010-05-15 08:04:27	timestamp	time that this entry was inserted

      hg19.all_est.qName (via gbStatus.acc)
      hg19.all_mrna.qName (via gbStatus.acc)
      hg19.ccdsInfo.mrnaAcc (via gbStatus.acc)
      hg19.estOrientInfo.name (via gbStatus.acc)
      hg19.gbCdnaInfo.acc (via gbStatus.acc)
      hg19.gbSeq.acc (via gbStatus.acc)
      hg19.geneNetworkId.id (via gbStatus.acc)
      hg19.imageClone.acc (via gbStatus.acc)
      hg19.intronEst.qName (via gbStatus.acc)
      hg19.kgXref.refseq (via gbStatus.acc)
      hg19.knownToRefSeq.value (via gbStatus.acc)
      hg19.mgcFullMrna.qName (via gbStatus.acc)
      hg19.mgcGenes.name (via gbStatus.acc)
      hg19.mrnaOrientInfo.name (via gbStatus.acc)
      hg19.orfeomeGenes.name (via gbStatus.acc)
      hg19.orfeomeMrna.qName (via gbStatus.acc)
      hg19.refFlat.name (via gbStatus.acc)
      hg19.refGene.name (via gbStatus.acc)
      hg19.refLink.mrnaAcc (via gbStatus.acc)
      hg19.refSeqAli.qName (via gbStatus.acc)
      hg19.refSeqStatus.mrnaAcc (via gbStatus.acc)
      hg19.refSeqSummary.mrnaAcc (via gbStatus.acc)
      hg19.seq.acc (via gbStatus.acc)
      hg19.spMrna.mrnaID (via gbStatus.acc)
      hg19.xenoMrna.qName (via gbStatus.acc)
      hg19.xenoRefFlat.name (via gbStatus.acc)
      hg19.xenoRefGene.name (via gbStatus.acc)
      hg19.xenoRefSeqAli.qName (via gbStatus.acc)

acc	version	modDate	type	srcDb	orgCat	gbSeq	numAligns	seqRelease	seqUpdate	metaRelease	metaUpdate	extRelease	extUpdate	time
NM_001000000	1	2010-04-13	mRNA	RefSeq	xeno	62341805	1	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000001	1	2010-04-13	mRNA	RefSeq	xeno	62342602	1	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000002	1	2010-04-13	mRNA	RefSeq	xeno	62343474	1	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000003	1	2010-04-13	mRNA	RefSeq	xeno	62344395	1	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000004	1	2010-04-13	mRNA	RefSeq	xeno	62345233	2	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000005	1	2010-04-13	mRNA	RefSeq	xeno	62315306	3	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000006	1	2010-04-13	mRNA	RefSeq	xeno	62315989	3	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000007	1	2010-04-13	mRNA	RefSeq	xeno	62316842	3	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000008	1	2010-04-13	mRNA	RefSeq	xeno	62317705	2	33	full	40	full	40	full	2010-05-15 08:04:27
NM_001000009	1	2010-04-13	mRNA	RefSeq	xeno	62318531	3	33	full	40	full	40	full	2010-05-15 08:04:27

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