contig_metadata
14 rows where bioproject = "PRJNA493244", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1730578 | 1730578 | PRJNA493244_P_NODE_1501282_length_242_cov_5.000000_g1478157_i0 | PRJNA493244 | 1501282 | 242 | 5 | 12.1 | Erysiphe necator associated ourmia-like virus 87 | 2741867 | Viruses | Viruses | 394 | 3.14e-105 | NTclustered | gi|2798495165|gb|PP945076.1| | 2741867 | g1478157 | i0 | 98.649 | 0.91735537190082606 | 222 | 3 | 92 | 0 | 21 | 242 | 1954 | 2175 | Erysiphe necator associated ourmia-like virus 87 strain China-NX113 RNA-dependent RNA polymerase gene, complete cds | blastn | 222 | 394 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 87 | ||
| 3006906 | 3006906 | PRJNA493244_P_NODE_16083_length_2467_cov_7.995844_g14384_i0 | PRJNA493244 | 16083 | 2467 | 7.995844 | 197.25747148 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 2586 | 0 | NTclustered | gi|2245490375|gb|ON164215.1| | 2583949 | g14384 | i0 | 97.674 | 0.623023915687069 | 1505 | 35 | 61 | 0 | 1 | 1505 | 89 | 1593 | MAG: Narnaviridae sp. isolate 176-k141_8579 RNA dependent RNA polymerase gene, partial cds | blastn | 1537 | 2586 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 5561484 | 5561484 | PRJNA493244_P_NODE_993845_length_409_cov_19.195402_g970765_i0 | PRJNA493244 | 993845 | 409 | 19.195402 | 78.50919418 | Aspergillus flavus magoulivirus 1 | 2871716 | Viruses | Viruses | 226 | 2.19e-54 | NTclustered | gi|2095891259|gb|MZ600058.1| | 2871716 | g970765 | i0 | 79.883 | 0.838630806845966 | 343 | 41 | 80 | 20 | 12 | 337 | 381 | 50 | MAG: Aspergillus flavus magoulivirus 1 isolate UniPR4 genomic sequence, sequence | blastn | 343 | 226 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Aspergillus flavus magoulivirus 1 | ||
| 8109025 | 8109025 | PRJNA493244_P_NODE_1536527_length_234_cov_3.150289_g1513402_i0 | PRJNA493244 | 1536527 | 234 | 3.150289 | 7.37167626 | Chrocagost virus | 3129398 | Viruses | Viruses | 281 | 2.46e-71 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g1513402 | i0 | 92.424 | 312.551282051282 | 198 | 14 | 84 | 1 | 5 | 201 | 5664 | 5861 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 73137 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 9383175 | 9383175 | PRJNA493244_P_NODE_1276128_length_304_cov_1.983539_g1253004_i0 | PRJNA493244 | 1276128 | 304 | 1.983539 | 6.02995856 | Hebei scleroulivirus | 3371279 | Viruses | Viruses | 372 | 1.91e-98 | NTclustered | gi|2819062619|gb|PQ150490.1| | 3371279 | g1253004 | i0 | 93.6 | 1.00657894736842 | 250 | 15 | 82 | 1 | 24 | 272 | 2113 | 2362 | MAG: Hebei scleroulivirus isolate Beijing_119 genomic sequence | blastn | 306 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Hebei scleroulivirus | ||
| 19581309 | 19581309 | PRJNA493244_P_NODE_134116_length_1383_cov_27.645234_g125387_i0 | PRJNA493244 | 134116 | 1383 | 27.645234 | 382.33358622 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 432 | 4.31e-143 | NR | UJQ91996.1 | 2808997 | g125387 | i0 | 54 | 0.991323210412148 | 457 | 154 | 88.3 | 10 | 1221 | 1 | 2 | 452 | UJQ91996.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] | diamond | 1371 | 432 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 27377210 | 27377210 | PRJNA493244_P_NODE_345543_length_910_cov_1.992933_g328708_i0 | PRJNA493244 | 345543 | 910 | 1.992933 | 18.1356903 | Viruses | 10239 | Viruses | Viruses | 108 | 4.4e-22 | NR | WAK73589.1 | 2976296 | g328708 | i0 | 32.6 | 1.11098901098901 | 218 | 132 | 70.5 | 6 | 822 | 181 | 559 | 765 | WAK73589.1 RNA-dependent RNA polymerase [Phytophthora palustris narna-like virus 4] | diamond | 1011 | 109 | 0.990825688073395 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Phytophthora palustris narna-like virus 4 | |||
| 28087074 | 28087074 | PRJNA493244_P_NODE_855365_length_476_cov_7.419277_g832510_i0 | PRJNA493244 | 855365 | 476 | 7.419277 | 35.31575852 | Sanya botourmia-like virus 15 | 2970187 | Viruses | Viruses | 151 | 2.3099999999999998e-39 | NR | UUW21046.1 | 2970187 | g832510 | i0 | 53.3 | 0.863445378151261 | 137 | 63 | 85.7 | 1 | 442 | 35 | 423 | 559 | UUW21046.1 MAG: putative RNA-dependent RNA polymerase [Sanya botourmia-like virus 15] | diamond | 411 | 151 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sanya botourmia-like virus 15 | |||
| 28466208 | 28466208 | PRJNA493244_P_NODE_1474166_length_249_cov_1.585106_g1451041_i0 | PRJNA493244 | 1474166 | 249 | 1.585106 | 3.94691394 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 127 | 3.869999999999999e-32 | NR | UJQ91947.1 | 2808997 | g1451041 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 2 | 247 | 160 | 241 | UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 246 | 127 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 28971293 | 28971293 | PRJNA493244_P_NODE_894088_length_456_cov_17.840506_g871136_i0 | PRJNA493244 | 894088 | 456 | 17.840506 | 81.35270736 | ssRNA phage SRR696 | 2845865 | Viruses | Viruses | 162 | 5.1499999999999993e-48 | NR | YP_010769763.1 | 2786514 | g871136 | i0 | 57.8 | 2.48026315789474 | 128 | 54 | 84.2 | 0 | 64 | 447 | 1 | 128 | YP_010769763.1 coat protein [ssRNA phage SRR6960507_4] | diamond | 1131 | 162 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Pohlevirus | Pohlevirus caenicola | ||
| 30076332 | 30076332 | PRJNA493244_P_NODE_1368052_length_277_cov_1.893519_g1344927_i0 | PRJNA493244 | 1368052 | 277 | 1.893519 | 5.24504763 | Leviviridae sp. | 2027243 | Viruses | Viruses | 53.5 | 8.42e-6 | NR | DAH09204.1 | 2027243 | g1344927 | i0 | 50 | 0.51985559566787 | 48 | 24 | 52 | 0 | 253 | 110 | 239 | 286 | DAH09204.1 MAG TPA: capsid protein [Leviviridae sp.] | diamond | 144 | 53.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31340413 | 31340413 | PRJNA493244_P_NODE_1579216_length_225_cov_1.493902_g1556091_i0 | PRJNA493244 | 1579216 | 225 | 1.493902 | 3.3612795 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 99.8 | 2.6e-22 | NR | UJQ91947.1 | 2808997 | g1556091 | i0 | 69.7 | 0.88 | 66 | 19 | 88 | 1 | 25 | 222 | 65 | 129 | UJQ91947.1 MAG: putative RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 198 | 99.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 31530372 | 31530372 | PRJNA493244_P_NODE_1089116_length_369_cov_10.240260_g1065995_i0 | PRJNA493244 | 1089116 | 369 | 10.24026 | 37.7865594 | Magnaporthe oryzae botourmiavirus 7 | 2755484 | Viruses | Viruses | 84 | 5.58e-16 | NR | QVU39995.1 | 2755484 | g1065995 | i0 | 51 | 1.5609756097561 | 96 | 45 | 76.4 | 1 | 35 | 316 | 380 | 475 | QVU39995.1 RNA-dependent RNA polymerase [Magnaporthe oryzae botourmiavirus 7] | diamond | 576 | 84 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Epsilonscleroulivirus | Epsilonscleroulivirus alphaoryzae | ||
| 31751480 | 31751480 | PRJNA493244_P_NODE_1523637_length_237_cov_2.903409_g1500512_i0 | PRJNA493244 | 1523637 | 237 | 2.903409 | 6.88107933 | Diplodia seriata botourmiavirus 1 | 2932871 | Viruses | Viruses | 43.9 | 0.0133 | NR | UOK20173.1 | 2932871 | g1500512 | i0 | 41.5 | 0.670886075949367 | 53 | 31 | 67.1 | 0 | 208 | 50 | 503 | 555 | UOK20173.1 RNA dependent RNA polymerase [Diplodia seriata botourmiavirus 1] | diamond | 159 | 43.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Diplodia seriata botourmiavirus 1 |
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);;