RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA454503 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
26601005 26601005 PRJNA454503_P_NODE_50641_length_215_cov_1.285714_g50312_i0 PRJNA454503 50641 215 1.285714 2.7642851 Caudoviricetes sp. 2832643 Viruses Viruses 68.2 9.14e-13   NR XOR34747.1 2832643 g50312 i0 47.8 0.962790697674419 69 35 96.3 1 7 213 26 93 XOR34747.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 207 68.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26632981 26632981 PRJNA454503_P_NODE_80241_length_203_cov_1.830986_g79912_i0 PRJNA454503 80241 203 1.830986 3.71690158 Caudoviricetes sp. 2832643 Viruses Viruses 52 6.57e-6   NR XOR09135.1 2832643 g79912 i0 62.5 0.591133004926108 40 15 59.1 0 125 6 1 40 XOR09135.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 120 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26854886 26854886 PRJNA454503_P_NODE_61421_length_209_cov_0.878378_g61092_i0 PRJNA454503 61421 209 0.878378 1.83581002 Klebsiella phage VLCpiS6a 2874891 Viruses Viruses 58.2 8.59e-8   NR UVX29654.1 2874891 g61092 i0 47.7 1.86602870813397 65 33 93.3 1 10 204 372 435 UVX29654.1 portal protein [Klebsiella phage VLCpiS6a] diamond 390 58.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage VLCpiS6a
27581597 27581597 PRJNA454503_P_NODE_49124_length_216_cov_2.122581_g48795_i0 PRJNA454503 49124 216 2.122581 4.58477496 Caudoviricetes sp. 2832643 Viruses Viruses 50.1 6.71e-5   NR DAV36718.1 2832643 g48795 i0 44.1 0.944444444444444 68 34 94.4 2 11 214 316 379 DAV36718.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 204 50.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28749912 28749912 PRJNA454503_P_NODE_52067_length_213_cov_1.710526_g51738_i0 PRJNA454503 52067 213 1.710526 3.64342038 Staphylococcus phage vB_SepM_BE 2944247 Viruses Viruses 108 5.03e-26   NR QLF86898.1 2750276 g51738 i0 75.7 0.985915492957746 70 17 98.6 0 212 3 40 109 QLF86898.1 transposase subunit [Staphylococcus phage vB_SepM_BE04] diamond 210 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Sepunavirus Staphylococcus phage vB_SepM_BE04
28876146 28876146 PRJNA454503_P_NODE_32488_length_236_cov_1.485714_g32159_i0 PRJNA454503 32488 236 1.485714 3.50628504 Caudoviricetes sp. 2832643 Viruses Viruses 128 3.05e-32   NR XOR52210.1 2832643 g32159 i0 80.8 0.991525423728814 78 15 99.2 0 1 234 551 628 XOR52210.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 234 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29223688 29223688 PRJNA454503_P_NODE_29669_length_240_cov_1.201117_g29340_i0 PRJNA454503 29669 240 1.201117 2.8826808 uncultured Caudovirales phage 2100421 Viruses Viruses 118 7.05e-29   NR CAB4172138.1 2100421 g29340 i0 82.4 1.7 68 12 85 0 208 5 1 68 CAB4172138.1 Phage P22-like portal protein [uncultured Caudovirales phage] diamond 408 118 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29271083 29271083 PRJNA454503_P_NODE_7109_length_422_cov_2.016620_g6780_i0 PRJNA454503 7109 422 2.01662 8.5101364 root 1 Root_unresolved Root_unresolved 72.4 3.05e-13   NR DAQ55630.1 2832643 g6780 i0 79.5 0.554502369668246 39 8 27.7 0 302 418 48 86 DAQ55630.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 234 72.8 0.994505494505495 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29318146 29318146 PRJNA454503_P_NODE_62069_length_209_cov_0.878378_g61740_i0 PRJNA454503 62069 209 0.878378 1.83581002 Vibrio phage Va1 2508852 Viruses Viruses 47.4 3.86e-4   NR QAU04534.1 2508852 g61740 i0 48.5 0.947368421052632 66 29 89 3 208 23 137 201 QAU04534.1 hypothetical protein Va1_239 [Vibrio phage Va1] diamond 198 47.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage Va1
29460412 29460412 PRJNA454503_P_NODE_36170_length_231_cov_2.011765_g35841_i0 PRJNA454503 36170 231 2.011765 4.64717715 Vandenendeviridae 3424680 Viruses Viruses 119 2.1000000000000002e-30   NR QNR53916.1 2759194 g35841 i0 74 2.97402597402597 77 20 100 0 231 1 180 256 QNR53916.1 ribonucleotide-diphosphate reductase subunit beta [Pseudomonas phage phiK7A1] diamond 687 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Torinovirus Torinovirus K7A1
29507604 29507604 PRJNA454503_P_NODE_68650_length_207_cov_0.890411_g68321_i0 PRJNA454503 68650 207 0.890411 1.84315077 Burkholderia phage FLC9 2906467 Viruses Viruses 51.2 2.15e-5   NR BDD79855.1 2906467 g68321 i0 37.3 0.855072463768116 59 36 85.5 1 190 14 175 232 BDD79855.1 hypothetical protein [Burkholderia phage FLC9] diamond 177 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30138948 30138948 PRJNA454503_P_NODE_63132_length_208_cov_2.931973_g62803_i0 PRJNA454503 63132 208 2.931973 6.09850384 Pseudomonas phage vB_PsaM_M1 2995601 Viruses Viruses 90.5 9.58e-20   NR UZS00975.1 2995601 g62803 i0 63.6 0.951923076923077 66 24 95.2 0 206 9 75 140 UZS00975.1 exonuclease [Pseudomonas phage vB_PsaM_M1] diamond 198 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Andersonviridae   Pseudomonas phage vB_PaeM_M1
30234118 30234118 PRJNA454503_P_NODE_38672_length_228_cov_1.892216_g38343_i0 PRJNA454503 38672 228 1.892216 4.31425248 Caudoviricetes sp. 2832643 Viruses Viruses 92.4 1.8300000000000003e-21   NR XOS47120.1 2832643 g38343 i0 81.5 0.710526315789474 54 10 71.1 0 164 3 1 54 XOS47120.1 MAG: hypothetical protein MSP0423_110 [Caudoviricetes sp.] diamond 162 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30960935 30960935 PRJNA454503_P_NODE_76674_length_204_cov_1.818182_g76345_i0 PRJNA454503 76674 204 1.818182 3.70909128 Streptomyces phage Tomas 2914443 Viruses Viruses 47 6.86e-4   NR YP_010651287.1 2914443 g76345 i0 40.6 4.04411764705882 69 36 95.6 4 202 8 164 231 YP_010651287.1 RNA ligase [Streptomyces phage Tomas] diamond 825 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Stanwilliamsviridae Tomasvirus Tomasvirus tomas
31687974 31687974 PRJNA454503_P_NODE_90777_length_165_cov_4.557692_g90448_i0 PRJNA454503 90777 165 4.557692 7.5201918 Caudoviricetes sp. 2832643 Viruses Viruses 93.2 2.0899999999999994e-23   NR XOS47160.1 2832643 g90448 i0 88.4 0.781818181818182 43 5 78.2 0 163 35 29 71 XOS47160.1 MAG: hypothetical protein MSP0423_150 [Caudoviricetes sp.] diamond 129 93.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31814540 31814540 PRJNA454503_P_NODE_49397_length_216_cov_1.677419_g49068_i0 PRJNA454503 49397 216 1.677419 3.62322504 uncultured Caudovirales phage 2100421 Viruses Viruses 106 8.67e-25   NR CAB4143065.1 2100421 g49068 i0 67.6 0.986111111111111 71 22 97.2 1 7 216 223 293 CAB4143065.1 Methyltransferase FkbM [uncultured Caudovirales phage] diamond 213 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31940914 31940914 PRJNA454503_P_NODE_45157_length_221_cov_1.312500_g44828_i0 PRJNA454503 45157 221 1.3125 2.900625 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.011   NR DAM78134.1 2832643 g44828 i0 45.1 3.06787330316742 51 23 66.5 2 159 13 366 413 DAM78134.1 MAG TPA: endonuclease-like protein [Caudoviricetes sp.] diamond 678 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32099251 32099251 PRJNA454503_P_NODE_37598_length_230_cov_1.065089_g37269_i0 PRJNA454503 37598 230 1.065089 2.4497047 Caudoviricetes sp. 2832643 Viruses Viruses 69.7 1.39e-13   NR DAE95385.1 2832643 g37269 i0 76.7 1.16086956521739 43 10 56.1 0 102 230 3 45 DAE95385.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 267 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32352699 32352699 PRJNA454503_P_NODE_63159_length_208_cov_2.653061_g62830_i0 PRJNA454503 63159 208 2.653061 5.51836688 Caudoviricetes sp. 2832643 Viruses Viruses 125 6.649999999999998e-35   NR XOS29813.1 2832643 g62830 i0 92.8 0.995192307692308 69 5 99.5 0 208 2 41 109 XOS29813.1 MAG: hypothetical protein MSP0831_24 [Caudoviricetes sp.] diamond 207 125 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);;