RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

37 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 37 ✖

bioproject 1

  • PRJNA438111 · 37 ✖

analysis 1

  • diamond · 37 ✖

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
1708780 1708780 PRJNA438111_P_NODE_20442_length_237_cov_5.634615_g19817_i0 PRJNA438111 20442 237 5.634615 13.35403755 Microbacterium phage Cece 2972516 Viruses Viruses 89.4 8.76e-19   NR UVG35173.1 2972516 g19817 i0 95.3 0.544303797468354 43 2 54.4 0 237 109 251 293 UVG35173.1 RtcB-like RNA ligase [Microbacterium phage Cece] diamond 129 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Cece
6811698 6811698 PRJNA438111_P_NODE_28506_length_210_cov_5.425414_g27881_i0 PRJNA438111 28506 210 5.425414 11.3933694 Limnohabitans phage YIMV22061 3390366 Viruses Viruses 101 5.72e-23   NR XLZ15554.1 3390366 g27881 i0 63.9 1.18571428571429 83 17 100 1 210 1 232 314 XLZ15554.1 terminase large subunit [Limnohabitans phage YIMV22061] diamond 249 101 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Autographiviridae   Limnohabitans phage YIMV22061
18285715 18285715 PRJNA438111_P_NODE_33415_length_209_cov_3.350000_g32790_i0 PRJNA438111 33415 209 3.35 7.0015 Caudoviricetes sp. 2832643 Viruses Viruses 56.6 1.68e-7   NR XOR75269.1 2832643 g32790 i0 48.3 0.832535885167464 58 23 73.2 1 153 1 54 111 XOR75269.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 174 56.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26632794 26632794 PRJNA438111_P_NODE_84881_length_154_cov_3.264000_g84256_i0 PRJNA438111 84881 154 3.264 5.02656 Caudoviricetes sp. 2832643 Viruses Viruses 100 2.0899999999999994e-23   NR DAK30344.1 2832643 g84256 i0 82.4 0.993506493506494 51 9 99.4 0 153 1 101 151 DAK30344.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 153 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26664151 26664151 PRJNA438111_P_NODE_68581_length_165_cov_3.919118_g67956_i0 PRJNA438111 68581 165 3.919118 6.4665447 Xanthomonas phage DES1 2894399 Viruses Viruses 99.8 5.449999999999999e-23   NR UFK09536.1 2894399 g67956 i0 90.7 0.981818181818182 54 5 98.2 0 3 164 139 192 UFK09536.1 putative ribonucleoside-diphosphate reductase subunit alpha [Xanthomonas phage DES1] diamond 162 99.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage DES1
26917771 26917771 PRJNA438111_P_NODE_63122_length_169_cov_2.557143_g62497_i0 PRJNA438111 63122 169 2.557143 4.32157167 Escherichia phage T2 2060721 Viruses Viruses 48.9 2.68e-5   NR YP_010073785.1 2060721 g62497 i0 46.8 0.834319526627219 47 24 83.4 1 169 29 20 65 YP_010073785.1 hypothetical protein KMC23_gp276 [Escherichia phage T2] diamond 141 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Tequatrovirus T2
27644856 27644856 PRJNA438111_P_NODE_75744_length_161_cov_1.727273_g75119_i0 PRJNA438111 75744 161 1.727273 2.78090953 Clandestinovirus 2831644 Viruses Viruses 60.8 2.39e-9   NR QYA18369.1 2831644 g75119 i0 56.5 0.857142857142857 46 19 83.9 1 27 161 140 185 QYA18369.1 bifunctional linker histone H1/H5 [Clandestinovirus] diamond 138 60.8 1 Viruses               Clandestinovirus
27708188 27708188 PRJNA438111_P_NODE_2704_length_591_cov_2.743772_g2244_i0 PRJNA438111 2704 591 2.743772 16.21569252 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 94 2.32e-18   NR YP_010840939.1 2951531 g2244 i0 41.4 0.736040609137056 145 80 71.6 3 6 428 24 167 YP_010840939.1 L protein [Hardyhead chuvirus] diamond 435 94 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
27802616 27802616 PRJNA438111_P_NODE_35304_length_204_cov_3.091429_g34679_i0 PRJNA438111 35304 204 3.091429 6.30651516 Acinetobacter phage Bestia 2801401 Viruses Viruses 82.4 2.87e-18   NR QVG64288.1 2801401 g34679 i0 54.4 1 68 31 100 0 204 1 11 78 QVG64288.1 putative endolysin [Acinetobacter phage Bestia] diamond 204 82.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage Bestia
27802630 27802630 PRJNA438111_P_NODE_54244_length_177_cov_2.824324_g53619_i0 PRJNA438111 54244 177 2.824324 4.99905348 Caudoviricetes sp. 2832643 Viruses Viruses 51.6 1.8e-6   NR XOR90598.1 2832643 g53619 i0 64.1 0.661016949152542 39 14 66.1 0 60 176 41 79 XOR90598.1 MAG: hypothetical protein MSP1590_1 [Caudoviricetes sp.] diamond 117 51.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27802646 27802646 PRJNA438111_P_NODE_71164_length_164_cov_1.051852_g70539_i0 PRJNA438111 71164 164 1.051852 1.72503728 Caudoviricetes sp. 2832643 Viruses Viruses 82.4 1.28e-16   NR XOR20508.1 2832643 g70539 i0 77.8 0.98780487804878 54 12 98.8 0 163 2 157 210 XOR20508.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 162 82.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28071337 28071337 PRJNA438111_P_NODE_62305_length_170_cov_1.007092_g61680_i0 PRJNA438111 62305 170 1.007092 1.7120564 Pumpernickelvirus 3152625 Viruses Viruses 83.6 5.63e-17   NR QIG57848.1 2704039 g61680 i0 63 5.71764705882353 54 20 95.3 0 7 168 132 185 QIG57848.1 DNA helicase [Microbacterium phage PauloDiaboli] diamond 972 84 0.995238095238095 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage PauloDiaboli
28497218 28497218 PRJNA438111_P_NODE_5147_length_435_cov_2.706897_g4578_i0 PRJNA438111 5147 435 2.706897 11.77500195 Klosneuvirus KNV1 1977640 Viruses Viruses 187 3.01e-54   NR ARF12356.1 1977640 g4578 i0 60.1 7.00689655172414 138 45 95.2 1 1 414 128 255 ARF12356.1 fructose-1,6-bisphosphatase [Klosneuvirus KNV1] diamond 3048 187 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
28560393 28560393 PRJNA438111_P_NODE_66907_length_166_cov_4.985401_g66282_i0 PRJNA438111 66907 166 4.985401 8.27576566 Xanthomonas phage DES1 2894399 Viruses Viruses 106 1.7e-25   NR UFK09591.1 2894399 g66282 i0 78.2 0.993975903614458 55 12 99.4 0 166 2 47 101 UFK09591.1 large terminase protein [Xanthomonas phage DES1] diamond 165 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage DES1
28623564 28623564 PRJNA438111_P_NODE_41267_length_192_cov_3.926380_g40642_i0 PRJNA438111 41267 192 3.92638 7.5386496 Clandestinovirus 2831644 Viruses Viruses 52.4 7.19e-6   NR QYA18491.1 2831644 g40642 i0 46.8 0.96875 62 30 96.9 2 191 6 69 127 QYA18491.1 deoxyguanosine kinase mitochondrial precursor [Clandestinovirus] diamond 186 52.4 1 Viruses               Clandestinovirus
28718250 28718250 PRJNA438111_P_NODE_82647_length_156_cov_2.118110_g82022_i0 PRJNA438111 82647 156 2.11811 3.3042516 Pseudomonas phage Touem 3138548 Viruses Viruses 57 1.08e-7   NR XAI70546.1 3138548 g82022 i0 56.4 5.03846153846154 55 21 100 1 156 1 124 178 XAI70546.1 DNA modification methylase [Pseudomonas phage Touem01] diamond 786 57 1 Viruses               Pseudomonas phage Touem01
28781123 28781123 PRJNA438111_P_NODE_5127_length_436_cov_2.486486_g4559_i0 PRJNA438111 5127 436 2.486486 10.84107896 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 99.4 5.65e-21   NR WLN26256.1 2951531 g4559 i0 42 1.65137614678899 119 69 81.9 0 421 65 97 215 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 720 99.4 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
29097094 29097094 PRJNA438111_P_NODE_11348_length_305_cov_3.989130_g10723_i0 PRJNA438111 11348 305 3.98913 12.1668465 Erysiphe necator associated abispo virus 1 2748675 Viruses Viruses 55.5 2.57e-6   NR QLC27600.1 2748675 g10723 i0 35.6 0.99344262295082 101 55 96.4 3 6 299 336 429 QLC27600.1 putative methyltransferase [Erysiphe necator associated abispo virus 1] diamond 303 55.5 1 Viruses               Erysiphe necator associated abispo virus 1
29254640 29254640 PRJNA438111_P_NODE_66229_length_167_cov_1.971014_g65604_i0 PRJNA438111 66229 167 1.971014 3.29159338 Caudoviricetes sp. 2832643 Viruses Viruses 82.8 1.01e-16   NR XOQ93052.1 2832643 g65604 i0 81.5 0.970059880239521 54 10 97 0 5 166 94 147 XOQ93052.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 162 82.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29349662 29349662 PRJNA438111_P_NODE_20729_length_236_cov_3.285024_g20104_i0 PRJNA438111 20729 236 3.285024 7.75265664 Yasminevirus sp. GU-2 3060817 Viruses Viruses 73.6 3.24e-13   NR VBB18342.1 2420051 g20104 i0 46.6 3.71186440677966 73 38 92.8 1 13 231 171 242 VBB18342.1 hypothetical protein YASMINEVIRUS_805 [Yasminevirus sp. GU-2018] diamond 876 73.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Yasminevirus Yasminevirus saudimassiliense
29791491 29791491 PRJNA438111_P_NODE_60211_length_171_cov_2.957746_g59586_i0 PRJNA438111 60211 171 2.957746 5.05774566 Caudoviricetes sp. 2832643 Viruses Viruses 110 2.68e-27   NR AXQ66443.1 2832643 g59586 i0 89.5 1 57 6 100 0 171 1 48 104 AXQ66443.1 MAG: major capsid protein E [Caudoviricetes sp.] diamond 171 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29918147 29918147 PRJNA438111_P_NODE_70871_length_164_cov_1.577778_g70246_i0 PRJNA438111 70871 164 1.577778 2.58755592 Orpheovirus IHUMI-LCC2 2023057 Viruses Viruses 95.9 2.3700000000000003e-21   NR YP_009448418.1 2023057 g70246 i0 74.1 0.98780487804878 54 14 98.8 0 2 163 129 182 YP_009448418.1 Arginyl-tRNA synthetase [Orpheovirus IHUMI-LCC2] diamond 162 95.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Orpheoviridae Alphaorpheovirus Alphaorpheovirus massiliense
30155198 30155198 PRJNA438111_P_NODE_84292_length_154_cov_6.792000_g83667_i0 PRJNA438111 84292 154 6.792 10.45968 Otagovirus 2560197 Viruses Viruses 48.9 4.94e-6   NR YP_010768111.1 1460363 g83667 i0 47.6 1.28571428571429 42 15 79.9 2 133 11 4 39 YP_010768111.1 hypothetical protein QGX21_gp072 [Pseudomonas phage phiPsa315] diamond 198 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Otagovirus Otagovirus psa315
30297613 30297613 PRJNA438111_P_NODE_3932_length_496_cov_5.447537_g3411_i0 PRJNA438111 3932 496 5.447537 27.01978352 Riboviria sp. 2585031 Viruses Viruses 207 3.6e-61   NR WWV90525.1 2585031 g3411 i0 62.4 0.997983870967742 165 61 99.2 1 4 495 372 536 WWV90525.1 MAG: RNA polymerase, partial [Riboviria sp.] diamond 495 207 1 Viruses               Riboviria sp.
30597664 30597664 PRJNA438111_P_NODE_9493_length_331_cov_2.122517_g8873_i0 PRJNA438111 9493 331 2.122517 7.02553127 Chuvivirus 2842604 Viruses Viruses 77.8 4.92e-14   NR WET19887.1 2842604 g8873 i0 73.1 0.942598187311178 52 14 47.1 0 176 331 305 356 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 312 77.8 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
30644525 30644525 PRJNA438111_P_NODE_4993_length_441_cov_5.849515_g4430_i0 PRJNA438111 4993 441 5.849515 25.79636115 Klosneuvirus KNV1 1977640 Viruses Viruses 79 6.68e-14   NR ARF12220.1 1977640 g4430 i0 30.7 0.952380952380952 140 93 94.6 3 424 8 255 391 ARF12220.1 hypothetical protein Klosneuvirus_4_35 [Klosneuvirus KNV1] diamond 420 79 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
30676078 30676078 PRJNA438111_P_NODE_46853_length_185_cov_3.525641_g46228_i0 PRJNA438111 46853 185 3.525641 6.52243585 Nucleocytoviricota sp. 2809609 Viruses Viruses 41.2 0.0309   NR UZT28927.1 2809609 g46228 i0 41.2 0.827027027027027 51 29 81.1 1 11 160 76 126 UZT28927.1 hypothetical protein [Nucleocytoviricota sp.] diamond 153 41.2 1 Viruses   Bamfordvirae Nucleocytoviricota         Nucleocytoviricota sp.
31040446 31040446 PRJNA438111_P_NODE_77735_length_159_cov_5.146154_g77110_i0 PRJNA438111 77735 159 5.146154 8.18238486 Kunmingvirus 2948791 Viruses Viruses 60.1 9.21e-9   NR YP_010052969.1 2588098 g77110 i0 60.8 1.92452830188679 51 18 92.5 1 13 159 67 117 YP_010052969.1 tail protein [Aeromonas phage 2_D05] diamond 306 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kunmingvirus Kunmingvirus kv2D05
31434678 31434678 PRJNA438111_P_NODE_11356_length_305_cov_3.608696_g10731_i0 PRJNA438111 11356 305 3.608696 11.0065228 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 65.1 1.14e-9   NR UVF58767.1 2951531 g10731 i0 43.6 2.31147540983607 78 43 75.7 1 231 1 1 78 UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] diamond 705 65.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
31845881 31845881 PRJNA438111_P_NODE_65017_length_168_cov_1.021583_g64392_i0 PRJNA438111 65017 168 1.021583 1.71625944 Liverwort associated bunyavirus 3 2933081 Viruses Viruses 66.2 6.83e-11   NR CAI5383925.1 2933081 g64392 i0 56.9 1.73214285714286 51 22 91.1 0 11 163 735 785 CAI5383925.1 RNA-dependent RNA polymerase [Liverwort associated bunyavirus 3] diamond 291 66.2 1 Viruses   Orthornavirae Negarnaviricota Ellioviricetes Bunyavirales     Liverwort associated bunyavirus 3
31957142 31957142 PRJNA438111_P_NODE_13197_length_286_cov_3.085603_g12572_i0 PRJNA438111 13197 286 3.085603 8.82482458 Klosneuvirus 1977639 Viruses Viruses 105 1.75e-25   NR ARF12304.1 1977640 g12572 i0 57.4 1.97202797202797 94 40 98.6 0 3 284 114 207 ARF12304.1 metal dependent phosphohydrolase [Klosneuvirus KNV1] diamond 564 105 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
32067311 32067311 PRJNA438111_P_NODE_11378_length_305_cov_2.641304_g10753_i0 PRJNA438111 11378 305 2.641304 8.0559772 Mimivirus LCMiAC 2506609 Viruses Viruses 63.2 4e-9   NR QBK89199.1 2506609 g10753 i0 35 0.983606557377049 100 62 96.4 2 4 297 155 253 QBK89199.1 MAG: endonuclease/exonuclease/phosphatase family protein [Mimivirus LCMiAC02] diamond 300 63.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Mimivirus LCMiAC02
32067369 32067369 PRJNA438111_P_NODE_76238_length_160_cov_8.175573_g75613_i0 PRJNA438111 76238 160 8.175573 13.0809168 Bacteriophage sp. 38018 Viruses Viruses 43.5 0.0066   NR DAE58860.1 38018 g75613 i0 44.2 1.93125 52 29 97.5 0 5 160 256 307 DAE58860.1 MAG TPA: Pectate lyase [Bacteriophage sp.] diamond 309 43.5 1 Viruses               Bacteriophage sp.
32447393 32447393 PRJNA438111_P_NODE_62559_length_169_cov_4.778571_g61934_i0 PRJNA438111 62559 169 4.778571 8.07578499 Caudoviricetes sp. 2832643 Viruses Viruses 58.9 2.66e-8   NR DAY14183.1 2832643 g61934 i0 48.2 0.994082840236686 56 29 99.4 0 1 168 270 325 DAY14183.1 MAG TPA: peptidoglycan-recognition protein [Caudoviricetes sp.] diamond 168 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32542301 32542301 PRJNA438111_P_NODE_45799_length_186_cov_5.331210_g45174_i0 PRJNA438111 45799 186 5.33121 9.9160506 Thermus phage Lalka27a 3289877 Viruses Viruses 115 2.84e-28   NR XKB89797.1 3289877 g45174 i0 88.7 1 62 7 100 0 1 186 465 526 XKB89797.1 AAA family ATPase [Thermus phage Lalka27a] diamond 186 115 1 Viruses               Thermus phage Lalka27a
32573938 32573938 PRJNA438111_P_NODE_3419_length_529_cov_7.076000_g2913_i0 PRJNA438111 3419 529 7.076 37.43204 Klosneuvirus KNV1 1977640 Viruses Viruses 100 4.19e-21   NR ARF12097.1 1977640 g2913 i0 35.7 0.969754253308129 171 96 90.2 4 3 479 596 764 ARF12097.1 hypothetical protein Klosneuvirus_3_232 [Klosneuvirus KNV1] diamond 513 100 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
32699502 32699502 PRJNA438111_P_NODE_43120_length_190_cov_1.701863_g42495_i0 PRJNA438111 43120 190 1.701863 3.2335397 Escherichia phage vB_EcoM_APEC 2759186 Viruses Viruses 57.8 9.3e-8   NR QMP81465.1 2759186 g42495 i0 44.2 0.821052631578947 52 29 82.1 0 34 189 433 484 QMP81465.1 tail fiber protein [Escherichia phage vB_EcoM_APEC] diamond 156 57.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage vB_EcoM_APEC

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