Schema for seq
  Database: hg38    Primary Table: seq    Row Count: 1,574,366   Data last updated: 2015-09-14
Format description: Information about sequences contained in files described in extFile
On download server: MariaDB table dump directory
fieldexampleSQL type description
id 1int(10) unsigned ID/index
acc gnf1h00001_x_atvarchar(128) Accession of sequence
size 25int(10) unsigned Size of sequence (number of bases)
gb_date 0000-00-00date unused
extFile 8int(10) unsigned ID/index of file in extFile
file_offset 0bigint(20) byte offset of sequence in file
file_size 54int(10) unsigned byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1gnf1h00001_x_at250000-00-008054
2gnf1h00002_x_at250000-00-0085454
3gnf1h00003_x_at250000-00-00810854
4gnf1h00004_x_at250000-00-00816254
5gnf1h00005_x_at250000-00-00821655
6gnf1h00006_x_at250000-00-00827154
7gnf1h00007_x_at250000-00-00832554
8gnf1h00008_x_at250000-00-00837954
9gnf1h00009_x_at250000-00-00843355
10gnf1h00010_x_at250000-00-00848855

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