Schema for seqNcbiRefSeq
  Database: xenLae2    Primary Table: seqNcbiRefSeq    Row Count: 60,920   Data last updated: 2020-04-01
Format description: Information about sequences contained in files described in extFile
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(10) unsigned range ID/index
acc NM_001085445.1varchar(128) values Accession of sequence
size 450int(10) unsigned range Size of sequence (number of bases)
gb_date 0000-00-00date   unused
extFile 1int(10) unsigned range ID/index of file in extFile
file_offset 0bigint(20) range byte offset of sequence in file
file_size 472int(10) unsigned range byte size of sequence in file

Connected Tables and Joining Fields
        xenLae2.ncbiRefSeq.name (via seqNcbiRefSeq.acc)
      xenLae2.ncbiRefSeqCds.id (via seqNcbiRefSeq.acc)
      xenLae2.ncbiRefSeqCurated.name (via seqNcbiRefSeq.acc)
      xenLae2.ncbiRefSeqLink.id (via seqNcbiRefSeq.acc)
      xenLae2.ncbiRefSeqPredicted.name (via seqNcbiRefSeq.acc)
      xenLae2.ncbiRefSeqPsl.qName (via seqNcbiRefSeq.acc)
      xenLae2.extNcbiRefSeq.id (via seqNcbiRefSeq.extFile)

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001085445.14500000-00-0010472
2NM_001085482.160420000-00-0014726134
3NM_001085483.121250000-00-00166062168
4NM_001085484.149110000-00-00187744989
5NM_001085556.124900000-00-001137632538
6NM_001085557.117460000-00-001163011784
7NM_001085558.116630000-00-001180851700
8NM_001085559.118180000-00-001197851857
9NM_001085560.141280000-00-001216424196
10NM_001085561.129590000-00-001258383012

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