Feedback Form
{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 (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


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

©1998-2016. TSRI. All rights Reserved.