GeneX @ SourceForge

Destinations

GeneX Release Home

GeneX Dev Home

Download GeneX Software

GeneX Server SW

Development

GeneX development page

Join the GeneX mailing list

Weekly Status Updates

Review the GeneX development timeline: 2002

Source Code Repository

G2G: data exchange

SourceForge Project Page

Required Software

Apache Web Server

Perl

Required Perl modules

Suggested Software

R stats pkg

Documentation & Help

Server Installation

Genex-2 Schema Tables

GeneX Mailing Lists

CyberT Help

Troubleshooting

SourceForge BugTracking

Related Resources

Other Tools Page

Leming Shi's
DNA Microarray site

Gene-Arrays Listserv
by Subscription
or by egroups

David Lanes's Stats Books
and Tutorials

GeneX Development Supported By

Tracker

- Bugs ( 53 open / 229 total )
Bug Tracking System

- Support Requests ( 0 open / 0 total )
Tech Support Tracking System

- Patches ( 0 open / 0 total )
Patch Tracking System

- Feature Requests ( 8 open / 70 total )
Feature Request Tracking System

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: Species Table

GeneX-2.0 DB: Species Table
Table Type	Inherits	Comment
DATA	none	The Species table characterizes primary taxonomic information concerning the organisms being researched. It can be used to obtain further taxonomic data for the species in question.

Column Information
Column Name	Full Name	Data Type	Not NULL	Comment
audit_fk	Audit	int	true	The audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger.
cell_structure	Cell Structure	char128	false	controlled vocab
comments	Comments	text	false
common_names	Common Names	char128	false
general_classification	General Classification	char128	false	controlled vocab
genome_size	Genome Size	int	false
is_circular_genome	Is Circular Genome	bool	true
is_sequenced_genome	Is Sequenced Genome	bool	true
ncbi_taxonomy_acc	NCBI Taxonomy Accession Number	text	false
num_chromosomes	Number of Chromosomes	int	false
primary_scientific_name	Primary Scientific Name	char128	true
relevant_urls	Relevant URLs	text	false
ro_groupname	Read-Only Group Name	name	true	The group with permission to view this data
rw_groupname	Read/Write Group Name	name	true	The group with permission to modify this data
scientific_aliases	Scientific Aliases	text	false
spc_pk	Accession Number	serial	false

Primary Key Information
Column Name
spc_pk

Foreign Key Information
Column Name	Foreign Table	Primary Key in Foreign Table	Foreign Key Type
audit_fk	Audit	audit_pk	ONE_TO_ONE
ro_groupname	GroupSec	name	ONE_TO_ONE
rw_groupname	GroupSec	name	ONE_TO_ONE

Unique Column Information
Column Names
primary_scientific_name

Index Information
Name	Column Name