Tables Information

Table align_sequences

Name: align_sequences
Code: align_sequences
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores information regarding to the sequences and quality values that belong to alignments.

Column List

Name

Code

Type

P

M

align_id

align_id

int4

No

No

align_order

align_order

int4

No

No

align_quality

align_quality

text

No

No

align_seq_id

align_seq_id

int4

Yes

Yes

align_sequence

align_sequence

text

No

No

seq_id_phrap

seq_id_phrap

int4

No

No

Fill List

Name

Type

Null

Distinct

Length

M

U

F

align_id

int4

0%

100%

4

No

No

Yes

align_order

int4

0%

100%

4

No

No

No

align_quality

text

0%

100%

0

No

No

No

align_seq_id

int4

0%

100%

4

Yes

Yes

No

align_sequence

text

0%

100%

0

No

No

No

seq_id_phrap

int4

0%

100%

4

No

No

Yes

Column align_seq_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column seq_id_phrap

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_order

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_sequence

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:0

Column align_quality

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:0

Index List

Index Code

P

F

A

U

C

Column Code

Sort

align_sequences_pkey

Yes

No

No

Yes

No

align_seq_id

ASC

Reference to List

Primary Key

Reference to

Foreign Key

align_id

alignments

align_id

seq_id_phrap

seq_phrap

seq_id_phrap

Table alignments

Name: alignments
Code: alignments
Label:
Owner:
Number:
PK constraint:
Source:

Description

Store general algnment information, ownership, and statistics about the alignments

Column List

Name

Code

Type

P

M

align_1nt

align_1nt

int4

No

No

align_2nt

align_2nt

int4

No

No

align_3nt

align_3nt

int4

No

No

align_4nt

align_4nt

int4

No

No

align_5nt

align_5nt

int4

No

No

align_6nt

align_6nt

int4

No

No

align_core_left

align_core_left

int4

No

No

align_core_length

align_core_length

int4

No

No

align_core_right

align_core_right

int4

No

No

align_good

align_good

int4

No

No

align_id

align_id

int4

Yes

Yes

align_length

align_length

int4

No

No

align_owner

align_owner

int4

No

No

align_parent_id

align_parent_id

int4

No

No

align_version

align_version

int4

No

No

align_visible

align_visible

bool(1)

No

No

core_1nt

core_1nt

int4

No

No

core_2nt

core_2nt

int4

No

No

core_3nt

core_3nt

int4

No

No

core_4nt

core_4nt

int4

No

No

core_5nt

core_5nt

int4

No

No

core_6nt

core_6nt

int4

No

No

gene_id

gene_id

int4

No

No

number_seqs

number_seqs

int4

No

No

Fill List

Name

Type

Null

Distinct

Length

M

U

F

align_1nt

int4

0%

100%

4

No

No

No

align_2nt

int4

0%

100%

4

No

No

No

align_3nt

int4

0%

100%

4

No

No

No

align_4nt

int4

0%

100%

4

No

No

No

align_5nt

int4

0%

100%

4

No

No

No

align_6nt

int4

0%

100%

4

No

No

No

align_core_left

int4

0%

100%

4

No

No

No

align_core_length

int4

0%

100%

4

No

No

No

align_core_right

int4

0%

100%

4

No

No

No

align_good

int4

0%

100%

4

No

No

No

align_id

int4

0%

100%

4

Yes

Yes

No

align_length

int4

0%

100%

4

No

No

No

align_owner

int4

0%

100%

4

No

No

Yes

align_parent_id

int4

0%

100%

4

No

No

Yes

align_version

int4

0%

100%

4

No

No

No

align_visible

bool(1)

0%

100%

1

No

No

No

core_1nt

int4

0%

100%

4

No

No

No

core_2nt

int4

0%

100%

4

No

No

No

core_3nt

int4

0%

100%

4

No

No

No

core_4nt

int4

0%

100%

4

No

No

No

core_5nt

int4

0%

100%

4

No

No

No

core_6nt

int4

0%

100%

4

No

No

No

gene_id

int4

0%

100%

4

No

No

Yes

number_seqs

int4

0%

100%

4

No

No

No

Column align_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column gene_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column number_seqs

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_version

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_length

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_core_length

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_core_left

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_core_right

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_1nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_2nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_3nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_4nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_5nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_6nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_1nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_2nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_3nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_4nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_5nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column core_6nt

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_parent_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_good

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column align_visible

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:1

Column align_owner

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Index List

Index Code

P

F

A

U

C

Column Code

Sort

alignments_pkey

Yes

No

No

Yes

No

align_id

ASC

Reference to List

Primary Key

Reference to

Foreign Key

align_id

alignments

align_parent_id

gene_id

genes

gene_id

labuser_id

labusers

align_owner

Reference by List

Referenced by

Primary Key

Foreign Key

align_sequences

align_id

align_id

alignments

align_id

align_parent_id

Table amplicons

