PICCOLO

 

 
pdb_atom_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

contact_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p1_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p1_atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

p1_element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p2_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

p2_element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

is_contact

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_cov

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_vdw

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_vdwclash

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_hb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcmchb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_scschb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcschb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_wmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcmcwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_scscwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcscwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_hydrophobe

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_ionic

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_aromarom

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_facetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_dispfacetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_edgetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_disulph

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_picat

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_aromsulph

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_proximal

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

distance

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_atom_pairs

0

PRIMARY

1

id

A

184639194

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

pdb

3

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

pdb

4

contact_id

A

184639194

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

3

p1_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

4

p1_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

pdb_atom_pairs

0

atom_pair

5

p1_atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

6

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

7

p2_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atom_pairs

0

atom_pair

8

p2_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

pdb_atom_pairs

0

atom_pair

9

p2_atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
pdb_atoms  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

 

 

select,insert,update,references

 

resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_atoms

0

PRIMARY

1

id

A

49216255

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

3

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

4

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

5

resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_atoms

0

pdb

6

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

pdb_atoms

0

pdb

7

atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
pdb_chain_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_chain_pairs

0

PRIMARY

1

id

A

164734

(NULL)

(NULL)

 

BTREE

 

pdb_chain_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_chain_pairs

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_chain_pairs

0

pdb

3

p2_chain

A

164734

(NULL)

(NULL)

 

BTREE

 

pdb_chain_pairs

1

pdbch

1

pdb

A

41183

(NULL)

(NULL)

 

BTREE

 

pdb_chain_pairs

1

pdbch

2

p2_chain

A

82367

(NULL)

(NULL)

 

BTREE

 

Back

 
pdb_chains  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_chains

0

PRIMARY

1

id

A

329468

(NULL)

(NULL)

 

BTREE

 

pdb_chains

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_chains

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_chains

0

pdb

3

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_chains

0

pdb

4

chain

A

329468

(NULL)

(NULL)

 

BTREE

 

Back

 
pdb_naccess_chains  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

apo_sum_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

delta_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_naccess_chains

0

PRIMARY

1

id

A

164855

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_chains

0

pdbchainsuniq

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_chains

0

pdbchainsuniq

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_chains

0

pdbchainsuniq

3

p2_chain

A

164855

(NULL)

(NULL)

 

BTREE

 

Back

 
pdb_naccess_residues  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

res_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

apo_abs_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

apo_rel_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_abs_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_rel_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

delta_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_naccess_residues

0

PRIMARY

1

id

A

78463339

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

3

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

4

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

5

res_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_naccess_residues

0

uniq_res

6

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back

 
pdb_res_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p1_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p2_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_res_pairs

0

PRIMARY

1

id

A

14618400

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

3

p1_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

4

p1_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

pdb_res_pairs

0

pdb

5

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

6

p2_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_res_pairs

0

pdb

7

p2_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back

 
pdb_residues  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

 

 

select,insert,update,references

 

resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

pdb_residues

0

PRIMARY

1

id

A

9065778

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

2

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

3

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

4

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

5

resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

pdb_residues

0

pdb

6

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back

 
quat_atom_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

contact_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p1_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p1_atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

p1_element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p2_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

p2_element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

is_contact

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_cov

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_vdw

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_vdwclash

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_hb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcmchb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_scschb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcschb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_wmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcmcwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_scscwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_mcscwmhb

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_hydrophobe

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_ionic

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_aromarom

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_facetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_dispfacetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_arom_edgetoface

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_disulph

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_picat

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_aromsulph

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

is_proximal

tinyint(4)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

distance

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_atom_pairs

0

PRIMARY

1

id

A

260224802

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

pdb

4

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

pdb

5

contact_id

A

260224802

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

4

p1_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

5

p1_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

quat_atom_pairs

0

atom_pair

6

p1_atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

7

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

8

p2_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atom_pairs

0

atom_pair

9

p2_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

quat_atom_pairs

0

atom_pair

10

p2_atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
quat_atoms  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

 

 

select,insert,update,references

 

resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

atname

char(4)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

element

char(2)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_atoms

0

PRIMARY

1

id

A

68597408

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

4

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

5

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

6

resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_atoms

0

pdb

7

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

quat_atoms

0

pdb

8

atname

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
quat_chain_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_chain_pairs

0

PRIMARY

1

id

A

203884

(NULL)

(NULL)

 

BTREE

 

quat_chain_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chain_pairs

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chain_pairs

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chain_pairs

0

pdb

4

p2_chain

A

203884

(NULL)

(NULL)

 

BTREE

 

Back

 
quat_chains  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_chains

0

PRIMARY

1

id

A

407768

(NULL)

(NULL)

 

BTREE

 

quat_chains

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chains

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chains

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chains

0

pdb

4

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_chains

0

pdb

5

chain

A

407768

(NULL)

(NULL)

 

BTREE

 

Back

 
quat_naccess_chains  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

apo_sum_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

delta_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_naccess_chains

0

PRIMARY

1

id

A

204005

(NULL)

(NULL)

 

BTREE

 

quat_naccess_chains

0

pdbchainsuniq

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_chains

0

pdbchainsuniq

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_chains

0

pdbchainsuniq

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_chains

0

pdbchainsuniq

4

p2_chain

A

204005

(NULL)

(NULL)

 

BTREE

 

Back

 
quat_naccess_residues  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

res_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

apo_abs_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

apo_rel_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_abs_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

bound_rel_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

delta_asa

float

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_naccess_residues

0

PRIMARY

1

id

A

96910295

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

4

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

5

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

6

res_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_naccess_residues

0

uniq_res

7

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back

 
quat_res_pairs  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p1_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p1_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p2_inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

p2_resname

char(3)

latin1_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_res_pairs

0

PRIMARY

1

id

A

20450685

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

4

p1_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

5

p1_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

quat_res_pairs

0

pdb

6

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

7

p2_resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_res_pairs

0

pdb

8

p2_inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back

 
quat_residues  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pdb

char(4)

latin1_general_ci

NO

MUL

 

 

select,insert,update,references

 

biomol_id

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

p1_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

p2_chain

char(1)

latin1_general_cs

NO

 

(NULL)

 

select,insert,update,references

 

chain

char(1)

latin1_general_cs

NO

 

 

 

select,insert,update,references

 

resid

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

inscode

char(1)

latin1_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

resname

char(3)

latin1_general_ci

NO

 

 

 

select,insert,update,references

 

sum_contact

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_cov

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdw

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_vdwclash

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmchb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcschb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_wmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcmcwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_scscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_mcscwmhb

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_hydrophobe

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_ionic

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromarom

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_facetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_dispfacetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_arom_edgetoface

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_disulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_picat

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_aromsulph

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

sum_proximal

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

quat_residues

0

PRIMARY

1

id

A

12497274

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

1

pdb

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

2

biomol_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

3

p1_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

4

p2_chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

5

chain

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

6

resid

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

quat_residues

0

pdb

7

inscode

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back