RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA795663 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
2055467 2055467 PRJNA795663_S_NODE_8522_length_206_cov_4.017751_g8417_i0 PRJNA795663 8522 206 4.017751 8.27656706 Ittyvirus 3044742 Viruses Viruses 120 4.24e-32   NR YP_010671599.1 2805750 g8417 i0 76.5 1.95145631067961 68 16 99 0 206 3 4 71 YP_010671599.1 hypothetical protein PQC19_gp10 [Pseudomonas phage Itty13] diamond 402 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
4607664 4607664 PRJNA795663_S_NODE_124_length_1260_cov_5.167621_g79_i0 PRJNA795663 124 1260 5.167621 65.1120246 Pseudomonas phage Itty13 2805750 Viruses Viruses 288 6.32e-93   NR YP_010671672.1 2805750 g79 i0 74.3 0.416666666666667 175 45 41.7 0 1252 728 17 191 YP_010671672.1 endolysin [Pseudomonas phage Itty13] diamond 525 288 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
26673625 26673625 PRJNA795663_S_NODE_8441_length_207_cov_2.341176_g8336_i0 PRJNA795663 8441 207 2.341176 4.84623432 Escherichia phage PJNS 3102713 Viruses Viruses 68.6 1.78e-11   NR WWV92023.1 3126091 g8336 i0 59.1 1.84057971014493 66 21 95.7 2 2 199 143 202 WWV92023.1 hypothetical protein [Escherichia phage PJNS034] diamond 381 68.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage PJNS034
28285304 28285304 PRJNA795663_S_NODE_10666_length_188_cov_1.516556_g10561_i0 PRJNA795663 10666 188 1.516556 2.85112528 Escherichia phage PJNS 3102713 Viruses Viruses 70.1 2.36e-12   NR WWV91980.1 3126091 g10561 i0 63.2 0.909574468085106 57 19 91 1 16 186 234 288 WWV91980.1 hypothetical protein [Escherichia phage PJNS034] diamond 171 70.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage PJNS034
28696180 28696180 PRJNA795663_S_NODE_3687_length_301_cov_1.678030_g3582_i0 PRJNA795663 3687 301 1.67803 5.0508703 Pseudomonas phage Itty13 2805750 Viruses Viruses 162 6.579999999999999e-46   NR YP_010671668.1 2805750 g3582 i0 80.8 0.98671096345515 99 19 98.7 0 3 299 71 169 YP_010671668.1 integrase [Pseudomonas phage Itty13] diamond 297 162 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
28696181 28696181 PRJNA795663_S_NODE_387_length_790_cov_3.810093_g317_i0 PRJNA795663 387 790 3.810093 30.0997347 Pseudomonas phage Itty13 2805750 Viruses Viruses 302 2.54e-98   NR YP_010671600.1 2805750 g317 i0 49.2 1.18101265822785 311 106 98.4 2 777 1 3 313 YP_010671600.1 baseplate wedge subunit [Pseudomonas phage Itty13] diamond 933 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
29012084 29012084 PRJNA795663_S_NODE_2888_length_336_cov_1.414716_g2783_i0 PRJNA795663 2888 336 1.414716 4.75344576 Caudoviricetes sp. 2832643 Viruses Viruses 180 3.29e-51   NR DAM62840.1 2832643 g2783 i0 74.8 2.96428571428571 111 28 99.1 0 334 2 155 265 DAM62840.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 996 180 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29106570 29106570 PRJNA795663_S_NODE_5548_length_249_cov_1.287736_g5443_i0 PRJNA795663 5548 249 1.287736 3.20646264 Shigella virus Moo19 2886042 Viruses Viruses 128 2.6099999999999996e-32   NR YP_010657803.1 2886042 g5443 i0 80 0.963855421686747 80 16 96.4 0 8 247 1 80 YP_010657803.1 tail spike protein [Shigella virus Moo19] diamond 240 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
29620344 29620344 PRJNA795663_S_NODE_18850_length_150_cov_2.707965_g18745_i0 PRJNA795663 18850 150 2.707965 4.0619475 root 1 Root_unresolved Root_unresolved 71.2 3.22e-13   NR YP_010671619.1 2805750 g18745 i0 69.4 2.86 49 15 98 0 148 2 176 224 YP_010671619.1 terminase small subunit [Pseudomonas phage Itty13] diamond 429 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
30148389 30148389 PRJNA795663_S_NODE_5132_length_257_cov_2.250000_g5027_i0 PRJNA795663 5132 257 2.25 5.7825 Pseudomonas phage Itty13 2805750 Viruses Viruses 115 2.17e-28   NR YP_010671600.1 2805750 g5027 i0 77.8 0.840466926070039 72 16 84 0 250 35 306 377 YP_010671600.1 baseplate wedge subunit [Pseudomonas phage Itty13] diamond 216 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
30180088 30180088 PRJNA795663_S_NODE_13272_length_172_cov_2.000000_g13167_i0 PRJNA795663 13272 172 2 3.44 Escherichia phage PJNS 3102713 Viruses Viruses 95.9 2.6500000000000003e-21   NR WWV91979.1 3126091 g13167 i0 80.8 0.906976744186046 52 10 90.7 0 172 17 156 207 WWV91979.1 hypothetical protein [Escherichia phage PJNS034] diamond 156 95.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage PJNS034
30211617 30211617 PRJNA795663_S_NODE_8832_length_203_cov_1.867470_g8727_i0 PRJNA795663 8832 203 1.86747 3.7909641 Pseudomonas phage Lana 2530172 Viruses Viruses 99.4 2.77e-25   NR YP_009820439.1 2530172 g8727 i0 70.1 0.990147783251232 67 20 99 0 1 201 14 80 YP_009820439.1 hypothetical protein HOV23_gp108 [Pseudomonas phage Lana] diamond 201 99.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lanavirus Lanavirus lana
30401833 30401833 PRJNA795663_S_NODE_7413_length_219_cov_1.983516_g7308_i0 PRJNA795663 7413 219 1.983516 4.34390004 Burkholderia phage BcepSauron 2530033 Viruses Viruses 87.4 4.17e-19   NR YP_009904434.1 2530033 g7308 i0 66.1 1.52054794520548 56 19 76.7 0 208 41 167 222 YP_009904434.1 glycosyltransferase [Burkholderia phage BcepSauron] diamond 333 87.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Sarumanvirus Sarumanvirus bcepsauron
30433322 30433322 PRJNA795663_S_NODE_2093_length_388_cov_3.569801_g1988_i0 PRJNA795663 2093 388 3.569801 13.85082788 Pseudomonas phage Skulduggery 2006671 Viruses Viruses 114 2.8799999999999997e-30   NR YP_010655408.1 2006671 g1988 i0 54.9 0.788659793814433 102 43 76.5 2 310 14 1 102 YP_010655408.1 hypothetical protein PP627_gp36 [Pseudomonas phage Skulduggery] diamond 306 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skulduggeryvirus Skulduggeryvirus skulduggery
30748915 30748915 PRJNA795663_S_NODE_2434_length_363_cov_1.671779_g2329_i0 PRJNA795663 2434 363 1.671779 6.06855777 uncultured Caudovirales phage 2100421 Viruses Viruses 50.4 1.31e-4   NR CAB4134886.1 2100421 g2329 i0 39.2 0.652892561983471 79 35 65.3 2 3 239 120 185 CAB4134886.1 hypothetical protein UFOVP275_29 [uncultured Caudovirales phage] diamond 237 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30875280 30875280 PRJNA795663_S_NODE_3234_length_319_cov_1.769504_g3129_i0 PRJNA795663 3234 319 1.769504 5.64471776 Pseudomonas phage Itty13 2805750 Viruses Viruses 159 9.14e-45   NR YP_010671668.1 2805750 g3129 i0 83.3 0.90282131661442 96 15 90.3 1 290 3 192 286 YP_010671668.1 integrase [Pseudomonas phage Itty13] diamond 288 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
31168578 31168578 PRJNA795663_S_NODE_5175_length_256_cov_2.196347_g5070_i0 PRJNA795663 5175 256 2.196347 5.62264832 root 1 Root_unresolved Root_unresolved 54.3 3.74e-6   NR YP_010655400.1 2006671 g5070 i0 49.1 1.76953125 53 26 62.1 1 161 3 1221 1272 YP_010655400.1 DarB-like antirestriction [Pseudomonas phage Skulduggery] diamond 453 54.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Skulduggeryvirus Skulduggeryvirus skulduggery
31285989 31285989 PRJNA795663_S_NODE_7095_length_223_cov_3.709677_g6990_i0 PRJNA795663 7095 223 3.709677 8.27257971 Serratia phage Parlo 2557554 Viruses Viruses 135 2.4699999999999996e-35   NR YP_009845065.1 2557554 g6990 i0 76.1 0.955156950672646 71 17 95.5 0 6 218 355 425 YP_009845065.1 terminase large subunit [Serratia phage Parlo] diamond 213 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Parlovirus Parlovirus parlo
31381188 31381188 PRJNA795663_S_NODE_4176_length_284_cov_1.595142_g4071_i0 PRJNA795663 4176 284 1.595142 4.53020328 Bacillus phage Shanette 1296656 Viruses Viruses 79 1.45e-16   NR YP_009216188.1 1296656 g4071 i0 50.6 0.813380281690141 77 37 81.3 1 52 282 1 76 YP_009216188.1 hypothetical protein AVV46_gp104 [Bacillus phage Shanette] diamond 231 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Siminovitchvirus Siminovitchvirus shanette
31507716 31507716 PRJNA795663_S_NODE_556_length_685_cov_3.412037_g474_i0 PRJNA795663 556 685 3.412037 23.37245345 Pseudomonas phage Itty13 2805750 Viruses Viruses 129 1.3e-30   NR YP_010671616.1 2805750 g474 i0 67.5 1.16934306569343 83 27 36.4 0 684 436 422 504 YP_010671616.1 putative TerL [Pseudomonas phage Itty13] diamond 801 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ittyvirus Ittyvirus itty13
31665578 31665578 PRJNA795663_S_NODE_9457_length_197_cov_2.406250_g9352_i0 PRJNA795663 9457 197 2.40625 4.7403125 Pseudomonas phage ZRG1 3032262 Viruses Viruses 60.5 7.63e-10   NR WID42097.1 3032262 g9352 i0 76.5 0.517766497461929 34 8 51.8 0 2 103 64 97 WID42097.1 HNH endonuclease [Pseudomonas phage ZRG1] diamond 102 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage ZRG1
31728829 31728829 PRJNA795663_S_NODE_5777_length_244_cov_3.429952_g5672_i0 PRJNA795663 5777 244 3.429952 8.36908288 Caudoviricetes sp. 2832643 Viruses Viruses 63.5 4.3e-11   NR XOS20065.1 2832643 g5672 i0 68.2 0.540983606557377 44 14 54.1 0 2 133 38 81 XOS20065.1 MAG: hypothetical protein MSP0058_141 [Caudoviricetes sp.] diamond 132 63.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31760509 31760509 PRJNA795663_S_NODE_2417_length_364_cov_2.626911_g2312_i0 PRJNA795663 2417 364 2.626911 9.56195604 Burkholderia phage Bcep22 2883944 Viruses Viruses 63.5 7.43e-9   NR NP_944280.1 2883944 g2312 i0 45.5 1.29395604395604 77 38 63.5 2 132 362 1 73 NP_944280.1 portal protein [Burkholderia phage Bcep22] diamond 471 63.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lessievirus Lessievirus bcep22
31791981 31791981 PRJNA795663_S_NODE_18217_length_152_cov_2.026087_g18112_i0 PRJNA795663 18217 152 2.026087 3.07965224 Serratia phage Parlo 2557554 Viruses Viruses 88.2 1.03e-18   NR YP_009845088.1 2557554 g18112 i0 90 2.96052631578947 50 5 98.7 0 150 1 2136 2185 YP_009845088.1 DarB-like antirestriction [Serratia phage Parlo] diamond 450 88.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Parlovirus Parlovirus parlo
32013675 32013675 PRJNA795663_S_NODE_3138_length_323_cov_3.024476_g3033_i0 PRJNA795663 3138 323 3.024476 9.76905748 Aeromonas phage ST4 3065692 Viruses Viruses 133 2.4999999999999997e-36   NR WNL63620.1 3065692 g3033 i0 72.4 0.975232198142415 105 29 97.5 0 318 4 69 173 WNL63620.1 hypothetical protein ST4_062 [Aeromonas phage ST4] diamond 315 133 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage ST4
32307896 32307896 PRJNA795663_S_NODE_11939_length_180_cov_1.083916_g11834_i0 PRJNA795663 11939 180 1.083916 1.9510488 Viruses 10239 Viruses Viruses 73.2 2.93e-13   NR QKW95403.1 2736195 g11834 i0 61.4 3.8 57 22 95 0 179 9 285 341 QKW95403.1 DarB-like antirestriction protein [Ralstonia phage RPZH6] diamond 684 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Gervaisevirus Ralstonia phage RPZH6
32844028 32844028 PRJNA795663_S_NODE_13700_length_170_cov_1.684211_g13595_i0 PRJNA795663 13700 170 1.684211 2.8631587 Viruses 10239 Viruses Viruses 54.7 5.87e-7   NR DAM52152.1 2832643 g13595 i0 85.2 0.952941176470588 27 4 47.6 0 169 89 212 238 DAM52152.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 162 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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