{pdb_id}

VIPERdb Database Browser

Below are lists of the tables in VIPERdb. Tables based on data categories in the MMS ontology and those added by the VIPERdb team are shown separately in upper and lower case letters, respectively. Mousing over a table name will give a short description of what types of data it contains. Clicking on a name will provide more information on a table.

There is a window at the bottom of the page where you can enter SQL queries and view the results in a number of formats

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



VIPERdb Tables (119 total)

MSA_FamilyMSA_Structure_Based_Advanced_DetailsMSA_Structure_Based_Details
MSA_Structure_Based_Resumeau_matrixcitations
click_countcolumns_privcounter
dbem_infoextra_citation
extra_citation_authorextra_citation_editorfam_gen_codes
funcguestbookhelp_category
help_keywordhelp_relationhelp_topic
heterohosthydroscore
icos_matrixlab_computerslayer
layer_chainlayersmail_list
procprocs_privqscore
spgrp_tabletables_privtime_zone
time_zone_leap_secondtime_zone_nametime_zone_transition
time_zone_transition_typetotalcountuser
usersviperviper_acl_groups
viper_acl_optionsviper_acl_rolesviper_acl_roles_data
viper_acl_usersviper_atom_siteviper_attachments
viper_banlistviper_bbcodesviper_bookmarks
viper_botsviper_configviper_confirm
viper_disallowviper_draftsviper_energy
viper_extension_groupsviper_extensionsviper_forums
viper_forums_accessviper_forums_trackviper_forums_watch
viper_groupsviper_iconsviper_lang
viper_logviper_moderator_cacheviper_modules
viper_poll_optionsviper_poll_votesviper_posts
viper_privmsgsviper_privmsgs_folderviper_privmsgs_rules
viper_privmsgs_toviper_profile_fieldsviper_profile_fields_data
viper_profile_fields_langviper_profile_langviper_ranks
viper_reportsviper_reports_reasonsviper_residue_asa
viper_residue_asa_jwviper_residue_contactviper_residue_energy
viper_residue_strideviper_search_resultsviper_search_wordlist
viper_search_wordmatchviper_sessionsviper_sessions_keys
viper_sitelistviper_smiliesviper_styles
viper_styles_imagesetviper_styles_imageset_dataviper_styles_template
viper_styles_template_dataviper_styles_themeviper_topics
viper_topics_postedviper_topics_trackviper_topics_watch
viper_user_groupviper_usersviper_warnings
viper_wordsviper_zebraviperdb_category
viperdb_itemviprefsvirus_info
xtal_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
Enters your SQL query (only SELECT, SHOW and DESCRIBE supported):

Output format:   

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-2017. TSRI. All rights Reserved.