Schema for ensPep
  Database: rn3    Primary Table: ensPep    Row Count: 28,545   Data last updated: 2004-04-30
Format description: The mRNA sequence that represents each UCSC Genes transcript.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSRNOT00000020780.2varchar(255) values Name of gene
seq MAPGQRLVLCEETVRERSGLGPHRDLA...longblob   mRNA sequence

Connected Tables and Joining Fields
        knownGeneV39.knownToEnsembl.value (via ensPep.name)
      rn3.ensGene.name (via ensPep.name)
      rn3.ensGeneXref.transcript_name (via ensPep.name)
      rn3.ensGtp.transcript (via ensPep.name)
      rn3.ensTranscript.transcript_name (via ensPep.name)
      rn3.knownToEnsembl.value (via ensPep.name)

Sample Rows
 
nameseq
ENSRNOT00000020780.2MAPGQRLVLCEETVRERSGLGPHRDLAELRSLSIPGTYQEKITHLGNSLMHLTALKSLDLSRNSLVSLEGIQYLVSLESLNLYYNCISSLAEVFRLHTLMELQDVDFRLNPVVKNESDYRLFVVHMLP ...
ENSRNOT00000039166.1MADSKAKPTKAANKTPPKSPGDPAKAAKRLSLESEGANEGAAAAPELSALEEAFRRFAVHGDTRATGKEMHGKNWSKLCKDCHVIDGKNVTVTDVDIVFSKIKGKSCRTITFEQFQEALEELAKKRFK ...
ENSRNOT00000021000.2GYLKKLGDGSLLYSVVNATEPDADEEETHPVDLSSLSSKLLPGFTTLGFKDERRNKVTFLSSASTALSMQNNSVFGDLKSDEMELLYSAYGDETGVQCALSLQEFVKDAGSYSKKMVDDLLDQITGGD ...
ENSRNOT00000021112.2LFPCFLFINSAENESTPIQRLLEHFLRQLQRKDPHGFFAFPVTDAIAPGYSMIIKHPMDFGTMKDKIVANEYKSVTEFKADFKLMCDNAMTYNRPDTVYYKLAKKILHAGFKMMSKQAALLGSEDPAV ...
ENSRNOT00000021532.2MDDAVGDLKQALPCVAESPAVHVEVLQRSGSTAKKEDIKQSVYRLLKRHNIVFGDYVWTEFDEPFLTRNVQSVSIVDTELKAKDPQPIDLSACTIALHIFQLNEEGPSSENLDEETENIIAASHWVLP ...
ENSRNOT00000021898.1QELPNGDPKEGPFWEDKGSLEVVLPPEKSEGHEGQLFSVDDGEKAANREGPLRLSKKHLNIDALQCDVSVEEDNRQEWTFTLYDFDNSGKVTREDMSSLMHTIYEVVDASVNHSSGSSKTLRVKLTVS ...
ENSRNOT00000021995.2SSTGDGNPRENSPFINNVEVERESYFEGKNMALFEEEMDSNPMVSSLLNKLANYTNLSQGVVEHEEDEDSRRREIKAPRMGTFIGVYLPCLQNILGVILFLRLTWIVGAAGVLESFLIVAMCCTCTML ...
ENSRNOT00000022635.2MPTNFTVVPVEARADGAGDEAAERTEEPGSPESADPACPTPGDGNPRENSPFINNVEVERESYFEGKNMALFEEEMDSNPMVSSLLNKLANYTNLSQGVVEHEEDEDSRRREIKAPRMGTFIGVYLPC ...
ENSRNOT00000036714.1MVRLVLPNPGLEDRIPSLDELEVIEKEEASSRPKWDNKAQYMLTCVGFCVGLGNVWRFPYLCQSHGGGAFMIPFLILLVLEGIPLLHLEFAIGQRLRKGSVGVWSSIHPALKGVGIASMFVSFMVGLY ...
ENSRNOT00000036693.1MVRLVLPNPGLEDRIPSLDELEVIEKEEASSRPKWDNKAQYMLTCVGFCVGLGNVWRFPYLCQSHGGGAFMIPFLILLVLEGIPLLHLEFAIGQRLRKGSVGVWSSIHPALKGVGIASMFVSFMVGLY ...

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