Commits

Davide Cittaro committed ead42ca

added legend in excel export

  • Participants
  • Parent commits 2f36af3

Comments (0)

Files changed (1)

     col = openpyxl.cell.get_column_letter(1 + idx)
     ws.cell("%s%s" % (col, row)).value = f
 
+#write legend
 ws = wb.create_sheet()
+ws.title = "Legend"
+ws.cell("A1").value = 'CHROM'
+ws.cell("A2").value = 'POS'
+ws.cell("A3").value = 'ID'
+ws.cell("A4").value = 'REF'
+ws.cell("A5").value = 'ALT'
+ws.cell("A6").value = 'QUAL'
+ws.cell("A7").value = 'FILTER'
+ws.cell("B1").value = 'Chromosome'
+ws.cell("B2").value = 'Position'
+ws.cell("B3").value = 'dbSNP or Exome Variant Server ID'
+ws.cell("B4").value = 'Reference Allele'
+ws.cell("B5").value = 'Alternate Allele(s)'
+ws.cell("B6").value = 'Call quality'
+ws.cell("B7").value = 'Filter'
+ws.cell("A8").value = 'SAMPLE.GT'
+ws.cell("A9").value = 'SAMPLE.AD'
+ws.cell("B8").value = 'Sample Genotype (0: ref allele, 1: first alternate allele...)'
+ws.cell("B9").value = 'Allele depth'
+
+
+row=10
+
+for i in fields_in_INFO:
+  ws.cell("A%s" % row).value = i
+  ws.cell("B%s" % row).value = parser.infos[i].desc
+  row += 1
 wb.save(filename = fileout)