contig_metadata
25 rows where bioproject = "PRJNA1237347", tax_phylum = "Lenarviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 343546 | 343546 | PRJNA1237347_P_NODE_461081_length_255_cov_1.269231_g454508_i0 | PRJNA1237347 | 461081 | 255 | 1.269231 | 3.23653905 | Ripaglys virus | 3130696 | Viruses | Viruses | 183 | 7.87e-42 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g454508 | i0 | 89.189 | 79.1058823529412 | 148 | 14 | 58 | 2 | 107 | 253 | 755 | 609 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 20172 | 183 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 5441688 | 5441688 | PRJNA1237347_P_NODE_194105_length_442_cov_1.940379_g187533_i0 | PRJNA1237347 | 194105 | 442 | 1.940379 | 8.57647518 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 507 | 7.59e-139 | NTclustered | gi|2465104871|gb|OQ363045.1| | 3028986 | g187533 | i0 | 87.5 | 0.995475113122172 | 440 | 53 | 99 | 2 | 1 | 439 | 347 | 785 | MAG: Hangzhou mito-like virus 9 isolate gl067 genomic sequence | blastn | 440 | 507 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 5446963 | 5446963 | PRJNA1237347_P_NODE_457245_length_256_cov_1.710383_g450672_i0 | PRJNA1237347 | 457245 | 256 | 1.710383 | 4.37858048 | Chronazanb virus | 3129852 | Viruses | Viruses | 147 | 1.04e-30 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g450672 | i0 | 96.591 | 41.81640625 | 88 | 3 | 34 | 0 | 44 | 131 | 4485 | 4398 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 10705 | 147 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 24567209 | 24567209 | PRJNA1237347_P_NODE_322440_length_319_cov_1.784553_g315867_i0 | PRJNA1237347 | 322440 | 319 | 1.784553 | 5.69272407 | Sopawol virus | 3131668 | Viruses | Viruses | 292 | 1.6199999999999999e-74 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g315867 | i0 | 87.451 | 259.432601880878 | 255 | 30 | 80 | 2 | 66 | 319 | 380 | 127 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 82759 | 292 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 26724273 | 26724273 | PRJNA1237347_P_NODE_208081_length_422_cov_2.206304_g201509_i0 | PRJNA1237347 | 208081 | 422 | 2.206304 | 9.31060288 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 95.9 | 7.12e-20 | NR | WWZ85650.1 | 3132560 | g201509 | i0 | 42 | 0.931279620853081 | 131 | 75 | 93.1 | 1 | 398 | 6 | 346 | 475 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 393 | 95.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 | |||
| 26851890 | 26851890 | PRJNA1237347_P_NODE_414901_length_273_cov_1.925000_g408328_i0 | PRJNA1237347 | 414901 | 273 | 1.925 | 5.25525 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 45.4 | 0.00618 | NR | WWZ85650.1 | 3132560 | g408328 | i0 | 62.2 | 0.406593406593407 | 37 | 14 | 40.7 | 0 | 1 | 111 | 597 | 633 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 111 | 45.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 | |||
| 26914672 | 26914672 | PRJNA1237347_P_NODE_214902_length_413_cov_4.250000_g208330_i0 | PRJNA1237347 | 214902 | 413 | 4.25 | 17.5525 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 131 | 8.49e-33 | NR | URG17081.1 | 2583949 | g208330 | i0 | 51.5 | 1.97578692493947 | 136 | 60 | 98.8 | 4 | 6 | 413 | 292 | 421 | URG17081.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 816 | 131 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 26996530 | 26996530 | PRJNA1237347_P_NODE_423102_length_270_cov_1.507614_g416529_i0 | PRJNA1237347 | 423102 | 270 | 1.507614 | 4.0705578 | Lenarviricota | 2732407 | Viruses | Viruses | 76.3 | 8.25e-14 | NR | QIJ70066.1 | 2716639 | g416529 | i0 | 39.6 | 6.55555555555556 | 106 | 45 | 96.7 | 1 | 6 | 266 | 257 | 362 | QIJ70066.1 RNA-dependent RNA polymerase [Annperkins narna-like virus] | diamond | 1770 | 76.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Annperkins narna-like virus | |||
| 27167523 | 27167523 | PRJNA1237347_P_NODE_180762_length_463_cov_4.079487_g174191_i0 | PRJNA1237347 | 180762 | 463 | 4.079487 | 18.88802481 | Sanya narna-like virus 1 | 2970204 | Viruses | Viruses | 239 | 1.38e-71 | NR | UUW20996.1 | 2970204 | g174191 | i0 | 73.9 | 0.991360691144708 | 153 | 39 | 99.1 | 1 | 3 | 461 | 590 | 741 | UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1] | diamond | 459 | 239 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sanya narna-like virus 1 | |||
| 27326040 | 27326040 | PRJNA1237347_P_NODE_370663_length_292_cov_2.141553_g364090_i0 | PRJNA1237347 | 370663 | 292 | 2.141553 | 6.25333476 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 73.6 | 9.95e-13 | NR | WWZ85650.1 | 3132560 | g364090 | i0 | 43.5 | 0.873287671232877 | 85 | 47 | 86.3 | 1 | 291 | 40 | 109 | 193 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 255 | 73.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 | |||
| 27597307 | 27597307 | PRJNA1237347_P_NODE_538364_length_243_cov_0.905882_g531791_i0 | PRJNA1237347 | 538364 | 243 | 0.905882 | 2.20129326 | Viruses | 10239 | Viruses | Viruses | 55.1 | 1.66e-6 | NR | WPR16663.1 | 3067041 | g531791 | i0 | 40.5 | 1.96296296296296 | 79 | 45 | 97.5 | 2 | 238 | 2 | 338 | 414 | WPR16663.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 84] | diamond | 477 | 55.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Moss associated narna-like virus 84 | |||
| 27705586 | 27705586 | PRJNA1237347_P_NODE_67324_length_877_cov_5.478856_g61608_i0 | PRJNA1237347 | 67324 | 877 | 5.478856 | 48.04956712 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 149 | 1.91e-36 | NR | UJQ92837.1 | 2583949 | g61608 | i0 | 39.4 | 1.40592930444698 | 208 | 116 | 71.2 | 4 | 37 | 660 | 43 | 240 | UJQ92837.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 1233 | 149 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 28021070 | 28021070 | PRJNA1237347_P_NODE_550865_length_241_cov_1.714286_g544292_i0 | PRJNA1237347 | 550865 | 241 | 1.714286 | 4.13142926 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 53.1 | 7.73e-6 | NR | URG16580.1 | 2809572 | g544292 | i0 | 41.7 | 0.746887966804979 | 60 | 35 | 74.7 | 0 | 228 | 49 | 1 | 60 | URG16580.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 180 | 53.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28273362 | 28273362 | PRJNA1237347_P_NODE_567506_length_221_cov_6.243243_g560932_i0 | PRJNA1237347 | 567506 | 221 | 6.243243 | 13.79756703 | Sanya narna-like virus 1 | 2970204 | Viruses | Viruses | 121 | 6.5e-30 | NR | UUW20996.1 | 2970204 | g560932 | i0 | 72.2 | 0.97737556561086 | 72 | 20 | 97.7 | 0 | 217 | 2 | 140 | 211 | UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1] | diamond | 216 | 121 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sanya narna-like virus 1 | |||
| 29410112 | 29410112 | PRJNA1237347_P_NODE_73589_length_829_cov_3.685185_g67682_i0 | PRJNA1237347 | 73589 | 829 | 3.685185 | 30.55018365 | Sclerotinia sclerotiorum narnavirus 1 | 2822897 | Viruses | Viruses | 99 | 1.05e-20 | NR | QZE12035.1 | 2822897 | g67682 | i0 | 37.4 | 0.76357056694813 | 211 | 115 | 70.9 | 7 | 161 | 748 | 26 | 234 | QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1] | diamond | 633 | 99 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sclerotinia sclerotiorum narnavirus 1 | ||
| 30199471 | 30199471 | PRJNA1237347_P_NODE_529132_length_244_cov_0.900585_g522559_i0 | PRJNA1237347 | 529132 | 244 | 0.900585 | 2.1974274 | Chronavynt virus | 3129961 | Viruses | Viruses | 57.8 | 1.93e-7 | NR | WZH59023.1 | 3129961 | g522559 | i0 | 42 | 0.995901639344262 | 81 | 36 | 99.6 | 1 | 2 | 244 | 239 | 308 | WZH59023.1 MAG: RNA-dependent RNA polymerase [Chronavynt virus] | diamond | 243 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronavynt virus | |||
| 30483683 | 30483683 | PRJNA1237347_P_NODE_183713_length_458_cov_6.932468_g177142_i0 | PRJNA1237347 | 183713 | 458 | 6.932468 | 31.75070344 | Grapevine wood holobiome associated narna-like virus 17 | 3398653 | Viruses | Viruses | 112 | 1.27e-25 | NR | XOD45385.1 | 3398653 | g177142 | i0 | 50.8 | 0.825327510917031 | 126 | 60 | 82.5 | 2 | 379 | 2 | 34 | 157 | XOD45385.1 RdRp [Grapevine wood holobiome associated narna-like virus 17] | diamond | 378 | 112 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Grapevine wood holobiome associated narna-like virus 17 | |||
| 30596949 | 30596949 | PRJNA1237347_P_NODE_253913_length_371_cov_1.513423_g247340_i0 | PRJNA1237347 | 253913 | 371 | 1.513423 | 5.61479933 | Wolframvirales | 2732502 | Viruses | Viruses | 109 | 5.44e-25 | NR | QIP68021.1 | 2719804 | g247340 | i0 | 45.5 | 1.94878706199461 | 123 | 67 | 99.5 | 0 | 371 | 3 | 441 | 563 | QIP68021.1 MAG: RNA-dependent RNA polymerase [Bremia lactucae associated splipalmivirus 1] | diamond | 723 | 109 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus bremiae | ||
| 30894586 | 30894586 | PRJNA1237347_P_NODE_221274_length_405_cov_4.018072_g214702_i0 | PRJNA1237347 | 221274 | 405 | 4.018072 | 16.2731916 | Bremia lactucae associated splipalmivirus 1 | 2719804 | Viruses | Viruses | 44.7 | 0.0446 | NR | UZC38463.1 | 2719804 | g214702 | i0 | 34 | 0.785185185185185 | 106 | 56 | 72.6 | 4 | 399 | 106 | 617 | 716 | UZC38463.1 MAG: RNA-dependent RNA polymerase [Bremia lactucae associated splipalmivirus 1] | diamond | 318 | 44.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus bremiae | ||
| 31178434 | 31178434 | PRJNA1237347_P_NODE_17695_length_1885_cov_5.012693_g15402_i0 | PRJNA1237347 | 17695 | 1885 | 5.012693 | 94.48926305 | Qianjiang botourmia-like virus 7 | 3347318 | Viruses | Viruses | 222 | 7.78e-61 | NR | XHA87386.1 | 3347318 | g15402 | i0 | 40.6 | 0.490185676392573 | 308 | 156 | 47.6 | 8 | 10 | 906 | 221 | 510 | XHA87386.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang botourmia-like virus 7] | diamond | 924 | 222 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Qianjiang botourmia-like virus 7 | |||
| 32318196 | 32318196 | PRJNA1237347_P_NODE_455519_length_257_cov_1.396739_g448946_i0 | PRJNA1237347 | 455519 | 257 | 1.396739 | 3.58961923 | Rhizopus microsporus mitovirus 1 | 2918176 | Viruses | Viruses | 84.3 | 1.01e-16 | NR | BDF97663.1 | 2918176 | g448946 | i0 | 52.4 | 0.980544747081712 | 84 | 39 | 98.1 | 1 | 2 | 253 | 247 | 329 | BDF97663.1 RNA-dependent RNA polymerase [Rhizopus microsporus mitovirus 1] | diamond | 252 | 84.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Rhizopus microsporus mitovirus 1 | ||
| 32475801 | 32475801 | PRJNA1237347_P_NODE_102059_length_672_cov_3.156928_g95652_i0 | PRJNA1237347 | 102059 | 672 | 3.156928 | 21.21455616 | Sanya narna-like virus 1 | 2970204 | Viruses | Viruses | 385 | 1.88e-126 | NR | UUW20996.1 | 2970204 | g95652 | i0 | 83.8 | 0.991071428571429 | 222 | 36 | 99.1 | 0 | 667 | 2 | 370 | 591 | UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1] | diamond | 666 | 385 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sanya narna-like virus 1 | |||
| 32507864 | 32507864 | PRJNA1237347_P_NODE_372979_length_291_cov_1.766055_g366406_i0 | PRJNA1237347 | 372979 | 291 | 1.766055 | 5.13922005 | Alternaria tenuissima narnavirus 1 | 2587531 | Viruses | Viruses | 85.9 | 4.53e-17 | NR | QDB74997.1 | 2587531 | g366406 | i0 | 46.2 | 4.79381443298969 | 93 | 47 | 95.9 | 1 | 290 | 12 | 586 | 675 | QDB74997.1 MAG: RNA-dependent RNA polymerase [Alternaria tenuissima narnavirus 1] | diamond | 1395 | 85.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Alternaria tenuissima narnavirus 1 | ||
| 32589369 | 32589369 | PRJNA1237347_P_NODE_121179_length_602_cov_2.166352_g114666_i0 | PRJNA1237347 | 121179 | 602 | 2.166352 | 13.04143904 | Wolframvirales | 2732502 | Viruses | Viruses | 165 | 1.15e-43 | NR | WNA22204.1 | 2719492 | g114666 | i0 | 50 | 1.9485049833887 | 196 | 96 | 97.2 | 2 | 592 | 8 | 224 | 418 | WNA22204.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 1] | diamond | 1173 | 165 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 1 | ||
| 32602343 | 32602343 | PRJNA1237347_P_NODE_339540_length_309_cov_1.512712_g332967_i0 | PRJNA1237347 | 339540 | 309 | 1.512712 | 4.67428008 | Mitovirus sp. | 2587224 | Viruses | Viruses | 48.5 | 7.17e-4 | NR | QDH88391.1 | 2587224 | g332967 | i0 | 31.3 | 0.650485436893204 | 67 | 45 | 65 | 1 | 94 | 294 | 2 | 67 | QDH88391.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] | diamond | 201 | 48.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus 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);;