{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 (117 total)

MSA_Structure_Based_DetailsMSA_Structure_Based_Resumeau_matrix
citationsclick_countcolumns_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
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.