Feedback Form
{pdb_id}

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):


Output format:      





VIPERdb Tables (114 total)

au_matrixcitationscolumns_priv
counterdbem_info
extra_citationextra_citation_authorextra_citation_editor
fam_gen_codesfuncguestbook
help_categoryhelp_keywordhelp_relation
help_topicheterohost
hydroscoreicos_matrixlab_computers
layerlayer_chainlayers
mail_listprocprocs_priv
qscorespgrp_tabletables_priv
time_zonetime_zone_leap_secondtime_zone_name
time_zone_transitiontime_zone_transition_typetotalcount
userusersviper
viper_acl_groupsviper_acl_optionsviper_acl_roles
viper_acl_roles_dataviper_acl_usersviper_atom_site
viper_attachmentsviper_banlistviper_bbcodes
viper_bookmarksviper_botsviper_config
viper_confirmviper_disallowviper_drafts
viper_energyviper_extension_groupsviper_extensions
viper_forumsviper_forums_accessviper_forums_track
viper_forums_watchviper_groupsviper_icons
viper_langviper_logviper_moderator_cache
viper_modulesviper_poll_optionsviper_poll_votes
viper_postsviper_privmsgsviper_privmsgs_folder
viper_privmsgs_rulesviper_privmsgs_toviper_profile_fields
viper_profile_fields_dataviper_profile_fields_langviper_profile_lang
viper_ranksviper_reportsviper_reports_reasons
viper_residue_asaviper_residue_asa_jwviper_residue_contact
viper_residue_energyviper_residue_strideviper_search_results
viper_search_wordlistviper_search_wordmatchviper_sessions
viper_sessions_keysviper_sitelistviper_smilies
viper_stylesviper_styles_imagesetviper_styles_imageset_data
viper_styles_templateviper_styles_template_dataviper_styles_theme
viper_topicsviper_topics_postedviper_topics_track
viper_topics_watchviper_user_groupviper_users
viper_warningsviper_wordsviper_zebra
viperdb_categoryviperdb_itemviprefs
virus_infoxtal_contactsxtal_table





MMS Tables (176 total)

