Schema for seqNcbiRefSeq
  Database: sorAra2    Primary Table: seqNcbiRefSeq    Row Count: 23,525   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_001280678.1varchar(128) values Accession of sequence
size 552int(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 575int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001280678.15520000-00-0010575
2NM_001281925.16340000-00-001575658
3NM_001285876.18340000-00-0011233861
4NM_001286187.111100000-00-00120941140
5NM_001290408.18300000-00-0013234857
6NM_001291139.146710000-00-00140914746
7NM_001291140.146710000-00-00188374746
8NM_001291520.142820000-00-001135834352
9NM_001293736.120630000-00-001179352105
10NM_001301748.141360000-00-001200404204

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