SchemaSpy Analysis of homo_sapiens_core_98_38 - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Nov 27 11:43 CET 2019 |
| ||||||
|
homo_sapiens_core_98_38 contains 492 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | |||
ditag_feature | ditag_side | enum | 2 | ||||
exon | end_phase | tinyint | 3 | ||||
ontology_xref | linkage_type | varchar | 3 | √ | null | ||
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 | ||||
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 | ||||
gene_archive | gene_version | smallint | 5 | 1 | |||
misc_feature_misc_set | misc_set_id | smallint unsigned | 5 | 0 | |||
misc_set | misc_set_id | smallint unsigned | 5 | √ | |||
mapping_session | new_release | varchar | 5 | ||||
stable_id_event | new_version | smallint | 5 | √ | null | ||
mapping_session | old_release | varchar | 5 | ||||
stable_id_event | old_version | smallint | 5 | √ | null | ||
rnaproduct | rnaproduct_type_id | smallint unsigned | 5 | ||||
rnaproduct_type | rnaproduct_type_id | smallint unsigned | 5 | √ | |||
intron_supporting_evidence | score_type | enum | 5 | √ | NONE | ||
ditag | tag_count | smallint unsigned | 5 | 1 | |||
gene_archive | transcript_version | smallint | 5 | 1 | |||
gene_archive | translation_version | smallint | 5 | 1 | |||
density_type | value_type | enum | 5 | ||||
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 | ||
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 | ||
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_end | int | 10 | ||||
assembly | asm_seq_region_id | int unsigned | 10 | ||||
assembly | asm_start | int | 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 | √ | |||
biotype | attrib_type_id | int | 10 | √ | null | ||
genome_statistics | attrib_type_id | int unsigned | 10 | √ | null | ||
biotype | biotype_group | enum | 10 | √ | null | ||
biotype | biotype_id | int unsigned | 10 | √ | |||
density_type | block_size | int | 10 | ||||
gene | canonical_transcript_id | int unsigned | 10 | ||||
transcript | canonical_translation_id | int unsigned | 10 | √ | null | ||
assembly | cmp_end | int | 10 | ||||
assembly | cmp_seq_region_id | int unsigned | 10 | ||||
assembly | cmp_start | int | 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 | ||||
identity_xref | ensembl_end | int | 10 | √ | null | ||
object_xref | ensembl_id | int unsigned | 10 | ||||
unmapped_object | ensembl_id | int unsigned | 10 | √ | 0 | ||
identity_xref | ensembl_identity | int | 10 | √ | null | ||
identity_xref | ensembl_start | int | 10 | √ | null | ||
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 | |||
dna_align_feature | hit_end | int | 10 | ||||
protein_align_feature | hit_end | int | 10 | ||||
protein_feature | hit_end | int | 10 | ||||
ditag_feature | hit_start | int unsigned | 10 | 0 | |||
dna_align_feature | hit_start | int | 10 | ||||
protein_align_feature | hit_start | int | 10 | ||||
protein_feature | hit_start | int | 10 | ||||
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 | ||||
meta_coord | max_length | int | 10 | √ | null | ||
misc_set | max_length | int unsigned | 10 | ||||
marker | max_primer_dist | int unsigned | 10 | ||||
meta | meta_id | int | 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 | ||||
biotype | object_type | enum | 10 | gene | |||
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 | ||
assembly_exception | ori | int | 10 | ||||
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 | ||||
external_db | priority | int | 10 | ||||
marker | priority | int | 10 | √ | null | ||
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 | ||
coord_system | rank | int | 10 | ||||
exon_transcript | rank | int | 10 | ||||
density_type | region_features | int | 10 | ||||
repeat_consensus | repeat_consensus_id | int unsigned | 10 | √ | |||
repeat_feature | repeat_consensus_id | int unsigned | 10 | ||||
repeat_feature | repeat_end | int | 10 | ||||
repeat_feature | repeat_feature_id | int unsigned | 10 | √ | |||
repeat_feature | repeat_start | int | 10 | ||||
rnaproduct | rnaproduct_id | int unsigned | 10 | √ | |||
rnaproduct_attrib | rnaproduct_id | int unsigned | 10 | 0 | |||
protein_feature | seq_end | int | 10 | ||||
rnaproduct | seq_end | int | 10 | ||||
translation | seq_end | int | 10 | ||||
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 | √ | |||
protein_feature | seq_start | int | 10 | ||||
rnaproduct | seq_start | int | 10 | ||||
translation | seq_start | int | 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 | ||||
external_db | status | enum | 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 | √ | |||
xref | version | varchar | 10 | √ | null | ||
identity_xref | xref_end | int | 10 | √ | null | ||
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 | √ | |||
identity_xref | xref_identity | int | 10 | √ | null | ||
identity_xref | xref_start | int | 10 | √ | null | ||
intron_supporting_evidence | score | decimal | 10,3 | √ | null | ||
unmapped_object | ensembl_object_type | enum | 11 | √ | RawContig | ||
assembly_exception | exc_type | enum | 11 | ||||
stable_id_event | type | enum | 11 | ||||
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 | |||
marker | type | enum | 14 | √ | null | ||
marker_map_location | chromosome_name | varchar | 15 | ||||
marker_map_location | position | varchar | 15 | ||||
object_xref | ensembl_object_type | enum | 16 | ||||
xref | info_type | enum | 18 | NONE | |||
external_db | type | enum | 18 | √ | null | ||
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 | ||
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 | ||
genome_statistics | value | bigint unsigned | 20 | 0 | |||
supporting_feature | feature_type | enum | 21 | √ | null | ||
transcript_supporting_feature | feature_type | enum | 21 | √ | 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 | ||
misc_set | code | varchar | 25 | ||||
coord_system | attrib | set | 30 | √ | null | ||
map | map_name | varchar | 30 | ||||
ditag | name | varchar | 30 | ||||
ditag | type | varchar | 30 | ||||
peptide_archive | md5_checksum | varchar | 32 | √ | null | ||
alt_allele_attrib | attrib | enum | 35 | √ | 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 | ||
biotype | db_type | set | 128 | core | |||
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 | ||||
ditag_feature | cigar_line | tinytext | 255 | ||||
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 | ||
ditag | sequence | tinytext | 255 | ||||
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 | ||
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 | ||
peptide_archive | peptide_seq | mediumtext | 16777215 | ||||
dna | sequence | longtext | 2147483647 |