RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 21 ✖

bioproject 1

  • PRJNA917598 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26644547 26644547 PRJNA917598_P_NODE_65901_length_280_cov_1.381643_g64957_i0 PRJNA917598 65901 280 1.381643 3.8686004 Plasmopara viticola lesion associated mitovirus 51 2719480 Viruses Viruses 45.4 0.00599   NR QIR30274.1 2719480 g64957 i0 34.4 1.02857142857143 96 52 94.3 4 277 14 83 175 QIR30274.1 RNA-dependent RNA polymerase, partial [Plasmopara viticola lesion associated mitovirus 51] diamond 288 45.4 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Plasmopara viticola lesion associated mitovirus 51
26707731 26707731 PRJNA917598_P_NODE_14421_length_621_cov_1.784672_g13487_i0 PRJNA917598 14421 621 1.784672 11.08281312 Guangxi cysto-like virus 13 2824314 Viruses Viruses 57.8 5.5e-6   NR QYF49845.1 2824314 g13487 i0 37.8 0.434782608695652 90 56 43.5 0 602 333 175 264 QYF49845.1 MAG: hypothetical protein 2 [Guangxi cysto-like virus 13] diamond 270 57.8 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Guangxi cysto-like virus 13
26905425 26905425 PRJNA917598_P_NODE_10401_length_739_cov_4.138138_g9506_i0 PRJNA917598 10401 739 4.138138 30.58083982 Lenarviricota 2732407 Viruses Viruses 47.8 0.00654   NR WAK72389.1 2809572 g9506 i0 36.7 0.803788903924222 90 51 34.1 4 323 72 48 137 WAK72389.1 MAG: hypothetical protein [Mitoviridae sp.] diamond 594 48.1 0.993762993762994 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
27245835 27245835 PRJNA917598_P_NODE_56003_length_304_cov_1.329004_g55059_i0 PRJNA917598 56003 304 1.329004 4.04017216 Ripulip virus 3131096 Viruses Viruses 92 1.47e-19   NR WZH60849.1 3131096 g55059 i0 51 0.967105263157895 98 48 96.7 0 11 304 179 276 WZH60849.1 MAG: RNA-dependent RNA polymerase, partial [Ripulip virus] diamond 294 92 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Ripulip virus
27372634 27372634 PRJNA917598_P_NODE_63_length_7624_cov_12.407496_g50_i0 PRJNA917598 63 7624 12.407496 945.94749504 Red mite associated cystovirus 2936548 Viruses Viruses 462 5.34e-139   NR UQT02510.1 2936548 g50 i0 40.8 0.239244491080797 608 342 23.8 7 5164 3350 62 654 UQT02510.1 P2 [Red mite associated cystovirus] diamond 1824 462 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Cystovirus Red mite associated cystovirus
27404063 27404063 PRJNA917598_P_NODE_94903_length_241_cov_1.773810_g93959_i0 PRJNA917598 94903 241 1.77381 4.2748821 Phytophthora endornavirus 2 2779399 Viruses Viruses 45.1 0.00585   NR BCL84886.1 2779399 g93959 i0 48.6 0.460580912863071 37 17 44.8 2 26 133 616 651 BCL84886.1 polyprotein [Phytophthora endornavirus 2] diamond 111 45.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae   Phytophthora endornavirus 2
27435665 27435665 PRJNA917598_P_NODE_1043_length_2430_cov_84.378447_g845_i0 PRJNA917598 1043 2430 84.378447 2050.3962621 Pseudomonas phage phi12 161736 Viruses Viruses 90.1 5.72e-16   NR NP_690829.1 161736 g845 i0 29.8 0.444444444444444 191 119 22.2 5 1735 2274 57 243 NP_690829.1 muramidase [Pseudomonas phage phi12] diamond 1080 90.1 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27474356 27474356 PRJNA917598_P_NODE_37123_length_377_cov_1.197368_g36179_i0 PRJNA917598 37123 377 1.197368 4.51407736 Viruses 10239 Viruses Viruses 142 4.06e-38   NR URG15085.1 2027243 g36179 i0 52.4 3.11936339522546 126 58 98.7 2 5 376 54 179 URG15085.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] diamond 1176 142 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
27593479 27593479 PRJNA917598_P_NODE_14504_length_619_cov_1.996337_g13570_i0 PRJNA917598 14504 619 1.996337 12.35732603 Mitoviridae sp. 2809572 Viruses Viruses 160 1.19e-41   NR WAK72376.1 2809572 g13570 i0 45.9 0.886914378029079 183 93 88.2 4 550 5 1 178 WAK72376.1 MAG: RNA-dependent RNA polymerases [Mitoviridae sp.] diamond 549 160 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
28003971 28003971 PRJNA917598_P_NODE_20845_length_509_cov_1.892202_g19907_i0 PRJNA917598 20845 509 1.892202 9.63130818 Mitoviridae sp. 2809572 Viruses Viruses 131 7.35e-32   NR UJQ92600.1 2809572 g19907 i0 45.1 3.03536345776031 173 91 99.6 2 3 509 190 362 UJQ92600.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 1545 131 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
28666944 28666944 PRJNA917598_P_NODE_29627_length_423_cov_1.088571_g28683_i0 PRJNA917598 29627 423 1.088571 4.60465533 Qianjiang cysto-like virus 2 3349102 Viruses Viruses 182 1.36e-53   NR XHA85791.1 3349102 g28683 i0 61.7 1 141 54 100 0 1 423 15 155 XHA85791.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang cysto-like virus 2] diamond 423 182 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Qianjiang cysto-like virus 2
28792978 28792978 PRJNA917598_P_NODE_4307_length_1196_cov_1.596616_g3666_i0 PRJNA917598 4307 1196 1.596616 19.09552736 Mitoviridae sp. 2809572 Viruses Viruses 429 4.14e-141   NR WAK72382.1 2809572 g3666 i0 54.6 1.95401337792642 394 174 98.3 4 2 1177 205 595 WAK72382.1 MAG: RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 2337 429 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
29361495 29361495 PRJNA917598_P_NODE_169_length_5200_cov_22.644431_g133_i0 PRJNA917598 169 5200 22.644431 1177.510412 Pseudomonas phage phiNN 1603039 Viruses Viruses 67.4 2.21e-8   NR YP_009618372.1 1603039 g133 i0 46.2 0.0525 91 45 5.3 1 818 1090 44 130 YP_009618372.1 hypothetical protein [Pseudomonas phage phiNN] diamond 273 67.4 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Orthocystovirus Orthocystovirus phiNN
29779204 29779204 PRJNA917598_P_NODE_16791_length_572_cov_1.965932_g15856_i0 PRJNA917598 16791 572 1.965932 11.24513104 Lenarviricota 2732407 Viruses Viruses 129 1e-30   NR UJQ92566.1 2809572 g15856 i0 50.4 2.23426573426573 125 61 65.6 1 68 442 2 125 UJQ92566.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 1278 129 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
30024810 30024810 PRJNA917598_P_NODE_41931_length_354_cov_3.238434_g40987_i0 PRJNA917598 41931 354 3.238434 11.46405636 Cat Tien Hylomus ashce-like virus 3240111 Viruses Viruses 81.6 3.22e-17   NR XGJ13211.1 3240111 g40987 i0 66.7 0.559322033898305 66 20 55.9 1 353 156 56 119 XGJ13211.1 MAG: capsid protein [Cat Tien Hylomus ashce-like virus] diamond 198 81.6 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Timlovirales Steitzviridae Ashcevirus Cat Tien Hylomus ashce-like virus
30087748 30087748 PRJNA917598_P_NODE_45832_length_339_cov_1.157895_g44888_i0 PRJNA917598 45832 339 1.157895 3.92526405 Ripulip virus 3131096 Viruses Viruses 125 3.85e-32   NR WZH60849.1 3131096 g44888 i0 52.7 0.991150442477876 112 53 99.1 0 336 1 1 112 WZH60849.1 MAG: RNA-dependent RNA polymerase, partial [Ripulip virus] diamond 336 125 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Ripulip virus
30277757 30277757 PRJNA917598_P_NODE_7392_length_886_cov_1.644526_g6589_i0 PRJNA917598 7392 886 1.644526 14.57050036 Qianjiang cysto-like virus 2 3349102 Viruses Viruses 354 1.8599999999999998e-118   NR XHA85791.1 3349102 g6589 i0 61.1 0.95823927765237 283 108 95.8 1 857 9 1 281 XHA85791.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang cysto-like virus 2] diamond 849 354 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Qianjiang cysto-like virus 2
30372586 30372586 PRJNA917598_P_NODE_66912_length_278_cov_1.380488_g65968_i0 PRJNA917598 66912 278 1.380488 3.83775664 Inner Mongolia sediment alphaendornavirus 4 2824245 Viruses Viruses 79 7.99e-15   NR QYF50103.1 2824245 g65968 i0 44.3 4.66187050359712 88 49 95 0 271 8 281 368 QYF50103.1 MAG: polyprotein, partial [Inner Mongolia sediment alphaendornavirus 4] diamond 1296 79 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae Alphaendornavirus Inner Mongolia sediment alphaendornavirus 4
31320080 31320080 PRJNA917598_P_NODE_39415_length_366_cov_1.051195_g38471_i0 PRJNA917598 39415 366 1.051195 3.8473737 Ripulip virus 3131096 Viruses Viruses 109 7.26e-26   NR WZH60849.1 3131096 g38471 i0 51 0.836065573770492 102 50 83.6 0 60 365 1 102 WZH60849.1 MAG: RNA-dependent RNA polymerase, partial [Ripulip virus] diamond 306 109 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Ripulip virus
31857790 31857790 PRJNA917598_P_NODE_70017_length_272_cov_1.311558_g69073_i0 PRJNA917598 70017 272 1.311558 3.56743776 Mitoviridae sp. 2809572 Viruses Viruses 85.1 6.64e-17   NR UJQ92589.1 2809572 g69073 i0 50 4.65441176470588 84 42 92.6 0 252 1 438 521 UJQ92589.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 1266 85.1 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
32205974 32205974 PRJNA917598_P_NODE_538_length_3330_cov_4.043905_g424_i0 PRJNA917598 538 3330 4.043905 134.6620365 Qianjiang levi-like virus 42 3348452 Viruses Viruses 526 5.729999999999998e-172   NR XHA87358.1 3348452 g424 i0 51.4 0.461261261261261 512 245 45.9 3 1735 3261 9 519 XHA87358.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang levi-like virus 42] diamond 1536 526 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Qianjiang levi-like virus 42

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