ATOM_SITEATOM_SITESATOM_SITES_ALT
ATOM_SITES_ALT_ENSATOM_SITES_ALT_GENATOM_SITES_FOOTNOTE
ATOM_SITE_ANISOTROPATOM_TYPECELL
CELL_MEASUREMENTCELL_MEASUREMENT_REFLNCHEM_COMP
CHEM_COMP_ANGLECHEM_COMP_ATOMCHEM_COMP_BOND
CHEM_COMP_CHIRCHEM_COMP_CHIR_ATOMCHEM_COMP_LINK
CHEM_COMP_PLANECHEM_COMP_PLANE_ATOMCHEM_COMP_TOR
CHEM_COMP_TOR_VALUECHEM_LINKCHEM_LINK_ANGLE
CHEM_LINK_BONDCHEM_LINK_CHIRCHEM_LINK_CHIR_ATOM
CHEM_LINK_PLANECHEM_LINK_PLANE_ATOMCHEM_LINK_TOR
CHEM_LINK_TOR_VALUECITATIONCITATION_AUTHOR
CITATION_EDITORCOMPUTINGDATABASE_2
DATABASE_PDB_CAVEATDATABASE_PDB_MATRIXDATABASE_PDB_REMARK
DATABASE_PDB_REVDATABASE_PDB_REV_RECORDDATABASE_PDB_TVECT
DIFFRNDIFFRN_ATTENUATORDIFFRN_DETECTOR
DIFFRN_MEASUREMENTDIFFRN_ORIENT_MATRIXDIFFRN_ORIENT_REFLN
DIFFRN_RADIATIONDIFFRN_RADIATION_WAVELENGTHDIFFRN_REFLN
DIFFRN_REFLNSDIFFRN_SCALE_GROUPDIFFRN_SOURCE
DIFFRN_STANDARDSDIFFRN_STANDARD_REFLNENTITY
ENTITY_KEYWORDSENTITY_LINKENTITY_NAME_COM
ENTITY_NAME_SYSENTITY_POLYENTITY_POLY_SEQ
ENTITY_SRC_GENENTITY_SRC_NATENTRY_LINK
EXPTLEXPTL_CRYSTALEXPTL_CRYSTAL_FACE
EXPTL_CRYSTAL_GROWEXPTL_CRYSTAL_GROW_COMPGEOM
GEOM_ANGLEGEOM_BONDGEOM_CONTACT
GEOM_HBONDGEOM_TORSIONMMS_CATEGORY
MMS_ENTRYMMS_ENTRY_CATEGORIESMMS_ITEM
MMS_SYSTEMPDBX_DATABASE_MESSAGEPDBX_DATABASE_PDB_OBS_SPR
PDBX_DATABASE_PROCPDBX_DATABASE_RELATEDPDBX_DATABASE_REMARK
PDBX_DATABASE_STATUSPDBX_ENTITY_ASSEMBLYPDBX_ENTITY_NAME
PDBX_ENTITY_SRC_SYNPDBX_NMR_CONSTRAINTSPDBX_NMR_DETAILS
PDBX_NMR_ENSEMBLEPDBX_NMR_ENSEMBLE_RMSPDBX_NMR_EXPTL
PDBX_NMR_EXPTL_SAMPLEPDBX_NMR_EXPTL_SAMPLE_CONDITIONSPDBX_NMR_FORCE_CONSTANTS
PDBX_NMR_REFINEPDBX_NMR_REPRESENTATIVEPDBX_NMR_SAMPLE_DETAILS
PDBX_NMR_SOFTWAREPDBX_NMR_SPECTROMETERPDBX_NONPOLY_SCHEME
PDBX_POLY_SEQ_SCHEMEPDBX_PRERELEASE_SEQPDBX_REFINE
PDBX_REFINE_AUX_FILEPDBX_REFINE_TLSPDBX_REFINE_TLS_GROUP
PDBX_STRUCT_SHEET_HBONDPDBX_XPLOR_FILEPHASING
PHASING_AVERAGINGPHASING_ISOMORPHOUSPHASING_MAD
PHASING_MAD_CLUSTPHASING_MAD_EXPTPHASING_MAD_RATIO
PHASING_MAD_SETPHASING_MIRPHASING_MIR_DER
PHASING_MIR_DER_REFLNPHASING_MIR_DER_SHELLPHASING_MIR_DER_SITE
PHASING_MIR_SHELLPHASING_SETPHASING_SET_REFLN
REFINEREFINE_ANALYZEREFINE_B_ISO
REFINE_HISTREFINE_LS_RESTRREFINE_LS_RESTR_NCS
REFINE_LS_SHELLREFINE_OCCUPANCYREFLN
REFLNSREFLNS_SCALEREFLNS_SHELL
SOFTWARESTRUCTSTRUCT_ASYM
STRUCT_BIOLSTRUCT_BIOL_GENSTRUCT_BIOL_KEYWORDS
STRUCT_BIOL_VIEWSTRUCT_CONFSTRUCT_CONF_TYPE
STRUCT_CONNSTRUCT_CONN_TYPESTRUCT_KEYWORDS
STRUCT_MON_DETAILSSTRUCT_MON_NUCLSTRUCT_MON_PROT
STRUCT_MON_PROT_CISSTRUCT_NCS_DOMSTRUCT_NCS_DOM_LIM
STRUCT_NCS_ENSSTRUCT_NCS_ENS_GENSTRUCT_NCS_OPER
STRUCT_REFSTRUCT_REF_SEQSTRUCT_REF_SEQ_DIF
STRUCT_SHEETSTRUCT_SHEET_HBONDSTRUCT_SHEET_ORDER
STRUCT_SHEET_RANGESTRUCT_SHEET_TOPOLOGYSTRUCT_SITE
STRUCT_SITE_GENSTRUCT_SITE_KEYWORDSSTRUCT_SITE_VIEW
SYMMETRYSYMMETRY_EQUIV

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



Main | Data & Analysis | Utilities | Search | Contact Us | Help | Links | Mailing List | Cite VIPERdb | Disclaimer

©1998-2016. TSRI. All rights Reserved.