contig_metadata
27 rows where bioproject = "PRJNA946307", tax_phylum = "Pisuviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 926799 | 926799 | PRJNA946307_P_NODE_1_length_8287_cov_76.507162_g0_i0 | PRJNA946307 | 1 | 8287 | 76.507162 | 6340.14851494 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 2486 | 0 | NR | XCO49139.1 | 1955144 | g0 | i0 | 79.1 | 0.558947749487149 | 1544 | 239 | 53.5 | 7 | 1759 | 6195 | 1 | 1525 | XCO49139.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] | diamond | 4632 | 2486 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 4756126 | 4756126 | PRJNA946307_P_NODE_6984_length_534_cov_3.657732_g6198_i0 | PRJNA946307 | 6984 | 534 | 3.657732 | 19.53228888 | Poaceae Liege partitivirus 6 | 2972889 | Viruses | Viruses | 944 | 0 | NTclustered | gi|2288738604|gb|OL330745.1| | 2972889 | g6198 | i0 | 99.423 | 1.02808988764045 | 520 | 3 | 97 | 0 | 15 | 534 | 817 | 1336 | Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds | blastn | 549 | 944 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Poaceae Liege partitivirus 6 | |||
| 6028711 | 6028711 | PRJNA946307_P_NODE_101305_length_183_cov_4.029851_g100431_i0 | PRJNA946307 | 101305 | 183 | 4.029851 | 7.37462733 | Pinus sylvestris partitivirus NL-2005 | 328694 | Viruses | Viruses | 291 | 3.03e-74 | NTclustered | gi|66476364|gb|AY973825.1| | 328694 | g100431 | i0 | 99.375 | 0.87431693989071 | 160 | 1 | 87 | 0 | 10 | 169 | 1078 | 919 | Pinus sylvestris partitivirus NL-2005 putative RNA-dependent RNA polymerase gene, partial cds | blastn | 160 | 291 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Pinus sylvestris partitivirus NL-2005 | |||
| 8580996 | 8580996 | PRJNA946307_P_NODE_8867_length_460_cov_2.328467_g8036_i0 | PRJNA946307 | 8867 | 460 | 2.328467 | 10.7109482 | Poaceae Liege partitivirus 6 | 2972889 | Viruses | Viruses | 802 | 0 | NTclustered | gi|2288738604|gb|OL330745.1| | 2972889 | g8036 | i0 | 99.103 | 0.969565217391304 | 446 | 4 | 97 | 0 | 1 | 446 | 479 | 34 | Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds | blastn | 446 | 802 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Poaceae Liege partitivirus 6 | |||
| 9855211 | 9855211 | PRJNA946307_P_NODE_38768_length_214_cov_3.048485_g37894_i0 | PRJNA946307 | 38768 | 214 | 3.048485 | 6.5237579 | Nepovirus betae | 3050242 | Viruses | Viruses | 327 | 2.8e-85 | NTclustered | gi|2073348417|gb|MZ202338.1| | 191547 | g37894 | i0 | 96.465 | 27.1448598130841 | 198 | 7 | 93 | 0 | 1 | 198 | 1080 | 883 | Beet ringspot virus isolate DSMZ PV-0521 segment RNA 2, complete sequence | blastn | 5809 | 327 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betae | ||
| 11131729 | 11131729 | PRJNA946307_P_NODE_89929_length_189_cov_1.100000_g89055_i0 | PRJNA946307 | 89929 | 189 | 1.1 | 2.079 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 324 | 3.11e-84 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g89055 | i0 | 100 | 92.5925925925926 | 175 | 0 | 93 | 0 | 15 | 189 | 12139 | 12313 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 17500 | 324 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12406925 | 12406925 | PRJNA946307_P_NODE_71110_length_199_cov_2.993333_g70236_i0 | PRJNA946307 | 71110 | 199 | 2.993333 | 5.95673267 | Erysiphe necator associated fusarivirus 3 | 2743151 | Viruses | Viruses | 156 | 1.28e-33 | NTclustered | gi|1851774059|gb|MN627479.1| | 2743151 | g70236 | i0 | 95.833 | 0.919597989949749 | 96 | 4 | 91 | 0 | 5 | 100 | 887 | 792 | Erysiphe necator associated fusarivirus 3 isolate PMS5_DN29549, complete genome | blastn | 183 | 156 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Erysiphe necator associated fusarivirus 3 | |||
| 13681314 | 13681314 | PRJNA946307_P_NODE_62671_length_202_cov_3.183007_g61797_i0 | PRJNA946307 | 62671 | 202 | 3.183007 | 6.42967414 | Porcine picobirnavirus | 442302 | Viruses | Viruses | 111 | 2.86e-20 | NTclustered | gi|2095880689|gb|MW978564.1| | 442302 | g61797 | i0 | 90.476 | 1.92574257425743 | 84 | 8 | 82 | 0 | 19 | 102 | 2122 | 2205 | MAG: Porcine picobirnavirus isolate 15217_NODE_144_len_2531_cov_92.661147 hypothetical protein and capsid protein-like gene, partial sequence | blastn | 389 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Porcine picobirnavirus | ||
| 14955447 | 14955447 | PRJNA946307_P_NODE_56952_length_210_cov_2.770186_g56078_i0 | PRJNA946307 | 56952 | 210 | 2.770186 | 5.8173906 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 191 | 3.74e-44 | NTclustered | gi|2754804027|tpg|BK063169.1| | 3032225 | g56078 | i0 | 84.021 | 0.923809523809524 | 194 | 26 | 92 | 1 | 17 | 210 | 523 | 711 | TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds | blastn | 194 | 191 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 18778653 | 18778653 | PRJNA946307_P_NODE_21715_length_274_cov_10.493333_g20842_i0 | PRJNA946307 | 21715 | 274 | 10.493333 | 28.75173242 | Hanko picorna-like virus | 2980576 | Viruses | Viruses | 442 | 1.2799999999999994e-119 | NTclustered | gi|2320141567|gb|ON955109.1| | 2980576 | g20842 | i0 | 97.308 | 2.84671532846715 | 260 | 7 | 95 | 0 | 1 | 260 | 946 | 687 | MAG: Hanko picorna-like virus isolate FIN/U-2018/92-2 polyprotein gene, partial cds | blastn | 780 | 442 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Hanko picorna-like virus | |||
| 20053801 | 20053801 | PRJNA946307_P_NODE_36776_length_218_cov_2.946746_g35902_i0 | PRJNA946307 | 36776 | 218 | 2.946746 | 6.42390628 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 224 | 3.859999999999999e-54 | NTclustered | gi|2754804027|tpg|BK063169.1| | 3032225 | g35902 | i0 | 87.895 | 0.871559633027523 | 190 | 23 | 87 | 0 | 13 | 202 | 881 | 692 | TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds | blastn | 190 | 224 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 20054414 | 20054414 | PRJNA946307_P_NODE_7016_length_532_cov_19.861284_g6230_i0 | PRJNA946307 | 7016 | 532 | 19.861284 | 105.66203088 | Hanko picorna-like virus | 2980576 | Viruses | Viruses | 889 | 0 | NTclustered | gi|2320141565|gb|ON955108.1| | 2980576 | g6230 | i0 | 97.679 | 2.91541353383459 | 517 | 12 | 97 | 0 | 2 | 518 | 1418 | 902 | MAG: Hanko picorna-like virus isolate FIN/U-2018/92-1 polyprotein gene, partial cds | blastn | 1551 | 889 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Hanko picorna-like virus | |||
| 21327937 | 21327937 | PRJNA946307_P_NODE_117577_length_176_cov_2.181102_g116703_i0 | PRJNA946307 | 117577 | 176 | 2.181102 | 3.83873952 | Pinus sylvestris partitivirus NL-2005 | 328694 | Viruses | Viruses | 267 | 4.8699999999999996e-67 | NTclustered | gi|66476364|gb|AY973825.1| | 328694 | g116703 | i0 | 96.319 | 0.926136363636364 | 163 | 5 | 92 | 1 | 1 | 162 | 683 | 521 | Pinus sylvestris partitivirus NL-2005 putative RNA-dependent RNA polymerase gene, partial cds | blastn | 163 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Pinus sylvestris partitivirus NL-2005 | |||
| 21327985 | 21327985 | PRJNA946307_P_NODE_120217_length_175_cov_1.547619_g119343_i0 | PRJNA946307 | 120217 | 175 | 1.547619 | 2.70833325 | Nepovirus betae | 3050242 | Viruses | Viruses | 248 | 1.7499999999999998e-61 | NTclustered | gi|20260800|ref|NC_003694.1| | 191547 | g119343 | i0 | 93.902 | 10.6342857142857 | 164 | 10 | 94 | 0 | 12 | 175 | 1331 | 1494 | Beet ringspot virus RNA 2, complete sequence | blastn | 1861 | 248 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betae | ||
| 21329285 | 21329285 | PRJNA946307_P_NODE_37997_length_215_cov_4.433735_g37123_i0 | PRJNA946307 | 37997 | 215 | 4.433735 | 9.53253025 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 189 | 1.3799999999999999e-43 | NTclustered | gi|2523467093|emb|OX976994.1| | 2697049 | g37123 | i0 | 100 | 93.0325581395349 | 102 | 0 | 94 | 0 | 3 | 104 | 9859 | 9758 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 20002 | 189 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23878544 | 23878544 | PRJNA946307_P_NODE_124599_length_173_cov_1.701613_g123725_i0 | PRJNA946307 | 124599 | 173 | 1.701613 | 2.94379049 | Nepovirus avii | 3047741 | Viruses | Viruses | 252 | 1.33e-62 | NTclustered | gi|2105858737|gb|MT935684.1| | 12615 | g123725 | i0 | 95 | 20.606936416185 | 160 | 8 | 92 | 0 | 14 | 173 | 4608 | 4767 | Cherry leaf roll virus isolate 19NR014 segment RNA1, complete sequence | blastn | 3565 | 252 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 23880666 | 23880666 | PRJNA946307_P_NODE_91619_length_188_cov_1.395683_g90745_i0 | PRJNA946307 | 91619 | 188 | 1.395683 | 2.62388404 | Poaceae Liege partitivirus 6 | 2972889 | Viruses | Viruses | 331 | 1.85e-86 | NTclustered | gi|2288738604|gb|OL330745.1| | 2972889 | g90745 | i0 | 98.404 | 27.4734042553191 | 188 | 3 | 100 | 0 | 1 | 188 | 1557 | 1744 | Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds | blastn | 5165 | 331 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Poaceae Liege partitivirus 6 | |||
| 26740170 | 26740170 | PRJNA946307_P_NODE_81121_length_193_cov_3.034722_g80247_i0 | PRJNA946307 | 81121 | 193 | 3.034722 | 5.85701346 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 47.4 | 4.35e-4 | NR | XCO49265.1 | 1955144 | g80247 | i0 | 69 | 1.33678756476684 | 29 | 9 | 45.1 | 0 | 9 | 95 | 489 | 517 | XCO49265.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] | diamond | 258 | 47.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 27214825 | 27214825 | PRJNA946307_P_NODE_117842_length_176_cov_1.598425_g116968_i0 | PRJNA946307 | 117842 | 176 | 1.598425 | 2.813228 | Scotland dicistro-like virus | 2789512 | Viruses | Viruses | 53.5 | 2.37e-6 | NR | QPN36963.1 | 2789512 | g116968 | i0 | 77.1 | 0.596590909090909 | 35 | 8 | 59.7 | 0 | 162 | 58 | 1886 | 1920 | QPN36963.1 polyprotein 1 [Scotland dicistro-like virus] | diamond | 105 | 53.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Scotland dicistro-like virus | |||
| 27569174 | 27569174 | PRJNA946307_P_NODE_108624_length_180_cov_2.183206_g107750_i0 | PRJNA946307 | 108624 | 180 | 2.183206 | 3.9297708 | Orthopicobirnavirus | 2948851 | Viruses | Viruses | 53.5 | 2.42e-6 | NR | USE07769.1 | 1907787 | g107750 | i0 | 58.3 | 3.46666666666667 | 36 | 15 | 60 | 0 | 121 | 14 | 339 | 374 | USE07769.1 MAG: putative RNA-dependent RNA polymerase, partial [Picobirnavirus sp.] | diamond | 624 | 53.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 28193886 | 28193886 | PRJNA946307_P_NODE_89746_length_189_cov_1.321429_g88872_i0 | PRJNA946307 | 89746 | 189 | 1.321429 | 2.49750081 | Panax cryptic virus 4 | 2809267 | Viruses | Viruses | 56.6 | 2.25e-7 | NR | QRG29207.1 | 2809267 | g88872 | i0 | 74.2 | 0.492063492063492 | 31 | 8 | 49.2 | 0 | 15 | 107 | 225 | 255 | QRG29207.1 putative CP [Panax cryptic virus 4] | diamond | 93 | 56.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Panax cryptic virus 4 | |||
| 29299175 | 29299175 | PRJNA946307_P_NODE_28749_length_241_cov_5.958333_g27875_i0 | PRJNA946307 | 28749 | 241 | 5.958333 | 14.35958253 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 66.6 | 1.45e-10 | NR | QPG92982.1 | 2789378 | g27875 | i0 | 45.6 | 1.96680497925311 | 79 | 38 | 92.1 | 2 | 223 | 2 | 792 | 870 | QPG92982.1 polyprotein [Shenzhen dicistro-like virus] | diamond | 474 | 66.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 30657311 | 30657311 | PRJNA946307_P_NODE_35773_length_220_cov_6.198830_g34899_i0 | PRJNA946307 | 35773 | 220 | 6.19883 | 13.637426 | Trichoderma citrinoviride partitivirus 1 | 2501046 | Viruses | Viruses | 109 | 7.36e-26 | NR | AZT88592.1 | 2501046 | g34899 | i0 | 79.4 | 0.927272727272727 | 68 | 13 | 91.4 | 1 | 216 | 16 | 560 | 627 | AZT88592.1 RNA-dependent RNA polymerase [Trichoderma citrinoviride partitivirus 1] | diamond | 204 | 109 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Trichoderma citrinoviride partitivirus 1 | |||
| 31068286 | 31068286 | PRJNA946307_P_NODE_4295_length_705_cov_23.233232_g3654_i0 | PRJNA946307 | 4295 | 705 | 23.233232 | 163.7942856 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 73.9 | 4.38e-11 | NR | QJI52110.1 | 1955144 | g3654 | i0 | 36.1 | 0.659574468085106 | 155 | 83 | 61.7 | 5 | 653 | 219 | 689 | 837 | QJI52110.1 MAG: hypothetical protein 2 [Dicistroviridae sp.] | diamond | 465 | 73.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 31795217 | 31795217 | PRJNA946307_P_NODE_46197_length_210_cov_4.596273_g45323_i0 | PRJNA946307 | 46197 | 210 | 4.596273 | 9.6521733 | Beet ringspot virus | 191547 | Viruses | Viruses | 59.3 | 3.45e-8 | NR | NP_620113.1 | 191547 | g45323 | i0 | 84.4 | 3.2 | 32 | 5 | 45.7 | 0 | 111 | 206 | 465 | 496 | NP_620113.1 polyprotein [Beet ringspot virus] | diamond | 672 | 59.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betae | ||
| 32111835 | 32111835 | PRJNA946307_P_NODE_172038_length_154_cov_2.704762_g171164_i0 | PRJNA946307 | 172038 | 154 | 2.704762 | 4.16533348 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 87.4 | 1.92e-18 | NR | DBA56413.1 | 3032225 | g171164 | i0 | 95.6 | 0.876623376623377 | 45 | 2 | 87.7 | 0 | 15 | 149 | 656 | 700 | DBA56413.1 TPA_asm: hypothetical protein, partial [Periplaneta americana dicistro-like virus] | diamond | 135 | 87.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 32555154 | 32555154 | PRJNA946307_P_NODE_84999_length_191_cov_1.943662_g84125_i0 | PRJNA946307 | 84999 | 191 | 1.943662 | 3.71239442 | Paris mosaic necrosis virus | 2058396 | Viruses | Viruses | 93.6 | 2.32e-20 | NR | WYJ74782.1 | 2058396 | g84125 | i0 | 75.4 | 0.895287958115183 | 57 | 14 | 89.5 | 0 | 16 | 186 | 251 | 307 | WYJ74782.1 putative RNA-dependent RNA polymerase [Paris mosaic necrosis virus] | diamond | 171 | 93.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus parisnecrosis |
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);;