- 1 OSCtable file format
- 1.1 Column header name nomenclature
- 1.2 Wrapping external file formats with OSCtable headers
- 1.3 File related metadata
- 2 Original OSCTable specification structure
OSCtable file format
The OSCTable is an open structure tab-separated text table format. Any tab-text file which can be loaded into a spreadsheet program like excel or into data analysis programs like R can be loaded into ZENBU using the OSCtable format (file extension .osc). Just like an excel file or most analysis related tab-text files, the oscfile uses the first line of the file as a header to describe the columns. The difference is that OSCTable uses a controlled nomenclature of header terms to control how the file is loaded and interpreted. What this means is that OSCTable allows for flexible column ordering, of a user specified number of columns.
ZENBU includes a rich set of header terms to be able to translate any tab-text table into .osc format and loaded. This column header name nomenclature will be described bellow.
Here is a simple example of adding an OSCTable header line to a bed6 file so that it can be loaded as an OSCTable file with a .osc file extension. In fact, internally this is how ZENBU translates bed files
eedb:chrom eedb:start.0base eedb:end eedb:name eedb:score eedb:strand chr1 67092175 67134971 NM_001276352 0 - chr1 201283451 201332993 NM_000299 0 + chr1 67092175 67134971 NM_001276351 0 - chr1 67092175 67134971 NR_075077 0 -
OSCtable is one of the main interchange formats for ZENBU. It allows all possible mapping of data into the ZENBU data model. Since the OSCtable specification is highly flexible, it was possible for the ZENBU OSCtable parser to have an extended vocabulary of metadata directives and column name spaces.
Column header name nomenclature
The fist non-commented line of the file is interpreted as the column-header line. This line is a requirement for OSCTable files because without it, it is not possible to translate the file.
core column name nomenclature
These represent the core types of columns that are usually found in genomic-location files which can be loaded into ZENBU. All are easily mapped onto the Feature. Currently ZENBU requires OSCTable files to specify genomic coordinate columns in order to load (chrom, start, end minimum requirement), but in a future release we will allow for non-genomic node and edge files to be specified with OSCTable and loaded.
- eedb:chrom -- chromosome name
- eedb:start.0base -- chromosome start in a 0base-exclusive coordinate system (like BED files)
- eedb:start.1base -- chromosome start in a 1base-inclusive coordinate system (like GFF files)
- eedb:end -- chromosome end location
- eedb:strand -- chromosome strand
- eedb:name -- the name of the Feature
- exp.YYY.ZZZ -- interpreted as expression value of datatype YYY for experiment named ZZZ. This will create the experiment source named ZZZ.
- exp.YYY -- interpreted as expression value of datatype YYY for the primary/default experiment of the file. This will not create additional experiments within the file.
- raw.ZZZ -- interpreted as expression value of datatype raw for experiment named ZZZ. This will create the experiment source named ZZZ.
- norm.ZZZ -- interpreted as expression value of datatype norm for experiment named ZZZ. This will create the experiment source named ZZZ.
While ZENBU uses a 1-based-inclusive coordinate space internally, it can automatically handle the conversion between coordinate spaces at load time and when exporting data out of the system. Please just specify the correct coordinate space for your file, there is no need to convert your files.
additional column name nomenclature
- eedb:fsrc_category -- causes creation of multiple FeatureSources from a single OSCtable file using the value of this column as different source categories
- eedb:score -- is stored in the Feature significance.
- eedb:bed_block_count -- are taken from the BED file specification.
- eedb:bed_block_sizes -- are taken from the BED file specification.
- eedb:bed_block_starts -- are taken from the BED file specification.
- eedb:bed_thickend -- are taken from the BED file specification.
- if eedb:bed_thickstart is not equal to start then the region from start to bed:thickStart is interpreted into a SubFeature of category 5utr
- if eedb:bed_thickend is not equal to end then the region from bed:thickEnd to end is interpreted into a SubFeature of category 3utr
- bed:itemRgb -- bed file style rgb color stored as Feature Metadata
- eedb:genome -- if specified in a column, this allows data from multiple-genomes within the same OSCtable file
- eedb:sam_flag -- ZENBU parses strand out of the SAM file flag column.
- eedb:sam_cigar -- can be parsed into chrom_end and subfeatures
- eedb:ctg_cigar -- a ZENBU specific extension of the cigar concept allowing multiple overlapping subfeature layers with different FeatureSource categories.
- example eedb:ctg_cigar -- 3utr:4738N415M,5utr:375M,block:404M1628N769M1377N977M
- gff:attributes -- GFF2/GFF3 style tag=value; data with extended support for feature/subfeature linking
- gff:source -- GFF source column. Interpreted as metadata
- gff:frame -- GFF frame column. Interpreted as metadata
- eedb:demux_fsrc -- load time demultiplexing of FeatureSource based on value of this column
- eedb:demux_exp -- load time demultiplexing of Experiment based on value of this column
Any column with an unknown name is mapped into the Metadata of the Feature. The column name becomes the key of the metadata. For example you could use the column name barcode for a column and since that is not part of the controlled nomenclature, it will be interpreted as metadata and the values in that column will be added to the row feature as barcode=xxxxxx.
- edgef1.AAA -- for edge files, this is the metadata key from feature_source1 used for linking to the edges, use edgef1.name is linking to name
- edgef2.BBB -- for edge files, this is the metadata key from feature_source2 used for linking to the edges, use edgef2.name is linking to name
- ewt.ZZZ -- for adding numerical edge_weights to the edges. Similar syntax to exp.ZZZ
genomic coordinate or expression columns are ignore with edge files. Metadata columns are interpreted in the same way as genomic feature OSCFiles.
To load edge .osc files into ZENBU, use the web interface, select the .osc file and then select "non-genomic" for the genome/assembly. This will then show a radio selector for non-genomic nodes or edges. Selecting edge will bring up an interface to search for the datasources for linking the edgef1.AAA and edgef2.BBB to. It is possible to select either different sources for F1 and F2 or you can select the same source twice.
Aliased column names
Several column names have aliases to other column name spaces
- name -- same as eedb:name
- ID -- same as eedb:name
- score -- same as eedb:score
- chrom -- same as eedb:chrom
- chromosome -- same as eedb:chrom
- start -- same as eedb:start.0base
- start.0base -- same as eedb:start.0base
- start.1base -- same as eedb:start.1base
- end -- same as eedb:end'
- strand -- same as eedb:strand
- eedb:mapcount -- same as mapcount
- eedb:significance -- same as eedb:score
The OSCtable allows for easy wrapping of any tab-texted file into an OSCtable by simply pre-pending a header with the appropriate column names. But sometimes these original files contain columns which one might not really need. To simplify the process of loading, ZENBU added a special column-name
- ignore.xxxx -- ignore this column, where xxxx would be the original column name
If a column is labeled as such, on loading this column will be stripped from the data file and thrown away. This can simplify the process for bioinformatician and avoid un-needed data-scripting to munge data prior to loading.
Wrapping external file formats with OSCtable headers
With the extended vocabulary of the ZENBU OSCtable parser, it is possible to wrap external file formats very easily with an OSCtable header and load them into ZENBU. In fact the ZENBU upload support for BED, GTF and GFF are done through wrapping predefined OSCtable column headers onto these files.
Here is the column header line to wrap a BED file
eedb:chrom eedb:start.0base eedb:end eedb:name eedb:score eedb:strand eedb:bed_thickstart eedb:bed_thickend bed:itemRgb eedb:bed_block_count eedb:bed_block_sizes eedb:bed_block_starts
eedb:chrom eedb:start.0base eedb:end eedb:name eedb:score eedb:strand
eedb:chrom eedb:start.0base eedb:end
eedb:chrom gff:source eedb:fsrc_category eedb:start.1base eedb:end eedb:score eedb:strand gff:frame gff:attributes
The gff:attributes column has a complete ZENBU parser attached to it. The parser can interpret this column in either the older GFF/GTF tag<space>value format or the GFF2/GFF3 style tag=value format. The gff:attributes column can be used to store feature/subfeature relationships(GFF3 specification), the name of the feature(GFF2 & GFF3), and all variable metadata of the Feature (original GFF specification)
gff:source and gff:frame are currently simply stored as Metadata.
Here is the column header line to wrap a SAM file
eedb:name eedb:sam_flag eedb:chrom eedb:start.1base eedb:score eedb:sam_cigar sam:mrnm sam:mpos sam:isize eedb:seqread sam:qual eedb:sam_opt
ENCODE NarrowPeak oscheader
ENCODE narrowPeak (or Point-Source) format is used to provide called peaks of signal enrichment based on pooled, normalized (interpreted) data. It is a BED6+4 format.
- chrom - Name of the chromosome (or contig, scaffold, etc.).
- chromStart - The starting position of the feature in the chromosome or scaffold. The first base in a chromosome is numbered 0.
- chromEnd - The ending position of the feature in the chromosome or scaffold. The chromEnd base is not included in the display of the feature. For example, the first 100 bases of a chromosome are defined as chromStart=0, chromEnd=100, and span the bases numbered 0-99.
- name - Name given to a region (preferably unique). Use '.' if no name is assigned.
- score - Indicates how dark the peak will be displayed in the browser (0-1000). If all scores were '0' when the data were submitted to the DCC, the DCC assigned scores 1-1000 based on signal value. Ideally the average signalValue per base spread is between 100-1000.
- strand - +/- to denote strand or orientation (whenever applicable). Use '.' if no orientation is assigned.
- signalValue - Measurement of overall (usually, average) enrichment for the region.
- pValue - Measurement of statistical significance (-log10). Use -1 if no pValue is assigned.
- qValue - Measurement of statistical significance using false discovery rate (-log10). Use -1 if no qValue is assigned.
- peak - Point-source called for this peak; 0-based offset from chromStart. Use -1 if no point-source called.
Here is an example of narrowPeak data file:
track type=narrowPeak visibility=3 db=hg19 name="nPk" description="ENCODE narrowPeak Example" browser position chr1:9356000-9365000 chr1 9356548 9356648 . 0 . 182 5.0945 -1 50 chr1 9358722 9358822 . 0 . 91 4.6052 -1 40 chr1 9361082 9361182 . 0 . 182 9.2103 -1 75
To wrap ENCODE narrowPeak (or Regions) files with an OSCtable header and load them into ZENBU, the OSC header should be
eedb:chrom eedb:start.0base eedb:end eedb:name eedb:score eedb:strand exp.signal exp.pvalue exp.qvalue exp.peak chr1 9356548 9356648 . 0 . 182 5.0945 -1 50 chr1 9358722 9358822 . 0 . 91 4.6052 -1 40 chr1 9361082 9361182 . 0 . 182 9.2103 -1 75
Upon data loading, leave the "display name" textbox empty so has to not overwrite the one available from the OSCtable (and keep the featureSource name and ExpreimentSource names in sync)
Any line in the file can start with a # character to represent a comment. These lines are ignored by the ZENBU OSCTable parser, but can be useful for making your data file more human readable. In addition the original OSCTable specification included a special set of ## comment lines to be included prior to the column-header line.
None of these ## lines are required by the ZENBU OSCTable parser, but can be useful for describing your datafiles. While the official OSCtable specification include mandatory metadata elements, the ZENBU OSCtable parser relaxes this requirement. All ## metadata lines are parsed as optional metadata. Even ##ColumnVariable directives are consider as optional metadata. The only requirement for a valid OSCtable for ZENBU is the column header line.
The primary ## line syntax which can be parsed by ZENBU as optional metadata are:
##ParameterValue[key] = value
##ColumnVariable[col_name] = description
##ExperimentMetadata[experiment-name][key] = value
##key = value
The original OSCtable specification works very well with single experiment data files, but does not provide enough fine control of assigning metadata in a multi-experiment data file. To alleviate this, ZENBU added an additional metadata directive to the OSCtable specification
- ##ExperimentMetadata[experiment-name][key] = value
experiment-name is the same as the ZZZ in the expression column header descriptions. By referencing to the experiment-name it is possible to have the same experiment used in multiple columns with different datatypes.
Example (please note that the text is wrapped below for display)
##ParameterValue[filetype] = osc ##ParameterValue[genome] = mm9 ##ColumnVariable[eedb:chrom] = chromosome name ##ColumnVariable[eedb:start.0base] = chromosome start in 0base coordinate system ##ColumnVariable[eedb:end] = chromosome end ##ColumnVariable[eedb:strand] = chromosome strand ##ColumnVariable[eedb:score] = score or significance of the feature ##ColumnVariable[exp.tagcount.Mouse_Embryoid_Body_RNAseq_exonic] = tagcount Mouse_Embryoid_Body_RNAseq_exonic ##ExperimentMetadata[Mouse_Embryoid_Body_RNAseq_exonic][eedb:display_name] = Mouse_Embryoid_Body_RNAseq_exonic ##ExperimentMetadata[Mouse_Embryoid_Body_RNAseq_exonic][eedb:platform] = SQRL_RNAseq ##ExperimentMetadata[Mouse_Embryoid_Body_RNAseq_exonic][description] = This is the exon junction signal for RNAseq of Mouse Embryoid body cells after 4 days of differentiation to the 'primitive streak stage' (see PMID:17286599 , and should contain expression of brachyury, mixl1, tbx6, and flk1) carried out at the IMB on Applied Biosystems SOLiD system (PMID: 18516046). Mouse strain: SV129. Mapping: published version. ##ExperimentMetadata[Mouse_Embryoid_Body_RNAseq_exonic][strain] = SV129 ##ExperimentMetadata[Mouse_Embryoid_Body_RNAseq_exonic][tissue] = Mouse Embryoid body ##ColumnVariable[exp.tagcount.Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal] = tagcount Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal ##ExperimentMetadata[Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal][eedb:display_name] = Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal ##ExperimentMetadata[Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal][eedb:platform] = SQRL_RNAseq ##ExperimentMetadata[Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal][description] = Description: This is the exonic signal for RNAseq of Mouse Embryonic Stem Cells carried out at the IMB on Applied Biosystems SOLiD system (PMID: 18516046). Mouse strain: SV129. Mapping: published version ##ExperimentMetadata[Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal][strain] = SV129 ##ExperimentMetadata[Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal][tissue] = Mouse Embryonic Stem Cells eedb:chrom eedb:start.0base eedb:end eedb:name eedb:score eedb:strand exp.tagcount.Mouse_Embryoid_Body_RNAseq_exonic exp.tagcount.Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal exp.tpm.Mouse_Embryoid_Body_RNAseq_exonic exp.tpm.Mouse_Embryonic_Stem_Cell_RNAseq_exonic_signal chr7 52253690 52253691 block_chr7:52253691..52253691+ 186.00 + 84.00 102.00 8.40 10.20 chr7 52253691 52253692 block_chr7:52253692..52253692+ 184.00 + 83.00 101.00 8.30 10.10 chr7 52253692 52253693 block_chr7:52253693..52253693+ 185.00 + 83.00 102.00 8.30 10.20 chr7 52253693 52253694 block_chr7:52253694..52253694+ 180.00 + 81.00 99.00 8.10 9.90 chr7 52253694 52253695 block_chr7:52253695..52253695+ 174.00 + 77.00 97.00 7.70 9.70
Original OSCTable specification structure
The original OSCTable format specification was created in the FANTOM4 project for distribution of our datafiles. Since there were no OSCTable parsers at the time, this specification was more for describing how to write your own parser. As the ZENBU OSCTable parser evolved, many aspects of the original specification have been changed. Basically the ZENBU OSCTable parser relaxed all the requirements for the ## header metadata and extended the nomenclature vocabulary of column names. This means that the ZENBU OSCTable parser is backward compatible with any file created in the original specification, but that the current specification, described above, is much more comprehensive than this original working draft specification. The original specification file can be found here http://fantom.gsc.riken.jp/download/Tables/doc/090703-osctable.rtf
The following documentation remains here for historical purposes.
- A simple tabdelimited text file.
- Column order is flexible
- Lines starting with '#' are comments.
- Lines starting with '##' are attributes or metadata of the table. (See Metadata section below)
- The first line after the comments/metadata (see below) is a header line, which indicate column names of the table.
- All the comment and attribute lines should appear above the header line
- The first column should describe a 'key' (unique in many cases, but not necessarily) of the data, and the column name should be 'id'
- If a cell needs to include multiple values, comma(',') is recommended to be used as a separator.
- All the columns should be described in Metadata (See 'Metadata' section below)
File Metadata ('##' lines)
The basic structure is '##qualifier = value'.
Required metadata: FileFormat, Date, ProtocolREF, ColumnVariable, ContactName, ContactEmail
'genome_assembly' for parameter value is required, when using
- FileFormat -- describes file format of this file.
##FileFormat = OSCtable1.1
- Date -- describes the date when the data file is generated
##Date = 20090602
- ProtocolREF -- describes the protocol used to generate the data file.
##ProtocolREF = CAGEmappingv1.0
- ColumnVariable -- describes ALL the columns used in the data file
##ColumnVariable[start] = this is a start position of the genomic coordinate
##ColumnVariable[end] = this is a stop position of the genomic coordinate
##ColumnVariable[norm.THP10h] = this is TPM normalized value with 10h
##ColumnVariable[entrez_gene_id] = Entrez gene ID, which is assigned to the cluster
- ContactName -- describes the contact name about the data file.
##ContactName = Hideya Kawaji
- ContactEmail -- describes the contact address about the data file
##ContactEmail = firstname.lastname@example.org
- InputFile -- describes the file(s) used to generate the data file
##InputFile = lane1.fa
##InputFile = lane2.fa
- ParameterValue -- describes the parameter(s) used to generate the data file in the protocol. The parameter(s) should be consistent with the protocol description
##ParameterValue[alignment_program] = BWA
##ParameterValue[aligment_program_version] = 1.3.5
##ParameterValue[UCSC_gene_tracks] = RefSeq
##ParameterValue[UCSC_gene_tracks] = ENSEMBL transcript
- NameSpace -- describes the name space for the column names. See below (NameSpace)
Column Name Spaces
- A set of column names (and parameters) to be used for a specific purpose or context.
- The same column names with the same name space are recognized as the same (equivalent) meaning.
- Supported name space: genomic_coordinate, expression
- column names are: chrom, start.0base, start.1base, end, strand
- parameter value: genome_assembly
- chrom: chromosome name used in the genome assembly. For example, chr1, chr2, chr3, ... chrM for the UCSC hg18 genome assembly.
- start.0base: start position (bp) on the chromosome in 0start coordinate system (BED, PSL, BLAT, exonerate, and nexAlign style)
- start.1base: start position (bp) on the chromosome in 1start coordinate system (conventional coordinate system; adopted in GFF as well)
- end: end position (bp) on the chromosome
- strand: strand on the chromosome; optional
- All of the above columns are not necessarily required. For example, start.0base would not be required if you have start.1base, and strand would not be required if the annotation do not have strand distinction
- 'genome_assembly' for parameter value is required.
- generic expression tags -- column names follow the form : exp.YYY.ZZZ, raw.ZZZ, norm.ZZZ, or mapcount
- exp.YYY.ZZZ is the general form for describing an expression column. YYY labels the DataType of the expression and should not include any dot (.) characters. ZZZ indicates the name of the Experiment source of the expression.
- raw.ZZZ is shorthand for exp.raw.ZZZ where raw is a datatype for un-processed values of expression such as raw_counts and raw signal intensities.
- norm.ZZZ is shorthand for exp.norm.ZZZ where norm is a datatype for normalized value.
- mapcount specifies the number of locations where this element has been mapped onto the genome.