RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
14197429 14197429 PRJNA1035005_P_NODE_30252_length_282_cov_1.492823_g29846_i0 PRJNA1035005 30252 282 1.492823 4.20976086 root 1 Root_unresolved Root_unresolved 105 3.799999999999999e-24   NR CAB4195903.1 2100421 g29846 i0 73.8 1.71276595744681 80 21 85.1 0 3 242 658 737 CAB4195903.1 hypothetical protein UFOVP1295_43 [uncultured Caudovirales phage] diamond 483 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
18020777 18020777 PRJNA1035005_P_NODE_49715_length_257_cov_1.695652_g49309_i0 PRJNA1035005 49715 257 1.695652 4.35782564 Caudoviricetes sp. 2832643 Viruses Viruses 126 5.389999999999998e-35   NR DAK57376.1 2832643 g49309 i0 69.4 0.992217898832685 85 26 99.2 0 255 1 27 111 DAK57376.1 MAG TPA: dUTPase [Caudoviricetes sp.] diamond 255 126 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
25233998 25233998 PRJNA1035005_P_NODE_19080_length_304_cov_1.350649_g18674_i0 PRJNA1035005 19080 304 1.350649 4.10597296 Caudoviricetes sp. 2832643 Viruses Viruses 125 9.41e-31   NR DAO89770.1 2832643 g18674 i0 68.3 2.71381578947368 104 27 98.7 2 304 5 878 979 DAO89770.1 MAG TPA: tail tape measure [Caudoviricetes sp.] diamond 825 125 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26623539 26623539 PRJNA1035005_P_NODE_34221_length_277_cov_1.495098_g33815_i0 PRJNA1035005 34221 277 1.495098 4.14142146 Caudoviricetes sp. 2832643 Viruses Viruses 134 3.3499999999999996e-37   NR XOR09864.1 2832643 g33815 i0 72.2 0.974729241877256 90 25 97.5 0 276 7 13 102 XOR09864.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 270 134 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26623553 26623553 PRJNA1035005_P_NODE_77021_length_245_cov_0.906977_g76615_i0 PRJNA1035005 77021 245 0.906977 2.22209365 Acinetobacter phage vB_AbaM_BP1 2865959 Viruses Viruses 94.7 1.2e-22   NR UYL86081.1 2985293 g76615 i0 66.2 0.83265306122449 68 23 83.3 0 209 6 1 68 UYL86081.1 putative RNA polymerase [Acinetobacter phage vB_AbaM_BP10] diamond 204 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Obolenskvirus Acinetobacter phage vB_AbaM_BP10
26813677 26813677 PRJNA1035005_P_NODE_43461_length_265_cov_1.536458_g43055_i0 PRJNA1035005 43461 265 1.536458 4.0716137 Bacillus phage 458639 Viruses Viruses 51.6 3.85e-5   NR YP_001429636.1 458639 g43055 i0 43.7 0.80377358490566 71 32 80.4 2 53 265 9 71 YP_001429636.1 virion structural protein [Bacillus phage 0305phi8-36] diamond 213 51.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage 0305phi8-36
26845521 26845521 PRJNA1035005_P_NODE_78061_length_244_cov_1.824561_g77655_i0 PRJNA1035005 78061 244 1.824561 4.45192884 Siphoviridae sp. ctfYP22 2827584 Viruses Viruses 58.9 2.67e-9   NR DAD69782.1 2827584 g77655 i0 73.7 0.934426229508197 38 10 46.7 0 242 129 25 62 DAD69782.1 MAG TPA: hypothetical protein, partial [Siphoviridae sp. ctfYP22] diamond 228 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctfYP22
27256372 27256372 PRJNA1035005_P_NODE_55303_length_252_cov_3.156425_g54897_i0 PRJNA1035005 55303 252 3.156425 7.954191 Staphylococcus phage PMBT8 2590894 Viruses Viruses 68.9 2.34e-13   NR QDF14411.1 2590894 g54897 i0 53.3 0.714285714285714 60 28 71.4 0 19 198 1 60 QDF14411.1 hypothetical protein [Staphylococcus phage PMBT8] diamond 180 68.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Sextaecvirus Staphylococcus phage PMBT8
27887924 27887924 PRJNA1035005_P_NODE_58765_length_251_cov_1.443820_g58359_i0 PRJNA1035005 58765 251 1.44382 3.6239882 Pseudomonas phage Dolphis 2762288 Viruses Viruses 110 2.29e-26   NR QNJ57355.1 2762288 g58359 i0 67.1 0.9800796812749 82 27 98 0 249 4 38 119 QNJ57355.1 AAA-ATPase [Pseudomonas phage Dolphis] diamond 246 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Dolphis
27951250 27951250 PRJNA1035005_P_NODE_82585_length_243_cov_0.917647_g82179_i0 PRJNA1035005 82585 243 0.917647 2.22988221 Pseudomonas phage D6 3025445 Viruses Viruses 43.1 0.0158   NR WDS62029.1 3025445 g82179 i0 34.8 0.851851851851852 69 44 85.2 1 236 30 47 114 WDS62029.1 hypothetical protein [Pseudomonas phage D6] diamond 207 43.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage D6
28077377 28077377 PRJNA1035005_P_NODE_61545_length_250_cov_1.491525_g61139_i0 PRJNA1035005 61545 250 1.491525 3.7288125 Caudoviricetes sp. 2832643 Viruses Viruses 87.8 5.55e-18   NR DAJ83151.1 2832643 g61139 i0 51.2 0.984 82 40 98.4 0 248 3 726 807 DAJ83151.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 246 87.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28235101 28235101 PRJNA1035005_P_NODE_30066_length_282_cov_1.866029_g29660_i0 PRJNA1035005 30066 282 1.866029 5.26220178 Caudoviricetes sp. 2832643 Viruses Viruses 75.9 1.03e-13   NR DAJ83147.1 2832643 g29660 i0 41.3 0.978723404255319 92 53 97.9 1 281 6 274 364 DAJ83147.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 276 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28235120 28235120 PRJNA1035005_P_NODE_9626_length_368_cov_4.857627_g9221_i0 PRJNA1035005 9626 368 4.857627 17.87606736 Bacillus phage vB_BsuM-Goe3 1933063 Viruses Viruses 45.1 0.00598   NR YP_009832166.1 1933063 g9221 i0 39.7 0.554347826086957 68 36 51.4 2 159 347 51 118 YP_009832166.1 CoA ligase [Bacillus phage vB_BsuM-Goe3] diamond 204 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Grisebachstrassevirus Grisebachstrassevirus goe3
28393210 28393210 PRJNA1035005_P_NODE_89086_length_229_cov_3.147436_g88679_i0 PRJNA1035005 89086 229 3.147436 7.20762844 Caudoviricetes sp. 2832643 Viruses Viruses 66.6 1.09e-10   NR DAL31101.1 2832643 g88679 i0 49.4 1.91266375545852 77 36 98.3 3 3 227 292 367 DAL31101.1 MAG TPA_asm: DNA encapsidation protein [Caudoviricetes sp.] diamond 438 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28416947 28416947 PRJNA1035005_P_NODE_31646_length_280_cov_1.507246_g31240_i0 PRJNA1035005 31646 280 1.507246 4.2202888 Viruses 10239 Viruses Viruses 152 8.29e-43   NR YP_008873200.1 1279082 g31240 i0 80.6 2.98928571428571 93 18 99.6 0 2 280 72 164 YP_008873200.1 tail protein [Pseudomonas phage PPpW-3] diamond 837 152 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Hiroshimavirus Hiroshimavirus PPpW3
28614267 28614267 PRJNA1035005_P_NODE_76947_length_245_cov_0.906977_g76541_i0 PRJNA1035005 76947 245 0.906977 2.22209365 Caudoviricetes sp. 2832643 Viruses Viruses 65.1 9.22e-11   NR DAJ83036.1 2832643 g76541 i0 44 1.02857142857143 84 42 98 3 2 241 55 137 DAJ83036.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 252 65.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28740551 28740551 PRJNA1035005_P_NODE_77087_length_245_cov_0.906977_g76681_i0 PRJNA1035005 77087 245 0.906977 2.22209365 Caudoviricetes sp. 2832643 Viruses Viruses 84.7 4.35e-18   NR XOR20232.1 2832643 g76681 i0 54.9 0.869387755102041 71 32 86.9 0 9 221 88 158 XOR20232.1 MAG: putative IS transposase [Caudoviricetes sp.] diamond 213 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28803435 28803435 PRJNA1035005_P_NODE_32228_length_279_cov_2.621359_g31822_i0 PRJNA1035005 32228 279 2.621359 7.31359161 Caudoviricetes sp. 2832643 Viruses Viruses 42 0.0465   NR DAP85020.1 2832643 g31822 i0 42.9 0.602150537634409 56 31 59.1 1 114 278 1 56 DAP85020.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 168 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28930004 28930004 PRJNA1035005_P_NODE_35708_length_275_cov_1.514851_g35302_i0 PRJNA1035005 35708 275 1.514851 4.16584025 uncultured Caudovirales phage 2100421 Viruses Viruses 77 4.38e-16   NR CAB4135523.1 2100421 g35302 i0 62.3 0.578181818181818 53 20 57.8 0 275 117 41 93 CAB4135523.1 VRR-NUC domain containing protein [uncultured Caudovirales phage] diamond 159 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29561305 29561305 PRJNA1035005_P_NODE_76650_length_245_cov_0.906977_g76244_i0 PRJNA1035005 76650 245 0.906977 2.22209365 Microbacterium phage Magritte 3077798 Viruses Viruses 105 2.33e-24   NR WNN95046.1 3077798 g76244 i0 67.6 0.906122448979592 74 23 89.4 1 219 1 640 713 WNN95046.1 DNA polymerase I [Microbacterium phage Magritte] diamond 222 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Magritte
29719050 29719050 PRJNA1035005_P_NODE_64690_length_249_cov_0.886364_g64284_i0 PRJNA1035005 64690 249 0.886364 2.20704636 Caudoviricetes sp. 2832643 Viruses Viruses 48.1 5.02e-4   NR DAK98454.1 2832643 g64284 i0 43.6 1.32530120481928 55 28 62.7 1 231 76 289 343 DAK98454.1 MAG TPA: endonuclease-like protein [Caudoviricetes sp.] diamond 330 48.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30351672 30351672 PRJNA1035005_P_NODE_57752_length_252_cov_0.871508_g57346_i0 PRJNA1035005 57752 252 0.871508 2.19620016 Enterococcus phage 9181 2763101 Viruses Viruses 92.4 1.39e-19   NR QOC57490.1 2763101 g57346 i0 53.2 0.916666666666667 77 36 91.7 0 250 20 52 128 QOC57490.1 tail fiber protein [Enterococcus phage 9181] diamond 231 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Enterococcus phage 9181
30667056 30667056 PRJNA1035005_P_NODE_11113_length_352_cov_2.652330_g10708_i0 PRJNA1035005 11113 352 2.65233 9.3362016 Corynebacterium phage EmiRose 2565372 Viruses Viruses 133 1.65e-33   NR YP_010754301.1 2565372 g10708 i0 59.8 0.997159090909091 117 45 99.7 1 1 351 145 259 YP_010754301.1 DNA polymerase I [Corynebacterium phage EmiRose] diamond 351 133 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Emirosevirus Emirosevirus emirose
31520655 31520655 PRJNA1035005_P_NODE_64216_length_249_cov_1.579545_g63810_i0 PRJNA1035005 64216 249 1.579545 3.93306705 Aeromonas phage 4_L372X 2588519 Viruses Viruses 73.9 4.47e-14   NR QFG15372.1 2588519 g63810 i0 50.8 0.759036144578313 63 31 75.9 0 245 57 123 185 QFG15372.1 hypothetical protein 4L372X_060 [Aeromonas phage 4_L372X] diamond 189 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage 4_L372X
31678516 31678516 PRJNA1035005_P_NODE_31837_length_280_cov_1.507246_g31431_i0 PRJNA1035005 31837 280 1.507246 4.2202888 Pseudomonas phage pf16 1815630 Viruses Viruses 68.9 3.49e-11   NR YP_009595661.1 1815630 g31431 i0 40.8 1.05 98 50 96.4 2 4 273 327 424 YP_009595661.1 baseplate hub subunit and tail lysozyme [Pseudomonas phage pf16] diamond 294 68.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Chakrabartyvirus Chakrabartyvirus pf16
31994999 31994999 PRJNA1035005_P_NODE_10558_length_358_cov_1.642105_g10153_i0 PRJNA1035005 10558 358 1.642105 5.8787359 Caudoviricetes sp. 2832643 Viruses Viruses 67 4.61e-10   NR DAJ83143.1 2832643 g10153 i0 52.6 0.477653631284916 57 27 47.8 0 26 196 1 57 DAJ83143.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 171 67 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32216564 32216564 PRJNA1035005_P_NODE_87078_length_239_cov_2.355422_g86672_i0 PRJNA1035005 87078 239 2.355422 5.62945858 Microbacterium phage Nike 2719203 Viruses Viruses 92.4 1.1e-21   NR QIQ63669.1 2719203 g86672 i0 57.7 0.97907949790795 78 27 91.6 2 9 227 75 151 QIQ63669.1 hypothetical protein SEA_NIKE_89 [Microbacterium phage Nike] diamond 234 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Squashvirus Microbacterium phage Nike
32248441 32248441 PRJNA1035005_P_NODE_21898_length_293_cov_2.836364_g21492_i0 PRJNA1035005 21898 293 2.836364 8.31054652 Shewanella phage SFCi1 1852599 Viruses Viruses 75.9 1.5700000000000001e-13   NR ANO58029.1 1852599 g21492 i0 57.4 0.62457337883959 61 24 61.4 2 289 110 763 822 ANO58029.1 putative DNA polymerase [Shewanella phage SFCi1] diamond 183 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage SFCi1
32847870 32847870 PRJNA1035005_P_NODE_52300_length_254_cov_1.635359_g51894_i0 PRJNA1035005 52300 254 1.635359 4.15381186 Caudoviricetes sp. 2832643 Viruses Viruses 126 1.0599999999999998e-31   NR DAJ83005.1 2832643 g51894 i0 72.3 0.980314960629921 83 23 98 0 253 5 148 230 DAJ83005.1 MAG TPA: Terminase [Caudoviricetes sp.] diamond 249 126 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);;