Schema for seqNcbiRefSeq
  Database: galGal6    Primary Table: seqNcbiRefSeq    Row Count: 62,160   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_001001127.1varchar(128) values Accession of sequence
size 1904int(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 1944int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001001127.119040000-00-00101944
2NM_001001129.114790000-00-00119441514
3NM_001001131.18430000-00-0013458870
4NM_001001189.115090000-00-00143281544
5NM_001001192.112960000-00-00158721329
6NM_001001193.15020000-00-0017201525
7NM_001001194.15140000-00-0017726537
8NM_001001195.225230000-00-00182632571
9NM_001001201.111930000-00-001108341224
10NM_001001203.19480000-00-00112058976

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