Column | MySQL Type | Oracle Type | Nullable | Description |
---|---|---|---|---|
WID | BIGINT | NUMBER | No | WID of this support |
OtherWID | BIGINT | NUMBER | No | WID of supported entity, e.g. Protein Function |
Type | VARCHAR | VARCHAR2(100) | Yes | Type: Identifies the type of assertion that this row pertains to. Enumerated Values:
protein function - The evidence supports protein function protein existence - The evidence supports protein existence |
EvidenceType | VARCHAR | VARCHAR2(100) | Yes | EvidenceType: Defines the type of evidential support that this row pertains to. Enumerated Values:
computational - Valid when type is 'protein function'. Protein function is supported by a computational prediction (example: existence of a gene could be supported by a gene-finding program). experimental - Valid when type is 'protein function'. Protein function is supported by data from a wet-lab experiment (example: existence of a gene could be supported observation of the gene's mRNA product in a microarray experiment). Evidence at protein level - Valid when type is 'protein existence'. Protein existence is supported by the evidences at protein level (e.g. clear identification by mass spectrometry). Evidence at transcript level - Valid when type is 'protein existence'. Protein existence is supported by evidences at transcript level (e.g. Northern blot). Inferred from homology - Valid when type is 'protein existence'. Protein existence is inferred by homology (strong sequence similarity to known proteins in related species). Predicted - Valid when type is 'protein existence'. Protein existence is predicted Uncertain - Valid when type is 'protein existence'. Protein existence is uncertain (e.g. dubious sequences that could be the erroneous translation of a pseudogene). |
Confidence | FLOAT | NUMBER | Yes | 0 < confidence <= 1. |
DataSetWID | BIGINT | NUMBER | No | The data set this entity came from or is associated with |
Column | References |
---|---|
OtherWID | Chemical : WID |
OtherWID | Element : WID |
OtherWID | Reaction : WID |
OtherWID | Protein : WID |
OtherWID | Feature : WID |
OtherWID | Function : WID |
OtherWID | EnzymaticReaction : WID |
OtherWID | Gene : WID |
OtherWID | BioSource : WID |
OtherWID | Pathway : WID |
OtherWID | NucleicAcid : WID |
OtherWID | Citation : WID |
Table | Column |
---|---|
Entry | OtherWID |
RelatedTerm | OtherWID |
CitationWIDOtherWID | OtherWID |
CommentTable | OtherWID |
CrossReference | OtherWID |
CrossReference | CrossWID |
Description | OtherWID |
DBID | OtherWID |
SynonymTable | OtherWID |
ToolAdvice | OtherWID |
Name | Columns |
---|---|
SUPPORT_OTHERWID | OTHERWID |
SUPPORT_TYPE | TYPE |
SUPPORT_CONFIDENCE | CONFIDENCE |