contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145097 | 145097 | PRJNA1000943_P_NODE_10161_length_263_cov_1.247368_g10023_i0 | PRJNA1000943 | 10161 | 263 | 1.247368 | 3.28057784 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 470 | 5.59e-128 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g10023 | i0 | 98.859 | 23.5703422053232 | 263 | 3 | 100 | 0 | 1 | 263 | 351 | 89 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 6199 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 1419858 | 1419858 | PRJNA1000943_P_NODE_2842_length_456_cov_1.838120_g2705_i0 | PRJNA1000943 | 2842 | 456 | 1.83812 | 8.3818272 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 760 | 0 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g2705 | i0 | 96.711 | 33.4276315789474 | 456 | 15 | 100 | 0 | 1 | 456 | 1606 | 1151 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 15243 | 760 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 2695287 | 2695287 | PRJNA1000943_P_NODE_11703_length_251_cov_1.398876_g11565_i0 | PRJNA1000943 | 11703 | 251 | 1.398876 | 3.51117876 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g11565 | i0 | 99.203 | 31.4382470119522 | 251 | 2 | 100 | 0 | 1 | 251 | 3326 | 3576 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 7891 | 453 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 2695308 | 2695308 | PRJNA1000943_P_NODE_13963_length_245_cov_1.813953_g13825_i0 | PRJNA1000943 | 13963 | 245 | 1.813953 | 4.44418485 | Riboviria sp. | 2585031 | Viruses | Viruses | 274 | 4.34e-69 | NTclustered | gi|1698232529|gb|MN032776.1| | 2585031 | g13825 | i0 | 90.047 | 0.861224489795918 | 211 | 21 | 86 | 0 | 35 | 245 | 757 | 547 | MAG: Riboviria sp. isolate H1_Bulk_Litter_5_scaffold_8245 hypothetical protein (H1BulkLitter58245_000001) gene, partial cds; and RNA-dependent RNA polymerase (H1BulkLitter58245_000002) gene, complete cds | blastn | 211 | 274 | 1 | Viruses | Riboviria sp. | ||||||||
| 3971375 | 3971375 | PRJNA1000943_P_NODE_1184_length_691_cov_2.631068_g1054_i0 | PRJNA1000943 | 1184 | 691 | 2.631068 | 18.18067988 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1243 | 0 | NTclustered | gi|2671680470|gb|OR496452.1| | 294365 | g1054 | i0 | 99.273 | 91.7149059334298 | 688 | 5 | 99 | 0 | 4 | 691 | 7056 | 6369 | MAG: Israeli acute paralysis virus isolate Andong genomic sequence | blastn | 63375 | 1243 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 3971436 | 3971436 | PRJNA1000943_P_NODE_2204_length_513_cov_2.772727_g2067_i0 | PRJNA1000943 | 2204 | 513 | 2.772727 | 14.22408951 | Aparavirus israelense | 3048155 | Viruses | Viruses | 887 | 0 | NTclustered | gi|2671680486|gb|OR496456.1| | 294365 | g2067 | i0 | 97.856 | 54 | 513 | 11 | 100 | 0 | 1 | 513 | 4150 | 3638 | MAG: Israeli acute paralysis virus isolate Gyeongju genomic sequence | blastn | 27702 | 887 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 6523446 | 6523446 | PRJNA1000943_P_NODE_15006_length_243_cov_0.917647_g14868_i0 | PRJNA1000943 | 15006 | 243 | 0.917647 | 2.22988221 | Dishui Lake large algae virus 1 | 2704073 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1817920096|gb|MN940580.1| | 2704073 | g14868 | i0 | 94.286 | 0.1440329218107 | 35 | 1 | 14 | 1 | 179 | 213 | 76645 | 76678 | Dishui Lake large Algae virus 1, complete genome | blastn | 35 | 52.8 | 1 | Viruses | Dishui Lake large algae virus 1 | ||||||||
| 7797595 | 7797595 | PRJNA1000943_P_NODE_1267_length_670_cov_3.311558_g1136_i0 | PRJNA1000943 | 1267 | 670 | 3.311558 | 22.1874386 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1175 | 0 | NTclustered | gi|2671680494|gb|OR496458.1| | 294365 | g1136 | i0 | 98.358 | 90.5716417910448 | 670 | 10 | 99 | 1 | 2 | 670 | 887 | 218 | MAG: Israeli acute paralysis virus isolate Uiseong genomic sequence | blastn | 60683 | 1175 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 7797644 | 7797644 | PRJNA1000943_P_NODE_2147_length_518_cov_4.256180_g2010_i0 | PRJNA1000943 | 2147 | 518 | 4.25618 | 22.0470124 | Aparavirus israelense | 3048155 | Viruses | Viruses | 891 | 0 | NTclustered | gi|2671680486|gb|OR496456.1| | 294365 | g2010 | i0 | 97.683 | 53.9382239382239 | 518 | 12 | 100 | 0 | 1 | 518 | 3114 | 3631 | MAG: Israeli acute paralysis virus isolate Gyeongju genomic sequence | blastn | 27940 | 891 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 10348226 | 10348226 | PRJNA1000943_P_NODE_13849_length_246_cov_0.901734_g13711_i0 | PRJNA1000943 | 13849 | 246 | 0.901734 | 2.21826564 | Sopapen virus | 3131614 | Viruses | Viruses | 139 | 1.66e-28 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g13711 | i0 | 93.548 | 9.98373983739837 | 93 | 6 | 38 | 0 | 22 | 114 | 527 | 435 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 2456 | 139 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 10348275 | 10348275 | PRJNA1000943_P_NODE_2809_length_458_cov_2.129870_g2672_i0 | PRJNA1000943 | 2809 | 458 | 2.12987 | 9.7548046 | Aparavirus israelense | 3048155 | Viruses | Viruses | 813 | 0 | NTclustered | gi|2127009797|gb|MZ821845.1| | 294365 | g2672 | i0 | 98.69 | 79.9606986899563 | 458 | 6 | 100 | 0 | 1 | 458 | 2949 | 2492 | MAG: Israeli acute paralysis virus isolate IAPV_No6_Mi020-JL2018-10 replicase polyprotein and capsid protein genes, complete cds | blastn | 36622 | 813 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 10348305 | 10348305 | PRJNA1000943_P_NODE_5469_length_342_cov_2.029740_g5331_i0 | PRJNA1000943 | 5469 | 342 | 2.02974 | 6.9417108 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 577 | 4.31e-160 | NTclustered | gi|2737472559|dbj|LC818006.1| | 1080798 | g5331 | i0 | 97.076 | 18.4736842105263 | 342 | 10 | 100 | 0 | 1 | 342 | 2538 | 2197 | Soybean yellow common mosaic virus SYCMV_NA_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete cds | blastn | 6318 | 577 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 14173684 | 14173684 | PRJNA1000943_P_NODE_1012_length_741_cov_2.320359_g886_i0 | PRJNA1000943 | 1012 | 741 | 2.320359 | 17.19386019 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1308 | 0 | NTclustered | gi|2514754451|gb|OP972882.1| | 294365 | g886 | i0 | 98.516 | 71.195681511471 | 741 | 11 | 100 | 0 | 1 | 741 | 8156 | 7416 | MAG: Israeli acute paralysis virus isolate Hwasun_B, complete genome | blastn | 52756 | 1308 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173755 | 14173755 | PRJNA1000943_P_NODE_1932_length_546_cov_2.391121_g1796_i0 | PRJNA1000943 | 1932 | 546 | 2.391121 | 13.055520660000001 | Aparavirus israelense | 3048155 | Viruses | Viruses | 992 | 0 | NTclustered | gi|2127009794|gb|MZ821844.1| | 294365 | g1796 | i0 | 99.451 | 53.5586080586081 | 546 | 3 | 100 | 0 | 1 | 546 | 1028 | 1573 | MAG: Israeli acute paralysis virus isolate IAPV_No5_Mi002-AH2018 replicase polyprotein and capsid protein genes, complete cds | blastn | 29243 | 992 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173759 | 14173759 | PRJNA1000943_P_NODE_2492_length_484_cov_2.440389_g2355_i0 | PRJNA1000943 | 2492 | 484 | 2.440389 | 11.81148276 | Aparavirus israelense | 3048155 | Viruses | Viruses | 872 | 0 | NTclustered | gi|2514754445|gb|OP972880.1| | 294365 | g2355 | i0 | 99.174 | 65.1074380165289 | 484 | 4 | 100 | 0 | 1 | 484 | 8923 | 8440 | MAG: Israeli acute paralysis virus isolate Geochang_A genomic sequence | blastn | 31512 | 872 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173775 | 14173775 | PRJNA1000943_P_NODE_412_length_1076_cov_2.985045_g339_i0 | PRJNA1000943 | 412 | 1076 | 2.985045 | 32.1190842 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1905 | 0 | NTclustered | gi|2671680470|gb|OR496452.1| | 294365 | g339 | i0 | 98.695 | 71.8996282527881 | 1073 | 14 | 99 | 0 | 4 | 1076 | 5523 | 4451 | MAG: Israeli acute paralysis virus isolate Andong genomic sequence | blastn | 77364 | 1905 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 15447909 | 15447909 | PRJNA1000943_P_NODE_7613_length_298_cov_1.733333_g7475_i0 | PRJNA1000943 | 7613 | 298 | 1.733333 | 5.16533234 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 507 | 4.92e-139 | NTclustered | gi|2737472559|dbj|LC818006.1| | 1080798 | g7475 | i0 | 97.315 | 15.8489932885906 | 298 | 8 | 100 | 0 | 1 | 298 | 800 | 1097 | Soybean yellow common mosaic virus SYCMV_NA_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete cds | blastn | 4723 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 16721998 | 16721998 | PRJNA1000943_P_NODE_1594_length_601_cov_1.791667_g1459_i0 | PRJNA1000943 | 1594 | 601 | 1.791667 | 10.76791867 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1038 | 0 | NTclustered | gi|491846189|gb|KC690270.1| | 294365 | g1459 | i0 | 97.841 | 66.2745424292845 | 602 | 12 | 100 | 1 | 1 | 601 | 1713 | 2314 | Israeli acute paralysis virus strain Korea3, complete genome | blastn | 39831 | 1038 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 16722055 | 16722055 | PRJNA1000943_P_NODE_6154_length_326_cov_1.233202_g6016_i0 | PRJNA1000943 | 6154 | 326 | 1.233202 | 4.02023852 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 553 | 6.889999999999998e-153 | NTclustered | gi|2059625997|tpg|BK028313.1| | 2832643 | g6016 | i0 | 97.239 | 6.85889570552147 | 326 | 9 | 100 | 0 | 1 | 326 | 19986 | 20311 | MAG TPA_asm: Caudoviricetes sp. isolate ctMkD2, partial genome | blastn | 2236 | 553 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16722091 | 16722091 | PRJNA1000943_P_NODE_9574_length_269_cov_2.556122_g9436_i0 | PRJNA1000943 | 9574 | 269 | 2.556122 | 6.87596818 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|2056529904|gb|MT997092.1| | 1080798 | g9436 | i0 | 99.628 | 43.2862453531598 | 269 | 1 | 100 | 0 | 1 | 269 | 1889 | 1621 | Soybean yellow common mosaic virus isolate CHN-JZ-02, partial genome | blastn | 11644 | 492 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 17996882 | 17996882 | PRJNA1000943_P_NODE_635_length_902_cov_12.401689_g534_i0 | PRJNA1000943 | 635 | 902 | 12.401689 | 111.86323478 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1666 | 0 | NTclustered | gi|1836048744|gb|MT415897.1| | 2697049 | g534 | i0 | 100 | 100 | 902 | 0 | 100 | 0 | 1 | 902 | 29176 | 28275 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/VA-DCLS-0072/2020, complete genome | blastn | 90200 | 1666 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20546278 | 20546278 | PRJNA1000943_P_NODE_15157_length_243_cov_0.917647_g15019_i0 | PRJNA1000943 | 15157 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 7.03e-82 | NTclustered | gi|2914761258|gb|OR221805.1| | 2832643 | g15019 | i0 | 90.123 | 1 | 243 | 24 | 100 | 0 | 1 | 243 | 36947 | 36705 | MAG: Caudoviricetes sp. isolate MSP1209 genomic sequence | blastn | 243 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20546346 | 20546346 | PRJNA1000943_P_NODE_7537_length_299_cov_2.190265_g7399_i0 | PRJNA1000943 | 7537 | 299 | 2.190265 | 6.54889235 | Aparavirus israelense | 3048155 | Viruses | Viruses | 516 | 8.2e-142 | NTclustered | gi|2574590679|gb|OR416402.1| | 294365 | g7399 | i0 | 97.674 | 65.5852842809364 | 301 | 5 | 100 | 1 | 1 | 299 | 5259 | 5559 | MAG: Israeli acute paralysis virus isolate IAPV-Vcra nonstructural polyprotein gene, complete cds | blastn | 19610 | 516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 21821971 | 21821971 | PRJNA1000943_P_NODE_14998_length_243_cov_0.917647_g14860_i0 | PRJNA1000943 | 14998 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 180 | 9.63e-41 | NTclustered | gi|2914986982|gb|OR222125.1| | 2832643 | g14860 | i0 | 95.536 | 0.917695473251029 | 112 | 5 | 46 | 0 | 1 | 112 | 28867 | 28756 | MAG: Caudoviricetes sp. isolate MSP0855 genomic sequence | blastn | 223 | 180 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23097335 | 23097335 | PRJNA1000943_P_NODE_5339_length_346_cov_2.274725_g5201_i0 | PRJNA1000943 | 5339 | 346 | 2.274725 | 7.8705485 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 614 | 3.329999999999999e-171 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g5201 | i0 | 98.837 | 22.150289017341 | 344 | 4 | 99 | 0 | 3 | 346 | 671 | 328 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 7664 | 614 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 23097350 | 23097350 | PRJNA1000943_P_NODE_6219_length_324_cov_2.486056_g6081_i0 | PRJNA1000943 | 6219 | 324 | 2.486056 | 8.05482144 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 571 | 1.8899999999999993e-158 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g6081 | i0 | 98.457 | 20.7654320987654 | 324 | 5 | 100 | 0 | 1 | 324 | 2856 | 3179 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 6728 | 571 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 23951656 | 23951656 | PRJNA1000943_P_NODE_11499_length_252_cov_0.871508_g11361_i0 | PRJNA1000943 | 11499 | 252 | 0.871508 | 2.19620016 | Pahexavirus | 1982251 | Viruses | Viruses | 431 | 2.5099999999999992e-116 | NTclustered | gi|543171355|ref|NC_022336.1| | 1235645 | g11361 | i0 | 97.984 | 99.5238095238095 | 248 | 5 | 98 | 0 | 5 | 252 | 2651 | 2898 | Propionibacterium phage PHL010M04, complete genome | blastn | 25080 | 431 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL151N00 | ||||
| 24370975 | 24370975 | PRJNA1000943_P_NODE_11960_length_251_cov_0.876404_g11822_i0 | PRJNA1000943 | 11960 | 251 | 0.876404 | 2.19977404 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g11822 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 45711 | 45461 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 251 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;