RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 36 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1108009 · 36 ✖

analysis 1

  • blastn · 36 ✖
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
212969 212969 PRJNA1108009_P_NODE_22241_length_269_cov_2.556122_g21923_i0 PRJNA1108009 22241 269 2.556122 6.87596818 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g21923 i0 94.595 0.550185873605948 37 0 13 2 78 112 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
1020343 1020343 PRJNA1108009_P_NODE_10661_length_412_cov_1.926254_g10343_i0 PRJNA1108009 10661 412 1.926254 7.93616648 Metazoa 33208 Arthropoda Arthropoda 52.8 0.04   NTclustered gi|1894961536|ref|XM_035930693.1| 7167 g10343 i0 100 0.483009708737864 28 0 7 0 151 178 1600 1573 PREDICTED: Anopheles albimanus ell-associated factor Eaf-like (LOC118463814), transcript variant X2, mRNA blastn 199 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
1020449 1020449 PRJNA1108009_P_NODE_4741_length_640_cov_5.349206_g4434_i0 PRJNA1108009 4741 640 5.349206 34.2349184 Chironomus 7150 Arthropoda Arthropoda 1096 0   NTclustered gi|2485418712|gb|OQ813480.1| 7152 g4434 i0 97.377 101.4984375 648 9 100 2 1 640 1283 1930 Chironomus sp. isolate OVO4158 small subunit ribosomal RNA gene, partial sequence blastn 64959 1103 0.99365367180417 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
1487559 1487559 PRJNA1108009_P_NODE_18042_length_306_cov_1.017167_g17724_i0 PRJNA1108009 18042 306 1.017167 3.11253102 Drosophila grimshawi 7222 Arthropoda Arthropoda 62.1 4.74e-5   NTclustered gi|1820264708|ref|XM_001991809.2| 7222 g17724 i0 97.222 0.738562091503268 36 1 12 0 150 185 2353 2388 PREDICTED: Drosophila grimshawi basic proline-rich protein (LOC6564979), mRNA blastn 226 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
1487860 1487860 PRJNA1108009_P_NODE_31122_length_242_cov_0.911243_g30804_i0 PRJNA1108009 31122 242 0.911243 2.20520806 Caligus clemensi 344056 Arthropoda Arthropoda 167 7.46e-37   NTclustered gi|225718733|gb|BT080789.1| 344056 g30804 i0 80.631 4.97107438016529 222 37 90 4 3 221 314 96 Caligus clemensi clone ccle-evs-509-311 Ras-related protein Rab-2 putative mRNA, complete cds blastn 1203 167 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus clemensi
2763686 2763686 PRJNA1108009_P_NODE_22543_length_267_cov_1.216495_g22225_i0 PRJNA1108009 22543 267 1.216495 3.24804165 Contarinia nasturtii 265458 Arthropoda Arthropoda 276 1.33e-69   NTclustered gi|1779629115|ref|XM_031764441.1| 265458 g22225 i0 88.596 0.853932584269663 228 24 85 2 41 267 1970 1744 PREDICTED: Contarinia nasturtii larval serum protein 2-like (LOC116338896), mRNA blastn 228 276 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
7398254 7398254 PRJNA1108009_P_NODE_14926_length_341_cov_1.604478_g14608_i0 PRJNA1108009 14926 341 1.604478 5.47126998 Chironomus 7150 Arthropoda Arthropoda 608 1.5199999999999993e-169   NTclustered gi|2486656239|gb|OQ819027.1| 7152 g14608 i0 98.827 91.950146627566 341 4 100 0 1 341 367 27 Chironomus sp. isolate OVO4158 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 31355 614 0.990228013029316 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
7398367 7398367 PRJNA1108009_P_NODE_8526_length_469_cov_1.361111_g8209_i0 PRJNA1108009 8526 469 1.361111 6.38361059 Opisthokonta 33154 Arthropoda Arthropoda 340 8.689999999999999e-89   NTclustered gi|1948417695|emb|OE002687.1| 61484 g8209 i0 80.813 97.9019189765458 443 77 94 7 20 458 66255 65817 4_Tte_b3v08 blastn 45916 342 0.994152046783626 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
7865600 7865600 PRJNA1108009_P_NODE_17247_length_314_cov_1.190871_g16929_i0 PRJNA1108009 17247 314 1.190871 3.73933494 Chelidurella thaleri 2546182 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2919607699|emb|OZ238405.1| 2546182 g16929 i0 97.059 0.10828025477707 34 0 11 1 16 49 4808165 4808197 Chelidura thaleri genome assembly, chromosome: 6 blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
7865977 7865977 PRJNA1108009_P_NODE_31647_length_241_cov_0.916667_g31329_i0 PRJNA1108009 31647 241 0.916667 2.20916747 Chironomus tepperi 113505 Arthropoda Arthropoda 342 1.1499999999999999e-89   NTclustered gi|2874202739|ref|XM_070635122.1| 113505 g31329 i0 92.797 42.5601659751037 236 17 98 0 6 241 417 182 PREDICTED: Chironomus tepperi ribosomal protein L4 (RpL4), mRNA blastn 10257 342 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
9140393 9140393 PRJNA1108009_P_NODE_14628_length_345_cov_1.261029_g14310_i0 PRJNA1108009 14628 345 1.261029 4.35055005 Liposcelis bostrychophila 185214 Arthropoda Arthropoda 616 9.229999999999999e-172   NTclustered gi|2210637305|gb|MT106115.1| 185214 g14310 i0 98.844 54.0376811594203 346 3 100 1 1 345 7983 7638 Liposcelis bostrychophila strain Berlin chromosome 1 mitochondrion, complete sequence blastn 18643 616 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis bostrychophila
9140669 9140669 PRJNA1108009_P_NODE_25328_length_250_cov_0.971751_g25010_i0 PRJNA1108009 25328 250 0.971751 2.4293775 Dalotia coriaria 877792 Arthropoda Arthropoda 215 2.73e-51   NTclustered gi|2732274778|ref|XM_065315869.1| 877792 g25010 i0 82.52 50.708 246 41 98 2 2 246 590 834 PREDICTED: Atheta coriaria rRNA 2'-O-methyltransferase fibrillarin-like (LOC135802303), mRNA blastn 12677 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
10416201 10416201 PRJNA1108009_P_NODE_14149_length_351_cov_1.107914_g13831_i0 PRJNA1108009 14149 351 1.107914 3.88877814 Timema douglasi 61478 Arthropoda Arthropoda 58.4 7.13e-4   NTclustered gi|1937045675|emb|OA572143.1| 61478 g13831 i0 97.059 2.94586894586895 34 1 10 0 278 311 18763 18730 1_Tdi_b3v08 blastn 1034 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
10416241 10416241 PRJNA1108009_P_NODE_15569_length_333_cov_1.142308_g15251_i0 PRJNA1108009 15569 333 1.142308 3.80388564 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g15251 i0 100 0.0840840840840841 28 0 8 0 275 302 14100628 14100601 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
10416615 10416615 PRJNA1108009_P_NODE_31029_length_242_cov_0.911243_g30711_i0 PRJNA1108009 31029 242 0.911243 2.20520806 Ixodes scapularis 6945 Arthropoda Arthropoda 60.2 1.3e-4   NTclustered gi|2064639269|ref|XM_042289145.1| 6945 g30711 i0 97.143 2.66942148760331 35 1 14 0 100 134 2336 2302 PREDICTED: Ixodes scapularis multiple C2 and transmembrane domain-containing protein 1 (LOC8051326), mRNA blastn 646 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
10416742 10416742 PRJNA1108009_P_NODE_6849_length_529_cov_1.622807_g6536_i0 PRJNA1108009 6849 529 1.6228070000000001 8.58464903 Chironomus flaviplumus 586673 Arthropoda Arthropoda 968 0   NTclustered gi|1820104501|gb|MN942954.1| 586673 g6536 i0 99.81 100.051039697543 527 1 99 0 3 529 280 806 Chironomus flaviplumus 18S small subunit ribosomal RNA gene, partial sequence blastn 52927 968 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus flaviplumus
11691414 11691414 PRJNA1108009_P_NODE_12590_length_375_cov_1.523179_g12272_i0 PRJNA1108009 12590 375 1.523179 5.71192125 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 60.2 2.13e-4   NTclustered gi|2918369770|emb|OZ237837.1| 1007376 g12272 i0 87.273 0.146666666666667 55 4 14 3 269 322 5854513 5854565 Pseudoterpna coronillaria genome assembly, chromosome: 12 blastn 55 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
11691633 11691633 PRJNA1108009_P_NODE_20350_length_285_cov_1.051887_g20032_i0 PRJNA1108009 20350 285 1.051887 2.99787795 Anopheles coustani 139045 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2548924941|ref|XM_058268309.1| 139045 g20032 i0 100 0.0982456140350877 28 0 10 0 20 47 598 571 PREDICTED: Anopheles coustani uncharacterized LOC131265983 (LOC131265983), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles coustani
11691678 11691678 PRJNA1108009_P_NODE_22250_length_269_cov_1.959184_g21932_i0 PRJNA1108009 22250 269 1.959184 5.27020496 Copidosoma floridanum 29053 Arthropoda Arthropoda 137 6.61e-28   NTclustered gi|936562920|ref|XM_014360548.1| 29053 g21932 i0 86.614 1.95167286245353 127 13 46 4 16 140 781 657 PREDICTED: Copidosoma floridanum serine/arginine-rich splicing factor 1B (LOC106644852), transcript variant X2, mRNA blastn 525 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Encyrtidae Copidosoma Copidosoma floridanum
11691759 11691759 PRJNA1108009_P_NODE_25450_length_250_cov_0.870056_g25132_i0 PRJNA1108009 25450 250 0.870056 2.17514 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2782895951|ref|XM_067133573.1| 79674 g25132 i0 100 0.236 30 0 12 0 37 66 113 142 PREDICTED: Macrobrachium rosenbergii mucin-2-like (LOC136856020), mRNA blastn 59 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
12966806 12966806 PRJNA1108009_P_NODE_21171_length_278_cov_1.575610_g20853_i0 PRJNA1108009 21171 278 1.57561 4.3801958 Drosophila melanogaster 7227 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1813375|dbj|D86546.1| 7227 g20853 i0 96.97 0.118705035971223 33 1 12 0 136 168 880 912 Drosophila melanogaster mRNA for still life type 2, complete cds blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
12967221 12967221 PRJNA1108009_P_NODE_9151_length_450_cov_1.899204_g8833_i0 PRJNA1108009 9151 450 1.899204 8.546418 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.044   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g8833 i0 100 0.0622222222222222 28 0 6 0 409 436 5916400 5916427 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
15048184 15048184 PRJNA1108009_P_NODE_19452_length_292_cov_1.168950_g19134_i0 PRJNA1108009 19452 292 1.16895 3.413334 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 246 1.16e-60   NTclustered gi|2874230810|ref|XM_070650149.1| 113505 g19134 i0 83.032 94.6267123287671 277 41 94 6 1 274 450 723 PREDICTED: Chironomus tepperi actin, muscle-like (LOC139098036), mRNA blastn 27631 248 0.991935483870968 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
15515417 15515417 PRJNA1108009_P_NODE_15293_length_336_cov_2.174905_g14975_i0 PRJNA1108009 15293 336 2.174905 7.3076808 Satyrium ilicis 876074 Arthropoda Arthropoda 52.8 0.032   NTclustered gi|2918386088|emb|OZ238121.1| 876074 g14975 i0 100 0.0833333333333333 28 0 8 0 25 52 23317845 23317818 Satyrium ilicis genome assembly, chromosome: 12 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
15515545 15515545 PRJNA1108009_P_NODE_20213_length_286_cov_1.084507_g19895_i0 PRJNA1108009 20213 286 1.084507 3.10169002 Contarinia nasturtii 265458 Arthropoda Arthropoda 335 2.339999999999999e-87   NTclustered gi|1779648086|ref|XM_031774744.1| 265458 g19895 i0 88.462 5 286 21 100 5 1 286 2925 2652 PREDICTED: Contarinia nasturtii glycogenin-1-like (LOC116345417), transcript variant X1, mRNA blastn 1430 335 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
15515982 15515982 PRJNA1108009_P_NODE_9033_length_454_cov_1.624672_g8715_i0 PRJNA1108009 9033 454 1.624672 7.37601088 Contarinia nasturtii 265458 Arthropoda Arthropoda 211 6.86e-50   NTclustered gi|1779628449|ref|XM_031764077.1| 265458 g8715 i0 80.456 1.00881057268722 307 34 65 15 93 386 1054 1347 PREDICTED: Contarinia nasturtii extensin-like (LOC116338668), mRNA blastn 458 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
16789816 16789816 PRJNA1108009_P_NODE_11834_length_389_cov_1.183544_g11516_i0 PRJNA1108009 11834 389 1.183544 4.60398616 Agapeta hamana 1100904 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g11516 i0 94.286 0.089974293059126 35 2 9 0 221 255 16934838 16934804 Agapeta hamana genome assembly, chromosome: 4 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
16789820 16789820 PRJNA1108009_P_NODE_12074_length_385_cov_0.987179_g11756_i0 PRJNA1108009 12074 385 0.987179 3.80063915 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.037   NTclustered gi|2919608728|emb|OZ238409.1| 2546182 g11756 i0 100 0.0727272727272727 28 0 7 0 21 48 12720701 12720728 Chelidura thaleri genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
18064339 18064339 PRJNA1108009_P_NODE_11515_length_394_cov_3.239875_g11197_i0 PRJNA1108009 11515 394 3.239875 12.7651075 Drosophila albomicans 7291 Arthropoda Arthropoda 320 9.36e-83   NTclustered gi|2328675983|ref|XM_034255271.2| 7291 g11197 i0 84.132 79.6040609137056 334 50 85 1 50 383 150 480 PREDICTED: Drosophila albomicans 40S ribosomal protein S23 (LOC117572440), mRNA blastn 31364 320 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila albomicans
19338804 19338804 PRJNA1108009_P_NODE_21116_length_279_cov_1.121359_g20798_i0 PRJNA1108009 21116 279 1.121359 3.12859161 Drymonia dodonaea 988176 Arthropoda Arthropoda 52.8 0.026   NTclustered gi|2918369756|emb|OZ237822.1| 988176 g20798 i0 100 0.100358422939068 28 0 10 0 204 231 4890525 4890552 Drymonia dodonaea genome assembly, chromosome: 29 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Notodontidae Drymonia Drymonia dodonaea
21422472 21422472 PRJNA1108009_P_NODE_12217_length_382_cov_1.915858_g11899_i0 PRJNA1108009 12217 382 1.915858 7.31857756 Chironomus 7150 Arthropoda Arthropoda 684 0   NTclustered gi|12141795|emb|AJ279431.1| 27468 g11899 i0 98.953 74.130890052356 382 4 100 0 1 382 134 515 Chironomus luridus partial 28S rRNA gene, partial 18S rRNA gene and intergenic spacer (IGS), clone lurIGS 5 blastn 28318 684 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus luridus
21889814 21889814 PRJNA1108009_P_NODE_24498_length_252_cov_1.229050_g24180_i0 PRJNA1108009 24498 252 1.22905 3.097206 Penaeus vannamei 6689 Arthropoda Arthropoda 163 1.01e-35   NTclustered gi|48766850|gb|AY645906.1| 6689 g24180 i0 78.486 83.234126984127 251 52 99 2 1 250 1310 1061 Litopenaeus vannamei heat shock protein 70 gene, complete cds blastn 20975 163 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
21889876 21889876 PRJNA1108009_P_NODE_26898_length_248_cov_0.880000_g26580_i0 PRJNA1108009 26898 248 0.88 2.1824 Notodromas monacha 399045 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1937999148|emb|OA883720.1| 399045 g26580 i0 100 0.116935483870968 29 0 12 0 205 233 37369 37397 Notodromas monacha blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
22697409 22697409 PRJNA1108009_P_NODE_13898_length_354_cov_2.128114_g13580_i0 PRJNA1108009 13898 354 2.128114 7.53352356 Chironomus 7150 Arthropoda Arthropoda 621 2.04e-173   NTclustered gi|2486656239|gb|OQ819027.1| 7152 g13580 i0 98.305 96.6949152542373 354 6 100 0 1 354 1943 2296 Chironomus sp. isolate OVO4158 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 34230 627 0.990430622009569 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus sp.
22697453 22697453 PRJNA1108009_P_NODE_22138_length_270_cov_1.827411_g21820_i0 PRJNA1108009 22138 270 1.827411 4.9340097 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 54.7 0.007   NTclustered gi|2837469607|ref|XM_069336193.1| 6728 g21820 i0 100 2.47037037037037 29 0 11 0 232 260 923 951 PREDICTED: Procambarus clarkii mucin-2-like (LOC123750712), mRNA blastn 667 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
24439255 24439255 PRJNA1108009_P_NODE_8240_length_478_cov_1.439506_g7923_i0 PRJNA1108009 8240 478 1.439506 6.88083868 Samia ricini 63990 Arthropoda Arthropoda 52.8 0.047   NTclustered gi|2883229729|dbj|AP038898.1| 63990 g7923 i0 96.875 0.0669456066945607 32 0 6 1 105 135 3256762 3256731 Samia ricini White GU1 DNA, chromosome 03, complete sequence blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Saturniidae Samia Samia ricini

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);;