FileMaker UniGene Database Release

The current release contains two FileMaker Database templates (Built under FileMaker Pro 4.0 under Mac environment) and two flat files to be imported into FileMaker database. They are:

FileName Type Description
CloneID_to_UG FileMaker template An empty database for IMAGE CloneID map
cloneid_to_unigene.txt text file Database content for "CloneID to UG"
UG_lookup FileMaker template An empty database for UniGene Cluster
unigene_lookup.txt text file Database content for "UGlookup"

Filemaker database templates for both Mac and PC are provided. The text files are available for both Mac and PC platform. We also provide a compressed version for Mac users for fast downloading. The flat text files will be update periodically depending on the UniGene release. The UniGene Build number and the date for the current update is listed under the title "Basic Databases".

cloneid_to_unigene.txt is created solely from the UniGene downloadable files. The database is created for people who would like to know UniGene cluster ID or GenBank Accession ID given an IMAGE clone ID. Since each clone ID is not uniquely assigned to a single UniGene cluster, and given the knowledge that all sequence-verified clones are confirmed from their 3' end, UniGene cluster IDs corresponding to a given IMAGE clone ID is arranged such that the 3' end sequence will be the first, then 5' end, and then sequences with no end's designation.

unigene_lookup.txt is created from UniGene downloadable files and GeneMap 99 downloadable files. Each UniGene cluster is mapped through its marker position, and a gipomap entry is specially designed solely for the purpose of NHGRI GIPO (Gene-In-Plate-Order) format. The gipomap is a condensed version of radiation mapping position, and only GB4 panel is used for gipomap.

The databases were designed for following purposes:

  1. Making GIPO file (for gene name, cytogenetic position, radiation mapping position, etc), and some other microarray design purpose
  2. clone ID conversion to UG ID, GenBank Accession ID
  3. current clone information for final data integration

In short, the databases are used when individual clone lookup through web interface become tedious job. Any creative uses of these databases are highly encouraged.

 

Download

use your web browser to download all templates and text files. For Mac user, BinHex files (.hqx) can be decoded by StuffIt Expander (usually done automatically by the web browser). The Unix compression files (.Z) has to be decompressed by MacCompress3.2. (Note: StuffIt Expander does not work properly, even though it seems to recognize the format and decompress it successfully, but not correctly!)

For other platforms, you may download the straight text file.

 

Database creation

Warning: It may take more than one hour to import all data into the database on an Apple G3 machine. Please close all other applications and turn off screen-saver program before you import the database. You need at least 500 MB free disk space before you start downloading (the combined downloaded data files take about 100M and the final databases take about 300 MB).

To create UG lookup database

  1. Double click the FileMaker file "UG lookup". The default layout is here.
  2. Select Import/Export from File menu,
  3. Navigate to the location when the text file unigene_lookup.txt is stored, and then select it,
  4. Each field in FileMaker Pro is already pre-aligned for the data to be imported. No further alignment is necessary. Click OK button and wait till the end of importing.

The first cluster record is shown here.

To create "CloneID to UG" database, repeat the step 1) to 4) by using the database template "CloneID to UG" and the text file cloneid_to_unigene.txt.

Enjoy the web-less freedom.

Comments/Requests to Yidong Chen, and Anthony Masiello

Updated: 11/24/1999