contig_metadata
18 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3014749 | 3014749 | PRJNA493632_P_NODE_440003_length_264_cov_1.277487_g436564_i0 | PRJNA493632 | 440003 | 264 | 1.277487 | 3.37256568 | Andihavirus borborohabitans | 2843692 | Viruses | Viruses | 281 | 2.83e-71 | NTclustered | gi|2497515024|ref|NC_074146.1| | 2786658 | g436564 | i0 | 94.054 | 1.37878787878788 | 185 | 11 | 70 | 0 | 59 | 243 | 2 | 186 | SsRNA phage SRR7976300_9 genomic sequence | blastn | 364 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Andihavirus | Andihavirus borborohabitans | ||
| 11947410 | 11947410 | PRJNA493632_P_NODE_718810_length_211_cov_8.036232_g715368_i0 | PRJNA493632 | 718810 | 211 | 8.036232 | 16.95644952 | Chrocagost virus | 3129398 | Viruses | Viruses | 289 | 1.2999999999999999e-73 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g715368 | i0 | 91.469 | 856.161137440758 | 211 | 17 | 99 | 1 | 1 | 210 | 5828 | 5618 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 180650 | 289 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 17036593 | 17036593 | PRJNA493632_P_NODE_188114_length_353_cov_2.935714_g184683_i0 | PRJNA493632 | 188114 | 353 | 2.935714 | 10.36307042 | Sonamyl virus | 3131590 | Viruses | Viruses | 91.6 | 7.07e-14 | NTclustered | gi|2717322886|gb|PP173891.1| | 3131590 | g184683 | i0 | 91.176 | 0.192634560906516 | 68 | 4 | 19 | 2 | 40 | 106 | 2688 | 2622 | MAG: Sonamyl virus isolate SN2B_k141_68293 genomic sequence | blastn | 68 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sonamyl virus | |||||
| 22143032 | 22143032 | PRJNA493632_P_NODE_588598_length_245_cov_7.854651_g585157_i0 | PRJNA493632 | 588598 | 245 | 7.854651 | 19.24389495 | Chrocagosk virus | 3129397 | Viruses | Viruses | 191 | 4.49e-44 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g585157 | i0 | 87.879 | 0.673469387755102 | 165 | 16 | 67 | 4 | 1 | 164 | 518 | 679 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 165 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 27297805 | 27297805 | PRJNA493632_P_NODE_307223_length_293_cov_1.336364_g303785_i0 | PRJNA493632 | 307223 | 293 | 1.336364 | 3.91554652 | Chrocafynt virus | 3129393 | Viruses | Viruses | 79 | 1.29e-14 | NR | WZH58264.1 | 3129393 | g303785 | i0 | 40.3 | 0.78839590443686 | 77 | 46 | 78.8 | 0 | 38 | 268 | 34 | 110 | WZH58264.1 MAG: RNA-dependent RNA polymerase [Chrocafynt virus] | diamond | 231 | 79 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocafynt virus | |||||
| 27582050 | 27582050 | PRJNA493632_P_NODE_445064_length_263_cov_1.215789_g441625_i0 | PRJNA493632 | 445064 | 263 | 1.215789 | 3.19752507 | brine shrimp narna-like virus 1 | 2900385 | Viruses | Viruses | 57.8 | 2.44e-7 | NR | UNI73858.1 | 2900385 | g441625 | i0 | 45 | 0.684410646387833 | 60 | 33 | 68.4 | 0 | 83 | 262 | 148 | 207 | UNI73858.1 MAG: RNA-dependent RNA polymerase [brine shrimp narna-like virus 1] | diamond | 180 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | brine shrimp narna-like virus 1 | |||
| 27834509 | 27834509 | PRJNA493632_P_NODE_174824_length_364_cov_1.058419_g171396_i0 | PRJNA493632 | 174824 | 364 | 1.058419 | 3.85264516 | Sanya fiers-like virus 41 | 2970049 | Viruses | Viruses | 71.2 | 1.38e-11 | NR | UUW21380.1 | 2970049 | g171396 | i0 | 41.9 | 0.708791208791209 | 86 | 50 | 70.9 | 0 | 1 | 258 | 176 | 261 | UUW21380.1 MAG: maturation protein [Sanya fiers-like virus 41] | diamond | 258 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Longmavirus | Longmavirus dinebrenecus | ||
| 27961039 | 27961039 | PRJNA493632_P_NODE_524785_length_250_cov_0.870056_g521346_i0 | PRJNA493632 | 524785 | 250 | 0.870056 | 2.17514 | Leviviridae sp. | 2027243 | Viruses | Viruses | 111 | 4.2900000000000005e-27 | NR | URG16006.1 | 2027243 | g521346 | i0 | 70.4 | 0.972 | 81 | 22 | 97.2 | 1 | 243 | 1 | 146 | 224 | URG16006.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 243 | 111 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28529601 | 28529601 | PRJNA493632_P_NODE_658407_length_241_cov_0.916667_g654966_i0 | PRJNA493632 | 658407 | 241 | 0.916667 | 2.20916747 | Ripastol virus | 3131339 | Viruses | Viruses | 43.5 | 0.0196 | NR | WZH61253.1 | 3131339 | g654966 | i0 | 38.3 | 1.00829875518672 | 81 | 43 | 93.4 | 2 | 240 | 16 | 492 | 571 | WZH61253.1 MAG: RNA-dependent RNA polymerase, partial [Ripastol virus] | diamond | 243 | 43.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripastol virus | |||||
| 28624372 | 28624372 | PRJNA493632_P_NODE_660707_length_241_cov_0.916667_g657266_i0 | PRJNA493632 | 660707 | 241 | 0.916667 | 2.20916747 | Leviviridae sp. | 2027243 | Viruses | Viruses | 164 | 1.28e-45 | NR | DAE35055.1 | 2027243 | g657266 | i0 | 98.8 | 0.995850622406639 | 80 | 1 | 99.6 | 0 | 240 | 1 | 344 | 423 | DAE35055.1 MAG TPA: RDRP protein, partial [Leviviridae sp.] | diamond | 240 | 164 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28908002 | 28908002 | PRJNA493632_P_NODE_542588_length_249_cov_0.875000_g539149_i0 | PRJNA493632 | 542588 | 249 | 0.875 | 2.17875 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 85.5 | 3.54e-17 | NR | UOL49050.1 | 2809572 | g539149 | i0 | 67.8 | 0.710843373493976 | 59 | 19 | 71.1 | 0 | 179 | 3 | 1 | 59 | UOL49050.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 177 | 85.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29823630 | 29823630 | PRJNA493632_P_NODE_369071_length_279_cov_1.048544_g365632_i0 | PRJNA493632 | 369071 | 279 | 1.048544 | 2.92543776 | Sanya fiers-like virus 56 | 2970065 | Viruses | Viruses | 98.2 | 6.819999999999999e-24 | NR | UUW21431.1 | 2970065 | g365632 | i0 | 50 | 0.946236559139785 | 88 | 44 | 94.6 | 0 | 2 | 265 | 2 | 89 | UUW21431.1 MAG: hypothetical protein [Sanya fiers-like virus 56] | diamond | 264 | 98.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Longmavirus | Longmavirus cypericola | ||
| 29918850 | 29918850 | PRJNA493632_P_NODE_584851_length_246_cov_0.890173_g581410_i0 | PRJNA493632 | 584851 | 246 | 0.890173 | 2.18982558 | Leviviridae sp. | 2027243 | Viruses | Viruses | 71.2 | 2.87e-12 | NR | URG16293.1 | 2027243 | g581410 | i0 | 47 | 0.804878048780488 | 66 | 34 | 80.5 | 1 | 1 | 198 | 294 | 358 | URG16293.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 198 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31340616 | 31340616 | PRJNA493632_P_NODE_602336_length_245_cov_0.895349_g598895_i0 | PRJNA493632 | 602336 | 245 | 0.895349 | 2.19360505 | Ripameb virus | 3130844 | Viruses | Viruses | 81.6 | 7.45e-16 | NR | WZH60424.1 | 3130844 | g598895 | i0 | 53.4 | 0.893877551020408 | 73 | 34 | 89.4 | 0 | 236 | 18 | 35 | 107 | WZH60424.1 MAG: RNA-dependent RNA polymerase, partial [Ripameb virus] | diamond | 219 | 81.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripameb virus | |||
| 31593726 | 31593726 | PRJNA493632_P_NODE_245416_length_317_cov_1.258197_g241980_i0 | PRJNA493632 | 245416 | 317 | 1.258197 | 3.98848449 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 48.9 | 6.07e-4 | NR | UOL49050.1 | 2809572 | g241980 | i0 | 38.2 | 1.66561514195584 | 89 | 44 | 77.6 | 3 | 18 | 263 | 649 | 733 | UOL49050.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 528 | 48.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32226477 | 32226477 | PRJNA493632_P_NODE_433758_length_265_cov_1.604167_g430319_i0 | PRJNA493632 | 433758 | 265 | 1.604167 | 4.25104255 | Erysiphe necator associated ourmia-like virus 89 | 2741869 | Viruses | Viruses | 132 | 4.369999999999999e-34 | NR | QKI79919.1 | 2741869 | g430319 | i0 | 74.1 | 0.962264150943396 | 85 | 22 | 96.2 | 0 | 2 | 256 | 148 | 232 | QKI79919.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 89] | diamond | 255 | 132 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 89 | ||
| 32384572 | 32384572 | PRJNA493632_P_NODE_598459_length_245_cov_0.895349_g595018_i0 | PRJNA493632 | 598459 | 245 | 0.895349 | 2.19360505 | Sanya fiers-like virus 43 | 2970051 | Viruses | Viruses | 75.9 | 2.09e-15 | NR | UUW21387.1 | 2970051 | g595018 | i0 | 75 | 0.538775510204082 | 44 | 11 | 53.9 | 0 | 244 | 113 | 87 | 130 | UUW21387.1 MAG: hypothetical protein [Sanya fiers-like virus 43] | diamond | 132 | 75.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Sanya fiers-like virus 43 | |||
| 32652763 | 32652763 | PRJNA493632_P_NODE_360_length_3893_cov_7.297644_g158_i0 | PRJNA493632 | 360 | 3893 | 7.297644 | 284.09728092 | Viruses | 10239 | Viruses | Viruses | 409 | 1.8099999999999999e-124 | NR | URG15081.1 | 2027243 | g158 | i0 | 40.8 | 0.920883637297714 | 601 | 327 | 45.5 | 8 | 1789 | 20 | 32 | 614 | URG15081.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 3585 | 409 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;