Schema for ucscRetroSeq5
  Database: hg19    Primary Table: ucscRetroSeq5    Row Count: 2,017,610   Data last updated: 2013-03-01
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 AF001540.1varchar(128) Accession of sequence
size 1781int(10) unsigned Size of sequence (number of bases)
gb_date 0000-00-00date unused
extFile 1int(10) unsigned ID/index of file in extFile
file_offset 0bigint(20) byte offset of sequence in file
file_size 1829int(10) unsigned byte size of sequence in file

Connected Tables and Joining Fields
        hg19.ucscRetroAli5.qName (via ucscRetroSeq5.acc)
      hg19.ucscRetroCds5.id (via ucscRetroSeq5.acc)
      hg19.ucscRetroInfo5.name (via ucscRetroSeq5.acc)
      hg19.ucscRetroExtFile5.id (via ucscRetroSeq5.extFile)

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1AF001540.117810000-00-00101829
2AF001541.111380000-00-00118291173
3AF001542.129920000-00-00130023064
4AF001543.19030000-00-0016066934
5AF001544.14340000-00-0017000455
6AF001545.13700000-00-0017455390
7AF001546.111420000-00-00178451177
8AF001547.110920000-00-00190221126
9AF034176.172320000-00-001101487389
10AF038950.123840000-00-001175372444

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