RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

36 rows where analysis = "diamond", bioproject = "PRJNA851399" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 36 ✖

tax_kingdom 1

bioproject 1

  • PRJNA851399 · 36 ✖

analysis 1

  • diamond · 36 ✖

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
26801719 26801719 PRJNA851399_P_NODE_22081_length_173_cov_1.129032_g21628_i0 PRJNA851399 22081 173 1.129032 1.95322536 Caudoviricetes sp. 2832643 Viruses Viruses 110 7.650000000000001e-27   NR XOR69060.1 2832643 g21628 i0 86 1.97687861271676 57 8 98.8 0 3 173 295 351 XOR69060.1 MAG: terminase large subunit [Caudoviricetes sp.] diamond 342 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27181222 27181222 PRJNA851399_P_NODE_11722_length_224_cov_1.982857_g11269_i0 PRJNA851399 11722 224 1.982857 4.44159968 Caudoviricetes sp. 2832643 Viruses Viruses 86.3 7.85e-19   NR XOS57101.1 2832643 g11269 i0 52.8 0.964285714285714 72 31 96.4 1 222 7 10 78 XOS57101.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] diamond 216 86.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27497448 27497448 PRJNA851399_P_NODE_20723_length_176_cov_1.330709_g20270_i0 PRJNA851399 20723 176 1.330709 2.34204784 Corynebacterium phage Darwin 2047869 Viruses Viruses 91.3 2.88e-21   NR YP_009620322.1 2047869 g20270 i0 70.7 5.93181818181818 58 17 98.9 0 176 3 63 120 YP_009620322.1 HNH endonuclease [Corynebacterium phage Darwin] diamond 1044 91.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Zierdtviridae Ceetrepovirus Ceetrepovirus darwin
27718824 27718824 PRJNA851399_P_NODE_14764_length_196_cov_1.040816_g14311_i0 PRJNA851399 14764 196 1.040816 2.03999936 Caudoviricetes sp. 2832643 Viruses Viruses 95.9 3.7400000000000005e-21   NR XOS29806.1 2832643 g14311 i0 74.5 0.841836734693878 55 14 84.2 0 3 167 1005 1059 XOS29806.1 MAG: putative glycosyl hydrolase family 16 laminarinase [Caudoviricetes sp.] diamond 165 95.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27970928 27970928 PRJNA851399_P_NODE_39865_length_161_cov_0.910714_g39412_i0 PRJNA851399 39865 161 0.910714 1.46624954 Aurantimonas phage AmM-1 1503929 Viruses Viruses 63.2 7.08e-10   NR YP_009146964.1 1503929 g39412 i0 62.7 0.950310559006211 51 19 95 0 161 9 186 236 YP_009146964.1 tail protein [Aurantimonas phage AmM-1] diamond 153 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aurantimonas phage AmM-1
28065704 28065704 PRJNA851399_P_NODE_7805_length_308_cov_1.938224_g7352_i0 PRJNA851399 7805 308 1.938224 5.96972992 Caudoviricetes sp. 2832643 Viruses Viruses 107 1.5899999999999999e-24   NR XOR37212.1 2832643 g7352 i0 52.9 1.01298701298701 104 46 99.4 2 2 307 623 725 XOR37212.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 312 107 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28231530 28231530 PRJNA851399_P_NODE_9986_length_250_cov_2.661692_g9533_i0 PRJNA851399 9986 250 2.661692 6.65423 root 1 Root_unresolved Root_unresolved 124 5.829999999999999e-31   NR XOS04997.1 2832643 g9533 i0 76.8 1.968 82 19 98.4 0 3 248 436 517 XOS04997.1 MAG: p005a protein, partial [Caudoviricetes sp.] diamond 492 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28286497 28286497 PRJNA851399_P_NODE_8666_length_280_cov_1.376623_g8213_i0 PRJNA851399 8666 280 1.376623 3.8545444 Caudoviricetes sp. 2832643 Viruses Viruses 124 5.73e-32   NR XOQ97232.1 2832643 g8213 i0 92.5 1.43571428571429 67 5 71.8 0 80 280 70 136 XOQ97232.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 402 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28318273 28318273 PRJNA851399_P_NODE_9826_length_253_cov_2.142157_g9373_i0 PRJNA851399 9826 253 2.142157 5.41965721 Caudoviricetes sp. 2832643 Viruses Viruses 116 2.05e-31   NR XOR83204.1 2832643 g9373 i0 79.4 0.806324110671937 68 14 80.6 0 49 252 1 68 XOR83204.1 MAG: terminase small subunit [Caudoviricetes sp.] diamond 204 116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28634268 28634268 PRJNA851399_P_NODE_26087_length_167_cov_0.864407_g25634_i0 PRJNA851399 26087 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 97.1 9.3e-22   NR XOR83203.1 2832643 g25634 i0 81.8 0.988023952095808 55 10 98.8 0 167 3 267 321 XOR83203.1 MAG: terminase large subunit [Caudoviricetes sp.] diamond 165 97.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28823207 28823207 PRJNA851399_P_NODE_6588_length_361_cov_2.298077_g6136_i0 PRJNA851399 6588 361 2.298077 8.29605797 Caudoviricetes sp. 2832643 Viruses Viruses 89.7 3.54e-19   NR XOS39632.1 2832643 g6136 i0 80.4 0.42382271468144 51 10 42.4 0 2 154 183 233 XOS39632.1 MAG: hypothetical protein MSP1057_12 [Caudoviricetes sp.] diamond 153 89.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28854875 28854875 PRJNA851399_P_NODE_27908_length_166_cov_0.871795_g27455_i0 PRJNA851399 27908 166 0.871795 1.4471797 Caudoviricetes sp. 2832643 Viruses Viruses 44.3 4.45e-4   NR XOS40823.1 2832643 g27455 i0 63.6 0.596385542168675 33 12 59.6 0 100 2 1 33 XOS40823.1 MAG: hypothetical protein MSP1018_73 [Caudoviricetes sp.] diamond 99 44.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29139510 29139510 PRJNA851399_P_NODE_11869_length_223_cov_0.879310_g11416_i0 PRJNA851399 11869 223 0.87931 1.9608613 Caudoviricetes sp. 2832643 Viruses Viruses 127 5.789999999999999e-35   NR XOR32393.1 2832643 g11416 i0 74 1.96412556053812 73 19 98.2 0 221 3 82 154 XOR32393.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] diamond 438 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29139514 29139514 PRJNA851399_P_NODE_28449_length_166_cov_0.871795_g27996_i0 PRJNA851399 28449 166 0.871795 1.4471797 Caudoviricetes sp. 2832643 Viruses Viruses 81.6 5.17e-18   NR XOQ95934.1 2832643 g27996 i0 72.5 0.921686746987952 51 14 92.2 0 13 165 1 51 XOQ95934.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 153 81.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29202488 29202488 PRJNA851399_P_NODE_20289_length_177_cov_1.375000_g19836_i0 PRJNA851399 20289 177 1.375 2.43375 Caudoviricetes sp. 2832643 Viruses Viruses 90.9 1.23e-19   NR XOS39637.1 2832643 g19836 i0 68.4 2.89830508474576 57 18 96.6 0 1 171 29 85 XOS39637.1 MAG: hypothetical protein MSP1057_17 [Caudoviricetes sp.] diamond 513 90.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29328616 29328616 PRJNA851399_P_NODE_8769_length_277_cov_1.171053_g8316_i0 PRJNA851399 8769 277 1.171053 3.24381681 Caudoviricetes sp. 2832643 Viruses Viruses 147 4.639999999999999e-43   NR XOR99839.1 2832643 g8316 i0 84.1 0.888086642599278 82 13 88.8 0 3 248 68 149 XOR99839.1 MAG: DNA recombination protein [Caudoviricetes sp.] diamond 246 147 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29802198 29802198 PRJNA851399_P_NODE_39151_length_161_cov_2.732143_g38698_i0 PRJNA851399 39151 161 2.732143 4.39875023 Caudoviricetes sp. 2832643 Viruses Viruses 64.3 2.79e-10   NR XOS63400.1 2832643 g38698 i0 48.1 0.968944099378882 52 27 96.9 0 2 157 72 123 XOS63400.1 MAG: hypothetical protein MSP0629_32 [Caudoviricetes sp.] diamond 156 64.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29928796 29928796 PRJNA851399_P_NODE_13171_length_209_cov_0.931250_g12718_i0 PRJNA851399 13171 209 0.93125 1.9463125 Caudoviricetes sp. 2832643 Viruses Viruses 130 6.15e-34   NR XOR78559.1 2832643 g12718 i0 84.1 0.990430622009569 69 11 99 0 2 208 110 178 XOR78559.1 MAG: conserved phage structural protein [Caudoviricetes sp.] diamond 207 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29960186 29960186 PRJNA851399_P_NODE_20791_length_176_cov_1.196850_g20338_i0 PRJNA851399 20791 176 1.19685 2.106456 Caudoviricetes sp. 2832643 Viruses Viruses 97.4 8.270000000000001e-22   NR XOR90815.1 2832643 g20338 i0 76.8 0.954545454545455 56 13 95.5 0 174 7 317 372 XOR90815.1 MAG: tail protein [Caudoviricetes sp.] diamond 168 97.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30054808 30054808 PRJNA851399_P_NODE_19771_length_178_cov_1.581395_g19318_i0 PRJNA851399 19771 178 1.581395 2.8148831 Caudoviricetes sp. 2832643 Viruses Viruses 125 4.98e-34   NR XOS31883.1 2832643 g19318 i0 88.1 0.99438202247191 59 7 99.4 0 178 2 169 227 XOS31883.1 MAG: hypothetical protein MSP0777_35 [Caudoviricetes sp.] diamond 177 125 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30339874 30339874 PRJNA851399_P_NODE_5452_length_422_cov_1.493298_g5000_i0 PRJNA851399 5452 422 1.493298 6.30171756 Caudoviricetes sp. 2832643 Viruses Viruses 225 3.7999999999999996e-73   NR XOR83196.1 2832643 g5000 i0 76.4 0.995260663507109 140 31 99.5 1 2 421 3 140 XOR83196.1 MAG: p008 protein [Caudoviricetes sp.] diamond 420 225 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30655190 30655190 PRJNA851399_P_NODE_23733_length_169_cov_1.700000_g23280_i0 PRJNA851399 23733 169 1.7 2.873 Caudoviricetes sp. 2832643 Viruses Viruses 57.4 7.83e-8   NR DAS64484.1 2832643 g23280 i0 54.5 0.781065088757396 44 20 78.1 0 27 158 2 45 DAS64484.1 MAG TPA: AccD protein [Caudoviricetes sp.] diamond 132 57.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30718395 30718395 PRJNA851399_P_NODE_8754_length_277_cov_2.447368_g8301_i0 PRJNA851399 8754 277 2.447368 6.77920936 Caudoviricetes sp. 2832643 Viruses Viruses 129 3.02e-35   NR XOR32393.1 2832643 g8301 i0 59.3 0.985559566787004 91 37 98.6 0 275 3 62 152 XOR32393.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] diamond 273 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30813234 30813234 PRJNA851399_P_NODE_11094_length_232_cov_1.464481_g10641_i0 PRJNA851399 11094 232 1.464481 3.39759592 Caudoviricetes sp. 2832643 Viruses Viruses 63.5 2.28e-10   NR UOF80303.1 2832643 g10641 i0 60.5 0.556034482758621 43 17 55.6 0 101 229 2 44 UOF80303.1 dctp deaminase dutpase [Caudoviricetes sp.] diamond 129 63.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31002928 31002928 PRJNA851399_P_NODE_24334_length_168_cov_1.714286_g23881_i0 PRJNA851399 24334 168 1.714286 2.88000048 Caudoviricetes sp. 2832643 Viruses Viruses 84.7 2.12e-17   NR XOR83201.1 2832643 g23881 i0 76.5 0.910714285714286 51 12 91.1 0 12 164 118 168 XOR83201.1 MAG: p005a protein [Caudoviricetes sp.] diamond 153 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31445457 31445457 PRJNA851399_P_NODE_8056_length_298_cov_2.879518_g7603_i0 PRJNA851399 8056 298 2.879518 8.58096364 Caudoviricetes sp. 2832643 Viruses Viruses 131 4.399999999999999e-33   NR XOR78579.1 2832643 g7603 i0 66.7 0.996644295302013 99 33 99.7 0 297 1 814 912 XOR78579.1 MAG: p036 protein [Caudoviricetes sp.] diamond 297 131 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31761716 31761716 PRJNA851399_P_NODE_20297_length_177_cov_1.328125_g19844_i0 PRJNA851399 20297 177 1.328125 2.35078125 Acinetobacter phage Phab24 2855484 Viruses Viruses 94.7 2.5600000000000003e-21   NR QXM18463.1 2855484 g19844 i0 75.4 0.966101694915254 57 14 96.6 0 6 176 262 318 QXM18463.1 major capsid protein [Acinetobacter phage Phab24] diamond 171 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage Phab24
31951494 31951494 PRJNA851399_P_NODE_22717_length_171_cov_1.672131_g22264_i0 PRJNA851399 22717 171 1.672131 2.85934401 Caudoviricetes sp. 2832643 Viruses Viruses 52.4 2.79e-6   NR XOS31732.1 2832643 g22264 i0 37.3 0.894736842105263 51 32 89.5 0 10 162 18 68 XOS31732.1 MAG: hypothetical protein MSP0776_26 [Caudoviricetes sp.] diamond 153 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32078099 32078099 PRJNA851399_P_NODE_21798_length_173_cov_1.645161_g21345_i0 PRJNA851399 21798 173 1.645161 2.84612853 Caudoviricetes sp. 2832643 Viruses Viruses 74.3 1.05e-13   NR XOR94869.1 2832643 g21345 i0 81 0.728323699421965 42 6 72.8 1 173 48 452 491 XOR94869.1 MAG: tail protein [Caudoviricetes sp.] diamond 126 74.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32078100 32078100 PRJNA851399_P_NODE_25558_length_167_cov_0.864407_g25105_i0 PRJNA851399 25558 167 0.864407 1.44355969 Microcystis phage Mwe-JY13 3128147 Viruses Viruses 45.1 0.00205   NR XAI95156.1 3128147 g25105 i0 46.3 1.38323353293413 41 22 73.7 0 26 148 328 368 XAI95156.1 DNA primase [Microcystis phage Mwe-JY13] diamond 231 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microcystis phage Mwe-JY13
32236688 32236688 PRJNA851399_P_NODE_16418_length_188_cov_0.978417_g15965_i0 PRJNA851399 16418 188 0.978417 1.83942396 Caudoviricetes sp. 2832643 Viruses Viruses 54.3 1.03e-6   NR XOR36738.1 2832643 g15965 i0 58.5 0.654255319148936 41 17 65.4 0 138 16 1 41 XOR36738.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 123 54.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32268131 32268131 PRJNA851399_P_NODE_12318_length_218_cov_0.875740_g11865_i0 PRJNA851399 12318 218 0.87574 1.9091132 Caudoviricetes sp. 2832643 Viruses Viruses 44.7 0.00245   NR XOS40641.1 2832643 g11865 i0 39.3 0.770642201834862 56 34 77.1 0 217 50 33 88 XOS40641.1 MAG: hypothetical protein MSP1023_2 [Caudoviricetes sp.] diamond 168 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32331629 32331629 PRJNA851399_P_NODE_20719_length_176_cov_1.330709_g20266_i0 PRJNA851399 20719 176 1.330709 2.34204784 Caudoviricetes sp. 2832643 Viruses Viruses 98.6 1.5e-25   NR XOR39481.1 2832643 g20266 i0 70.2 0.971590909090909 57 17 97.2 0 176 6 4 60 XOR39481.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 171 98.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32466268 32466268 PRJNA851399_P_NODE_18179_length_182_cov_1.601504_g17726_i0 PRJNA851399 18179 182 1.601504 2.91473728 root 1 Root_unresolved Root_unresolved 95.9 9.24e-24   NR XOR88982.1 2832643 g17726 i0 68.3 2.96703296703297 60 19 98.9 0 181 2 31 90 XOR88982.1 MAG: single-stranded binding protein [Caudoviricetes sp.] diamond 540 96.3 0.995846313603323 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32489630 32489630 PRJNA851399_P_NODE_14759_length_196_cov_1.054422_g14306_i0 PRJNA851399 14759 196 1.054422 2.06666712 Caudoviricetes sp. 2832643 Viruses Viruses 129 2.13e-33   NR XOS01709.1 2832643 g14306 i0 85.9 0.979591836734694 64 9 98 0 194 3 271 334 XOS01709.1 MAG: endolysin [Caudoviricetes sp.] diamond 192 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32804610 32804610 PRJNA851399_P_NODE_32300_length_164_cov_0.904348_g31847_i0 PRJNA851399 32300 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 4.24e-10   NR XOR99870.1 2832643 g31847 i0 59.6 1.90243902439024 52 17 87.8 1 148 5 135 186 XOR99870.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] diamond 312 63.9 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);;