contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4256633 | 4256633 | PRJNA432257_S_NODE_4384_length_549_cov_44.966797_g4141_i0 | PRJNA432257 | 4384 | 549 | 44.966797 | 246.86771553 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 135 | 9.29e-36 | NR | WNA22213.1 | 2719525 | g4141 | i0 | 65.5 | 0.650273224043716 | 119 | 40 | 65 | 1 | 37 | 393 | 121 | 238 | WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4] | diamond | 357 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 26632600 | 26632600 | PRJNA432257_S_NODE_113161_length_163_cov_1.563492_g112780_i0 | PRJNA432257 | 113161 | 163 | 1.563492 | 2.54849196 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 111 | 9.48e-27 | NR | QKN22646.1 | 2743099 | g112780 | i0 | 88.9 | 0.993865030674847 | 54 | 6 | 99.4 | 0 | 163 | 2 | 1877 | 1930 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 162 | 111 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 26664007 | 26664007 | PRJNA432257_S_NODE_7181_length_458_cov_64.178147_g6868_i0 | PRJNA432257 | 7181 | 458 | 64.178147 | 293.93591326 | Aspen mosaic-associated virus | 2681381 | Viruses | Viruses | 122 | 2.26e-30 | NR | WLF82580.1 | 2681381 | g6868 | i0 | 50 | 1.53930131004367 | 120 | 57 | 76.6 | 1 | 425 | 75 | 186 | 305 | WLF82580.1 nucleoprotein [Aspen mosaic-associated virus] | diamond | 705 | 122 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Fimoviridae | Emaravirus | Emaravirus populi | ||
| 26886154 | 26886154 | PRJNA432257_S_NODE_21781_length_313_cov_1.695652_g21400_i0 | PRJNA432257 | 21781 | 313 | 1.695652 | 5.30739076 | Crogonang virus 135 | 3062923 | Viruses | Viruses | 83.2 | 5.46e-16 | NR | WPR18031.1 | 3062923 | g21400 | i0 | 48.8 | 2.30031948881789 | 80 | 40 | 76.7 | 1 | 313 | 74 | 773 | 851 | WPR18031.1 MAG: capsid protein [Crogonang virus 135] | diamond | 720 | 83.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 135 | ||||
| 27265541 | 27265541 | PRJNA432257_S_NODE_52303_length_227_cov_5.178947_g51922_i0 | PRJNA432257 | 52303 | 227 | 5.178947 | 11.75620969 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 57.8 | 9.15e-8 | NR | WNA22213.1 | 2719525 | g51922 | i0 | 44.8 | 1.40088105726872 | 58 | 32 | 76.7 | 0 | 191 | 18 | 5 | 62 | WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4] | diamond | 318 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 27455232 | 27455232 | PRJNA432257_S_NODE_89063_length_185_cov_1.702703_g88682_i0 | PRJNA432257 | 89063 | 185 | 1.702703 | 3.15000055 | Sjack associated botourmia-like virus 22 | 3066747 | Viruses | Viruses | 57.8 | 8.51e-8 | NR | WPR16987.1 | 3066747 | g88682 | i0 | 60 | 0.810810810810811 | 50 | 20 | 81.1 | 0 | 33 | 182 | 538 | 587 | WPR16987.1 MAG: RNA-dependent RNA polymerase, partial [Sjack associated botourmia-like virus 22] | diamond | 150 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sjack associated botourmia-like virus 22 | |||
| 28465537 | 28465537 | PRJNA432257_S_NODE_58806_length_217_cov_96.222222_g58425_i0 | PRJNA432257 | 58806 | 217 | 96.222222 | 208.80222174 | Yunnan mito-like virus 59 | 2937265 | Viruses | Viruses | 88.2 | 2.64e-18 | NR | UPW42189.1 | 2937265 | g58425 | i0 | 66.7 | 0.829493087557604 | 60 | 20 | 82.9 | 0 | 180 | 1 | 539 | 598 | UPW42189.1 MAG: putative RNA dependent RNA polymerase, partial [Yunnan mito-like virus 59] | diamond | 180 | 88.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Yunnan mito-like virus 59 | |||
| 28465560 | 28465560 | PRJNA432257_S_NODE_9946_length_409_cov_124.607527_g9594_i0 | PRJNA432257 | 9946 | 409 | 124.607527 | 509.64478543 | Exserohilum turcicum narnavirus 1 | 3229034 | Viruses | Viruses | 67.8 | 3.37e-10 | NR | XBY85592.1 | 3229034 | g9594 | i0 | 50 | 0.645476772616137 | 88 | 24 | 57.2 | 4 | 376 | 143 | 1 | 78 | XBY85592.1 MAG: hypothetical protein [Exserohilum turcicum narnavirus 1] | diamond | 264 | 67.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Exserohilum turcicum narnavirus 1 | ||
| 28560242 | 28560242 | PRJNA432257_S_NODE_73867_length_199_cov_3.574074_g73486_i0 | PRJNA432257 | 73867 | 199 | 3.574074 | 7.11240726 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 109 | 7.19e-26 | NR | WLK77416.1 | 3067827 | g73486 | i0 | 75.7 | 1.11557788944724 | 74 | 9 | 98 | 1 | 3 | 197 | 7 | 80 | WLK77416.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 8] | diamond | 222 | 109 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 28812365 | 28812365 | PRJNA432257_S_NODE_106548_length_170_cov_2.052632_g106167_i0 | PRJNA432257 | 106548 | 170 | 2.052632 | 3.4894744 | Clover yellow mosaic virus | 12177 | Viruses | Viruses | 42.4 | 0.0183 | NR | UZP17131.1 | 12177 | g106167 | i0 | 87.5 | 1.27058823529412 | 24 | 3 | 42.4 | 0 | 163 | 92 | 233 | 256 | UZP17131.1 ORF5 [Clover yellow mosaic virus] | diamond | 216 | 42.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 29160271 | 29160271 | PRJNA432257_S_NODE_4009_length_568_cov_8.638418_g3774_i0 | PRJNA432257 | 4009 | 568 | 8.638418 | 49.06621424 | blackberry leaf mottle-associated virus | 3070201 | Viruses | Viruses | 78.6 | 2.14e-13 | NR | QBM15141.1 | 3070201 | g3774 | i0 | 40.9 | 0.670774647887324 | 127 | 70 | 67.1 | 1 | 568 | 188 | 236 | 357 | QBM15141.1 movement protein [blackberry leaf mottle-associated virus] | diamond | 381 | 78.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Fimoviridae | Emaravirus | Emaravirus rubi | ||
| 29270996 | 29270996 | PRJNA432257_S_NODE_79949_length_193_cov_1.961538_g79568_i0 | PRJNA432257 | 79949 | 193 | 1.961538 | 3.78576834 | Chuvivirus | 2842604 | Viruses | Viruses | 52 | 1.06e-5 | NR | YP_010839346.1 | 2842604 | g79568 | i0 | 46.4 | 1.74093264248705 | 56 | 29 | 87 | 1 | 184 | 17 | 454 | 508 | YP_010839346.1 putative nucleoprotein [Wenzhou crab virus 2] | diamond | 336 | 52 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 29664806 | 29664806 | PRJNA432257_S_NODE_108470_length_168_cov_1.786260_g108089_i0 | PRJNA432257 | 108470 | 168 | 1.78626 | 3.0009168 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 93.2 | 2.34e-20 | NR | QKN22646.1 | 2743099 | g108089 | i0 | 76.8 | 1 | 56 | 13 | 100 | 0 | 168 | 1 | 578 | 633 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 168 | 93.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 29744549 | 29744549 | PRJNA432257_S_NODE_106670_length_170_cov_1.759398_g106289_i0 | PRJNA432257 | 106670 | 170 | 1.759398 | 2.9909766 | Picornavirales | 464095 | Viruses | Viruses | 43.9 | 0.00555 | NR | YP_006607894.1 | 2870351 | g106289 | i0 | 41.2 | 5.62941176470588 | 51 | 29 | 90 | 1 | 7 | 159 | 389 | 438 | YP_006607894.1 polyprotein [limnipivirus A1] | diamond | 957 | 43.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Limnipivirus | Limnipivirus ablugi | ||
| 29886403 | 29886403 | PRJNA432257_S_NODE_122731_length_154_cov_3.264957_g122350_i0 | PRJNA432257 | 122731 | 154 | 3.264957 | 5.02803378 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 94 | 1.01e-20 | NR | QKN22646.1 | 2743099 | g122350 | i0 | 96 | 0.974025974025974 | 50 | 2 | 97.4 | 0 | 151 | 2 | 1155 | 1204 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 150 | 94 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 29917989 | 29917989 | PRJNA432257_S_NODE_26491_length_292_cov_1.376471_g26110_i0 | PRJNA432257 | 26491 | 292 | 1.376471 | 4.01929532 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 135 | 2.53e-34 | NR | QKN22646.1 | 2743099 | g26110 | i0 | 68 | 0.996575342465753 | 97 | 31 | 99.7 | 0 | 1 | 291 | 954 | 1050 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 291 | 135 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 29949508 | 29949508 | PRJNA432257_S_NODE_82011_length_191_cov_2.409091_g81630_i0 | PRJNA432257 | 82011 | 191 | 2.409091 | 4.60136381 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 117 | 1.3e-28 | NR | WLK77416.1 | 3067827 | g81630 | i0 | 84.1 | 0.989528795811518 | 63 | 10 | 99 | 0 | 190 | 2 | 673 | 735 | WLK77416.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 8] | diamond | 189 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 29981051 | 29981051 | PRJNA432257_S_NODE_32671_length_271_cov_1.829060_g32290_i0 | PRJNA432257 | 32671 | 271 | 1.82906 | 4.9567526 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 58.9 | 1.07e-7 | NR | UNY42067.1 | 3003959 | g32290 | i0 | 34.9 | 0.952029520295203 | 86 | 54 | 93 | 2 | 270 | 19 | 512 | 597 | UNY42067.1 MAG: polyprotein 2 [Picornavirales sp.] | diamond | 258 | 58.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30107272 | 30107272 | PRJNA432257_S_NODE_100992_length_175_cov_27.202899_g100611_i0 | PRJNA432257 | 100992 | 175 | 27.202899 | 47.60507325 | Plasmopara viticola lesion associated ourmia-like virus 26 | 2686494 | Viruses | Viruses | 69.3 | 6.33e-12 | NR | YP_010800226.1 | 2686494 | g100611 | i0 | 91.7 | 0.617142857142857 | 36 | 3 | 61.7 | 0 | 141 | 34 | 565 | 600 | YP_010800226.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 26] | diamond | 108 | 69.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 30107294 | 30107294 | PRJNA432257_S_NODE_43932_length_242_cov_78.775610_g43551_i0 | PRJNA432257 | 43932 | 242 | 78.77561 | 190.6369762 | Human blood-associated dicistrovirus | 2184748 | Viruses | Viruses | 98.2 | 1.13e-21 | NR | AWK23471.1 | 2184748 | g43551 | i0 | 71.8 | 1.7603305785124 | 71 | 16 | 84.3 | 2 | 205 | 2 | 220 | 289 | AWK23471.1 structural polyprotein, partial [Human blood-associated dicistrovirus] | diamond | 426 | 98.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Human blood-associated dicistrovirus | |||
| 30834103 | 30834103 | PRJNA432257_S_NODE_38514_length_255_cov_1.857798_g38133_i0 | PRJNA432257 | 38514 | 255 | 1.857798 | 4.7373849 | Qianjiang marna-like virus 137 | 3347560 | Viruses | Viruses | 58.9 | 8.51e-8 | NR | XHA88290.1 | 3347560 | g38133 | i0 | 52.1 | 0.564705882352941 | 48 | 23 | 56.5 | 0 | 3 | 146 | 774 | 821 | XHA88290.1 MAG: putative viral coat protein [Qianjiang marna-like virus 137] | diamond | 144 | 58.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 137 | |||
| 32098906 | 32098906 | PRJNA432257_S_NODE_438_length_2108_cov_59.100917_g428_i0 | PRJNA432257 | 438 | 2108 | 59.100917 | 1245.84733036 | Grapevine wood holobiome associated deltaflexivirus 2 | 3384488 | Viruses | Viruses | 54.7 | 2.43e-4 | NR | XLE34830.1 | 3384488 | g428 | i0 | 33 | 0.163662239089184 | 115 | 68 | 15.8 | 2 | 1061 | 1393 | 62 | 171 | XLE34830.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] | diamond | 345 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Grapevine wood holobiome associated deltaflexivirus 2 | ||
| 32130772 | 32130772 | PRJNA432257_S_NODE_110218_length_166_cov_1.813953_g109837_i0 | PRJNA432257 | 110218 | 166 | 1.813953 | 3.01116198 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 41.2 | 0.0459 | NR | ULF99805.1 | 1955144 | g109837 | i0 | 51.7 | 0.524096385542169 | 29 | 14 | 52.4 | 0 | 92 | 6 | 452 | 480 | ULF99805.1 MAG: putative nonstructural polyprotein [Dicistroviridae sp.] | diamond | 87 | 41.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 32320797 | 32320797 | PRJNA432257_S_NODE_439_length_2108_cov_48.098986_g428_i1 | PRJNA432257 | 439 | 2108 | 48.098986 | 1013.92662488 | Grapevine wood holobiome associated deltaflexivirus 2 | 3384488 | Viruses | Viruses | 54.7 | 2.43e-4 | NR | XLE34830.1 | 3384488 | g428 | i1 | 33 | 0.163662239089184 | 115 | 68 | 15.8 | 2 | 1048 | 716 | 62 | 171 | XLE34830.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] | diamond | 345 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Grapevine wood holobiome associated deltaflexivirus 2 | ||
| 32447226 | 32447226 | PRJNA432257_S_NODE_42359_length_246_cov_1.296651_g41978_i0 | PRJNA432257 | 42359 | 246 | 1.296651 | 3.18976146 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 64.3 | 9.58e-10 | NR | XCM68204.1 | 3003959 | g41978 | i0 | 47.6 | 1.98780487804878 | 82 | 41 | 97.6 | 2 | 3 | 242 | 707 | 788 | XCM68204.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 489 | 64.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32510597 | 32510597 | PRJNA432257_S_NODE_79999_length_193_cov_1.750000_g79618_i0 | PRJNA432257 | 79999 | 193 | 1.75 | 3.3775 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 95.9 | 3.58e-21 | NR | XCO49023.1 | 1955144 | g79618 | i0 | 91.8 | 0.761658031088083 | 49 | 4 | 76.2 | 0 | 3 | 149 | 818 | 866 | XCO49023.1 MAG: putative ORF2 protein [Dicistroviridae sp.] | diamond | 147 | 95.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 32731077 | 32731077 | PRJNA432257_S_NODE_67920_length_206_cov_1.254438_g67539_i0 | PRJNA432257 | 67920 | 206 | 1.254438 | 2.58414228 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 131 | 1.22e-33 | NR | QKN22646.1 | 2743099 | g67539 | i0 | 94.1 | 0.990291262135922 | 68 | 4 | 99 | 0 | 2 | 205 | 1215 | 1282 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 204 | 131 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 |
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);;