Destinations
Download GeneX Software
Development
Required Software
Suggested Software
Documentation & Help
Troubleshooting
Related Resources
GeneX Development Supported By
 Tracker
- Bugs
( 53 open / 229 total )
- Support Requests
( 0 open / 0 total )
- Patches
( 0 open / 0 total )
- Feature Requests
( 8 open / 70 total )  Forums ( 3 messages in 3 forums )
 Doc Manager
 Mailing Lists ( 5 mailing lists )
Screenshots
Task Manager
- SourceForge.net WWW Site - Genex Server - Documentation  CVS Tree ( 2502 commits, 834 adds ) 
 Released Files
|
| GeneX-2.0 DB: Reporter Table | ||
|---|---|---|
| Table Type | Inherits | Comment |
| DATA | Identifiable | The Reporter table describes the genetic elements that are used as probes in gene expression experiments (e.g. the cDNA elements that are immobilized on a glass slide). They can be cloned genes, ESTs, etc. |
| Column Information | ||||
|---|---|---|---|---|
| Column Name | Full Name | Data Type | Not NULL | Comment |
| chromosome | Chromosome Location | char128 | false | the chromosome on which the Reporter resides |
| clone_name | Clone Name | char128 | false | |
| clone_provider_con_fk | Clone Provider Contact | int | false | useful for tracking where the sequence feature came from if the clone was provided by another source (an untested feature at best, shouldn't this be handled by the smp_fk??) |
| end_position | End Position | int | false | the location with respect to the origin of the chromosome |
| other_name | Other Name | char128 | false | |
| other_type | Other Type | char128 | false | an alternative name by which the entity is known (doesn't this want to be a restricted vocab??) |
| plate_column | Plate Column | char128 | false | column reference to indentify the well on the plate this sequence feature came from. |
| plate_identifier | Plate | char128 | false | Used to identify a source plate for this sequence feature This could be a reference to the spotting plate, or it could refer to the original clone library plate. |
| plate_row | Plate Row | char128 | false | Row reference to indentify the well on the plate this sequence feature came from. |
| provider_con_fk | Provider Contact | int | false | the researcher that provided the reporter info |
| rep_name | Sequence Feature Name | char128 | true | an identifier such as EST or ORF name, by which the entity is known in the lab using it is expression experiments |
| rep_pk | Accession Number | serial | false | |
| rep_type | Sequence Feature Type | char128 | true | conrolled vocab |
| sequence | Sequence | text | false | may be used when dealing with ESTs that have not been submitted to a public database (won't be used for public version, but may be useful for local installations) |
| smp_fk | Sample | int | false | sample information for the Reporter this may be useful for identifying the state of the organism from which the sequence feature was obtained |
| spc_fk | Species | int | false | the species to which the Reporter belongs |
| start_position | Start Position | int | false | the location with respect to the origin of the chromosome |
| Primary Key Information |
|---|
| Column Name |
| rep_pk |
| Foreign Key Information | |||
|---|---|---|---|
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| clone_provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| provider_con_fk | Contact | con_pk | MANY_TO_ONE |
| smp_fk | Sample | smp_pk | MANY_TO_ONE |
| spc_fk | Species | spc_pk | MANY_TO_ONE |
| Unique Column Information |
|---|
| Column Names |
| rep_name provider_con_fk spc_fk |
| Index Information | |
|---|---|
| Name | Column Name |
genex-dev@lists.sourceforge.net