SchemaSpy Analysis of cxgn.sgn - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 20 01:50 EDT 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.sgn contains 671 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
abstract deprecated_maps text 2147483647
abstract map text 2147483647  √  null
accession library varchar 255  √  null
accession_id accession serial 10  √  nextval('accession_accession_id_seq'::regclass)
accession_names.accession_id accession_id_fk
map.ancestor map_ancestor_fkey
map.parent_1 map_parent_1_fkey
map.parent_2 map_parent_2_fkey
pcr_exp_accession.accession_id accession_id_fk
accession_id accession_names int8 19  √  null
accession.accession_id accession_id_fk
accession_id pcr_exp_accession int8 19  √  null
accession.accession_id accession_id_fk
accession_id pcr_experiment varchar 7  √  null
accession_name accession_names varchar 255  √  null
accession_name_id accession int8 19  √  null
accession_names.accession_name_id accession_name_id_fk
accession_name_id accession_names bigserial 19  √  nextval('accession_names_accession_name_id_seq'::regclass)
accession.accession_name_id accession_name_id_fk
additional_enzymes pcr_experiment varchar 1023  √  null
alias marker_alias text 2147483647
alias_id marker_alias serial 10  √  nextval('marker_alias_alias_id_seq'::regclass)
align_length rflp_unigene_associations int8 19  √  null
alignment_seq family_member text 2147483647  √  null
ancestor map int4 10  √  null
accession.accession_id map_ancestor_fkey
ann_high ssr varchar 10  √  null
ann_low ssr varchar 10  √  null
annealing_temp pcr_experiment int8 19  √  null
annotation_target_id manual_annotations int8 19  √  null
annotation_target_type_id annotation_target_type bigserial 19  √  nextval('annotation_target_type_annotation_target_type_id_seq'::regclass)
annotation_target_type_id manual_annotations int8 19  √  null
annotation_text manual_annotations text 2147483647  √  null
annotation_text_fulltext manual_annotations tsvector 2147483647  √  null
apply_end blast_hits int8 19  √  null
apply_id blast_annotations int4 10  √  null
unigene.unigene_id apply_id_fkey
apply_start blast_hits int8 19  √  null
apply_type blast_annotations int4 10  √  null
arm fish_chromatin_density_constants varchar 1 'E'::character varying
arm_eu_length fish_karyotype_constants numeric 5,2
arm_het_length fish_karyotype_constants numeric 5,2
arm_length fish_karyotype_constants numeric 5,2
at_evalue cos_markers varchar 25  √  null
at_identities cos_markers numeric 11,3  √  null
at_match cos_markers varchar 25  √  null
at_position cos_markers numeric 11,7  √  null
attribution_display facility text 2147483647  √  null
attribution_id fish_result int8 19  √  null
attribution_id seqread int4 10  √  null
author_id authors serial 10  √  nextval('authors_author_id_seq'::regclass)
author_id manual_annotations int8 19  √  null
authors library varchar 255  √  null
bac_id cos_markers int8 19  √  null
band_size pcr_product int8 19  √  null
basecaller est varchar 40  √  null
basecaller qc_report varchar 40  √  null
batch_id seqread int4 10  √  null
begin cds int4 10  √  null
best_gb_prot_hit cos_markers varchar 25  √  null
blast_annotation_id blast_annotations serial 10  √  nextval('blast_annotations_blast_annotation_id_seq'::regclass)
blast_hits.blast_annotation_id blast_hits_blast_annotation_id_fkey
blast_annotation_id blast_hits int4 10  √  null
blast_annotations.blast_annotation_id blast_hits_blast_annotation_id_fkey
blast_db_group_id blast_db int4 10  √  null
blast_db_group.blast_db_group_id blast_db_blast_db_group_id_fkey
blast_db_group this belongs to, for displaying on web
blast_db_group_id blast_db_group serial 10  √  nextval('blast_db_group_blast_db_group_id_seq'::regclass)
blast_db.blast_db_group_id blast_db_blast_db_group_id_fkey
blast_db_id blast_db serial 10  √  nextval('blast_db_blast_db_id_seq'::regclass)
unigene_build.blast_db_id unigene_build_blast_db_id_fkey
blast_db_id unigene_build int4 10  √  null
blast_db.blast_db_id unigene_build_blast_db_id_fkey
blast_hit_id blast_hits serial 10  √  nextval('blast_hits_blast_hit_id_seq'::regclass)
blast_program blast_targets varchar 7  √  null
blast_target_id blast_annotations int4 10  √  null
blast_target_id blast_defline int4 10  √  null
blast_target_id blast_targets serial 10  √  nextval('blast_targets_blast_target_id_seq'::regclass)
build_date family_build timestamp 29,6 ('now'::text)::timestamp(6) with time zone
build_date unigene_build date 13  √  now()
build_nr family_build int8 19  √  null
build_nr unigene_build int4 10 0
call_positions est text 2147483647  √  null
cds_id cds bigserial 19  √  nextval('cds_cds_id_seq'::regclass)
domain_match.cds_id domain_match_cds_id_fkey
cds_id domain_match int8 19  √  null
cds.cds_id domain_match_cds_id_fkey
cds_id family_member int8 19  √  null
cds_seq cds text 2147483647  √  null
censor_id manual_censor_reasons serial 10  √  nextval('manual_censor_reasons_censor_id_seq'::regclass)
censor_id seqread int4 10  √  null
chemistry facility varchar 40  √  null
chip_name microarray varchar 80  √  null
chr_n_gnmc organism int4 10  √  null
chromo_arm fish_karyotype_constants text 2147483647
chromo_arm fish_result varchar 1
chromo_arm fish_result_composite varchar 1 'P'::character varying
chromo_arm_ratio fish_karyotype_constants_old float4 8,8  √  null
chromo_length fish_karyotype_constants_old float4 8,8  √  null
chromo_num fish_karyotype_constants int2 5
fish_karyotype_constants_old.chromo_num Implied Constraint
chromo_num fish_karyotype_constants_old int2 5 (0)::smallint
fish_karyotype_constants.chromo_num Implied Constraint
fish_result.chromo_num Implied Constraint
fish_result_composite.chromo_num Implied Constraint
chromo_num fish_result int2 5
fish_karyotype_constants_old.chromo_num Implied Constraint
chromo_num fish_result_composite int2 5 (0)::smallint
fish_karyotype_constants_old.chromo_num Implied Constraint
clone_group_id clone int4 10  √  null
clone_id clone serial 10  √  nextval('clone_clone_id_seq'::regclass)
ests_mapped_by_clone.clone_id clone_id_fk
fish_result.clone_id fish_result_clone_id_fkey
seqread.clone_id clone_id_fk
clone_id ests_mapped_by_clone int8 19  √  null
clone.clone_id clone_id_fk
clone_id fish_result int8 19
clone.clone_id fish_result_clone_id_fkey
clone_id fish_result_composite int8 19 (0)::bigint
clone_id microarray int4 10  √  null
clone_id seqread int4 10  √  null
clone.clone_id clone_id_fk
clone_name clone varchar 50  √  null
clone_name rflp_markers varchar 16  √  null
cloning_host library varchar 80  √  null
cloning_kit library varchar 255  √  null
cloning_vector_id cloning_vector serial 10  √  nextval('cloning_vector_cloning_vector_id_seq'::regclass)
cluster_no unigene int8 19  √  null
comment cos_markers text 2147483647  √  null
comment groups text 2147483647  √  null
comment tm_markers text 2147483647  √  null
comment tm_markers_sequences text 2147483647  √  null
comment trim_feature_types text 2147483647  √  null
comment types text 2147483647  √  null
comment unigene_build text 2147483647  √  null
comments library text 2147483647  √  null
common_name accession varchar 80  √  null
common_name common_name varchar 255
common_name_id common_name bigserial 19  √  nextval('common_name_common_name_id_seq'::regclass)
organism.common_name_id common_name_id_fk
organismprop.common_name_id organismprop_common_name_id_fkey
common_name_id organism int8 19
common_name.common_name_id common_name_id_fk
common_name_id organismprop int4 10
common_name.common_name_id organismprop_common_name_id_fkey
confidence deprecated_marker_locations int8 19 (0)::bigint
deprecated_marker_confidences.legacy_conf_id confidence_fk
confidence_id deprecated_marker_confidences serial 10  √  nextval('deprecated_marker_confidences_confidence_id_seq'::regclass)
map_version.default_threshold map_version_default_threshold_fkey
marker_confidence.confidence_id Implied Constraint
confidence_id marker_confidence serial 10  √  nextval('marker_confidence_confidence_id_seq'::regclass)
marker_location.confidence_id marker_location_confidence_id_fkey
deprecated_marker_confidences.confidence_id Implied Constraint
confidence_id marker_location int4 10
marker_confidence.confidence_id marker_location_confidence_id_fkey
confidence_id marker_to_map int4 10  √  null
confidence_name deprecated_marker_confidences varchar 16  √  null
confidence_name marker_confidence text 2147483647  √  null
confirm_code submit_user varchar 16  √  null
consensi_id unigene int4 10  √  null
unigene_consensi.consensi_id unigene_unigene_consensi_id_fkey
consensi_id unigene_consensi serial 10  √  nextval('unigene_consensi_consensi_id_seq'::regclass)
unigene.consensi_id unigene_unigene_consensi_id_fkey
contact_information library text 2147483647  √  null
contact_information submit_user text 2147483647  √  null
content_specific_tag microarray varchar 40  √  null
contig_no unigene int8 19  √  null
copies cosii_ortholog varchar 1  √  null
cos_id cos_markers varchar 10 ''::character varying
cos_marker_id cos_markers serial 10  √  nextval('cos_markers_cos_marker_id_seq'::regclass)
cosii_unigene_id cosii_ortholog bigserial 19  √  nextval('cosii_ortholog_cosii_unigene_id_seq'::regclass)
create_date library timestamptz 35,6  √  null
create_date metadata timestamptz 35,6  √  now()
create_person_id metadata int4 10
cultivar library varchar 255  √  null
current_tc_id tigrtc_tracking int4 10  √  null
current_version map_version bool 1  √  null
current_version marker_to_map bool 1  √  null
cutting_site rflp_markers varchar 32  √  null
database_name cosii_ortholog varchar 11  √  null
database_name family_member varchar 20  √  null
database_name unigene varchar 2147483647 'SGN'::character varying
date est date 13  √  null
date seqread timestamp 29,6 ('now'::text)::timestamp(6) with time zone
date_entered manual_annotations date 13  √  null
date_loaded map_version date 13  √  null
db_name blast_targets varchar 80  √  null
db_path blast_targets varchar 255  √  null
dbxref_id domain int8 19  √  null
dbxref_id est_dbxref int4 10
default_threshold deprecated_maps int8 19 (0)::bigint
default_threshold map_version int4 10  √  null
deprecated_marker_confidences.confidence_id map_version_default_threshold_fkey
defline blast_defline text 2147483647  √  null
defline_fulltext blast_defline tsvector 2147483647  √  null
defline_id blast_defline serial 10  √  nextval('blast_defline_defline_id_seq'::regclass)
defline_id blast_hits int4 10  √  null
density fish_chromatin_density_constants float4 8,8  √  null
deprecated_by deprecated_maps int8 19  √  (0)::bigint
derived_from_source_id derived_from_source serial 10  √  nextval('derived_from_source_derived_from_source_id_seq'::regclass)
marker_derived_from.derived_from_source_id marker_derived_from_derived_from_source_id_fkey
derived_from_source_id marker_derived_from int4 10  √  null
derived_from_source.derived_from_source_id marker_derived_from_derived_from_source_id_fkey
description blast_db text 2147483647  √  null
description cos_markers text 2147483647  √  null
description deprecated_marker_types text 2147483647  √  null
description domain text 2147483647  √  null
description experiment_type text 2147483647  √  null
description go text 2147483647  √  null
description interpro text 2147483647  √  null
description_fulltext domain tsvector 2147483647  √  null
description_fulltext go tsvector 2147483647  √  null
description_fulltext interpro tsvector 2147483647  √  null
development_stage library varchar 255  √  null
dir unigene_member bpchar 1  √  null
direction seqread bpchar 1  √  null
disabled submit_user int8 19  √  null
domain_accession domain varchar 20  √  null
domain_id domain bigserial 19  √  nextval('domain_domain_id_seq'::regclass)
domain_match.domain_id domain_match_domain_id_fkey
domain_id domain_match int8 19  √  null
domain.domain_id domain_match_domain_id_fkey
domain_match_id domain_match bigserial 19  √  nextval('domain_match_domain_match_id_seq'::regclass)
drug_resistance rflp_markers varchar 16  √  null
dummy_field marker bool 1  √  null
e_val rflp_unigene_associations float8 17,17  √  null
e_value domain_match varchar 10  √  null
e_value primer_unigene_match float8 17,17  √  null
e_value ssr_primer_unigene_matches varchar 32 ''::character varying
edited_sequence_id cosii_ortholog int8 19  √  null
email_address submit_user varchar 255  √  null
embc_id ests_mapped_by_clone serial 10  √  nextval('ests_mapped_by_clone_embc_id_seq'::regclass)
end cds int4 10  √  null
end trim_feature int8 19  √  null
end_primer ssr varchar 100  √  null
entropy qc_report float4 8,8  √  null
enzyme_id enzyme_restriction_sites int4 10  √  null
enzyme_id enzymes serial 10  √  nextval('enzymes_enzyme_id_seq'::regclass)
pcr_product.enzyme_id enzyme_id_fk
enzyme_id pcr_product int8 19  √  null
enzymes.enzyme_id enzyme_id_fk
enzyme_name enzymes varchar 32  √  null
enzyme_restriction_sites_id enzyme_restriction_sites serial 10  √  nextval('enzyme_restriction_sites_enzyme_restriction_sites_id_seq'::regclass)
est_attribution_tqmc organism text 2147483647  √  null
est_clone_id p_markers int8 19 (0)::bigint
est_dbxref_id est_dbxref serial 10  √  nextval('sgn.est_dbxref_est_dbxref_id_seq'::regclass)
est_id est serial 10  √  nextval('est_est_id_seq'::regclass)
est_dbxref.est_id est_dbxref_est_id_fkey
qc_report.est_id est_id_fk
unigene_member.est_id est_id_fkey
est_id est_dbxref int4 10
est.est_id est_dbxref_est_id_fkey
est_id qc_report int4 10 0
est.est_id est_id_fk
est_id trim_feature int4 10  √  null
est_id unigene_member int4 10  √  null
est.est_id est_id_fkey
est_read_id cos_markers int8 19 (0)::bigint
est_read_id ssr int8 19  √  null
est_read_id tm_markers int8 19  √  null
evalue blast_hits float8 17,17  √  null
expected_error qc_report float4 8,8  √  null
experiment_group fish_result varchar 12  √  null
experiment_group fish_result_composite varchar 12  √  null
experiment_name fish_result varchar 10
experiment_name fish_result_composite varchar 10  √  null
experiment_type_id experiment_type bigserial 19  √  nextval('experiment_type_experiment_type_id_seq'::regclass)
pcr_experiment.experiment_type_id experiment_type_id_fk
experiment_type_id pcr_experiment int8 19  √  null
experiment_type.experiment_type_id experiment_type_id_fk
facility_address facility text 2147483647  √  null
facility_contact facility varchar 80  √  null
facility_id facility serial 10  √  nextval('facility_facility_id_seq'::regclass)
seqread.facility_id facility_id_fk
facility_id seqread int4 10  √  null
facility.facility_id facility_id_fk
facility_moniker facility varchar 20  √  null
facility_name facility varchar 80  √  null
facility_shortname facility varchar 12  √  null
family_annotation family text 2147483647  √  null
family_build_id family int8 19  √  null
family_build.family_build_id family_family_build_id_fkey
family_build_id family_build bigserial 19  √  nextval('family_build_family_build_id_seq'::regclass)
family.family_build_id family_family_build_id_fkey
family_id family bigserial 19  √  nextval('family_family_id_seq'::regclass)
family_member.family_id family_member_family_id_fkey
family_tree.family_id family_tree_family_id_fkey
family_id family_member int8 19  √  null
family.family_id family_member_family_id_fkey
family_id family_tree int4 10
family.family_id family_tree_family_id_fkey
family_member_id family_member bigserial 19  √  nextval('family_member_family_member_id_seq'::regclass)
family_nr family int4 10  √  null
family_tax organism int4 10  √  null
taxonomy.tax_id organism_family_tax_fkey
family_tree_id family_tree serial 10  √  nextval('family_tree_family_tree_id_seq'::regclass)
fasta_sequence rflp_sequences text 2147483647
feature_id trim_feature serial 10  √  nextval('trim_feature_feature_id_seq'::regclass)
file_base blast_db varchar 120 the basename of the blast db files, relative to the root of the databases repository.  A blast DB is usually composed of 3 files, all with a given basename, and with the extensions .[pn]in, .[pn]sq, and .[pn]hr.
filename fish_file varchar 255  √  null
filename fish_image varchar 255  √  null
fish_experimenter_id fish_experimenter serial 10  √  nextval('fish_experimenter_fish_experimenter_id_seq'::regclass)
fish_result.fish_experimenter_id fish_experimenter_id_fkey
fish_experimenter_id fish_karyotype_constants int4 10
fish_experimenter_id fish_result int4 10
fish_experimenter.fish_experimenter_id fish_experimenter_id_fkey
fish_experimenter_id fish_result_composite int4 10  √  null
fish_experimenter_name fish_experimenter varchar 20  √  null
fish_file_id fish_file bigserial 19  √  nextval('fish_file_fish_file_id_seq'::regclass)
fish_image_id fish_image int4 10 0
fish_result_id fish_file int8 19 (0)::bigint
fish_result_composite.fish_result_id Implied Constraint
fish_result_id fish_image int4 10 0
fish_result_id fish_result bigserial 19  √  nextval('fish_result_fish_result_id_seq'::regclass)
fish_result_id fish_result_composite int8 19 (0)::bigint
fish_file.fish_result_id Implied Constraint
flags est int8 19  √  null
forward_adapter library varchar 2147483647  √  null
forward_reverse cds bpchar 1  √  null
forward_seq_id rflp_markers int8 19  √  null
rflp_sequences.seq_id forward_seq_id_fk
frame cds varchar 2  √  null
funding_agency facility varchar 80  √  null
funding_comment facility text 2147483647  √  null
gbprot_evalue cos_markers varchar 25  √  null
gbprot_identities cos_markers numeric 11,3  √  null
genbank_confirmed est bool 1  √  null
genbank_submission_date est date 13  √  null
genetic_cross deprecated_maps varchar 250  √  null
genom_proj_gnmc organism text 2147483647  √  null
genom_size_gnmc organism varchar 50  √  null
genus_tax organism int4 10  √  null
taxonomy.tax_id organism_genus_tax_fkey
go_accession go varchar 20  √  null
interpro_go.go_accession interpro_go_go_accession_fkey
go_accession interpro_go varchar 20  √  null
go.go_accession interpro_go_go_accession_fkey
go_id go bigserial 19  √  nextval('go_go_id_seq'::regclass)
group_id family_build int8 19  √  null
group_id group_linkage int4 10  √  null
group_id groups serial 10  √  nextval('groups_group_id_seq'::regclass)
unigene_build.organism_group_id unigene_build_organism_group_id_fkey
group_linkage_id group_linkage serial 10  √  nextval('group_linkage_group_linkage_id_seq'::regclass)
has_il map_version bool 1  √  null
has_physical map_version bool 1  √  null
header deprecated_maps text 2147483647
het_or_eu fish_result_composite varchar 1  √  null
hit_status domain_match bpchar 1  √  null
hits_stored blast_annotations int4 10  √  null
host blast_annotations varchar 20  √  null
hqi_length qc_report int8 19  √  null
hqi_start qc_report int8 19  √  null
i_value family_build float8 17,17  √  null
id_in_source marker_derived_from int4 10  √  null
id_linkage_id id_linkage serial 10  √  nextval('id_linkage_id_linkage_id_seq'::regclass)
identifier_defline_fulltext blast_defline tsvector 2147483647  √  null
identity_percentage blast_hits float8 17,17  √  null
iend qc_report int8 19  √  null
index_field_name annotation_target_type varchar 250  √  null
index_name tigrtc_index varchar 40  √  null
index_seqs blast_db bool 1 false corresponds to formatdb -o option.  Set true if formatdb should be given a '-o T'.  This is used only if you later want to fetch specific sequences out of this blast db.
info_url blast_db varchar 255  √  null
insert_size rflp_markers int8 19 (0)::bigint
institution authors text 2147483647  √  null
internal_id id_linkage int4 10  √  null
internal_id_type id_linkage int4 10  √  null
interpro_accession interpro varchar 20  √  null
interpro_go.interpro_accession interpro_go_interpro_accession_fkey
interpro_accession interpro_go varchar 20  √  null
interpro.interpro_accession interpro_go_interpro_accession_fkey
interpro_go_id interpro_go bigserial 19  √  nextval('interpro_go_interpro_go_id_seq'::regclass)
interpro_id domain int8 19  √  null
interpro_id interpro bigserial 19  √  nextval('interpro_interpro_id_seq'::regclass)
introns cosii_ortholog text 2147483647  √  null
istart qc_report int8 19  √  null
last_modified manual_annotations date 13  √  null
last_updated blast_annotations int4 10  √  null
latest_build_id unigene_build int4 10  √  null
unigene_build.unigene_build_id unigene_build_latest_build_id_fkey
legacy_conf_id deprecated_marker_confidences int8 19  √  null
deprecated_marker_locations.confidence confidence_fk
legacy_id deprecated_maps int8 19 (0)::bigint
lg_id deprecated_linkage_groups bigserial 19  √  nextval('deprecated_linkage_groups_lg_id_seq'::regclass)
deprecated_mapdata.lg_id lg_id_fk
lg_id deprecated_mapdata int8 19  √  null
deprecated_linkage_groups.lg_id lg_id_fk
lg_id linkage_group serial 10  √  nextval('linkage_group_lg_id_seq'::regclass)
marker_location.lg_id marker_location_lg_id_fkey
lg_id marker_location int4 10
linkage_group.lg_id marker_location_lg_id_fkey
lg_name deprecated_linkage_groups varchar 255  √  null
lg_name il_info text 2147483647  √  null
lg_name linkage_group text 2147483647  √  null
lg_name marker_to_map text 2147483647  √  null
lg_order deprecated_linkage_groups int8 19  √  null
lg_order linkage_group int4 10
lg_order marker_to_map int4 10  √  null
library_id clone int4 10  √  null
library.library_id library_id_fk
library_id library serial 10  √  nextval('library_library_id_seq'::regclass)
clone.library_id library_id_fk
library_name library varchar 80  √  null
library_name rflp_markers varchar 64  √  null
library_shortname library varchar 16  √  null
link_id id_linkage varchar 80  √  null
link_id_type id_linkage int4 10  √  null
loc_id deprecated_mapdata serial 10  √  nextval('deprecated_mapdata_loc_id_seq'::regclass)
deprecated_marker_locations.loc_id loc_id_fk
loc_id deprecated_marker_locations int8 19 (0)::bigint
deprecated_mapdata.loc_id loc_id_fk
loc_order deprecated_mapdata int8 19 (0)::bigint
loc_type deprecated_mapdata int8 19 (0)::bigint
loc_type_id loc_types serial 10  √  nextval('loc_types_loc_type_id_seq'::regclass)
local_copy_timestamp blast_targets int4 10  √  null
location_id marker_experiment int4 10  √  null
marker_location.location_id marker_experiment_location_id_fkey
location_id marker_location serial 10  √  nextval('marker_location_location_id_seq'::regclass)
linkage_group.north_location_id linkage_group_north_location_id_fkey
linkage_group.south_location_id linkage_group_south_location_id_fkey
marker_experiment.location_id marker_experiment_location_id_fkey
location_id marker_to_map int4 10  √  null
location_subscript deprecated_marker_locations bpchar 2  √  null
long_arm_eu_length fish_karyotype_constants_old float4 8,8  √  null
long_arm_het_length fish_karyotype_constants_old float4 8,8  √  null
long_arm_length fish_karyotype_constants_old float4 8,8  √  null
long_name deprecated_maps varchar 250 ''::character varying
long_name map text 2147483647  √  null
lookup_url blast_db varchar 255  √  null
machine facility varchar 40  √  null
manual_annotations_id manual_annotations bigserial 19  √  nextval('manual_annotations_manual_annotations_id_seq'::regclass)
map_cross_id deprecated_map_cross serial 10  √  nextval('deprecated_map_cross_map_cross_id_seq'::regclass)
map_id deprecated_linkage_groups int8 19  √  null
deprecated_maps.map_id map_id_fk
map_id deprecated_map_cross int8 19 (0)::bigint
deprecated_maps.map_id map_id_fk
map_id deprecated_mapdata int8 19 (0)::bigint
deprecated_maps.map_id map_id_fk
map_id deprecated_maps serial 10  √  nextval('deprecated_maps_map_id_seq'::regclass)
deprecated_linkage_groups.map_id map_id_fk
deprecated_map_cross.map_id map_id_fk
deprecated_mapdata.map_id map_id_fk
fish_result.map_id map_id_fkey
map.map_id Implied Constraint
temp_map_correspondence.old_map_id temp_map_correspondence_old_map_id_fkey
map_id fish_result int8 19
deprecated_maps.map_id map_id_fkey
map_id fish_result_composite int8 19 (0)::bigint
map_id il_info int4 10  √  null
map_id map serial 10  √  nextval('map_map_id_seq'::regclass)
map_version.map_id map_version_map_id_fkey
pcr_experiment.map_id map_id_fk
deprecated_maps.map_id Implied Constraint
map_id map_version int4 10  √  null
map.map_id map_version_map_id_fkey
map_id marker_to_map int4 10  √  null
map_id pcr_experiment int8 19  √  null
map.map_id map_id_fk
map_type deprecated_maps varchar 7  √  null
map_type map text 2147483647  √  null
map_version_id il_info int4 10  √  null
map_version_id linkage_group int4 10  √  null
map_version.map_version_id linkage_group_map_version_id_fkey
map_version_id map_version serial 10  √  nextval('map_version_map_version_id_seq'::regclass)
linkage_group.map_version_id linkage_group_map_version_id_fkey
marker_location.map_version_id marker_location_map_version_id_fkey
temp_map_correspondence.map_version_id temp_map_correspondence_map_version_id_fkey
map_version_id marker_location int4 10
map_version.map_version_id marker_location_map_version_id_fkey
map_version_id marker_to_map int4 10  √  null
map_version_id temp_map_correspondence int4 10  √  null
map_version.map_version_id temp_map_correspondence_map_version_id_fkey
mapmaker_id deprecated_marker_locations int8 19 (0)::bigint
marker_collectible_dummy_id marker_collectible serial 10  √  nextval('marker_collectible_marker_collectible_dummy_id_seq'::regclass)
marker_derived_dummy_id marker_derived_from serial 10  √  nextval('marker_derived_from_marker_derived_dummy_id_seq'::regclass)
marker_experiment_id marker_experiment serial 10  √  nextval('marker_experiment_marker_experiment_id_seq'::regclass)
marker_id cos_markers int8 19 (0)::bigint
marker.marker_id marker_id_fk
marker_id cosii_ortholog int8 19  √  null
marker.marker_id marker_id_fk
marker_id deprecated_marker_locations int8 19 (0)::bigint
deprecated_markers.marker_id marker_id_fk
marker_id deprecated_markers serial 10  √  nextval('deprecated_markers_marker_id_seq'::regclass)
deprecated_marker_locations.marker_id marker_id_fk
marker_derived_from.marker_id marker_derived_from_marker_id_fkey
temp_marker_correspondence.old_marker_id temp_marker_correspondence_old_marker_id_fkey
marker.marker_id Implied Constraint
marker_id ests_mapped_by_clone int8 19  √  null
marker.marker_id marker_id_fk
marker_id marker serial 10  √  nextval('marker_marker_id_seq'::regclass)
cos_markers.marker_id marker_id_fk
cosii_ortholog.marker_id marker_id_fk
deprecated_markers.marker_id Implied Constraint
ests_mapped_by_clone.marker_id marker_id_fk
marker_alias.marker_id marker_alias_marker_id_fkey
marker_collectible.marker_id marker_collectible_marker_id_fkey
marker_experiment.marker_id marker_experiment_marker_id_fkey
p_markers.marker_id marker_id_fk
pcr_experiment.marker_id marker_id_fk
primer_unigene_match.marker_id marker_id_fk
rflp_markers.marker_id marker_id_fk
ssr.marker_id marker_id_fk
ssr_repeats.marker_id marker_id_fk
tm_markers.marker_id marker_id_fk
marker_id marker_alias int4 10
marker.marker_id marker_alias_marker_id_fkey
marker_id marker_collectible int4 10
marker.marker_id marker_collectible_marker_id_fkey
marker_id marker_derived_from int4 10  √  null
deprecated_markers.marker_id marker_derived_from_marker_id_fkey
marker_id marker_experiment int4 10  √  null
marker.marker_id marker_experiment_marker_id_fkey
marker_id marker_to_map int4 10  √  null
marker_id p_markers int8 19 (0)::bigint
marker.marker_id marker_id_fk
marker_id pcr_experiment int8 19  √  null
marker.marker_id marker_id_fk
marker_id primer_unigene_match int4 10
marker.marker_id marker_id_fk
marker_id rflp_markers int8 19 (0)::bigint
marker.marker_id marker_id_fk
marker_id ssr int8 19 (0)::bigint
marker.marker_id marker_id_fk
marker_id ssr_repeats int4 10
marker.marker_id marker_id_fk
marker_id tm_markers int8 19 (0)::bigint
marker.marker_id marker_id_fk
marker_location_id deprecated_marker_locations serial 10  √  nextval('deprecated_marker_locations_marker_location_id_seq'::regclass)
marker_name deprecated_markers varchar 32 ''::character varying
marker_prefix rflp_markers varchar 8  √  null
marker_suffix rflp_markers int2 5  √  null
marker_table deprecated_marker_types varchar 128  √  null
marker_type deprecated_markers int8 19 (0)::bigint
deprecated_marker_types.marker_type_id marker_type_fk
marker_type_id deprecated_marker_types serial 10  √  nextval('deprecated_marker_types_marker_type_id_seq'::regclass)
deprecated_markers.marker_type marker_type_fk
match_begin domain_match int4 10  √  null
match_end domain_match int4 10  √  null
match_length primer_unigene_match int4 10  √  null
match_length ssr_primer_unigene_matches int8 19 (0)::bigint
mbp_from_arm_border fish_result_composite float4 8,8  √  null
mbp_from_arm_end fish_result_composite float4 8,8  √  null
mbp_from_centromere fish_result_composite float4 8,8  √  null
mc_description marker_collection text 2147483647  √  null
mc_id marker_collectible int4 10
marker_collection.mc_id marker_collectible_mc_id_fkey
mc_id marker_collection serial 10  √  nextval('marker_collection_mc_id_seq'::regclass)
marker_collectible.mc_id marker_collectible_mc_id_fkey
mc_name marker_collection text 2147483647
member_count family int4 10  √  null
member_id group_linkage int4 10  √  null
member_type group_linkage int8 19  √  null
member_value group_linkage bytea 2147483647  √  null
metadata_id domain int8 19  √  null
metadata.metadata_id domain_metadata_id_fkey
metadata_id domain_match int8 19  √  null
metadata.metadata_id domain_match_metadata_id_fkey
metadata_id metadata bigserial 19  √  nextval('sgn.metadata_metadata_id_seq'::regclass)
domain.metadata_id domain_metadata_id_fkey
domain_match.metadata_id domain_match_metadata_id_fkey
method cds varchar 20  √  null
method_id domain int8 19  √  null
method_id unigene_build int4 10  √  null
mg_concentration pcr_experiment float4 8,8  √  null
microarray_id microarray serial 10  √  nextval('microarray_microarray_id_seq'::regclass)
mips_cat cos_markers varchar 11  √  null
misc_id misc int4 10  √  null
misc_unique_id misc serial 10  √  nextval('misc_misc_unique_id_seq'::regclass)
modified_date library timestamptz 35,6  √  null
modified_date metadata timestamptz 35,6  √  null
modified_person_id metadata int4 10  √  null
multiple_flag pcr_product int8 19  √  null
n_hits blast_annotations int4 10  √  null
name authors text 2147483647  √  null
name blast_db_group varchar 50  √  null
name cloning_vector varchar 32  √  null
name experiment_type varchar 255  √  null
name il_info varchar 100  √  null
name misc text 2147483647  √  null
name submit_user varchar 80  √  null
new_marker_id temp_caps_correspondence int4 10  √  null
new_marker_id temp_marker_correspondence int4 10  √  null
newick_cds family_tree varchar 2147483647  √  null
newick_unigene family_tree varchar 2147483647  √  null
next_build_id unigene_build int4 10  √  null
unigene_build.unigene_build_id unigene_build_next_build_id_fkey
north_location_id linkage_group int4 10  √  null
marker_location.location_id linkage_group_north_location_id_fkey
nr_members unigene int8 19  √  null
ns_alias il_info text 2147483647  √  null
ns_marker_id il_info int4 10  √  null
ns_position il_info numeric 8,5  √  null
number_chromosomes deprecated_maps int8 19 (0)::bigint
obsolete library bool 1  √  null
obsolete metadata int4 10  √  0
obsolete_note metadata varchar 250  √  null
offset deprecated_mapdata numeric 8,5  √  null
old_cos_id tm_markers varchar 32  √  null
old_map_id temp_map_correspondence int4 10  √  null
deprecated_maps.map_id temp_map_correspondence_old_map_id_fkey
old_marker_id temp_caps_correspondence int4 10  √  null
old_marker_id temp_marker_correspondence int4 10  √  null
deprecated_markers.marker_id temp_marker_correspondence_old_marker_id_fkey
order_in_loc deprecated_marker_locations int8 19 (0)::bigint
order_routing_id library int8 19  √  null
order_tax organism int4 10  √  null
taxonomy.tax_id organism_order_tax_fkey
ordinal blast_db_group int4 10  √  null
organism_descrip organism text 2147483647  √  null
organism_group_id family_member int8 19  √  null
organism_group_id unigene_build int4 10  √  null
groups.group_id unigene_build_organism_group_id_fkey
organism_id accession int8 19  √  null
organism.organism_id organism_id_fk
organism_id deprecated_map_cross int8 19 (0)::bigint
organism.organism_id organism_id_fk
organism_id library int4 10  √  null
organism_id organism serial 10  √  nextval('organism_organism_id_seq'::regclass)
accession.organism_id organism_id_fk
deprecated_map_cross.organism_id organism_id_fk
organism_name organism varchar 80  √  null
organismprop_id organismprop serial 10  √  nextval('organismprop_organismprop_id_seq'::regclass)
organization submit_user varchar 80  √  null
p_mrkr_name p_markers varchar 32  √  null
parent_1 map int4 10  √  null
accession.accession_id map_parent_1_fkey
parent_1 marker_to_map int4 10  √  null
parent_2 map int4 10  √  null
accession.accession_id map_parent_2_fkey
parent_2 marker_to_map int4 10  √  null
password submit_user varchar 20  √  null
pcr_exp_accession_id pcr_exp_accession bigserial 19  √  nextval('pcr_exp_accession_pcr_exp_accession_id_seq'::regclass)
pcr_product.pcr_exp_accession_id pcr_exp_accession_id_fk
pcr_exp_accession_id pcr_product int8 19  √  null
pcr_exp_accession.pcr_exp_accession_id pcr_exp_accession_id_fk
pcr_experiment_id marker_experiment int4 10  √  null
pcr_experiment.pcr_experiment_id marker_experiment_pcr_experiment_id_fkey
pcr_experiment_id pcr_exp_accession int8 19  √  null
pcr_experiment.pcr_experiment_id pcr_experiment_id_fk
pcr_experiment_id pcr_experiment bigserial 19  √  nextval('pcr_experiment_pcr_experiment_id_seq'::regclass)
marker_experiment.pcr_experiment_id marker_experiment_pcr_experiment_id_fkey
pcr_exp_accession.pcr_experiment_id pcr_experiment_id_fk
pcr_product_id pcr_product bigserial 19  √  nextval('pcr_product_pcr_product_id_seq'::regclass)
pcr_product_ln ssr int8 19  √  null
peptide_sequence_id cosii_ortholog int8 19  √  null
percent_from_centromere fish_result float4 8,8
percent_from_centromere fish_result_composite float4 8,8 (0)::real
phone_number submit_user varchar 20  √  null
pid blast_annotations int4 10  √  null
pid p_markers serial 10  √  nextval('p_markers_pid_seq'::regclass)
polypl_gnmc organism varchar 50  √  null
population_id il_info int8 19  √  null
population_size deprecated_maps int8 19  √  null
population_type deprecated_maps varchar 250  √  null
position marker_location numeric 8,5
position marker_to_map numeric 8,5  √  null
predicted pcr_experiment bool 1  √  false
predicted pcr_product bool 1  √  false
preferred cds bool 1  √  null
preferred marker_alias bool 1  √  true
previous_metadata_id metadata int4 10  √  null
primer seqread varchar 50  √  null
primer_direction primer_unigene_match int2 5  √  null
primer_direction ssr_primer_unigene_matches int2 5 (0)::smallint
primer_id_fwd pcr_experiment int8 19  √  null
sequence.sequence_id primer_id_fwd_fk
primer_id_pd pcr_experiment int8 19  √  null
primer_id_rev pcr_experiment int8 19  √  null
sequence.sequence_id primer_id_rev_fk
primer_match_end primer_unigene_match int4 10  √  null
primer_match_end ssr_primer_unigene_matches int8 19 (0)::bigint
primer_match_start primer_unigene_match int4 10  √  null
primer_match_start ssr_primer_unigene_matches int8 19 (0)::bigint
primer_type pcr_experiment varchar 4  √  null
primer_unigene_match_id primer_unigene_match serial 10  √  nextval('primer_unigene_match_primer_unigene_match_id_seq'::regclass)
protein_feature_id cds int8 19  √  null
protein_seq cds text 2147483647  √  null
protocol marker_experiment text 2147483647
protocol marker_to_map text 2147483647  √  null
qc_id qc_report serial 10  √  nextval('qc_report_qc_id_seq'::regclass)
qc_status qc_report int8 19  √  null
qend qc_report int8 19  √  null
qend unigene_member int8 19  √  null
qscore est text 2147483647  √  null
qscores unigene_consensi text 2147483647  √  null
qstart qc_report int8 19  √  null
qstart unigene_member int8 19  √  null
quality_trim_threshold qc_report float4 8,8  √  null
query_end rflp_unigene_associations int8 19  √  null
query_start rflp_unigene_associations int8 19  √  null
rank organismprop int4 10 0
read_id est int4 10  √  null
seqread.read_id read_id_fkey
read_id seqread serial 10  √  nextval('seqread_read_id_seq'::regclass)
est.read_id read_id_fkey
read_id tigrtc_membership int4 10  √  null
reapeat_nr ssr_repeats int8 19  √  null
reason manual_censor_reasons text 2147483647  √  null
release microarray int8 19  √  null
repeat_id ssr_repeats serial 10  √  nextval('ssr_repeats_repeat_id_seq'::regclass)
repeat_motif ssr_repeats varchar 32 ''::character varying
restriction_site enzyme_restriction_sites text 2147483647  √  null
reverse_adapter library varchar 2147483647  √  null
reverse_seq_id rflp_markers int8 19  √  null
rflp_sequences.seq_id reverse_seq_id_fk
rflp_experiment_id marker_experiment int4 10  √  null
rflp_markers.rflp_id marker_experiment_rflp_experiment_id_fkey
rflp_id rflp_markers serial 10  √  nextval('rflp_markers_rflp_id_seq'::regclass)
marker_experiment.rflp_experiment_id marker_experiment_rflp_experiment_id_fkey
rflp_name rflp_markers varchar 64 ''::character varying
rflp_seq_id rflp_unigene_associations int8 19  √  null
rflp_sequences.seq_id rflp_seq_id_fk
rflp_unigene_assoc_id rflp_unigene_associations serial 10  √  nextval('rflp_unigene_associations_rflp_unigene_assoc_id_seq'::regclass)
rs1 library varchar 12  √  null
rs2 library varchar 12  √  null
run_id cds int8 19  √  null
run_id domain_match int8 19  √  null
score blast_hits float8 17,17  √  null
score cds int4 10  √  null
seed_available deprecated_maps int8 19  √  null
seed_url deprecated_maps varchar 250  √  null
seq cloning_vector text 2147483647  √  null
seq est text 2147483647  √  null
seq unigene_consensi text 2147483647  √  null
seq_edits cds text 2147483647  √  null
seq_id rflp_sequences serial 10  √  nextval('rflp_sequences_seq_id_seq'::regclass)
rflp_markers.forward_seq_id forward_seq_id_fk
rflp_markers.reverse_seq_id reverse_seq_id_fk
rflp_unigene_associations.rflp_seq_id rflp_seq_id_fk
seq_id tm_markers int8 19  √  null
seq_text cds text 2147483647  √  null
sequence sequence text 2147483647  √  null
sequence tm_markers_sequences text 2147483647  √  null
sequence_id sequence bigserial 19  √  nextval('sequence_sequence_id_seq'::regclass)
pcr_experiment.primer_id_fwd primer_id_fwd_fk
pcr_experiment.primer_id_rev primer_id_rev_fk
sequence_name cosii_ortholog varchar 255  √  null
sequence_name family_member varchar 50  √  null
sequence_name unigene int8 19
sequencing_primers facility varchar 80  √  null
short_arm_eu_length fish_karyotype_constants_old float4 8,8  √  null
short_arm_het_length fish_karyotype_constants_old float4 8,8  √  null
short_arm_length fish_karyotype_constants_old float4 8,8  √  null
short_name deprecated_maps varchar 50 ''::character varying
short_name map text 2147483647
sn_alias il_info text 2147483647  √  null
sn_marker_id il_info int4 10  √  null
sn_position il_info numeric 8,5  √  null
source_col derived_from_source text 2147483647  √  null
source_data_group_id unigene_build int4 10  √  null
source_name derived_from_source text 2147483647  √  null
source_schema derived_from_source text 2147483647  √  null
source_table derived_from_source text 2147483647  √  null
source_url blast_db varchar 255  √  null
south_location_id linkage_group int4 10  √  null
marker_location.location_id linkage_group_south_location_id_fkey
sp_person_id facility int4 10  √  null
sp_person_id library int4 10  √  null
sp_person_id submit_user int4 10  √  null
specie_tax organism varchar 80  √  null
spot_id microarray varchar 20  √  null
ssr_id ssr serial 10  √  nextval('ssr_ssr_id_seq'::regclass)
ssr_primer_unigene_matches.ssr_id ssr_id_fk
ssr_repeats.ssr_id ssr_id_fk
ssr_id ssr_primer_unigene_matches int8 19 (0)::bigint
ssr.ssr_id ssr_id_fk
ssr_id ssr_repeats int8 19 (0)::bigint
ssr.ssr_id ssr_id_fk
ssr_name ssr varchar 10  √  null
ssr_primer_unigene_match_id ssr_primer_unigene_matches serial 10  √  nextval('ssr_primer_unigene_matches_ssr_primer_unigene_match_id_seq'::regclass)
start trim_feature int8 19  √  null
start unigene_member int8 19  √  null
start_primer ssr varchar 100  √  null
status est int4 10  √  null
status family_build bpchar 1  √  'C'::bpchar
status unigene_build bpchar 1  √  null
stop unigene_member int8 19  √  null
subfamily_tax organism int4 10  √  null
taxonomy.tax_id organism_subfamily_tax_fkey
submit_code submit_user varchar 6  √  null
submit_user_id facility int4 10  √  null
submit_user_id library int4 10  √  null
submit_user_id submit_user serial 10  √  nextval('submit_user_submit_user_id_seq'::regclass)
submitter_id seqread int4 10  √  null
subscript marker_location bpchar 1  √  null
subscript marker_to_map bpchar 1  √  null
subscript pcr_experiment varchar 255  √  null
superseding_build_id unigene_build int4 10  √  null
unigene_build.unigene_build_id unigene_build_superseding_build_id_fkey
table_name annotation_target_type varchar 250  √  null
target_db_id blast_defline varchar 255  √  null
target_db_id blast_hits varchar 255  √  null
tax_id taxonomy serial 10  √  nextval('sgn.taxonomy_tax_id_seq'::regclass)
organism.family_tax organism_family_tax_fkey
organism.genus_tax organism_genus_tax_fkey
organism.order_tax organism_order_tax_fkey
organism.subfamily_tax organism_subfamily_tax_fkey
tax_name taxonomy varchar 50
tax_type taxonomy varchar 50  √  null
tc_id tigrtc_membership int4 10  √  null
tc_id tigrtc_tracking int4 10  √  null
tcc_id temp_caps_correspondence serial 10  √  nextval('temp_caps_correspondence_tcc_id_seq'::regclass)
tcindex_id tigrtc_index serial 10  √  nextval('tigrtc_index_tcindex_id_seq'::regclass)
tcindex_id tigrtc_membership int4 10  √  null
tcindex_id tigrtc_tracking int4 10  √  null
tigrtc_membership_id tigrtc_membership serial 10  √  nextval('tigrtc_membership_tigrtc_membership_id_seq'::regclass)
tigrtc_tracking_id tigrtc_tracking serial 10  √  nextval('tigrtc_tracking_tigrtc_tracking_id_seq'::regclass)
tissue library varchar 255  √  null
title blast_db varchar 80
tm_end_primer ssr varchar 10  √  null
tm_id tm_markers serial 10  √  nextval('tm_markers_tm_id_seq'::regclass)
tm_markers.tm_id tm_id_fk
tm_markers.tm_id tm_id_fk
tm_id tm_markers_sequences int8 19  √  null
tm_marker_seq_id tm_markers_sequences int8 19 (0)::bigint
tm_name tm_markers varchar 32 ''::character varying
tm_start_primer ssr varchar 10  √  null
tmc_id temp_map_correspondence serial 10  √  nextval('temp_map_correspondence_tmc_id_seq'::regclass)
temp_marker_correspondence.tmc_id Implied Constraint
tmc_id temp_marker_correspondence serial 10  √  nextval('temp_marker_correspondence_tmc_id_seq'::regclass)
temp_map_correspondence.tmc_id Implied Constraint
tomato_copy_number cos_markers varchar 11  √  null
trace_location seqread text 2147483647  √  null
trace_name seqread varchar 50
treatment_conditions library text 2147483647  √  null
tree_file_location family varchar 2147483647  √  null
tree_log_file_location family varchar 2147483647  √  null
tree_nr family_tree int4 10  √  null
tree_overlap_length family int4 10  √  null
tree_taxa_number family int4 10  √  null
trim_type_id trim_feature_types serial 10  √  nextval('trim_feature_types_trim_type_id_seq'::regclass)
type blast_db varchar 80  √  null
type groups int4 10  √  null
type library int8 19  √  null
types.type_id type_fkey
type trim_feature int8 19  √  null
type_code loc_types varchar 10 ''::character varying
type_description annotation_target_type varchar 250  √  null
type_id organismprop int4 10
type_id types serial 10  √  nextval('types_type_id_seq'::regclass)
library.type type_fkey
type_name annotation_target_type varchar 25  √  null
type_name deprecated_marker_types varchar 32  √  null
type_name loc_types varchar 12 ''::character varying
um_from_arm_border fish_result_composite float4 8,8  √  null
um_from_arm_end fish_result_composite float4 8,8  √  null
um_from_centromere fish_result_composite float4 8,8  √  null
unigene_build_id unigene int4 10  √  null
unigene_build.unigene_build_id unigene_unigene_build_id_fkey
unigene_build_id unigene_build serial 10  √  nextval('unigene_build_unigene_build_id_seq'::regclass)
unigene.unigene_build_id unigene_unigene_build_id_fkey
unigene_build.latest_build_id unigene_build_latest_build_id_fkey
unigene_build.next_build_id unigene_build_next_build_id_fkey
unigene_build.superseding_build_id unigene_build_superseding_build_id_fkey
unigene_id cds int8 19  √  null
unigene.unigene_id cds_unigene_id_fkey
unigene_id cosii_ortholog int4 10  √  null
unigene_id domain_match int8 19  √  null
unigene_id primer_unigene_match int4 10
unigene.unigene_id primer_unigene_match_unigene_id_fkey
unigene_id rflp_unigene_associations int8 19  √  null
unigene.unigene_id unigene_id_fk
unigene_id ssr_primer_unigene_matches int8 19 (0)::bigint
unigene.unigene_id unigene_id_fk
unigene_id unigene serial 10  √  nextval('unigene_unigene_id_seq'::regclass)
blast_annotations.apply_id apply_id_fkey
cds.unigene_id cds_unigene_id_fkey
primer_unigene_match.unigene_id primer_unigene_match_unigene_id_fkey
rflp_unigene_associations.unigene_id unigene_id_fk
ssr_primer_unigene_matches.unigene_id unigene_id_fk
unigene_member.unigene_id unigene_member_unigene_id_fkey
unigene_id unigene_member int4 10 0
unigene.unigene_id unigene_member_unigene_id_fkey
unigene_match_end primer_unigene_match int4 10  √  null
unigene_match_end ssr_primer_unigene_matches int8 19 (0)::bigint
unigene_match_start primer_unigene_match int4 10  √  null
unigene_match_start ssr_primer_unigene_matches int8 19 (0)::bigint
unigene_member_id unigene_member serial 10  √  nextval('unigene_member_unigene_member_id_seq'::regclass)
units map text 2147483647  √  'cM'::text
update_freq blast_db varchar 80 'monthly'::character varying
username submit_user varchar 20  √  null
value misc bytea 2147483647  √  null
value organismprop varchar 32
value trim_feature bytea 2147483647  √  null
vector library varchar 80  √  null
vector rflp_markers varchar 32  √  null
vector_tokens qc_report text 2147483647  √  null
version est int4 10  √  null
version microarray int8 19  √  null
vs_status qc_report int8 19  √  null
web_interface_visible blast_db bool 1  √  false whether this blast DB is available for BLASTing via web interfaces