Schema for ensPep

Database: macEug1 Primary Table: ensPep Row Count: 15,342 Data last updated: 2012-08-24
On download server: MariaDB table dump directory

field	example	SQL type	info
`name`	ENSMEUT00000000001	`varchar(255)`	values
`seq`	MTWVNQSLSTEFVFLAYPTYSELQVLV...	`longblob`

Connected Tables and Joining Fields


	knownGeneV39.knownToEnsembl.value (via ensPep.name) macEug1.ensGene.name (via ensPep.name) macEug1.ensGtp.transcript (via ensPep.name) macEug1.ensemblSource.name (via ensPep.name) macEug1.ensemblToGeneName.name (via ensPep.name)

Sample Rows

name	seq
ENSMEUT00000000001	MTWVNQSLSTEFVFLAYPTYSELQVLVFLGISLVYFMILTGNVLIVATIYMEACLHTPMYYLLGSLSIVEIWYTATVVPHILVNTMKRHKAITLLGCATQMLFFIGLGSTDCFLLAVMAYDRYVAICC ...
ENSMEUT00000000002	MPVPPPPPPPLPPPPPPIGAPPPPPPLASPASTEAPRLKKDVPQGRSALLADIQQGTRLRKVTQINDRSAPQIESSKGANKESGGAPGNSRGGAPQALGGLFAGGFPVLRPAGQRDGSPLHSSPSPRS ...
ENSMEUT00000000003	CGDTVEILEGKDAGKQGKVVQIIRERNWVVLEGLNTHFRYIGRSKDYRGTMIPSEAPLLFRQVKLVDPTDRKPTEVEWRFTEEGERVRVSLRTGRIIPKPEFPRPDGIIPEQWIDGPKDTSVEDALER ...
ENSMEUT00000000004	MNAIQRLLASHLRKRKMLLRFQSGDQPTVPLGSRILADPAKVYEHNMXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXKYESQASKYWNNFYKIHKNKFFKDRNWLLREFPEILPVGLQTKEEKGEM ...
ENSMEUT00000000005	MPGLAARNLTLEGRRQLAVDLTRVLPLYGFILDAYIIEFFTDCLWEKLPSSWQEVLDGLTPPQIATMLLEMPSAGEEIRYRSVWPLTLLALKATAHALAFIRTPESLGPNEFQENPSQSSLLAAQFRK ...
ENSMEUT00000000006	MSTLILNLDFGDCPPPKKATEGNHRHQRFIQRQRRIQRNLKQKQMQVPQAFGLHSKLQNNGGTLSTNSKQKLHPLPEPIEETPNQKNGIEKPLSRKVSTVSWLTPAPSRKTSSVSISSKVDLLSEFQS ...
ENSMEUT00000000007	VVRRVPGDRLREAAMDIFGDLRKMNKRQLYYQVLNFVMIMIWKGLIVVTGSESPIVVVLSGSMEPAFHRGDLLFLTNFQEDPIRAGEIVVFKVDGRDIPIVHRVIKVHEKDDGNVKFLTKGDNNEVDD ...
ENSMEUT00000000008	TPDEPSLLAPPRGPGCFSEESGCLDVSDFGCQLSSFHRTDPLHRFHTNRWNLTSCGTSVASSECSEELFSSVSVGDQDDCYSLLDDQDFTSFDLFPEGSVCSDVSSSISTYWDWSDSEFEWQLPGSDI ...
ENSMEUT00000000009	MAPKKKTVKKNKGEVNEMTIIVEDSPLSKLNALNSFLEGGNGLNCISSEVTDASYGPNLLEGLSKMRQENFLCDLVIGTKTKSFNVHKSVMASCSDYFYNILKKDPATQRVDLNDVSPLGLATVIAYA ...
ENSMEUT00000000010	MKKQFNRMRQLANQTVGRAEKTEVLNEDLLQVEKRLELVKQVSHSTHKKLTACLQGQQGVEADKRSKKLPLTALAQCLMEGSAILGDETLLGKMLKLCGETEDKLAQELIHFELQVERDVIEPLFVLA ...

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