RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA690592", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 20 ✖

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690592 · 20 ✖

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
8832028 8832028 PRJNA690592_S_NODE_51507_length_434_cov_1.279778_g50493_i0 PRJNA690592 51507 434 1.279778 5.55423652 Viruses 10239 Viruses Viruses 54.7 0.012   NTclustered gi|2906904862|gb|PQ805454.1| 2461425 g50493 i0 100 0.200460829493088 29 0 7 0 185 213 5931 5959 Goat astrovirus isolate GX/HC/C10/2024, complete genome blastn 87 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Goat astrovirus
12150331 12150331 PRJNA690592_S_NODE_150_length_4216_cov_8.450157_g70_i0 PRJNA690592 150 4216 8.450157 356.25861912 Solanum melongena bastro-like virus 2740136 Viruses Viruses 5999 0   NTclustered gi|1848664429|gb|MN841288.1| 2740136 g70 i0 92.416 2.98885199240987 4206 318 99 1 1 4205 3631 7836 Solanum melongena bastro-like virus strain pt065-phy-4-plant 65, complete genome blastn 12601 5999 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Solanum melongena bastro-like virus
12151153 12151153 PRJNA690592_S_NODE_670_length_2358_cov_3.538293_g507_i0 PRJNA690592 670 2358 3.538293 83.43294894 Solanum melongena bastro-like virus 2740136 Viruses Viruses 3249 0   NTclustered gi|2819064396|gb|PQ150499.1| 2740136 g507 i0 91.553 2.99745547073791 2356 199 99 0 1 2356 902 3257 MAG: Solanum melongena bastro-like virus isolate Hebei_128 genomic sequence blastn 7068 3249 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Solanum melongena bastro-like virus
14699750 14699750 PRJNA690592_S_NODE_12072_length_839_cov_1.629243_g11261_i0 PRJNA690592 12072 839 1.629243 13.66934877 Solanum melongena bastro-like virus 2740136 Viruses Viruses 1301 0   NTclustered gi|2819064396|gb|PQ150499.1| 2740136 g11261 i0 94.636 3.48986889153754 839 45 100 0 1 839 862 24 MAG: Solanum melongena bastro-like virus isolate Hebei_128 genomic sequence blastn 2928 1301 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Solanum melongena bastro-like virus
18523331 18523331 PRJNA690592_S_NODE_192115_length_249_cov_0.875000_g191101_i0 PRJNA690592 192115 249 0.875 2.17875 Zebrafish picornavirus 1 2304617 Viruses Viruses 339 1.5399999999999998e-88   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g191101 i0 91.532 0.995983935742972 248 18 98 3 1 245 2923 3170 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 248 339 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21073709 21073709 PRJNA690592_S_NODE_183517_length_252_cov_1.832402_g182503_i0 PRJNA690592 183517 252 1.832402 4.61765304 Sopidub virus 3131684 Viruses Viruses 185 2.16e-42   NTclustered gi|2717323145|gb|PP173985.1| 3131684 g182503 i0 85.185 4.10714285714286 189 18 72 7 47 227 2076 2262 MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence blastn 1035 185 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae   Sopidub virus
26924355 26924355 PRJNA690592_S_NODE_214522_length_241_cov_1.375000_g213508_i0 PRJNA690592 214522 241 1.375 3.31375 Astroviridae sp. 2585114 Viruses Viruses 44.3 0.00983   NR QDH87054.1 2585114 g213508 i0 36.2 0.858921161825726 69 44 85.9 0 26 232 69 137 QDH87054.1 MAG: RNA-dependent RNA polymerase [Astroviridae sp.] diamond 207 44.3 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Astroviridae sp.
27030598 27030598 PRJNA690592_S_NODE_174642_length_258_cov_2.081081_g173628_i0 PRJNA690592 174642 258 2.081081 5.36918898 Viruses 10239 Viruses Viruses 84 1.45e-16   NR QDH87819.1 1955153 g173628 i0 48.2 2.96511627906977 85 44 98.8 0 1 255 107 191 QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.] diamond 765 84 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
27188555 27188555 PRJNA690592_S_NODE_822_length_2199_cov_3.489652_g643_i0 PRJNA690592 822 2199 3.489652 76.73744748 Viruses 10239 Viruses Viruses 188 1.73e-45   NR XCM67725.1 1955153 g643 i0 25.7 2.90859481582538 707 474 92.8 21 113 2152 2344 3026 XCM67725.1 MAG: polyprotein [Picornavirales sp.] diamond 6396 189 0.994708994708995 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
27809141 27809141 PRJNA690592_S_NODE_103664_length_323_cov_1.280000_g102650_i0 PRJNA690592 103664 323 1.28 4.1344 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 95.9 2.22e-20   NR XDO02803.1 3239337 g102650 i0 49.5 1.98761609907121 107 51 99.4 2 322 2 1542 1645 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 642 95.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29020523 29020523 PRJNA690592_S_NODE_7328_length_1033_cov_2.626042_g6703_i0 PRJNA690592 7328 1033 2.626042 27.12701386 Viruses 10239 Viruses Viruses 210 3.5799999999999997e-62   NR WPV63357.1 3083973 g6703 i0 49.1 4.47531461761859 220 110 63.3 2 1033 380 72 291 WPV63357.1 MAG: polyprotein, partial [Wenzhou bat picornavirus 7] diamond 4623 211 0.995260663507109 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wenzhou bat picornavirus 7
29040690 29040690 PRJNA690592_S_NODE_79588_length_360_cov_1.209059_g78574_i0 PRJNA690592 79588 360 1.209059 4.3526124 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 138 5.159999999999998e-35   NR XDO02803.1 3239337 g78574 i0 57 0.95 114 49 95 0 359 18 1810 1923 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 342 138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29103679 29103679 PRJNA690592_S_NODE_186648_length_251_cov_0.865169_g185634_i0 PRJNA690592 186648 251 0.865169 2.17157419 Qianjiang picorna-like virus 37 3348762 Viruses Viruses 45.1 0.00653   NR XHA88494.1 3348762 g185634 i0 47.7 0.525896414342629 44 23 52.6 0 246 115 1797 1840 XHA88494.1 MAG: polyprotein [Qianjiang picorna-like virus 37] diamond 132 45.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 37
29987694 29987694 PRJNA690592_S_NODE_128051_length_296_cov_1.721973_g127037_i0 PRJNA690592 128051 296 1.721973 5.09704008 Caprine kobuvirus 1452516 Viruses Viruses 45.1 0.0112   NR WJZ69322.1 1452516 g127037 i0 37.4 0.922297297297297 91 45 87.2 4 31 288 2048 2131 WJZ69322.1 polyprotein [Caprine kobuvirus] diamond 273 45.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Kobuvirus cebes
30272428 30272428 PRJNA690592_S_NODE_89172_length_343_cov_1.518519_g88158_i0 PRJNA690592 89172 343 1.518519 5.20852017 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 46.6 0.00518   NR XDO02804.1 3239337 g88158 i0 29.3 1.16326530612245 133 61 98.8 4 3 341 458 577 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 399 46.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
31042085 31042085 PRJNA690592_S_NODE_213235_length_242_cov_0.911243_g212221_i0 PRJNA690592 213235 242 0.911243 2.20520806 Viruses 10239 Viruses Viruses 58.2 1.38e-7   NR WPV63372.1 3084702 g212221 i0 54.2 2.31818181818182 48 22 59.5 0 91 234 420 467 WPV63372.1 MAG: RNA-dependent RNA polymerase [Wenzhou shrew picornavirus 1] diamond 561 58.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wenzhou shrew picornavirus 1
31409694 31409694 PRJNA690592_S_NODE_12496_length_826_cov_1.901726_g11664_i0 PRJNA690592 12496 826 1.901726 15.70825676 Zebrafish jaw picornavirus RQ13 Viruses Viruses 230 1.35e-64   NR QXO14875.1 RQ13 g11664 i0 53.4 10.2966101694915 236 101 84.6 6 128 826 1861 2090 QXO14875.1 MAG: polyprotein, partial [Gallivirus sp.] diamond 8505 230 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Gallivirus Zebrafish jaw picornavirus
31630998 31630998 PRJNA690592_S_NODE_140256_length_285_cov_1.433962_g139242_i0 PRJNA690592 140256 285 1.433962 4.0867917 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 84 2.01e-16   NR XDO02804.1 3239337 g139242 i0 49.4 1.91578947368421 87 42 89.5 1 259 5 255 341 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 546 84 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
32105553 32105553 PRJNA690592_S_NODE_128958_length_295_cov_2.081081_g127944_i0 PRJNA690592 128958 295 2.081081 6.13918895 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 144 1.9999999999999997e-37   NR XDO02803.1 3239337 g127944 i0 66.7 0.976271186440678 96 32 97.6 0 3 290 1727 1822 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 288 144 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
32264098 32264098 PRJNA690592_S_NODE_159778_length_269_cov_1.571429_g158764_i0 PRJNA690592 159778 269 1.571429 4.22714401 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 50.8 7.48e-5   NR XDO02803.1 3239337 g158764 i0 41.1 0.62453531598513 56 33 62.5 0 269 102 763 818 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 168 50.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22

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