contig_metadata
16 rows where bioproject = "PRJNA591127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 565097 | 565097 | PRJNA591127_P_NODE_23261_length_179_cov_3.661972_g23092_i0 | PRJNA591127 | 23261 | 179 | 3.661972 | 6.55492988 | Ripasluj virus | 3131271 | Viruses | Viruses | 272 | 1.07e-68 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g23092 | i0 | 94.828 | 70.5307262569832 | 174 | 9 | 97 | 0 | 6 | 179 | 224 | 51 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 12625 | 272 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj virus | |||||
| 4966837 | 4966837 | PRJNA591127_P_NODE_16944_length_197_cov_2.637500_g16775_i0 | PRJNA591127 | 16944 | 197 | 2.6375 | 5.195875 | Tobamovirus | 12234 | Viruses | Viruses | 141 | 3.5400000000000003e-29 | NTclustered | gi|323404090|gb|HQ593616.1| | 12253 | g16775 | i0 | 100 | 62.1522842639594 | 76 | 0 | 76 | 0 | 1 | 76 | 151 | 226 | Tomato mosaic virus isolate TMV-Jahrum coat protein (CP) mRNA, complete cds | blastn | 12244 | 141 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 10769381 | 10769381 | PRJNA591127_P_NODE_28189_length_153_cov_1.344828_g28020_i0 | PRJNA591127 | 28189 | 153 | 1.344828 | 2.05758684 | La Jolla virus | 1654357 | Viruses | Viruses | 283 | 4.0799999999999995e-72 | NTclustered | gi|822477602|gb|KP969711.1| | 1654357 | g28020 | i0 | 100 | 23.9542483660131 | 153 | 0 | 100 | 0 | 1 | 153 | 6297 | 6145 | La Jolla virus isolate LJ19_LaJolla polyprotein gene, partial cds | blastn | 3665 | 283 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | La Jolla virus | |||
| 10769473 | 10769473 | PRJNA591127_P_NODE_9989_length_233_cov_1.479592_g9821_i0 | PRJNA591127 | 9989 | 233 | 1.479592 | 3.44744936 | Chrocurosk virus | 3129322 | Viruses | Viruses | 302 | 1.88e-77 | NTclustered | gi|2717317280|gb|PP171770.1| | 3129322 | g9821 | i0 | 90.789 | 216.643776824034 | 228 | 17 | 97 | 4 | 7 | 232 | 1896 | 1671 | MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence | blastn | 50478 | 302 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocurosk virus | |||
| 12044177 | 12044177 | PRJNA591127_P_NODE_22510_length_184_cov_3.829932_g22341_i0 | PRJNA591127 | 22510 | 184 | 3.829932 | 7.04707488 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 335 | 1.3899999999999996e-87 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g22341 | i0 | 99.457 | 1 | 184 | 1 | 100 | 0 | 1 | 184 | 4319 | 4136 | Malassezia restricta virus MrV40L, complete genome | blastn | 184 | 335 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 13319045 | 13319045 | PRJNA591127_P_NODE_24751_length_170_cov_1.330827_g24582_i0 | PRJNA591127 | 24751 | 170 | 1.330827 | 2.2624059 | Tobamovirus viridimaculae | 3432895 | Viruses | Viruses | 315 | 1.64e-81 | NTclustered | gi|1338641401|gb|KY977430.1| | 12235 | g24582 | i0 | 100 | 100 | 170 | 0 | 100 | 0 | 1 | 170 | 282 | 113 | Cucumber green mottle mosaic virus isolate CGMMV-NMG coat protein (cp) gene, complete cds | blastn | 17000 | 315 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 13892973 | 13892973 | PRJNA591127_P_NODE_8251_length_257_cov_1.259091_g8083_i0 | PRJNA591127 | 8251 | 257 | 1.259091 | 3.23586387 | Tobamovirus | 12234 | Viruses | Viruses | 475 | 1.1699999999999999e-129 | NTclustered | gi|1782797563|gb|MK933286.1| | 12235 | g8083 | i0 | 100 | 100 | 257 | 0 | 100 | 0 | 1 | 257 | 159 | 415 | Cucumber green mottle mosaic virus isolate GDLZ, complete genome | blastn | 25700 | 475 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 18417049 | 18417049 | PRJNA591127_P_NODE_8255_length_257_cov_0.881818_g8087_i0 | PRJNA591127 | 8255 | 257 | 0.881818 | 2.26627226 | Ripathuj virus | 3131458 | Viruses | Viruses | 281 | 2.74e-71 | NTclustered | gi|2717322573|gb|PP173760.1| | 3131458 | g8087 | i0 | 86.853 | 188.782101167315 | 251 | 33 | 98 | 0 | 7 | 257 | 469 | 219 | MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence | blastn | 48517 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathuj virus | |||||
| 23517461 | 23517461 | PRJNA591127_P_NODE_25739_length_164_cov_4.401575_g25570_i0 | PRJNA591127 | 25739 | 164 | 4.401575 | 7.218583 | Cucumovirus CMV | 3428131 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|2296356105|gb|MW926533.1| | 12305 | g25570 | i0 | 100 | 100.042682926829 | 164 | 0 | 100 | 0 | 1 | 164 | 1775 | 1938 | Cucumber mosaic virus isolate CH99 3a protein and CP genes, complete cds | blastn | 16407 | 303 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus CMV | ||
| 23517473 | 23517473 | PRJNA591127_P_NODE_27259_length_157_cov_2.250000_g27090_i0 | PRJNA591127 | 27259 | 157 | 2.25 | 3.5325 | Chronazanb virus | 3129852 | Viruses | Viruses | 126 | 7.53e-25 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g27090 | i0 | 95 | 8.15286624203822 | 80 | 4 | 51 | 0 | 1 | 80 | 4477 | 4398 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 1280 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 24791159 | 24791159 | PRJNA591127_P_NODE_13780_length_198_cov_1.503106_g13611_i0 | PRJNA591127 | 13780 | 198 | 1.503106 | 2.97614988 | Ripachij virus | 3130407 | Viruses | Viruses | 250 | 5.67e-62 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g13611 | i0 | 89.394 | 217.570707070707 | 198 | 21 | 100 | 0 | 1 | 198 | 613 | 416 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 43079 | 250 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 24791261 | 24791261 | PRJNA591127_P_NODE_24740_length_170_cov_1.458647_g24571_i0 | PRJNA591127 | 24740 | 170 | 1.458647 | 2.4796999 | Cucumovirus PSV | 3428133 | Viruses | Viruses | 309 | 7.64e-80 | NTclustered | gi|55140577|gb|AY775057.1| | 12313 | g24571 | i0 | 99.412 | 63.5352941176471 | 170 | 1 | 100 | 0 | 1 | 170 | 1381 | 1550 | Peanut stunt virus, complete genome | blastn | 10801 | 309 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Cucumovirus | Cucumovirus PSV | ||
| 28595767 | 28595767 | PRJNA591127_P_NODE_22887_length_182_cov_1.344828_g22718_i0 | PRJNA591127 | 22887 | 182 | 1.344828 | 2.44758696 | Leviviridae sp. | 2027243 | Viruses | Viruses | 75.9 | 3.43e-14 | NR | URG16528.1 | 2027243 | g22718 | i0 | 56.7 | 1.97802197802198 | 60 | 26 | 98.9 | 0 | 180 | 1 | 509 | 568 | URG16528.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 360 | 75.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30585053 | 30585053 | PRJNA591127_P_NODE_21433_length_192_cov_2.754839_g21264_i0 | PRJNA591127 | 21433 | 192 | 2.754839 | 5.28929088 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 49.3 | 9.26e-5 | NR | UVF58767.1 | 2951531 | g21264 | i0 | 34.9 | 0.984375 | 63 | 41 | 98.4 | 0 | 3 | 191 | 90 | 152 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 189 | 49.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 31944470 | 31944470 | PRJNA591127_P_NODE_26257_length_162_cov_1.248000_g26088_i0 | PRJNA591127 | 26257 | 162 | 1.248 | 2.02176 | ssRNA phage Gerhypos.2_3 | 2786263 | Viruses | Viruses | 70.5 | 1.98e-12 | NR | YP_010770593.1 | 2786264 | g26088 | i0 | 75 | 0.740740740740741 | 40 | 10 | 74.1 | 0 | 3 | 122 | 368 | 407 | YP_010770593.1 maturation protein, partial [ssRNA phage Gerhypos.2_30] | diamond | 120 | 70.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neosolivicinum | ||
| 32166328 | 32166328 | PRJNA591127_P_NODE_25998_length_163_cov_1.857143_g25829_i0 | PRJNA591127 | 25998 | 163 | 1.857143 | 3.02714309 | Plasmopara viticola lesion associated ourmia-like virus 82 | 2686556 | Viruses | Viruses | 108 | 1.06e-25 | NR | YP_010800276.1 | 2686556 | g25829 | i0 | 90.6 | 0.975460122699387 | 53 | 5 | 97.5 | 0 | 3 | 161 | 231 | 283 | YP_010800276.1 RNA dependent RNA polymerase, partial [Plasmopara viticola lesion associated ourmia-like virus 82] | diamond | 159 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaplasmoparae |
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);;