cxgn_breedbase.public

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
organism	Table	abbreviation	varchar	255	√		null
pubabstract	Table	abstract	text	2147483647	√		null
pubabstract	Table	abstract_tsvector	tsvector	2147483647	√		null
dbxref	Table	accession	varchar	255			null	The local part of the identifier. Guaranteed by the db authority to be unique for that db
materialized_stockprop	View	accession number	jsonb	2147483647	√		null
materialized_phenoview	View	accession_id	int4	10	√		null
materialized_genoview	View	accession_id	int4	10	√		null
accessionsxseedlots	View	accession_id	int4	10	√		null
accessionsxtrials	View	accession_id	int4	10	√		null
forward_amplicon_sequence_information	Table	accession_id	text	2147483647	√		null
accessionsxtrial_types	View	accession_id	int4	10	√		null
accessionsxplants	View	accession_id	int4	10	√		null
accessionsxyears	View	accession_id	int4	10	√		null
accessionsxtrait_components	View	accession_id	int4	10	√		null
accessionsxgenotyping_protocols	View	accession_id	int4	10	√		null
accessionsxlocations	View	accession_id	int4	10	√		null
accessionsxplots	View	accession_id	int4	10	√		null
accessionsxbreeding_programs	View	accession_id	int4	10	√		null
accessionsxtraits	View	accession_id	int4	10	√		null
accessionsxgenotyping_projects	View	accession_id	int4	10	√		null
accessionsxtrial_designs	View	accession_id	int4	10	√		null
accessions	View	accession_id	int4	10	√		null
accessions	View	accession_name	text	2147483647	√		null
materialized_stockprop	View	acquisition date	jsonb	2147483647	√		null
bug	Table	action	text	2147483647	√		null
bug	Table	affected_page	text	2147483647	√		null
ara_domain	Table	agi	varchar	16	√		null
ara_signalp	Table	agi	varchar	16			null
ara_intron	Table	agi	varchar	16	√		null
ara_properties	Table	agi	varchar	16			null
ara_targetp	Table	agi	varchar	16			null
ara_annotation	Table	agi	varchar	16			null
ara_scop	Table	agi	varchar	16	√		null
ara_sequence	Table	agi	varchar	16			null
ara_gfp_ms	Table	agi	varchar	16	√		null
analysis	Table	algorithm	varchar	255	√		null
ara_annotation	Table	aliases	text	2147483647	√		null
family_member	View	alignment_seq	text	2147483647	√		null
materialized_markerview	View	alt	text	2147483647	√		null
ara_go_term	Table	alt_id	varchar	12	√		null
nd_geolocation	Table	altitude	float4	8	√		null	The altitude (elevation) of the location in meters. If the altitude is only known as a range, this is the average, and altitude_dev will hold half of the width of the range.
analysisprop	Table	analysis_id	int4	10			null
phylotree	Table	analysis_id	int4	10	√		null
analysisfeature	Table	analysis_id	int4	10			null
analysis	Table	analysis_id	serial	10		√	nextval('analysis_analysis_id_seq'::regclass)
analysisfeature	Table	analysisfeature_id	serial	10		√	nextval('analysisfeature_analysisfeature_id_seq'::regclass)
analysisprop	Table	analysisprop_id	serial	10		√	nextval('analysisprop_analysisprop_id_seq'::regclass)
ara_domain	Table	app_name	varchar	32	√		null
phenotype	Table	assay_id	int4	10	√		null
phenotype	Table	attr_id	int4	10	√		null

Showing 1 to 50 of 1,270 entries