RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA605033 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
27048474 27048474 PRJNA605033_P_NODE_135382_length_210_cov_1.371429_g133813_i0 PRJNA605033 135382 210 1.371429 2.8800009 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 73.6 6.49e-14   NR DAF42957.1 2827830 g133813 i0 50.8 0.842857142857143 59 29 84.3 0 33 209 117 175 DAF42957.1 MAG TPA: hypothetical protein [Siphoviridae sp. ctHip2] diamond 177 73.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
27269640 27269640 PRJNA605033_P_NODE_195363_length_168_cov_1.142857_g193794_i0 PRJNA605033 195363 168 1.142857 1.91999976 Caudoviricetes sp. 2832643 Viruses Viruses 45.4 1.58e-4   NR DAJ06941.1 2832643 g193794 i0 71.9 0.571428571428571 32 8 55.4 1 22 114 25 56 DAJ06941.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 96 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27427935 27427935 PRJNA605033_P_NODE_235843_length_153_cov_2.686441_g234274_i0 PRJNA605033 235843 153 2.686441 4.11025473 Caudoviricetes sp. 2832643 Viruses Viruses 70.5 1.75e-12   NR XOR07218.1 2832643 g234274 i0 69.6 0.901960784313726 46 13 88.2 1 137 3 6 51 XOR07218.1 MAG: RepA [Caudoviricetes sp.] diamond 138 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27996165 27996165 PRJNA605033_P_NODE_52725_length_235_cov_4.210000_g51157_i0 PRJNA605033 52725 235 4.21 9.8935 Arthrobacter phage Faja 2419957 Viruses Viruses 78.6 1.82e-15   NR YP_010656318.1 2419957 g51157 i0 42 1.51914893617021 119 26 97 2 234 7 127 245 YP_010656318.1 esterase [Arthrobacter phage Faja] diamond 357 78.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fajavirus Fajavirus faja
28122343 28122343 PRJNA605033_P_NODE_74265_length_222_cov_2.791444_g72696_i0 PRJNA605033 74265 222 2.791444 6.19700568 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.0152   NR XOR83186.1 2832643 g72696 i0 91.7 0.324324324324324 24 2 32.4 0 73 2 728 751 XOR83186.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] diamond 72 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28406597 28406597 PRJNA605033_P_NODE_50346_length_239_cov_1.960784_g48778_i0 PRJNA605033 50346 239 1.960784 4.68627376 Caudoviricetes sp. 2832643 Viruses Viruses 100 1.41e-25   NR DAL22883.1 2832643 g48778 i0 72 3.01255230125523 82 20 99.2 1 3 239 1 82 DAL22883.1 MAG TPA_asm: hypothetical protein, partial [Caudoviricetes sp.] diamond 720 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28501287 28501287 PRJNA605033_P_NODE_170107_length_180_cov_1.965517_g168538_i0 PRJNA605033 170107 180 1.965517 3.5379306 Lactobacillus phage LpeD 2041210 Viruses Viruses 79 4.04e-16   NR YP_009835303.1 2041210 g168538 i0 53.4 0.966666666666667 58 27 96.7 0 176 3 61 118 YP_009835303.1 hypothetical protein HWB32_gp011 [Lactobacillus phage LpeD] diamond 174 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Elpedvirus Elpedvirus LpeD
29038196 29038196 PRJNA605033_P_NODE_100508_length_222_cov_1.946524_g98939_i0 PRJNA605033 100508 222 1.946524 4.32128328 Caudoviricetes sp. 2832643 Viruses Viruses 47.4 6.59e-4   NR DAT01039.1 2832643 g98939 i0 91.7 0.324324324324324 24 2 32.4 0 149 220 569 592 DAT01039.1 MAG TPA: Tail fiber protein [Caudoviricetes sp.] diamond 72 47.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29069719 29069719 PRJNA605033_P_NODE_233928_length_154_cov_1.512605_g232359_i0 PRJNA605033 233928 154 1.512605 2.3294117 Caudoviricetes sp. 2832643 Viruses Viruses 62.8 3.01e-10   NR DAL36433.1 2832643 g232359 i0 72.7 0.857142857142857 44 12 85.7 0 23 154 1 44 DAL36433.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] diamond 132 62.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29258737 29258737 PRJNA605033_P_NODE_19529_length_326_cov_2.295533_g17970_i0 PRJNA605033 19529 326 2.295533 7.48343758 Caudoviricetes sp. 2832643 Viruses Viruses 47 0.00301   NR XOR20224.1 2832643 g17970 i0 25 0.957055214723926 104 72 95.7 1 313 2 152 249 XOR20224.1 MAG: putative phage protein [Caudoviricetes sp.] diamond 312 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29543061 29543061 PRJNA605033_P_NODE_197390_length_167_cov_1.378788_g195821_i0 PRJNA605033 197390 167 1.378788 2.30257596 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 44.3 0.00385   NR DAF42561.1 2827830 g195821 i0 38.8 0.880239520958084 49 30 88 0 159 13 186 234 DAF42561.1 MAG TPA: TrbL/VirB6 plasmid conjugal transfer protein [Siphoviridae sp. ctHip2] diamond 147 44.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
29669079 29669079 PRJNA605033_P_NODE_152090_length_192_cov_3.101911_g150521_i0 PRJNA605033 152090 192 3.101911 5.95566912 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 3.45e-11   NR DAX51862.1 2832643 g150521 i0 71.1 0.59375 38 11 59.4 0 127 14 14 51 DAX51862.1 MAG TPA: Single-strand binding protein BINDING FOLD, DNA-BINDING PROTEIN.5A [Caudoviricetes sp.] diamond 114 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29700680 29700680 PRJNA605033_P_NODE_58610_length_228_cov_2.373057_g57042_i0 PRJNA605033 58610 228 2.373057 5.41056996 Caudoviricetes sp. 2832643 Viruses Viruses 53.5 4.83e-6   NR DAN78129.1 2832643 g57042 i0 91.4 1.88157894736842 35 3 46.1 0 6 110 1201 1235 DAN78129.1 MAG TPA: tail tape measure [Caudoviricetes sp.] diamond 429 53.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29713841 29713841 PRJNA605033_P_NODE_72190_length_222_cov_2.935829_g70621_i0 PRJNA605033 72190 222 2.935829 6.51754038 Chimalliviridae 3152113 Viruses Viruses 44.3 0.00797   NR YP_009217218.1 998086 g70621 i0 83.3 3.45945945945946 24 4 32.4 0 74 3 139 162 YP_009217218.1 polymerase [Pseudomonas phage PhiPA3] diamond 768 44.7 0.991051454138702 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Miltoncavirus Miltoncavirus PhiPA3
30396467 30396467 PRJNA605033_P_NODE_242333_length_151_cov_3.534483_g240764_i0 PRJNA605033 242333 151 3.534483 5.33706933 Streptomyces phage KimJongPhill 2848886 Viruses Viruses 63.2 6.64e-10   NR YP_010655686.1 2848886 g240764 i0 60 0.993377483443709 50 20 99.3 0 1 150 309 358 YP_010655686.1 DNA polymerase I [Streptomyces phage KimJongPhill] diamond 150 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Zukovirus Zukovirus phill
31217137 31217137 PRJNA605033_P_NODE_96375_length_222_cov_2.032086_g94806_i0 PRJNA605033 96375 222 2.032086 4.51123092 Caudoviricetes sp. 2832643 Viruses Viruses 63.2 1.77e-9   NR DAX78865.1 2832643 g94806 i0 50.7 1.97297297297297 73 12 98.6 1 3 221 733 781 DAX78865.1 MAG TPA: STRUCTURAL MAINTENANCE OF CHROMOSOMES PROTEIN [Caudoviricetes sp.] diamond 438 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31534000 31534000 PRJNA605033_P_NODE_188116_length_171_cov_1.529412_g186547_i0 PRJNA605033 188116 171 1.529412 2.61529452 Mycobacterium phage JacoRen57 2499043 Viruses Viruses 100 5.5e-24   NR AZS06581.1 2499043 g186547 i0 80 1.92982456140351 55 11 96.5 0 2 166 148 202 AZS06581.1 tail assembly chaperone [Mycobacterium phage JacoRen57] diamond 330 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Mapvirus Mycobacterium phage JacoRen57
32230010 32230010 PRJNA605033_P_NODE_237338_length_153_cov_1.440678_g235769_i0 PRJNA605033 237338 153 1.440678 2.20423734 Caudoviricetes sp. 2832643 Viruses Viruses 48.1 9.64e-5   NR DAL36433.1 2832643 g235769 i0 59.5 0.725490196078431 37 15 72.5 0 4 114 99 135 DAL36433.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] diamond 111 48.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32356647 32356647 PRJNA605033_P_NODE_67119_length_222_cov_3.508021_g65550_i0 PRJNA605033 67119 222 3.508021 7.78780662 Caudoviricetes sp. 2832643 Viruses Viruses 44.7 0.00587   NR XOR20515.1 2832643 g65550 i0 70.8 0.324324324324324 24 7 32.4 0 150 221 93 116 XOR20515.1 MAG: putative DNA-directed RNA polymerase beta subunit [Caudoviricetes sp.] diamond 72 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32514856 32514856 PRJNA605033_P_NODE_29339_length_280_cov_1.987755_g27773_i0 PRJNA605033 29339 280 1.987755 5.565714 Caudoviricetes sp. 2832643 Viruses Viruses 164 5.699999999999999e-47   NR DAX91803.1 2832643 g27773 i0 79.6 0.996428571428571 93 19 99.6 0 280 2 47 139 DAX91803.1 MAG TPA: portal protein [Caudoviricetes sp.] diamond 279 164 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32672101 32672101 PRJNA605033_P_NODE_118240_length_222_cov_1.620321_g116671_i0 PRJNA605033 118240 222 1.620321 3.59711262 Caudoviricetes sp. 2832643 Viruses Viruses 46.6 0.00123   NR XOR69112.1 2832643 g116671 i0 90.9 0.621621621621622 22 2 29.7 0 2 67 698 719 XOR69112.1 MAG: hypothetical protein, partial [Caudoviricetes sp.] diamond 138 46.6 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);;