contig_metadata
30 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Arthropoda"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5227168 | 5227168 | PRJEB58983_P_NODE_105_length_3083_cov_5.773754_g79_i0 | PRJEB58983 | 105 | 3083 | 5.773754 | 178.00483582 | Darwinula stevensoni | 69355 | Arthropoda | Arthropoda | 872 | 2.13e-291 | NR | CAD7251900.1 | 69355 | g79 | i0 | 66.1 | 0.609146934803763 | 626 | 174 | 60.9 | 1 | 3083 | 1206 | 135 | 722 | CAD7251900.1 unnamed protein product, partial [Darwinula stevensoni] | diamond | 1878 | 872 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 6502844 | 6502844 | PRJEB58983_P_NODE_10106_length_393_cov_2.143750_g9691_i0 | PRJEB58983 | 10106 | 393 | 2.14375 | 8.4249375 | Arthropoda | 6656 | Arthropoda | Arthropoda | 209 | 2.52e-65 | NR | XP_035791541.1 | 7167 | g9691 | i0 | 71.8 | 20 | 131 | 37 | 100 | 0 | 393 | 1 | 4 | 134 | XP_035791541.1 60S ribosomal protein L8 [Anopheles albimanus] | diamond | 7860 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Anopheles | Anopheles albimanus | |
| 10327928 | 10327928 | PRJEB58983_P_NODE_23869_length_270_cov_2.213198_g23454_i0 | PRJEB58983 | 23869 | 270 | 2.213198 | 5.9756346 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 145 | 2.63e-41 | NR | XP_046911115.1 | 6954 | g23454 | i0 | 70.8 | 10.8777777777778 | 89 | 26 | 98.9 | 0 | 269 | 3 | 82 | 170 | XP_046911115.1 60S ribosomal protein L8-like [Dermatophagoides farinae] | diamond | 2937 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides farinae | |
| 11603439 | 11603439 | PRJEB58983_P_NODE_29130_length_249_cov_4.034091_g28715_i0 | PRJEB58983 | 29130 | 249 | 4.034091 | 10.04488659 | Pollicipes pollicipes | 41117 | Arthropoda | Arthropoda | 126 | 2.2e-34 | NR | XP_037075409.1 | 41117 | g28715 | i0 | 72.3 | 3.85542168674699 | 83 | 21 | 98.8 | 2 | 2 | 247 | 56 | 137 | XP_037075409.1 LOW QUALITY PROTEIN: digestive cysteine proteinase 2-like [Pollicipes pollicipes] | diamond | 960 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Thecostraca | Pollicipedomorpha | Pollicipedidae | Pollicipes | Pollicipes pollicipes | |
| 16294708 | 16294708 | PRJEB58983_P_NODE_10873_length_380_cov_5.136808_g10458_i0 | PRJEB58983 | 10873 | 380 | 5.136808 | 19.5198704 | Coleoptera | 7041 | Arthropoda | Arthropoda | 117 | 1.58e-29 | NR | XP_018322541.1 | 224129 | g10458 | i0 | 54.5 | 11.6605263157895 | 123 | 40 | 97.1 | 1 | 372 | 4 | 84 | 190 | XP_018322541.1 40S ribosomal protein S6-like [Agrilus planipennis] | diamond | 4431 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Buprestidae | Agrilus | Agrilus planipennis | |
| 16701913 | 16701913 | PRJEB58983_P_NODE_9154_length_411_cov_6.269231_g8740_i0 | PRJEB58983 | 9154 | 411 | 6.2692310000000004 | 25.76653941 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 6.15e-43 | NR | EFX61290.1 | 6669 | g8740 | i0 | 62.5 | 1.86861313868613 | 128 | 48 | 93.4 | 0 | 411 | 28 | 49 | 176 | EFX61290.1 hypothetical protein DAPPUDRAFT_69961 [Daphnia pulex] | diamond | 768 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 17569966 | 17569966 | PRJEB58983_P_NODE_25594_length_262_cov_1.910053_g25179_i0 | PRJEB58983 | 25594 | 262 | 1.910053 | 5.00433886 | Lepeophtheirus salmonis | 72036 | Arthropoda | Arthropoda | 142 | 6.28e-41 | NR | ADD38729.1 | 72036 | g25179 | i0 | 76.5 | 4.87786259541985 | 85 | 20 | 97.3 | 0 | 258 | 4 | 72 | 156 | ADD38729.1 60S ribosomal protein L11 [Lepeophtheirus salmonis] | diamond | 1278 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis | |
| 26621987 | 26621987 | PRJEB58983_P_NODE_16781_length_313_cov_4.133333_g16366_i0 | PRJEB58983 | 16781 | 313 | 4.133333 | 12.93733229 | Agrilus planipennis | 224129 | Arthropoda | Arthropoda | 144 | 7.76e-40 | NR | XP_025833010.1 | 224129 | g16366 | i0 | 69.8 | 5.42492012779553 | 96 | 29 | 92 | 0 | 3 | 290 | 8 | 103 | XP_025833010.1 ADP,ATP carrier protein 1 [Agrilus planipennis] | diamond | 1698 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Buprestidae | Agrilus | Agrilus planipennis | |
| 26900349 | 26900349 | PRJEB58983_P_NODE_8061_length_436_cov_3.600551_g7647_i0 | PRJEB58983 | 8061 | 436 | 3.600551 | 15.69840236 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99 | 1.4599999999999995e-23 | NR | CAG4636732.1 | 186181 | g7647 | i0 | 45.9 | 3.6743119266055 | 133 | 56 | 91.5 | 1 | 422 | 24 | 7 | 123 | CAG4636732.1 EOG090X0NXS [Eubosmina coregoni] | diamond | 1602 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Bosminidae | Eubosmina | Eubosmina coregoni | |
| 27343146 | 27343146 | PRJEB58983_P_NODE_29303_length_249_cov_1.698864_g28888_i0 | PRJEB58983 | 29303 | 249 | 1.698864 | 4.23017136 | Arthropoda | 6656 | Arthropoda | Arthropoda | 42.7 | 0.0394 | NR | KAJ8682434.1 | 131215 | g28888 | i0 | 48.1 | 2.3855421686747 | 52 | 25 | 62.7 | 2 | 248 | 93 | 50 | 99 | KAJ8682434.1 hypothetical protein QAD02_018226 [Eretmocerus hayati] | diamond | 594 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Aphelinidae | Eretmocerus | Eretmocerus hayati | |
| 27444728 | 27444728 | PRJEB58983_P_NODE_28023_length_252_cov_3.648045_g27608_i0 | PRJEB58983 | 28023 | 252 | 3.648045 | 9.1930734 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 118 | 5.0399999999999993e-29 | NR | XP_002428198.1 | 121224 | g27608 | i0 | 63.4 | 1.95238095238095 | 82 | 30 | 97.6 | 0 | 251 | 6 | 314 | 395 | XP_002428198.1 thioredoxin reductase, putative [Pediculus humanus corporis] | diamond | 492 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 27469372 | 27469372 | PRJEB58983_P_NODE_8623_length_423_cov_3.911429_g8209_i0 | PRJEB58983 | 8623 | 423 | 3.911429 | 16.54534467 | Metazoa | 33208 | Arthropoda | Arthropoda | 108 | 3.5100000000000004e-27 | NR | XP_059090465.1 | 6832 | g8209 | i0 | 47.1 | 2.60283687943262 | 121 | 58 | 85.8 | 2 | 20 | 382 | 24 | 138 | XP_059090465.1 small ribosomal subunit protein eS12-like [Tigriopus californicus] | diamond | 1101 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Harpacticoida | Harpacticidae | Tigriopus | Tigriopus californicus | |
| 27563687 | 27563687 | PRJEB58983_P_NODE_10744_length_382_cov_7.058252_g10329_i0 | PRJEB58983 | 10744 | 382 | 7.058252 | 26.96252264 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.6 | 1.86e-21 | NR | CAG4642261.1 | 202080 | g10329 | i0 | 53 | 2.6544502617801 | 115 | 38 | 90.3 | 2 | 352 | 8 | 30 | 128 | CAG4642261.1 EOG090X0NXS [Eurycercus lamellatus] | diamond | 1014 | 94.4 | 0.991525423728813 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Eurycercidae | Eurycercus | Eurycercus lamellatus | |
| 27563690 | 27563690 | PRJEB58983_P_NODE_22684_length_276_cov_1.334975_g22269_i0 | PRJEB58983 | 22684 | 276 | 1.334975 | 3.684531 | Mesostigmata | 34634 | Arthropoda | Arthropoda | 74.3 | 4.5e-13 | NR | XP_022657939.1 | 109461 | g22269 | i0 | 44.6 | 3 | 92 | 50 | 100 | 1 | 1 | 276 | 686 | 776 | XP_022657939.1 coatomer subunit alpha-like isoform X2 [Varroa destructor] | diamond | 828 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa destructor | |
| 27658868 | 27658868 | PRJEB58983_P_NODE_12564_length_356_cov_1.530035_g12149_i0 | PRJEB58983 | 12564 | 356 | 1.530035 | 5.4469246 | Metazoa | 33208 | Arthropoda | Arthropoda | 69.3 | 4.22e-11 | NR | XP_019872418.1 | 116153 | g12149 | i0 | 37.9 | 5.19943820224719 | 87 | 51 | 73.3 | 2 | 278 | 18 | 223 | 306 | XP_019872418.1 cathepsin B-like [Aethina tumida] | diamond | 1851 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Nitidulidae | Aethina | Aethina tumida | |
| 28044295 | 28044295 | PRJEB58983_P_NODE_10045_length_394_cov_2.557632_g9630_i0 | PRJEB58983 | 10045 | 394 | 2.557632 | 10.07707008 | Triatoma brasiliensis | 65344 | Arthropoda | Arthropoda | 95.1 | 2.35e-22 | NR | ABJ96355.1 | 65344 | g9630 | i0 | 57.4 | 0.875634517766497 | 115 | 48 | 87.6 | 1 | 381 | 37 | 1 | 114 | ABJ96355.1 60S acidic ribosomal protein P2 [Triatoma brasiliensis] | diamond | 345 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Reduviidae | Triatoma | Triatoma brasiliensis | |
| 28549731 | 28549731 | PRJEB58983_P_NODE_32047_length_243_cov_0.917647_g31632_i0 | PRJEB58983 | 32047 | 243 | 0.917647 | 2.22988221 | Tetranychus urticae | 32264 | Arthropoda | Arthropoda | 52.8 | 1.16e-5 | NR | XP_015786313.1 | 32264 | g31632 | i0 | 46.2 | 0.641975308641975 | 52 | 28 | 64.2 | 0 | 85 | 240 | 2597 | 2648 | XP_015786313.1 inositol 1,4,5-trisphosphate receptor type 1-like isoform X1 [Tetranychus urticae] | diamond | 156 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 29023520 | 29023520 | PRJEB58983_P_NODE_34548_length_228_cov_2.400000_g34133_i0 | PRJEB58983 | 34548 | 228 | 2.4 | 5.472 | Leptopilina heterotoma | 63436 | Arthropoda | Arthropoda | 56.2 | 5.61e-7 | NR | XP_043466331.1 | 63436 | g34133 | i0 | 41.5 | 0.855263157894737 | 65 | 35 | 81.6 | 1 | 204 | 19 | 556 | 620 | XP_043466331.1 uncharacterized protein LOC122501122 [Leptopilina heterotoma] | diamond | 195 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Figitidae | Leptopilina | Leptopilina heterotoma | |
| 29654252 | 29654252 | PRJEB58983_P_NODE_970_length_1331_cov_7.848967_g723_i0 | PRJEB58983 | 970 | 1331 | 7.848967 | 104.46975077 | Lamprigera yunnana | 370605 | Arthropoda | Arthropoda | 52.8 | 0.00237 | NR | KAF5272819.1 | 370605 | g723 | i0 | 38.1 | 0.189331329827198 | 84 | 46 | 17.6 | 2 | 556 | 789 | 147 | 230 | KAF5272819.1 hypothetical protein FQA39_LY07846 [Lamprigera yunnana] | diamond | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Lampyridae | Lamprigera | Lamprigera yunnana | |
| 29844052 | 29844052 | PRJEB58983_P_NODE_26131_length_260_cov_1.518717_g25716_i0 | PRJEB58983 | 26131 | 260 | 1.518717 | 3.9486642 | Darwinula stevensoni | 69355 | Arthropoda | Arthropoda | 58.9 | 9.21e-8 | NR | CAD7254523.1 | 69355 | g25716 | i0 | 36 | 1.61538461538462 | 86 | 22 | 99.2 | 2 | 2 | 259 | 79 | 131 | CAD7254523.1 unnamed protein product, partial [Darwinula stevensoni] | diamond | 420 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Darwinulidae | Darwinula | Darwinula stevensoni | |
| 30500772 | 30500772 | PRJEB58983_P_NODE_27853_length_253_cov_1.333333_g27438_i0 | PRJEB58983 | 27853 | 253 | 1.333333 | 3.37333249 | Insecta | 50557 | Arthropoda | Arthropoda | 65.5 | 4.16e-10 | NR | XP_043793234.1 | 183418 | g27438 | i0 | 39.5 | 2.02766798418972 | 86 | 48 | 97.2 | 2 | 246 | 1 | 84 | 169 | XP_043793234.1 tubulin--tyrosine ligase-like protein 12 [Apis laboriosa] | diamond | 513 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Apis | Apis laboriosa | |
| 30602200 | 30602200 | PRJEB58983_P_NODE_9953_length_396_cov_1.854489_g9539_i0 | PRJEB58983 | 9953 | 396 | 1.854489 | 7.34377644 | Tropilaelaps mercedesae | 418985 | Arthropoda | Arthropoda | 136 | 2.46e-38 | NR | OQR70690.1 | 418985 | g9539 | i0 | 54.9 | 1.84848484848485 | 122 | 54 | 92.4 | 1 | 3 | 368 | 20 | 140 | OQR70690.1 60S ribosomal protein L26 isoform 1 [Tropilaelaps mercedesae] | diamond | 732 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Laelapidae | Tropilaelaps | Tropilaelaps mercedesae | |
| 30950041 | 30950041 | PRJEB58983_P_NODE_30394_length_246_cov_6.410405_g29979_i0 | PRJEB58983 | 30394 | 246 | 6.410405 | 15.7695963 | Anthophora plagiata | 597819 | Arthropoda | Arthropoda | 57.8 | 1.83e-7 | NR | CAK9813121.1 | 597819 | g29979 | i0 | 50.9 | 2.90243902439024 | 57 | 27 | 68.3 | 1 | 186 | 19 | 222 | 278 | CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] | diamond | 714 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Anthophora | Anthophora plagiata | |
| 31107692 | 31107692 | PRJEB58983_P_NODE_10235_length_391_cov_1.235849_g9820_i0 | PRJEB58983 | 10235 | 391 | 1.235849 | 4.83216959 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 56.2 | 3.97e-6 | NR | QVD39252.1 | 7010 | g9820 | i0 | 30.6 | 0.951406649616368 | 124 | 79 | 90.5 | 3 | 360 | 7 | 705 | 827 | QVD39252.1 IP3 receptor [Schistocerca gregaria] | diamond | 372 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 31107717 | 31107717 | PRJEB58983_P_NODE_29495_length_249_cov_0.886364_g29080_i0 | PRJEB58983 | 29495 | 249 | 0.886364 | 2.20704636 | Diachasma alloeum | 454923 | Arthropoda | Arthropoda | 96.7 | 3.850000000000001e-21 | NR | XP_015125086.1 | 454923 | g29080 | i0 | 53.7 | 1.97590361445783 | 82 | 37 | 98.8 | 1 | 248 | 3 | 52 | 132 | XP_015125086.1 arylsulfatase B [Diachasma alloeum] | diamond | 492 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Diachasma | Diachasma alloeum | |
| 31670251 | 31670251 | PRJEB58983_P_NODE_11757_length_367_cov_2.945578_g11342_i0 | PRJEB58983 | 11757 | 367 | 2.945578 | 10.81027126 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.24e-34 | NR | ADD38054.1 | 72036 | g11342 | i0 | 54.2 | 1.9291553133515 | 118 | 54 | 96.5 | 0 | 366 | 13 | 22 | 139 | ADD38054.1 60S ribosomal protein L13 [Lepeophtheirus salmonis] | diamond | 708 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis | |
| 31859927 | 31859927 | PRJEB58983_P_NODE_22957_length_274_cov_3.870647_g22542_i0 | PRJEB58983 | 22957 | 274 | 3.870647 | 10.60557278 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 1.07e-7 | NR | MCL4117871.1 | 82763 | g22542 | i0 | 46.4 | 3.81021897810219 | 69 | 37 | 75.5 | 0 | 274 | 68 | 2 | 70 | MCL4117871.1 hypothetical protein [Idotea baltica] | diamond | 1044 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 31986496 | 31986496 | PRJEB58983_P_NODE_3698_length_639_cov_2.651943_g3293_i0 | PRJEB58983 | 3698 | 639 | 2.651943 | 16.94591577 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 177 | 1.41e-51 | NR | KAG5683884.1 | 319348 | g3293 | i0 | 47.2 | 4.53990610328638 | 195 | 96 | 91.1 | 2 | 39 | 620 | 70 | 258 | KAG5683884.1 30S ribosomal protein S4e [Polypedilum vanderplanki] | diamond | 2901 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Polypedilum | Polypedilum vanderplanki | |
| 32468303 | 32468303 | PRJEB58983_P_NODE_21499_length_282_cov_1.133971_g21084_i0 | PRJEB58983 | 21499 | 282 | 1.133971 | 3.19779822 | Dinothrombium tinctorium | 1965070 | Arthropoda | Arthropoda | 131 | 9.93e-34 | NR | RWS11172.1 | 1965070 | g21084 | i0 | 68.1 | 6 | 94 | 30 | 100 | 0 | 282 | 1 | 147 | 240 | RWS11172.1 mitochondrial-processing peptidase subunit beta-like protein [Dinothrombium tinctorium] | diamond | 1692 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombidiidae | Dinothrombium | Dinothrombium tinctorium | |
| 32846289 | 32846289 | PRJEB58983_P_NODE_31040_length_245_cov_1.360465_g30625_i0 | PRJEB58983 | 31040 | 245 | 1.360465 | 3.33313925 | Chironomus riparius | 315576 | Arthropoda | Arthropoda | 44.3 | 0.00878 | NR | CAG9805894.1 | 315576 | g30625 | i0 | 50 | 1.00408163265306 | 40 | 19 | 49 | 1 | 244 | 125 | 28 | 66 | CAG9805894.1 unnamed protein product [Chironomus riparius] | diamond | 246 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus riparius |
Advanced export
JSON shape: default, array, newline-delimited
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);;