Schema for seq

Database: hg19 Primary Table: seq Row Count: 1,269,198
Format description: Information about sequences contained in files described in extFile

field	example	SQL type	description
`id`	14	`int(10) unsigned`	ID/index
`acc`	AZ303307	`varchar(128)`	Accession of sequence
`size`	0	`int(10) unsigned`	Size of sequence (number of bases)
`gb_date`	0000-00-00	`date`	unused
`extFile`	13	`int(10) unsigned`	ID/index of file in extFile
`file_offset`	0	`bigint(20)`	byte offset of sequence in file
`file_size`	560	`int(10) unsigned`	byte size of sequence in file

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

id	acc	gb_date	extFile	file_offset	file_size
14	AZ303307	0000-00-00	13	0	560
15	AZ303308	0000-00-00	13	560	544
16	AZ482433	0000-00-00	13	1104	537
17	AZ482434	0000-00-00	13	1641	403
18	AZ482435	0000-00-00	13	2044	400
19	AZ482436	0000-00-00	13	2444	544
20	AZ482437	0000-00-00	13	2988	441
21	AZ482438	0000-00-00	13	3429	513
22	AZ482439	0000-00-00	13	3942	496
23	AZ482440	0000-00-00	13	4438	546

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