VIPERdb Database Browser

Lists of tables in VIPERdb. These are based on data categories in the MMS ontology (upper-case). Those added by the VIPERdb team are shown separately (lower-case). Mousing over a table name will give a short description of what types of data contains. Clicking on a name will provide more information on a table.

Below there is a text area where you can enter mySQL queries and view the results in a number of formats

Helpful information on writing your own scripts or programs can be found here

Enter your mySQL query (only SELECT, SHOW and DESCRIBE supported):

VIPERdb Tables (21 total)

au_matrix	extra_citation	extra_citation_author
extra_citation_editor	fam_gen_codes	hydroscore
icos_matrix	layer	layer_chain
qscore	spgrp_table	viper
viper_atom_site	viper_energy	viper_residue_asa
viper_residue_contact	viper_residue_energy	viper_residue_stride
viperdb_category	viperdb_item	xtal_table

MMS Tables (176 total)

ATOM_SITE	ATOM_SITES	ATOM_SITES_ALT
ATOM_SITES_ALT_ENS	ATOM_SITES_ALT_GEN	ATOM_SITES_FOOTNOTE
ATOM_SITE_ANISOTROP	ATOM_TYPE	CELL
CELL_MEASUREMENT	CELL_MEASUREMENT_REFLN	CHEM_COMP
CHEM_COMP_ANGLE	CHEM_COMP_ATOM	CHEM_COMP_BOND
CHEM_COMP_CHIR	CHEM_COMP_CHIR_ATOM	CHEM_COMP_LINK
CHEM_COMP_PLANE	CHEM_COMP_PLANE_ATOM	CHEM_COMP_TOR
CHEM_COMP_TOR_VALUE	CHEM_LINK	CHEM_LINK_ANGLE
CHEM_LINK_BOND	CHEM_LINK_CHIR	CHEM_LINK_CHIR_ATOM
CHEM_LINK_PLANE	CHEM_LINK_PLANE_ATOM	CHEM_LINK_TOR
CHEM_LINK_TOR_VALUE	CITATION	CITATION_AUTHOR
CITATION_EDITOR	COMPUTING	DATABASE_2
DATABASE_PDB_CAVEAT	DATABASE_PDB_MATRIX	DATABASE_PDB_REMARK
DATABASE_PDB_REV	DATABASE_PDB_REV_RECORD	DATABASE_PDB_TVECT
DIFFRN	DIFFRN_ATTENUATOR	DIFFRN_DETECTOR
DIFFRN_MEASUREMENT	DIFFRN_ORIENT_MATRIX	DIFFRN_ORIENT_REFLN
DIFFRN_RADIATION	DIFFRN_RADIATION_WAVELENGTH	DIFFRN_REFLN
DIFFRN_REFLNS	DIFFRN_SCALE_GROUP	DIFFRN_SOURCE
DIFFRN_STANDARDS	DIFFRN_STANDARD_REFLN	ENTITY
ENTITY_KEYWORDS	ENTITY_LINK	ENTITY_NAME_COM
ENTITY_NAME_SYS	ENTITY_POLY	ENTITY_POLY_SEQ
ENTITY_SRC_GEN	ENTITY_SRC_NAT	ENTRY_LINK
EXPTL	EXPTL_CRYSTAL	EXPTL_CRYSTAL_FACE
EXPTL_CRYSTAL_GROW	EXPTL_CRYSTAL_GROW_COMP	GEOM
GEOM_ANGLE	GEOM_BOND	GEOM_CONTACT
GEOM_HBOND	GEOM_TORSION	MMS_CATEGORY
MMS_ENTRY	MMS_ENTRY_CATEGORIES	MMS_ITEM
MMS_SYSTEM	PDBX_DATABASE_MESSAGE	PDBX_DATABASE_PDB_OBS_SPR
PDBX_DATABASE_PROC	PDBX_DATABASE_RELATED	PDBX_DATABASE_REMARK
PDBX_DATABASE_STATUS	PDBX_ENTITY_ASSEMBLY	PDBX_ENTITY_NAME
PDBX_ENTITY_SRC_SYN	PDBX_NMR_CONSTRAINTS	PDBX_NMR_DETAILS
PDBX_NMR_ENSEMBLE	PDBX_NMR_ENSEMBLE_RMS	PDBX_NMR_EXPTL
PDBX_NMR_EXPTL_SAMPLE	PDBX_NMR_EXPTL_SAMPLE_CONDITIONS	PDBX_NMR_FORCE_CONSTANTS
PDBX_NMR_REFINE	PDBX_NMR_REPRESENTATIVE	PDBX_NMR_SAMPLE_DETAILS
PDBX_NMR_SOFTWARE	PDBX_NMR_SPECTROMETER	PDBX_NONPOLY_SCHEME
PDBX_POLY_SEQ_SCHEME	PDBX_PRERELEASE_SEQ	PDBX_REFINE
PDBX_REFINE_AUX_FILE	PDBX_REFINE_TLS	PDBX_REFINE_TLS_GROUP
PDBX_STRUCT_SHEET_HBOND	PDBX_XPLOR_FILE	PHASING
PHASING_AVERAGING	PHASING_ISOMORPHOUS	PHASING_MAD
PHASING_MAD_CLUST	PHASING_MAD_EXPT	PHASING_MAD_RATIO
PHASING_MAD_SET	PHASING_MIR	PHASING_MIR_DER
PHASING_MIR_DER_REFLN	PHASING_MIR_DER_SHELL	PHASING_MIR_DER_SITE
PHASING_MIR_SHELL	PHASING_SET	PHASING_SET_REFLN
REFINE	REFINE_ANALYZE	REFINE_B_ISO
REFINE_HIST	REFINE_LS_RESTR	REFINE_LS_RESTR_NCS
REFINE_LS_SHELL	REFINE_OCCUPANCY	REFLN
REFLNS	REFLNS_SCALE	REFLNS_SHELL
SOFTWARE	STRUCT	STRUCT_ASYM
STRUCT_BIOL	STRUCT_BIOL_GEN	STRUCT_BIOL_KEYWORDS
STRUCT_BIOL_VIEW	STRUCT_CONF	STRUCT_CONF_TYPE
STRUCT_CONN	STRUCT_CONN_TYPE	STRUCT_KEYWORDS
STRUCT_MON_DETAILS	STRUCT_MON_NUCL	STRUCT_MON_PROT
STRUCT_MON_PROT_CIS	STRUCT_NCS_DOM	STRUCT_NCS_DOM_LIM
STRUCT_NCS_ENS	STRUCT_NCS_ENS_GEN	STRUCT_NCS_OPER
STRUCT_REF	STRUCT_REF_SEQ	STRUCT_REF_SEQ_DIF
STRUCT_SHEET	STRUCT_SHEET_HBOND	STRUCT_SHEET_ORDER
STRUCT_SHEET_RANGE	STRUCT_SHEET_TOPOLOGY	STRUCT_SITE
STRUCT_SITE_GEN	STRUCT_SITE_KEYWORDS	STRUCT_SITE_VIEW
SYMMETRY	SYMMETRY_EQUIV

Note: Only SELECT, SHOW or DESCRIBE queries can be performed, any other command will generate an error