contig_metadata
21 rows where bioproject = "PRJNA804229" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2079776 | 2079776 | PRJNA804229_S_NODE_36962_length_319_cov_8.101449_g36004_i0 | PRJNA804229 | 36962 | 319 | 8.101449 | 25.84362231 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g36004 | i0 | 100 | 0.178683385579937 | 29 | 0 | 9 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 4630377 | 4630377 | PRJNA804229_S_NODE_122864_length_184_cov_1.397163_g121906_i0 | PRJNA804229 | 122864 | 184 | 1.397163 | 2.57077992 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g121906 | i0 | 100 | 0.152173913043478 | 28 | 0 | 15 | 0 | 157 | 184 | 28 | 1 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 4632489 | 4632489 | PRJNA804229_S_NODE_38364_length_315_cov_2.029412_g37406_i0 | PRJNA804229 | 38364 | 315 | 2.029412 | 6.3926478 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g37406 | i0 | 96.97 | 0.193650793650794 | 33 | 0 | 10 | 1 | 283 | 315 | 37 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 6326003 | 6326003 | PRJNA804229_S_NODE_166385_length_158_cov_1.252174_g165427_i0 | PRJNA804229 | 166385 | 158 | 1.252174 | 1.97843492 | Viruses | 10239 | Viruses | Viruses | 193 | 7.38e-45 | NTclustered | gi|2051094702|tpg|BK014912.1| | 2826306 | g165427 | i0 | 88.608 | 2 | 158 | 18 | 100 | 0 | 1 | 158 | 8200 | 8357 | MAG TPA_asm: Siphoviridae sp. ctNmW2, partial genome | blastn | 316 | 193 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctNmW2 | |||||
| 7183060 | 7183060 | PRJNA804229_S_NODE_66906_length_248_cov_0.956098_g65948_i0 | PRJNA804229 | 66906 | 248 | 0.956098 | 2.37112304 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 58.4 | 4.82e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g65948 | i0 | 100 | 0.237903225806452 | 31 | 0 | 13 | 0 | 1 | 31 | 6 | 36 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 59 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 10150514 | 10150514 | PRJNA804229_S_NODE_137608_length_174_cov_1.320611_g136650_i0 | PRJNA804229 | 137608 | 174 | 1.320611 | 2.29786314 | Copiparvovirus | 1511888 | Viruses | Viruses | 311 | 2.19e-80 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g136650 | i0 | 98.851 | 5 | 174 | 2 | 100 | 0 | 1 | 174 | 4777 | 4604 | Bosavirus MS-2016a, complete genome | blastn | 870 | 311 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 11425903 | 11425903 | PRJNA804229_S_NODE_57689_length_265_cov_2.153153_g56731_i0 | PRJNA804229 | 57689 | 265 | 2.153153 | 5.70585545 | Copiparvovirus | 1511888 | Viruses | Viruses | 444 | 3.42e-120 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g56731 | i0 | 99.588 | 3.93962264150943 | 243 | 1 | 92 | 0 | 1 | 243 | 2415 | 2657 | Bosavirus MS-2016a, complete genome | blastn | 1044 | 444 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 13554994 | 13554994 | PRJNA804229_S_NODE_102171_length_201_cov_2.424051_g101213_i0 | PRJNA804229 | 102171 | 201 | 2.424051 | 4.87234251 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 231 | 2.09e-56 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g101213 | i0 | 89.944 | 1.2636815920398 | 179 | 18 | 89 | 0 | 23 | 201 | 13263 | 13085 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 254 | 231 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16524749 | 16524749 | PRJNA804229_S_NODE_110933_length_193_cov_3.673333_g109975_i0 | PRJNA804229 | 110933 | 193 | 3.673333 | 7.08953269 | Copiparvovirus | 1511888 | Viruses | Viruses | 357 | 3.1499999999999996e-94 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g109975 | i0 | 100 | 5 | 193 | 0 | 100 | 0 | 1 | 193 | 4149 | 4341 | Bosavirus MS-2016a, complete genome | blastn | 965 | 357 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 18655794 | 18655794 | PRJNA804229_S_NODE_5215_length_622_cov_7.250432_g4445_i0 | PRJNA804229 | 5215 | 622 | 7.250432 | 45.09768704 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 977 | 0 | NTclustered | gi|38155067|gb|AY349137.1| | 11786 | g4445 | i0 | 94.803 | 95.2250803858521 | 635 | 20 | 100 | 2 | 1 | 622 | 671 | 37 | Murine leukemia virus isolate Lung-1-2 defective envelope transcript gene, sequence | blastn | 59230 | 977 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 19929915 | 19929915 | PRJNA804229_S_NODE_172536_length_155_cov_1.285714_g171578_i0 | PRJNA804229 | 172536 | 155 | 1.285714 | 1.9928567 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1707894375|gb|MK892579.1| | 2591644 | g171578 | i0 | 100 | 0.187096774193548 | 29 | 0 | 19 | 0 | 48 | 76 | 6609 | 6637 | MAG: Prokaryotic dsDNA virus sp. isolate Unbinned_3907_contig-100_0, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 21204278 | 21204278 | PRJNA804229_S_NODE_121497_length_185_cov_1.507042_g120539_i0 | PRJNA804229 | 121497 | 185 | 1.507042 | 2.7880277 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g120539 | i0 | 100 | 0.308108108108108 | 29 | 0 | 16 | 0 | 157 | 185 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 21207318 | 21207318 | PRJNA804229_S_NODE_74777_length_235_cov_1.750000_g73819_i0 | PRJNA804229 | 74777 | 235 | 1.75 | 4.1125 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 8.569999999999998e-96 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g73819 | i0 | 94.468 | 393.348936170213 | 235 | 13 | 100 | 0 | 1 | 235 | 17939 | 18173 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 92437 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21624015 | 21624015 | PRJNA804229_S_NODE_117477_length_188_cov_1.655172_g116519_i0 | PRJNA804229 | 117477 | 188 | 1.655172 | 3.11172336 | Tetraparvovirus | 1511911 | Viruses | Viruses | 342 | 8.539999999999999e-90 | NTclustered | gi|1372080036|gb|MG745679.1| | 494651 | g116519 | i0 | 99.468 | 73.563829787234 | 188 | 1 | 100 | 0 | 1 | 188 | 2896 | 3083 | Bovine hokovirus 1 isolate Guarapuava nonstructural protein 1 and capsid protein 1 genes, complete cds | blastn | 13830 | 342 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Tetraparvovirus | Tetraparvovirus ungulate1 | ||
| 22481842 | 22481842 | PRJNA804229_S_NODE_71218_length_240_cov_5.172589_g70260_i0 | PRJNA804229 | 71218 | 240 | 5.172589 | 12.4142136 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 438 | 1.4199999999999995e-118 | NTclustered | gi|1167936530|gb|KY574504.1| | 11786 | g70260 | i0 | 99.583 | 100.004166666667 | 240 | 1 | 100 | 0 | 1 | 240 | 7045 | 6806 | Murine leukemia virus isolate AKR13, complete genome | blastn | 24001 | 438 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 23757302 | 23757302 | PRJNA804229_S_NODE_61599_length_257_cov_3.065421_g60641_i0 | PRJNA804229 | 61599 | 257 | 3.065421 | 7.87813197 | Bacteriophage sp. | 38018 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2057076630|tpg|BK037829.1| | 38018 | g60641 | i0 | 100 | 0.439688715953307 | 29 | 0 | 11 | 0 | 66 | 94 | 7630 | 7658 | MAG TPA_asm: Bacteriophage sp. isolate ctiyJ22, partial genome | blastn | 113 | 54.7 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 25028470 | 25028470 | PRJNA804229_S_NODE_123200_length_184_cov_1.021277_g122242_i0 | PRJNA804229 | 123200 | 184 | 1.021277 | 1.87914968 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g122242 | i0 | 100 | 0.766304347826087 | 29 | 0 | 16 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 25448724 | 25448724 | PRJNA804229_S_NODE_7120_length_558_cov_13.246602_g6249_i0 | PRJNA804229 | 7120 | 558 | 13.246602 | 73.91603916 | Copiparvovirus | 1511888 | Viruses | Viruses | 992 | 0 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g6249 | i0 | 99.815 | 4.54121863799283 | 540 | 1 | 97 | 0 | 19 | 558 | 4808 | 5347 | Bosavirus MS-2016a, complete genome | blastn | 2534 | 992 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 26927582 | 26927582 | PRJNA804229_S_NODE_147302_length_168_cov_1.536000_g146344_i0 | PRJNA804229 | 147302 | 168 | 1.536 | 2.58048 | Marsupial endogenous gammaretrovirus 2 | 3386030 | Viruses | Viruses | 44.3 | 0.00404 | NR | DBA62711.1 | 3386030 | g146344 | i0 | 53.5 | 1.53571428571429 | 43 | 14 | 66.1 | 1 | 58 | 168 | 197 | 239 | DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] | diamond | 258 | 44.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Marsupial endogenous gammaretrovirus 2 | ||
| 27307168 | 27307168 | PRJNA804229_S_NODE_159443_length_161_cov_2.033898_g158485_i0 | PRJNA804229 | 159443 | 161 | 2.033898 | 3.27457578 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57.4 | 8.22e-8 | NR | XOR55634.1 | 2832643 | g158485 | i0 | 54.7 | 0.987577639751553 | 53 | 24 | 98.8 | 0 | 2 | 160 | 310 | 362 | XOR55634.1 MAG: TerL [Caudoviricetes sp.] | diamond | 159 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32108934 | 32108934 | PRJNA804229_S_NODE_13698_length_449_cov_3.790640_g12755_i0 | PRJNA804229 | 13698 | 449 | 3.79064 | 17.0199736 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 309 | 2.689999999999999e-101 | NR | 8WUS_E | 11801 | g12755 | i0 | 99.3 | 9.9554565701559 | 149 | 1 | 99.6 | 0 | 2 | 448 | 124 | 272 | 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] | diamond | 4470 | 309 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;