contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA773778" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24158903 | 24158903 | PRJNA773778_S_NODE_25419_length_301_cov_2.092105_g25269_i0 | PRJNA773778 | 25419 | 301 | 2.092105 | 6.29723605 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 156 | 5.12e-44 | NR | URG16991.1 | 2583949 | g25269 | i0 | 68 | 0.996677740863787 | 100 | 32 | 99.7 | 0 | 2 | 301 | 253 | 352 | URG16991.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 300 | 156 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 27179588 | 27179588 | PRJNA773778_S_NODE_35982_length_263_cov_1.336842_g35832_i0 | PRJNA773778 | 35982 | 263 | 1.336842 | 3.51589446 | Ripatrop virus | 3131332 | Viruses | Viruses | 77 | 3.88e-14 | NR | WZH61242.1 | 3131332 | g35832 | i0 | 46.8 | 1.74524714828897 | 77 | 41 | 87.8 | 0 | 29 | 259 | 42 | 118 | WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus] | diamond | 459 | 77 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripatrop virus | |||
| 27653796 | 27653796 | PRJNA773778_S_NODE_38084_length_257_cov_1.179348_g37934_i0 | PRJNA773778 | 38084 | 257 | 1.179348 | 3.03092436 | Ripaprib virus | 3131006 | Viruses | Viruses | 50.8 | 5.26e-5 | NR | WZH60699.1 | 3131006 | g37934 | i0 | 42.4 | 0.688715953307393 | 59 | 34 | 68.9 | 0 | 9 | 185 | 199 | 257 | WZH60699.1 MAG: RNA-dependent RNA polymerase [Ripaprib virus] | diamond | 177 | 50.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripaprib virus | |||
| 27842882 | 27842882 | PRJNA773778_S_NODE_36504_length_261_cov_3.494681_g36354_i0 | PRJNA773778 | 36504 | 261 | 3.494681 | 9.12111741 | Ripaprib virus | 3131006 | Viruses | Viruses | 84.7 | 1.58e-17 | NR | WZH60699.1 | 3131006 | g36354 | i0 | 61.9 | 0.724137931034483 | 63 | 24 | 72.4 | 0 | 57 | 245 | 2 | 64 | WZH60699.1 MAG: RNA-dependent RNA polymerase [Ripaprib virus] | diamond | 189 | 84.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripaprib virus | |||
| 28253448 | 28253448 | PRJNA773778_S_NODE_2126_length_730_cov_1.357686_g1993_i0 | PRJNA773778 | 2126 | 730 | 1.357686 | 9.9111078 | Macrobrachium rosenbergii narna-like virus 1 | 3132536 | Viruses | Viruses | 87.8 | 9.94e-16 | NR | WWZ85587.1 | 3132536 | g1993 | i0 | 28.5 | 1.03972602739726 | 253 | 160 | 99 | 8 | 3 | 725 | 251 | 494 | WWZ85587.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii narna-like virus 1] | diamond | 759 | 87.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Macrobrachium rosenbergii narna-like virus 1 | |||
| 28695742 | 28695742 | PRJNA773778_S_NODE_807_length_1039_cov_8.303313_g71_i1 | PRJNA773778 | 807 | 1039 | 8.303313 | 86.27142207 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 155 | 2.05e-38 | NR | URG16550.1 | 2809572 | g71 | i1 | 35.3 | 0.866217516843118 | 300 | 175 | 83.7 | 8 | 169 | 1038 | 2 | 292 | URG16550.1 MAG: RNA dependent RNA polymerase [Mitoviridae sp.] | diamond | 900 | 155 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28853225 | 28853225 | PRJNA773778_S_NODE_5888_length_523_cov_1.602222_g5739_i0 | PRJNA773778 | 5888 | 523 | 1.602222 | 8.37962106 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 137 | 4.9000000000000005e-34 | NR | URG16795.1 | 2809572 | g5739 | i0 | 49 | 0.84321223709369 | 147 | 72 | 82.6 | 1 | 92 | 523 | 6 | 152 | URG16795.1 MAG: RNA dependent RNA polymerase [Mitoviridae sp.] | diamond | 441 | 137 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29547852 | 29547852 | PRJNA773778_S_NODE_32970_length_273_cov_0.965000_g32820_i0 | PRJNA773778 | 32970 | 273 | 0.965 | 2.63445 | Chronaverd virus | 3129954 | Viruses | Viruses | 90.5 | 8.5e-19 | NR | WZH59013.1 | 3129954 | g32820 | i0 | 51.9 | 5.27472527472527 | 81 | 39 | 89 | 0 | 28 | 270 | 466 | 546 | WZH59013.1 MAG: RNA-dependent RNA polymerase, partial [Chronaverd virus] | diamond | 1440 | 90.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaverd virus | |||
| 29737245 | 29737245 | PRJNA773778_S_NODE_16970_length_350_cov_1.148014_g16820_i0 | PRJNA773778 | 16970 | 350 | 1.148014 | 4.018049 | Aspergillus lentulus narnavirus 1 | 2747489 | Viruses | Viruses | 90.9 | 1.73e-18 | NR | BCH36643.1 | 2747489 | g16820 | i0 | 43.9 | 1.84285714285714 | 107 | 58 | 90 | 1 | 5 | 319 | 158 | 264 | BCH36643.1 RNA-dependent RNA polymerase [Aspergillus lentulus narnavirus 1] | diamond | 645 | 90.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Aspergillus lentulus narnavirus 1 | |||
| 29927156 | 29927156 | PRJNA773778_S_NODE_38131_length_257_cov_0.940217_g37981_i0 | PRJNA773778 | 38131 | 257 | 0.940217 | 2.41635769 | Mbeech associated narna-like virus 23 | 3066948 | Viruses | Viruses | 86.7 | 1.57e-17 | NR | WPR17341.1 | 3066948 | g37981 | i0 | 50.6 | 0.968871595330739 | 83 | 39 | 94.6 | 1 | 11 | 253 | 184 | 266 | WPR17341.1 MAG: RNA-dependent RNA polymerase, partial [Mbeech associated narna-like virus 23] | diamond | 249 | 86.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mbeech associated narna-like virus 23 | |||
| 29936580 | 29936580 | PRJNA773778_S_NODE_23751_length_309_cov_1.088983_g23601_i0 | PRJNA773778 | 23751 | 309 | 1.088983 | 3.36495747 | Viruses | 10239 | Viruses | Viruses | 87.8 | 1.22e-17 | NR | QQD86177.1 | 2785367 | g23601 | i0 | 45.6 | 3 | 103 | 55 | 99 | 1 | 2 | 307 | 698 | 800 | QQD86177.1 RNA-dependent RNA polymerase [Botryosphaeria dothidea narnavirus 3] | diamond | 927 | 87.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Botryosphaeria dothidea narnavirus 3 | |||
| 30243042 | 30243042 | PRJNA773778_S_NODE_8712_length_454_cov_1.881890_g8562_i0 | PRJNA773778 | 8712 | 454 | 1.88189 | 8.5437806 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 149 | 7.66e-39 | NR | URG16795.1 | 2809572 | g8562 | i0 | 52.3 | 0.997797356828194 | 151 | 70 | 99.1 | 2 | 4 | 453 | 147 | 296 | URG16795.1 MAG: RNA dependent RNA polymerase [Mitoviridae sp.] | diamond | 453 | 149 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 30401381 | 30401381 | PRJNA773778_S_NODE_41433_length_250_cov_0.870056_g41283_i0 | PRJNA773778 | 41433 | 250 | 0.870056 | 2.17514 | Poseidon narna-like virus | 2912712 | Viruses | Viruses | 105 | 7.030000000000001e-26 | NR | DAZ87244.1 | 2912712 | g41283 | i0 | 61.4 | 0.996 | 83 | 31 | 99.6 | 1 | 1 | 249 | 151 | 232 | DAZ87244.1 TPA_asm: RNA-dependent polymerase, partial [Poseidon narna-like virus] | diamond | 249 | 105 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Poseidon narna-like virus | |||
| 30495823 | 30495823 | PRJNA773778_S_NODE_6593_length_502_cov_1.249417_g6443_i0 | PRJNA773778 | 6593 | 502 | 1.249417 | 6.27207334 | Ripatrop virus | 3131332 | Viruses | Viruses | 100 | 2.08e-21 | NR | WZH61242.1 | 3131332 | g6443 | i0 | 33.5 | 1.06972111553785 | 179 | 96 | 98.6 | 6 | 7 | 501 | 261 | 430 | WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus] | diamond | 537 | 100 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripatrop virus | |||
| 30716756 | 30716756 | PRJNA773778_S_NODE_9514_length_439_cov_1.450820_g9364_i0 | PRJNA773778 | 9514 | 439 | 1.45082 | 6.3690998 | Macrobrachium rosenbergii narna-like virus 1 | 3132536 | Viruses | Viruses | 89 | 2.38e-17 | NR | WWZ85587.1 | 3132536 | g9364 | i0 | 37.1 | 0.902050113895216 | 132 | 82 | 90.2 | 1 | 405 | 10 | 122 | 252 | WWZ85587.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii narna-like virus 1] | diamond | 396 | 89 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Macrobrachium rosenbergii narna-like virus 1 | |||
| 30969798 | 30969798 | PRJNA773778_S_NODE_32094_length_276_cov_0.931034_g31944_i0 | PRJNA773778 | 32094 | 276 | 0.931034 | 2.56965384 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 136 | 2.52e-36 | NR | URG16991.1 | 2583949 | g31944 | i0 | 71.4 | 0.989130434782609 | 91 | 25 | 98.9 | 1 | 275 | 3 | 131 | 220 | URG16991.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 273 | 136 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 31633505 | 31633505 | PRJNA773778_S_NODE_5996_length_519_cov_3.334081_g5846_i0 | PRJNA773778 | 5996 | 519 | 3.334081 | 17.30388039 | Athena mito-like virus | 2912695 | Viruses | Viruses | 175 | 2.33e-49 | NR | DAZ87261.1 | 2912695 | g5846 | i0 | 52.1 | 0.976878612716763 | 169 | 80 | 97.7 | 1 | 3 | 509 | 135 | 302 | DAZ87261.1 TPA_asm: RNA-dependent polymerase, partial [Athena mito-like virus] | diamond | 507 | 175 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Athena mito-like virus | |||
| 31886568 | 31886568 | PRJNA773778_S_NODE_6557_length_503_cov_1.383721_g6407_i0 | PRJNA773778 | 6557 | 503 | 1.383721 | 6.96011663 | Halia narna-like virus | 2912703 | Viruses | Viruses | 151 | 6.24e-39 | NR | DAZ87253.1 | 2912703 | g6407 | i0 | 49.7 | 0.996023856858847 | 167 | 81 | 97.8 | 1 | 495 | 4 | 206 | 372 | DAZ87253.1 TPA_asm: RNA-dependent polymerase [Halia narna-like virus] | diamond | 501 | 151 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Halia narna-like virus | |||
| 31896101 | 31896101 | PRJNA773778_S_NODE_42837_length_248_cov_0.880000_g42687_i0 | PRJNA773778 | 42837 | 248 | 0.88 | 2.1824 | Viruses | 10239 | Viruses | Viruses | 88.2 | 3.97e-18 | NR | DAZ87243.1 | 2912713 | g42687 | i0 | 62.2 | 1.79032258064516 | 74 | 28 | 89.5 | 0 | 20 | 241 | 227 | 300 | DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus] | diamond | 444 | 88.6 | 0.99548532731377 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Proteus mito-like virus | |||
| 31918299 | 31918299 | PRJNA773778_S_NODE_21217_length_322_cov_1.265060_g21067_i0 | PRJNA773778 | 21217 | 322 | 1.26506 | 4.0734932 | Plasmopara viticola lesion associated narnavirus 9 | 2719534 | Viruses | Viruses | 83.6 | 4.52e-16 | NR | QIR30288.1 | 2719534 | g21067 | i0 | 44.9 | 0.996894409937888 | 107 | 46 | 99.7 | 2 | 321 | 1 | 281 | 374 | QIR30288.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated narnavirus 9] | diamond | 321 | 83.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Plasmopara viticola lesion associated narnavirus 9 | ||
| 32139845 | 32139845 | PRJNA773778_S_NODE_30478_length_281_cov_1.480769_g30328_i0 | PRJNA773778 | 30478 | 281 | 1.480769 | 4.16096089 | Proteus mito-like virus | 2912713 | Viruses | Viruses | 96.7 | 6.53e-21 | NR | DAZ87243.1 | 2912713 | g30328 | i0 | 50.6 | 0.950177935943061 | 89 | 44 | 95 | 0 | 272 | 6 | 380 | 468 | DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus] | diamond | 267 | 96.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Proteus mito-like virus | |||
| 32551385 | 32551385 | PRJNA773778_S_NODE_79_length_2230_cov_8.865090_g71_i0 | PRJNA773778 | 79 | 2230 | 8.86509 | 197.691507 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 276 | 6.6e-79 | NR | URG16550.1 | 2809572 | g71 | i0 | 31.9 | 0.902690582959641 | 671 | 419 | 88 | 17 | 2062 | 101 | 2 | 651 | URG16550.1 MAG: RNA dependent RNA polymerase [Mitoviridae sp.] | diamond | 2013 | 276 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32834476 | 32834476 | PRJNA773778_S_NODE_3440_length_622_cov_0.958106_g3295_i0 | PRJNA773778 | 3440 | 622 | 0.958106 | 5.95941932 | Halia narna-like virus | 2912703 | Viruses | Viruses | 100 | 1.12e-20 | NR | DAZ87253.1 | 2912703 | g3295 | i0 | 39.9 | 0.665594855305466 | 138 | 77 | 64.1 | 3 | 619 | 221 | 596 | 732 | DAZ87253.1 TPA_asm: RNA-dependent polymerase [Halia narna-like virus] | diamond | 414 | 100 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Halia narna-like virus |
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);;