RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 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
26603843 26603843 PRJNA558770_P_NODE_258741_length_234_cov_2.120603_g256736_i0 PRJNA558770 258741 234 2.120603 4.96221102 Microvirus sp. 2202559 Viruses Viruses 48.5 1.2e-4   NR WNK14872.1 2202559 g256736 i0 75 0.307692307692308 24 6 30.8 0 163 234 62 85 WNK14872.1 MAG: internal scaffolding protein [Microvirus sp.] diamond 72 48.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
26825950 26825950 PRJNA558770_P_NODE_385781_length_192_cov_7.560510_g383776_i0 PRJNA558770 385781 192 7.56051 14.5161792 Microviridae sp. 2202644 Viruses Viruses 86.7 2.45e-20   NR UOF78628.1 2202644 g383776 i0 67.2 1 64 21 100 0 192 1 5 68 UOF78628.1 hypothetical protein [Microviridae sp.] diamond 192 86.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26857787 26857787 PRJNA558770_P_NODE_390981_length_173_cov_4.253623_g388976_i0 PRJNA558770 390981 173 4.253623 7.35876779 Microviridae sp. 2202644 Viruses Viruses 70.9 1.47e-14   NR XOF05521.1 2202644 g388976 i0 100 0.641618497109827 37 0 64.2 0 112 2 1 37 XOF05521.1 MAG: hypothetical protein [Microviridae sp.] diamond 111 70.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
27110341 27110341 PRJNA558770_P_NODE_382142_length_208_cov_8.335260_g380137_i0 PRJNA558770 382142 208 8.33526 17.3373408 Microviridae sp. 2202644 Viruses Viruses 127 1.43e-32   NR UOF78622.1 2202644 g380137 i0 94 0.966346153846154 67 4 96.6 0 205 5 258 324 UOF78622.1 major capsid protein [Microviridae sp.] diamond 201 127 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
27774045 27774045 PRJNA558770_P_NODE_268884_length_234_cov_1.929648_g266879_i0 PRJNA558770 268884 234 1.929648 4.51537632 Blackfly microvirus SF 2576452 Viruses Viruses 43.1 0.0228   NR QCQ84715.1 2576452 g266879 i0 79.2 0.307692307692308 24 5 30.8 0 74 3 167 190 QCQ84715.1 replication initiator protein [Blackfly microvirus SF02] diamond 72 43.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Microvirus Blackfly microvirus SF02
28247324 28247324 PRJNA558770_P_NODE_241786_length_234_cov_2.497487_g239781_i0 PRJNA558770 241786 234 2.497487 5.84411958 Microviridae sp. 2202644 Viruses Viruses 51.2 3.05e-6   NR XOE98612.1 2202644 g239781 i0 88 0.320512820512821 25 3 32.1 0 1 75 2 26 XOE98612.1 MAG: DNA binding protein [Microviridae sp.] diamond 75 51.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29163406 29163406 PRJNA558770_P_NODE_47049_length_313_cov_8.694245_g45047_i0 PRJNA558770 47049 313 8.694245 27.21298685 Microviridae sp. 2202644 Viruses Viruses 91.7 1.77e-19   NR AXH75287.1 2202644 g45047 i0 76.5 0.488817891373802 51 12 48.9 0 312 160 142 192 AXH75287.1 MAG: replication initiator protein [Microviridae sp.] diamond 153 91.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29320968 29320968 PRJNA558770_P_NODE_55209_length_283_cov_6.370968_g53205_i0 PRJNA558770 55209 283 6.370968 18.02983944 Ariapismic virus 59 3376564 Viruses Viruses 62 1.42e-9   NR XJW04580.1 3376564 g53205 i0 72.1 0.45583038869258 43 12 45.6 0 137 9 50 92 XJW04580.1 MAG: internal scaffolding protein [Ariapismic virus 59] diamond 129 62 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 59
29384280 29384280 PRJNA558770_P_NODE_389549_length_178_cov_6.566434_g387544_i0 PRJNA558770 389549 178 6.566434 11.68825252 Microviridae sp. 2202644 Viruses Viruses 67 3.61e-11   NR AXH76120.1 2202644 g387544 i0 63.8 0.97752808988764 58 20 96.1 1 173 3 73 130 AXH76120.1 MAG: replication initiator protein [Microviridae sp.] diamond 174 67 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29604869 29604869 PRJNA558770_P_NODE_75030_length_239_cov_19.686275_g73025_i0 PRJNA558770 75030 239 19.686275 47.05019725 Microviridae sp. 2202644 Viruses Viruses 61.6 7.2e-9   NR AXH76551.1 2202644 g73025 i0 47.1 1.59414225941423 70 33 82.8 2 5 202 269 338 AXH76551.1 MAG: replication initiator protein [Microviridae sp.] diamond 381 61.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29808534 29808534 PRJNA558770_P_NODE_236011_length_234_cov_2.643216_g234006_i0 PRJNA558770 236011 234 2.643216 6.18512544 Microvirus 10842 Viruses Viruses 43.9 0.0127   NR AXH76386.1 2202644 g234006 i0 83.3 4.61538461538461 24 4 30.8 0 3 74 283 306 AXH76386.1 MAG: major capsid protein [Microviridae sp.] diamond 1080 44.3 0.99097065462754 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30110490 30110490 PRJNA558770_P_NODE_73372_length_242_cov_10.869565_g71367_i0 PRJNA558770 73372 242 10.869565 26.3043473 Microvirus sp. 2202559 Viruses Viruses 132 1.19e-35   NR QJB19245.1 2202559 g71367 i0 82.1 0.966942148760331 78 14 96.7 0 3 236 63 140 QJB19245.1 MAG: replication initiator protein [Microvirus sp.] diamond 234 132 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30236877 30236877 PRJNA558770_P_NODE_207452_length_234_cov_3.502513_g205447_i0 PRJNA558770 207452 234 3.502513 8.19588042 Ariapismic virus 19 3376425 Viruses Viruses 43.1 0.0124   NR XJW05234.1 3376426 g205447 i0 91.3 0.58974358974359 23 2 29.5 0 229 161 67 89 XJW05234.1 MAG: internal scaffolding protein [Ariapismic virus 190] diamond 138 43.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 190
30489727 30489727 PRJNA558770_P_NODE_56193_length_279_cov_19.930328_g54189_i0 PRJNA558770 56193 279 19.930328 55.60561512 Microviridae sp. 2202644 Viruses Viruses 101 8.28e-24   NR AXH73227.1 2202644 g54189 i0 56 0.978494623655914 91 38 95.7 1 274 8 121 211 AXH73227.1 MAG: DNA pilot protein [Microviridae sp.] diamond 273 101 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30774171 30774171 PRJNA558770_P_NODE_237054_length_234_cov_2.613065_g235049_i0 PRJNA558770 237054 234 2.613065 6.1145721 Microviridae sp. 2202644 Viruses Viruses 60.5 1.67e-8   NR AXH78097.1 2202644 g235049 i0 40.3 1.97435897435897 77 18 98.7 1 233 3 81 129 AXH78097.1 MAG: replication initiator protein [Microviridae sp.] diamond 462 60.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30805668 30805668 PRJNA558770_P_NODE_66174_length_256_cov_5.018100_g64169_i0 PRJNA558770 66174 256 5.0181 12.846336 Microviridae sp. 2202644 Viruses Viruses 58.5 1.07e-7   NR AXH76120.1 2202644 g64169 i0 52.8 0.62109375 53 24 60.9 1 6 161 302 354 AXH76120.1 MAG: replication initiator protein [Microviridae sp.] diamond 159 58.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31152739 31152739 PRJNA558770_P_NODE_204895_length_234_cov_3.597990_g202890_i0 PRJNA558770 204895 234 3.59799 8.4192966 Microviridae sp. 2202644 Viruses Viruses 50.8 1.54e-5   NR XOF02485.1 2202644 g202890 i0 91.7 0.628205128205128 24 2 30.8 0 161 232 60 83 XOF02485.1 MAG: hypothetical protein [Microviridae sp.] diamond 147 50.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31564566 31564566 PRJNA558770_P_NODE_377456_length_226_cov_10.361257_g375451_i0 PRJNA558770 377456 226 10.361257 23.41644082 Microviridae sp. 2202644 Viruses Viruses 43.5 0.00574   NR QRQ90067.1 2202644 g375451 i0 72 0.331858407079646 25 7 33.2 0 76 2 1 25 QRQ90067.1 MAG: major capsid protein, partial [Microviridae sp.] diamond 75 43.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31659004 31659004 PRJNA558770_P_NODE_285477_length_234_cov_1.648241_g283472_i0 PRJNA558770 285477 234 1.648241 3.85688394 Microvirus sp. 2202559 Viruses Viruses 46.2 0.00194   NR WNK14659.1 2202559 g283472 i0 87.5 2.83333333333333 24 3 30.8 0 2 73 192 215 WNK14659.1 MAG: major capsid protein [Microvirus sp.] diamond 663 46.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31799570 31799570 PRJNA558770_P_NODE_222997_length_234_cov_3.005025_g220992_i0 PRJNA558770 222997 234 3.005025 7.0317585 Viruses 10239 Viruses Viruses 59.3 8.35e-9   NR AXH76779.1 2202644 g220992 i0 47.4 1.92307692307692 76 15 97.4 1 7 234 90 140 AXH76779.1 MAG: internal scaffolding protein [Microviridae sp.] diamond 450 59.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31912255 31912255 PRJNA558770_P_NODE_381297_length_212_cov_3.525424_g379292_i0 PRJNA558770 381297 212 3.525424 7.47389888 bajarodmic virus 77 3343703 Viruses Viruses 53.9 7.5e-7   NR XHH69933.1 3344143 g379292 i0 56.5 1.31603773584906 46 20 65.1 0 212 75 86 131 XHH69933.1 internal scaffolding protein [bajarodmic virus 770] diamond 279 53.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Microvirus bajarodmic virus 770
32070405 32070405 PRJNA558770_P_NODE_205618_length_234_cov_3.572864_g203613_i0 PRJNA558770 205618 234 3.572864 8.36050176 Apis mellifera associated microvirus 49 2494779 Viruses Viruses 76.3 4.95e-14   NR AZL82871.1 2494779 g203613 i0 50 0.974358974358974 76 15 97.4 1 6 233 15 67 AZL82871.1 major capsid protein [Apis mellifera associated microvirus 49] diamond 228 76.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Apis mellifera associated microvirus 49

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