Workflow: Generating Quantitative Genomic Feature table for VizDeck

This workflow how to take a table quantitative information on a genomic feature and bring into VizDeck. Specifically a gff format table with DNA methylation information will be joing with functional and gene characteristic information.

In this instance I will start with the query first:

SELECT 
seqname,
start as CpG_pos,
CAST(start AS FLOAT(1))/(mRNA.column5 - mRNA.column4)*100 as Rel_CpG_pos,
score as methratio,
term,
GOSlim_bin,
aspect,
mRNA.column5 - mRNA.column4 as mRNA_length 

FROM [sr320@washington.edu].[BiGill_methratio_Gene_Genomic_GFF] gff
left join [sr320@washington.edu].[qDOD_Cgigas_GO_GOslim] des
​on gff.seqname = des.CGI_ID
left join [sr320@washington.edu].[oyster_v9_mRNA GFF] mRNA
on gff.seqname = mRNA.Column9

Order by mRNA_length desc

Explanation: The gff was joined with des (to get gene function) and mRNA to indirectly obtain gene length.

Below are snapshots and links to the tables.

---

---

---

---

---

---

###Resulting table

---

---