RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA561212", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 21 ✖

tax_phylum 1

  • Pisuviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 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
545175 545175 PRJNA561212_P_NODE_1001_length_1062_cov_27595.039434_g676_i6 PRJNA561212 1001 1062 27595.039434 293059.31878908 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.77e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i6 85.714 1.05461393596987 91 11 8 2 27 115 9209 9119 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
545216 545216 PRJNA561212_P_NODE_12521_length_314_cov_12.190871_g12310_i0 PRJNA561212 12521 314 12.190871 38.27933494 Sobemovirus sp. 2809869 Viruses Viruses 206 2.13e-48   NTclustered gi|2171145024|gb|MZ218240.1| 2809869 g12310 i0 80 400.455414012739 280 54 89 2 11 289 4906 5184 MAG: Sobemovirus sp. isolate 267-k141_60134 genomic sequence blastn 125743 206 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Sobemovirus Sobemovirus sp.
545332 545332 PRJNA561212_P_NODE_1_length_10659_cov_2833.062441_g0_i0 PRJNA561212 1 10659 2833.062441 301976.12558619 Viruses 10239 Viruses Viruses 833 6.05e-254   NR XCO48968.1 1955144 g0 i0 32.2 5.04728398536448 1841 962 50 38 1940 7267 153 1772 XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 53799 841 0.990487514863258 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
1821157 1821157 PRJNA561212_P_NODE_2_length_9251_cov_83.505121_g1_i0 PRJNA561212 2 9251 83.505121 7725.05874371 brine shrimp iflavirus 3 2900464 Viruses Viruses 16831 0   NTclustered gi|2209094758|gb|OL472451.1| 2900464 g1 i0 99.567 10.9891903577992 9234 40 99 0 9 9242 9236 3 MAG: Brine shrimp iflavirus 3 isolate KAZ/15-16 RNA-dependent RNA polymerase gene, complete cds blastn 101661 16831 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
3096442 3096442 PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0 PRJNA561212 3 8346 49.070712 4095.44162352 Zebrafish picornavirus 1 2304617 Viruses Viruses 13572 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2 i0 96.194 3.03965971722981 8303 305 99 9 24 8322 8298 3 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 25369 13572 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
3096531 3096531 PRJNA561212_P_NODE_963_length_1087_cov_27600.694280_g676_i3 PRJNA561212 963 1087 27600.69428 300019.5468236 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.81e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i3 85.714 1.03035878564857 91 11 8 2 973 1061 9119 9209 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
4372952 4372952 PRJNA561212_P_NODE_4_length_5507_cov_45.314869_g2_i1 PRJNA561212 4 5507 45.314869 2495.48983583 Zebrafish picornavirus 1 2304617 Viruses Viruses 8918 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2 i1 95.994 2.99201016887598 5492 214 99 4 10 5498 7619 2131 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 16477 8918 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5649392 5649392 PRJNA561212_P_NODE_885_length_1124_cov_17293.054234_g676_i1 PRJNA561212 885 1124 17293.054234 194373.92959016 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.87e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i1 85.714 0.99644128113879 91 11 8 2 27 115 9209 9119 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
6923298 6923298 PRJNA561212_P_NODE_1306_length_946_cov_26928.316151_g676_i7 PRJNA561212 1306 946 26928.316151 254741.87078846 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.57e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i7 85.714 1.18393234672304 91 11 9 2 832 920 9119 9209 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
12024436 12024436 PRJNA561212_P_NODE_18110_length_267_cov_1.489691_g17899_i0 PRJNA561212 18110 267 1.489691 3.97747497 Zebrafish picornavirus 1 2304617 Viruses Viruses 335 2.169999999999999e-87   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g17899 i0 90.837 1.88014981273408 251 22 94 1 10 259 3141 2891 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 502 335 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17123131 17123131 PRJNA561212_P_NODE_23534_length_246_cov_5.393064_g23323_i0 PRJNA561212 23534 246 5.393064 13.26693744 Zebrafish picornavirus 1 2304617 Viruses Viruses 313 9.23e-81   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g23323 i0 91.342 2.81707317073171 231 17 93 1 10 237 3129 3359 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 693 313 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
20947713 20947713 PRJNA561212_P_NODE_797_length_1172_cov_22636.337580_g676_i0 PRJNA561212 797 1172 22636.33758 265297.8764376 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.96e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i0 85.714 0.955631399317406 91 11 8 2 1058 1146 9119 9209 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
22222636 22222636 PRJNA561212_P_NODE_898_length_1121_cov_23521.990458_g676_i2 PRJNA561212 898 1121 23521.990458 263681.51303418 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.87e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i2 85.714 0.999107939339875 91 11 8 2 27 115 9209 9119 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
23497956 23497956 PRJNA561212_P_NODE_999_length_1062_cov_30112.421638_g676_i4 PRJNA561212 999 1062 30112.421638 319793.91779556 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.77e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i4 85.714 1.05461393596987 91 11 8 2 27 115 9209 9119 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
24771483 24771483 PRJNA561212_P_NODE_1000_length_1062_cov_27694.141557_g676_i5 PRJNA561212 1000 1062 27694.141557 294111.78333534 Arma chinensis virus 1 2974718 Viruses Viruses 95.3 1.77e-14   NTclustered gi|2289441063|gb|MW846634.1| 2974718 g676 i5 85.714 1.05461393596987 91 11 8 2 27 115 9209 9119 Arma chinensis virus 1 isolate GZ1, complete genome blastn 1120 95.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Arma chinensis virus 1
27363863 27363863 PRJNA561212_P_NODE_15783_length_284_cov_1.289100_g15572_i0 PRJNA561212 15783 284 1.2891 3.661044 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 77.8 3.01e-14   NR XHA88449.1 3348787 g15572 i0 37.4 0.961267605633803 91 57 96.1 0 12 284 195 285 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 273 77.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
28153137 28153137 PRJNA561212_P_NODE_11305_length_329_cov_2.937500_g11094_i0 PRJNA561212 11305 329 2.9375 9.664375 Picornaviridae sp. 1530251 Viruses Viruses 106 2.1699999999999994e-24   NR WWV87070.1 1530251 g11094 i0 49.1 0.966565349544073 106 54 96.7 0 319 2 120 225 WWV87070.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 318 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29195056 29195056 PRJNA561212_P_NODE_209_length_1944_cov_2.265099_g160_i0 PRJNA561212 209 1944 2.265099 44.03352456 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 195 3.21e-48   NR XHA88449.1 3348787 g160 i0 52.3 0.300925925925926 195 82 30.1 3 16 600 378 561 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 585 195 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
29447283 29447283 PRJNA561212_P_NODE_90_length_2617_cov_2.301101_g67_i0 PRJNA561212 90 2617 2.301101 60.21981317 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 390 4.769999999999999e-112   NR XHA88449.1 3348787 g67 i0 40.1 0.765762323270921 668 335 74.4 22 11 1957 1946 2567 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 2004 390 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
30616103 30616103 PRJNA561212_P_NODE_12713_length_312_cov_2.150628_g12502_i0 PRJNA561212 12713 312 2.150628 6.70995936 Picornaviridae sp. 1530251 Viruses Viruses 117 4.65e-29   NR WWV86705.1 1530251 g12502 i0 53.9 0.980769230769231 102 46 97.1 1 2 304 134 235 WWV86705.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 306 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32576993 32576993 PRJNA561212_P_NODE_539_length_1376_cov_1.987721_g436_i0 PRJNA561212 539 1376 1.987721 27.35104096 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 302 6.87e-87   NR XHA88449.1 3348787 g436 i0 40.6 1.0094476744186 463 215 99 6 1371 10 1534 1945 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 1389 302 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6

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