Name: amplicons
Code: amplicons
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores general information regarding to amplicons that belong to sequenced genes.

Column List

Name

Code

Type

P

M

amplicon_desc

amplicon_desc

varchar(36)

No

No

amplicon_id

amplicon_id

int4

Yes

Yes

amplicon_name

amplicon_name

varchar(36)

No

No

amplicon_order

amplicon_order

int4

No

No

amplicon_start

amplicon_start

int4

No

No

amplicon_stop

amplicon_stop

int4

No

No

gene_id

gene_id

int4

No

No

Fill List

Name

Type

Null

Distinct

Length

M

U

F

amplicon_desc

varchar(36)

0%

100%

36

No

No

No

amplicon_id

int4

0%

100%

4

Yes

Yes

No

amplicon_name

varchar(36)

0%

100%

36

No

No

No

amplicon_order

int4

0%

100%

4

No

No

No

amplicon_start

int4

0%

100%

4

No

No

No

amplicon_stop

int4

0%

100%

4

No

No

No

gene_id

int4

0%

100%

4

No

No

Yes

Column amplicon_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column gene_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Column amplicon_order

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_start

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_stop

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_desc

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Reference to List

Primary Key

Reference to

Foreign Key

gene_id

genes

gene_id

Reference by List

Referenced by

Primary Key

Foreign Key

primers

amplicon_id

amplicon_id

seq_phrap

amplicon_id

amplicon_id

Table genes

Name: genes
Code: genes
Label:
Owner:
Number:
PK constraint:
Source:

Description

Records information related to genes used for sequencing

Column List

Name

Code

Type

P

M

gene_desc

gene_desc

varchar(254)

No

No

gene_id

gene_id

int4

Yes

Yes

gene_name

gene_name

varchar(36)

No

Yes

Fill List

Name

Type

Null

Distinct

Length

M

U

F

gene_desc

varchar(254)

0%

100%

254

No

No

No

gene_id

int4

0%

100%

4

Yes

Yes

No

gene_name

varchar(36)

0%

100%

36

Yes

Yes

No

Column gene_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column gene_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Column gene_desc

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:254

Index List

Index Code

P

F

A

U

C

Column Code

Sort

genes_gene_name_key

No

No

No

Yes

No

gene_name

ASC

genes_pkey

Yes

No

No

Yes

No

gene_id

ASC

Reference by List

Referenced by

Primary Key

Foreign Key

alignments

gene_id

gene_id

amplicons

gene_id

gene_id

primers

gene_id

gene_id

seq_phrap

gene_id

gene_id

Table labusers

Name: labusers
Code: labusers
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores information regarding to users involved in the database and user interface manipulation.

Column List

Name

Code

Type

P

M

labuser_id

labuser_id

int4

Yes

Yes

labuser_name

labuser_name

varchar(36)

No

Yes

Fill List

Name

Type

Null

Distinct

Length

M

U

F

labuser_id

int4

0%

100%

4

Yes

Yes

No

labuser_name

varchar(36)

0%

100%

36

Yes

Yes

No

Column labuser_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column labuser_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Index List

Index Code

P

F

A

U

C

Column Code

Sort

labusers_labuser_name_key

No

No

No

Yes

No

labuser_name

ASC

labusers_pkey

Yes

No

No

Yes

No

labuser_id

ASC

Reference by List

Referenced by

Primary Key

Foreign Key

alignments

labuser_id

align_owner

permissions

labuser_id

user_id

Table objects

Name: objects
Code: objects
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores information about the entities (menus) used in the user interface.

Column List

Name

Code

Type

P

M

object_id

object_id

int4

Yes

Yes

object_name

object_name

varchar(36)

No

Yes

Fill List

Name

Type

Null

Distinct

Length

M

U

F

object_id

int4

0%

100%

4

Yes

Yes

No

object_name

varchar(36)

0%

100%

36

Yes

Yes

No

Column object_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column object_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Index List

Index Code

P

F

A

U

C

Column Code

Sort

objects_object_name_key

No

No

No

Yes

No

object_name

ASC

objects_pkey

Yes

No

No

Yes

No

object_id

ASC

Reference by List

Referenced by

Primary Key

Foreign Key

permissions

object_id

object_id

Table permissions

Name: permissions
Code: permissions
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores identifiers related to privileges that users have to work with the entities (menus) in the user interface.

Column List

Name

Code

Type

P

M

object_id

object_id

int4

No

Yes

user_id

user_id

int4

No

No

Fill List

Name

Type

Null

Distinct

Length

M

U

F

object_id

int4

0%

100%

4

Yes

No

Yes

user_id

int4

0%

100%

4

No

No

Yes

Column user_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column object_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Reference to List

Primary Key

Reference to

Foreign Key

labuser_id

labusers

user_id

object_id

objects

object_id

Table populations

Name: populations
Code: populations
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores general information regarding to the populations used to record sequences and quality values.

Column List

Name

Code

