homo_sapiens_core_98_38 contains 492 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
genome_statistics	value	bigint unsigned	20			0
data_file	absolute	bit	0			0
analysis_description	displayable	bit	0			1
ditag_feature	hit_strand	bit	0			0
dna_align_feature	hit_strand	bit	0
exon	is_constitutive	bit	0			0
exon	is_current	bit	0			1
gene	is_current	bit	0			1
transcript	is_current	bit	0			1
intron_supporting_evidence	is_splice_canonical	bit	0			0
ditag_feature	seq_region_strand	bit	0			0
dna_align_feature	seq_region_strand	bit	0
protein_align_feature	seq_region_strand	bit	0			1
repeat_feature	seq_region_strand	bit	0			1
simple_feature	seq_region_strand	bit	0
data_file	version_lock	bit	0			0
analysis	created	datetime	19	√		null
mapping_session	created	datetime	19
exon	created_date	datetime	19	√		null
gene	created_date	datetime	19	√		null
operon	created_date	datetime	19	√		null
operon_transcript	created_date	datetime	19	√		null
rnaproduct	created_date	datetime	19	√		null
transcript	created_date	datetime	19	√		null
translation	created_date	datetime	19	√		null
exon	modified_date	datetime	19	√		null
gene	modified_date	datetime	19	√		null
operon	modified_date	datetime	19	√		null
operon_transcript	modified_date	datetime	19	√		null
rnaproduct	modified_date	datetime	19	√		null
transcript	modified_date	datetime	19	√		null
translation	modified_date	datetime	19	√		null
genome_statistics	timestamp	datetime	19	√		null
intron_supporting_evidence	score	decimal	10,3	√		null
dna_align_feature	evalue	double	22	√		null
identity_xref	evalue	double	22	√		null
protein_align_feature	evalue	double	22	√		null
protein_feature	evalue	double	22	√		null
dna_align_feature	hcoverage	double	22	√		null
protein_align_feature	hcoverage	double	22	√		null
marker_map_location	lod_score	double	22	√		null
prediction_exon	p_value	double	22	√		null
unmapped_object	query_score	double	22	√		null
dna_align_feature	score	double	22	√		null
identity_xref	score	double	22	√		null
prediction_exon	score	double	22	√		null
protein_align_feature	score	double	22	√		null
protein_feature	score	double	22	√		null
repeat_feature	score	double	22	√		null
simple_feature	score	double	22	√		null
unmapped_object	target_score	double	22	√		null
ditag_feature	ditag_side	enum	2
intron_supporting_evidence	score_type	enum	5	√		NONE
density_type	value_type	enum	5
data_file	file_type	enum	6	√		null
unmapped_object	type	enum	6
dna_align_feature	align_type	enum	8	√		ensembl
protein_align_feature	align_type	enum	8	√		ensembl
protein_feature	align_type	enum	9	√		null
biotype	biotype_group	enum	10	√		null
biotype	object_type	enum	10			gene
external_db	status	enum	10
unmapped_object	ensembl_object_type	enum	11	√		RawContig
assembly_exception	exc_type	enum	11
stable_id_event	type	enum	11
marker	type	enum	14	√		null
object_xref	ensembl_object_type	enum	16
xref	info_type	enum	18			NONE
external_db	type	enum	18	√		null
supporting_feature	feature_type	enum	21	√		null
transcript_supporting_feature	feature_type	enum	21	√		null
alt_allele_attrib	attrib	enum	35	√		null
density_feature	density_value	float	12
dna_align_feature	perc_ident	float	12	√		null
protein_align_feature	perc_ident	float	12	√		null
protein_feature	perc_ident	float	12	√		null
stable_id_event	score	float	12			0
assembly	asm_end	int	10
assembly	asm_start	int	10
biotype	attrib_type_id	int	10	√		null
density_type	block_size	int	10
assembly	cmp_end	int	10
assembly	cmp_start	int	10
identity_xref	ensembl_end	int	10	√		null
identity_xref	ensembl_identity	int	10	√		null
identity_xref	ensembl_start	int	10	√		null
dna_align_feature	hit_end	int	10
protein_align_feature	hit_end	int	10
protein_feature	hit_end	int	10
dna_align_feature	hit_start	int	10
protein_align_feature	hit_start	int	10
protein_feature	hit_start	int	10
meta_coord	max_length	int	10	√		null
meta	meta_id	int	10		√
assembly_exception	ori	int	10
external_db	priority	int	10
marker	priority	int	10	√		null
coord_system	rank	int	10
exon_transcript	rank	int	10
density_type	region_features	int	10
repeat_feature	repeat_end	int	10
repeat_feature	repeat_start	int	10
protein_feature	seq_end	int	10
rnaproduct	seq_end	int	10
translation	seq_end	int	10
protein_feature	seq_start	int	10
rnaproduct	seq_start	int	10
translation	seq_start	int	10
identity_xref	xref_end	int	10	√		null
identity_xref	xref_identity	int	10	√		null
identity_xref	xref_start	int	10	√		null
alt_allele	alt_allele_group_id	int unsigned	10
alt_allele_group	alt_allele_group_id	int unsigned	10		√
alt_allele	alt_allele_id	int unsigned	10		√
alt_allele_attrib	alt_allele_id	int unsigned	10	√		null
assembly	asm_seq_region_id	int unsigned	10
assembly_exception	assembly_exception_id	int unsigned	10		√
associated_group	associated_group_id	int unsigned	10		√
associated_xref	associated_group_id	int unsigned	10	√		null
associated_xref	associated_xref_id	int unsigned	10		√
genome_statistics	attrib_type_id	int unsigned	10	√		null
biotype	biotype_id	int unsigned	10		√
gene	canonical_transcript_id	int unsigned	10
transcript	canonical_translation_id	int unsigned	10	√		null
assembly	cmp_seq_region_id	int unsigned	10
coord_system	coord_system_id	int unsigned	10		√
data_file	coord_system_id	int unsigned	10
meta_coord	coord_system_id	int unsigned	10
seq_region	coord_system_id	int unsigned	10
data_file	data_file_id	int unsigned	10		√
density_feature	density_feature_id	int unsigned	10		√
density_feature	density_type_id	int unsigned	10
density_type	density_type_id	int unsigned	10		√
dependent_xref	dependent_xref_id	int unsigned	10
marker	display_marker_synonym_id	int unsigned	10	√		null
gene	display_xref_id	int unsigned	10	√		null
transcript	display_xref_id	int unsigned	10	√		null
ditag_feature	ditag_feature_id	int unsigned	10		√
ditag	ditag_id	int unsigned	10		√
ditag_feature	ditag_id	int unsigned	10			0
ditag_feature	ditag_pair_id	int unsigned	10			0
dna_align_feature	dna_align_feature_id	int unsigned	10		√
dna_align_feature_attrib	dna_align_feature_id	int unsigned	10
rnaproduct	end_exon_id	int unsigned	10	√		null
translation	end_exon_id	int unsigned	10
object_xref	ensembl_id	int unsigned	10
unmapped_object	ensembl_id	int unsigned	10	√		0
assembly_exception	exc_seq_region_end	int unsigned	10
assembly_exception	exc_seq_region_id	int unsigned	10
assembly_exception	exc_seq_region_start	int unsigned	10
exon	exon_id	int unsigned	10		√
exon_transcript	exon_id	int unsigned	10
supporting_feature	exon_id	int unsigned	10			0
dna_align_feature	external_db_id	int unsigned	10	√		null
external_db	external_db_id	int unsigned	10		√
protein_align_feature	external_db_id	int unsigned	10	√		null
seq_region_synonym	external_db_id	int unsigned	10	√		null
unmapped_object	external_db_id	int unsigned	10	√		null
xref	external_db_id	int unsigned	10
seq_region_mapping	external_seq_region_id	int unsigned	10
supporting_feature	feature_id	int unsigned	10			0
transcript_supporting_feature	feature_id	int unsigned	10			0
alt_allele	gene_id	int unsigned	10
gene	gene_id	int unsigned	10		√
gene_attrib	gene_id	int unsigned	10			0
operon_transcript_gene	gene_id	int unsigned	10	√		null
transcript	gene_id	int unsigned	10	√		null
genome_statistics	genome_statistics_id	int unsigned	10		√
ditag_feature	hit_end	int unsigned	10			0
ditag_feature	hit_start	int unsigned	10			0
seq_region_mapping	internal_seq_region_id	int unsigned	10
intron_supporting_evidence	intron_supporting_evidence_id	int unsigned	10		√
transcript_intron_supporting_evidence	intron_supporting_evidence_id	int unsigned	10
karyotype	karyotype_id	int unsigned	10		√
seq_region	length	int unsigned	10
map	map_id	int unsigned	10		√
marker_map_location	map_id	int unsigned	10
marker_feature	map_weight	int unsigned	10	√		null
gene_archive	mapping_session_id	int unsigned	10
mapping_session	mapping_session_id	int unsigned	10		√
stable_id_event	mapping_session_id	int unsigned	10			0
mapping_set	mapping_set_id	int unsigned	10
seq_region_mapping	mapping_set_id	int unsigned	10
marker_feature	marker_feature_id	int unsigned	10		√
marker	marker_id	int unsigned	10		√
marker_feature	marker_id	int unsigned	10
marker_map_location	marker_id	int unsigned	10
marker_synonym	marker_id	int unsigned	10
marker_map_location	marker_synonym_id	int unsigned	10
marker_synonym	marker_synonym_id	int unsigned	10		√
dependent_xref	master_xref_id	int unsigned	10
misc_set	max_length	int unsigned	10
marker	max_primer_dist	int unsigned	10
marker	min_primer_dist	int unsigned	10
misc_attrib	misc_feature_id	int unsigned	10			0
misc_feature	misc_feature_id	int unsigned	10		√
misc_feature_misc_set	misc_feature_id	int unsigned	10			0
transcript_intron_supporting_evidence	next_exon_id	int unsigned	10
associated_xref	object_xref_id	int unsigned	10			0
dependent_xref	object_xref_id	int unsigned	10
identity_xref	object_xref_id	int unsigned	10
object_xref	object_xref_id	int unsigned	10		√
ontology_xref	object_xref_id	int unsigned	10			0
operon	operon_id	int unsigned	10		√
operon_transcript	operon_id	int unsigned	10
operon_transcript	operon_transcript_id	int unsigned	10		√
operon_transcript_gene	operon_transcript_id	int unsigned	10	√		null
gene_archive	peptide_archive_id	int unsigned	10	√		null
peptide_archive	peptide_archive_id	int unsigned	10		√
prediction_exon	prediction_exon_id	int unsigned	10		√
prediction_exon	prediction_transcript_id	int unsigned	10
prediction_transcript	prediction_transcript_id	int unsigned	10		√
transcript_intron_supporting_evidence	previous_exon_id	int unsigned	10
protein_align_feature	protein_align_feature_id	int unsigned	10		√
protein_feature	protein_feature_id	int unsigned	10		√
associated_xref	rank	int unsigned	10	√		0
repeat_consensus	repeat_consensus_id	int unsigned	10		√
repeat_feature	repeat_consensus_id	int unsigned	10
repeat_feature	repeat_feature_id	int unsigned	10		√
rnaproduct	rnaproduct_id	int unsigned	10		√
rnaproduct_attrib	rnaproduct_id	int unsigned	10			0
assembly_exception	seq_region_end	int unsigned	10
density_feature	seq_region_end	int unsigned	10
ditag_feature	seq_region_end	int unsigned	10			0
dna_align_feature	seq_region_end	int unsigned	10
exon	seq_region_end	int unsigned	10
gene	seq_region_end	int unsigned	10
intron_supporting_evidence	seq_region_end	int unsigned	10
karyotype	seq_region_end	int unsigned	10
marker_feature	seq_region_end	int unsigned	10
misc_feature	seq_region_end	int unsigned	10			0
operon	seq_region_end	int unsigned	10
operon_transcript	seq_region_end	int unsigned	10
prediction_exon	seq_region_end	int unsigned	10
prediction_transcript	seq_region_end	int unsigned	10
protein_align_feature	seq_region_end	int unsigned	10
repeat_feature	seq_region_end	int unsigned	10
simple_feature	seq_region_end	int unsigned	10
transcript	seq_region_end	int unsigned	10
assembly_exception	seq_region_id	int unsigned	10
density_feature	seq_region_id	int unsigned	10
ditag_feature	seq_region_id	int unsigned	10			0
dna	seq_region_id	int unsigned	10
dna_align_feature	seq_region_id	int unsigned	10
exon	seq_region_id	int unsigned	10
gene	seq_region_id	int unsigned	10
intron_supporting_evidence	seq_region_id	int unsigned	10
karyotype	seq_region_id	int unsigned	10
marker_feature	seq_region_id	int unsigned	10
misc_feature	seq_region_id	int unsigned	10			0
operon	seq_region_id	int unsigned	10
operon_transcript	seq_region_id	int unsigned	10
prediction_exon	seq_region_id	int unsigned	10
prediction_transcript	seq_region_id	int unsigned	10
protein_align_feature	seq_region_id	int unsigned	10
repeat_feature	seq_region_id	int unsigned	10
seq_region	seq_region_id	int unsigned	10		√
seq_region_attrib	seq_region_id	int unsigned	10			0
seq_region_synonym	seq_region_id	int unsigned	10
simple_feature	seq_region_id	int unsigned	10
transcript	seq_region_id	int unsigned	10
assembly_exception	seq_region_start	int unsigned	10
density_feature	seq_region_start	int unsigned	10
ditag_feature	seq_region_start	int unsigned	10			0
dna_align_feature	seq_region_start	int unsigned	10
exon	seq_region_start	int unsigned	10
gene	seq_region_start	int unsigned	10
intron_supporting_evidence	seq_region_start	int unsigned	10
karyotype	seq_region_start	int unsigned	10
marker_feature	seq_region_start	int unsigned	10
misc_feature	seq_region_start	int unsigned	10			0
operon	seq_region_start	int unsigned	10
operon_transcript	seq_region_start	int unsigned	10
prediction_exon	seq_region_start	int unsigned	10
prediction_transcript	seq_region_start	int unsigned	10
protein_align_feature	seq_region_start	int unsigned	10
repeat_feature	seq_region_start	int unsigned	10
simple_feature	seq_region_start	int unsigned	10
transcript	seq_region_start	int unsigned	10
seq_region_synonym	seq_region_synonym_id	int unsigned	10		√
simple_feature	simple_feature_id	int unsigned	10		√
associated_xref	source_xref_id	int unsigned	10	√		null
ontology_xref	source_xref_id	int unsigned	10	√		null
coord_system	species_id	int unsigned	10			1
genome_statistics	species_id	int unsigned	10	√		1
meta	species_id	int unsigned	10	√		1
rnaproduct	start_exon_id	int unsigned	10	√		null
translation	start_exon_id	int unsigned	10
exon_transcript	transcript_id	int unsigned	10
rnaproduct	transcript_id	int unsigned	10
transcript	transcript_id	int unsigned	10		√
transcript_attrib	transcript_id	int unsigned	10			0
transcript_intron_supporting_evidence	transcript_id	int unsigned	10
transcript_supporting_feature	transcript_id	int unsigned	10			0
translation	transcript_id	int unsigned	10
protein_feature	translation_id	int unsigned	10
translation	translation_id	int unsigned	10		√
translation_attrib	translation_id	int unsigned	10			0
unmapped_object	unmapped_object_id	int unsigned	10		√
unmapped_object	unmapped_reason_id	int unsigned	10
unmapped_reason	unmapped_reason_id	int unsigned	10		√
associated_xref	xref_id	int unsigned	10			0
external_synonym	xref_id	int unsigned	10
object_xref	xref_id	int unsigned	10
xref	xref_id	int unsigned	10		√
dna	sequence	longtext	2147483647
peptide_archive	peptide_seq	mediumtext	16777215
coord_system	attrib	set	30	√		null
biotype	db_type	set	128			core
gene_archive	gene_version	smallint	5			1
stable_id_event	new_version	smallint	5	√		null
stable_id_event	old_version	smallint	5	√		null
gene_archive	transcript_version	smallint	5			1
gene_archive	translation_version	smallint	5			1
analysis	analysis_id	smallint unsigned	5		√
analysis_description	analysis_id	smallint unsigned	5
data_file	analysis_id	smallint unsigned	5
density_type	analysis_id	smallint unsigned	5
ditag_feature	analysis_id	smallint unsigned	5			0
dna_align_feature	analysis_id	smallint unsigned	5
gene	analysis_id	smallint unsigned	5
intron_supporting_evidence	analysis_id	smallint unsigned	5
marker_feature	analysis_id	smallint unsigned	5
object_xref	analysis_id	smallint unsigned	5	√		null
operon	analysis_id	smallint unsigned	5
operon_transcript	analysis_id	smallint unsigned	5
prediction_transcript	analysis_id	smallint unsigned	5
protein_align_feature	analysis_id	smallint unsigned	5
protein_feature	analysis_id	smallint unsigned	5
repeat_feature	analysis_id	smallint unsigned	5
simple_feature	analysis_id	smallint unsigned	5
transcript	analysis_id	smallint unsigned	5
unmapped_object	analysis_id	smallint unsigned	5
attrib_type	attrib_type_id	smallint unsigned	5		√
dna_align_feature_attrib	attrib_type_id	smallint unsigned	5
gene_attrib	attrib_type_id	smallint unsigned	5			0
misc_attrib	attrib_type_id	smallint unsigned	5			0
rnaproduct_attrib	attrib_type_id	smallint unsigned	5			0
seq_region_attrib	attrib_type_id	smallint unsigned	5			0
transcript_attrib	attrib_type_id	smallint unsigned	5			0
translation_attrib	attrib_type_id	smallint unsigned	5			0
prediction_exon	exon_rank	smallint unsigned	5
misc_feature_misc_set	misc_set_id	smallint unsigned	5			0
misc_set	misc_set_id	smallint unsigned	5		√
rnaproduct	rnaproduct_type_id	smallint unsigned	5
rnaproduct_type	rnaproduct_type_id	smallint unsigned	5		√
ditag	tag_count	smallint unsigned	5			1
exon	version	smallint unsigned	5	√		null
gene	version	smallint unsigned	5	√		null
operon	version	smallint unsigned	5	√		null
operon_transcript	version	smallint unsigned	5	√		null
rnaproduct	version	smallint unsigned	5	√		null
transcript	version	smallint unsigned	5	√		null
translation	version	smallint unsigned	5	√		null
dna_align_feature	cigar_line	text	65535	√		null
identity_xref	cigar_line	text	65535	√		null
protein_align_feature	cigar_line	text	65535	√		null
protein_feature	cigar_line	text	65535	√		null
analysis_description	description	text	65535	√		null
attrib_type	description	text	65535	√		null
biotype	description	text	65535	√		null
external_db	description	text	65535	√		null
gene	description	text	65535	√		null
misc_set	description	text	65535
rnaproduct_type	description	text	65535	√		null
transcript	description	text	65535	√		null
xref	description	text	65535	√		null
protein_feature	external_data	text	65535	√		null
protein_feature	hit_description	text	65535	√		null
analysis	parameters	text	65535	√		null
repeat_consensus	repeat_consensus	text	65535	√		null
data_file	url	text	65535	√		null
dna_align_feature_attrib	value	text	65535
gene_attrib	value	text	65535
misc_attrib	value	text	65535
rnaproduct_attrib	value	text	65535
seq_region_attrib	value	text	65535
transcript_attrib	value	text	65535
translation_attrib	value	text	65535
analysis_description	web_data	text	65535	√		null
exon	end_phase	tinyint	3
assembly	ori	tinyint	3
exon	phase	tinyint	3
exon	seq_region_strand	tinyint	3
gene	seq_region_strand	tinyint	3
intron_supporting_evidence	seq_region_strand	tinyint	3
misc_feature	seq_region_strand	tinyint	3			0
operon	seq_region_strand	tinyint	3
operon_transcript	seq_region_strand	tinyint	3
prediction_exon	seq_region_strand	tinyint	3
prediction_transcript	seq_region_strand	tinyint	3
transcript	seq_region_strand	tinyint	3
prediction_exon	start_phase	tinyint	3
ditag_feature	cigar_line	tinytext	255
ditag	sequence	tinytext	255
ontology_xref	linkage_type	varchar	3	√		null
mapping_session	new_release	varchar	5
mapping_session	old_release	varchar	5
xref	version	varchar	10	√		null
marker_map_location	chromosome_name	varchar	15
marker_map_location	position	varchar	15
attrib_type	code	varchar	20
rnaproduct_type	code	varchar	20
mapping_set	external_schema_build	varchar	20
mapping_set	internal_schema_build	varchar	20
mapping_session	new_assembly	varchar	20
mapping_session	old_assembly	varchar	20
marker_synonym	source	varchar	20	√		null
misc_set	code	varchar	25
map	map_name	varchar	30
ditag	name	varchar	30
ditag	type	varchar	30
peptide_archive	md5_checksum	varchar	32	√		null
karyotype	band	varchar	40	√		null
gene	biotype	varchar	40
transcript	biotype	varchar	40
analysis	db_version	varchar	40	√		null
analysis	gff_feature	varchar	40	√		null
analysis	gff_source	varchar	40	√		null
dna_align_feature	hit_name	varchar	40
protein_align_feature	hit_name	varchar	40
protein_feature	hit_name	varchar	40
interpro	id	varchar	40
interpro	interpro_ac	varchar	40
meta	meta_key	varchar	40
analysis	module_version	varchar	40	√		null
coord_system	name	varchar	40
analysis	program_version	varchar	40	√		null
repeat_consensus	repeat_type	varchar	40
gene	source	varchar	40
transcript	source	varchar	40			ensembl
karyotype	stain	varchar	40	√		null
meta_coord	table_name	varchar	40
marker_synonym	name	varchar	50	√		null
biotype	name	varchar	64
biotype	so_acc	varchar	64	√		null
analysis	module	varchar	80	√		null
mapping_session	new_db_name	varchar	80
mapping_session	old_db_name	varchar	80
analysis	program	varchar	80	√		null
analysis	program_file	varchar	80	√		null
external_db	db_name	varchar	100
intron_supporting_evidence	hit_name	varchar	100
marker	left_primer	varchar	100
data_file	name	varchar	100
repeat_consensus	repeat_class	varchar	100
marker	right_primer	varchar	100
external_synonym	synonym	varchar	100
analysis	db	varchar	120	√		null
analysis	db_file	varchar	120	√		null
associated_xref	condition_type	varchar	128	√		null
associated_group	description	varchar	128	√		null
gene_archive	gene_stable_id	varchar	128
analysis	logic_name	varchar	128
stable_id_event	new_stable_id	varchar	128	√		null
stable_id_event	old_stable_id	varchar	128	√		null
exon	stable_id	varchar	128	√		null
gene	stable_id	varchar	128	√		null
operon	stable_id	varchar	128	√		null
operon_transcript	stable_id	varchar	128	√		null
rnaproduct	stable_id	varchar	128	√		null
transcript	stable_id	varchar	128	√		null
translation	stable_id	varchar	128	√		null
genome_statistics	statistic	varchar	128
gene_archive	transcript_stable_id	varchar	128
gene_archive	translation_stable_id	varchar	128	√		null
seq_region_synonym	synonym	varchar	250
external_db	db_display_name	varchar	255	√		null
external_db	db_release	varchar	255	√		null
analysis_description	display_label	varchar	255
operon	display_label	varchar	255	√		null
operon_transcript	display_label	varchar	255	√		null
prediction_transcript	display_label	varchar	255	√		null
simple_feature	display_label	varchar	255
unmapped_reason	full_description	varchar	255	√		null
unmapped_object	identifier	varchar	255
xref	info_text	varchar	255
object_xref	linkage_annotation	varchar	255	√		null
meta	meta_value	varchar	255
attrib_type	name	varchar	255
misc_set	name	varchar	255
rnaproduct_type	name	varchar	255
seq_region	name	varchar	255
unmapped_object	parent	varchar	255	√		null
repeat_consensus	repeat_name	varchar	255
external_db	secondary_db_name	varchar	255	√		null
external_db	secondary_db_table	varchar	255	√		null
unmapped_reason	summary_description	varchar	255	√		null
coord_system	version	varchar	255	√		null
xref	dbprimary_acc	varchar	512
xref	display_label	varchar	512
biotype	so_term	varchar	1023	√		null