Efficiently compares multiple XLSX or VCF (Variant Call Format) files to identify common/different genomic positions, designed specifically for multisample comparisons. This tool functions as a specialized file comparator, optimized for speed and tailored to handle the intricacies of VCF files.
![image](https://private-user-images.githubusercontent.com/95364352/319371939-827da7fe-86d4-4892-a0e4-72b9346ca734.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQyNjY1MDYsIm5iZiI6MTcyNDI2NjIwNiwicGF0aCI6Ii85NTM2NDM1Mi8zMTkzNzE5MzktODI3ZGE3ZmUtODZkNC00ODkyLWEwZTQtNzJiOTM0NmNhNzM0LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODIxVDE4NTAwNlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTJjZmU4ZWIyMTc3YTcxYzEyYjE5NGU0MDk3ZDEwMjRhODkzMTEyNTBkNmFkNGJjMDkwMTYyMWJhMDczYTU1MzQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.0UfieWOlwI9kB6wZUN9AcX48MYgXlfVBRfvfFt933tg)
Compares multiple XLSX files to identify common/different positions. Suitable for any use. Fast and reliable. Engineered for multisample comparisons.
- Add Files: Click the
Add file
button to add at least two XLSX Excel files (no file number limit). - Set Parameters:
First Cell
: First Cell of the Categories row. Find your headers row (usually the first row) and write the first cell's value here (the most left cell).Aimed Cell
: Aimed Cell of the Categories row. Find the column you want to compare, and write the header of that column here.
- Optional Settings:
- Change the
Output folder
andOutput file type
. - Name your new Excel file
Output file (.xlsx)
. - Mark/unmark
Split cell text
or add your custom splitter (Add a space between every splitter). - Mark/unmark
Discordant Comparison
. Check this to output differences instead of commonities.
- Change the
An Excel (.xlsx) file will be created in the chosen output folder with multiple spreadsheets containing common/different positions of the XLSX files. If VCF is selected as output type, each VCF file will contain its commonities/differences.
- Input file name must not contain illegal characters like
.
:
or'
. First Cell
&Aimed Cell
parameters must be typed in correctly and are case-sensitive.- All files should be in Excel Workbook ".xlsx" format (not ".xls" or
Strict Open XML Spreadsheet
). - The first rows of XLSX files can have metadata starting with "##". If they don't exist, it's even better.
- There must not be a highlighted/edited cell in a row under the final row. For example, if the last row is 351 and you accidentally highlighted row 462, the algorithm will think there are more data between those rows, causing it to crash.
Compares multiple VCF (Variant Call Format) files for common/different positions, optimized for multisample comparisons. (Faster than XLSX Comparator)
- Add Files: Click the
Add file
button to add at least two VCF files (no file number limit). - Hit
Compare
- Optional Settings:
- Change the
Output folder
andOutput file type
. - Name your new Excel file
Output file (.vcf)
. - Mark/unmark
Discordant Comparison
. Check this to output differences instead of commonities.
- Change the
An Excel or VCF file will be created in the chosen output folder with multiple spreadsheets containing common/different positions of the VCF files. If VCF is selected as output type, each VCF file will contain its commonities/differences.
- Input file name must not contain illegal characters like
.
:
or'
. - Metadata lines in a VCF file should begin with
##
and headers line should begin with#
, following the standard VCF file format. - The first header cell is designated for chromosomes and the second for positions, as commonly formatted in VCF files. However, the names of these headers can be customized.
- It is best not to alter or change the VCF file before processing it to avoid potential errors.
Click the gear icon on the top right corner, next to the (i) button, to open the DevConsole window. Here, you can see every operation done. In case of an unexpected error, open the dev console to check if your file is being processed correctly, or print the console log to share it with others.
App icon by: Healthcare and medical icons created by Muhammad_Usman - Flaticon
For any questions or support, contact: bsayitoglu@gmail.com