RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA627467", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 13 ✖

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA627467 · 13 ✖

analysis 1

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
599152 599152 PRJNA627467_P_NODE_19241_length_161_cov_1.785714_g19172_i0 PRJNA627467 19241 161 1.785714 2.87499954 Potyvirus citrulli 3240504 Viruses Viruses 281 1.57e-71   NTclustered gi|1821701274|gb|MN186551.1| 146500 g19172 i0 98.734 98.0993788819876 158 2 98 0 1 158 727 884 Watermelon mosaic virus isolate 323-2016 polyprotein, helper component protease region, gene, partial cds blastn 15794 281 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
1875383 1875383 PRJNA627467_P_NODE_7422_length_235_cov_3.790323_g7353_i0 PRJNA627467 7422 235 3.790323 8.90725905 Potyvirus citrulli 3240504 Viruses Viruses 418 1.8e-112   NTclustered gi|326468192|gb|JF273463.1| 146500 g7353 i0 100 95.336170212766 226 0 96 0 5 230 4864 5089 Watermelon mosaic virus isolate C06-257, complete genome blastn 22404 418 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
1875389 1875389 PRJNA627467_P_NODE_7782_length_223_cov_2.977011_g7713_i0 PRJNA627467 7782 223 2.977011 6.63873453 Potyvirus citrulli 3240504 Viruses Viruses 385 1.72e-102   NTclustered gi|726972783|gb|KM527486.1| 146500 g7713 i0 98.182 98.6233183856502 220 4 99 0 4 223 241 460 Watermelon mosaic virus isolate WTLF-1 coat protein mRNA, partial cds blastn 21993 385 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
3150041 3150041 PRJNA627467_P_NODE_16423_length_167_cov_0.864407_g16354_i0 PRJNA627467 16423 167 0.864407 1.44355969 Potyvirus citrulli 3240504 Viruses Viruses 259 7.69e-65   NTclustered gi|1204712534|gb|KX664483.1| 146500 g16354 i0 95.122 91.562874251497007 164 8 98 0 1 164 742 579 Watermelon mosaic virus isolate WMV-WS, complete genome blastn 15291 259 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
4426756 4426756 PRJNA627467_P_NODE_1384_length_330_cov_1.672598_g1317_i0 PRJNA627467 1384 330 1.672598 5.5195734 Potyvirus citrulli 3240504 Viruses Viruses 195 4.88e-45   NTclustered gi|326468192|gb|JF273463.1| 146500 g1317 i0 97.368 46.269696969697 114 3 64 0 1 114 5788 5675 Watermelon mosaic virus isolate C06-257, complete genome blastn 15269 195 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
4426800 4426800 PRJNA627467_P_NODE_17484_length_164_cov_5.652174_g17415_i0 PRJNA627467 17484 164 5.652174 9.26956536 Potyvirus citrulli 3240504 Viruses Viruses 291 2.67e-74   NTclustered gi|1821701274|gb|MN186551.1| 146500 g17415 i0 99.375 97.3963414634146 160 1 98 0 2 161 366 207 Watermelon mosaic virus isolate 323-2016 polyprotein, helper component protease region, gene, partial cds blastn 15973 291 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
6977642 6977642 PRJNA627467_P_NODE_19026_length_161_cov_3.589286_g18957_i0 PRJNA627467 19026 161 3.589286 5.77875046 Potyvirus citrulli 3240504 Viruses Viruses 274 2.62e-69   NTclustered gi|1789811472|gb|MN686524.1| 146500 g18957 i0 98.701 95.111801242236 154 2 96 0 6 159 1397 1244 Watermelon mosaic virus isolate TX113, complete genome blastn 15313 274 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
8252254 8252254 PRJNA627467_P_NODE_11267_length_183_cov_2.813433_g11198_i0 PRJNA627467 11267 183 2.813433 5.14858239 Potyvirus citrulli 3240504 Viruses Viruses 322 1.08e-83   NTclustered gi|326468192|gb|JF273463.1| 146500 g11198 i0 98.361 99.9890710382514 183 3 100 0 1 183 6160 6342 Watermelon mosaic virus isolate C06-257, complete genome blastn 18298 322 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
10803267 10803267 PRJNA627467_P_NODE_10189_length_187_cov_1.876812_g10120_i0 PRJNA627467 10189 187 1.876812 3.50963844 Potyvirus citrulli 3240504 Viruses Viruses 322 1.1e-83   NTclustered gi|268628057|gb|FJ823122.1| 146500 g10120 i0 98.361 31.957219251336895 183 3 98 0 5 187 619 801 Watermelon mosaic virus isolate Lecce, complete genome blastn 5976 322 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
21001582 21001582 PRJNA627467_P_NODE_2677_length_316_cov_2.434457_g2609_i0 PRJNA627467 2677 316 2.434457 7.69288412 Potyvirus citrulli 3240504 Viruses Viruses 178 4.68e-40   NTclustered gi|1864318209|gb|MN464245.1| 146500 g2609 i0 100 55.2626582278481 96 0 30 0 218 313 660 565 Watermelon mosaic virus isolate Ir-W7 cytoplasmic inclusion protein gene, partial cds blastn 17463 178 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
21001632 21001632 PRJNA627467_P_NODE_7057_length_250_cov_6.378109_g6988_i0 PRJNA627467 7057 250 6.378109 15.9452725 Potyvirus citrulli 3240504 Viruses Viruses 436 5.349999999999999e-118   NTclustered gi|2547379353|gb|OQ680560.1| 146500 g6988 i0 99.174 97.072 242 2 97 0 6 247 7406 7165 Watermelon mosaic virus isolate EM190155, complete genome blastn 24268 436 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli
24102859 24102859 PRJNA627467_P_NODE_8779_length_198_cov_2.026846_g8710_i0 PRJNA627467 8779 198 2.026846 4.01315508 Viruses 10239 Viruses Viruses 52.8 0.017   NTclustered gi|2565349936|emb|OY624021.1| 2697049 g8710 i0 100 0.282828282828283 28 0 14 0 85 112 21766 21739 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 56 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
24825443 24825443 PRJNA627467_P_NODE_7540_length_231_cov_3.708791_g7471_i0 PRJNA627467 7540 231 3.708791 8.56730721 Potyvirus citrulli 3240504 Viruses Viruses 418 1.7699999999999994e-112   NTclustered gi|268628057|gb|FJ823122.1| 146500 g7471 i0 99.563 79.1774891774892 229 1 99 0 3 231 869 1097 Watermelon mosaic virus isolate Lecce, complete genome blastn 18290 418 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus citrulli

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