Schema for seqNcbiRefSeq
  Database: susScr11    Primary Table: seqNcbiRefSeq    Row Count: 77,702   Data last updated: 2021-02-11
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_001001258.1varchar(128) values Accession of sequence
size 1073int(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 1103int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001001258.110730000-00-00101103
2NM_001001259.135860000-00-00111033647
3NM_001001260.16790000-00-0014750704
4NM_001001261.116440000-00-00154541681
5NM_001001262.115480000-00-00171351584
6NM_001001263.117210000-00-00187191759
7NM_001001264.120830000-00-001104782126
8NM_001001265.16200000-00-00112604644
9NM_001001266.23760000-00-00113248397
10NM_001001267.112090000-00-001136451241

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