cxgn_breedbase.phenome

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default
individual	Table	accession_id	int4	10	√		null
locus_alias	Table	alias	text	2147483647			null
allele_alias	Table	alias	text	2147483647			null
individual_alias	Table	alias	text	2147483647			null
allele_alias	Table	allele_alias_id	serial	10		√	nextval('phenome.allele_alias_allele_alias_id_seq'::regclass)
allele_dbxref	Table	allele_dbxref_id	serial	10		√	nextval('phenome.allele_dbxref_allele_dbxref_id_seq'::regclass)
allele_history	Table	allele_history_id	serial	10		√	nextval('phenome.allele_history_allele_history_id_seq'::regclass)
allele_alias	Table	allele_id	int4	10			null
allele	Table	allele_id	serial	10		√	nextval('phenome.allele_allele_id_seq'::regclass)
stock_allele	Table	allele_id	int4	10			null
individual_allele	Table	allele_id	int8	19			null
allele_dbxref	Table	allele_id	int4	10			null
allele_history	Table	allele_id	int4	10			null
allele_history	Table	allele_name	varchar	32	√		null
allele	Table	allele_name	varchar	255	√		null
allele	Table	allele_notes	text	2147483647	√		null
allele_history	Table	allele_phenotype	text	2147483647	√		null
allele	Table	allele_phenotype	text	2147483647	√		null
allele_history	Table	allele_symbol	varchar	32	√		null
allele	Table	allele_symbol	varchar	32	√		null
allele	Table	allele_synonym	_varchar	255	√		null
pub_curator	Table	assigned_to	int4	10	√		null
population	Table	background_accession_id	int8	19	√		null
phenome_genotype	Table	background_accession_id	int8	19	√		null
genotype_experiment	Table	background_accession_id	int8	19	√		null
tomato_il_bin	Table	chromosome	int4	10			null
population	Table	comment	text	2147483647	√		null
population	Table	common_name_id	int4	10	√		null
individual	Table	common_name_id	int8	19	√		null
locus	Table	common_name_id	int4	10			null
tomato_term2term	Table	complete	int8	19			(0)::bigint
individual_dbxref	Table	create_date	timestamptz	35	√		now()
individual_history	Table	create_date	timestamptz	35	√		now()
locus_dbxref	Table	create_date	timestamptz	35	√		now()
genotype_region	Table	create_date	timestamptz	35			now()
registry	Table	create_date	timestamptz	35	√		now()
individual_dbxref_evidence_history	Table	create_date	timestamptz	35	√		now()
locus_image	Table	create_date	timestamptz	35	√		now()
locus_registry	Table	create_date	timestamptz	35	√		now()
individual_dbxref_evidence	Table	create_date	timestamptz	35	√		now()
polymorphic_fragment	Table	create_date	timestamptz	35	√		null
allele_alias	Table	create_date	timestamptz	35	√		now()
allele	Table	create_date	timestamptz	35	√		now()
locus_owner	Table	create_date	timestamptz	35	√		now()
locus_dbxref_evidence	Table	create_date	timestamptz	35	√		now()
locus_dbxref_evidence_history	Table	create_date	timestamptz	35	√		now()
project_owner	Table	create_date	timestamp	29	√		now()
locusgroup	Table	create_date	timestamptz	35	√		now()
individual	Table	create_date	timestamptz	35	√		now()
phenome_genotype	Table	create_date	timestamptz	35	√		null

Showing 1 to 50 of 450 entries