contig_metadata
11 rows where bioproject = "PRJNA934472" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 911282 | 911282 | PRJNA934472_P_NODE_39741_length_231_cov_3.006329_g39363_i0 | PRJNA934472 | 39741 | 231 | 3.006329 | 6.94461999 | Sopapen virus | 3131614 | Viruses | Viruses | 130 | 9.27e-26 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g39363 | i0 | 94.118 | 2.17748917748918 | 85 | 5 | 37 | 0 | 1 | 85 | 514 | 430 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 503 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 2186522 | 2186522 | PRJNA934472_P_NODE_33842_length_256_cov_1.262295_g33464_i0 | PRJNA934472 | 33842 | 256 | 1.262295 | 3.2314752 | Curvularia homomorpha narnavirus 1 | 3111958 | Viruses | Viruses | 318 | 2.0799999999999998e-82 | NTclustered | gi|2645095085|gb|OQ162166.1| | 3111958 | g33464 | i0 | 89.105 | 1.00390625 | 257 | 26 | 100 | 2 | 1 | 256 | 438 | 693 | Curvularia homomorpha narnavirus 1 strain ChNV1/ZZ13-2, complete genome | blastn | 257 | 318 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Curvularia homomorpha narnavirus 1 | ||
| 16214286 | 16214286 | PRJNA934472_P_NODE_40273_length_217_cov_8.555556_g39895_i0 | PRJNA934472 | 40273 | 217 | 8.555556 | 18.56555652 | Sopapal virus | 3131818 | Viruses | Viruses | 60.2 | 1.15e-4 | NTclustered | gi|2717323464|gb|PP174119.1| | 3131818 | g39895 | i0 | 100 | 0.147465437788018 | 32 | 0 | 15 | 0 | 1 | 32 | 2386 | 2355 | MAG: Sopapal virus isolate SP1C_k141_7609 genomic sequence | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sopapal virus | |||
| 18762796 | 18762796 | PRJNA934472_P_NODE_33135_length_258_cov_2.621622_g32757_i0 | PRJNA934472 | 33135 | 258 | 2.621622 | 6.76378476 | Chronacard virus | 3129783 | Viruses | Viruses | 233 | 7.809999999999999e-57 | NTclustered | gi|2717318323|gb|PP172180.1| | 3129783 | g32757 | i0 | 88.66 | 583.720930232558 | 194 | 18 | 74 | 4 | 1 | 192 | 194 | 3 | MAG: Chronacard virus isolate CN1A_k141_43539 genomic sequence | blastn | 150600 | 233 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronacard virus | |||
| 20037973 | 20037973 | PRJNA934472_P_NODE_6516_length_546_cov_3.627907_g6203_i0 | PRJNA934472 | 6516 | 546 | 3.627907 | 19.80837222 | Moss associated narna-like virus 47 | 3067006 | Viruses | Viruses | 91.6 | 1.14e-13 | NTclustered | gi|2626077323|gb|OQ987542.1| | 3067006 | g6203 | i0 | 91.045 | 0.741758241758242 | 67 | 6 | 12 | 0 | 1 | 67 | 438 | 372 | MAG: Moss associated narna-like virus 47 isolate DICBIL genomic sequence | blastn | 405 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Moss associated narna-like virus 47 | |||
| 27063600 | 27063600 | PRJNA934472_P_NODE_37862_length_243_cov_3.917647_g37484_i0 | PRJNA934472 | 37862 | 243 | 3.917647 | 9.51988221 | Leviviricetes | 2842243 | Viruses | Viruses | 57.4 | 2.48e-7 | NR | UJQ85483.1 | 2027243 | g37484 | i0 | 39.4 | 2.4320987654321 | 71 | 39 | 87.7 | 1 | 213 | 1 | 219 | 285 | UJQ85483.1 MAG: hypothetical protein 1 [Leviviridae sp.] | diamond | 591 | 57.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30246366 | 30246366 | PRJNA934472_P_NODE_16932_length_351_cov_1.107914_g16555_i0 | PRJNA934472 | 16932 | 351 | 1.107914 | 3.88877814 | Leviviridae sp. | 2027243 | Viruses | Viruses | 100 | 6e-22 | NR | URG15607.1 | 2027243 | g16555 | i0 | 44.2 | 4.94871794871795 | 113 | 58 | 93.2 | 2 | 351 | 25 | 275 | 386 | URG15607.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 1737 | 100 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30341473 | 30341473 | PRJNA934472_P_NODE_25872_length_289_cov_3.069444_g25494_i0 | PRJNA934472 | 25872 | 289 | 3.069444 | 8.87069316 | Hangzhou steitz-like virus 7 | 3029018 | Viruses | Viruses | 52 | 3.39e-5 | NR | WEU70967.1 | 3029018 | g25494 | i0 | 35.6 | 1.78546712802768 | 87 | 52 | 90.3 | 3 | 1 | 261 | 275 | 357 | WEU70967.1 MAG: maturation protein [Hangzhou steitz-like virus 7] | diamond | 516 | 52 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hangzhou steitz-like virus 7 | |||
| 31162130 | 31162130 | PRJNA934472_P_NODE_16575_length_354_cov_1.893238_g16198_i0 | PRJNA934472 | 16575 | 354 | 1.893238 | 6.70206252 | ssRNA phage Esthiorhiza.2_3 | 2786047 | Viruses | Viruses | 65.9 | 9.26e-10 | NR | YP_010769523.1 | 2786048 | g16198 | i0 | 32.2 | 1.99152542372881 | 118 | 68 | 99.2 | 2 | 2 | 352 | 199 | 305 | YP_010769523.1 maturation protein [ssRNA phage Esthiorhiza.2_30] | diamond | 705 | 65.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Mihkrovirus | Mihkrovirus pedovicinum | ||
| 31573738 | 31573738 | PRJNA934472_P_NODE_12176_length_408_cov_4.313433_g11799_i0 | PRJNA934472 | 12176 | 408 | 4.313433 | 17.59880664 | Riparelt virus | 3130044 | Viruses | Viruses | 113 | 3.01e-26 | NR | WZH59164.1 | 3130044 | g11799 | i0 | 42.9 | 0.977941176470588 | 133 | 71 | 95.6 | 3 | 392 | 3 | 358 | 488 | WZH59164.1 MAG: maturation protein, partial [Riparelt virus] | diamond | 399 | 113 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Riparelt virus | |||||
| 32774680 | 32774680 | PRJNA934472_P_NODE_22540_length_308_cov_2.404255_g22162_i0 | PRJNA934472 | 22540 | 308 | 2.404255 | 7.4051054 | Leviviridae sp. | 2027243 | Viruses | Viruses | 122 | 7.999999999999998e-30 | NR | UJQ85814.1 | 2027243 | g22162 | i0 | 60.8 | 1.97727272727273 | 102 | 40 | 99.4 | 0 | 1 | 306 | 242 | 343 | UJQ85814.1 MAG: hypothetical protein 2 [Leviviridae sp.] | diamond | 609 | 122 | 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);;