RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA550047", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 15 ✖

tax_phylum 1

  • Lenarviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA550047 · 15 ✖

tax_clade 0

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
1791456 1791456 PRJNA550047_P_NODE_389702_length_269_cov_5.244898_g387730_i0 PRJNA550047 389702 269 5.244898 14.10877562 Erysiphe necator associated ourmia-like virus 76 2741856 Viruses Viruses 481 2.65e-131   NTclustered gi|1848976685|gb|MN611604.1| 2741856 g387730 i0 98.885 3.28624535315985 269 3 100 0 1 269 1588 1320 Erysiphe necator associated ourmia-like virus 76 isolate PMS2_DN33113, complete genome blastn 884 481 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 76
9441508 9441508 PRJNA550047_P_NODE_164968_length_345_cov_3.742647_g163008_i0 PRJNA550047 164968 345 3.742647 12.91213215 Erysiphe necator associated ourmia-like virus 76 2741856 Viruses Viruses 278 4.9500000000000006e-70   NTclustered gi|1848976685|gb|MN611604.1| 2741856 g163008 i0 100 1.29855072463768 150 0 86 0 196 345 866 1015 Erysiphe necator associated ourmia-like virus 76 isolate PMS2_DN33113, complete genome blastn 448 278 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 76
9444622 9444622 PRJNA550047_P_NODE_42108_length_367_cov_5.125850_g40153_i0 PRJNA550047 42108 367 5.12585 18.8118695 Erysiphe necator associated ourmia-like virus 76 2741856 Viruses Viruses 322 2.41e-83   NTclustered gi|1848976685|gb|MN611604.1| 2741856 g40153 i0 98.889 1.62942779291553 180 2 93 0 1 180 1842 2021 Erysiphe necator associated ourmia-like virus 76 isolate PMS2_DN33113, complete genome blastn 598 322 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 76
11992288 11992288 PRJNA550047_P_NODE_188410_length_344_cov_12.361624_g186449_i0 PRJNA550047 188410 344 12.361624 42.52398656 Sopawad virus 3131649 Viruses Viruses 226 1.81e-54   NTclustered gi|2717323044|gb|PP173950.1| 3131649 g186449 i0 94 6.43023255813953 150 7 44 1 195 344 4249 4102 MAG: Sopawad virus isolate SP1A_k141_78953 genomic sequence blastn 2212 226 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Sopawad virus
13272060 13272060 PRJNA550047_P_NODE_574911_length_205_cov_19.098485_g572938_i0 PRJNA550047 574911 205 19.098485 39.15189425 Orius laevigatus associated ourmiavirus 1 3344920 Viruses Viruses 99 2.27e-16   NTclustered gi|2802859168|gb|PP908631.1| 3344920 g572938 i0 91.549 0.346341463414634 71 6 35 0 33 103 180 250 MAG: Orius laevigatus associated ourmiavirus 1 isolate OlaeAOuV1 polyprotein gene, complete cds blastn 71 99 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Orius laevigatus associated ourmiavirus 1
14541356 14541356 PRJNA550047_P_NODE_11512_length_571_cov_5.877510_g9701_i0 PRJNA550047 11512 571 5.87751 33.5605821 Erysiphe necator associated ourmia-like virus 76 2741856 Viruses Viruses 579 2.09e-160   NTclustered gi|1848976685|gb|MN611604.1| 2741856 g9701 i0 98.476 1.51663747810858 328 5 93 0 244 571 367 40 Erysiphe necator associated ourmia-like virus 76 isolate PMS2_DN33113, complete genome blastn 866 579 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 76
14541869 14541869 PRJNA550047_P_NODE_15652_length_522_cov_16.728285_g13777_i0 PRJNA550047 15652 522 16.728285 87.3216477 Sopafab virus 3131770 Viruses Viruses 529 1.9399999999999998e-145   NTclustered gi|2717323354|gb|PP174071.1| 3131770 g13777 i0 97.727 41.5268199233716 308 6 59 1 210 517 4 310 MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence blastn 21677 529 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Sopafab virus
17095500 17095500 PRJNA550047_P_NODE_562734_length_209_cov_13.845588_g560761_i0 PRJNA550047 562734 209 13.845588 28.93727892 Ripalen virus 3130538 Viruses Viruses 337 4.5199999999999994e-88   NTclustered gi|2717320031|gb|PP172840.1| 3130538 g560761 i0 95.694 111.272727272727 209 9 100 0 1 209 4437 4229 MAG: Ripalen virus isolate KCAP1_k141_90819 genomic sequence blastn 23256 337 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripalen virus
18365181 18365181 PRJNA550047_P_NODE_204875_length_332_cov_2.416988_g202908_i0 PRJNA550047 204875 332 2.416988 8.02440016 Erysiphe necator associated ourmia-like virus 76 2741856 Viruses Viruses 580 3.229999999999999e-161   NTclustered gi|1848976685|gb|MN611604.1| 2741856 g202908 i0 98.193 2.97590361445783 332 6 100 0 1 332 1885 1554 Erysiphe necator associated ourmia-like virus 76 isolate PMS2_DN33113, complete genome blastn 988 580 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 76
18365197 18365197 PRJNA550047_P_NODE_205835_length_327_cov_15.811024_g203867_i0 PRJNA550047 205835 327 15.811024 51.70204848 Erysiphe necator associated ourmia-like virus 36 2741816 Viruses Viruses 300 9.95e-77   NTclustered gi|1848976605|gb|MN611564.1| 2741816 g203867 i0 83.988 4.31192660550459 331 33 99 13 3 327 2405 2089 Erysiphe necator associated ourmia-like virus 36 isolate PMS12_DN11639, complete genome blastn 1410 300 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 36
22195759 22195759 PRJNA550047_P_NODE_95398_length_345_cov_8.889706_g93438_i0 PRJNA550047 95398 345 8.889706 30.6694857 Sopafab virus 3131770 Viruses Viruses 171 8.64e-38   NTclustered gi|2717323354|gb|PP174071.1| 3131770 g93438 i0 91.87 141.727536231884 123 9 35 1 206 327 3358 3236 MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence blastn 48896 171 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Sopafab virus
24739256 24739256 PRJNA550047_P_NODE_1740_length_1659_cov_11.141866_g777_i0 PRJNA550047 1740 1659 11.141866 184.84355694 Erysiphe necator associated ourmia-like virus 36 2741816 Viruses Viruses 697 5.05e-245   NR QKI79866.1 2741816 g777 i0 83.3 0.735985533453888 407 68 73.6 0 437 1657 183 589 QKI79866.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 36] diamond 1221 697 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 36
27867568 27867568 PRJNA550047_P_NODE_280005_length_299_cov_4.402655_g278036_i0 PRJNA550047 280005 299 4.402655 13.16393845 Chronawum virus 3129986 Viruses Viruses 68.6 3.53e-11   NR WZH59063.1 3129986 g278036 i0 66 0.471571906354515 47 16 47.2 0 141 1 97 143 WZH59063.1 MAG: RNA-dependent RNA polymerase, partial [Chronawum virus] diamond 141 68.6 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Chronawum virus
31689887 31689887 PRJNA550047_P_NODE_440337_length_250_cov_7.858757_g438365_i0 PRJNA550047 440337 250 7.858757 19.6468925 Botourmiaviridae sp. 2808997 Viruses Viruses 43.5 0.0219   NR WAK77806.1 2808997 g438365 i0 34.8 0.828 69 44 82.8 1 247 41 430 497 WAK77806.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.] diamond 207 43.5 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
31816507 31816507 PRJNA550047_P_NODE_545657_length_215_cov_7.788732_g543684_i0 PRJNA550047 545657 215 7.788732 16.7457738 Emesvirus sp. 2960215 Viruses Viruses 70.9 3.72e-13   NR WWU04530.1 2960215 g543684 i0 54.3 0.976744186046512 70 31 96.3 1 2 208 30 99 WWU04530.1 MAG: putative maturation protein, partial [Emesvirus sp.] diamond 210 70.9 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Emesvirus Emesvirus sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;