Schema for seqNcbiRefSeq
  Database: felCat9    Primary Table: seqNcbiRefSeq    Row Count: 72,089   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_001009188.1varchar(128) values Accession of sequence
size 2139int(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 2182int(10) unsigned range byte size of sequence in file

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

Sample Rows
 
idaccsizegb_dateextFilefile_offsetfile_size
1NM_001009188.121390000-00-00102182
2NM_001009190.14080000-00-0012182430
3NM_001009193.15700000-00-0012612594
4NM_001009197.27470000-00-0013206773
5NM_001009199.11710000-00-0013979190
6NM_001009200.110570000-00-00141691087
7NM_001009203.118360000-00-00152561875
8NM_001009205.17530000-00-0017131779
9NM_001009206.13900000-00-0017910411
10NM_001009207.14890000-00-0018321512

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