RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA690592" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 22 ✖

bioproject 1

  • PRJNA690592 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
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.
27398720 27398720 PRJNA690592_S_NODE_48803_length_444_cov_1.646900_g47789_i0 PRJNA690592 48803 444 1.6469 7.312236 Downy mildew lesion associated splipalmivirus 44 3070776 Viruses Viruses 232 1.87e-75   NR WNA22226.1 3070776 g47789 i0 81.6 1.83783783783784 136 25 91.9 0 35 442 1 136 WNA22226.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 44] diamond 816 232 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Downy mildew lesion associated splipalmivirus 44
27430323 27430323 PRJNA690592_S_NODE_147483_length_279_cov_1.194175_g146469_i0 PRJNA690592 147483 279 1.194175 3.33174825 ssRNA phage SRR5466338_2 2786391 Viruses Viruses 54.7 3.39e-6   NR YP_010769838.1 2786391 g146469 i0 55.6 1.63440860215054 45 19 48.4 1 224 90 171 214 YP_010769838.1 maturation protein [ssRNA phage SRR5466338_2] diamond 456 54.7 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Rusvolovirus Rusvolovirus asiadaptatum
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
29829663 29829663 PRJNA690592_S_NODE_16071_length_737_cov_13.043675_g15165_i0 PRJNA690592 16071 737 13.043675 96.13188475 Rhizopus microsporus phasma-like virus 1 3156537 Viruses Viruses 138 1.57e-36   NR BFM51672.1 3156537 g15165 i0 41.4 0.777476255088195 191 107 77.3 3 694 125 4 190 BFM51672.1 hypothetical protein [Rhizopus microsporus phasma-like virus 1] diamond 573 138 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Rhizopus microsporus phasma-like virus 1
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
30177248 30177248 PRJNA690592_S_NODE_72_length_6509_cov_27.059975_g22_i0 PRJNA690592 72 6509 27.059975 1761.33377275 Tolivirales sp. 2809914 Viruses Viruses 120 9.4e-24   NR WRQ65297.1 2809914 g22 i0 29 0.205100629897066 445 261 19.5 21 5097 6368 97 507 WRQ65297.1 hypothetical protein, partial [Tolivirales sp.] diamond 1335 120 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
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
30809209 30809209 PRJNA690592_S_NODE_2454_length_1540_cov_3.020450_g2122_i0 PRJNA690592 2454 1540 3.02045 46.51493 Qianjiang toti-like virus 8 3348857 Viruses Viruses 61.2 9.61e-6   NR XHA85760.1 3348857 g2122 i0 26.4 0.562987012987013 140 100 27.1 2 1516 1100 429 566 XHA85760.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang toti-like virus 8] diamond 867 61.2 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Qianjiang toti-like virus 8
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
32074100 32074100 PRJNA690592_S_NODE_74278_length_371_cov_1.033557_g73264_i0 PRJNA690592 74278 371 1.033557 3.83449647 Rhizopus microsporus phasma-like virus 1 3156537 Viruses Viruses 65.9 3.48e-10   NR BFM51672.1 3156537 g73264 i0 34.4 2.82210242587601 128 73 98.7 5 1 366 41 163 BFM51672.1 hypothetical protein [Rhizopus microsporus phasma-like virus 1] diamond 1047 65.9 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Rhizopus microsporus phasma-like virus 1
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
32327491 32327491 PRJNA690592_S_NODE_15819_length_742_cov_23.198804_g14916_i0 PRJNA690592 15819 742 23.198804 172.13512568 Rhizopus microsporus phasma-like virus 1 3156537 Viruses Viruses 145 2.3999999999999998e-39   NR BFM51672.1 3156537 g14916 i0 42.1 0.788409703504043 195 107 78.4 4 38 619 1 190 BFM51672.1 hypothetical protein [Rhizopus microsporus phasma-like virus 1] diamond 585 145 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Rhizopus microsporus phasma-like virus 1
32674477 32674477 PRJNA690592_S_NODE_216960_length_238_cov_4.612121_g215946_i0 PRJNA690592 216960 238 4.612121 10.97684798 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 43.5 0.0192   NR XCO56027.1 3233859 g215946 i0 37.9 0.73109243697479 58 36 73.1 0 1 174 531 588 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 174 43.5 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1

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