gmbuilder.public contains 841 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
commenttype	absorption	int8	19	√		null
commenttype_diseasetype	acronym	varchar	2147483647	√		null
proteintype	allergenname	int8	19	√		null
proteintype_componenttype	allergenname	int8	19	√		null
proteintype_domaintype	allergenname	int8	19	√		null
goa	annotation_extension	varchar	2147483647	√		null
goa	aspect	varchar	2147483647
goa	assigned_by	varchar	2147483647
citationtype	authorlist	int8	19	√		null
locationtype	begin	int8	19	√		null
proteintype	biotechname	int8	19	√		null
proteintype_componenttype	biotechname	int8	19	√		null
proteintype_domaintype	biotechname	int8	19	√		null
evidencedstringtype	bpccommentgroupabsorptiontype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupabsorptiontype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_km_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_km_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_vmax_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_vmax_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupphdependencetype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupphdependencetype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupredoxpotentialtype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupredoxpotentialtype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgrouptemperaturedependencetype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgrouptemperaturedependencetype_text_hjindex	int4	10	√		null
sequencetype	checksum	varchar	2147483647	√		null
referencetype	citation	int8	19	√		null
dbreferencetype	citationtype_dbreference_hjid	int8	19	√		null
dbreferencetype	citationtype_dbreference_hjindex	int4	10	√		null
citationtype	city	varchar	2147483647	√		null
cofactortype_evidence	cofactortype_evidence_hjid	int8	19
cofactortype_evidence	cofactortype_evidence_hjindex	int4	10
cofactortype	commenttype_cofactor_hjid	int8	19	√		null
cofactortype	commenttype_cofactor_hjindex	int4	10	√		null
eventtype	commenttype_event_hjid	int8	19	√		null
eventtype	commenttype_event_hjindex	int4	10	√		null
commenttype_evidence	commenttype_evidence_hjid	int8	19
commenttype_evidence	commenttype_evidence_hjindex	int4	10
interactanttype	commenttype_interactant_hjid	int8	19	√		null
interactanttype	commenttype_interactant_hjindex	int4	10	√		null
isoformtype	commenttype_isoform_hjid	int8	19	√		null
isoformtype	commenttype_isoform_hjindex	int4	10	√		null
commenttype_linktype	commenttype_link_hjid	int8	19	√		null
commenttype_linktype	commenttype_link_hjindex	int4	10	√		null
locationtype	commenttype_location_hjid	int8	19	√		null
locationtype	commenttype_location_hjindex	int4	10	√		null
subcellularlocationtype	commenttype_subcellularlocation_hjid	int8	19	√		null
subcellularlocationtype	commenttype_subcellularlocation_hjindex	int4	10	√		null
evidencedstringtype	commenttype_text_hjid	int8	19	√		null
evidencedstringtype	commenttype_text_hjindex	int4	10	√		null
commenttype	conflict	int8	19	√		null
acc	content	varchar	2147483647	√		null
altid	content	varchar	2147483647	√		null
autogeneratedby	content	varchar	2147483647	√		null
comment	content	varchar	2147483647	√		null
consider	content	varchar	2147483647	√		null
createdby	content	varchar	2147483647	√		null
creationdate	content	varchar	2147483647	√		null
dataversion	content	varchar	2147483647	√		null
date	content	varchar	2147483647	√		null
dbname	content	varchar	2147483647	√		null
defaultnamespace	content	varchar	2147483647	√		null
defstr	content	varchar	2147483647	√		null
disjointfrom	content	varchar	2147483647	√		null
domain	content	varchar	2147483647	√		null
expandassertionto	content	varchar	2147483647	√		null
formatversion	content	varchar	2147483647	√		null
global	content	varchar	2147483647	√		null
id	content	varchar	2147483647	√		null
inverseof	content	varchar	2147483647	√		null
isa	content	varchar	2147483647	√		null
isanonymous	content	varchar	2147483647	√		null
isantisymmetric	content	varchar	2147483647	√		null
isclasslevel	content	varchar	2147483647	√		null
ismetadatatag	content	varchar	2147483647	√		null
isobsolete	content	varchar	2147483647	√		null
isreflexive	content	varchar	2147483647	√		null
isroot	content	varchar	2147483647	√		null
issymmetric	content	varchar	2147483647	√		null
istransitive	content	varchar	2147483647	√		null
lexicalcategory	content	varchar	2147483647	√		null
local	content	varchar	2147483647	√		null
name	content	varchar	2147483647	√		null
namespace	content	varchar	2147483647	√		null
ontology	content	varchar	2147483647	√		null
propertyvalue	content	varchar	2147483647	√		null
range	content	varchar	2147483647	√		null
relation	content	varchar	2147483647	√		null
remark	content	varchar	2147483647	√		null
replacedby	content	varchar	2147483647	√		null
savedby	content	varchar	2147483647	√		null
scope	content	varchar	2147483647	√		null
sourcefullpath	content	varchar	2147483647	√		null
sourceid	content	varchar	2147483647	√		null
sourcemd5	content	varchar	2147483647	√		null
sourcemtime	content	varchar	2147483647	√		null
sourceparsetime	content	varchar	2147483647	√		null
sourcepath	content	varchar	2147483647	√		null
sourcetype	content	varchar	2147483647	√		null
subset	content	varchar	2147483647	√		null
synonymtext	content	varchar	2147483647	√		null
to_	content	varchar	2147483647	√		null
transitiveover	content	varchar	2147483647	√		null
type	content	varchar	2147483647	√		null
unionof	content	varchar	2147483647	√		null
uniprottype	copyright	varchar	2147483647	√		null
citationtype	country	varchar	2147483647	√		null
entrytype	created	timestamp	29,6	√		null
entrytype	dataset	varchar	2147483647	√		null
goa	date	date	13
citationtype	date_hjclass	varchar	2147483647	√		null
citationtype	date_hjid	int8	19	√		null
citationtype	db	varchar	2147483647	√		null
goa	db	varchar	2147483647
goa	db_object_id	varchar	2147483647
goa	db_object_name	varchar	2147483647	√		null
goa	db_object_symbol	varchar	2147483647
goa	db_object_synonym	varchar	2147483647	√		null
goa	db_object_type	varchar	2147483647
goa	db_reference	varchar	2147483647
cofactortype	dbreference	int8	19	√		null
commenttype_diseasetype	dbreference	int8	19	√		null
importedfromtype	dbreference	int8	19	√		null
uniprotsourcetype	dbreference	int8	19	√		null
dbreferencetype_evidence	dbreferencetype_evidence_hjid	int8	19
dbreferencetype_evidence	dbreferencetype_evidence_hjindex	int4	10
propertytype	dbreferencetype_property_hjid	int8	19	√		null
propertytype	dbreferencetype_property_hjindex	int4	10	√		null
dbxref_content	dbxref_content_hjchildid	int8	19	√		null
dbxref_content	dbxref_content_hjclass	varchar	2147483647	√		null
dbxref_content	dbxref_content_hjid	int8	19
dbxref_content	dbxref_content_hjindex	int4	10
def_content	def_content_hjchildid	int8	19	√		null
def_content	def_content_hjclass	varchar	2147483647	√		null
def_content	def_content_hjid	int8	19
def_content	def_content_hjindex	int4	10
commenttype_diseasetype	description	varchar	2147483647	√		null
featuretype	description	varchar	2147483647	√		null
commenttype	disease	int8	19	√		null
citationtype	editorlist	int8	19	√		null
locationtype	endposition	int8	19	√		null
entrytype_accession	entrytype_accession_hjid	int8	19
entrytype_accession	entrytype_accession_hjindex	int4	10
entrytype_comment	entrytype_comment_hjchildid	int8	19	√		null
entrytype_comment	entrytype_comment_hjclass	varchar	2147483647	√		null
entrytype_comment	entrytype_comment_hjid	int8	19
entrytype_comment	entrytype_comment_hjindex	int4	10
dbreferencetype	entrytype_dbreference_hjid	int8	19	√		null
dbreferencetype	entrytype_dbreference_hjindex	int4	10	√		null
evidencetype	entrytype_evidence_hjid	int8	19	√		null
evidencetype	entrytype_evidence_hjindex	int4	10	√		null
featuretype	entrytype_feature_hjid	int8	19	√		null
featuretype	entrytype_feature_hjindex	int4	10	√		null
genetype	entrytype_gene_hjid	int8	19	√		null
genetype	entrytype_gene_hjindex	int4	10	√		null
genelocationtype	entrytype_genelocation_hjid	int8	19	√		null
genelocationtype	entrytype_genelocation_hjindex	int4	10	√		null
keywordtype	entrytype_keyword_hjid	int8	19	√		null
keywordtype	entrytype_keyword_hjindex	int4	10	√		null
entrytype_name	entrytype_name_hjid	int8	19
entrytype_name	entrytype_name_hjindex	int4	10
organismtype	entrytype_organismhost_hjid	int8	19	√		null
organismtype	entrytype_organismhost_hjindex	int4	10	√		null
referencetype	entrytype_reference_hjid	int8	19	√		null
referencetype	entrytype_reference_hjindex	int4	10	√		null
commenttype	error	varchar	2147483647	√		null
goa	evidence_code	varchar	2147483647
evidencedstringtype_evidence	evidencedstringtype_evidence_hjid	int8	19
evidencedstringtype_evidence	evidencedstringtype_evidence_hjindex	int4	10
commenttype	experiments	int4	10	√		null
featuretype_evidence	featuretype_evidence_hjid	int8	19
featuretype_evidence	featuretype_evidence_hjindex	int4	10
featuretype_variation	featuretype_variation_hjid	int8	19
featuretype_variation	featuretype_variation_hjindex	int4	10
citationtype	first	varchar	2147483647	√		null
sequencetype	fragment	varchar	2147483647	√		null
proteinnamegroupalternativenametype	fullname	int8	19	√		null
proteinnamegrouprecommendednametype	fullname	int8	19	√		null
proteinnamegroupsubmittednametype	fullname	int8	19	√		null
goa	gene_product_form_id	varchar	2147483647	√		null
genelocationtype_evidence	genelocationtype_evidence_hjid	int8	19
genelocationtype_evidence	genelocationtype_evidence_hjindex	int4	10
statustype	genelocationtype_name_hjid	int8	19	√		null
statustype	genelocationtype_name_hjindex	int4	10	√		null
genenametype_evidence	genenametype_evidence_hjid	int8	19
genenametype_evidence	genenametype_evidence_hjindex	int4	10
genenametype	genetype_name_hjid	int8	19	√		null
genenametype	genetype_name_hjindex	int4	10	√		null
goa	go_id	varchar	2147483647
header_content	header_content_hjchildid	int8	19	√		null
header_content	header_content_hjclass	varchar	2147483647	√		null
header_content	header_content_hjid	int8	19
header_content	header_content_hjindex	int4	10
acc	hjid	int8	19
altid	hjid	int8	19
autogeneratedby	hjid	int8	19
bpccommentgroupabsorptiontype	hjid	int8	19
bpccommentgroupkineticstype	hjid	int8	19
bpccommentgroupphdependencetype	hjid	int8	19
bpccommentgroupredoxpotentialtype	hjid	int8	19
bpccommentgrouptemperaturedependencetype	hjid	int8	19
citationtype	hjid	int8	19
cofactortype	hjid	int8	19
comment	hjid	int8	19
commenttype	hjid	int8	19
commenttype_conflicttype	hjid	int8	19
commenttype_conflicttype_sequencetype	hjid	int8	19
commenttype_diseasetype	hjid	int8	19
commenttype_linktype	hjid	int8	19
consider	hjid	int8	19
consortiumtype	hjid	int8	19
copyright	hjid	int8	19
createdby	hjid	int8	19
creationdate	hjid	int8	19
dataversion	hjid	int8	19
date	hjid	int8	19
dbname	hjid	int8	19
dbreferencetype	hjid	int8	19
dbxref	hjid	int8	19
def	hjid	int8	19
defaultnamespace	hjid	int8	19
defstr	hjid	int8	19
disjointfrom	hjid	int8	19
domain	hjid	int8	19
entrytype	hjid	int8	19
eventtype	hjid	int8	19
evidencedstringtype	hjid	int8	19
evidencetype	hjid	int8	19
expandassertionto	hjid	int8	19
featuretype	hjid	int8	19
formatversion	hjid	int8	19
genelocationtype	hjid	int8	19
genenametype	hjid	int8	19
genetype	hjid	int8	19
global	hjid	int8	19
header	hjid	int8	19
holdsoverchain	hjid	int8	19
id	hjid	int8	19
idspace	hjid	int8	19
importedfromtype	hjid	int8	19
interactanttype	hjid	int8	19
intersectionof	hjid	int8	19
inverseof	hjid	int8	19
isa	hjid	int8	19
isanonymous	hjid	int8	19
isantisymmetric	hjid	int8	19
isclasslevel	hjid	int8	19
ismetadatatag	hjid	int8	19
isobsolete	hjid	int8	19
isoformtype	hjid	int8	19
isoformtype_nametype	hjid	int8	19
isoformtype_sequencetype	hjid	int8	19
isreflexive	hjid	int8	19
isroot	hjid	int8	19
issymmetric	hjid	int8	19
istransitive	hjid	int8	19
keywordtype	hjid	int8	19
lexicalcategory	hjid	int8	19
local	hjid	int8	19
locationtype	hjid	int8	19
moleculetype	hjid	int8	19
name	hjid	int8	19
namelisttype	hjid	int8	19
namespace	hjid	int8	19
obo	hjid	int8	19
ontology	hjid	int8	19
organismnametype	hjid	int8	19
organismtype	hjid	int8	19
organismtype_lineagetype	hjid	int8	19
persontype	hjid	int8	19
positiontype	hjid	int8	19
propertytype	hjid	int8	19
propertyvalue	hjid	int8	19
proteinexistencetype	hjid	int8	19
proteinnamegroupalternativenametype	hjid	int8	19
proteinnamegrouprecommendednametype	hjid	int8	19
proteinnamegroupsubmittednametype	hjid	int8	19
proteintype	hjid	int8	19
proteintype_componenttype	hjid	int8	19
proteintype_domaintype	hjid	int8	19
range	hjid	int8	19
referencetype	hjid	int8	19
relation	hjid	int8	19
relationship	hjid	int8	19
remark	hjid	int8	19
replacedby	hjid	int8	19
savedby	hjid	int8	19
scope	hjid	int8	19
sequencetype	hjid	int8	19
source	hjid	int8	19
sourcedatatype	hjid	int8	19
sourcedatatype_plasmidtype	hjid	int8	19
sourcedatatype_straintype	hjid	int8	19
sourcedatatype_tissuetype	hjid	int8	19
sourcedatatype_transposontype	hjid	int8	19
sourcefullpath	hjid	int8	19
sourceid	hjid	int8	19
sourcemd5	hjid	int8	19
sourcemtime	hjid	int8	19
sourceparsetime	hjid	int8	19
sourcepath	hjid	int8	19
sourcetype	hjid	int8	19
statustype	hjid	int8	19
subcellularlocationtype	hjid	int8	19
subset	hjid	int8	19
subsetdef	hjid	int8	19
synonym	hjid	int8	19
synonymcategory	hjid	int8	19
synonymtext	hjid	int8	19
synonymtypedef	hjid	int8	19
term	hjid	int8	19
to_	hjid	int8	19
transitiveover	hjid	int8	19
type	hjid	int8	19
typedef	hjid	int8	19
unionof	hjid	int8	19
uniprotsourcetype	hjid	int8	19
uniprottype	hjid	int8	19
xrefanalog	hjid	int8	19
xrefunknown	hjid	int8	19
acc	hjtype	varchar	2147483647
altid	hjtype	varchar	2147483647
autogeneratedby	hjtype	varchar	2147483647
bpccommentgroupabsorptiontype	hjtype	varchar	2147483647
bpccommentgroupkineticstype	hjtype	varchar	2147483647
bpccommentgroupphdependencetype	hjtype	varchar	2147483647
bpccommentgroupredoxpotentialtype	hjtype	varchar	2147483647
bpccommentgrouptemperaturedependencetype	hjtype	varchar	2147483647
citationtype	hjtype	varchar	2147483647
cofactortype	hjtype	varchar	2147483647
comment	hjtype	varchar	2147483647
commenttype	hjtype	varchar	2147483647
commenttype_conflicttype	hjtype	varchar	2147483647
commenttype_conflicttype_sequencetype	hjtype	varchar	2147483647
commenttype_diseasetype	hjtype	varchar	2147483647
commenttype_linktype	hjtype	varchar	2147483647
consider	hjtype	varchar	2147483647
consortiumtype	hjtype	varchar	2147483647
copyright	hjtype	varchar	2147483647
createdby	hjtype	varchar	2147483647
creationdate	hjtype	varchar	2147483647
dataversion	hjtype	varchar	2147483647
date	hjtype	varchar	2147483647
dbname	hjtype	varchar	2147483647
dbreferencetype	hjtype	varchar	2147483647
dbxref	hjtype	varchar	2147483647
def	hjtype	varchar	2147483647
defaultnamespace	hjtype	varchar	2147483647
defstr	hjtype	varchar	2147483647
disjointfrom	hjtype	varchar	2147483647
domain	hjtype	varchar	2147483647
entrytype	hjtype	varchar	2147483647
eventtype	hjtype	varchar	2147483647
evidencedstringtype	hjtype	varchar	2147483647
evidencetype	hjtype	varchar	2147483647
expandassertionto	hjtype	varchar	2147483647
featuretype	hjtype	varchar	2147483647
formatversion	hjtype	varchar	2147483647
genelocationtype	hjtype	varchar	2147483647
genenametype	hjtype	varchar	2147483647
genetype	hjtype	varchar	2147483647
global	hjtype	varchar	2147483647
header	hjtype	varchar	2147483647
holdsoverchain	hjtype	varchar	2147483647
id	hjtype	varchar	2147483647
idspace	hjtype	varchar	2147483647
importedfromtype	hjtype	varchar	2147483647
interactanttype	hjtype	varchar	2147483647
intersectionof	hjtype	varchar	2147483647
inverseof	hjtype	varchar	2147483647
isa	hjtype	varchar	2147483647
isanonymous	hjtype	varchar	2147483647
isantisymmetric	hjtype	varchar	2147483647
isclasslevel	hjtype	varchar	2147483647
ismetadatatag	hjtype	varchar	2147483647
isobsolete	hjtype	varchar	2147483647
isoformtype	hjtype	varchar	2147483647
isoformtype_nametype	hjtype	varchar	2147483647
isoformtype_sequencetype	hjtype	varchar	2147483647
isreflexive	hjtype	varchar	2147483647
isroot	hjtype	varchar	2147483647
issymmetric	hjtype	varchar	2147483647
istransitive	hjtype	varchar	2147483647
keywordtype	hjtype	varchar	2147483647
lexicalcategory	hjtype	varchar	2147483647
local	hjtype	varchar	2147483647
locationtype	hjtype	varchar	2147483647
moleculetype	hjtype	varchar	2147483647
name	hjtype	varchar	2147483647
namelisttype	hjtype	varchar	2147483647
namespace	hjtype	varchar	2147483647
obo	hjtype	varchar	2147483647
ontology	hjtype	varchar	2147483647
organismnametype	hjtype	varchar	2147483647
organismtype	hjtype	varchar	2147483647
organismtype_lineagetype	hjtype	varchar	2147483647
persontype	hjtype	varchar	2147483647
positiontype	hjtype	varchar	2147483647
propertytype	hjtype	varchar	2147483647
propertyvalue	hjtype	varchar	2147483647
proteinexistencetype	hjtype	varchar	2147483647
proteinnamegroupalternativenametype	hjtype	varchar	2147483647
proteinnamegrouprecommendednametype	hjtype	varchar	2147483647
proteinnamegroupsubmittednametype	hjtype	varchar	2147483647
proteintype	hjtype	varchar	2147483647
proteintype_componenttype	hjtype	varchar	2147483647
proteintype_domaintype	hjtype	varchar	2147483647
range	hjtype	varchar	2147483647
referencetype	hjtype	varchar	2147483647
relation	hjtype	varchar	2147483647
relationship	hjtype	varchar	2147483647
remark	hjtype	varchar	2147483647
replacedby	hjtype	varchar	2147483647
savedby	hjtype	varchar	2147483647
scope	hjtype	varchar	2147483647
sequencetype	hjtype	varchar	2147483647
source	hjtype	varchar	2147483647
sourcedatatype	hjtype	varchar	2147483647
sourcedatatype_plasmidtype	hjtype	varchar	2147483647
sourcedatatype_straintype	hjtype	varchar	2147483647
sourcedatatype_tissuetype	hjtype	varchar	2147483647
sourcedatatype_transposontype	hjtype	varchar	2147483647
sourcefullpath	hjtype	varchar	2147483647
sourceid	hjtype	varchar	2147483647
sourcemd5	hjtype	varchar	2147483647
sourcemtime	hjtype	varchar	2147483647
sourceparsetime	hjtype	varchar	2147483647
sourcepath	hjtype	varchar	2147483647
sourcetype	hjtype	varchar	2147483647
statustype	hjtype	varchar	2147483647
subcellularlocationtype	hjtype	varchar	2147483647
subset	hjtype	varchar	2147483647
subsetdef	hjtype	varchar	2147483647
synonym	hjtype	varchar	2147483647
synonymcategory	hjtype	varchar	2147483647
synonymtext	hjtype	varchar	2147483647
synonymtypedef	hjtype	varchar	2147483647
term	hjtype	varchar	2147483647
to_	hjtype	varchar	2147483647
transitiveover	hjtype	varchar	2147483647
type	hjtype	varchar	2147483647
typedef	hjtype	varchar	2147483647
unionof	hjtype	varchar	2147483647
uniprotsourcetype	hjtype	varchar	2147483647
uniprottype	hjtype	varchar	2147483647
xrefanalog	hjtype	varchar	2147483647
xrefunknown	hjtype	varchar	2147483647
cofactortype_evidence	hjvalue	int4	10	√		null
commenttype_evidence	hjvalue	int4	10	√		null
dbreferencetype_evidence	hjvalue	int4	10	√		null
entrytype_accession	hjvalue	varchar	2147483647	√		null
entrytype_name	hjvalue	varchar	2147483647	√		null
evidencedstringtype_evidence	hjvalue	int4	10	√		null
featuretype_evidence	hjvalue	int4	10	√		null
featuretype_variation	hjvalue	varchar	2147483647	√		null
genelocationtype_evidence	hjvalue	int4	10	√		null
genenametype_evidence	hjvalue	int4	10	√		null
isoformtype_id	hjvalue	varchar	2147483647	√		null
isoformtype_nametype_evidence	hjvalue	int4	10	√		null
keywordtype_evidence	hjvalue	int4	10	√		null
organismtype_evidence	hjvalue	int4	10	√		null
organismtype_lineagetype_taxon	hjvalue	varchar	2147483647	√		null
positiontype_evidence	hjvalue	int4	10	√		null
referencetype_evidence	hjvalue	int4	10	√		null
referencetype_scope	hjvalue	varchar	2147483647	√		null
sourcedatatype_plasmidtype_evidence	hjvalue	int4	10	√		null
sourcedatatype_straintype_evidence	hjvalue	int4	10	√		null
sourcedatatype_tissuetype_evidence	hjvalue	int4	10	√		null
sourcedatatype_transposontype_evidence	hjvalue	int4	10	√		null
acc	hjversion	int8	19
altid	hjversion	int8	19
autogeneratedby	hjversion	int8	19
bpccommentgroupabsorptiontype	hjversion	int8	19
bpccommentgroupkineticstype	hjversion	int8	19
bpccommentgroupphdependencetype	hjversion	int8	19
bpccommentgroupredoxpotentialtype	hjversion	int8	19
bpccommentgrouptemperaturedependencetype	hjversion	int8	19
citationtype	hjversion	int8	19
cofactortype	hjversion	int8	19
comment	hjversion	int8	19
commenttype	hjversion	int8	19
commenttype_conflicttype	hjversion	int8	19
commenttype_conflicttype_sequencetype	hjversion	int8	19
commenttype_diseasetype	hjversion	int8	19
commenttype_linktype	hjversion	int8	19
consider	hjversion	int8	19
consortiumtype	hjversion	int8	19
copyright	hjversion	int8	19
createdby	hjversion	int8	19
creationdate	hjversion	int8	19
dataversion	hjversion	int8	19
date	hjversion	int8	19
dbname	hjversion	int8	19
dbreferencetype	hjversion	int8	19
dbxref	hjversion	int8	19
def	hjversion	int8	19
defaultnamespace	hjversion	int8	19
defstr	hjversion	int8	19
disjointfrom	hjversion	int8	19
domain	hjversion	int8	19
entrytype	hjversion	int8	19
eventtype	hjversion	int8	19
evidencedstringtype	hjversion	int8	19
evidencetype	hjversion	int8	19
expandassertionto	hjversion	int8	19
featuretype	hjversion	int8	19
formatversion	hjversion	int8	19
genelocationtype	hjversion	int8	19
genenametype	hjversion	int8	19
genetype	hjversion	int8	19
global	hjversion	int8	19
header	hjversion	int8	19
holdsoverchain	hjversion	int8	19
id	hjversion	int8	19
idspace	hjversion	int8	19
importedfromtype	hjversion	int8	19
interactanttype	hjversion	int8	19
intersectionof	hjversion	int8	19
inverseof	hjversion	int8	19
isa	hjversion	int8	19
isanonymous	hjversion	int8	19
isantisymmetric	hjversion	int8	19
isclasslevel	hjversion	int8	19
ismetadatatag	hjversion	int8	19
isobsolete	hjversion	int8	19
isoformtype	hjversion	int8	19
isoformtype_nametype	hjversion	int8	19
isoformtype_sequencetype	hjversion	int8	19
isreflexive	hjversion	int8	19
isroot	hjversion	int8	19
issymmetric	hjversion	int8	19
istransitive	hjversion	int8	19
keywordtype	hjversion	int8	19
lexicalcategory	hjversion	int8	19
local	hjversion	int8	19
locationtype	hjversion	int8	19
moleculetype	hjversion	int8	19
name	hjversion	int8	19
namelisttype	hjversion	int8	19
namespace	hjversion	int8	19
obo	hjversion	int8	19
ontology	hjversion	int8	19
organismnametype	hjversion	int8	19
organismtype	hjversion	int8	19
organismtype_lineagetype	hjversion	int8	19
persontype	hjversion	int8	19
positiontype	hjversion	int8	19
propertytype	hjversion	int8	19
propertyvalue	hjversion	int8	19
proteinexistencetype	hjversion	int8	19
proteinnamegroupalternativenametype	hjversion	int8	19
proteinnamegrouprecommendednametype	hjversion	int8	19
proteinnamegroupsubmittednametype	hjversion	int8	19
proteintype	hjversion	int8	19
proteintype_componenttype	hjversion	int8	19
proteintype_domaintype	hjversion	int8	19
range	hjversion	int8	19
referencetype	hjversion	int8	19
relation	hjversion	int8	19
relationship	hjversion	int8	19
remark	hjversion	int8	19
replacedby	hjversion	int8	19
savedby	hjversion	int8	19
scope	hjversion	int8	19
sequencetype	hjversion	int8	19
source	hjversion	int8	19
sourcedatatype	hjversion	int8	19
sourcedatatype_plasmidtype	hjversion	int8	19
sourcedatatype_straintype	hjversion	int8	19
sourcedatatype_tissuetype	hjversion	int8	19
sourcedatatype_transposontype	hjversion	int8	19
sourcefullpath	hjversion	int8	19
sourceid	hjversion	int8	19
sourcemd5	hjversion	int8	19
sourcemtime	hjversion	int8	19
sourceparsetime	hjversion	int8	19
sourcepath	hjversion	int8	19
sourcetype	hjversion	int8	19
statustype	hjversion	int8	19
subcellularlocationtype	hjversion	int8	19
subset	hjversion	int8	19
subsetdef	hjversion	int8	19
synonym	hjversion	int8	19
synonymcategory	hjversion	int8	19
synonymtext	hjversion	int8	19
synonymtypedef	hjversion	int8	19
term	hjversion	int8	19
to_	hjversion	int8	19
transitiveover	hjversion	int8	19
type	hjversion	int8	19
typedef	hjversion	int8	19
unionof	hjversion	int8	19
uniprotsourcetype	hjversion	int8	19
uniprottype	hjversion	int8	19
xrefanalog	hjversion	int8	19
xrefunknown	hjversion	int8	19
relation	holdsoverchain_relation_hjid	int8	19	√		null
relation	holdsoverchain_relation_hjindex	int4	10	√		null
commenttype_conflicttype_sequencetype	id	varchar	2147483647	√		null
commenttype_diseasetype	id	varchar	2147483647	√		null
dbreferencetype	id	varchar	2147483647	√		null
featuretype	id	varchar	2147483647	√		null
interactanttype	id	varchar	2147483647	√		null
keywordtype	id	varchar	2147483647	√		null
moleculetype	id	varchar	2147483647	√		null
idspace_content	idspace_content_hjchildid	int8	19	√		null
idspace_content	idspace_content_hjclass	varchar	2147483647	√		null
idspace_content	idspace_content_hjid	int8	19
idspace_content	idspace_content_hjindex	int4	10
evidencetype	importedfrom	int8	19	√		null
citationtype	institute	varchar	2147483647	√		null
interactanttype	intactid	varchar	2147483647	√		null
intersectionof_content	intersectionof_content_hjchildid	int8	19	√		null
intersectionof_content	intersectionof_content_hjclass	varchar	2147483647	√		null
intersectionof_content	intersectionof_content_hjid	int8	19
intersectionof_content	intersectionof_content_hjindex	int4	10
isoformtype_id	isoformtype_id_hjid	int8	19
isoformtype_id	isoformtype_id_hjindex	int4	10
isoformtype_nametype	isoformtype_name_hjid	int8	19	√		null
isoformtype_nametype	isoformtype_name_hjindex	int4	10	√		null
isoformtype_nametype_evidence	isoformtype_nametype_evidence_hjid	int8	19
isoformtype_nametype_evidence	isoformtype_nametype_evidence_hjindex	int4	10
evidencedstringtype	isoformtype_text_hjid	int8	19	√		null
evidencedstringtype	isoformtype_text_hjindex	int4	10	√		null
evidencetype	key	numeric	131089	√		null
referencetype	key	varchar	2147483647	√		null
keywordtype_evidence	keywordtype_evidence_hjid	int8	19
keywordtype_evidence	keywordtype_evidence_hjindex	int4	10
commenttype	kinetics	int8	19	√		null
interactanttype	label	varchar	2147483647	√		null
citationtype	last	varchar	2147483647	√		null
sequencetype	length	int4	10	√		null
organismtype	lineage	int8	19	√		null
featuretype	location	int8	19	√		null
commenttype	locationtype	varchar	2147483647	√		null
citationtype	locator	varchar	2147483647	√		null
commenttype	mass	float4	8,8	√		null
sequencetype	mass	int4	10	√		null
bpccommentgroupabsorptiontype	max	int8	19	√		null
commenttype	method	varchar	2147483647	√		null
entrytype	modified	timestamp	29,6	√		null
sequencetype	modified	timestamp	29,6	√		null
commenttype	molecule	int8	19	√		null
dbreferencetype	molecule	int8	19	√		null
citationtype	name	varchar	2147483647	√		null
cofactortype	name	varchar	2147483647	√		null
commenttype	name	varchar	2147483647	√		null
commenttype_diseasetype	name	varchar	2147483647	√		null
consortiumtype	name	varchar	2147483647	√		null
persontype	name	varchar	2147483647	√		null
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjchildid	int8	19	√		null
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjclass	varchar	2147483647	√		null
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjid	int8	19
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjindex	int4	10
citationtype	number	varchar	2147483647	√		null
obo_content	obo_content_hjchildid	int8	19	√		null
obo_content	obo_content_hjclass	varchar	2147483647	√		null
obo_content	obo_content_hjid	int8	19
obo_content	obo_content_hjindex	int4	10
entrytype	organism	int8	19	√		null
commenttype	organismsdiffer	bool	1	√		null
dbreferencetype	organismtype_dbreference_hjid	int8	19	√		null
dbreferencetype	organismtype_dbreference_hjindex	int4	10	√		null
organismtype_evidence	organismtype_evidence_hjid	int8	19
organismtype_evidence	organismtype_evidence_hjindex	int4	10
organismtype_lineagetype_taxon	organismtype_lineagetype_taxon_hjid	int8	19
organismtype_lineagetype_taxon	organismtype_lineagetype_taxon_hjindex	int4	10
organismnametype	organismtype_name_hjid	int8	19	√		null
organismnametype	organismtype_name_hjindex	int4	10	√		null
featuretype	original	varchar	2147483647	√		null
commenttype	phdependence	int8	19	√		null
locationtype	position	int8	19	√		null
positiontype	position	numeric	131089	√		null
positiontype_evidence	positiontype_evidence_hjid	int8	19
positiontype_evidence	positiontype_evidence_hjindex	int4	10
sequencetype	precursor	bool	1	√		null
goa	primdbkey	int8	19
entrytype	protein	int8	19	√		null
entrytype	proteinexistence	int8	19	√		null
evidencedstringtype	proteinnamegroupalternativenametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupalternativenametype_ecnumber_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegroupalternativenametype_shortname_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupalternativenametype_shortname_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_ecnumber_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_shortname_hjid	int8	19	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_shortname_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegroupsubmittednametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupsubmittednametype_ecnumber_hjindex	int4	10	√		null
proteinnamegroupalternativenametype	proteintype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_alternativename_hjindex	int4	10	√		null
evidencedstringtype	proteintype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_cdantigenname_hjindex	int4	10	√		null
proteintype_componenttype	proteintype_component_hjid	int8	19	√		null
proteintype_componenttype	proteintype_component_hjindex	int4	10	√		null
proteinnamegroupalternativenametype	proteintype_componenttype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_componenttype_alternativename_hjindex	int4	10	√		null
evidencedstringtype	proteintype_componenttype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_componenttype_cdantigenname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_componenttype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_componenttype_innname_hjindex	int4	10	√		null
proteinnamegroupsubmittednametype	proteintype_componenttype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_componenttype_submittedname_hjindex	int4	10	√		null
proteintype_domaintype	proteintype_domain_hjid	int8	19	√		null
proteintype_domaintype	proteintype_domain_hjindex	int4	10	√		null
proteinnamegroupalternativenametype	proteintype_domaintype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_domaintype_alternativename_hjindex	int4	10	√		null
evidencedstringtype	proteintype_domaintype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_domaintype_cdantigenname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_domaintype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_domaintype_innname_hjindex	int4	10	√		null
proteinnamegroupsubmittednametype	proteintype_domaintype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_domaintype_submittedname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_innname_hjindex	int4	10	√		null
proteinnamegroupsubmittednametype	proteintype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_submittedname_hjindex	int4	10	√		null
citationtype	publisher	varchar	2147483647	√		null
goa	qualifier	varchar	2147483647	√		null
proteintype	recommendedname	int8	19	√		null
proteintype_componenttype	recommendedname	int8	19	√		null
proteintype_domaintype	recommendedname	int8	19	√		null
commenttype	redoxpotential	int8	19	√		null
commenttype_conflicttype	ref	varchar	2147483647	√		null
featuretype	ref	varchar	2147483647	√		null
isoformtype_sequencetype	ref	varchar	2147483647	√		null
uniprotsourcetype	ref	numeric	131089	√		null
referencetype_evidence	referencetype_evidence_hjid	int8	19
referencetype_evidence	referencetype_evidence_hjindex	int4	10
referencetype_scope	referencetype_scope_hjid	int8	19
referencetype_scope	referencetype_scope_hjindex	int4	10
relationship_content	relationship_content_hjchildid	int8	19	√		null
relationship_content	relationship_content_hjclass	varchar	2147483647	√		null
relationship_content	relationship_content_hjid	int8	19
relationship_content	relationship_content_hjindex	int4	10
commenttype_conflicttype_sequencetype	resource	varchar	2147483647	√		null
synonym	scope	varchar	2147483647	√		null
commenttype_conflicttype	sequence	int8	19	√		null
entrytype	sequence	int8	19	√		null
isoformtype	sequence	int8	19	√		null
locationtype	sequence	varchar	2147483647	√		null
evidencetype	source	int8	19	√		null
referencetype	source	int8	19	√		null
source_content	source_content_hjchildid	int8	19	√		null
source_content	source_content_hjclass	varchar	2147483647	√		null
source_content	source_content_hjid	int8	19
source_content	source_content_hjindex	int4	10
sourcedatatype_plasmidtype_evidence	sourcedatatype_plasmidtype_evidence_hjid	int8	19
sourcedatatype_plasmidtype_evidence	sourcedatatype_plasmidtype_evidence_hjindex	int4	10
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjchildid	int8	19	√		null
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjclass	varchar	2147483647	√		null
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjid	int8	19
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjindex	int4	10
sourcedatatype_straintype_evidence	sourcedatatype_straintype_evidence_hjid	int8	19
sourcedatatype_straintype_evidence	sourcedatatype_straintype_evidence_hjindex	int4	10
sourcedatatype_tissuetype_evidence	sourcedatatype_tissuetype_evidence_hjid	int8	19
sourcedatatype_tissuetype_evidence	sourcedatatype_tissuetype_evidence_hjindex	int4	10
sourcedatatype_transposontype_evidence	sourcedatatype_transposontype_evidence_hjid	int8	19
sourcedatatype_transposontype_evidence	sourcedatatype_transposontype_evidence_hjindex	int4	10
evidencedstringtype	status	varchar	2147483647	√		null
featuretype	status	varchar	2147483647	√		null
positiontype	status	varchar	2147483647	√		null
statustype	status	varchar	2147483647	√		null
evidencedstringtype	subcellularlocationtype_location_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_location_hjindex	int4	10	√		null
evidencedstringtype	subcellularlocationtype_orientation_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_orientation_hjindex	int4	10	√		null
evidencedstringtype	subcellularlocationtype_topology_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_topology_hjindex	int4	10	√		null
subsetdef_content	subsetdef_content_hjchildid	int8	19	√		null
subsetdef_content	subsetdef_content_hjclass	varchar	2147483647	√		null
subsetdef_content	subsetdef_content_hjid	int8	19
subsetdef_content	subsetdef_content_hjindex	int4	10
synonym_content	synonym_content_hjchildid	int8	19	√		null
synonym_content	synonym_content_hjclass	varchar	2147483647	√		null
synonym_content	synonym_content_hjid	int8	19
synonym_content	synonym_content_hjindex	int4	10
synonymcategory_content	synonymcategory_content_hjchildid	int8	19	√		null
synonymcategory_content	synonymcategory_content_hjclass	varchar	2147483647	√		null
synonymcategory_content	synonymcategory_content_hjid	int8	19
synonymcategory_content	synonymcategory_content_hjindex	int4	10
synonymtypedef_content	synonymtypedef_content_hjchildid	int8	19	√		null
synonymtypedef_content	synonymtypedef_content_hjclass	varchar	2147483647	√		null
synonymtypedef_content	synonymtypedef_content_hjid	int8	19
synonymtypedef_content	synonymtypedef_content_hjindex	int4	10
goa	taxon	varchar	2147483647
commenttype	temperaturedependence	int8	19	√		null
term_content	term_content_hjchildid	int8	19	√		null
term_content	term_content_hjclass	varchar	2147483647	√		null
term_content	term_content_hjid	int8	19
term_content	term_content_hjindex	int4	10
citationtype	title	varchar	2147483647	√		null
citationtype	type	varchar	2147483647	√		null
commenttype	type	varchar	2147483647	√		null
commenttype_conflicttype	type	varchar	2147483647	√		null
dbreferencetype	type	varchar	2147483647	√		null
eventtype	type	varchar	2147483647	√		null
evidencetype	type	varchar	2147483647	√		null
featuretype	type	varchar	2147483647	√		null
genelocationtype	type	varchar	2147483647	√		null
genenametype	type	varchar	2147483647	√		null
isoformtype_sequencetype	type	varchar	2147483647	√		null
organismnametype	type	varchar	2147483647	√		null
propertytype	type	varchar	2147483647	√		null
proteinexistencetype	type	varchar	2147483647	√		null
typedef_content	typedef_content_hjchildid	int8	19	√		null
typedef_content	typedef_content_hjclass	varchar	2147483647	√		null
typedef_content	typedef_content_hjid	int8	19
typedef_content	typedef_content_hjindex	int4	10
entrytype	uniprottype_entry_hjid	int8	19	√		null
entrytype	uniprottype_entry_hjindex	int4	10	√		null
commenttype_linktype	uri	varchar	2147483647	√		null
copyright	value	varchar	2147483647	√		null
evidencedstringtype	value	varchar	2147483647	√		null
genenametype	value	varchar	2147483647	√		null
isoformtype_nametype	value	varchar	2147483647	√		null
keywordtype	value	varchar	2147483647	√		null
moleculetype	value	varchar	2147483647	√		null
organismnametype	value	varchar	2147483647	√		null
propertytype	value	varchar	2147483647	√		null
sequencetype	value	varchar	2147483647	√		null
sourcedatatype_plasmidtype	value	varchar	2147483647	√		null
sourcedatatype_straintype	value	varchar	2147483647	√		null
sourcedatatype_tissuetype	value	varchar	2147483647	√		null
sourcedatatype_transposontype	value	varchar	2147483647	√		null
statustype	value	varchar	2147483647	√		null
commenttype_conflicttype_sequencetype	version	int4	10	√		null
entrytype	version	int4	10	√		null
sequencetype	version	int4	10	√		null
citationtype	volume	varchar	2147483647	√		null
goa	with_or_from	varchar	2147483647	√		null
xrefanalog_content	xrefanalog_content_hjchildid	int8	19	√		null
xrefanalog_content	xrefanalog_content_hjclass	varchar	2147483647	√		null
xrefanalog_content	xrefanalog_content_hjid	int8	19
xrefanalog_content	xrefanalog_content_hjindex	int4	10
xrefunknown_content	xrefunknown_content_hjchildid	int8	19	√		null
xrefunknown_content	xrefunknown_content_hjclass	varchar	2147483647	√		null
xrefunknown_content	xrefunknown_content_hjid	int8	19
xrefunknown_content	xrefunknown_content_hjindex	int4	10