Type

P

M

population_desc

population_desc

varchar(254)

No

No

population_id

population_id

int4

Yes

Yes

population_name

population_name

varchar(36)

No

Yes

Fill List

Name

Type

Null

Distinct

Length

M

U

F

population_desc

varchar(254)

0%

100%

254

No

No

No

population_id

int4

0%

100%

4

Yes

Yes

No

population_name

varchar(36)

0%

100%

36

Yes

Yes

No

Column population_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column population_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Column population_desc

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:254

Index List

Index Code

P

F

A

U

C

Column Code

Sort

populations_pkey

Yes

No

No

Yes

No

population_id

ASC

populations_population_name_key

No

No

No

Yes

No

population_name

ASC

Reference by List

Referenced by

Primary Key

Foreign Key

seq_phrap

population_id

population_id

Table primers

Name: primers
Code: primers
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores general information regarding to primers used during the sequencing process.

Column List

Name

Code

Type

P

M

amplicon_id

amplicon_id

int4

No

No

gene_id

gene_id

int4

No

No

primer_direction

primer_direction

varchar(3)

No

No

primer_id

primer_id

int4

Yes

Yes

primer_name

primer_name

varchar(36)

No

Yes

primer_sequence

primer_sequence

varchar(100)

No

Yes

primer_tm

primer_tm

float4

No

No

Fill List

Name

Type

Null

Distinct

Length

M

U

F

amplicon_id

int4

0%

100%

4

No

No

Yes

gene_id

int4

0%

100%

4

No

No

Yes

primer_direction

varchar(3)

0%

100%

3

No

No

No

primer_id

int4

0%

100%

4

Yes

Yes

No

primer_name

varchar(36)

0%

100%

36

Yes

Yes

No

primer_sequence

varchar(100)

0%

100%

100

Yes

No

No

primer_tm

float4

0%

100%

4

No

No

No

Column primer_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column primer_name

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:36

Column primer_direction

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:3

Column primer_sequence

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:100

Column primer_tm

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column gene_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Index List

Index Code

P

F

A

U

C

Column Code

Sort

primers_pkey

Yes

No

No

Yes

No

primer_id

ASC

primers_primer_name_key

No

No

No

Yes

No

primer_name

ASC

Reference to List

Primary Key

Reference to

Foreign Key

amplicon_id

amplicons

amplicon_id

gene_id

genes

gene_id

Reference by List

Referenced by

Primary Key

Foreign Key

seq_phrap

primer_id

primer_fwd

seq_phrap

primer_id

primer_rev

Table seq_phrap

Name: seq_phrap
Code: seq_phrap
Label:
Owner:
Number:
PK constraint:
Source:

Description

Stores information regarding to quality values reported by PHRED/PHAP program that belong to genes for related populations.

Column List

Name

Code

Type

P

M

amplicon_id

amplicon_id

int4

No

No

clustal

clustal

bool(1)

No

No

gene_id

gene_id

int4

No

No

nt_quality

nt_quality

text

No

No

nt_sequence

nt_sequence

text

No

No

phrap_type

phrap_type

bpchar(1)

No

No

population_id

population_id

int4

No

No

primer_fwd

primer_fwd

int4

No

No

primer_rev

primer_rev

int4

No

No

seq_id_phrap

seq_id_phrap

int4

Yes

Yes

Fill List

Name

Type

Null

Distinct

Length

M

U

F

amplicon_id

int4

0%

100%

4

No

No

Yes

clustal

bool(1)

0%

100%

1

No

No

No

gene_id

int4

0%

100%

4

No

No

Yes

nt_quality

text

0%

100%

0

No

No

No

nt_sequence

text

0%

100%

0

No

No

No

phrap_type

bpchar(1)

0%

100%

1

No

No

No

population_id

int4

0%

100%

4

No

No

Yes

primer_fwd

int4

0%

100%

4

No

No

Yes

primer_rev

int4

0%

100%

4

No

No

Yes

seq_id_phrap

int4

0%

100%

4

Yes

Yes

No

Column seq_id_phrap

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column phrap_type

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:1

Column population_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column gene_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column nt_sequence

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:0

Column nt_quality

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:0

Column clustal

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:1

Column primer_rev

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column primer_fwd

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Column amplicon_id

Client Check Expression

Server Check Expression

Fill

Null Values:0%
Distinct Values:100%
Average Length:4

Index List

Index Code

P

F

A

U

C

Column Code

Sort

seq_phrap_pkey

Yes

No

No

Yes

No

seq_id_phrap

ASC

Reference to List

Primary Key

Reference to

Foreign Key

amplicon_id

amplicons

amplicon_id

gene_id

genes

gene_id

population_id

populations

population_id

primer_id

primers

primer_rev

primer_id

primers

primer_fwd

Reference by List

Referenced by

Primary Key

Foreign Key

align_sequences

seq_id_phrap

seq_id_phrap


Home Page - Previous page