RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA917598", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 12 ✖

tax_phylum 1

  • Duplornaviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA917598 · 12 ✖

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
2170644 2170644 PRJNA917598_P_NODE_1182_length_2288_cov_291.512415_g955_i0 PRJNA917598 1182 2288 291.512415 6669.8040552 Betacystovirus phi12 3427160 Viruses Viruses 4004 0   NTclustered gi|22855216|ref|NC_004174.1| 161736 g955 i0 98.252 1 2288 40 100 0 1 2288 14 2301 Pseudomonas phage phi12 segment S, complete sequence blastn 2288 4004 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
9824927 9824927 PRJNA917598_P_NODE_88_length_6731_cov_27.772755_g67_i0 PRJNA917598 88 6731 27.772755 1869.38413905 Betacystovirus phi12 3427160 Viruses Viruses 6455 0   NTclustered gi|22855209|ref|NC_004173.1| 161736 g67 i0 84.001 1.00103996434408 6738 1061 100 15 1 6731 15 6742 Pseudomonas phage phi12 segment L, complete sequence blastn 6738 6455 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
22572819 22572819 PRJNA917598_P_NODE_318_length_4070_cov_82.526645_g247_i0 PRJNA917598 318 4070 82.526645 3358.8344515 Betacystovirus phi12 3427160 Viruses Viruses 6625 0   NTclustered gi|22855221|ref|NC_004175.1| 161736 g247 i0 96.045 1.0002457002457 4071 160 100 1 1 4070 20 4090 Pseudomonas phage phi12 segment M, complete sequence blastn 4071 6625 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
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
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
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
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
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
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
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

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