RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1158727 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
27249335 27249335 PRJNA1158727_P_NODE_157023_length_243_cov_0.905882_g149561_i0 PRJNA1158727 157023 243 0.905882 2.20129326 Viruses 10239 Viruses Viruses 61.2 3.15e-9   NR DAF61303.1 2827924 g149561 i0 73.7 0.938271604938272 38 10 46.9 0 242 129 64 101 DAF61303.1 MAG TPA: hypothetical protein [Siphoviridae sp. ctkV91] diamond 228 61.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctkV91
27533675 27533675 PRJNA1158727_P_NODE_152323_length_245_cov_0.895349_g144861_i0 PRJNA1158727 152323 245 0.895349 2.19360505 Chimalliviridae 3152113 Viruses Viruses 58.9 7.33e-8   NR YP_009608978.1 2006684 g144861 i0 34.7 3.68571428571429 75 49 91.8 0 241 17 216 290 YP_009608978.1 hypothetical protein FDI21_gp063 [Pseudomonas phage Noxifer] diamond 903 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Noxifervirus Noxifervirus noxifer
28019652 28019652 PRJNA1158727_P_NODE_136885_length_250_cov_2.175141_g129423_i0 PRJNA1158727 136885 250 2.175141 5.4378525 Acinetobacter phage phiAC-1 1229760 Viruses Viruses 127 9.499999999999999e-35   NR YP_009216832.1 1229760 g129423 i0 65.1 0.996 83 29 99.6 0 2 250 91 173 YP_009216832.1 putative phage baseplate assembly protein [Acinetobacter phage phiAC-1] diamond 249 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage phiAC-1
28114079 28114079 PRJNA1158727_P_NODE_160145_length_242_cov_0.911243_g152683_i0 PRJNA1158727 160145 242 0.911243 2.20520806 Caudoviricetes sp. 2832643 Viruses Viruses 80.1 2.44e-15   NR XOS67002.1 2832643 g152683 i0 56.2 3.18595041322314 89 28 97.9 3 241 5 15 102 XOS67002.1 MAG: putative site-specific phage recombinase [Caudoviricetes sp.] diamond 771 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28840328 28840328 PRJNA1158727_P_NODE_137988_length_250_cov_0.870056_g130526_i0 PRJNA1158727 137988 250 0.870056 2.17514 Siphoviridae sp. ctWf32 2827884 Viruses Viruses 42 0.0169   NR DAF54549.1 2827884 g130526 i0 51.9 0.624 52 24 62.4 1 64 219 5 55 DAF54549.1 MAG TPA: hypothetical protein, partial [Siphoviridae sp. ctWf32] diamond 156 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctWf32
29439978 29439978 PRJNA1158727_P_NODE_107330_length_283_cov_1.100000_g99869_i0 PRJNA1158727 107330 283 1.1 3.113 uncultured Caudovirales phage 2100421 Viruses Viruses 66.6 3.23e-11   NR CAB5178673.1 2100421 g99869 i0 49.3 0.795053003533569 75 37 78.4 1 62 283 5 79 CAB5178673.1 hypothetical protein UFOVP156_23 [uncultured Caudovirales phage] diamond 225 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29535072 29535072 PRJNA1158727_P_NODE_164730_length_238_cov_2.800000_g157268_i0 PRJNA1158727 164730 238 2.8 6.664 Acinetobacter phage WCHABP12 1965454 Viruses Viruses 55.1 9.16e-7   NR YP_009600519.1 1965454 g157268 i0 70.7 0.516806722689076 41 11 50.4 1 117 236 1 41 YP_009600519.1 Erf-like ssDNA annealing protein [Acinetobacter phage WCHABP12] diamond 123 55.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Obolenskvirus Obolenskvirus WCHABP12
30419851 30419851 PRJNA1158727_P_NODE_95473_length_302_cov_1.008734_g88012_i0 PRJNA1158727 95473 302 1.008734 3.04637668 Synechococcus phage Yong-M3-232 2928847 Viruses Viruses 82.8 1.44e-16   NR UPT53098.1 2928847 g88012 i0 69.5 0.586092715231788 59 18 58.6 0 125 301 176 234 UPT53098.1 HNH endonuclease [Synechococcus phage Yong-M3-232] diamond 177 82.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Synechococcus phage Yong-M3-232
30640515 30640515 PRJNA1158727_P_NODE_164453_length_240_cov_2.167665_g156991_i0 PRJNA1158727 164453 240 2.167665 5.202396 Caudoviricetes sp. 2832643 Viruses Viruses 102 3.6799999999999996e-23   NR XOS27272.1 2832643 g156991 i0 88.9 0.7875 63 7 78.8 0 52 240 659 721 XOS27272.1 MAG: hypothetical protein MSP0001_80 [Caudoviricetes sp.] diamond 189 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30767066 30767066 PRJNA1158727_P_NODE_49974_length_501_cov_1.378505_g42519_i0 PRJNA1158727 49974 501 1.378505 6.90631005 Escherichia phage vB_EcoM_APEC 2759186 Viruses Viruses 198 1.87e-58   NR QMP81490.1 2759186 g42519 i0 60.2 1.98802395209581 166 66 99.4 0 499 2 7 172 QMP81490.1 replicative DNA helicase [Escherichia phage vB_EcoM_APEC] diamond 996 198 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage vB_EcoM_APEC
31083031 31083031 PRJNA1158727_P_NODE_62295_length_412_cov_1.657817_g54834_i0 PRJNA1158727 62295 412 1.657817 6.83020604 Acinetobacter phage phiAC-1 1229760 Viruses Viruses 142 3.36e-37   NR YP_009216797.1 1229760 g54834 i0 57.2 3.73543689320388 138 51 97.6 4 404 3 4 137 YP_009216797.1 portal protein [Acinetobacter phage phiAC-1] diamond 1539 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage phiAC-1
31145716 31145716 PRJNA1158727_P_NODE_129875_length_256_cov_1.683060_g122414_i0 PRJNA1158727 129875 256 1.68306 4.3086336 Acinetobacter phage vB_AbaM_ME3 1837876 Viruses Viruses 58.9 5.53e-8   NR YP_009596011.1 1837876 g122414 i0 57.7 0.609375 52 16 53.9 1 117 254 143 194 YP_009596011.1 hypothetical protein FDH01_gp282 [Acinetobacter phage vB_AbaM_ME3] diamond 156 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Metrivirus Metrivirus ME3
31367717 31367717 PRJNA1158727_P_NODE_100416_length_292_cov_1.406393_g92955_i0 PRJNA1158727 100416 292 1.406393 4.10666756 Pseudomonas phage vB_PaeM_PS119XW 2601632 Viruses Viruses 116 2.11e-28   NR YP_010660824.1 2601632 g92955 i0 58.3 1.97260273972603 96 40 98.6 0 290 3 214 309 YP_010660824.1 hypothetical protein PP933_gp084 [Pseudomonas phage vB_PaeM_PS119XW] diamond 576 116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Pawinskivirus Pawinskivirus PS119XW
31905187 31905187 PRJNA1158727_P_NODE_140317_length_249_cov_0.875000_g132855_i0 PRJNA1158727 140317 249 0.875 2.17875 Aphanizomenon phage vB_AphaS-CL131 2047766 Viruses Viruses 57.4 2.47e-7   NR ATW59331.1 2047766 g132855 i0 64.3 0.506024096385542 42 15 50.6 0 248 123 261 302 ATW59331.1 hypothetical protein Cl131_gp063 [Aphanizomenon phage vB_AphaS-CL131] diamond 126 57.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aphanizomenon phage vB_AphaS-CL131
32000199 32000199 PRJNA1158727_P_NODE_74518_length_357_cov_1.626761_g67057_i0 PRJNA1158727 74518 357 1.626761 5.80753677 Acinetobacter phage Ab59 3065419 Viruses Viruses 155 4.41e-44   NR WMC00560.1 3065419 g67057 i0 65.3 0.991596638655462 118 40 99.2 1 3 356 56 172 WMC00560.1 putative tail fiber protein [Acinetobacter phage Ab59] diamond 354 155 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Obolenskvirus Acinetobacter phage Ab59
32063377 32063377 PRJNA1158727_P_NODE_84778_length_326_cov_1.877470_g77317_i0 PRJNA1158727 84778 326 1.87747 6.1205522 Caudoviricetes sp. 2832643 Viruses Viruses 73.2 1.51e-12   NR DAZ56518.1 2832643 g77317 i0 44 2.56748466257669 91 48 81 2 273 10 9 99 DAZ56518.1 MAG TPA: intron associated endonuclease [Caudoviricetes sp.] diamond 837 73.2 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);;