Schema for seqNcbiRefSeq
  Database: otoGar3    Primary Table: seqNcbiRefSeq    Row Count: 38,532   Data last updated: 2020-04-08
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_001281858.1varchar(128) values Accession of sequence
size 705int(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 730int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001281858.17050000-00-0010730
2NM_001281886.112700000-00-0017301302
3NM_001285809.19040000-00-0012032932
4NM_001289715.112040000-00-00129641236
5NM_001289994.119040000-00-00142001944
6NM_001290317.18890000-00-0016144917
7NM_001291038.125620000-00-00170612611
8NM_001291492.144470000-00-00196724519
9NM_001293717.121050000-00-001141912148
10NM_001301729.143010000-00-001163394371

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