/// <summary>
/// TotalFromAminoAcidChainCompositionList method.
/// </summary>
/// <param name="aminoAcidChainCompositionList"></param>
/// <returns></returns>
public static AminoAcidChainComposition TotalFromAminoAcidChainCompositionList(List <AminoAcidChainComposition> aminoAcidChainCompositionList)
{
var aminoAcidChainCompositionTotal = new AminoAcidChainComposition("Total", "-");
lock (aminoAcidChainCompositionList)
{
foreach (AminoAcidChainComposition aminoAcidChainComposition in aminoAcidChainCompositionList)
{
for (int x = 0; x < AminoAcidTotals.TotalAminoAcids(); x++)
{
// note 1: array is zero based, amino acid numbers are one based
// note 2: IncrementAminoAcidCount method also increments all groups so only one call is required
aminoAcidChainCompositionTotal.IncrementAminoAcidCount(x + 1, aminoAcidChainComposition.AminoAcidGroupsCount[(int)AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups.AminoAcids][x]);
}
}
}
return(aminoAcidChainCompositionTotal);
}
/// <summary>
/// This method returns the entire UniProt database composition as a chain.
/// </summary>
/// <returns></returns>
public static AminoAcidChainComposition AminoAcidCompositionAsChain()
{
var result = new AminoAcidChainComposition();
int totalAminoAcids = AminoAcidTotals.TotalAminoAcids();
for (int x = 0; x < totalAminoAcids; x++)
{
var aaPercentage = AminoAcidCompositionInPercent(x + 1);
var aaOriginal = (aaPercentage / 100) * TotalAminoAcidsInDatabase;
result.IncrementAminoAcidCount(x + 1, aaOriginal);
}
result.NumberSamples = TotalSamplesInDatabase;
result = AminoAcidChainComposition.ConvertToPercentage(result);
return(result);
}
/// <summary>
/// ConvertToPercentage method.
/// </summary>
/// <param name="aminoAcidChainComposition"></param>
/// <param name="factorisation"></param>
/// <returns></returns>
public static AminoAcidChainComposition ConvertToPercentage(AminoAcidChainComposition aminoAcidChainComposition)
{
var aminoAcidChainCompositionAsPercentage = new AminoAcidChainComposition(aminoAcidChainComposition.ProteinId, aminoAcidChainComposition.ChainId);
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
var sumTotal = aminoAcidChainComposition.AminoAcidGroupsCount[(int)enumAminoAcidGroups].Sum();
if (sumTotal == 0)
{
continue;
}
for (int groupIndex = 0; groupIndex < AminoAcidGroups.AminoAcidGroups.GetTotalSubgroups(enumAminoAcidGroups); groupIndex++)
{
aminoAcidChainCompositionAsPercentage.AminoAcidGroupsCount[(int)enumAminoAcidGroups][groupIndex] = (aminoAcidChainComposition.AminoAcidGroupsCount[(int)enumAminoAcidGroups][groupIndex] / sumTotal) * 100.0m;
}
}
return(aminoAcidChainCompositionAsPercentage);
}
public static AminoAcidPairCompositionMatrix ConvertToMatrix(AminoAcidChainComposition chain)
{
if (chain == null)
{
return(null);
}
var result = new AminoAcidPairCompositionMatrix();
int totalAminoAcids = AminoAcidTotals.TotalAminoAcids();
for (int x = 0; x < totalAminoAcids; x++)
{
for (int y = 0; y < totalAminoAcids; y++)
{
result.IncrementAminoAcidCount(x + 1, y + 1, (chain.AminoAcidGroupsCount[(int)AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups.AminoAcids][x] * chain.AminoAcidGroupsCount[(int)AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups.AminoAcids][y]) / 100);
}
}
return(result);
}
/// <summary>
/// This method returns a spreadsheet heat map of the entire UniProt sequence database.
/// </summary>
/// <returns></returns>
public static List <SpreadsheetCell[]> UniProtHeatMapSpreadsheet()
{
var spreadsheet = new List <SpreadsheetCell[]>();
//spreadsheet.Add("HM Entire UniProt Database"); // filename / worksheet name
spreadsheet.Add(new[] { new SpreadsheetCell("Amino Acid Heat Map - Entire UniProt Database Composition (Converted To Matrix)") }); // spreadsheet title
//spreadsheet.Add(new[] {new SpreadsheetCell(string.Empty), });
//spreadsheet.Add(new[] {new SpreadsheetCell("Amino Acid Heat Map - Entire UniProt Database - A to Z") }); // section title
//spreadsheet.AddRange(AminoAcidCompositionAsMatrix().SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet.Add(new[] { new SpreadsheetCell(string.Empty), });
spreadsheet.Add(new[] { new SpreadsheetCell("Amino Acid Heat Map - Entire UniProt Database - Acid Groups " + enumAminoAcidGroups) }); // section title
spreadsheet.AddRange(AminoAcidCompositionAsMatrix().SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
spreadsheet.Add(new[] { new SpreadsheetCell(string.Empty), });
spreadsheet.Add(new[] { new SpreadsheetCell("Amino Acid Heat Map - Entire UniProt Database - Original Data - A to Z") }); // section title
AminoAcidChainComposition c = AminoAcidCompositionAsChain();
var chain = new List <SpreadsheetCell>();
chain.Add(new SpreadsheetCell(string.Empty));
for (int i = 0; i < AminoAcidTotals.TotalAminoAcids(); i++)
{
chain.Add(new SpreadsheetCell(AminoAcidConversions.AminoAcidNumberToCode1L(i + 1)));
}
spreadsheet.Add(chain.ToArray());
chain = new List <SpreadsheetCell>();
chain.Add(new SpreadsheetCell(string.Empty));
for (int i = 0; i < AminoAcidTotals.TotalAminoAcids(); i++)
{
chain.Add(new SpreadsheetCell(c.AminoAcidGroupsCount[(int)AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups.AminoAcids][i]));
}
spreadsheet.Add(chain.ToArray());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet.Add(new[] { new SpreadsheetCell(string.Empty), });
spreadsheet.Add(new[] { new SpreadsheetCell("Amino Acid Heat Map - Entire UniProt Database - Original Data - Acid Groups " + enumAminoAcidGroups) }); // section title
var chainGroups = new List <SpreadsheetCell>();
chainGroups.Add(new SpreadsheetCell(string.Empty));
for (int i = 0; i < AminoAcidGroups.AminoAcidGroups.GetTotalSubgroups(enumAminoAcidGroups); i++)
{
chainGroups.Add(new SpreadsheetCell((i + 1)));
}
spreadsheet.Add(chainGroups.ToArray());
chainGroups = new List <SpreadsheetCell>();
chainGroups.Add(new SpreadsheetCell(string.Empty));
for (int i = 0; i < AminoAcidGroups.AminoAcidGroups.GetTotalSubgroups(enumAminoAcidGroups); i++)
{
chainGroups.Add(new SpreadsheetCell(c.AminoAcidGroupsCount[(int)enumAminoAcidGroups][i]));
}
spreadsheet.Add(chainGroups.ToArray());
}
return(spreadsheet);
}
/// <summary>
/// This method returns the entire UniProt database composition as a 2d matrix.
/// </summary>
/// <returns></returns>
public static AminoAcidPairCompositionMatrix AminoAcidCompositionAsMatrix()
{
return(AminoAcidChainComposition.ConvertToMatrix(AminoAcidCompositionAsChain()));
}
/// <summary>
/// Makes spreadsheets with scientific data outputs about given proteins.
/// </summary>
/// <param name="cancellationToken"></param>
/// <param name="pdbFolders">The location of the PDB files</param>
/// <param name="pdbIdList">The PDB files which should be used.</param>
/// <param name="consoleTextBox"></param>
/// <param name="progressBar">User proteinInterface progress bar for user feedback.</param>
/// <param name="estimatedTimeRemainingLabel">User proteinInterface estimated time remaining label for user feedback.</param>
/// <param name="requestedTotalThreads"></param>
/// <returns>Returns the generated spreadsheets with scientific data.</returns>
public static List <List <SpreadsheetCell[]> > MakeHomodimerStatisticsSpreadsheetsList(CancellationToken cancellationToken, decimal maxAtomInterationDistance, string[] pdbFolders, List <string> pdbIdList = null, Dictionary <string, List <string> > pdbIdChainIdList = null, ProgressActionSet progressActionSet = null, int requestedTotalThreads = -1)
{
if (pdbFolders == null || pdbFolders.Length == 0)
{
throw new ArgumentOutOfRangeException(nameof(pdbFolders));
}
if (pdbIdList == null || pdbIdList.Count == 0)
{
throw new ArgumentOutOfRangeException(nameof(pdbIdList));
}
if (progressActionSet == null)
{
throw new ArgumentNullException(nameof(progressActionSet));
}
// this method creates
// 1. a list of interactions
// 2. a list of symmetry percentage
// 3. an "expected" heatmap by combining every possible a/b amino acid combination
// 4. an actual heatmap for the proteinInterfaces
// 5. normalised versions of both of the heatmaps
string[] pdbFilesArray = ProteinDataBankFileOperations.RemoveNonWhiteListedPdbIdFromPdbFilesArray(pdbIdList, ProteinDataBankFileOperations.GetPdbFilesArray(pdbFolders));
//var interactionRecordList = new List<ProteinInteractionRecord>();
//var interactionMatchPercentageList = new List<InteractionMatchPercentage>();
//var wholeProteinChainsAminoAcidCounter = new List<AminoAcidChainComposition>();
//var interactionChainsAminoAcidCounter = new List<AminoAcidChainComposition>();
//var interactionsAminoAcidToAminoAcidCounter = new AminoAcidPairCompositionMatrix();
////var wholeProteinAminoAcidToAminoAcidCounter2x2 = new AminoAcidPairCompositionMatrix(); // composition of every amino acid paired in every possible combination
var workDivision = new WorkDivision <HomodimersStatisticsMinerTaskResult>(pdbFilesArray.Length, requestedTotalThreads);
ProgressActionSet.StartAction(pdbFilesArray.Length, progressActionSet);
int checkAllFilesProcessed = 0;
var lockCheckAllFilesProcessed = new object();
var pdbFilesProcessed = new bool[pdbFilesArray.Length];
Array.Clear(pdbFilesProcessed, 0, pdbFilesProcessed.Length);
for (int threadIndex = 0; threadIndex < workDivision.ThreadCount; threadIndex++)
{
int localThreadIndex = threadIndex;
Task <HomodimersStatisticsMinerTaskResult> task = Task.Run(() =>
{
var result = new HomodimersStatisticsMinerTaskResult();
for (int pdbFileNumber = workDivision.ThreadFirstIndex[localThreadIndex]; pdbFileNumber <= workDivision.ThreadLastIndex[localThreadIndex]; pdbFileNumber++)
{
if (cancellationToken.IsCancellationRequested)
{
break;
}
lock (lockCheckAllFilesProcessed)
{
checkAllFilesProcessed++;
pdbFilesProcessed[pdbFileNumber] = true;
}
try
{
string pdbFilename = pdbFilesArray[pdbFileNumber];
string proteinId = ProteinDataBankFileOperations.PdbIdFromPdbFilename(pdbFilename);
// Check if the file found is included in the white list.
if (/*pdbIdList != null && */ !pdbIdList.Contains(proteinId))
{
ProgressActionSet.Report("Error: " + proteinId + " was not in the PDB ID white list.", progressActionSet);
continue;
}
List <AtomPair> interactions = SearchInteractions.FindInteractions(cancellationToken, maxAtomInterationDistance, pdbFilename, pdbIdChainIdList);
// Make a list to save interactions found.
var interactionMatchPercentage = new InteractionMatchPercentage(proteinId);
var chainAminoAcidCounterA1X1 = new AminoAcidChainComposition(proteinId, "A");
var chainAminoAcidCounterB1X1 = new AminoAcidChainComposition(proteinId, "B");
var chainInteractionAminoAcidCounterA = new AminoAcidChainComposition(proteinId, "A");
var chainInteractionAminoAcidCounterB = new AminoAcidChainComposition(proteinId, "B");
if (interactions != null && interactions.Count > 0)
{
interactionMatchPercentage.IncrementTotalInteractions(interactions.Count);
for (int interactionsIndex = 0; interactionsIndex < interactions.Count; interactionsIndex++)
{
chainInteractionAminoAcidCounterA.IncrementAminoAcidCount(interactions[interactionsIndex].Atom1.resName.FieldValue);
chainInteractionAminoAcidCounterB.IncrementAminoAcidCount(interactions[interactionsIndex].Atom2.resName.FieldValue);
result.InteractionRecordList.Add(new ProteinInteractionRecord(proteinId, interactionsIndex + 1, interactions[interactionsIndex]));
interactionMatchPercentage.AddResidueSequenceIndex(StaticValues.ChainA, interactions[interactionsIndex].Atom1.resSeq.FieldValue);
interactionMatchPercentage.AddResidueSequenceIndex(StaticValues.ChainB, interactions[interactionsIndex].Atom2.resSeq.FieldValue);
result.InteractionsAminoAcidToAminoAcidCounter.IncrementAminoAcidCount(interactions[interactionsIndex].Atom1.resName.FieldValue, interactions[interactionsIndex].Atom2.resName.FieldValue);
}
}
var chainIdList = pdbIdChainIdList != null ? (pdbIdChainIdList.ContainsKey(proteinId) ? pdbIdChainIdList[proteinId].ToArray() : null) : null;
ProteinChainListContainer proteinFileChains = ProteinDataBankFileOperations.PdbAtomicChains(pdbFilename, chainIdList, 2, 2, true);
if (proteinFileChains == null || proteinFileChains.ChainList == null || proteinFileChains.ChainList.Count != 2 ||
proteinFileChains.ChainList[StaticValues.ChainA] == null || proteinFileChains.ChainList[StaticValues.ChainA].AtomList == null || proteinFileChains.ChainList[StaticValues.ChainA].AtomList.Count == 0 ||
proteinFileChains.ChainList[StaticValues.ChainB] == null || proteinFileChains.ChainList[StaticValues.ChainB].AtomList == null || proteinFileChains.ChainList[StaticValues.ChainB].AtomList.Count == 0)
{
if (!File.Exists(pdbFilename))
{
ProgressActionSet.Report("Error: " + pdbFilename + " (" + proteinId + ") file not found", progressActionSet);
}
else
{
int proteinFileChainCount = ProteinDataBankFileOperations.PdbAtomicChainsCount(pdbFilename);
ProgressActionSet.Report("Error: " + proteinId + " did not have exactly 2 chains (" + proteinFileChainCount + " chains found) - skipping.", progressActionSet);
}
continue;
}
// count total of how many of each type of amino acids are in Chain A.
for (int atomIndexA = 0; atomIndexA < proteinFileChains.ChainList[StaticValues.ChainA].AtomList.Count; atomIndexA++)
{
chainAminoAcidCounterA1X1.IncrementAminoAcidCount(proteinFileChains.ChainList[StaticValues.ChainA].AtomList[atomIndexA].resName.FieldValue);
}
// count total of how many of each type of amino acids are in Chain B.
for (int atomIndexB = 0; atomIndexB < proteinFileChains.ChainList[StaticValues.ChainB].AtomList.Count; atomIndexB++)
{
chainAminoAcidCounterB1X1.IncrementAminoAcidCount(proteinFileChains.ChainList[StaticValues.ChainB].AtomList[atomIndexB].resName.FieldValue);
}
interactionMatchPercentage.CalculatePercentage();
result.InteractionMatchPercentageList.Add(interactionMatchPercentage);
result.WholeProteinChainsAminoAcidCounter.Add(chainAminoAcidCounterA1X1);
result.WholeProteinChainsAminoAcidCounter.Add(chainAminoAcidCounterB1X1);
result.InteractionChainsAminoAcidCounter.Add(chainInteractionAminoAcidCounterA);
result.InteractionChainsAminoAcidCounter.Add(chainInteractionAminoAcidCounterB);
}
finally
{
workDivision.IncrementItemsCompleted(1);
ProgressActionSet.ProgressAction(1, progressActionSet);
ProgressActionSet.EstimatedTimeRemainingAction(workDivision.StartTicks, workDivision.ItemsCompleted, workDivision.ItemsToProcess, progressActionSet);
}
}
return(result);
}, cancellationToken);
workDivision.TaskList.Add(task);
}
workDivision.WaitAllTasks();
ProgressActionSet.FinishAction(true, progressActionSet);
// merge all instances of the results
var spreadsheetTaskResult = new HomodimersStatisticsMinerTaskResult();
foreach (var task in workDivision.TaskList.Where(t => t != null && t.IsCompleted && !t.IsCanceled && !t.IsFaulted && t.Result != null))
{
if (task.Result.InteractionChainsAminoAcidCounter != null && task.Result.InteractionChainsAminoAcidCounter.Count > 0)
{
spreadsheetTaskResult.InteractionChainsAminoAcidCounter.AddRange(task.Result.InteractionChainsAminoAcidCounter);
}
if (task.Result.InteractionMatchPercentageList != null && task.Result.InteractionMatchPercentageList.Count > 0)
{
spreadsheetTaskResult.InteractionMatchPercentageList.AddRange(task.Result.InteractionMatchPercentageList);
}
if (task.Result.InteractionRecordList != null && task.Result.InteractionRecordList.Count > 0)
{
spreadsheetTaskResult.InteractionRecordList.AddRange(task.Result.InteractionRecordList);
}
if (task.Result.InteractionsAminoAcidToAminoAcidCounter != null)
{
if (task.Result.InteractionsAminoAcidToAminoAcidCounter.AminoAcidToAminoAcid != null)
{
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
var totalGroups = AminoAcidGroups.AminoAcidGroups.GetTotalSubgroups(enumAminoAcidGroups);
for (int x = 0; x < totalGroups; x++)
{
for (int y = 0; y < totalGroups; y++)
{
spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter.AminoAcidToAminoAcid[(int)enumAminoAcidGroups][x, y] +=
task.Result.InteractionsAminoAcidToAminoAcidCounter.AminoAcidToAminoAcid[(int)enumAminoAcidGroups][x, y];
}
}
}
}
}
if (task.Result.WholeProteinChainsAminoAcidCounter != null && task.Result.WholeProteinChainsAminoAcidCounter.Count > 0)
{
spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter.AddRange(task.Result.WholeProteinChainsAminoAcidCounter);
}
}
if (pdbFilesProcessed.Count(file => file == false) > 0)
{
ProgressActionSet.Report("ERROR: " + pdbFilesProcessed.Count(file => file == false) + " PDB FILES WERE SKIPPED! 0x01", progressActionSet);
}
else
{
ProgressActionSet.Report("CHECK: NO PDB FILES WERE SKIPPED! 0x01", progressActionSet);
}
if (checkAllFilesProcessed != pdbFilesArray.Length)
{
ProgressActionSet.Report("ERROR: " + (pdbFilesArray.Length - checkAllFilesProcessed) + " PDB FILES WERE SKIPPED! 0x02", progressActionSet);
}
else
{
ProgressActionSet.Report("CHECK: NO PDB FILES WERE SKIPPED! 0x02", progressActionSet);
}
spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter = spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter.OrderBy(a => a.ProteinId).ThenBy(b => b.ChainId).ToList();
spreadsheetTaskResult.InteractionChainsAminoAcidCounter = spreadsheetTaskResult.InteractionChainsAminoAcidCounter.OrderBy(a => a.ProteinId).ThenBy(b => b.ChainId).ToList();
AminoAcidChainComposition wholeProteinChainsTotals = AminoAcidChainComposition.TotalFromAminoAcidChainCompositionList(spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter);
AminoAcidChainComposition interactionChainsTotals = AminoAcidChainComposition.TotalFromAminoAcidChainCompositionList(spreadsheetTaskResult.InteractionChainsAminoAcidCounter);
AminoAcidPairCompositionMatrix wholeProteinAminoAcidToAminoAcidCounter1X1 = AminoAcidChainComposition.ConvertToMatrix(wholeProteinChainsTotals);
var results = new List <List <SpreadsheetCell[]> >();
{
/* start test */
var spreadsheet1 = new List <SpreadsheetCell[]>();
spreadsheet1.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% TEST SHEET 0"), });
spreadsheet1.Add(new[] { new SpreadsheetCell("TEST SHEET 0"), });
foreach (AminoAcidChainComposition item in spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter)
{
//spreadsheet1.Add(item.ProteinId);
//spreadsheet1.Add(item.ChainId);
spreadsheet1.Add(item.SpreadsheetDataRow());
}
results.Add(spreadsheet1);
spreadsheet1 = null;
/* end test */
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
{
var spreadsheet2 = new List <SpreadsheetCell[]>();
spreadsheet2.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Interaction Symmetry"), });
spreadsheet2.Add(new[] { new SpreadsheetCell("Homodimers - List - Interaction Count And Interaction Match Percentage (Symmetry Measurement)") });
spreadsheet2.Add(InteractionMatchPercentage.SpreadsheetColumnHeadersRow());
var range2 = spreadsheetTaskResult.InteractionMatchPercentageList.Select(record => record.SpreadsheetDataRow()).ToList();
//range2.Sort();
range2 = range2
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ThenBy(a => a[2].CellData)
.ThenBy(a => a[3].CellData)
.ThenBy(a => a[4].CellData)
.ThenBy(a => a[5].CellData)
.ThenBy(a => a[6].CellData)
.ThenBy(a => a[7].CellData)
.ThenBy(a => a[8].CellData)
.ToList();
spreadsheet2.AddRange(range2);
range2 = null;
results.Add(spreadsheet2);
var spreadsheetHistogram2 = new List <SpreadsheetCell[]>();
spreadsheetHistogram2.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% HG Interaction Symmetry"), });
spreadsheetHistogram2.Add(new[] { new SpreadsheetCell("Homodimers - List - Interaction Count And Interaction Match Percentage (Symmetry Measurement) Histogram") });
spreadsheetHistogram2.AddRange(Histogram.MatrixToHistogram(spreadsheet2.ToArray(), Histogram.MakeBinDecimals(0, 100, 9, 10), new[] { 6, 7, 8 }, 2, -1, true));
results.Add(spreadsheetHistogram2);
spreadsheet2 = null;
spreadsheetHistogram2 = null;
}
//
{
var spreadsheet3 = new List <SpreadsheetCell[]>();
spreadsheet3.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Interaction Records"), });
spreadsheet3.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Interaction Record"), });
spreadsheet3.Add(ProteinInteractionRecord.TsvColumnHeadersRow());
var range3 = spreadsheetTaskResult.InteractionRecordList.Select(record => record.SpreadsheetDataRow()).ToList();
//range3.Sort();
range3 = range3
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ThenBy(a => a[3].CellData)
.ThenBy(a => a[5].CellData)
.ThenBy(a => a[13].CellData)
.ThenBy(a => a[15].CellData)
.ToList();
spreadsheet3.AddRange(range3);
range3 = null;
results.Add(spreadsheet3);
var spreadsheetHistogram3 = new List <SpreadsheetCell[]>();
spreadsheetHistogram3.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Interaction Records Histogram"), });
spreadsheetHistogram3.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Interaction Record - Histogram"), });
spreadsheetHistogram3.AddRange(Histogram.MatrixToHistogram(spreadsheet3.ToArray(), Histogram.MakeBinDecimals(0m, 5m, 0m, 0.05m), new[] { 1 }, 2, -1, true));
results.Add(spreadsheetHistogram3);
//spreadsheet3 = Histogram.InsertMatrixOverwrite(spreadsheet3.ToArray(), histogram3, 2, Histogram.MaxColumns(spreadsheet3.ToArray()) + 1).ToList();
spreadsheet3 = null;
spreadsheetHistogram3 = null;
}
//
{
var spreadsheet4 = new List <SpreadsheetCell[]>();
spreadsheet4.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Interaction Count - A-Z"), });
spreadsheet4.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Amino Acid Count - Interactions - A to Z"), });
spreadsheet4.Add(AminoAcidChainComposition.SpreadsheetTitleRow());
var range4 = spreadsheetTaskResult.InteractionChainsAminoAcidCounter.Select(record => record.SpreadsheetDataRow()).ToList();
//range4.Sort();
range4 = range4
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ToList();
spreadsheet4.AddRange(range4);
range4 = null;
spreadsheet4.Add(interactionChainsTotals.SpreadsheetDataRow());
results.Add(spreadsheet4);
spreadsheet4 = null;
}
//
{
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
var spreadsheet5 = new List <SpreadsheetCell[]>();
spreadsheet5.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Interaction Count - Groups " + enumAminoAcidGroups), });
spreadsheet5.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Amino Acid Count - Interactions - Acid Groups " + enumAminoAcidGroups), });
spreadsheet5.Add(AminoAcidChainComposition.SpreadsheetGroupsTitleRow(enumAminoAcidGroups));
var range5 = spreadsheetTaskResult.InteractionChainsAminoAcidCounter.Select(record => record.SpreadsheetGroupsDataRow(enumAminoAcidGroups)).ToList();
//range4.Sort();
range5 = range5
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ToList();
spreadsheet5.AddRange(range5);
range5 = null;
spreadsheet5.Add(interactionChainsTotals.SpreadsheetGroupsDataRow(enumAminoAcidGroups));
results.Add(spreadsheet5);
spreadsheet5 = null;
}
}
//
{
var spreadsheet6 = new List <SpreadsheetCell[]>();
spreadsheet6.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Entire Count - A-Z"), });
spreadsheet6.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Amino Acid Count - All Atoms - A to Z"), });
spreadsheet6.Add(AminoAcidChainComposition.SpreadsheetTitleRow());
var range6 = spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter.Select(record => record.SpreadsheetDataRow()).ToList();
//range6.Sort();
range6 = range6
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ToList();
spreadsheet6.AddRange(range6);
range6 = null;
spreadsheet6.Add(wholeProteinChainsTotals.SpreadsheetDataRow());
results.Add(spreadsheet6);
var spreadsheetHistogram6 = new List <SpreadsheetCell[]>();
spreadsheetHistogram6.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Entire Count - A-Z - Historgram"), });
spreadsheetHistogram6.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Amino Acid Count - All Atoms - A to Z - Histogram"), });
spreadsheetHistogram6.AddRange(Histogram.MatrixToHistogram(spreadsheet6.ToArray(), Histogram.MakeBinDecimals(0, 10500, 0, 500), new[] { 28 }, 2, -1, true));
spreadsheetHistogram6.Add(new [] { new SpreadsheetCell(""), });
spreadsheetHistogram6.AddRange(Histogram.MatrixToHistogram(spreadsheet6.ToArray(), Histogram.MakeBinDecimals(0, 1000, 0, 100), new[] { 28 }, 2, -1, true));
results.Add(spreadsheetHistogram6);
spreadsheet6 = null;
spreadsheetHistogram6 = null;
}
//
{
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
var spreadsheet7 = new List <SpreadsheetCell[]>();
spreadsheet7.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% L Entire Count - Groups " + enumAminoAcidGroups), });
spreadsheet7.Add(new[] { new SpreadsheetCell("Homodimers - List - Protein Amino Acid Count - All Atoms - Acid Groups " + enumAminoAcidGroups), });
spreadsheet7.Add(AminoAcidChainComposition.SpreadsheetGroupsTitleRow(enumAminoAcidGroups));
var range7 = spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter.Select(record => record.SpreadsheetGroupsDataRow(enumAminoAcidGroups)).ToList();
//range7.Sort();
range7 = range7
.OrderBy(a => a[0].CellData)
.ThenBy(a => a[1].CellData)
.ToList();
spreadsheet7.AddRange(range7);
range7 = null;
spreadsheet7.Add(wholeProteinChainsTotals.SpreadsheetGroupsDataRow(enumAminoAcidGroups));
results.Add(spreadsheet7);
spreadsheet7 = null;
}
}
// convert to percentage for creating mean average protein composition
var meanProteinComposition = new AminoAcidChainComposition("Mean Composition", "-");
foreach (AminoAcidChainComposition aminoAcidChainComposition in spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter)
{
// get percentage for row
AminoAcidChainComposition percentage = AminoAcidChainComposition.ConvertToPercentage(aminoAcidChainComposition);
// add percentage to overall tally
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
for (int x = 0; x < AminoAcidGroups.AminoAcidGroups.GetTotalSubgroups(enumAminoAcidGroups); x++)
{
meanProteinComposition.AminoAcidGroupsCount[(int)enumAminoAcidGroups][x] += (percentage.AminoAcidGroupsCount[(int)enumAminoAcidGroups][x] / spreadsheetTaskResult.WholeProteinChainsAminoAcidCounter.Count);
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
{
/* start test */
var spreadsheet8 = new List <SpreadsheetCell[]>();
spreadsheet8.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% TEST SHEET 1"), }); // Worksheet name.
spreadsheet8.Add(new[] { new SpreadsheetCell("TEST SHEET 1"), }); // Spreadsheet title
spreadsheet8.Add(new[] { new SpreadsheetCell(string.Empty), });
spreadsheet8.Add(meanProteinComposition.SpreadsheetDataRow());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet8.Add(meanProteinComposition.SpreadsheetGroupsDataRow(enumAminoAcidGroups));
}
results.Add(spreadsheet8);
spreadsheet8 = null;
/* end test */
}
AminoAcidPairCompositionMatrix meanProteinMatrix = AminoAcidChainComposition.ConvertToMatrix(meanProteinComposition);
{
var spreadsheet9 = new List <SpreadsheetCell[]>();
spreadsheet9.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% HM All Atoms 3x3"), }); // Worksheet name.
spreadsheet9.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Average Chain Composition"), }); // Spreadsheet title.
//spreadsheet9.Add(new[] { new SpreadsheetCell(string.Empty), });
//spreadsheet9.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Average Chain Composition - Percentage Composition - A to Z"), }); // Section title.
//spreadsheet9.AddRange(meanProteinMatrix.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet9.Add(new[] { new SpreadsheetCell(string.Empty), });
spreadsheet9.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Average Chain Composition - Percentage Composition - Acid Groups " + enumAminoAcidGroups), }); // Section title.
spreadsheet9.AddRange(meanProteinMatrix.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
results.Add(spreadsheet9);
spreadsheet9 = null;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//if (outputAllAtoms1x1)
//{
AminoAcidPairCompositionMatrix wholeProteinAminoAcidToAminoAcidCounterPercentage1X1 = AminoAcidPairCompositionMatrix.CalculatePercentageMatrix(wholeProteinAminoAcidToAminoAcidCounter1X1);
{
var spreadsheet10 = new List <SpreadsheetCell[]>();
spreadsheet10.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% HM All Atoms 1x1") }); // Worksheet name.
spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall Composition") }); // Spreadsheet title.
//spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall Percentage Composition - A to Z")}); // Section title.
//spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall Percentage Composition - Acid Groups " + enumAminoAcidGroups) }); // Section title.
spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
AminoAcidPairCompositionMatrix wholeProteinAminoAcidToAminoAcidCounterNormalised1X1 = AminoAcidPairCompositionMatrix.NormalizeWithCompositionMatrix(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1, UniProtProteinDatabaseComposition.AminoAcidCompositionAsMatrix());
//spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall UniProt Normalised - A to Z ")}); // Section title.
//spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterNormalised1X1.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall UniProt Normalised - Acid Groups " + enumAminoAcidGroups) }); // Section title.
spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterNormalised1X1.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
AminoAcidPairCompositionMatrix wholeProteinAminoAcidToAminoAcidCounterDifference1X1 = AminoAcidPairCompositionMatrix.DifferenceWithCompositionMatrix(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1, UniProtProteinDatabaseComposition.AminoAcidCompositionAsMatrix());
//spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall A to Z - UniProt Difference")}); // Section title.
//spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterDifference1X1.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet10.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet10.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - All Atoms - Overall Acid Groups " + enumAminoAcidGroups + " - UniProt Difference") }); // Section title.
spreadsheet10.AddRange(wholeProteinAminoAcidToAminoAcidCounterDifference1X1.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
results.Add(spreadsheet10);
spreadsheet10 = null;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
{
AminoAcidPairCompositionMatrix interactionsAminoAcidToAminoAcidCounterPercentage = AminoAcidPairCompositionMatrix.CalculatePercentageMatrix(spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter);
var spreadsheet11 = new List <SpreadsheetCell[]>();
spreadsheet11.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% HM Interactions Only") }); // Worksheet name.
spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only") }); // Spreadsheet title.
//spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - A to Z")}); // Section title.
//spreadsheet11.AddRange(spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - Acid Groups " + enumAminoAcidGroups) }); // Section title.
spreadsheet11.AddRange(spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
AminoAcidPairCompositionMatrix interactionsAminoAcidToAminoAcidCounterNormalised = AminoAcidPairCompositionMatrix.NormalizeWithCompositionMatrix(interactionsAminoAcidToAminoAcidCounterPercentage, UniProtProteinDatabaseComposition.AminoAcidCompositionAsMatrix());
//spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - A to Z - UniProt Normalised")}); // Section title.
//spreadsheet11.AddRange(interactionsAminoAcidToAminoAcidCounterNormalised.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - Acid Groups " + enumAminoAcidGroups + " - UniProt Normalised") }); // Section title.
spreadsheet11.AddRange(interactionsAminoAcidToAminoAcidCounterNormalised.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
AminoAcidPairCompositionMatrix interactionsAminoAcidToAminoAcidCounterDifference = AminoAcidPairCompositionMatrix.DifferenceWithCompositionMatrix(interactionsAminoAcidToAminoAcidCounterPercentage, UniProtProteinDatabaseComposition.AminoAcidCompositionAsMatrix());
//spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty)});
//spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - A to Z - UniProt Difference")}); // Section title.
//spreadsheet11.AddRange(interactionsAminoAcidToAminoAcidCounterDifference.SpreadsheetAminoAcidColorGroupsHeatMap());
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet11.Add(new[] { new SpreadsheetCell(string.Empty) });
spreadsheet11.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Interactions Only - Acid Groups " + enumAminoAcidGroups + " - UniProt Difference") }); // Section title.
spreadsheet11.AddRange(interactionsAminoAcidToAminoAcidCounterDifference.SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
}
results.Add(spreadsheet11);
spreadsheet11 = null;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
{
var spreadsheet12 = new List <SpreadsheetCell[]>();
spreadsheet12.Add(new[] { new SpreadsheetCell("%batch_number%%batch_letter% HM Interactions v Homodimers") }); // Worksheet name.
spreadsheet12.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Difference between homodimer composition and homodimer interactions") }); // Spreadsheet title
spreadsheet12.Add(new[] { new SpreadsheetCell(string.Empty) });
//spreadsheet12.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Difference between homodimer composition and homodimer interactions - A to Z")}); // Section title
//spreadsheet12.AddRange(AminoAcidPairCompositionMatrix.DifferenceWithCompositionMatrix(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1, spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter).SpreadsheetAminoAcidColorGroupsHeatMap());
//spreadsheet12.Add(new[] { new SpreadsheetCell(string.Empty)});
foreach (AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups enumAminoAcidGroups in Enum.GetValues(typeof(AminoAcidGroups.AminoAcidGroups.EnumAminoAcidGroups)))
{
spreadsheet12.Add(new[] { new SpreadsheetCell("Homodimers - Amino Acid Heat Map - Difference between homodimer composition and homodimer interactions - Acid Groups " + enumAminoAcidGroups) }); // Section title.
spreadsheet12.AddRange(AminoAcidPairCompositionMatrix.DifferenceWithCompositionMatrix(wholeProteinAminoAcidToAminoAcidCounterPercentage1X1, spreadsheetTaskResult.InteractionsAminoAcidToAminoAcidCounter).SpreadsheetAminoAcidColorGroupsHeatMap(enumAminoAcidGroups));
spreadsheet12.Add(new[] { new SpreadsheetCell(string.Empty) });
}
results.Add(spreadsheet12);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
return(results);
}
