contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4357486 | 4357486 | PRJNA556992_P_NODE_555944_length_262_cov_3.259259_g553755_i0 | PRJNA556992 | 555944 | 262 | 3.259259 | 8.53925858 | Chrocagost virus | 3129398 | Viruses | Viruses | 302 | 2.15e-77 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g553755 | i0 | 87.405 | 368.530534351145 | 262 | 33 | 100 | 0 | 1 | 262 | 5601 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 96555 | 302 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 5634118 | 5634118 | PRJNA556992_P_NODE_55825_length_492_cov_2.854415_g53660_i0 | PRJNA556992 | 55825 | 492 | 2.854415 | 14.0437218 | Sonawaq virus | 3131534 | Viruses | Viruses | 121 | 1.3e-22 | NTclustered | gi|2717322765|gb|PP173835.1| | 3131534 | g53660 | i0 | 90.323 | 2.6890243902439 | 93 | 7 | 19 | 1 | 398 | 490 | 209 | 119 | MAG: Sonawaq virus isolate SN1_k141_191803 genomic sequence | blastn | 1323 | 121 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sonawaq virus | |||
| 6907006 | 6907006 | PRJNA556992_P_NODE_463166_length_270_cov_3.451777_g460977_i0 | PRJNA556992 | 463166 | 270 | 3.451777 | 9.3197979 | Koteshevirus allodinebrenecus | 3430228 | Viruses | Viruses | 418 | 2.1199999999999993e-112 | NTclustered | gi|2284932147|gb|OM514457.1| | 2970036 | g460977 | i0 | 94.776 | 2.97777777777778 | 268 | 14 | 99 | 0 | 3 | 270 | 3016 | 2749 | MAG: Sanya fiers-like virus 3 isolate QJZLS298 maturation protein, hypothetical protein, and RNA replicase beta chain genes, complete cds | blastn | 804 | 418 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Koteshevirus | Koteshevirus allodinebrenecus | ||
| 9462147 | 9462147 | PRJNA556992_P_NODE_832228_length_244_cov_2.216374_g830038_i0 | PRJNA556992 | 832228 | 244 | 2.216374 | 5.40795256 | Tianjin Botou tick virus 3 | 2972071 | Viruses | Viruses | 392 | 1.14e-104 | NTclustered | gi|2320152917|gb|ON746361.1| | 2972071 | g830038 | i0 | 95.868 | 6.9672131147541 | 242 | 10 | 99 | 0 | 1 | 242 | 2022 | 1781 | MAG: Tianjin Botou tick virus 3 isolate TIGMIC 3 genomic sequence | blastn | 1700 | 392 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tianjin Botou tick virus 3 | |||
| 10730746 | 10730746 | PRJNA556992_P_NODE_277809_length_293_cov_37.536364_g275620_i0 | PRJNA556992 | 277809 | 293 | 37.536364 | 109.98154652 | Leviviridae sp. | 2027243 | Viruses | Viruses | 100 | 9.57e-17 | NTclustered | gi|2183423903|gb|MZ679790.1| | 2027243 | g275620 | i0 | 100 | 7.79522184300341 | 54 | 0 | 18 | 0 | 1 | 54 | 2994 | 3047 | MAG: Leviviridae sp. isolate R28-k141_67620 genomic sequence | blastn | 2284 | 100 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 10732508 | 10732508 | PRJNA556992_P_NODE_406649_length_276_cov_1.448276_g404460_i0 | PRJNA556992 | 406649 | 276 | 1.448276 | 3.99724176 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 111 | 4.13e-20 | NTclustered | gi|2320142600|gb|ON585073.1| | 2808997 | g404460 | i0 | 96.97 | 0.66304347826087 | 66 | 2 | 24 | 0 | 203 | 268 | 77 | 12 | MAG: Botourmiaviridae sp. isolate PMS7_Contig664 RNA-dependent RNA polymerase gene, partial cds | blastn | 183 | 111 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 12003598 | 12003598 | PRJNA556992_P_NODE_159410_length_351_cov_5.532374_g157222_i0 | PRJNA556992 | 159410 | 351 | 5.532374 | 19.41863274 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 344 | 4.89e-90 | NTclustered | gi|2465104871|gb|OQ363045.1| | 3028986 | g157222 | i0 | 96.618 | 0.58974358974359 | 207 | 7 | 59 | 0 | 9 | 215 | 207 | 1 | MAG: Hangzhou mito-like virus 9 isolate gl067 genomic sequence | blastn | 207 | 344 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 13285404 | 13285404 | PRJNA556992_P_NODE_64971_length_466_cov_1.625954_g62799_i0 | PRJNA556992 | 64971 | 466 | 1.625954 | 7.57694564 | Penoulivirus deltaplasmoparae | 2956288 | Viruses | Viruses | 726 | 0 | NTclustered | gi|2500381428|ref|NC_076814.1| | 2686559 | g62799 | i0 | 94.839 | 2.99356223175966 | 465 | 24 | 99 | 0 | 1 | 465 | 1947 | 2411 | Plasmopara viticola lesion associated ourmia-like virus 85 isolate DMG-C_28820 RNA dependent RNA polymerase (QKR90_gp1) gene, complete cds | blastn | 1395 | 726 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus deltaplasmoparae | ||
| 15825992 | 15825992 | PRJNA556992_P_NODE_111273_length_392_cov_2.435737_g109089_i0 | PRJNA556992 | 111273 | 392 | 2.435737 | 9.54808904 | Ripachij virus | 3130407 | Viruses | Viruses | 505 | 2.3899999999999995e-138 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g109089 | i0 | 90.181 | 342.591836734694 | 387 | 38 | 99 | 0 | 1 | 387 | 726 | 340 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 134296 | 505 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 15830330 | 15830330 | PRJNA556992_P_NODE_345733_length_282_cov_7.516746_g343544_i0 | PRJNA556992 | 345733 | 282 | 7.516746 | 21.19722372 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 424 | 4.7799999999999996e-114 | NTclustered | gi|2465104871|gb|OQ363045.1| | 3028986 | g343544 | i0 | 94.224 | 0.982269503546099 | 277 | 16 | 98 | 0 | 1 | 277 | 1446 | 1170 | MAG: Hangzhou mito-like virus 9 isolate gl067 genomic sequence | blastn | 277 | 424 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 17103155 | 17103155 | PRJNA556992_P_NODE_209314_length_322_cov_2.277108_g207126_i0 | PRJNA556992 | 209314 | 322 | 2.277108 | 7.33228776 | Chrocagosk virus | 3129397 | Viruses | Viruses | 483 | 9.039999999999999e-132 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g207126 | i0 | 94.304 | 47.4968944099379 | 316 | 17 | 98 | 1 | 1 | 316 | 315 | 1 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 15294 | 483 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 17105341 | 17105341 | PRJNA556992_P_NODE_353954_length_281_cov_15.024038_g351765_i0 | PRJNA556992 | 353954 | 281 | 15.024038 | 42.21754678 | Ripathur virus | 3131462 | Viruses | Viruses | 241 | 5.15e-59 | NTclustered | gi|2717322585|gb|PP173764.1| | 3131462 | g351765 | i0 | 86.486 | 1.80427046263345 | 222 | 27 | 78 | 3 | 62 | 281 | 1 | 221 | MAG: Ripathur virus isolate RCCP2_k141_225201 genomic sequence | blastn | 507 | 241 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathur virus | |||||
| 17109894 | 17109894 | PRJNA556992_P_NODE_721094_length_250_cov_1.480226_g718905_i0 | PRJNA556992 | 721094 | 250 | 1.480226 | 3.700565 | Ripastyr virus | 3131364 | Viruses | Viruses | 89.8 | 1.73e-13 | NTclustered | gi|2717322326|gb|PP173666.1| | 3131364 | g718905 | i0 | 75.109 | 2.236 | 229 | 37 | 90 | 11 | 1 | 224 | 890 | 1103 | MAG: Ripastyr virus isolate MP3_k141_6580 genomic sequence | blastn | 559 | 89.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripastyr virus | |||||
| 18377780 | 18377780 | PRJNA556992_P_NODE_241615_length_309_cov_1.165254_g239427_i0 | PRJNA556992 | 241615 | 309 | 1.165254 | 3.60063486 | Penoulivirus deltaplasmoparae | 2956288 | Viruses | Viruses | 520 | 6.579999999999998e-143 | NTclustered | gi|2396039604|gb|ON812880.1| | 2686559 | g239427 | i0 | 97.078 | 1.99676375404531 | 308 | 9 | 99 | 0 | 2 | 309 | 466 | 159 | MAG: Plasmopara viticola lesion associated ourmia-like virus 85 isolate TIGMIC_1, complete genome | blastn | 617 | 520 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus deltaplasmoparae | ||
| 18382854 | 18382854 | PRJNA556992_P_NODE_62075_length_473_cov_3.740000_g59904_i0 | PRJNA556992 | 62075 | 473 | 3.74 | 17.6902 | Ripaglys virus | 3130696 | Viruses | Viruses | 361 | 6.73e-95 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g59904 | i0 | 80.462 | 410.32769556025403 | 476 | 89 | 100 | 4 | 1 | 473 | 1691 | 1217 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 194085 | 361 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 18383377 | 18383377 | PRJNA556992_P_NODE_661495_length_254_cov_1.690608_g659306_i0 | PRJNA556992 | 661495 | 254 | 1.6906080000000001 | 4.29414432 | Ripachij virus | 3130407 | Viruses | Viruses | 296 | 9.65e-76 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g659306 | i0 | 88.618 | 133.594488188976 | 246 | 24 | 96 | 4 | 6 | 249 | 548 | 305 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 33933 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 19656801 | 19656801 | PRJNA556992_P_NODE_580656_length_260_cov_3.117647_g578467_i0 | PRJNA556992 | 580656 | 260 | 3.117647 | 8.1058822 | Chrocaryrb virus | 3129548 | Viruses | Viruses | 315 | 2.7399999999999992e-81 | NTclustered | gi|2717317854|gb|PP171996.1| | 3129548 | g578467 | i0 | 88.76 | 181.757692307692 | 258 | 27 | 99 | 2 | 1 | 257 | 1231 | 1487 | MAG: Chrocaryrb virus isolate CC1C_k141_106130 genomic sequence | blastn | 47257 | 315 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocaryrb virus | |||||
| 22203037 | 22203037 | PRJNA556992_P_NODE_241818_length_308_cov_9.323404_g239630_i0 | PRJNA556992 | 241818 | 308 | 9.323404 | 28.71608432 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 486 | 6.649999999999999e-133 | NTclustered | gi|2465104871|gb|OQ363045.1| | 3028986 | g239630 | i0 | 95.13 | 1 | 308 | 15 | 100 | 0 | 1 | 308 | 1907 | 1600 | MAG: Hangzhou mito-like virus 9 isolate gl067 genomic sequence | blastn | 308 | 486 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 23476263 | 23476263 | PRJNA556992_P_NODE_116339_length_387_cov_1.423567_g114152_i0 | PRJNA556992 | 116339 | 387 | 1.423567 | 5.50920429 | Sopaded virus | 3131761 | Viruses | Viruses | 102 | 3.62e-17 | NTclustered | gi|2717323334|gb|PP174062.1| | 3131761 | g114152 | i0 | 79.605 | 4.34108527131783 | 152 | 23 | 38 | 8 | 7 | 154 | 482 | 335 | MAG: Sopaded virus isolate SP1C_k141_196651 genomic sequence | blastn | 1680 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopaded virus | |||||
| 23479171 | 23479171 | PRJNA556992_P_NODE_294699_length_289_cov_18.995370_g292510_i0 | PRJNA556992 | 294699 | 289 | 18.99537 | 54.8966193 | Sopazov virus | 3131687 | Viruses | Viruses | 357 | 5.06e-94 | NTclustered | gi|2717323152|gb|PP173988.1| | 3131687 | g292510 | i0 | 90.253 | 43.3944636678201 | 277 | 22 | 95 | 5 | 14 | 288 | 330 | 57 | MAG: Sopazov virus isolate SP1B_k141_222276 genomic sequence | blastn | 12541 | 357 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopazov virus | |||||
| 24078342 | 24078342 | PRJNA556992_P_NODE_46279_length_528_cov_2.657143_g44121_i0 | PRJNA556992 | 46279 | 528 | 2.657143 | 14.02971504 | Ourmiavirus | 186783 | Viruses | Viruses | 885 | 0 | NTclustered | gi|2819071937|gb|PQ150549.1| | 2741821 | g44121 | i0 | 96.964 | 10.5094696969697 | 527 | 16 | 99 | 0 | 1 | 527 | 494 | 1020 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate Hebei_128 genomic sequence | blastn | 5549 | 891 | 0.993265993265993 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 24748035 | 24748035 | PRJNA556992_P_NODE_100180_length_405_cov_1.870482_g97996_i0 | PRJNA556992 | 100180 | 405 | 1.870482 | 7.5754521 | Tianjin Botou tick virus 3 | 2972071 | Viruses | Viruses | 693 | 0 | NTclustered | gi|2320152917|gb|ON746361.1| | 2972071 | g97996 | i0 | 97.531 | 14.7382716049383 | 405 | 10 | 100 | 0 | 1 | 405 | 1527 | 1123 | MAG: Tianjin Botou tick virus 3 isolate TIGMIC 3 genomic sequence | blastn | 5969 | 693 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tianjin Botou tick virus 3 |
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);;