search

Ahhgust / STRaitRazor

MIT License
11 stars 6 forks source link

The Excel Workbook for processing data is extremely sluggish. #3

Open soncomqiq opened 2 years ago

soncomqiq commented 2 years ago

I downloaded this worksheet in order to process the STR pattern. When I click the process queue button on the queue tab. Data processing takes a long time. Could you please assist me in checking this?

https://www.dropbox.com/s/t3n0d2h6od0qek2/STRait%20Razor%20Analysis%20v3.xlsm?dl=1

ExpectationsManaged commented 2 years ago

If you're looking into secondary analysis of v3 output, I highly recommend considering STRait Razor Online (SRO). SRO comes in standalone (local) and online (web-based) interfaces. The online (http://www.unthsc.edu/straitrazor) is easy to use. The standalone (https://github.com/ExpectationsManaged/STRaitRazorOnline) allows for batch processing of samples; however, you need to install R and RStudio. So, it's not as "turn-key" as the web interface. Please let us know if you need any help.

soncomqiq commented 2 years ago

Thank you so much.

soncomqiq commented 2 years ago

@ExpectationsManaged I attempted to submit the file as a batch on my local app, but it failed with some errors. both the fastq and allsequence.txt files.

ExpectationsManaged commented 2 years ago

Can you give some details of error (e.g., screenshot or copy of console text)? Also, with which OS and versions of R and RStudio are working?

ExpectationsManaged commented 2 years ago

@soncomqiq See above

soncomqiq commented 2 years ago

My Environments are

image

When I click on allsequences Dir button, it will throw these errors

image

@ExpectationsManaged Thanks in advance.

ExpectationsManaged commented 2 years ago

@soncomqiq My apologies for the delay. I was at a conference and took some time after. Before you upload an allseq or fastq file, please make sure and select LoadDB button above. This will load the current set of kits into the UI. It is alphabetical and the current default is ForenSeq. So, you'll need to make sure you're on the right one. Then, select the directory button as you have it. Sorry again for the confusion.

zhulihuan commented 1 year ago

Hello, can the standalone SRO be used under the windows system? Can the online SRO be used on windows and load my own configuration file, Thank you for your answer to my question.

zhulihuan commented 1 year ago

my own configuration file means kit, because I find I can not select my desired locus.

ExpectationsManaged commented 1 year ago

With the standalone version, you can add a kit using these instructions https://www.dropbox.com/scl/fi/syna0lqpbxpawhzafmudu/STRait-Razor-Online_AddingKits.pdf?rlkey=l2bv9ypvc55umnp1fs46abt9o&dl=1

The online version is content locked though. Our apologies.

Please let me know if you have any issue.

zhulihuan commented 1 year ago

Thank you for your reply. I have another question about the Excel workbag for version V3, but I found that the link is invalid. Is there still this Excel workbag

---Original--- From: @.> Date: Sun, Oct 22, 2023 20:46 PM To: @.>; Cc: @.**@.>; Subject: Re: [Ahhgust/STRaitRazor] The Excel Workbook for processing data isextremely sluggish. (Issue #3)

With the standalone version, you can add a kit using these instructions https://www.dropbox.com/scl/fi/syna0lqpbxpawhzafmudu/STRait-Razor-Online_AddingKits.pdf?rlkey=l2bv9ypvc55umnp1fs46abt9o&dl=1

The online version is content locked though. Our apologies.

Please let me know if you have any issue.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.***>

ExpectationsManaged commented 1 year ago

Sorry about that.

https://www.dropbox.com/s/t3n0d2h6od0qek2/STRait%20Razor%20v3%20Analysis.xlsm?dl=1

This should work

zhulihuan commented 1 year ago

Thank you very much for your reply. I have successfully downloaded the working bag, and I have added the loci I want to get in the kit loci option, some loci are like this, but they all have bar charts on the TOP20 page.may I ask if this can be solved? Or is there something wrong with my operation, because there are some differences between the job description I downloaded on this website and the Excel job description I am using now, thank you for your reply image

In addition, I would like to ask you another question, why is this number different? According to the literature, the numbers in allsequences.txt can be understood as abundance.

zhulihuan commented 1 year ago

Thank you very much for your reply. I have successfully downloaded the working bag, and I have added the loci I want to get in the kit loci option, some loci are like this, but they all have bar charts on the TOP20 page.may I ask if this can be solved? Or is there something wrong with my operation, because there are some differences between the job description I downloaded on this website and the Excel job description I am using now, thank you for your reply

 In addition, I would like to ask you another question, why is this number different? According to the literature, the numbers in allsequences.txt can be understood as abundance. For example,DXS10074,The Doc of allele 15 is 335+206=541, why is it finally shown to be 340, thank you for your answer. Excuse me for interrupting you.

---Original--- From: @.> Date: Tue, Oct 24, 2023 05:42 AM To: @.>; Cc: @.**@.>; Subject: Re: [Ahhgust/STRaitRazor] The Excel Workbook for processing data isextremely sluggish. (Issue #3)

Sorry about that.

https://www.dropbox.com/s/t3n0d2h6od0qek2/STRait%20Razor%20v3%20Analysis.xlsm?dl=1

This should work

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.***>