Schema for ucscRetroSeq9
  Database: hg38    Primary Table: ucscRetroSeq9    Row Count: 2,095,315   Data last updated: 2015-01-15
Format description: Information about sequences contained in files described in extFile
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
        hg38.ucscRetroAli9.qName (via ucscRetroSeq9.acc)
      hg38.ucscRetroCds9.id (via ucscRetroSeq9.acc)
      hg38.ucscRetroInfo9.name (via ucscRetroSeq9.acc)
      hg38.ucscRetroExtFile9.id (via ucscRetroSeq9.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.