package SBEAMS::PeptideAtlas::Tables; ############################################################################### # Program : SBEAMS::PeptideAtlas::Tables # Author : Eric Deutsch # $Id$ # # Description : This is part of the SBEAMS::PeptideAtlas module which provides # a level of abstraction to the database tables. # ############################################################################### use strict; use SBEAMS::Connection::Settings; use vars qw(@ISA @EXPORT $TB_ORGANISM $TBBL_POLYMER_TYPE $TBAT_BIOSEQUENCE_SET $TBAT_DBXREF $TBAT_BIOSEQUENCE $TBAT_BIOSEQUENCE_PROPERTY_SET $TBAT_QUERY_OPTION $TBAT_ATLAS_BUILD $TBAT_DEFAULT_ATLAS_BUILD $TBAT_ATLAS_SEARCH_BATCH $TBAT_SAMPLE $TBAT_ATLAS_BUILD_SAMPLE $TBAT_ATLAS_BUILD_SEARCH_BATCH $TBAT_PEPTIDE $TBAT_PEPTIDE_INSTANCE $TBAT_PEPTIDE_INSTANCE_SAMPLE $TBAT_PEPTIDE_INSTANCE_SEARCH_BATCH $TBAT_MODIFIED_PEPTIDE_INSTANCE $TBAT_MODIFIED_PEPTIDE_INSTANCE_SAMPLE $TBAT_MODIFIED_PEPTIDE_INSTANCE_SEARCH_BATCH $TBAT_PEPTIDE_MAPPING $TBAT_PUBLICATION $TBAT_BIOSEQUENCE_ANNOTATED_GENE $TBAT_BIOSEQUENCE_ANNOTATION $TBAT_SAMPLE_PUBLICATION $TBAT_IPI_VERSION $TBAT_IPI_XREFS $TBAT_IPI_DATA $TBAT_CELLULAR_LOCATION $TBAT_GLYCO_SITE $TBAT_IDENTIFIED_PEPTIDE $TBAT_PREDICTED_PEPTIDE $TBAT_PEPTIDE_TO_TISSUE $TBAT_TISSUE_TYPE $TBAT_GLYCO_SAMPLE $TBAT_IDENTIFIED_TO_IPI $TBAT_SYNTHESIZED_PEPTIDE $TBAT_SPECTRA_DESCRIPTION_SET $TBAT_ATLAS_SEARCH_BATCH_PARAMETER $TBAT_ATLAS_SEARCH_BATCH_PARAMETER_SET $TBAT_SEARCH_KEY $TBAT_NIST_LIBRARY $TBAT_NIST_LIBRARY_SPECTRUM $TBAT_NIST_LIBRARY_SPECTRUM_PEAK $TBAT_NIST_LIBRARY_SPECTRUM_COMMENT $TBAT_NIST_SPECTRUM_TYPE $TBAT_SPECTRUM_IDENTIFICATION $TBAT_SPECTRUM $TBAT_SPECTRUM_PEAK ); require Exporter; @ISA = qw (Exporter); @EXPORT = qw ( $TB_ORGANISM $TBBL_POLYMER_TYPE $TBAT_BIOSEQUENCE_SET $TBAT_DBXREF $TBAT_BIOSEQUENCE $TBAT_BIOSEQUENCE_PROPERTY_SET $TBAT_QUERY_OPTION $TBAT_ATLAS_BUILD $TBAT_DEFAULT_ATLAS_BUILD $TBAT_ATLAS_SEARCH_BATCH $TBAT_SAMPLE $TBAT_ATLAS_BUILD_SAMPLE $TBAT_ATLAS_BUILD_SEARCH_BATCH $TBAT_PEPTIDE $TBAT_PEPTIDE_INSTANCE $TBAT_PEPTIDE_INSTANCE_SAMPLE $TBAT_PEPTIDE_INSTANCE_SEARCH_BATCH $TBAT_MODIFIED_PEPTIDE_INSTANCE $TBAT_ATLAS_SEARCH_BATCH $TBAT_SAMPLE $TBAT_ATLAS_BUILD_SAMPLE $TBAT_ATLAS_BUILD_SEARCH_BATCH $TBAT_PEPTIDE $TBAT_PEPTIDE_INSTANCE $TBAT_PEPTIDE_INSTANCE_SAMPLE $TBAT_PEPTIDE_INSTANCE_SEARCH_BATCH $TBAT_MODIFIED_PEPTIDE_INSTANCE $TBAT_MODIFIED_PEPTIDE_INSTANCE_SAMPLE $TBAT_MODIFIED_PEPTIDE_INSTANCE_SEARCH_BATCH $TBAT_PEPTIDE_MAPPING $TBAT_PUBLICATION $TBAT_BIOSEQUENCE_ANNOTATED_GENE $TBAT_BIOSEQUENCE_ANNOTATION $TBAT_SAMPLE_PUBLICATION $TBAT_IPI_VERSION $TBAT_IPI_XREFS $TBAT_IPI_DATA $TBAT_CELLULAR_LOCATION $TBAT_GLYCO_SITE $TBAT_IDENTIFIED_PEPTIDE $TBAT_PREDICTED_PEPTIDE $TBAT_PEPTIDE_TO_TISSUE $TBAT_TISSUE_TYPE $TBAT_GLYCO_SAMPLE $TBAT_IDENTIFIED_TO_IPI $TBAT_SYNTHESIZED_PEPTIDE $TBAT_SPECTRA_DESCRIPTION_SET $TBAT_ATLAS_SEARCH_BATCH_PARAMETER $TBAT_ATLAS_SEARCH_BATCH_PARAMETER_SET $TBAT_SEARCH_KEY $TBAT_NIST_LIBRARY $TBAT_NIST_LIBRARY_SPECTRUM $TBAT_NIST_LIBRARY_SPECTRUM_PEAK $TBAT_NIST_LIBRARY_SPECTRUM_COMMENT $TBAT_NIST_SPECTRUM_TYPE $TBAT_SPECTRUM_IDENTIFICATION $TBAT_SPECTRUM $TBAT_SPECTRUM_PEAK ); #### Get the appropriate database prefixes for the SBEAMS core and this module my $core = $DBPREFIX{Core}; my $mod = $DBPREFIX{PeptideAtlas}; my $glycomod = $DBPREFIX{GlycoPeptide} || $DBPREFIX{PeptideAtlas}; my $BioLink = $DBPREFIX{BioLink}; $TB_ORGANISM = "${core}organism"; $TBBL_POLYMER_TYPE = "${BioLink}polymer_type"; $TBAT_BIOSEQUENCE_SET = "${mod}biosequence_set"; $TBAT_DBXREF = "${BioLink}dbxref"; $TBAT_BIOSEQUENCE = "${mod}biosequence"; $TBAT_BIOSEQUENCE_PROPERTY_SET = "${mod}biosequence_property_set"; $TBAT_QUERY_OPTION = "${mod}query_option"; $TBAT_ATLAS_BUILD = "${mod}atlas_build"; $TBAT_DEFAULT_ATLAS_BUILD = "${mod}default_atlas_build"; $TBAT_ATLAS_SEARCH_BATCH = "${mod}atlas_search_batch"; $TBAT_SAMPLE = "${mod}sample"; $TBAT_ATLAS_BUILD_SAMPLE = "${mod}atlas_build_sample"; $TBAT_ATLAS_BUILD_SEARCH_BATCH = "${mod}atlas_build_search_batch"; $TBAT_PEPTIDE = "${mod}peptide"; $TBAT_PEPTIDE_INSTANCE = "${mod}peptide_instance"; $TBAT_PEPTIDE_INSTANCE_SAMPLE = "${mod}peptide_instance_sample"; $TBAT_PEPTIDE_INSTANCE_SEARCH_BATCH = "${mod}peptide_instance_search_batch"; $TBAT_MODIFIED_PEPTIDE_INSTANCE = "${mod}modified_peptide_instance"; $TBAT_MODIFIED_PEPTIDE_INSTANCE_SAMPLE = "${mod}modified_peptide_instance_sample"; $TBAT_MODIFIED_PEPTIDE_INSTANCE_SEARCH_BATCH = "${mod}modified_peptide_instance_search_batch"; $TBAT_PEPTIDE_MAPPING = "${mod}peptide_mapping"; $TBAT_PUBLICATION = "${mod}publication"; $TBAT_BIOSEQUENCE_ANNOTATED_GENE = "${mod}biosequence_annotated_gene"; $TBAT_BIOSEQUENCE_ANNOTATION = "${mod}biosequence_annotation"; $TBAT_SAMPLE = "${mod}sample"; $TBAT_SAMPLE_PUBLICATION = "${mod}sample_publication"; $TBAT_IPI_VERSION = "${glycomod}ipi_version"; $TBAT_IPI_XREFS = "${glycomod}ipi_xrefs"; $TBAT_IPI_DATA = "${glycomod}ipi_data"; $TBAT_CELLULAR_LOCATION = "${glycomod}cellular_location"; $TBAT_GLYCO_SITE = "${glycomod}glyco_site"; $TBAT_IDENTIFIED_PEPTIDE = "${glycomod}identified_peptide"; $TBAT_PREDICTED_PEPTIDE = "${glycomod}predicted_peptide"; $TBAT_PEPTIDE_TO_TISSUE = "${glycomod}peptide_to_tissue"; $TBAT_TISSUE_TYPE = "${glycomod}tissue_type"; $TBAT_IDENTIFIED_TO_IPI= "${glycomod}identified_to_ipi"; $TBAT_GLYCO_SAMPLE = "${glycomod}glyco_sample"; $TBAT_SYNTHESIZED_PEPTIDE = "${glycomod}synthesized_peptide"; $TBAT_SPECTRA_DESCRIPTION_SET = "${mod}spectra_description_set"; $TBAT_ATLAS_SEARCH_BATCH_PARAMETER = "${mod}atlas_search_batch_parameter"; $TBAT_ATLAS_SEARCH_BATCH_PARAMETER_SET = "${mod}atlas_search_batch_parameter_set"; $TBAT_SEARCH_KEY = "${mod}search_key"; $TBAT_NIST_LIBRARY = "${mod}NIST_library"; $TBAT_NIST_LIBRARY_SPECTRUM = "${mod}NIST_library_spectrum"; $TBAT_NIST_LIBRARY_SPECTRUM_PEAK = "${mod}NIST_library_spectrum_peak"; $TBAT_NIST_LIBRARY_SPECTRUM_COMMENT = "${mod}NIST_library_spectrum_comment"; $TBAT_NIST_SPECTRUM_TYPE = "${mod}NIST_spectrum_type"; $TBAT_SPECTRUM_IDENTIFICATION = "${mod}spectrum_identificaton"; $TBAT_SPECTRUM = "${mod}spectrum"; $TBAT_SPECTRUM_PEAK = "${mod}spectrum_peak";