RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

37 rows where analysis = "blastn", bioproject = "PRJNA688352" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 37 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688352 · 37 ✖

analysis 1

  • blastn · 37 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
1176751 1176751 PRJNA688352_P_NODE_141_length_1454_cov_3.883418_g109_i0 PRJNA688352 141 1454 3.883418 56.46489772 Artemia 6660 Arthropoda Arthropoda 2669 0   NTclustered gi|2329659205|gb|OP250146.1| 351233 g109 i0 99.794 93.5385144429161 1454 3 100 0 1 1454 2841 1388 Artemia tibetiana mitochondrion, complete genome blastn 136005 2669 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
1176812 1176812 PRJNA688352_P_NODE_6441_length_261_cov_2.138298_g6338_i0 PRJNA688352 6441 261 2.138298 5.58095778 Sciaridae 7184 Arthropoda Arthropoda 470 5.539999999999998e-128   NTclustered gi|422898859|gb|JQ613602.1| 335710 g6338 i0 99.231 99.5862068965517 260 2 99 0 1 260 48 307 Bradysia difformis voucher 122 18S ribosomal RNA gene, partial sequence blastn 25992 470 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia impatiens
1942859 1942859 PRJNA688352_P_NODE_3282_length_341_cov_1.716418_g3179_i0 PRJNA688352 3282 341 1.716418 5.85298538 Bradysia amoena 560708 Arthropoda Arthropoda 625 1.5099999999999995e-174   NTclustered gi|202070883|gb|FJ040522.1| 560708 g3179 i0 99.707 55.8123167155425 341 1 100 0 1 341 3471 3811 Bradysia amoena 28S ribosomal RNA gene, partial sequence blastn 19032 625 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia amoena
2452033 2452033 PRJNA688352_P_NODE_4502_length_303_cov_1.078261_g4399_i0 PRJNA688352 4502 303 1.078261 3.26713083 Timema 61471 Arthropoda Arthropoda 52.8 0.028   NTclustered gi|1946912840|emb|OC317663.1| 61476 g4399 i0 100 0.184818481848185 28 0 9 0 26 53 8416 8443 3_Tce_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
3217732 3217732 PRJNA688352_P_NODE_10643_length_244_cov_0.900585_g10540_i0 PRJNA688352 10643 244 0.900585 2.1974274 Procambarus clarkii 6728 Arthropoda Arthropoda 451 1.86e-122   NTclustered gi|2837491178|ref|XM_045765645.2| 6728 g10540 i0 100 60.6393442622951 244 0 100 0 1 244 9856 9613 PREDICTED: Procambarus clarkii Ubiquitin specific protease 8 (LOC123772458), transcript variant X2, mRNA blastn 14796 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
3217776 3217776 PRJNA688352_P_NODE_4563_length_301_cov_2.789474_g4460_i0 PRJNA688352 4563 301 2.789474 8.39631674 Artemia franciscana 6661 Arthropoda Arthropoda 529 1.0599999999999996e-145   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g4460 i0 98.339 52.2790697674419 301 5 100 0 1 301 38 338 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 15736 529 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
3217809 3217809 PRJNA688352_P_NODE_7903_length_250_cov_0.870056_g7800_i0 PRJNA688352 7903 250 0.870056 2.17514 Procambarus clarkii 6728 Arthropoda Arthropoda 462 8.83e-126   NTclustered gi|2837464100|ref|XR_011227718.1| 6728 g7800 i0 100 93.772 250 0 100 0 1 250 2352 2103 PREDICTED: Procambarus clarkii large subunit ribosomal RNA (LOC138362496), rRNA blastn 23443 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
3728594 3728594 PRJNA688352_P_NODE_6503_length_260_cov_2.278075_g6400_i0 PRJNA688352 6503 260 2.278075 5.922995 Artemia 6660 Arthropoda Arthropoda 472 1.53e-128   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g6400 i0 99.612 99.0423076923077 258 1 99 0 3 260 2159 1902 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 25751 472 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
3728597 3728597 PRJNA688352_P_NODE_663_length_729_cov_3.080793_g570_i0 PRJNA688352 663 729 3.080793 22.45898097 Artemia 6660 Arthropoda Arthropoda 1345 0   NTclustered gi|511347781|ref|NC_021383.1| 351233 g570 i0 100 69.6584362139918 728 0 99 0 1 728 10302 11029 Artemia tibetiana mitochondrion, complete genome blastn 50781 1345 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
4494803 4494803 PRJNA688352_P_NODE_424_length_916_cov_13.347568_g346_i0 PRJNA688352 424 916 13.347568 122.26372288 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 0.002   NTclustered gi|1048003915|ref|XM_017627148.1| 28612 g346 i0 100 0.0338427947598253 31 0 3 0 268 298 738 708 PREDICTED: Rhagoletis zephyria uncharacterized LOC108371558 (LOC108371558), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
6280702 6280702 PRJNA688352_P_NODE_12725_length_231_cov_3.518987_g12622_i0 PRJNA688352 12725 231 3.518987 8.12885997 Artemia 6660 Arthropoda Arthropoda 425 1.0599999999999999e-114   NTclustered gi|511347781|ref|NC_021383.1| 351233 g12622 i0 100 67.987012987013 230 0 99 0 1 230 3220 3449 Artemia tibetiana mitochondrion, complete genome blastn 15705 425 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
7045513 7045513 PRJNA688352_P_NODE_3426_length_336_cov_2.338403_g3323_i0 PRJNA688352 3426 336 2.338403 7.85703408 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.032   NTclustered gi|1965352161|emb|OE839429.1| 629358 g3323 i0 100 0.0833333333333333 28 0 8 0 272 299 207360 207387 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
10105360 10105360 PRJNA688352_P_NODE_1488_length_487_cov_1.647343_g1385_i0 PRJNA688352 1488 487 1.647343 8.02256041 Artemia 6660 Arthropoda Arthropoda 898 0   NTclustered gi|2329659177|gb|OP250144.1| 351233 g1385 i0 100 50.564681724846 486 0 99 0 1 486 4760 5245 Artemia tibetiana mitochondrion, complete genome blastn 24625 898 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
10870877 10870877 PRJNA688352_P_NODE_10369_length_245_cov_0.895349_g10266_i0 PRJNA688352 10369 245 0.895349 2.19360505 Artemia franciscana 6661 Arthropoda Arthropoda 392 1.15e-104   NTclustered gi|2743050708|ref|XM_065721687.1| 6661 g10266 i0 95.51 37.134693877551 245 11 100 0 1 245 1252 1496 PREDICTED: Artemia franciscana repetitive organellar protein-like (LOC136038542), transcript variant X9, mRNA blastn 9098 392 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10870906 10870906 PRJNA688352_P_NODE_2209_length_403_cov_2.475758_g2106_i0 PRJNA688352 2209 403 2.475758 9.97730474 Artemia tibetiana 351233 Arthropoda Arthropoda 739 0   NTclustered gi|2329659177|gb|OP250144.1| 351233 g2106 i0 99.752 41.5409429280397 403 1 100 0 1 403 11233 11635 Artemia tibetiana mitochondrion, complete genome blastn 16741 739 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
10870933 10870933 PRJNA688352_P_NODE_5829_length_273_cov_3.850000_g5726_i0 PRJNA688352 5829 273 3.85 10.5105 Zerene cesonia 33412 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1949872336|ref|XM_038362308.1| 33412 g5726 i0 100 0.102564102564103 28 0 10 0 49 76 2539 2566 Zerene cesonia uncharacterized protein LOC119836831 (LOC119836831), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Zerene Zerene cesonia
11380264 11380264 PRJNA688352_P_NODE_3969_length_318_cov_1.257143_g3866_i0 PRJNA688352 3969 318 1.257143 3.99771474 root 1 Root_unresolved Root_unresolved 54.7 0.008   NTclustered gi|2863530859|ref|XM_070083067.1| 27406 g3866 i0 100 5.94968553459119 29 0 9 0 4 32 3642 3614 PREDICTED: Cherax quadricarinatus major facilitator superfamily domain-containing protein 4A-like (LOC128704746), mRNA blastn 1892 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Parastacidae Cherax Cherax quadricarinatus
11380288 11380288 PRJNA688352_P_NODE_5269_length_284_cov_2.957346_g5166_i0 PRJNA688352 5269 284 2.957346 8.39886264 Chironomus 7150 Arthropoda Arthropoda 492 1.2999999999999999e-134   NTclustered gi|2485418712|gb|OQ813480.1| 7152 g5166 i0 98.221 95.8978873239437 281 5 99 0 1 281 1803 1523 Chironomus sp. isolate OVO4158 small subunit ribosomal RNA gene, partial sequence blastn 27235 492 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
11380291 11380291 PRJNA688352_P_NODE_549_length_802_cov_4.126200_g462_i0 PRJNA688352 549 802 4.1262 33.092124 Artemia 6660 Arthropoda Arthropoda 1471 0   NTclustered gi|511347781|ref|NC_021383.1| 351233 g462 i0 99.751 38.2618453865337 802 2 100 0 1 802 3781 4582 Artemia tibetiana mitochondrion, complete genome blastn 30686 1471 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
12146285 12146285 PRJNA688352_P_NODE_6970_length_251_cov_3.612360_g6867_i0 PRJNA688352 6970 251 3.61236 9.0670236 Diuraphis noxia 143948 Arthropoda Arthropoda 52.8 0.023   NTclustered gi|985407829|ref|XM_015514248.1| 143948 g6867 i0 96.875 0.127490039840637 32 0 12 1 203 233 1454 1423 PREDICTED: Diuraphis noxia acyl-CoA:lysophosphatidylglycerol acyltransferase 1-like (LOC107165842), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
12656155 12656155 PRJNA688352_P_NODE_1970_length_423_cov_2.214286_g1867_i0 PRJNA688352 1970 423 2.214286 9.36642978 Artemia 6660 Arthropoda Arthropoda 778 0   NTclustered gi|2329659177|gb|OP250144.1| 351233 g1867 i0 100 26.612293144208 421 0 99 0 1 421 8954 8534 Artemia tibetiana mitochondrion, complete genome blastn 11257 778 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
13420848 13420848 PRJNA688352_P_NODE_4971_length_291_cov_2.018349_g4868_i0 PRJNA688352 4971 291 2.018349 5.87339559 Artemia franciscana 6661 Arthropoda Arthropoda 444 3.8099999999999997e-120   NTclustered gi|2743044893|ref|XM_065718665.1| 6661 g4868 i0 94.444 1.97938144329897 288 16 99 0 1 288 4786 4499 PREDICTED: Artemia franciscana uncharacterized LOC136036431 (LOC136036431), transcript variant X2, mRNA blastn 576 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
15969576 15969576 PRJNA688352_P_NODE_3293_length_341_cov_1.149254_g3190_i0 PRJNA688352 3293 341 1.149254 3.91895614 Artemia franciscana 6661 Arthropoda Arthropoda 564 3.349999999999999e-156   NTclustered gi|2743079830|ref|XM_065709204.1| 6661 g3190 i0 97.015 1.96480938416422 335 10 98 0 1 335 533 867 PREDICTED: Artemia franciscana protein obstructor-E-like (LOC136030311), transcript variant X1, mRNA blastn 670 564 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
15969583 15969583 PRJNA688352_P_NODE_4033_length_316_cov_1.419753_g3930_i0 PRJNA688352 4033 316 1.419753 4.48641948 Cerastipsocus sp. JRC-2012 1225570 Arthropoda Arthropoda 285 2.6799999999999996e-72   NTclustered gi|406822843|gb|JN797309.1| 1225570 g3930 i0 83.758 96.746835443038 314 37 99 10 3 316 303 4 Cerastipsocus sp. JRC-2012 28S ribosomal RNA gene, partial sequence blastn 30572 285 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Psocidae Cerastipsocus Cerastipsocus sp. JRC-2012
17244835 17244835 PRJNA688352_P_NODE_4314_length_308_cov_1.774468_g4211_i0 PRJNA688352 4314 308 1.774468 5.46536144 Artemia franciscana 6661 Arthropoda Arthropoda 508 1.42e-139   NTclustered gi|2743049859|ref|XM_065721253.1| 6661 g4211 i0 96.429 2.90909090909091 308 11 100 0 1 308 465 158 PREDICTED: Artemia franciscana large ribosomal subunit protein P1 (LOC136038176), mRNA blastn 896 508 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
17244850 17244850 PRJNA688352_P_NODE_6974_length_251_cov_3.258427_g6871_i0 PRJNA688352 6974 251 3.258427 8.17865177 Artemia tibetiana 351233 Arthropoda Arthropoda 464 2.47e-126   NTclustered gi|2329659177|gb|OP250144.1| 351233 g6871 i0 100 50.8605577689243 251 0 100 0 1 251 11976 11726 Artemia tibetiana mitochondrion, complete genome blastn 12766 464 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
17754584 17754584 PRJNA688352_P_NODE_4134_length_313_cov_3.033333_g4031_i0 PRJNA688352 4134 313 3.033333 9.49433229 Artemia 6660 Arthropoda Arthropoda 579 1.0899999999999999e-160   NTclustered gi|511347781|ref|NC_021383.1| 351233 g4031 i0 100 26.8913738019169 313 0 100 0 1 313 787 475 Artemia tibetiana mitochondrion, complete genome blastn 8417 579 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
18518953 18518953 PRJNA688352_P_NODE_3195_length_345_cov_1.694853_g3092_i0 PRJNA688352 3195 345 1.694853 5.84724285 Artemia franciscana 6661 Arthropoda Arthropoda 568 2.6199999999999992e-157   NTclustered gi|2743045490|ref|XM_065718990.1| 6661 g3092 i0 96.501 4.19420289855072 343 12 99 0 1 343 609 267 PREDICTED: Artemia franciscana compound eye opsin BCRH1-like (LOC136036679), mRNA blastn 1447 568 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
18518956 18518956 PRJNA688352_P_NODE_3775_length_323_cov_2.032000_g3672_i0 PRJNA688352 3775 323 2.032 6.56336 Artemia franciscana 6661 Arthropoda Arthropoda 536 6.87e-148   NTclustered gi|2743045494|ref|XM_065718992.1| 6661 g3672 i0 96.594 5.12693498452012 323 11 100 0 1 323 788 1110 PREDICTED: Artemia franciscana compound eye opsin BCRH2-like (LOC136036681), transcript variant X2, mRNA blastn 1656 536 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
19793812 19793812 PRJNA688352_P_NODE_7156_length_251_cov_0.865169_g7053_i0 PRJNA688352 7156 251 0.865169 2.17157419 Artemia sinica 112780 Arthropoda Arthropoda 200 7.679999999999999e-47   NTclustered gi|765368597|gb|KP162166.1| 112780 g7053 i0 97.458 0.470119521912351 118 2 47 1 1 117 1691 1574 Artemia sinica cell division cycle 20 (cdc20) mRNA, complete cds blastn 118 200 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia sinica
20303154 20303154 PRJNA688352_P_NODE_5156_length_287_cov_1.154206_g5053_i0 PRJNA688352 5156 287 1.154206 3.31257122 Artemia 6660 Arthropoda Arthropoda 525 1.2999999999999995e-144   NTclustered gi|2329659205|gb|OP250146.1| 351233 g5053 i0 99.652 27 287 1 100 0 1 287 6549 6835 Artemia tibetiana mitochondrion, complete genome blastn 7749 525 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
21069340 21069340 PRJNA688352_P_NODE_7337_length_251_cov_0.865169_g7234_i0 PRJNA688352 7337 251 0.865169 2.17157419 Artemia franciscana 6661 Arthropoda Arthropoda 401 1.9599999999999993e-107   NTclustered gi|2743033989|ref|XM_065713232.1| 6661 g7234 i0 95.6 0.99601593625498 250 11 99 0 1 250 353 602 PREDICTED: Artemia franciscana uncharacterized LOC136032824 (LOC136032824), mRNA blastn 250 401 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
21578962 21578962 PRJNA688352_P_NODE_3037_length_352_cov_2.551971_g2934_i0 PRJNA688352 3037 352 2.551971 8.98293792 Artemia 6660 Arthropoda Arthropoda 649 0   NTclustered gi|511347781|ref|NC_021383.1| 351233 g2934 i0 100 77.4232954545455 351 0 99 0 2 352 10285 9935 Artemia tibetiana mitochondrion, complete genome blastn 27253 649 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia tibetiana
22344160 22344160 PRJNA688352_P_NODE_10678_length_244_cov_0.900585_g10575_i0 PRJNA688352 10678 244 0.900585 2.1974274 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2918386085|emb|OZ238118.1| 876074 g10575 i0 100 0.114754098360656 28 0 11 0 29 56 46925924 46925897 Satyrium ilicis genome assembly, chromosome: 9 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
23619689 23619689 PRJNA688352_P_NODE_11739_length_242_cov_0.911243_g11636_i0 PRJNA688352 11739 242 0.911243 2.20520806 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 60.2 1.3e-4   NTclustered gi|2920024240|emb|OZ239122.1| 3086104 g11636 i0 100 0.276859504132231 32 0 13 0 181 212 17139495 17139526 Leiobunum subalpinum genome assembly, chromosome: 5 blastn 67 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
23619710 23619710 PRJNA688352_P_NODE_2299_length_396_cov_3.309598_g2196_i0 PRJNA688352 2299 396 3.309598 13.10600808 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.038   NTclustered gi|2636206763|emb|OY979789.1| 52344 g2196 i0 100 0.0707070707070707 28 0 7 0 284 311 12978788 12978761 Helicoverpa assulta genome assembly, chromosome: 15 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
23619756 23619756 PRJNA688352_P_NODE_8199_length_249_cov_0.875000_g8096_i0 PRJNA688352 8199 249 0.875 2.17875 Artemia franciscana 6661 Arthropoda Arthropoda 261 3.44e-65   NTclustered gi|2743035581|ref|XM_065714048.1| 6661 g8096 i0 86.166 1.01606425702811 253 21 98 5 1 244 2563 2316 PREDICTED: Artemia franciscana peroxidasin homolog (LOC136033286), mRNA blastn 253 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;