contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138707 | 138707 | PRJEB76780_P_NODE_1861_length_610_cov_1.534451_g1762_i0 | PRJEB76780 | 1861 | 610 | 1.534451 | 9.3601511 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 222 | 1.19e-68 | NR | XP_020626502.1 | 48498 | g1762 | i0 | 68 | 13.7409836065574 | 147 | 47 | 72.3 | 0 | 168 | 608 | 2 | 148 | XP_020626502.1 ras-related C3 botulinum toxin substrate 1-like [Orbicella faveolata] | diamond | 8382 | 224 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 138747 | 138747 | PRJEB76780_P_NODE_601_length_1046_cov_3.265159_g539_i0 | PRJEB76780 | 601 | 1046 | 3.265159 | 34.15356314 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 337 | 2.88e-111 | NR | XP_002166962.3 | 6087 | g539 | i0 | 58.3 | 7.76959847036329 | 302 | 114 | 84.9 | 9 | 4 | 891 | 33 | 328 | XP_002166962.3 cathepsin B [Hydra vulgaris] | diamond | 8127 | 340 | 0.991176470588235 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 2688845 | 2688845 | PRJEB76780_P_NODE_3303_length_449_cov_1.465426_g3203_i0 | PRJEB76780 | 3303 | 449 | 1.465426 | 6.57976274 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 219 | 1.06e-69 | NR | XP_065660884.1 | 6087 | g3203 | i0 | 77 | 77.9799554565702 | 139 | 32 | 92.9 | 0 | 33 | 449 | 6 | 144 | XP_065660884.1 ras-related protein Rab-11B isoform X2 [Hydra vulgaris] | diamond | 35013 | 221 | 0.990950226244344 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 2688911 | 2688911 | PRJEB76780_P_NODE_9843_length_259_cov_1.220430_g9743_i0 | PRJEB76780 | 9843 | 259 | 1.22043 | 3.1609137 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 143 | 2.24e-37 | NR | XP_065656527.1 | 6087 | g9743 | i0 | 71.8 | 27.9498069498069 | 85 | 24 | 98.5 | 0 | 3 | 257 | 1098 | 1182 | XP_065656527.1 bifunctional glutamate/proline--tRNA ligase isoform X2 [Hydra vulgaris] | diamond | 7239 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 6516945 | 6516945 | PRJEB76780_P_NODE_7646_length_292_cov_1.347032_g7546_i0 | PRJEB76780 | 7646 | 292 | 1.347032 | 3.93333344 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 107 | 1.75e-24 | NR | CAH3162736.1 | 104759 | g7546 | i0 | 67.1 | 7.51027397260274 | 85 | 27 | 87.3 | 1 | 255 | 1 | 21 | 104 | CAH3162736.1 unnamed protein product [Porites lobata] | diamond | 2193 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 10341802 | 10341802 | PRJEB76780_P_NODE_3109_length_464_cov_3.664962_g3009_i0 | PRJEB76780 | 3109 | 464 | 3.664962 | 17.00542368 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 192 | 8.42e-60 | NR | XP_002164954.1 | 6087 | g3009 | i0 | 79.1 | 2.85775862068966 | 148 | 29 | 94.4 | 1 | 5 | 442 | 1 | 148 | XP_002164954.1 large ribosomal subunit protein uL15 [Hydra vulgaris] | diamond | 1326 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 20539735 | 20539735 | PRJEB76780_P_NODE_6597_length_314_cov_0.970954_g6497_i0 | PRJEB76780 | 6597 | 314 | 0.970954 | 3.04879556 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 149 | 8.98e-41 | NR | XP_065651483.1 | 6087 | g6497 | i0 | 68.9 | 3.96496815286624 | 103 | 32 | 98.4 | 0 | 309 | 1 | 229 | 331 | XP_065651483.1 DDB1- and CUL4-associated factor 13 isoform X2 [Hydra vulgaris] | diamond | 1245 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26812758 | 26812758 | PRJEB76780_P_NODE_2501_length_519_cov_6.049327_g2401_i0 | PRJEB76780 | 2501 | 519 | 6.049327 | 31.39600713 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 133 | 3.31e-36 | NR | XP_046849006.1 | 2897299 | g2401 | i0 | 51.7 | 3.42774566473988 | 149 | 66 | 86.1 | 1 | 497 | 51 | 1 | 143 | XP_046849006.1 60S ribosomal protein L24-like [Xenia sp. Carnegie-2017] | diamond | 1779 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 27287085 | 27287085 | PRJEB76780_P_NODE_4603_length_379_cov_1.016340_g4503_i0 | PRJEB76780 | 4603 | 379 | 1.01634 | 3.8519286 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 65.1 | 2.51e-9 | NR | CAB3984188.1 | 317549 | g4503 | i0 | 38.1 | 1.81266490765171 | 105 | 59 | 79.2 | 3 | 309 | 10 | 19 | 122 | CAB3984188.1 digestive cysteine ase 1 [Paramuricea clavata] | diamond | 687 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27374974 | 27374974 | PRJEB76780_P_NODE_6423_length_318_cov_1.273469_g6323_i0 | PRJEB76780 | 6423 | 318 | 1.273469 | 4.04963142 | Acropora | 6127 | Cnidaria | other_Eukaryota | 57.8 | 4.58e-7 | NR | KAK2548570.1 | 6130 | g6323 | i0 | 49.1 | 3.49056603773585 | 55 | 28 | 51.9 | 0 | 141 | 305 | 327 | 381 | KAK2548570.1 BRCA1-associated RING domain protein 1 [Acropora cervicornis] | diamond | 1110 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 27406468 | 27406468 | PRJEB76780_P_NODE_10803_length_251_cov_1.314607_g10703_i0 | PRJEB76780 | 10803 | 251 | 1.314607 | 3.29966357 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 95.9 | 7.23e-21 | NR | XP_031559763.1 | 6105 | g10703 | i0 | 62.8 | 12.0836653386454 | 78 | 29 | 93.2 | 0 | 238 | 5 | 1 | 78 | XP_031559763.1 nucleolar protein 58-like [Actinia tenebrosa] | diamond | 3033 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27413769 | 27413769 | PRJEB76780_P_NODE_8483_length_278_cov_1.521951_g8383_i0 | PRJEB76780 | 8483 | 278 | 1.521951 | 4.23102378 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 128 | 5.33e-32 | NR | XP_065668513.1 | 6087 | g8383 | i0 | 60.9 | 2.97841726618705 | 92 | 36 | 99.3 | 0 | 278 | 3 | 390 | 481 | XP_065668513.1 advillin isoform X2 [Hydra vulgaris] | diamond | 828 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27445347 | 27445347 | PRJEB76780_P_NODE_11343_length_249_cov_0.886364_g11243_i0 | PRJEB76780 | 11343 | 249 | 0.886364 | 2.20704636 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 89 | 2.2e-18 | NR | KAJ7370338.1 | 174260 | g11243 | i0 | 55.4 | 14.2048192771084 | 74 | 33 | 89.2 | 0 | 248 | 27 | 1891 | 1964 | KAJ7370338.1 hypothetical protein OS493_032836 [Desmophyllum pertusum] | diamond | 3537 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 28645017 | 28645017 | PRJEB76780_P_NODE_10327_length_253_cov_0.866667_g10227_i0 | PRJEB76780 | 10327 | 253 | 0.866667 | 2.19266751 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 53.5 | 6.62e-6 | NR | XP_028395787.1 | 151771 | g10227 | i0 | 41 | 1.90909090909091 | 83 | 45 | 98.4 | 2 | 1 | 249 | 218 | 296 | XP_028395787.1 FYVE, RhoGEF and PH domain-containing protein 4-like [Dendronephthya gigantea] | diamond | 483 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29300699 | 29300699 | PRJEB76780_P_NODE_2129_length_568_cov_7.884848_g2029_i0 | PRJEB76780 | 2129 | 568 | 7.884848 | 44.78593664 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 176 | 9.77e-53 | NR | XP_057307393.1 | 13093 | g2029 | i0 | 61.8 | 13.5528169014085 | 144 | 55 | 76.1 | 0 | 12 | 443 | 25 | 168 | XP_057307393.1 40S ribosomal protein S15-like [Hydractinia symbiolongicarpus] | diamond | 7698 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29395416 | 29395416 | PRJEB76780_P_NODE_9349_length_266_cov_1.005181_g9249_i0 | PRJEB76780 | 9349 | 266 | 1.005181 | 2.67378146 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 1.98e-5 | NR | XP_001629203.2 | 45351 | g9249 | i0 | 60.5 | 1.79323308270677 | 43 | 14 | 48.5 | 1 | 129 | 1 | 2 | 41 | XP_001629203.2 protein DD3-3 [Nematostella vectensis] | diamond | 477 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29426748 | 29426748 | PRJEB76780_P_NODE_13209_length_242_cov_1.384615_g13109_i0 | PRJEB76780 | 13209 | 242 | 1.384615 | 3.3507683 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 81.3 | 6.43e-16 | NR | XP_002161130.3 | 6087 | g13109 | i0 | 53.1 | 5.0702479338843 | 64 | 30 | 79.3 | 0 | 4 | 195 | 252 | 315 | XP_002161130.3 LIM domain and actin-binding protein 1 [Hydra vulgaris] | diamond | 1227 | 81.6 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29837316 | 29837316 | PRJEB76780_P_NODE_4651_length_376_cov_3.300330_g4551_i0 | PRJEB76780 | 4651 | 376 | 3.30033 | 12.4092408 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 45.4 | 0.0189 | NR | XP_031575069.1 | 6105 | g4551 | i0 | 35.9 | 1.48404255319149 | 64 | 40 | 50.3 | 1 | 1 | 189 | 176 | 239 | XP_031575069.1 WD repeat-containing protein on Y chromosome-like [Actinia tenebrosa] | diamond | 558 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30216404 | 30216404 | PRJEB76780_P_NODE_3472_length_438_cov_2.136986_g3372_i0 | PRJEB76780 | 3472 | 438 | 2.136986 | 9.35999868 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 60.1 | 2.87e-7 | NR | XP_048586392.1 | 45351 | g3372 | i0 | 51.9 | 1.43150684931507 | 54 | 23 | 35.6 | 2 | 436 | 281 | 1572 | 1624 | XP_048586392.1 uncharacterized protein LOC5504315 isoform X3 [Nematostella vectensis] | diamond | 627 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30476732 | 30476732 | PRJEB76780_P_NODE_13393_length_242_cov_0.923077_g13293_i0 | PRJEB76780 | 13393 | 242 | 0.923077 | 2.23384634 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 67.8 | 4.86e-11 | NR | RMX50636.1 | 46731 | g13293 | i0 | 42.2 | 2.96280991735537 | 83 | 44 | 97.9 | 1 | 240 | 4 | 194 | 276 | RMX50636.1 hypothetical protein pdam_00009682 [Pocillopora damicornis] | diamond | 717 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30508183 | 30508183 | PRJEB76780_P_NODE_2973_length_476_cov_1.734491_g2873_i0 | PRJEB76780 | 2973 | 476 | 1.734491 | 8.25617716 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 49.7 | 3.5e-4 | NR | RMX40111.1 | 46731 | g2873 | i0 | 33.3 | 1.28571428571429 | 102 | 52 | 56.1 | 4 | 357 | 91 | 45 | 143 | RMX40111.1 hypothetical protein pdam_00002323 [Pocillopora damicornis] | diamond | 612 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30855684 | 30855684 | PRJEB76780_P_NODE_7454_length_296_cov_1.049327_g7354_i0 | PRJEB76780 | 7454 | 296 | 1.049327 | 3.10600792 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 80.1 | 5.14e-15 | NR | XP_028404232.1 | 151771 | g7354 | i0 | 41.4 | 1.00337837837838 | 99 | 53 | 97.3 | 2 | 3 | 290 | 464 | 560 | XP_028404232.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 2-like [Dendronephthya gigantea] | diamond | 297 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31132501 | 31132501 | PRJEB76780_P_NODE_13595_length_229_cov_3.500000_g13495_i0 | PRJEB76780 | 13595 | 229 | 3.5 | 8.015 | Acropora | 6127 | Cnidaria | other_Eukaryota | 57.4 | 1.69e-7 | NR | KAK2548361.1 | 6130 | g13495 | i0 | 54.2 | 1.46724890829694 | 48 | 21 | 61.6 | 1 | 144 | 4 | 98 | 145 | KAK2548361.1 hypothetical protein P5673_031416 [Acropora cervicornis] | diamond | 336 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 31828386 | 31828386 | PRJEB76780_P_NODE_4437_length_386_cov_0.996805_g4337_i0 | PRJEB76780 | 4437 | 386 | 0.996805 | 3.8476673 | root | 1 | Root_unresolved | Root_unresolved | 214 | 1.15e-66 | NR | XP_027053901.1 | 46731 | g4337 | i0 | 80.5 | 35.759067357513 | 128 | 25 | 99.5 | 0 | 384 | 1 | 42 | 169 | XP_027053901.1 phosphoenolpyruvate phosphomutase-like [Pocillopora damicornis] | diamond | 13803 | 215 | 0.995348837209302 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31828390 | 31828390 | PRJEB76780_P_NODE_8117_length_284_cov_1.535545_g8017_i0 | PRJEB76780 | 8117 | 284 | 1.535545 | 4.3609478 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 46.6 | 0.00275 | NR | XP_031561544.1 | 6105 | g8017 | i0 | 44.3 | 3.94014084507042 | 61 | 31 | 64.4 | 1 | 6 | 188 | 631 | 688 | XP_031561544.1 myb-binding protein 1A-like protein [Actinia tenebrosa] | diamond | 1119 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32310784 | 32310784 | PRJEB76780_P_NODE_1579_length_658_cov_1.707692_g1482_i0 | PRJEB76780 | 1579 | 658 | 1.707692 | 11.23661336 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 161 | 4.51e-46 | NR | XP_027038832.1 | 46731 | g1482 | i0 | 52.4 | 1.5 | 164 | 73 | 73.4 | 4 | 102 | 584 | 21 | 182 | XP_027038832.1 temperature-induced lipocalin-1-like [Pocillopora damicornis] | diamond | 987 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32563844 | 32563844 | PRJEB76780_P_NODE_12539_length_245_cov_0.906977_g12439_i0 | PRJEB76780 | 12539 | 245 | 0.906977 | 2.22209365 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.3 | 3.27e-6 | NR | XP_057306190.1 | 13093 | g12439 | i0 | 45.5 | 0.538775510204082 | 44 | 24 | 53.9 | 0 | 110 | 241 | 594 | 637 | XP_057306190.1 histone-lysine N-methyltransferase NSD2-like [Hydractinia symbiolongicarpus] | diamond | 132 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32563861 | 32563861 | PRJEB76780_P_NODE_9059_length_270_cov_1.187817_g8959_i0 | PRJEB76780 | 9059 | 270 | 1.187817 | 3.2071059 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 95.9 | 1.06e-20 | NR | XP_020629996.1 | 48498 | g8959 | i0 | 63.6 | 3.83333333333333 | 66 | 24 | 73.3 | 0 | 268 | 71 | 491 | 556 | XP_020629996.1 SWI/SNF-related matrix-associated actin-dependent regulator of chromatin subfamily A-like protein 1 [Orbicella faveolata] | diamond | 1035 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32588057 | 32588057 | PRJEB76780_P_NODE_11859_length_247_cov_0.896552_g11759_i0 | PRJEB76780 | 11859 | 247 | 0.896552 | 2.21448344 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.1 | 0.0062 | NR | XP_057308762.1 | 13093 | g11759 | i0 | 34.6 | 3.83805668016194 | 78 | 50 | 93.5 | 1 | 247 | 17 | 601 | 678 | XP_057308762.1 cullin-associated NEDD8-dissociated protein 1-like [Hydractinia symbiolongicarpus] | diamond | 948 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;