Schema for seq
  Database: hg19    Primary Table: seq    Row Count: 2,602,549   Data last updated: 2012-08-01
Format description: Information about sequences contained in files described in extFile
fieldexampleSQL type description
id 14int(10) unsigned ID/index
acc AZ303307varchar(128) Accession of sequence
size 0int(10) unsigned Size of sequence (number of bases)
gb_date 0000-00-00date unused
extFile 13int(10) unsigned ID/index of file in extFile
file_offset 0bigint(20) byte offset of sequence in file
file_size 560int(10) unsigned byte size of sequence in file

Connected Tables and Joining Fields
        hg19.fishClones.accNames (via seq.acc)
      hg19.gold.frag (via seq.acc)
      hg19.stsInfo2.genbank (via seq.acc)
      hg19.uniGene_3.qName (via seq.acc)
      hg19.extFile.id (via seq.extFile)

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
14AZ30330700000-00-00130560
15AZ30330800000-00-0013560544
16AZ48243300000-00-00131104537
17AZ48243400000-00-00131641403
18AZ48243500000-00-00132044400
19AZ48243600000-00-00132444544
20AZ48243700000-00-00132988441
21AZ48243800000-00-00133429513
22AZ48243900000-00-00133942496
23AZ48244000000-00-00134438546

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