RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1022392" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022392 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
3988501 3988501 PRJNA1022392_P_NODE_22884_length_221_cov_1.620690_g22215_i0 PRJNA1022392 22884 221 1.62069 3.5817249 Kenoshavirus 2842796 Viruses Viruses 137 4.23e-36   NR QKY79409.1 2743913 g22215 i0 84.9 3.96380090497738 73 11 99.1 0 221 3 9 81 QKY79409.1 terminase [Gordonia phage Jodelie19] diamond 876 138 0.992753623188406 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kenoshavirus Gordonia phage Jodelie19
26877072 26877072 PRJNA1022392_P_NODE_76521_length_160_cov_0.902655_g75852_i0 PRJNA1022392 76521 160 0.902655 1.444248 Stenotrophomonas phage RAS14 2996120 Viruses Viruses 48.9 1.03e-5   NR WAX21432.1 2996120 g75852 i0 75 0.6 32 8 60 0 158 63 61 92 WAX21432.1 hypothetical protein [Stenotrophomonas phage RAS14] diamond 96 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage RAS14
27098164 27098164 PRJNA1022392_P_NODE_66682_length_169_cov_1.106557_g66013_i0 PRJNA1022392 66682 169 1.106557 1.87008133 Caudoviricetes sp. 2832643 Viruses Viruses 49.7 8.3e-6   NR XOR83172.1 2832643 g66013 i0 74.2 0.550295857988166 31 8 55 0 167 75 78 108 XOR83172.1 MAG: hypothetical protein MSP1863_30 [Caudoviricetes sp.] diamond 93 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27161121 27161121 PRJNA1022392_P_NODE_49202_length_191_cov_3.284722_g48533_i0 PRJNA1022392 49202 191 3.284722 6.27381902 uncultured Caudovirales phage 2100421 Viruses Viruses 59.3 2.66e-8   NR CAB4167582.1 2100421 g48533 i0 59.6 0.816753926701571 52 18 80.1 2 38 190 167 216 CAB4167582.1 SPRY domain containing protein [uncultured Caudovirales phage] diamond 156 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27224458 27224458 PRJNA1022392_P_NODE_66683_length_169_cov_1.098361_g66014_i0 PRJNA1022392 66683 169 1.098361 1.85623009 Arthrobacter phage Truckee 2790984 Viruses Viruses 74.7 7.36e-14   NR QPX62477.1 2790984 g66014 i0 64.8 0.958579881656805 54 19 95.9 0 1 162 654 707 QPX62477.1 major capsid and protease fusion protein [Arthrobacter phage Truckee] diamond 162 74.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Gordonvirus Arthrobacter phage Truckee
27382764 27382764 PRJNA1022392_P_NODE_55563_length_183_cov_1.698529_g54894_i0 PRJNA1022392 55563 183 1.698529 3.10830807 Arthrobacter phage Sporto 2599835 Viruses Viruses 52.4 3.24e-6   NR QFG09164.1 2599835 g54894 i0 50 3.67213114754098 44 22 72.1 0 171 40 85 128 QFG09164.1 hypothetical protein PBI_SPORTO_56 [Arthrobacter phage Sporto] diamond 672 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Arthrobacter phage Sporto
28266535 28266535 PRJNA1022392_P_NODE_63706_length_172_cov_3.120000_g63037_i0 PRJNA1022392 63706 172 3.12 5.3664 uncultured Caudovirales phage 2100421 Viruses Viruses 68.9 8.15e-12   NR CAB4125907.1 2100421 g63037 i0 62.5 0.976744186046512 56 20 97.7 1 2 169 19 73 CAB4125907.1 hypothetical protein UFOVP57_308 [uncultured Caudovirales phage] diamond 168 68.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28551110 28551110 PRJNA1022392_P_NODE_73987_length_162_cov_0.886957_g73318_i0 PRJNA1022392 73987 162 0.886957 1.43687034 Pasteurella phage PMP-GADVASU-IND 1927015 Viruses Viruses 42.7 0.013   NR APQ42484.1 1927015 g73318 i0 42.2 0.833333333333333 45 24 79.6 1 129 1 547 591 APQ42484.1 hypothetical protein [Pasteurella phage PMP-GADVASU-IND] diamond 135 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pasteurella phage PMP-GADVASU-IND
28771881 28771881 PRJNA1022392_P_NODE_25747_length_207_cov_4.718750_g25078_i0 PRJNA1022392 25747 207 4.71875 9.7678125 Brevundimonas phage vB_BpoS-MaInes 2948603 Viruses Viruses 83.6 7.74e-19   NR UTC30095.1 2948603 g25078 i0 63 1.05797101449275 73 21 97.1 1 205 5 42 114 UTC30095.1 hypothetical protein MAINES_00560 [Brevundimonas phage vB_BpoS-MaInes] diamond 219 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Brevundimonas phage vB_BpoS-MaInes
29056229 29056229 PRJNA1022392_P_NODE_26228_length_207_cov_2.643750_g25559_i0 PRJNA1022392 26228 207 2.64375 5.4725625 Caudoviricetes sp. 2832643 Viruses Viruses 73.9 2.33e-13   NR XOS66335.1 2832643 g25559 i0 45.9 1.23188405797101 85 23 89.9 1 206 21 2245 2329 XOS66335.1 MAG: hypothetical protein MSP0579_7 [Caudoviricetes sp.] diamond 255 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30003541 30003541 PRJNA1022392_P_NODE_75891_length_160_cov_2.566372_g75222_i0 PRJNA1022392 75891 160 2.566372 4.1061952 Microbacterium phage Cece 2972516 Viruses Viruses 79 2e-15   NR UVG35148.1 2972516 g75222 i0 61.5 1.95 52 20 97.5 0 158 3 221 272 UVG35148.1 DNA helicase [Microbacterium phage Cece] diamond 312 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Cece
30319888 30319888 PRJNA1022392_P_NODE_28192_length_206_cov_4.584906_g27523_i0 PRJNA1022392 28192 206 4.584906 9.44490636 uncultured Caudovirales phage 2100421 Viruses Viruses 89.4 2.21e-19   NR CAB4125103.1 2100421 g27523 i0 44.3 3.3495145631068 115 17 99 1 204 1 59 173 CAB4125103.1 DNA primase [uncultured Caudovirales phage] diamond 690 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30319891 30319891 PRJNA1022392_P_NODE_36572_length_205_cov_3.512658_g35903_i0 PRJNA1022392 36572 205 3.512658 7.2009489 Caudoviricetes sp. 2832643 Viruses Viruses 57.4 1.16e-7   NR XOS47100.1 2832643 g35903 i0 84.4 0.468292682926829 32 5 46.8 0 96 1 6 37 XOS47100.1 MAG: phage protein [Caudoviricetes sp.] diamond 96 57.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31038482 31038482 PRJNA1022392_P_NODE_77675_length_159_cov_1.464286_g77006_i0 PRJNA1022392 77675 159 1.464286 2.32821474 root 1 Root_unresolved Root_unresolved 82.4 1.2e-16   NR QIQ65264.1 2719189 g77006 i0 78.8 4.83018867924528 52 11 98.1 0 2 157 103 154 QIQ65264.1 hypothetical protein 19_00042 [Pseudomonas phage Epa19] diamond 768 82.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae   Pseudomonas phage Epa19
31267308 31267308 PRJNA1022392_P_NODE_72375_length_163_cov_1.534483_g71706_i0 PRJNA1022392 72375 163 1.534483 2.50120729 Stenotrophomonas phage RAS14 2996120 Viruses Viruses 68.2 6.6e-13   NR WAX21952.1 2996120 g71706 i0 90.3 0.570552147239264 31 3 57.1 0 69 161 1 31 WAX21952.1 hypothetical protein [Stenotrophomonas phage RAS14] diamond 93 68.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage RAS14
31267313 31267313 PRJNA1022392_P_NODE_77955_length_159_cov_0.910714_g77286_i0 PRJNA1022392 77955 159 0.910714 1.44803526 Gordonia phage OhMyWard 2652414 Viruses Viruses 55.5 5.1e-8   NR YP_009852759.1 2652414 g77286 i0 70 2.62264150943396 50 12 94.3 1 10 159 1 47 YP_009852759.1 hypothetical protein HWC72_gp11 [Gordonia phage OhMyWard] diamond 417 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kenoshavirus Kenoshavirus ohmyward
31425374 31425374 PRJNA1022392_P_NODE_11436_length_329_cov_5.833333_g10774_i0 PRJNA1022392 11436 329 5.833333 19.19166557 Caudoviricetes sp. 2832643 Viruses Viruses 90.9 1.27e-18   NR XOR55175.1 2832643 g10774 i0 37 2.2887537993921 127 59 99.4 3 327 1 7 130 XOR55175.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 753 90.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31994838 31994838 PRJNA1022392_P_NODE_63378_length_173_cov_1.428571_g62709_i0 PRJNA1022392 63378 173 1.428571 2.47142783 Brevundimonas phage vB_BpoS-MaInes 2948603 Viruses Viruses 57 1.3e-7   NR UTC30064.1 2948603 g62709 i0 59.6 0.815028901734104 47 18 81.5 1 144 4 145 190 UTC30064.1 hypothetical protein MAINES_00250 [Brevundimonas phage vB_BpoS-MaInes] diamond 141 57 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Brevundimonas phage vB_BpoS-MaInes
32026495 32026495 PRJNA1022392_P_NODE_81438_length_156_cov_2.431193_g80769_i0 PRJNA1022392 81438 156 2.431193 3.79266108 Caudoviricetes sp. 2832643 Viruses Viruses 51.2 1.18e-5   NR XOR55151.1 2832643 g80769 i0 51.1 0.903846153846154 47 23 90.4 0 1 141 445 491 XOR55151.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 141 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32279807 32279807 PRJNA1022392_P_NODE_78759_length_158_cov_2.045045_g78090_i0 PRJNA1022392 78759 158 2.045045 3.2311711 Caudoviricetes sp. 2832643 Viruses Viruses 48.1 1.38e-4   NR DAO89827.1 2832643 g78090 i0 73.3 4.9746835443038 30 8 57 0 91 2 23 52 DAO89827.1 MAG TPA: exonuclease [Caudoviricetes sp.] diamond 786 48.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32438038 32438038 PRJNA1022392_P_NODE_66539_length_169_cov_1.483607_g65870_i0 PRJNA1022392 66539 169 1.483607 2.50729583 Caudoviricetes sp. 2832643 Viruses Viruses 79 2.37e-15   NR XOR55175.1 2832643 g65870 i0 63.6 0.976331360946746 55 20 97.6 0 166 2 497 551 XOR55175.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 165 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32784672 32784672 PRJNA1022392_P_NODE_74660_length_161_cov_2.324561_g73991_i0 PRJNA1022392 74660 161 2.324561 3.74254321 Streptomyces phage Madamato 2510517 Viruses Viruses 47.8 2.1e-4   NR QAY17141.1 2510517 g73991 i0 51 4.75155279503106 51 25 95 0 9 161 1132 1182 QAY17141.1 tape measure protein [Streptomyces phage Madamato] diamond 765 47.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Rimavirus Streptomyces phage Madamato

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