| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | The warehouse ID of this protein |
| Name | TEXT | VARCHAR2(4000) | Yes | Common name of the protein, if it exists |
| AASequence | LONGTEXT | CLOB | Yes | Amino-acid sequence for this protein, if available |
| Length | INT | NUMBER | Yes | Length of the amino-acid sequence for this protein, if available This value is not necessarily exact, as can be modified by LengthApproximate |
| LengthApproximate | VARCHAR | VARCHAR2(10) | Yes | Indicates that the Length is an approximate. It could be 'gt' for greater than, 'lt' for less than and 'ne' to indicate that it is not equal. This is a controlled vocabulary. |
| Charge | SMALLINT | NUMBER | Yes | Charge of the chemical |
| Fragment | CHAR(1) | CHAR(1) | Yes | 'T' if protein is a fragment, else 'F' |
| MolecularWeightCalc | FLOAT | NUMBER | Yes | Molecular weight calculated from sequence. Units: kiloDaltons. |
| MolecularWeightExp | FLOAT | NUMBER | Yes | Molecular Weight determined through experimentation. Units: kiloDaltons. |
| PICalc | VARCHAR | VARCHAR2(50) | Yes | Isoelectric point (pI) calculated from its sequence. |
| PIExp | VARCHAR | VARCHAR2(50) | Yes | Isoelectric point (pI) determined through experimentation. |
| DataSetWID | BIGINT | NUMBER | No | WID of the dataset the protein is from |
| Table | Column |
|---|---|
| EnzymaticReaction | ProteinWID |
| EnzymaticReaction | ComplexWID |
| Location | ProteinWID |
| Subunit | ComplexWID |
| Subunit | SubunitWID |
| BioSourceWIDProteinWID | ProteinWID |
| GeneWIDProteinWID | ProteinWID |
| ProteinWIDFunctionWID | ProteinWID |
| ProteinWIDSpotWID | ProteinWID |
| Entry | OtherWID |
| Feature | SequenceWID |
| Support | OtherWID |
| EnzReactionInhibitorActivator | CompoundWID |
| Product | OtherWID |
| Reactant | OtherWID |
| InteractionParticipant | OtherWID |
| SequenceMatch | QueryWID |
| SequenceMatch | MatchWID |
| RelatedTerm | OtherWID |
| CitationWIDOtherWID | OtherWID |
| CommentTable | OtherWID |
| CrossReference | OtherWID |
| CrossReference | CrossWID |
| Description | OtherWID |
| DBID | OtherWID |
| SynonymTable | OtherWID |
| ToolAdvice | OtherWID |
| Name | Columns |
|---|---|
| PROTEIN_DWID | DataSetWID |
| PROTEIN_NAME | |
| PROTEIN_CHARGE | CHARGE |
| PROTEIN_MOLEWEIGHTCALC | MOLECULARWEIGHTCALC |
| PROTEIN_MOLEWEIGHTEXP | MOLECULARWEIGHTEXP |
| PROTEIN_PICALC | PICALC |
| PROTEIN_PIEXP | PIEXP |