Schema for seqNcbiRefSeq

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for seqNcbiRefSeq

Database: hg38 Primary Table: seqNcbiRefSeq Row Count: 159,067 Data last updated: 2020-06-30

field	example	SQL type	info
`id`	1	`int(10) unsigned`	range
`acc`	NM_000014.5	`varchar(128)`	values
`size`	4945	`int(10) unsigned`	range
`gb_date`	0000-00-00	`date`
`extFile`	1	`int(10) unsigned`	range
`file_offset`	0	`bigint(20)`	range
`file_size`	5020	`int(10) unsigned`	range

Connected Tables and Joining Fields


	hg38.ncbiRefSeqCurated.name (via seqNcbiRefSeq.acc) hg38.ncbiRefSeqLink.id (via seqNcbiRefSeq.acc) hg38.ncbiRefSeqPsl.qName (via seqNcbiRefSeq.acc)

Sample Rows

id	acc	size	gb_date	extFile	file_offset	file_size
1	NM_000014.5	4945	0000-00-00	1	0	5020
2	NM_000015.3	1285	0000-00-00	1	5020	1315
3	NM_000016.5	2623	0000-00-00	1	6335	2669
4	NM_000017.4	1859	0000-00-00	1	9004	1896
5	NM_000018.4	2184	0000-00-00	1	10900	2225
6	NM_000019.4	1537	0000-00-00	1	13125	1570
7	NM_000020.3	4177	0000-00-00	1	14695	4243
8	NM_000021.4	6018	0000-00-00	1	18938	6107
9	NM_000022.4	1496	0000-00-00	1	25045	1528
10	NM_000023.4	1429	0000-00-00	1	26573	1460

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