contig_metadata
29 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 417625 | 417625 | PRJNA407886_P_NODE_53701_length_292_cov_1.406393_g52007_i0 | PRJNA407886 | 53701 | 292 | 1.406393 | 4.10666756 | Rhizobium phage RHEph12 | 2836128 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2071737242|gb|MW980064.1| | 2836128 | g52007 | i0 | 96.875 | 0.10958904109589 | 32 | 1 | 11 | 0 | 160 | 191 | 122935 | 122904 | Rhizobium phage RHEph12, complete genome | blastn | 32 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHEph12 | |||||
| 417982 | 417982 | PRJNA407886_P_NODE_72301_length_249_cov_0.875000_g70607_i0 | PRJNA407886 | 72301 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 381 | 2.5299999999999995e-101 | NTclustered | gi|2915015279|gb|OR222516.1| | 2832643 | g70607 | i0 | 94.378 | 1 | 249 | 13 | 100 | 1 | 1 | 249 | 16325 | 16572 | MAG: Caudoviricetes sp. isolate MSP0423 genomic sequence | blastn | 249 | 381 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2967939 | 2967939 | PRJNA407886_P_NODE_31303_length_406_cov_1.204204_g29609_i0 | PRJNA407886 | 31303 | 406 | 1.204204 | 4.88906824 | Potyvirus phaseovulgaris | 3240595 | Viruses | Viruses | 750 | 0 | NTclustered | gi|339905491|gb|HM776067.1| | 28353 | g29609 | i0 | 100 | 100 | 406 | 0 | 100 | 0 | 1 | 406 | 501 | 906 | Bean common mosaic virus strain peanut stripe isolate DY2 polyprotein gene, partial cds | blastn | 40600 | 750 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus phaseovulgaris | ||
| 2968769 | 2968769 | PRJNA407886_P_NODE_72843_length_248_cov_1.760000_g71149_i0 | PRJNA407886 | 72843 | 248 | 1.76 | 4.3648 | Capillovirus mali | 28347 | Viruses | Viruses | 401 | 1.9299999999999994e-107 | NTclustered | gi|381393149|gb|JQ308181.1| | 28347 | g71149 | i0 | 95.951 | 99.5846774193548 | 247 | 10 | 99 | 0 | 1 | 247 | 4570 | 4816 | Apple stem grooving virus isolate ASGV-CHN, complete genome | blastn | 24697 | 401 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 6794655 | 6794655 | PRJNA407886_P_NODE_20366_length_562_cov_2.316973_g18681_i0 | PRJNA407886 | 20366 | 562 | 2.316973 | 13.02138826 | Capillovirus mali | 28347 | Viruses | Viruses | 756 | 0 | NTclustered | gi|1463747790|gb|MF616381.1| | 28347 | g18681 | i0 | 90.925 | 48.6903914590747 | 562 | 51 | 100 | 0 | 1 | 562 | 2812 | 2251 | Capillovirus mali isolate JLSG, complete genome | blastn | 27364 | 756 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 6795056 | 6795056 | PRJNA407886_P_NODE_37606_length_360_cov_1.285714_g35912_i0 | PRJNA407886 | 37606 | 360 | 1.285714 | 4.6285704 | Capillovirus mali | 28347 | Viruses | Viruses | 544 | 4.6199999999999996e-150 | NTclustered | gi|1783301349|gb|MK599422.1| | 28347 | g35912 | i0 | 93.889 | 30.7972222222222 | 360 | 22 | 100 | 0 | 1 | 360 | 4440 | 4081 | Capillovirus mali isolate L3, complete genome | blastn | 11087 | 544 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 9346220 | 9346220 | PRJNA407886_P_NODE_76768_length_245_cov_0.895349_g75074_i0 | PRJNA407886 | 76768 | 245 | 0.895349 | 2.19360505 | Capillovirus mali | 28347 | Viruses | Viruses | 368 | 1.93e-97 | NTclustered | gi|390994805|gb|JX080219.1| | 28347 | g75074 | i0 | 93.852 | 21.9959183673469 | 244 | 15 | 99 | 0 | 2 | 245 | 290 | 47 | Apple stem grooving virus isolate Aus-V2 movement protein and polyprotein genes, partial cds | blastn | 5389 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 9346222 | 9346222 | PRJNA407886_P_NODE_76888_length_245_cov_0.895349_g75194_i0 | PRJNA407886 | 76888 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 8.989999999999999e-96 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g75194 | i0 | 93.443 | 298.848979591837 | 244 | 16 | 99 | 0 | 1 | 244 | 17709 | 17952 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 73218 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11285898 | 11285898 | PRJNA407886_P_NODE_75509_length_246_cov_0.890173_g73815_i0 | PRJNA407886 | 75509 | 246 | 0.890173 | 2.18982558 | Viruses | 10239 | Viruses | Viruses | 444 | 3.14e-120 | NTclustered | gi|431809676|ref|NC_019914.1| | 1147044 | g73815 | i0 | 99.187 | 18.4105691056911 | 246 | 2 | 100 | 0 | 1 | 246 | 34118 | 34363 | Staphylococcus phage StB27, complete genome | blastn | 4529 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Staphylococcus phage StB27 | |||||
| 13171643 | 13171643 | PRJNA407886_P_NODE_66571_length_258_cov_1.372973_g64877_i0 | PRJNA407886 | 66571 | 258 | 1.372973 | 3.54227034 | Potyvirus phaseovulgaris | 3240595 | Viruses | Viruses | 466 | 7.08e-127 | NTclustered | gi|2129411261|gb|MZ442684.1| | 28353 | g64877 | i0 | 99.225 | 75.9922480620155 | 258 | 2 | 100 | 0 | 1 | 258 | 5847 | 5590 | Peanut stripe virus isolate AYD-9 polyprotein gene, complete cds | blastn | 19606 | 466 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus phaseovulgaris | ||
| 13835808 | 13835808 | PRJNA407886_P_NODE_52311_length_296_cov_2.331839_g50617_i0 | PRJNA407886 | 52311 | 296 | 2.331839 | 6.90224344 | Capillovirus | 12174 | Viruses | Viruses | 459 | 1.39e-124 | NTclustered | gi|1845308772|gb|MN495979.1| | 28347 | g50617 | i0 | 94.595 | 100.027027027027 | 296 | 16 | 100 | 0 | 1 | 296 | 5658 | 5953 | Capillovirus mali, complete genome | blastn | 29608 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 14446182 | 14446182 | PRJNA407886_P_NODE_34932_length_377_cov_3.828947_g33238_i0 | PRJNA407886 | 34932 | 377 | 3.828947 | 14.43513019 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 65.8 | 4.61e-6 | NTclustered | gi|37701115|gb|AY397046.1| | 11676 | g33238 | i0 | 97.368 | 3.48541114058355 | 38 | 1 | 10 | 0 | 188 | 225 | 297 | 334 | HIV-1 strain A|A15 from Ghana gag protein (gag) gene, partial cds | blastn | 1314 | 65.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 14446670 | 14446670 | PRJNA407886_P_NODE_59152_length_276_cov_2.674877_g57458_i0 | PRJNA407886 | 59152 | 276 | 2.674877 | 7.38266052 | Trichovirus mali | 12175 | Viruses | Viruses | 364 | 2.869999999999999e-96 | NTclustered | gi|526455363|gb|KF134394.1| | 12175 | g57458 | i0 | 90.545 | 95.3659420289855 | 275 | 26 | 99 | 0 | 1 | 275 | 273 | 547 | Apple chlorotic leaf spot virus isolate FF coat protein gene, partial cds | blastn | 26321 | 364 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Trichovirus mali | ||
| 15110240 | 15110240 | PRJNA407886_P_NODE_67612_length_255_cov_2.560440_g65918_i0 | PRJNA407886 | 67612 | 255 | 2.56044 | 6.529122 | root | 1 | Root_unresolved | Root_unresolved | 267 | 7.6e-67 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g65918 | i0 | 100 | 97.0549019607843 | 144 | 0 | 96 | 0 | 107 | 250 | 11236 | 11379 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 24749 | 267 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 15719788 | 15719788 | PRJNA407886_P_NODE_27073_length_450_cov_1.480106_g25380_i0 | PRJNA407886 | 27073 | 450 | 1.480106 | 6.660477 | Capillovirus mali | 28347 | Viruses | Viruses | 660 | 0 | NTclustered | gi|381393149|gb|JQ308181.1| | 28347 | g25380 | i0 | 93.111 | 55.6111111111111 | 450 | 31 | 100 | 0 | 1 | 450 | 745 | 1194 | Apple stem grooving virus isolate ASGV-CHN, complete genome | blastn | 25025 | 660 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 15720187 | 15720187 | PRJNA407886_P_NODE_47633_length_313_cov_1.283333_g45939_i0 | PRJNA407886 | 47633 | 313 | 1.283333 | 4.01683229 | Capillovirus mali | 28347 | Viruses | Viruses | 512 | 1.12e-140 | NTclustered | gi|930068503|gb|KR106996.1| | 28347 | g45939 | i0 | 96.166 | 97.8051118210863 | 313 | 12 | 100 | 0 | 1 | 313 | 6034 | 6346 | Capillovirus mali isolate ASGV_kfp, complete genome | blastn | 30613 | 512 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 16995590 | 16995590 | PRJNA407886_P_NODE_77354_length_244_cov_2.701754_g75660_i0 | PRJNA407886 | 77354 | 244 | 2.701754 | 6.59227976 | Capillovirus mali | 28347 | Viruses | Viruses | 412 | 8.759999999999998e-111 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g75660 | i0 | 97.51 | 98.7213114754098 | 241 | 6 | 99 | 0 | 4 | 244 | 5925 | 5685 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 24088 | 412 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 18268287 | 18268287 | PRJNA407886_P_NODE_10355_length_959_cov_1.881490_g9050_i0 | PRJNA407886 | 10355 | 959 | 1.88149 | 18.0434891 | Capillovirus mali | 28347 | Viruses | Viruses | 1290 | 0 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g9050 | i0 | 90.928 | 47.6350364963504 | 959 | 87 | 100 | 0 | 1 | 959 | 3039 | 3997 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 45682 | 1290 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 19542735 | 19542735 | PRJNA407886_P_NODE_19636_length_579_cov_1.563241_g17955_i0 | PRJNA407886 | 19636 | 579 | 1.563241 | 9.05116539 | Capillovirus mali | 28347 | Viruses | Viruses | 795 | 0 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g17955 | i0 | 92.171 | 96.5613126079447 | 562 | 44 | 97 | 0 | 1 | 562 | 5140 | 5701 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 55909 | 795 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 19542887 | 19542887 | PRJNA407886_P_NODE_26836_length_453_cov_1.415789_g25144_i0 | PRJNA407886 | 26836 | 453 | 1.415789 | 6.41352417 | Capillovirus mali | 28347 | Viruses | Viruses | 606 | 7.469999999999996e-169 | NTclustered | gi|2842974839|gb|OR763046.1| | 28347 | g25144 | i0 | 93.204 | 90.6578366445916 | 412 | 28 | 91 | 0 | 42 | 453 | 5557 | 5146 | Capillovirus mali isolate A3, complete genome | blastn | 41068 | 606 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 19543940 | 19543940 | PRJNA407886_P_NODE_79836_length_242_cov_1.798817_g78142_i0 | PRJNA407886 | 79836 | 242 | 1.798817 | 4.35313714 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 414 | 2.41e-111 | NTclustered | gi|2054457545|tpg|BK031457.1| | 2832643 | g78142 | i0 | 97.521 | 29.8388429752066 | 242 | 6 | 100 | 0 | 1 | 242 | 18436 | 18195 | MAG TPA_asm: Caudoviricetes sp. isolate ctiLO4, partial genome | blastn | 7221 | 414 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20818741 | 20818741 | PRJNA407886_P_NODE_26837_length_453_cov_1.410526_g25145_i0 | PRJNA407886 | 26837 | 453 | 1.410526 | 6.38968278 | Capillovirus mali | 28347 | Viruses | Viruses | 784 | 0 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g25145 | i0 | 98.004 | 99.3399558498896 | 451 | 9 | 99 | 0 | 1 | 451 | 5905 | 6355 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 45001 | 784 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 20819821 | 20819821 | PRJNA407886_P_NODE_78857_length_243_cov_1.282353_g77163_i0 | PRJNA407886 | 78857 | 243 | 1.282353 | 3.11611779 | Capillovirus mali | 28347 | Viruses | Viruses | 372 | 1.48e-98 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g77163 | i0 | 94.583 | 2.92592592592593 | 240 | 13 | 99 | 0 | 1 | 240 | 751 | 990 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 711 | 372 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 22093618 | 22093618 | PRJNA407886_P_NODE_30438_length_414_cov_1.741935_g28744_i0 | PRJNA407886 | 30438 | 414 | 1.741935 | 7.2116109 | Gonad-specific virus | 134999 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1059791114|gb|AH009832.2| | 134999 | g28744 | i0 | 100 | 0.072463768115942 | 30 | 0 | 7 | 0 | 89 | 118 | 1412 | 1441 | Gonad-specific virus sequence | blastn | 30 | 56.5 | 1 | Viruses | Naldaviricetes | Lefavirales | Baculoviridae | Gonad-specific virus | |||||
| 23369335 | 23369335 | PRJNA407886_P_NODE_35439_length_374_cov_1.521595_g33745_i0 | PRJNA407886 | 35439 | 374 | 1.521595 | 5.6907653 | Capillovirus mali | 28347 | Viruses | Viruses | 213 | 1.54e-50 | NTclustered | gi|1249614036|dbj|LC184612.1| | 28347 | g33745 | i0 | 81.467 | 3.68181818181818 | 259 | 48 | 69 | 0 | 2 | 260 | 2828 | 3086 | Apple stem grooving virus genomic RNA, complete genome, isolate: Nagami | blastn | 1377 | 213 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 23369411 | 23369411 | PRJNA407886_P_NODE_39779_length_348_cov_1.010909_g38085_i0 | PRJNA407886 | 39779 | 348 | 1.010909 | 3.51796332 | Capillovirus mali | 28347 | Viruses | Viruses | 368 | 2.88e-97 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g38085 | i0 | 96.413 | 20.8563218390805 | 223 | 8 | 64 | 0 | 126 | 348 | 1230 | 1008 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 7258 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 23369690 | 23369690 | PRJNA407886_P_NODE_53379_length_293_cov_1.700000_g51685_i0 | PRJNA407886 | 53379 | 293 | 1.7 | 4.981 | Potyvirus phaseovulgaris | 3240595 | Viruses | Viruses | 542 | 1.32e-149 | NTclustered | gi|1935608368|gb|MN786956.1| | 12196 | g51685 | i0 | 100 | 99.5870307167235 | 293 | 0 | 100 | 0 | 1 | 293 | 8054 | 7762 | Bean common mosaic virus isolate SY-Peanut polyprotein gene, complete cds | blastn | 29179 | 542 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus phaseovulgaris | ||
| 23370198 | 23370198 | PRJNA407886_P_NODE_77679_length_244_cov_1.350877_g75985_i0 | PRJNA407886 | 77679 | 244 | 1.350877 | 3.29613988 | Capillovirus mali | 28347 | Viruses | Viruses | 340 | 4.189999999999999e-89 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g75985 | i0 | 92.437 | 1.95081967213115 | 238 | 18 | 98 | 0 | 7 | 244 | 2461 | 2224 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 476 | 340 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 23370350 | 23370350 | PRJNA407886_P_NODE_9519_length_1019_cov_2.165962_g8306_i0 | PRJNA407886 | 9519 | 1019 | 2.165962 | 22.07115278 | Capillovirus mali | 28347 | Viruses | Viruses | 1448 | 0 | NTclustered | gi|939193295|gb|KR185346.1| | 28347 | g8306 | i0 | 92.338 | 99.7939156035329 | 1018 | 78 | 99 | 0 | 2 | 1019 | 5174 | 4157 | Capillovirus mali isolate Cuiguan, complete genome | blastn | 101690 | 1448 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali |
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);;