RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1143173" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1143173 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
18137830 18137830 PRJNA1143173_P_NODE_1795_length_542_cov_4.347548_g1769_i0 PRJNA1143173 1795 542 4.347548 23.56371016 Caudoviricetes sp. 2832643 Viruses Viruses 189 1.3e-57   NR XOR51516.1 2832643 g1769 i0 76.2 0.675276752767528 122 29 67.5 0 368 3 9 130 XOR51516.1 MAG: ribonucleotide reductase A subunit [Caudoviricetes sp.] diamond 366 189 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26975459 26975459 PRJNA1143173_P_NODE_17142_length_295_cov_3.842342_g17116_i0 PRJNA1143173 17142 295 3.842342 11.3349089 uncultured Caudovirales phage 2100421 Viruses Viruses 157 5e-43   NR CAB5222668.1 2100421 g17116 i0 77.3 0.986440677966102 97 22 98.6 0 3 293 315 411 CAB5222668.1 hypothetical protein UFOVP378_20 [uncultured Caudovirales phage] diamond 291 157 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
26995915 26995915 PRJNA1143173_P_NODE_2162_length_511_cov_11.568493_g2136_i0 PRJNA1143173 2162 511 11.568493 59.11499923 root 1 Root_unresolved Root_unresolved 73.9 4.32e-13   NR YP_006988261.1 1211640 g2136 i0 36.2 2.40117416829746 152 82 85.7 5 48 485 13 155 YP_006988261.1 hypothetical protein CcrColossus_gp027 [Caulobacter phage CcrColossus] diamond 1227 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Jeanschmidtviridae Colossusvirus Colossusvirus colossus
27196658 27196658 PRJNA1143173_P_NODE_14302_length_299_cov_4.123894_g14276_i0 PRJNA1143173 14302 299 4.123894 12.33044306 Caudoviricetes sp. 2832643 Viruses Viruses 66.6 1.79e-11   NR QMP82925.1 2832643 g14276 i0 57.7 0.521739130434783 52 22 52.2 0 296 141 64 115 QMP82925.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 156 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27228373 27228373 PRJNA1143173_P_NODE_38203_length_233_cov_2.356250_g38177_i0 PRJNA1143173 38203 233 2.35625 5.4900625 Caudoviricetes sp. 2832643 Viruses Viruses 51.2 3.23e-5   NR DAW40938.1 2832643 g38177 i0 41.2 0.875536480686695 68 36 85 2 233 36 19 84 DAW40938.1 MAG TPA: Protein of unknown function (DUF2800) [Caudoviricetes sp.] diamond 204 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27386682 27386682 PRJNA1143173_P_NODE_37183_length_236_cov_5.779141_g37157_i0 PRJNA1143173 37183 236 5.779141 13.63877276 Rhizobium phage RHph_Y65 2509785 Viruses Viruses 110 2.75e-26   NR YP_010671358.1 2509785 g37157 i0 63.6 0.978813559322034 77 28 97.9 0 233 3 241 317 YP_010671358.1 ribonucleotide reductase [Rhizobium phage RHph_Y65] diamond 231 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Kleczkowskaviridae Cuauhnahuacvirus Cuauhnahuacvirus Y65
27418335 27418335 PRJNA1143173_P_NODE_41283_length_219_cov_4.630137_g41257_i0 PRJNA1143173 41283 219 4.630137 10.14000003 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 1.64e-6   NR XOR51503.1 2832643 g41257 i0 35.1 1.01369863013699 74 46 98.6 1 2 217 475 548 XOR51503.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 222 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27702558 27702558 PRJNA1143173_P_NODE_21664_length_282_cov_3.043062_g21638_i0 PRJNA1143173 21664 282 3.043062 8.58143484 Burkholderia phage vB_BceS_KL1 1132026 Viruses Viruses 60.8 9.07e-10   NR YP_006560752.1 1132026 g21638 i0 61.7 0.5 47 18 50 0 280 140 26 72 YP_006560752.1 lipoprotein [Burkholderia phage vB_BceS_KL1] diamond 141 60.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kilunavirus Kilunavirus KL1
27859971 27859971 PRJNA1143173_P_NODE_43465_length_205_cov_8.007576_g43439_i0 PRJNA1143173 43465 205 8.007576 16.4155308 Staphylococcus phage Alsa_2 3076562 Viruses Viruses 99.4 4.95e-25   NR WNM50766.1 3076562 g43439 i0 72.9 1.02439024390244 70 16 98 1 5 205 38 107 WNM50766.1 hypothetical protein Alsa2_CDS0152 [Staphylococcus phage Alsa_2] diamond 210 99.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae   Staphylococcus phage Alsa_2
28460206 28460206 PRJNA1143173_P_NODE_19406_length_289_cov_1.421296_g19380_i0 PRJNA1143173 19406 289 1.421296 4.10754544 Caudoviricetes sp. 2832643 Viruses Viruses 144 1.28e-37   NR XOR69605.1 2832643 g19380 i0 73.9 0.955017301038062 92 24 95.5 0 9 284 366 457 XOR69605.1 MAG: putative phage replicative helicase/primease [Caudoviricetes sp.] diamond 276 144 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28838800 28838800 PRJNA1143173_P_NODE_24108_length_275_cov_1.500000_g24082_i0 PRJNA1143173 24108 275 1.5 4.125 Bacillus phage vB_BauM_KLEB27-3 2927635 Viruses Viruses 70.5 5.33e-12   NR UNY39854.1 2927635 g24082 i0 40.4 2.00727272727273 94 49 96 4 273 10 78 170 UNY39854.1 ThiF family adenylyltransferase [Bacillus phage vB_BauM_KLEB27-3] diamond 552 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BauM_KLEB27-3
29691053 29691053 PRJNA1143173_P_NODE_20070_length_287_cov_1.439252_g20044_i0 PRJNA1143173 20070 287 1.439252 4.13065324 Caudoviricetes sp. 2832643 Viruses Viruses 41.2 0.0217   NR XOR51506.1 2832643 g20044 i0 37 0.564459930313589 54 33 55.4 1 284 126 1 54 XOR51506.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 162 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29975640 29975640 PRJNA1143173_P_NODE_29411_length_259_cov_5.403226_g29385_i0 PRJNA1143173 29411 259 5.403226 13.99435534 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 102 3.4199999999999996e-23   NR DAF42526.1 2827830 g29385 i0 56.5 0.984555984555985 85 37 98.5 0 255 1 143 227 DAF42526.1 MAG TPA: Membrane carboxypeptidase (penicillin-binding protein) [Siphoviridae sp. ctHip2] diamond 255 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
30355283 30355283 PRJNA1143173_P_NODE_10752_length_310_cov_3.675105_g10726_i0 PRJNA1143173 10752 310 3.675105 11.3928255 Caudoviricetes sp. 2832643 Viruses Viruses 90.5 1.3e-18   NR XOR51542.1 2832643 g10726 i0 50.5 2.13870967741935 107 46 96.8 1 9 308 22 128 XOR51542.1 MAG: LysM domain-containing protein [Caudoviricetes sp.] diamond 663 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30481201 30481201 PRJNA1143173_P_NODE_31433_length_253_cov_7.944444_g31407_i0 PRJNA1143173 31433 253 7.944444 20.09944332 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 43.9 0.0161   NR DAF42525.1 2827830 g31407 i0 29.1 0.936758893280632 79 53 93.7 1 237 1 52 127 DAF42525.1 MAG TPA: PknB [Siphoviridae sp. ctHip2] diamond 237 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
30733879 30733879 PRJNA1143173_P_NODE_27994_length_263_cov_5.915789_g27968_i0 PRJNA1143173 27994 263 5.915789 15.55852507 Microbacterium phage LeeroyJenkins 2593338 Viruses Viruses 46.6 0.00205   NR QDK01421.1 2593338 g27968 i0 50.8 0.695817490494297 61 27 67.3 2 17 193 452 511 QDK01421.1 portal protein [Microbacterium phage LeeroyJenkins] diamond 183 46.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage LeeroyJenkins
30860330 30860330 PRJNA1143173_P_NODE_30274_length_257_cov_3.179348_g30248_i0 PRJNA1143173 30274 257 3.179348 8.17092436 Caudoviricetes sp. 2832643 Viruses Viruses 58.9 2.9e-8   NR XOR51483.1 2832643 g30248 i0 41.9 0.863813229571984 74 42 86.4 1 3 224 119 191 XOR51483.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 222 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30944244 30944244 PRJNA1143173_P_NODE_10894_length_310_cov_3.544304_g10868_i0 PRJNA1143173 10894 310 3.544304 10.9873424 root 1 Root_unresolved Root_unresolved 60.1 3.32e-8   NR YP_010050741.1 2601610 g10868 i0 54.2 0.938709677419355 48 22 46.5 0 8 151 113 160 YP_010050741.1 hypothetical protein KDJ11_gp40 [Mycobacterium phage Weirdo19] diamond 291 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Rosariovirus Rosariovirus Weirdo19ES
31018339 31018339 PRJNA1143173_P_NODE_23055_length_278_cov_2.458537_g23029_i0 PRJNA1143173 23055 278 2.458537 6.83473286 Caudoviricetes sp. 2832643 Viruses Viruses 158 5.42e-44   NR XOR51531.1 2832643 g23029 i0 82.4 0.982014388489209 91 16 98.2 0 275 3 346 436 XOR51531.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 273 158 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31050188 31050188 PRJNA1143173_P_NODE_14855_length_299_cov_2.924779_g14829_i0 PRJNA1143173 14855 299 2.924779 8.74508921 Staphylococcus phage phiSA_BS2 2126724 Viruses Viruses 96.3 1.04e-20   NR YP_009799906.1 2126724 g14829 i0 58 0.882943143812709 88 24 76.3 3 230 3 1 87 YP_009799906.1 portal protein [Staphylococcus phage phiSA_BS2] diamond 264 96.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Baoshanvirus Baoshanvirus BS2
31207402 31207402 PRJNA1143173_P_NODE_29795_length_258_cov_5.416216_g29769_i0 PRJNA1143173 29795 258 5.416216 13.97383728 Mammaliicoccus phage vB_MscM-PMS3 2861056 Viruses Viruses 51.2 9.47e-6   NR QYC50880.1 2861056 g29769 i0 42.9 1.7906976744186 77 38 86 2 231 10 30 103 QYC50880.1 hypothetical protein [Mammaliicoccus phage vB_MscM-PMS3] diamond 462 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae   Mammaliicoccus phage vB_MscM-PMS3
31745456 31745456 PRJNA1143173_P_NODE_33297_length_248_cov_4.937143_g33271_i0 PRJNA1143173 33297 248 4.937143 12.24411464 Caudoviricetes sp. 2832643 Viruses Viruses 95.5 2.81e-23   NR XOR51533.1 2832643 g33271 i0 64.9 0.931451612903226 77 26 91.9 1 1 228 40 116 XOR51533.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 231 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31966856 31966856 PRJNA1143173_P_NODE_21878_length_281_cov_4.899038_g21852_i0 PRJNA1143173 21878 281 4.899038 13.76629678 Caudoviricetes sp. 2832643 Viruses Viruses 69.7 3.49e-12   NR DAQ10409.1 2832643 g21852 i0 48.5 0.725978647686833 68 35 72.6 0 221 18 2 69 DAQ10409.1 MAG TPA: ERF superfamily protein [Caudoviricetes sp.] diamond 204 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32188588 32188588 PRJNA1143173_P_NODE_44418_length_199_cov_4.706349_g44392_i0 PRJNA1143173 44418 199 4.706349 9.36563451 Caudoviricetes sp. 2832643 Viruses Viruses 64.7 6.72e-11   NR XOR51535.1 2832643 g44392 i0 49.2 0.979899497487437 65 31 98 1 197 3 20 82 XOR51535.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 195 64.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32346957 32346957 PRJNA1143173_P_NODE_23699_length_276_cov_2.827586_g23673_i0 PRJNA1143173 23699 276 2.827586 7.80413736 Caudoviricetes sp. 2832643 Viruses Viruses 120 1.84e-32   NR XOR51538.1 2832643 g23673 i0 62.9 0.967391304347826 89 32 96.7 1 8 274 1 88 XOR51538.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 267 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32630924 32630924 PRJNA1143173_P_NODE_28520_length_262_cov_2.634921_g28494_i0 PRJNA1143173 28520 262 2.634921 6.90349302 Caudoviricetes sp. 2832643 Viruses Viruses 47 0.00132   NR XOR51532.1 2832643 g28494 i0 52.9 0.583969465648855 51 22 58.4 2 1 153 214 262 XOR51532.1 MAG: putative protein metallo-phosphoesterase [Caudoviricetes sp.] diamond 153 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32630925 32630925 PRJNA1143173_P_NODE_30220_length_257_cov_4.059783_g30194_i0 PRJNA1143173 30220 257 4.059783 10.43364231 Acinetobacter phage AB2I2 3123117 Viruses Viruses 107 1.01e-27   NR XJP41281.1 3123117 g30194 i0 69.6 0.805447470817121 69 20 79.4 1 256 53 52 120 XJP41281.1 hypothetical protein [Acinetobacter phage AB2I2] diamond 207 107 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage AB2I2
32851498 32851498 PRJNA1143173_P_NODE_36960_length_237_cov_4.652439_g36934_i0 PRJNA1143173 36960 237 4.652439 11.02628043 Caudoviricetes sp. 2832643 Viruses Viruses 117 5.57e-29   NR XOS01464.1 2832643 g36934 i0 61.5 1.9620253164557 78 30 98.7 0 236 3 338 415 XOS01464.1 MAG: hypothetical protein MSP1228_17 [Caudoviricetes sp.] diamond 465 117 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);;