contig_metadata
11 rows where bioproject = "PRJNA855894" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9770025 | 9770025 | PRJNA855894_P_NODE_19688_length_339_cov_0.928571_g19566_i0 | PRJNA855894 | 19688 | 339 | 0.928571 | 3.14785569 | Moss associated narna-like virus 24 | 3066983 | Viruses | Viruses | 320 | 7.95e-83 | NTclustered | gi|2626077281|gb|OQ987521.1| | 3066983 | g19566 | i0 | 84.226 | 9.71681415929203 | 336 | 46 | 99 | 7 | 4 | 337 | 729 | 1059 | MAG: Moss associated narna-like virus 24 isolate DICBIL genomic sequence | blastn | 3294 | 320 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Moss associated narna-like virus 24 | |||
| 9770433 | 9770433 | PRJNA855894_P_NODE_48_length_3227_cov_7.572606_g46_i0 | PRJNA855894 | 48 | 3227 | 7.572606 | 244.36799562 | RD114 retrovirus | 11834 | Viruses | Viruses | 5938 | 0 | NTclustered | gi|306482054|dbj|AB559882.1| | 11834 | g46 | i0 | 99.876 | 47.4285714285714 | 3227 | 4 | 100 | 0 | 1 | 3227 | 8197 | 4971 | RD114 retrovirus proviral DNA, complete genome, strain: CRT1 | blastn | 153052 | 5938 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | RD114 retrovirus | ||
| 12321328 | 12321328 | PRJNA855894_P_NODE_25350_length_286_cov_0.981221_g25228_i0 | PRJNA855894 | 25350 | 286 | 0.981221 | 2.80629206 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 490 | 4.729999999999998e-134 | NTclustered | gi|939193298|gb|KR185347.1| | 12178 | g25228 | i0 | 97.552 | 29.8076923076923 | 286 | 7 | 100 | 0 | 1 | 286 | 3168 | 2883 | Cymbidium mosaic virus isolate China, complete genome | blastn | 8525 | 490 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 13595983 | 13595983 | PRJNA855894_P_NODE_29331_length_252_cov_1.290503_g29209_i0 | PRJNA855894 | 29331 | 252 | 1.290503 | 3.25206756 | Siphoviridae sp. ctGO42 | 2827566 | Viruses | Viruses | 344 | 3.37e-90 | NTclustered | gi|2051147051|tpg|BK015857.1| | 2827566 | g29209 | i0 | 91.27 | 26.7619047619048 | 252 | 22 | 100 | 0 | 1 | 252 | 31168 | 31419 | MAG TPA_asm: Siphoviridae sp. ctGO42, partial genome | blastn | 6744 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctGO42 | |||||
| 16144609 | 16144609 | PRJNA855894_P_NODE_13_length_4640_cov_6.881979_g12_i0 | PRJNA855894 | 13 | 4640 | 6.881979 | 319.3238256 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 8237 | 0 | NTclustered | gi|2232046865|gb|MW316659.1| | 12178 | g12 | i0 | 98.707 | 32.9838362068966 | 4641 | 59 | 100 | 1 | 1 | 4640 | 9 | 4649 | Cymbidium mosaic virus isolate Cy1, complete genome | blastn | 153045 | 8237 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 16145239 | 16145239 | PRJNA855894_P_NODE_933_length_1555_cov_15.647420_g893_i0 | PRJNA855894 | 933 | 1555 | 15.64742 | 243.317381 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 2772 | 0 | NTclustered | gi|2700566920|gb|PP481412.1| | 12178 | g893 | i0 | 98.842 | 59.9183279742765 | 1555 | 18 | 100 | 0 | 1 | 1555 | 4852 | 6406 | Cymbidium mosaic virus isolate IFA191, complete genome | blastn | 93173 | 2772 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 19968390 | 19968390 | PRJNA855894_P_NODE_13456_length_423_cov_1.980000_g13334_i0 | PRJNA855894 | 13456 | 423 | 1.98 | 8.3754 | Erysiphe necator associated narnavirus 3 | 2695336 | Viruses | Viruses | 186 | 8.42e-53 | NR | QJT93762.1 | 2736387 | g13334 | i0 | 66.7 | 1 | 141 | 46 | 99.3 | 1 | 421 | 2 | 340 | 480 | QJT93762.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 30] | diamond | 423 | 186 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 30 | ||
| 21244033 | 21244033 | PRJNA855894_P_NODE_18317_length_354_cov_1.370107_g18195_i0 | PRJNA855894 | 18317 | 354 | 1.370107 | 4.85017878 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 621 | 2.04e-173 | NTclustered | gi|2520252297|gb|OQ993367.1| | 12178 | g18195 | i0 | 98.305 | 37.9774011299435 | 354 | 6 | 100 | 0 | 1 | 354 | 3695 | 3342 | Cymbidium mosaic virus isolate DSMZ PV-1073, complete genome | blastn | 13444 | 621 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 27592333 | 27592333 | PRJNA855894_P_NODE_30364_length_250_cov_0.870056_g30242_i0 | PRJNA855894 | 30364 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 2.59e-32 | NR | XOR08241.1 | 2832643 | g30242 | i0 | 69.5 | 0.984 | 82 | 25 | 98.4 | 0 | 3 | 248 | 547 | 628 | XOR08241.1 MAG: putative primase [Caudoviricetes sp.] | diamond | 246 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29391984 | 29391984 | PRJNA855894_P_NODE_2969_length_959_cov_2.811512_g2878_i0 | PRJNA855894 | 2969 | 959 | 2.811512 | 26.96240008 | Cryphonectria naterciae splipalmivirus 1 | 2841740 | Viruses | Viruses | 103 | 4.3499999999999997e-23 | NR | BCX55511.1 | 2841740 | g2878 | i0 | 69.7 | 0.237747653806048 | 76 | 22 | 23.8 | 1 | 2 | 229 | 82 | 156 | BCX55511.1 hypothetical protein 1 [Cryphonectria naterciae splipalmivirus 1] | diamond | 228 | 103 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus cryphonectriae | ||
| 32804683 | 32804683 | PRJNA855894_P_NODE_17980_length_358_cov_1.533333_g17858_i0 | PRJNA855894 | 17980 | 358 | 1.533333 | 5.48933214 | Grapevine wood holobiome associated narna-like virus 18 | 3398654 | Viruses | Viruses | 78.2 | 1.98e-15 | NR | XOD45389.1 | 3398654 | g17858 | i0 | 51.8 | 1.39106145251397 | 85 | 36 | 67 | 1 | 113 | 352 | 1 | 85 | XOD45389.1 HP1 [Grapevine wood holobiome associated narna-like virus 18] | diamond | 498 | 78.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Grapevine wood holobiome associated narna-like virus 18 |
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);;