Schema for ensTranscript
  Database: rn3    Primary Table: ensTranscript    Row Count: 64,418   Data last updated: 2004-04-30
Format description: This is the table transcript downloaded directly from Ensembl ftp site (18.34 release 11/04). Please refer to Ensembl site for details. CAUTION: Ensembl sometimes changes its table definitions and some field may not contais data as its name indicates.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(10) unsigned range internal system ID?
db corevarchar(40) values unknown - check with Ensembl
analysis ensemblvarchar(40) values unknown - check with Ensembl
type ensemblvarchar(40) values unknown - check with Ensembl
transcript_id 122346int(10) unsigned range transcript ID
transcript_name ENSRNOT00000016190varchar(40) values transcript name
transcript_version 2smallint(5) unsigned range transcript version
chr_name 2varchar(20) values chromosome number
chr_start 50438931int(10) unsigned range start position
chr_end 50445674int(10) unsigned range end position
chr_strand -1tinyint(4) range strand
coding_start 50438931int(10) unsigned range coding start position
coding_end 50445674int(10) unsigned range coding end position
translation_id 123107int(10) unsigned range translation ID
translation_name ENSRNOP00000016190varchar(40) values translation Name
translation_version 1smallint(5) unsigned range translation version
gene_id 96736int(10) unsigned range gene ID
gene_name ENSRNOG00000012136varchar(40) values gene name
gene_version 2smallint(5) unsigned range gene version
exon_structure 317:2022:177:1638:106:580:1...text values exon structure
exon_ids 736712:736711:736710:736709...text values exon IDs
external_db  varchar(40) values external database
external_name  varchar(40) values external name
external_status  varchar(10) values external status

Connected Tables and Joining Fields
        rn3.ensGeneXref.gene_name (via ensTranscript.gene_name)
      rn3.ensGtp.gene (via ensTranscript.gene_name)
      knownGeneV39.knownToEnsembl.value (via ensTranscript.transcript_name)
      rn3.ensGene.name (via ensTranscript.transcript_name)
      rn3.ensGeneXref.transcript_name (via ensTranscript.transcript_name)
      rn3.ensGtp.transcript (via ensTranscript.transcript_name)
      rn3.ensPep.name (via ensTranscript.transcript_name)
      rn3.knownToEnsembl.value (via ensTranscript.transcript_name)
      rn3.ensGtp.protein (via ensTranscript.translation_name)
      rn3.sfAssign.seqID (via ensTranscript.translation_name)

Sample Rows
 
iddbanalysistypetranscript_idtranscript_nametranscript_versionchr_namechr_startchr_endchr_strandcoding_startcoding_endtranslation_idtranslation_nametranslation_versiongene_idgene_namegene_versionexon_structureexon_idsexternal_dbexternal_nameexternal_status
1coreensemblensembl122346ENSRNOT00000016190225043893150445674-15043893150445674123107ENSRNOP00000016190196736ENSRNOG000000121362317:2022:177:1638:106:580:146:1181:577736712:736711:736710:736709:736708
2coreensemblensembl122347ENSRNOT0000001648522507950325086855215079503250868552123108ENSRNOP00000016485196737ENSRNOG000000122782346:65800:104:7073:198736713:736714:736715SWISSPROTFGFA_RATKNOWN
3coreensemblensembl122348ENSRNOT0000003717512511882995118936615118829951189366123109ENSRNOP00000029824196738ENSRNOG0000002710811068736716SPTREMBLO08872KNOWN
4coreensemblensembl122349ENSRNOT00000037130125140521951405928-15140521951405928123110ENSRNOP00000029746196739ENSRNOG000000268991377:131:202736718:736717
5coreensemblensembl122350ENSRNOT00000037049125142541051513863-15142541051513863123111ENSRNOP00000029643196740ENSRNOG000000268421150:1970:116:1288:119:15109:82:2781:160:9796:180:1932:161:1077:234:29509:188:4821:89:4188:88:4571:218:2254:230:6992:151736737:736732:736730:736729:736728:736727:736726:736725:736724:736723:736722:736721:736720:736719
6coreensemblensembl122351ENSRNOT0000002078021300347603006416213003476030064162123112ENSRNOP00000020780296741ENSRNOG00000015465279:2624:128:949:193:3246:109:9618:179:1254:207:1050:305:999:139:1489:197:1372:127:3278:112:1583:166736731:736733:736734:736735:736736:736738:736739:736740:736742:736744:736745:736747
7coreensemblensembl122352ENSRNOT00000033627125142541051513863-15142541051513863123113ENSRNOP00000029578196740ENSRNOG000000268421150:1970:116:1288:119:15109:82:2781:160:9796:180:1932:161:1077:234:3426:196:1718:146:1885:111:1017:162:2661:154:927:192:532:134: ...736737:736732:736730:736729:736728:736727:736726:736725:736752:736750:736749:736748:736746:736743:736741:736724:736723:736722:73 ...
8coreensemblensembl122353ENSRNOT00000033601125142541051513863-15142541051513863123114ENSRNOP00000029529196740ENSRNOG000000268421150:1970:116:1288:119:15109:82:2781:160:9796:180:1932:161:1077:234:3426:196:1718:146:24023:188:4821:89:4188:88:4571:218:2254:230 ...736737:736732:736730:736729:736728:736727:736726:736725:736752:736750:736724:736723:736722:736721:736720:736719
9coreensemblensembl122354ENSRNOT00000039166113007091430081020-13007091430081020123115ENSRNOP00000034617196742ENSRNOG000000282611195:302:154:9148:308736754:736753:736751
10coreensemblensembl122355ENSRNOT00000021000213014017730156831-13014017730156831123116ENSRNOP00000021000296743ENSRNOG000000156762101:3094:168:3798:103:851:39:2529:112:1474:133:2478:96:1606:73736762:736761:736760:736759:736758:736757:736756:736755

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