Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Overview

GREAT offers both global and per-table export options that enable export / download of table data.

Global Export

All data as .tsv

The "All data as .tsv" export is useful for further manipulation in a spreadsheet program (like Excel) or with a scripting language. It includes all GREAT statistics (i.e. both shown and hidden columns) along with the names of the region and gene hits for each term. Like the GREAT Programming Interface Batch mode, up to 500 rows are returned per ontology.

  • The current minimum and maximum annotation counts are used to calculate corrected p-values in the export.
  • Aside from annotation count, the export is not filtered (i.e. no p-value cutoff, minimum observed genes hit, or minimum fold enrichment filter).

Header

The header specifies the GREAT version number, the species assembly, and the regulatory domain parameters. It also includes internal documentation explaining the data in each column.

Data

The main data export is tab-delimited, including all GREAT statistics:

The order of data columns output in a whole genome background test is:

  1. ontology name
  2. term name / identifier
  3. term description
  4. binomial rank
  5. binomial p-value (uncorrected)
  6. binomial Bonferroni corrected p-value
  7. binomial FDR q-value
  8. region fold enrichment (k/(n*p))
  9. expected region hits (n*p)
  10. observed region hits (k)
  11. genome fraction (p)
  12. region set coverage (k/n)
  13. hypergeometric rank
  14. hypergeometric p-value (uncorrected)
  15. hypergeometric Bonferroni corrected p-value
  16. hypergeometric FDR q-value
  17. gene fold enrichment (k*N/(n*K))
  18. expected gene hits (n*K/N)
  19. observed gene hits (k)
  20. total genes, a.k.a "annotation count" (K)
  21. gene set coverage (k/n)
  22. term gene coverage (k/K)
  23. names of region hits
  24. names of gene hits

The order of data columns output in a foreground/background test is:

  1. ontology name
  2. term name / identifier
  3. term description
  4. rank
  5. p-value (uncorrected)
  6. Bonferroni corrected p-value
  7. FDR q-value
  8. region fold enrichment (k*N/(n*K))
  9. expected foreground region hits (n*K/N)
  10. observed foreground region hits (k)
  11. background region hits (K)
  12. foreground region set coverage (k/n)
  13. term foreground coverage (k/K)
  14. number of genes annotated with term hit by foreground regions
  15. number of genes annotated with term hit by background regions
  16. total number of genes in the genome annotated with the term
  17. names of foreground regions associated with one or more genes annotated with the term
  18. names of background regions associated with one or more genes annotated with the term
  19. names of genes annotated with the term hit by one or more foreground regions
  20. names of genes annotated with the term hit by one or more background regions

The footer lists the tested ontologies, the number of terms tested per ontology, and the minimum and maximum annotation counts for each ontology.

All shown data as HTML

The "All shown data as HTML" export option offers a clean, readable dump of the currently shown GREAT results. It is useful for preparing presentation and publication quality tables.

The rows and columns included in the

The new page also contains the information in the footer of the table. It can be used as-is, or edited with any HTML editor.

    • Shown table data as .tsv - This allows you to download a tab-delimited file containing the exact data currently shown in the table, with columns ordered as in the display. The file does not contain the information in the footer of the table. The file can be opened with most spreadsheet programs for further manipulation.

Per Table Export

  • No labels