export.topTable: Export a topTable, or a list of top tables to an excel file....

Description Usage Arguments Author(s)

Description

The first worksheet will be the summary, and subsequent worksheets are for each top table supplied. Additional benefits:
- Limits the number of significant figures to digits correctly for the P and q values
- includes a Pcount column
- includes gene information which uses the ID column and rownames of annot object
- includes a few columns of coefficients, for eg if the group-means parameterisation is used, then the values of the coefficients (ie the value for each 'group') may be appropriate to export.

Usage

1
2
3
4
  export.topTable(tt, file, annot = NULL, fixFC = TRUE,
    Pcount = NULL, coefficients = NULL, fit = NULL,
    digits = 4, summary = TRUE, drop.Bstat = TRUE,
    adj.Pval.colname = "FDR", ...)

Arguments

tt

a topTable data.frame

file

the output file name

annot

the probe-level annotation object. rownames should be set to the probe ID, so tt$ID can match them

fixFC

fix the logFC to produce an absFC and direction columns

Pcount

an optional vector of Pcounts (ie how many times each probe was detected as present). Should be named so that tt$ID can match the probes

coefficients

an optional data.frame, of coefficients from the lmFit. You can use this arg to add custom columns to the topTable. eg the AvgExpr

fit

the lmFit object. Used to obtain the Standard error of each probe. using fit$stdev.unscaled * fit$sigma

digits

how many digits to round to?

summary

insert a worksheet into the excel workbook which contains a summary of the toptable

drop.Bstat

logical. If TRUE then the "B" column is not exported.

adj.Pval.colname

rather than "adj.P.Val", you can rename to column to "FDR", or "q", or similar.

...

additional arguments passed to write.xls

Author(s)

Mark Cowley


drmjc/microarrays documentation built on May 15, 2019, 2:26 p.m.