|
Size: 12772
Comment:
|
← Revision 18 as of 2025-11-27 09:32:30 ⇥
Size: 3132
Comment: Cleaning up the format of the table (removing empty lines between lines, changing with etc)
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| == File 706 == for uploading of genomic data in !GenoEx-GDE database. |
|
| Line 4: | Line 6: |
| == File 706 == for the upload of genomic data in !GenoEx-GDE database. |
Download the word version [[attachment:706file.docx|here|&do=get]] |
| Line 9: | Line 9: |
| ||<tablewidth="570px"width="259px" height="25px" style="border-top:1.00pt solid #000000;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0.49mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">'''Field Description ''' ||<width="131px" style="border-top:1.00pt solid #000000;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0.49mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">'''Format ''' ||<width="167px" style="border-top:1.00pt solid #000000;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0.49mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">'''Example ''' || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Record type ^1^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">integer 3 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">706 || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Breed of animal ^4^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">character 3 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">BSW || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Country of first registration of animal ^2^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">character 3 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">AUS || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Sex ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">character 1 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">M || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">ID number of animal ^5^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">alphanumeric 12 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">000000A12345 || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Organization sending this information ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">character ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">ANAFI || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">UUID ^6^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">alphanumeric 36 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">assigned automatically by gxprep.py program || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Genotyping laboratory ^7^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">character ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Weatherbys Ireland || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Sample ID ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">alphanumeric ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">S1234WI2001 || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Additional ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">for future reference ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm"> || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">Array identifier ^8^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">alphanumeric ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">54609_a || ||<tablewidth="570px"width="259px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">AB – Genotype for SNP Index 1 ^10^ ||<width="131px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">integer 1 ||<width="167px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">0 || ||<width="259px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">AB – Genotype for SNP Index 2 ^10^ ||<width="131px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">integer 1 ||<width="167px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">1 || ||<width="259px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">AB – Genotype for SNP Index … ^10^ ||<width="131px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">integer 1 ||<width="167px" style="border-top:none;border-bottom:none;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0mm;padding-left:0mm;padding-right:0.49mm">2 || ||<width="259px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">AB – Genotype for SNP Index n ^9,10^ ||<width="131px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">integer 1 ||<width="167px" style="border-top:none;border-bottom:1.00pt solid #000000;border-left:none;border-right:1.00pt solid #000000;padding-top:0mm;padding-bottom:0.49mm;padding-left:0mm;padding-right:0.49mm">5 || |
||<tablewidth="1000px">'''Field Description ''' ||'''Format ''' ||'''Example ''' || ||Record type ^1^ ||integer 3 ||706 || ||Breed of animal ^4^ ||character 3 ||BSW || ||Country of first registration of animal ^2^ ||character 3 ||AUS || ||Sex ||character 1 ||M || ||ID number of animal ^5^ ||alphanumeric 12 ||000000A12345 || ||Organization sending this information ||character ||ANAFI || ||UUID ^6^ ||alphanumeric 36 ||assigned automatically by gxprep.py program || ||Genotyping laboratory ^7^ ||character ||Weatherbys Ireland || ||Sample ID ^8^ ||alphanumeric ||S1234WI2001 || ||Additional ||for future reference || || ||Array identifier ^9^ ||alphanumeric ||54609_a || ||AB – Genotype for SNP Index 1 ^11^ ||integer 1 ||0 || ||AB – Genotype for SNP Index 2 ^11^ ||integer 1 ||1 || ||AB – Genotype for SNP Index … ^11^ ||integer 1 ||2 || ||AB – Genotype for SNP Index n ^10,11^ ||integer 1 ||5 || |
| Line 56: | Line 32: |
| 1. UUID, one for every uploaded genotype sequence. Additional information about generation of UUID can be found at https://wiki.interbull.org/public/uuid?action=print 1. Genotyping laboratory, among the ones listed in the "Laboratories" table available in the GenoEX-GDE System Data page https://genoex.org/display. If the laboratory is not listed in the table, a request should be sent to !GenoEx@slu.se 1. Array identifier, one of the listed in the "SNP Arrays" table ("Code" column) available in the !GenoEX-GDE System Data page https://genoex.org/display. |
1. UUID, one for every uploaded genotype sequence. Additional information about generation of UUID can be found [[https://interbull.org/ib/uuid_instructions_gde|here]]. 1. Genotyping laboratory, among the ones listed in the "Laboratories" table available in the !GenoEx-GDE System Data page https://genoex.org/display. If the laboratory is not listed in the table, a request should be sent to !GenoEx@slu.se 1. Sample ID. If unknown, use the word ''Missing'' as Sample ID 1. Array identifier, one of the listed in the "SNP Arrays" table ("Code" column) available in the !GenoEx-GDE System Data page https://genoex.org/display. |
| Line 72: | Line 49: |
=== upload of 706 file === In order to upload the files to !GenoEX-GDE database, file containing genomic data in 706 format has to be zipped. Zip format is the only one accepted by GenoEX-GDE database for the upload. Zip file can be created using the support program gxprep.py as described here: https://wiki.interbull.org/public/GDE_gxprep_manual#zip_example If the User creates the zip file without using the support program gxprep.py, please make sure that the file containing genotypes in 706 format and compressed in the zip archive has name "genotypes.csv". |
==== 706 upload ==== In order to upload genomic data to !GenoEx-GDE database, the file in 706 format has to be zipped. Zip format is the only one accepted by !GenoEx-GDE database for the upload. Zip file can be created using the support program gxprep.py as described here: [[https://interbull.org/ib/gde_gxprep_manual#zip_example|https://interbull.org/ib/gde_gxprep_manual]](#zip_example) If the User creates the zip file without using the support program gxprep.py, please make sure that the file containing genotypes in 706 format and compressed in the zip archive has name '''genotypes.csv'''. |
File 706
for uploading of genomic data in GenoEx-GDE database.
Download the word version here
706 format
Field Description |
Format |
Example |
Record type 1 |
integer 3 |
706 |
Breed of animal 4 |
character 3 |
BSW |
Country of first registration of animal 2 |
character 3 |
AUS |
Sex |
character 1 |
M |
ID number of animal 5 |
alphanumeric 12 |
000000A12345 |
Organization sending this information |
character |
ANAFI |
UUID 6 |
alphanumeric 36 |
assigned automatically by gxprep.py program |
Genotyping laboratory 7 |
character |
Weatherbys Ireland |
Sample ID 8 |
alphanumeric |
S1234WI2001 |
Additional |
for future reference |
|
Array identifier 9 |
alphanumeric |
54609_a |
AB – Genotype for SNP Index 1 11 |
integer 1 |
0 |
AB – Genotype for SNP Index 2 11 |
integer 1 |
1 |
AB – Genotype for SNP Index … 11 |
integer 1 |
2 |
AB – Genotype for SNP Index n 10,11 |
integer 1 |
5 |
- Record type is always 706 for this File Format
- ISO 3166-1 alpha-3 codes (3 characters, capital letters)
- Breed of evaluation (3 characters, capital letters, BSW, GUE, HOL, JER, RDC, SIM)
- Breed of animal (3 characters, capital letters)
- Alpha-numerical, Interbull standard, always 12 characters long
UUID, one for every uploaded genotype sequence. Additional information about generation of UUID can be found here.
Genotyping laboratory, among the ones listed in the "Laboratories" table available in the GenoEx-GDE System Data page https://genoex.org/display. If the laboratory is not listed in the table, a request should be sent to GenoEx@slu.se
Sample ID. If unknown, use the word Missing as Sample ID
Array identifier, one of the listed in the "SNP Arrays" table ("Code" column) available in the GenoEx-GDE System Data page https://genoex.org/display.
- n is equal to the number of SNPs reported in the stem of the Array identifier
coded SNP values written as a continuous string.
Acceptable values depend on the Illumina coded allele values, according to the following:
BB→0 AB→1 AA→2 ‘unknown’→5
706 example
706;BSW;ITA;M;000000A12345;ANARB;09c98b1e-6af8-4254-9768-58d7cd1ddafd;Weatherbys Ireland;S1234WI2001;;54609_a;021010…
706 upload
In order to upload genomic data to GenoEx-GDE database, the file in 706 format has to be zipped. Zip format is the only one accepted by GenoEx-GDE database for the upload. Zip file can be created using the support program gxprep.py as described here: https://interbull.org/ib/gde_gxprep_manual(#zip_example) If the User creates the zip file without using the support program gxprep.py, please make sure that the file containing genotypes in 706 format and compressed in the zip archive has name genotypes.csv.