RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879221 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
856691 856691 PRJNA879221_P_NODE_13261_length_495_cov_2.184834_g13122_i0 PRJNA879221 13261 495 2.184834 10.8149283 Escherichia phage Lambda imm21 2918897 Viruses Viruses 76.3 4.15e-15   NR UNA07126.1 2918897 g13122 i0 73.9 0.278787878787879 46 12 27.9 0 356 493 1 46 UNA07126.1 hypothetical protein CPT_lambdaimm21_027 [Escherichia phage Lambda imm21] diamond 138 76.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lambdavirus Escherichia phage Lambda imm21
12335983 12335983 PRJNA879221_P_NODE_2910_length_1104_cov_15.967022_g2818_i0 PRJNA879221 2910 1104 15.967022 176.27592288 Caudoviricetes sp. 2832643 Viruses Viruses 91.3 1.47e-16   NR DAP49566.1 2832643 g2818 i0 42.1 0.328804347826087 121 69 32.6 1 1070 711 211 331 DAP49566.1 MAG TPA: DEDDh [Caudoviricetes sp.] diamond 363 91.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26770446 26770446 PRJNA879221_P_NODE_14821_length_467_cov_1.893401_g14682_i0 PRJNA879221 14821 467 1.893401 8.84218267 Arthrobacter phage Zeina 2832323 Viruses Viruses 169 2.52e-47   NR UQS94685.1 2832323 g14682 i0 66.1 1.54175588865096 124 42 79.7 0 459 88 281 404 UQS94685.1 portal protein [Arthrobacter phage Zeina] diamond 720 169 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Arthrobacter phage Zeina
27023623 27023623 PRJNA879221_P_NODE_36962_length_288_cov_1.362791_g36822_i0 PRJNA879221 36962 288 1.362791 3.92483808 Xylella phage Bacata 2674970 Viruses Viruses 52 2.32e-5   NR YP_009997500.1 2674970 g36822 i0 39.5 1.79166666666667 86 46 83.3 1 286 47 144 229 YP_009997500.1 MazG-like pyrophosphatase [Xylella phage Bacata] diamond 516 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casjensviridae Salvovirus Salvovirus bacata
27086980 27086980 PRJNA879221_P_NODE_54562_length_246_cov_0.890173_g54422_i0 PRJNA879221 54562 246 0.890173 2.18982558 Caudoviricetes sp. 2832643 Viruses Viruses 138 4.6199999999999997e-39   NR XOR05948.1 2832643 g54422 i0 74.1 0.98780487804878 81 21 98.8 0 245 3 110 190 XOR05948.1 MAG: neck protein [Caudoviricetes sp.] diamond 243 138 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27157814 27157814 PRJNA879221_P_NODE_63582_length_241_cov_0.916667_g63442_i0 PRJNA879221 63582 241 0.916667 2.20916747 Secretariatvirus 2843027 Viruses Viruses 75.9 8.05e-14   NR YP_009859440.1 2725616 g63442 i0 50 5.91286307053942 80 40 99.6 0 2 241 402 481 YP_009859440.1 tail length tape measure protein [Gordonia phage Secretariat] diamond 1425 76.6 0.990861618798956 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Secretariatvirus Secretariatvirus secretariat
28508098 28508098 PRJNA879221_P_NODE_56627_length_245_cov_0.895349_g56487_i0 PRJNA879221 56627 245 0.895349 2.19360505 uncultured Caudovirales phage 2100421 Viruses Viruses 48.9 2.13e-4   NR CAB4127603.1 2100421 g56487 i0 45.6 0.697959183673469 57 29 67.3 1 209 45 197 253 CAB4127603.1 hypothetical protein UFOVP92_52 [uncultured Caudovirales phage] diamond 171 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28886811 28886811 PRJNA879221_P_NODE_48948_length_250_cov_0.870056_g48808_i0 PRJNA879221 48948 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 42.7 0.0344   NR XOS26502.1 2832643 g48808 i0 30 2.136 90 55 98.4 2 248 3 130 219 XOS26502.1 MAG: hypothetical protein MSP0002_419 [Caudoviricetes sp.] diamond 534 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29328907 29328907 PRJNA879221_P_NODE_37949_length_284_cov_0.872038_g37809_i0 PRJNA879221 37949 284 0.872038 2.47658792 Podoviridae sp. ct9H612 2825226 Viruses Viruses 112 8.78e-28   NR DAG06535.1 2825226 g37809 i0 70.8 0.76056338028169 72 20 76.1 1 218 3 35 105 DAG06535.1 MAG TPA: N-acetylmuramoyl-L-alanine amidase [Podoviridae sp. ct9H612] diamond 216 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Podoviridae sp. ct9H612
29360585 29360585 PRJNA879221_P_NODE_42229_length_265_cov_1.604167_g42089_i0 PRJNA879221 42229 265 1.604167 4.25104255 Caudoviricetes sp. 2832643 Viruses Viruses 90.5 4.1e-20   NR XOF05680.1 2832643 g42089 i0 45.5 0.99622641509434 88 47 98.5 1 1 261 106 193 XOF05680.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 264 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29770843 29770843 PRJNA879221_P_NODE_48331_length_250_cov_0.870056_g48191_i0 PRJNA879221 48331 250 0.870056 2.17514 uncultured Caudovirales phage 2100421 Viruses Viruses 86.3 1.49e-19   NR CAB4126571.1 2100421 g48191 i0 49.4 0.924 77 38 91.2 1 245 18 46 122 CAB4126571.1 hypothetical protein UFOVP75_12 [uncultured Caudovirales phage] diamond 231 86.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29802488 29802488 PRJNA879221_P_NODE_34151_length_301_cov_1.350877_g34011_i0 PRJNA879221 34151 301 1.350877 4.06613977 Gordonia phage OlgasClover 3035386 Viruses Viruses 114 2.1600000000000003e-27   NR WNT45094.1 3035386 g34011 i0 57.9 3.19933554817276 107 36 97.7 4 296 3 106 212 WNT45094.1 hypothetical protein SEA_OLGASCLOVER_18 [Gordonia phage OlgasClover] diamond 963 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kenoshavirus Gordonia phage OlgasClover
29992173 29992173 PRJNA879221_P_NODE_62331_length_242_cov_0.911243_g62191_i0 PRJNA879221 62331 242 0.911243 2.20520806 Xanthomonas phage RiverRider 2108116 Viruses Viruses 84.7 6.25e-17   NR YP_009837837.1 2108116 g62191 i0 56.4 0.966942148760331 78 34 96.7 0 241 8 1782 1859 YP_009837837.1 virion RNA polymerase [Xanthomonas phage RiverRider] diamond 234 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Riverridervirus Riverridervirus riverrider
30592318 30592318 PRJNA879221_P_NODE_9833_length_586_cov_1.265107_g9695_i0 PRJNA879221 9833 586 1.265107 7.41352702 Caudoviricetes sp. 2832643 Viruses Viruses 95.5 1.04e-19   NR DAL30111.1 2832643 g9695 i0 41.7 0.798634812286689 156 74 72.2 4 522 100 135 288 DAL30111.1 MAG TPA_asm: tail-needle protein [Caudoviricetes sp.] diamond 468 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30845236 30845236 PRJNA879221_P_NODE_50914_length_248_cov_1.320000_g50774_i0 PRJNA879221 50914 248 1.32 3.2736 Caudoviricetes sp. 2832643 Viruses Viruses 86.7 1.37e-17   NR XOR06698.1 2832643 g50774 i0 45 0.967741935483871 80 44 96.8 0 5 244 239 318 XOR06698.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 240 86.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31350960 31350960 PRJNA879221_P_NODE_46996_length_251_cov_0.865169_g46856_i0 PRJNA879221 46996 251 0.865169 2.17157419 Plectonema phage JingP1 2961687 Viruses Viruses 52 1.85e-5   NR UTQ79781.1 2961687 g46856 i0 36 1.06374501992032 89 50 98 2 248 3 165 253 UTQ79781.1 hypothetical protein [Plectonema phage JingP1] diamond 267 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Saffermanviridae Morrisvirus Morrisvirus JingP1
32742175 32742175 PRJNA879221_P_NODE_53620_length_247_cov_0.885057_g53480_i0 PRJNA879221 53620 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 45.4 0.00145   NR XOR42047.1 2832643 g53480 i0 32.4 0.862348178137652 71 45 86.2 1 17 229 63 130 XOR42047.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 213 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32867910 32867910 PRJNA879221_P_NODE_3600_length_997_cov_5.272727_g3499_i0 PRJNA879221 3600 997 5.272727 52.56908819 Pseudomonas phage PaMx74 1175663 Viruses Viruses 183 1.07e-51   NR YP_009199450.1 1175663 g3499 i0 74.8 0.346038114343029 115 29 34.6 0 465 809 184 298 YP_009199450.1 putative DNA ligase [Pseudomonas phage PaMx74] diamond 345 183 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae Cinvestavvirus Cinvestavvirus PaMx74

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