RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA438111 · 17 ✖

analysis 1

  • diamond · 17 ✖

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