|
MDB News
- September 23, 2001 - Updated the MDB content using all structures from the PDB
released as of Friday, September 21, 2001.
The database now contains 5473
metal-containing proteins and 19,333 sites.
- June 7, 2001 - MDB and Web server hardware upgraded to Sun Blade 100 CPU.
- January 19, 2001 - Added new tables to the MDB database. We have now
collected data that will allow dehomologized searches (using
PDBSELECT and
WHATIF SELECT), as well as crossreferences of ligand names and their entries
in the HET LIST
(from PDB). Torsions for selected residues (His, Asp, etc.) have been
collected, for all proteins in the latest PDB release, this will allow us to
compare trends in metal-binding sites with the rest of the proteins. For a
peek at the current schema, view the current
schema
- December 11, 2000 - Updated the MDB content using all structures from the PDB
released as of
Wednesday, December 6, 2000.
- October 12, 2000 - Backend server software upgraded. Now running PHP 4.0.3 (with XML
and XSLT extensions)
- August 24, 2000 - Server and backend server software upgraded. Now running Apache
3.0.12, and PHP 4.0.1pl2.
- Version 1.4 (Dec. 20, 1999)
Changes and bug fixes
This is a minor release. The next major release (version 2.0) will
include more functionality and a better data set (automatically recognized
first and second shell, nuclearity, geometry, etc.). Until the next
major release updates to the data content will be made, but the recognition
algorithm used in the versions 1.x will not be changed.
- The database contains the metal-binding sites from entries in the
PDB database as of December 03, 1999: the MDB about 3700 macromolecules,
with a total of about 10700 metal-containing sites.
- A script demonstrating our idea for a Web-based MDB API (more information
on this topic will come later).
The script accepts a valid "SELECT" SQL statement, and
generates a result set in one of three different formats: HTML table, Comma
Separated Values or as a WDDX packet.
Go to the MDB API page for
more information. [beta]
- A series of other search and display interfaces have been added
in a simple implementation. Full implementation of these capabilities
will be done once the next major release (version 2.0) is completed.
Go to the MDB beta test page to use the:
- Metal-ligand histogram/statistics calculation form
- Metal liganding pattern plot form
- Examples of XML/CML representations of metal-sites
- Chime examples of metal sites containing first and second
shell information.
- Fixed the problem with extraneous ligands showing in the display
and in the "mini-pdb" files, due to non-unique residue numbers in some
PDB files.
- The "ligand files" format has changed, the information in the
"Packages" page will be updated to reflect that.
- The advanced forms have been modified to allow for more complex
searching.
- A bug in the selection of year ranges when using the advanced
form was fixed
- Problems with the protein descriptions has been solved.
- Search forms now check that the user send some reasonable combination
of input. An appropriate error message is now displayed if some critical
piece of information is missing or if one of two linked conditions has
not been set.
- To avoid infinite time searches, the search scripts have a limit of
3 minutes of running time, this does not include the time taken by the
database server itself.
- Also to avoid the problem above, the database server will refuse to
make a search in which the intermediate table (product of joining two or
more tables) will contain more than 1'000,0000 (one million) rows.
Known bugs
- The site information contains only first shell ligands, and
does not automatically recognize multinuclear or cluster sites.
The next major release solves this problem (see the beta
page for a preview).
- Hemes contain sometimes extra ligating atoms, because the algorithm
for the version 1.x has some problems with recognizing automatically
those systems.
Miscellaneous
- A clarification. In the search forms in this site, "number of ligands"
refers to the number of atoms ligated to a metal center. The number of
residues ligating to a metal will then be equal or less than that number.
- The "Edited" database will no longer be updated. The indexing algorithm
used in constructing the next major release (version 2.0), will make the
information in the "Edited DB" redundant. This part of the MDB has been
frozen since release 1.2 and will remain so.
- (December 17, 1999)
New 1.x release being made, so some minor interruptions will occur from
time to time. The database now contains first shell information for
metal-binding sites in proteins in the PDB as of Dec 03, 1999.
More information will be posted here soon.
- (November 18, 1999)
Just implemented a script that accepts a valid "SELECT" SQL statement, and
generates a result set in one of three different formats: HTML table, Comma
Separated Values or as a WDDX packet.
First in a series of scripts implementing a MDB API
for application to application communication. Go to the
MDB API page for more information.
-- JMC
- (September 23, 1999)
New goodies to beta test. I made a simple page listing them. Go to the
MDB beta test page to see what is available.
The CML/XML part is not too documented and may not make any sense unless you
know what XML is. -- JMC
- (September 21, 1999)
We have migrated most of the site to a new backend database engine:
MySQL. Let me know if you catch a
bug that I did not -- JMC.
- (September 21, 1999)
You can download the source of CCMS/TSRI Macromolecular
java viewer (used in the interactive search interface) in
tar.gz format, or
in zip formats.
The archives contain the java sources as well as the jar file with
the compiled classes.
If you
cannot read these formats, e-mail
us and we can send the source via plain text e-mail to you.
This is stable beta code, so use it at your own risk. The code is Open Source (GPL).
- (BETA TEST) (September 15, 1999) The MDB is working on the new
machine, and I've added a beta test dir so you can sample one of the features
that the new version will have: producing plots of metal-ligand distances and
of ligand patterns for a give metal and coordination number. Go to the
Histogram Plot (beta version) page to play with it.
[ Note: the data being used is from the old version of the MDB, and
corresponds to the data in the PDB from the September 1998 release. Use the
results with caution. -- JMC ]
- September 10, 1999 - Moved the MDB to a new machine. So far it
seems to be working fine. This is the first step in the process of testing a
new release of the MDB that will contain more information a several new
querying interfaces.
- April 16, 1999 - Updated the advanced search forms to allow for more
inclusive search terms.
- April 02, 1999 - If you want to see the source for our PHP scripts, see the FAQ entry showing you how to do
that.
- We are also the US Mirror of the PROMISE site (from the University of Leeds).
-
(Feb. 12, 1999): After a period of beta-testing, the new release (1.3) of the MDB is up and
running.
Changes:
- Search interface additions/updates:
- Added new serch interface ("Advanced Queries") that allows
more complex search of the MDB. Three forms are offered:
- One that searches using PDB ids
- A simplified form similar to the one included in the
interactive search interface (i.e. the one containing the viewer
applet)
- A more complex form that allows more interesting searches to be
made on the MDB.
Look for more info in the "Advanced Queries" page.
- Modified the navigation, layout and options in the interactive search
interface for both the "Raw" and the "Edited" databases
- Back-end (Query processing, Database, Site documents) changes:
- Minor corrections in the r-values, resolution and description of the
metalloprotein entries to reflect the revisions up to January, 1998.
- Optimization of complex queries parsing to improve response.
- Allow searching on deposition/revision dates, and other numeric fields
by using a complete range syntaxis.
- Modified the whole site to support SSI and on-the-fly generation of
content, to make extensions and modifications simpler.
-
(Dec. 04, 1998): The new release (1.2b) of the MDB is up and
running. The main
changes have been in the interface to the raw database:
- It is now possible to indicate the maximum number of hits to return.
- Words in the authors names can be used to restrict the search.
- A series of "canned" extra options that allow a more complex search. Click
on the [More...] button in the search form to access the options. These
options will let you require that:
- the site contains at least one water as ligand
- the site does not contain any nucleic acid as ligand
- the metal-ligand distance is less or equal to 3 Â
- the PDB containing the site has been revised in the last 2 years
(1997-1998).
- A "remote-viewer" interface has
been implemented as a way for people to refer to sites in particular
metalloproteins. Select the links above for more information.
The pages in this site are being updated also to reflect the changes in the
MDB. This is a stable beta release and we expect that the final release will
be up soon.
-
(Oct. 13, 1998), Release of the new version of the MDB (Rel. 1.1).
The main changes in this release are:
- The "raw" database is now in SQL format (mSQL as database engine)
- The "raw" DB now contains information from all the released PDBs as of
September 15, 1998.
- We are using PHP3 to perform the searches, which combined with the
mSQL server gives us better performance, and the possibility of more complex
queries.
- IMPORTANT: in the new search interface you have the option of
requesting to be shown all the hits found, if you do not check that box
the search will default to showing the first 30 results as ordered by
their respective pdb code.
- If you do not want to search on Resolution or R-value, input "NULL" in the
respective boxes.
We have tested in-house this new release, but bugs have a way of creeping out
when you are not looking, so we will appreciate your input if you find one.
To help us debug, the queries submitted are being kept as SQL commands.
Also, the FAQ page has been updated to include
information on how to reference the MDB, and the URL's to use.
Pre-release 1.1 - NOTES: -- JMC
- Oct. 13, 1998
- End of second round of in-house testing of the new version of the MDB
(Release 1.1)
It took a little longer than planned, but now we have a
working and stable (hopefully) SQL-based database, which allows more complex
and flexible searches
- Sept. 28, 1998
- The filesystem problems have been (hopefully) fixed. Now we are generating the
files for what will be release 1.1 of the MDB.
We are in the process of re-indexing the whole PDB distribution (including
updates up to Sept. 15, 1998), and will be replacing the back-end CGI and database
engine (using PHP3 and mSQL) over the following week or two.
- Sept. 27, 1998
- We have been experiencing some filesystem problems lately. This server may be
unavailable on Monday (09/28/98) while we fix them. Our apologies to
those who had experienced errors while submitting queries.
|
|