Changes in version 3.2-0 (2016-12-21) o Add mRNArefseqByTaxID to get all refseq IDs given a Taxonomy ID Changes in version 3.1-8 (2015-06-30) o export annotateAnyIDs to annotate any types of feature identifiers supported by GTI Changes in version 3.1-7 (2015-01-15) o hasOracle uses now the 'requireNamespace' function to test whether ROracle can be loaded or not. This is more robust than testing the binary of sqlplus. o No Depends packages any more. Both ribiosUtils and DBI are imported from. Changes in version 3.1-6 (2014-10-10) o Java heap size is set to 4g before library loading if RJDBC has to be used. This will eliminate memory error messages due to insufficient heap size. Changes in version 3.1-5 (2014-07-08) o Add annotatemRNAs to translate mRNA accession numbers to GeneIDs. o Todo: there are redundant codes in annotateProbesets.R, with regard to multiple annotation methods. They should be cleaned-up. Changes in version 3.1-4 (2014-04-02) o ribiosCon tests whether RJDBC exists before it tries the JDBC option o Add importFrom DBI and ribiosUtils o Makefile: the R-devel default location is changed to point to the version that runs both on montale and bedastats Changes in version 3.1-3 (2013-11-14) o fillOneColTmpTbl:empty values are handled correctly. Changes in version 3.1-2 (2013-10-16) o Debug: in .onAttach, the ROracle namespace is not attached when it has been attached before. It fixes a bug that ribiosAnnotation refuses to be loaded when the ROracle package has been loaded before Changes in version 3.1-1 (2013-10-11) o add annotateEnsembl to annotate ENSEMBL identifiers Changes in version 3.1-0 (2013-07-08) o annotateHumanOrthologs: if multiple human orthologs were found and when multiple orthologues are not required, the one with the smallest GeneID (as integer) will be reported as the orthologue. o Remove illuminaSnp function: the table has been deleted in the database. Changes in version 3.0-6 (2013-01-22) o annotateHumanOrthologs: the output data.frame puts shorter GeneSymbols in front of longer ones in case one ID is mapped to several items; useful for reducing mismatch rates in annotating orthologues. Changes in version 3.0-5 (2012-10-24) o annotateAnyID passes on the 'chip' option to annotateProbesets Changes in version 3.0-4 (2012-10-22) o Add scriptChiptypes and annotateAnyID to simply annotations in Rscripts Changes in version 3.0-3 (2012-10-03) o Add ribios_orthologizer.Rscript to convert identifiers (GeneID, GeneSymbol or probesets) from other organisms to human Changes in version 3.0-2 (2012-08-27) o Bug fix: annotateHumanOrthologs returns a data.frame of five columns (previous four), adding a column OrigTaxID holding the TaxID of querying GeneIDs. The column GeneID is fixed as 9606, the TaxID of human. o Add internal function annotateHumanOrthologsNoOrigTax to remove OrigTaxID column, used by internal functions to make orthologue mapping. Changes in version 3.0-1 (2012-08-22) o Bug fix: querydbTmpTbl works well with NA values. Remaining bug: if no valid identifiers are given, the function stops and reports error. Changes in version 3.0-0 (2012-07-26) o Substantial updates of querydb, querydbSelectIn and querydbTmpTbl to support annotating anywhere. o From this version, ribiosAnnotation does not strictly depend on the availability of Oracle client library. It can run anywhere with JDBC accessing Oracle data. Changes in version 2.0-1 (2012-07-16) o annotateProbesets: If the option 'chip' is not missing, 'gtiChipAnnotation' takes over the orthologue mapping task, which was missing in previous versions. Changes in version 2.0-0 (2012-06-20) o Substantial upgrades of following functions: annotateProbesets, annotateGeneIDs and annotateGeneSymbols o For probesets mapping, three functions are available for different scenarios: gtiChipAnnotation, annotateAnyProbeset, and guessChiptype o Consistently map probesets, GeneIDs and GeneSymbols to Orthologues o Add annotateHumanOrthologs to map any Entrez GeneID to human orthologues o Add querydbTmpTbl to fill temporary table with user inputs and perform JOIN actions. o Speed-up several functions o Next major release will make the package work both with ROracle or RJDBC. Changes in version 1.2-0 (2012-06-12) o annotateProbesets, annotateGeneIDs and annotateGeneSymbols are substantially improved: they use now GTI tables, and are able to map orthologues. o querydbSelectIn has been exported, and documented. o TODO: currently the password are saved in clear text. This should be encoded. Changes in version 1.1-0 (2012-03-22) o querydb and querydbSelectIn have been refactored. They now accept db, user and password as inputs to provide more flexibility for programmer. The change is however transparent to end users, they should not have to remember which database to connect to and what are authentication details. o TODO: currently the password are saved in clear text. This should be encoded. Changes in version 1.0-18 (2012-03-15) o Add humanOrthologs, humanUniqOrtholog, nonhumanOrthologs and nonhumanUniqOrtholog to get ortholog information from GTI Changes in version 1.0-17 (2012-02-21) o Add newconRED(), enabling query the bia database with permissions of the user 'red' (for example CNS NGS data) o Modify querydb in order to allow querying database with red Changes in version 1.0-16 (2012-02-13) o the ORA object assignment is done after exporting ORACLE.BASE and ORACLE.LIB, to adapt to the newest version (1.1-1) of ROracle package o the gtiChipAnnotation function does not break when no probeset was annotated (due to logical(0) before) Changes in version 1.0-15 (2012-02-10) o gtiChiptypes uses genome.CHIP_ARRAY_TYPES@bin table to report GTI-supported chip types. Comparing previous versions, the default behavior is not changing. By settign 'include.desc=TRUE', more details are returned, includeing Technology and Species. o gtiChipAnnotation uses genome.chip_probeset_gene and genome.GTI_GENES internally, in order to be 100% synchronized with GTI. The resulting data.frame keeps consistency, although the isSingleGeneID column is always set to TRUE since only uniquely mapped probesets are stored. Provisionally this column shall be removed in the future version. o We export the hapmapSnp and illuminaSnp functions thanks to Isabelle's help. They are able to query SNP annotation and genomic contexts with user input. Changes in version 1.0-14 (2012-02-07) o Add isGtiChiptype to check user input with GTI-supported chiptypes o Change the default order of 'db' in the querydb function to c("bia", "bin") o gtiChipAnnotation has been substantially refactored: that for queries <1000 items, the filtering is done by the IN syntax of SQL instead by R. Doing so saves much overhead of transfering large tables between SQL and R. A benchmark with random sampled GeneIDs (see codes in the test directory) showed a 5-10x better performance measured by the running time. o gtiChipAnnotation documentation has been correspondingly updated o ORACLE.IN.NMAX constant variable is exported: the maximum length of the vector in the IN query syntax o Add mappedProbesets to get all probesets that map to given Entrez GeneIDs. o We have solved the mysterious issue of example codes in the ribiosAnnotation package:by wrapping example codes with options(error=utils:recover) and options(error=NULL), the examples can be executed now in the check process without issuing error. Although we do not really know why this is the case, this information should be shared with all developers who have had similar problems. Changes in version 1.0-13 (2012-02-03) o Add querydb to make generic db queries o Add chrLen to query chromosome lengths in supported organisms Changes in version 1.0-12 (2012-02-02) o gtiTaxAnnotation returns MappedChr, CoordLeft, CoordRight and RevComp for chromosome-mapping information, by outer joining the genome.gti_gene_map_a@genome table o Internal: connection to the bia server ia authenticated by bi. o gtiChipAnnotation (and downstream annotateProbesets) uses 'bi.EG_GENE_INFO.OFFICIAL_SYMBOL' for GeneSymbol instead of 'bi.AFFYCHIP_XREF_LL.GN' Changes in version 1.0-11 (2012-02-01) o Add gtiTaxAnnotation.Rd to get annotations belonging to the given TaxonID. o Change newcon to newconBIA, add newconBIN to prepare for connection to the BIN server Changes in version 1.0-10 (2012-01-25) o annotateIDs sets the queried IDs in its column, which affects annotateProbesets, annotateGeneIDs and annotateGeneSymbols Changes in version 1.0-9 (2012-01-24) o Add annotateGeneIDs and annotateGeneSymbols to annotate GeneIDs/GeneSymbols in a similar fashion as that for probesets o annotateProbeIDs have been added as a synonym to annotateProbesets o Internally the core logic of annotateProbesets is refactored into \code{annotateIDs} to be shared by \code{annotateGeneIDs} and \code{annotateGeneSymbols}. o Add a Rscript to do annotation from command line: inst/Rscript/ribios_annotate.R o Add test bash file and test text files for ribios_annotate.Rscript Changes in version 1.0-8 (2012-01-06) o bioc2gti and gti2bioc support missing argument. If 'chipname' is left missing, the functions will print GTI/Bioc names of chip types supported by both GTI and Bioc. Changes in version 1.0-7 (2011-12-21) o Add join of bi.EG_GENE_INFO to gtiChipAnnotation, in order to get GeneNames Changes in version 1.0-6 (2011-12-20) o Following suggestions of Laura, the race prefix is changed into gti o Thanks for Stan's feedback: ORACLE_BASE and ORACLE_HOME environment variables are set in the .onLoad function o ORACLE_BASE is set when there is no environment variable, or the path pointed to by the variable does not contain the "client" subfolder. o ORACLE_HOME is set when there is no environment variable, or the path pointed to by the variable does not contain the "bin" subfolder. o To test the ribiosAnnotation in a free environment, use "exec env -i bash --norc". Changes in version 1.0-4 (2011-12-16) o Current functions have been renamed to better reflect their functions o raceChiptypes (aka raceChipnames) returns a list of supported chip types (in the form of character vector) o raceChipAnnotation provides all annotation information for a certain chip o annotateProbesets provides annotation information for queried probesets. o The version numbering system is now consistent with the R convention (x.y-z) Changes in version 1.0.3 (2011-12-15) o Only BIOS-specific functions have been kept in the new ribiosAnnotation package, other functions relying on Bioc annotation mechanisms have been moved to the ciocAnnotation package, which shall not be part of the ribios suite). o Functions are renamed in a consistent way, representing their functionality. The old names are deprecated.