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





VIPERdb Tables (115 total)

au_matrixcitationsclick_count
columns_privcounterdb
em_infoextra_citationextra_citation_author
extra_citation_editorfam_gen_codesfunc
guestbookhelp_categoryhelp_keyword
help_relationhelp_topichetero
hosthydroscoreicos_matrix
lab_computerslayerlayer_chain
layersmail_listproc
procs_privqscorespgrp_table
tables_privtime_zonetime_zone_leap_second
time_zone_nametime_zone_transitiontime_zone_transition_type
totalcountuserusers
viperviper_acl_groupsviper_acl_options
viper_acl_rolesviper_acl_roles_dataviper_acl_users
viper_atom_siteviper_attachmentsviper_banlist
viper_bbcodesviper_bookmarksviper_bots
viper_configviper_confirmviper_disallow
viper_draftsviper_energyviper_extension_groups
viper_extensionsviper_forumsviper_forums_access
viper_forums_trackviper_forums_watchviper_groups
viper_iconsviper_langviper_log
viper_moderator_cacheviper_modulesviper_poll_options
viper_poll_votesviper_postsviper_privmsgs
viper_privmsgs_folderviper_privmsgs_rulesviper_privmsgs_to
viper_profile_fieldsviper_profile_fields_dataviper_profile_fields_lang
viper_profile_langviper_ranksviper_reports
viper_reports_reasonsviper_residue_asaviper_residue_asa_jw
viper_residue_contactviper_residue_energyviper_residue_stride
viper_search_resultsviper_search_wordlistviper_search_wordmatch
viper_sessionsviper_sessions_keysviper_sitelist
viper_smiliesviper_stylesviper_styles_imageset
viper_styles_imageset_dataviper_styles_templateviper_styles_template_data
viper_styles_themeviper_topicsviper_topics_posted
viper_topics_trackviper_topics_watchviper_user_group
viper_usersviper_warningsviper_words
viper_zebraviperdb_categoryviperdb_item
viprefsvirus_infoxtal_contacts
xtal_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.