contig_metadata
29 rows where bioproject = "PRJNA1061474" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7830352 | 7830352 | PRJNA1061474_P_NODE_14147_length_545_cov_0.788136_g13903_i0 | PRJNA1061474 | 14147 | 545 | 0.788136 | 4.2953412 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 784 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g13903 | i0 | 92.791 | 10.6788990825688 | 541 | 39 | 99 | 0 | 5 | 545 | 558 | 18 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 5820 | 784 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9939825 | 9939825 | PRJNA1061474_P_NODE_41848_length_269_cov_1.964286_g41602_i0 | PRJNA1061474 | 41848 | 269 | 1.964286 | 5.28392934 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 6.069999999999998e-88 | NTclustered | gi|21215206|gb|AF510205.1| | 5947 | g41602 | i0 | 89.513 | 95.9739776951673 | 267 | 27 | 99 | 1 | 1 | 267 | 1274 | 1009 | Oxytricha granulifera beta-tubulin gene, complete cds | blastn | 25817 | 337 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 14207234 | 14207234 | PRJNA1061474_P_NODE_37592_length_293_cov_0.900000_g37346_i0 | PRJNA1061474 | 37592 | 293 | 0.9 | 2.637 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 8.909999999999999e-67 | NTclustered | gi|4063597|gb|AF056109.1| | 6026 | g37346 | i0 | 85.714 | 74.4232081911263 | 252 | 36 | 86 | 0 | 42 | 293 | 1 | 252 | Telotrochidium henneguyii translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 21806 | 267 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 15039342 | 15039342 | PRJNA1061474_P_NODE_38612_length_287_cov_1.439252_g38366_i0 | PRJNA1061474 | 38612 | 287 | 1.439252 | 4.13065324 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 3.79e-30 | NR | CDW85032.1 | 5949 | g38366 | i0 | 63 | 8.78048780487805 | 92 | 34 | 96.2 | 0 | 286 | 11 | 37 | 128 | CDW85032.1 histone h2a [Stylonychia lemnae] | diamond | 2520 | 115 | 0.991304347826087 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 15481232 | 15481232 | PRJNA1061474_P_NODE_33533_length_316_cov_1.502058_g33287_i0 | PRJNA1061474 | 33533 | 316 | 1.502058 | 4.74650328 | Opisthonecta henneguyi | 6026 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 9.439999999999998e-87 | NTclustered | gi|21429687|gb|AY101352.1| | 6026 | g33287 | i0 | 86.084 | 97.1867088607595 | 309 | 43 | 98 | 0 | 8 | 316 | 994 | 686 | Opisthonecta henneguyi alpha-tubulin gene, partial cds | blastn | 30711 | 333 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta henneguyi | ||
| 15481527 | 15481527 | PRJNA1061474_P_NODE_43013_length_263_cov_1.215789_g42767_i0 | PRJNA1061474 | 43013 | 263 | 1.215789 | 3.19752507 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.27e-22 | NR | TNV76685.1 | 5974 | g42767 | i0 | 58.2 | 0.901140684410646 | 79 | 33 | 90.1 | 0 | 237 | 1 | 101 | 179 | TNV76685.1 hypothetical protein FGO68_gene948 [Halteria grandinella] | diamond | 237 | 97.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 21855426 | 21855426 | PRJNA1061474_P_NODE_38838_length_286_cov_1.244131_g38592_i0 | PRJNA1061474 | 38838 | 286 | 1.244131 | 3.55821466 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 2.23e-122 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g38592 | i0 | 98.438 | 95.8321678321678 | 256 | 4 | 90 | 0 | 1 | 256 | 256 | 1 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 27408 | 451 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 26655302 | 26655302 | PRJNA1061474_P_NODE_37401_length_294_cov_1.040724_g37155_i0 | PRJNA1061474 | 37401 | 294 | 1.040724 | 3.05972856 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 4.25e-6 | NR | CAD8209359.1 | 43138 | g37155 | i0 | 40.8 | 1.55102040816327 | 76 | 41 | 77.6 | 4 | 292 | 65 | 84 | 155 | CAD8209359.1 unnamed protein product [Paramecium pentaurelia] | diamond | 456 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 26813996 | 26813996 | PRJNA1061474_P_NODE_38621_length_287_cov_1.439252_g38375_i0 | PRJNA1061474 | 38621 | 287 | 1.439252 | 4.13065324 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 6.27e-15 | NR | KAL4431843.1 | 5901 | g38375 | i0 | 47.8 | 0.961672473867596 | 92 | 46 | 94.1 | 1 | 278 | 9 | 7 | 98 | KAL4431843.1 hypothetical protein ABPG74_015283 [Tetrahymena malaccensis] | diamond | 276 | 79 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 26877507 | 26877507 | PRJNA1061474_P_NODE_28461_length_351_cov_1.384892_g28215_i0 | PRJNA1061474 | 28461 | 351 | 1.384892 | 4.86097092 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.75e-4 | NR | XP_001031771.2 | 312017 | g28215 | i0 | 41.4 | 1.01709401709402 | 58 | 31 | 47 | 1 | 337 | 173 | 322 | 379 | XP_001031771.2 ferric reductase-like transmembrane component [Tetrahymena thermophila SB210] | diamond | 357 | 50.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26908926 | 26908926 | PRJNA1061474_P_NODE_51302_length_246_cov_0.890173_g51056_i0 | PRJNA1061474 | 51302 | 246 | 0.890173 | 2.18982558 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.38e-20 | NR | CDW89969.1 | 5949 | g51056 | i0 | 64 | 0.914634146341463 | 75 | 23 | 91.5 | 1 | 228 | 4 | 191 | 261 | CDW89969.1 ras-related protein rab-19 [Stylonychia lemnae] | diamond | 225 | 94 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27256686 | 27256686 | PRJNA1061474_P_NODE_1643_length_1571_cov_1.956609_g1561_i0 | PRJNA1061474 | 1643 | 1571 | 1.956609 | 30.73832739 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 3.39e-205 | NR | QBC88378.1 | 282688 | g1561 | i0 | 83.7 | 3.515595162317 | 344 | 48 | 65.7 | 2 | 1489 | 458 | 1 | 336 | QBC88378.1 NADH-cytochrome b5 reductase 1 [Philasterides dicentrarchi] | diamond | 5523 | 584 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 27438349 | 27438349 | PRJNA1061474_P_NODE_55603_length_243_cov_0.905882_g55357_i0 | PRJNA1061474 | 55603 | 243 | 0.905882 | 2.20129326 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 6.920000000000001e-27 | NR | CAD8145820.1 | 43138 | g55357 | i0 | 64.9 | 1.90123456790123 | 77 | 27 | 95.1 | 0 | 231 | 1 | 224 | 300 | CAD8145820.1 unnamed protein product [Paramecium pentaurelia] | diamond | 462 | 110 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 27635899 | 27635899 | PRJNA1061474_P_NODE_7144_length_819_cov_1.191689_g6936_i0 | PRJNA1061474 | 7144 | 819 | 1.191689 | 9.75993291 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.1899999999999997e-42 | NR | XP_004031019.1 | 5932 | g6936 | i0 | 40.6 | 1.6959706959707 | 234 | 135 | 84.6 | 4 | 810 | 118 | 1 | 233 | XP_004031019.1 ribosomal protein, putative [Ichthyophthirius multifiliis] | diamond | 1389 | 157 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 27856675 | 27856675 | PRJNA1061474_P_NODE_27045_length_363_cov_0.793103_g26799_i0 | PRJNA1061474 | 27045 | 363 | 0.793103 | 2.87896389 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 6.24e-32 | NR | CAD8086464.1 | 65129 | g26799 | i0 | 50.4 | 0.983471074380165 | 119 | 55 | 98.3 | 2 | 361 | 5 | 113 | 227 | CAD8086464.1 unnamed protein product [Paramecium sonneborni] | diamond | 357 | 125 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 28543395 | 28543395 | PRJNA1061474_P_NODE_50807_length_247_cov_0.885057_g50561_i0 | PRJNA1061474 | 50807 | 247 | 0.885057 | 2.18609079 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.79e-16 | NR | CAD8136818.1 | 43138 | g50561 | i0 | 47.4 | 1.89473684210526 | 78 | 40 | 93.5 | 1 | 17 | 247 | 171 | 248 | CAD8136818.1 unnamed protein product [Paramecium pentaurelia] | diamond | 468 | 83.2 | 0.990384615384615 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 28930337 | 28930337 | PRJNA1061474_P_NODE_23168_length_401_cov_0.939024_g22922_i0 | PRJNA1061474 | 23168 | 401 | 0.939024 | 3.76548624 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 2.39e-20 | NR | CAG9335356.1 | 1481888 | g22922 | i0 | 39.6 | 1.00249376558603 | 134 | 72 | 93.5 | 2 | 397 | 23 | 35 | 168 | CAG9335356.1 unnamed protein product [Blepharisma stoltei] | diamond | 402 | 91.7 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30121884 | 30121884 | PRJNA1061474_P_NODE_50412_length_247_cov_0.885057_g50166_i0 | PRJNA1061474 | 50412 | 247 | 0.885057 | 2.18609079 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0474 | NR | CAD8094763.1 | 5886 | g50166 | i0 | 60 | 1.2753036437247 | 35 | 14 | 42.5 | 0 | 1 | 105 | 91 | 125 | CAD8094763.1 unnamed protein product [Paramecium primaurelia] | diamond | 315 | 42.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 30225030 | 30225030 | PRJNA1061474_P_NODE_9352_length_701_cov_2.261146_g9125_i0 | PRJNA1061474 | 9352 | 701 | 2.261146 | 15.85063346 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 1.62e-6 | NR | CDW86772.1 | 5949 | g9125 | i0 | 42 | 0.427960057061341 | 100 | 49 | 39.8 | 3 | 132 | 410 | 42 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 300 | 57.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30280424 | 30280424 | PRJNA1061474_P_NODE_48072_length_249_cov_0.875000_g47826_i0 | PRJNA1061474 | 48072 | 249 | 0.875 | 2.17875 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.88e-13 | NR | CAD8050913.1 | 5886 | g47826 | i0 | 48.1 | 3.60240963855422 | 77 | 40 | 92.8 | 0 | 237 | 7 | 9 | 85 | CAD8050913.1 unnamed protein product [Paramecium primaurelia] | diamond | 897 | 69.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 30604088 | 30604088 | PRJNA1061474_P_NODE_34173_length_312_cov_1.933054_g33927_i0 | PRJNA1061474 | 34173 | 312 | 1.933054 | 6.03112848 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.45e-11 | NR | XP_001019178.2 | 312017 | g33927 | i0 | 44.6 | 0.711538461538462 | 74 | 41 | 71.2 | 0 | 13 | 234 | 161 | 234 | XP_001019178.2 high mobility group (HMG) box protein [Tetrahymena thermophila SB210] | diamond | 222 | 69.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30667404 | 30667404 | PRJNA1061474_P_NODE_53033_length_245_cov_0.895349_g52787_i0 | PRJNA1061474 | 53033 | 245 | 0.895349 | 2.19360505 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0373 | NR | KRX01183.1 | 266149 | g52787 | i0 | 38.9 | 0.881632653061225 | 72 | 39 | 88.2 | 2 | 3 | 218 | 256 | 322 | KRX01183.1 hypothetical protein PPERSA_03687 [Pseudocohnilembus persalinus] | diamond | 216 | 42.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31046835 | 31046835 | PRJNA1061474_P_NODE_57515_length_241_cov_0.916667_g57269_i0 | PRJNA1061474 | 57515 | 241 | 0.916667 | 2.20916747 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.3e-20 | NR | XP_004029841.1 | 5932 | g57269 | i0 | 54.4 | 0.983402489626556 | 79 | 36 | 98.3 | 0 | 239 | 3 | 273 | 351 | XP_004029841.1 hypothetical protein IMG5_171930 [Ichthyophthirius multifiliis] | diamond | 237 | 94 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31109567 | 31109567 | PRJNA1061474_P_NODE_38615_length_287_cov_1.439252_g38369_i0 | PRJNA1061474 | 38615 | 287 | 1.439252 | 4.13065324 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 5.84e-4 | NR | AAW02920.1 | 5908 | g38369 | i0 | 35 | 0.627177700348432 | 60 | 39 | 62.7 | 0 | 265 | 86 | 12 | 71 | AAW02920.1 translation elongation factor 1B alpha subunit, partial [Tetrahymena pyriformis] | diamond | 180 | 48.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 31140917 | 31140917 | PRJNA1061474_P_NODE_44375_length_256_cov_1.153005_g44129_i0 | PRJNA1061474 | 44375 | 256 | 1.153005 | 2.9516928 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00823 | NR | KRX09922.1 | 266149 | g44129 | i0 | 63 | 0.52734375 | 27 | 10 | 31.6 | 0 | 185 | 105 | 267 | 293 | KRX09922.1 Lysozyme-like domain [Pseudocohnilembus persalinus] | diamond | 135 | 44.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31267781 | 31267781 | PRJNA1061474_P_NODE_45575_length_251_cov_0.865169_g45329_i0 | PRJNA1061474 | 45575 | 251 | 0.865169 | 2.17157419 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.27e-11 | NR | KRX02716.1 | 266149 | g45329 | i0 | 42.7 | 0.9800796812749 | 82 | 47 | 98 | 0 | 249 | 4 | 315 | 396 | KRX02716.1 hypothetical protein PPERSA_01833 [Pseudocohnilembus persalinus] | diamond | 246 | 69.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32090234 | 32090234 | PRJNA1061474_P_NODE_28158_length_354_cov_0.807829_g27912_i0 | PRJNA1061474 | 28158 | 354 | 0.807829 | 2.85971466 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 5.65e-8 | NR | XP_004030818.1 | 5932 | g27912 | i0 | 33.6 | 0.983050847457627 | 116 | 74 | 97.5 | 2 | 346 | 2 | 153 | 266 | XP_004030818.1 nuclease domain protein 1 [Ichthyophthirius multifiliis] | diamond | 348 | 60.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 32619560 | 32619560 | PRJNA1061474_P_NODE_54520_length_244_cov_0.900585_g54274_i0 | PRJNA1061474 | 54520 | 244 | 0.900585 | 2.1974274 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 2.69e-23 | NR | CAD8064403.1 | 5886 | g54274 | i0 | 65.1 | 12.0737704918033 | 83 | 26 | 99.6 | 2 | 2 | 244 | 26 | 107 | CAD8064403.1 unnamed protein product [Paramecium primaurelia] | diamond | 2946 | 98.6 | 0.995943204868154 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32690637 | 32690637 | PRJNA1061474_P_NODE_48140_length_249_cov_0.875000_g47894_i0 | PRJNA1061474 | 48140 | 249 | 0.875 | 2.17875 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 8.54e-17 | NR | KRX10580.1 | 266149 | g47894 | i0 | 49.3 | 0.903614457831325 | 75 | 38 | 90.4 | 0 | 225 | 1 | 133 | 207 | KRX10580.1 hypothetical protein PPERSA_05400 [Pseudocohnilembus persalinus] | diamond | 225 | 82.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;