RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1067443" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 22 ✖

bioproject 1

  • PRJNA1067443 · 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
21858391 21858391 PRJNA1067443_P_NODE_278_length_818_cov_12.115436_g264_i0 PRJNA1067443 278 818 12.115436 99.10426648 Ariapismic virus 51 3376556 Viruses Viruses 383 8.33e-128   NR XJW04528.1 3376556 g264 i0 74.3 0.997555012224939 272 61 99.8 2 817 2 120 382 XJW04528.1 MAG: major capsid protein [Ariapismic virus 51] diamond 816 383 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 51
26678828 26678828 PRJNA1067443_P_NODE_16201_length_251_cov_1.938202_g16183_i0 PRJNA1067443 16201 251 1.938202 4.86488702 Lindbergviridae 3424659 Viruses Viruses 68.9 6.18e-12   NR USN16336.1 2948611 g16183 i0 49.2 2.33067729083665 63 32 75.3 0 212 24 1 63 USN16336.1 hypothetical protein PLUTO_00200 [Luteibacter phage vB_LflM-Pluto] diamond 585 69.3 0.994227994227994 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Lindbergviridae Plutovirus Plutovirus pluto
27509776 27509776 PRJNA1067443_P_NODE_10623_length_281_cov_2.471154_g10605_i0 PRJNA1067443 10623 281 2.471154 6.94394274 Bacillus phage G 2884420 Viruses Viruses 83.2 1.98e-16   NR YP_009015858.1 2884420 g10605 i0 37.8 1.92170818505338 90 56 96.1 0 10 279 219 308 YP_009015858.1 ATPase [Bacillus phage G] diamond 540 83.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Donellivirus Donellivirus gee
27572800 27572800 PRJNA1067443_P_NODE_104_length_1109_cov_6.100386_g95_i0 PRJNA1067443 104 1109 6.100386 67.65328074 Ariapismic virus 51 3376556 Viruses Viruses 279 7.16e-89   NR XJW04533.1 3376556 g95 i0 66.3 1.04418394950406 193 65 52.2 0 14 592 85 277 XJW04533.1 MAG: replication initiator protein [Ariapismic virus 51] diamond 1158 279 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 51
27730962 27730962 PRJNA1067443_P_NODE_16044_length_252_cov_1.625698_g16026_i0 PRJNA1067443 16044 252 1.625698 4.09675896 Sphingomonas phage Scott 2282912 Viruses Viruses 47.8 4.66e-4   NR YP_009807872.1 2282912 g16026 i0 66.7 0.392857142857143 33 11 39.3 0 101 3 3 35 YP_009807872.1 tail protein [Sphingomonas phage Scott] diamond 99 47.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autonotataviridae Scottvirus Scottvirus scott
27856897 27856897 PRJNA1067443_P_NODE_3125_length_412_cov_1.070796_g3107_i0 PRJNA1067443 3125 412 1.070796 4.41167952 Burkholderiales phage 68_11 2718473 Viruses Viruses 223 1.96e-65   NR QOR55222.1 2718473 g3107 i0 73.7 1.99514563106796 137 36 99.8 0 2 412 606 742 QOR55222.1 MAG: hypothetical protein SHS37scaffold296_39 [Burkholderiales phage 68_11] diamond 822 223 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderiales phage 68_11
28141384 28141384 PRJNA1067443_P_NODE_19065_length_247_cov_0.885057_g19047_i0 PRJNA1067443 19065 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 92 2.24e-20   NR DAM41238.1 2832643 g19047 i0 60.9 0.838056680161943 69 27 83.8 0 209 3 1 69 DAM41238.1 MAG TPA: tail fiber protein [Caudoviricetes sp.] diamond 207 92 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28141391 28141391 PRJNA1067443_P_NODE_8265_length_301_cov_2.179825_g8247_i0 PRJNA1067443 8265 301 2.179825 6.56127325 Luteibacter phage vB_LflM-Pluto 2948611 Viruses Viruses 52.4 2.85e-5   NR USN16337.1 2948611 g8247 i0 59.6 0.51827242524916906 52 19 51.8 1 293 138 186 235 USN16337.1 hypothetical protein PLUTO_00210 [Luteibacter phage vB_LflM-Pluto] diamond 156 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Lindbergviridae Plutovirus Plutovirus pluto
28195742 28195742 PRJNA1067443_P_NODE_13226_length_266_cov_2.051813_g13208_i0 PRJNA1067443 13226 266 2.051813 5.45782258 Lindbergviridae 3424659 Viruses Viruses 68.9 2.56e-12   NR YP_009819165.1 2785027 g13208 i0 37.5 2.97744360902256 88 55 99.2 0 264 1 6 93 YP_009819165.1 tail fiber protein [Xanthomonas phage XcP1] diamond 792 69.3 0.994227994227994 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Lindbergviridae Carpasinavirus Carpasinavirus FoX6
28204083 28204083 PRJNA1067443_P_NODE_19926_length_245_cov_1.430233_g19908_i0 PRJNA1067443 19926 245 1.430233 3.50407085 Pseudomonas phage Amjad_SA 3003706 Viruses Viruses 116 3.53e-31   NR WAX22809.1 3003706 g19908 i0 70.4 0.991836734693878 81 24 99.2 0 243 1 56 136 WAX22809.1 endolysin [Pseudomonas phage Amjad_SA] diamond 243 116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Amjad_SA
29435377 29435377 PRJNA1067443_P_NODE_14290_length_260_cov_3.454545_g14272_i0 PRJNA1067443 14290 260 3.454545 8.981817 Pseudomonas phage 98PfluR6 3060164 Viruses Viruses 162 5.799999999999998e-44   NR YP_010659279.1 2163965 g14272 i0 87.2 0.992307692307692 86 11 99.2 0 3 260 1191 1276 YP_010659279.1 RNA polymerase [Pseudomonas phage 98PfluR60PP] diamond 258 162 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Littlefixvirus Littlefixvirus 98Pflur60pp
30098754 30098754 PRJNA1067443_P_NODE_5252_length_350_cov_3.404332_g5234_i0 PRJNA1067443 5252 350 3.404332 11.915162 Acinetobacter phage vB_AbaM_ME3 1837876 Viruses Viruses 102 1.09e-22   NR YP_009595861.1 1837876 g5234 i0 48.6 0.934285714285714 109 56 93.4 0 3 329 541 649 YP_009595861.1 tail sheath [Acinetobacter phage vB_AbaM_ME3] diamond 327 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Metrivirus Metrivirus ME3
30193556 30193556 PRJNA1067443_P_NODE_22052_length_242_cov_0.911243_g22034_i0 PRJNA1067443 22052 242 0.911243 2.20520806 Stenotrophomonas phage RAS14 2996120 Viruses Viruses 103 8.97e-25   NR WAX21435.1 2996120 g22034 i0 63.8 0.991735537190083 80 28 99.2 1 240 1 69 147 WAX21435.1 hypothetical protein [Stenotrophomonas phage RAS14] diamond 240 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage RAS14
30604328 30604328 PRJNA1067443_P_NODE_2773_length_426_cov_10.495751_g2755_i0 PRJNA1067443 2773 426 10.495751 44.71189926 Bacillus phage vB_BceM-HSE3 2170705 Viruses Viruses 80.5 1.75e-14   NR AWD93031.1 2170705 g2755 i0 43.8 0.73943661971831 105 58 73.2 1 79 390 267 371 AWD93031.1 baseplate protein [Bacillus phage vB_BceM-HSE3] diamond 315 80.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BceM-HSE3
30880316 30880316 PRJNA1067443_P_NODE_94_length_1164_cov_1.920257_g85_i0 PRJNA1067443 94 1164 1.920257 22.35179148 root 1 Root_unresolved Root_unresolved 104 1.55e-22   NR XOR38518.1 2832643 g85 i0 71.4 0.59020618556701 77 21 19.8 1 932 1162 1 76 XOR38518.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 687 105 0.990476190476191 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30952126 30952126 PRJNA1067443_P_NODE_22634_length_241_cov_0.916667_g22616_i0 PRJNA1067443 22634 241 0.916667 2.20916747 Escherichia phage UPEC 3102713 Viruses Viruses 73.2 5.09e-14   NR QUL77180.1 2811509 g22616 i0 68.1 0.5850622406639 47 15 58.5 0 3 143 120 166 QUL77180.1 hypothetical protein [Escherichia phage UPEC06] diamond 141 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage UPEC06
31141141 31141141 PRJNA1067443_P_NODE_4855_length_360_cov_1.735192_g4837_i0 PRJNA1067443 4855 360 1.735192 6.2466912 Pseudomonas phage Littlefix 2079289 Viruses Viruses 214 5.73e-63   NR YP_009837222.1 2079289 g4837 i0 92.5 1 120 9 100 0 1 360 381 500 YP_009837222.1 portal protein [Pseudomonas phage Littlefix] diamond 360 214 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Littlefixvirus Littlefixvirus littlefix
31607513 31607513 PRJNA1067443_P_NODE_15996_length_252_cov_2.011173_g15978_i0 PRJNA1067443 15996 252 2.011173 5.06815596 Myosmarvirus 2843428 Viruses Viruses 111 9.23e-29   NR YP_009850590.1 2596673 g15978 i0 62.8 2.04761904761905 86 28 97.6 1 248 3 91 176 YP_009850590.1 hypothetical protein HWC56_gp038 [Serratia phage MyoSmar] diamond 516 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Lindbergviridae Myosmarvirus Myosmarvirus myosmar
31647370 31647370 PRJNA1067443_P_NODE_4757_length_362_cov_2.121107_g4739_i0 PRJNA1067443 4757 362 2.121107 7.67840734 Pseudomonas phage RSP 2544986 Viruses Viruses 89.4 1.64e-18   NR QDB70641.1 2544986 g4739 i0 42.6 1.01104972375691 122 64 97.8 2 362 9 74 193 QDB70641.1 hypothetical protein RSP_0063 [Pseudomonas phage RSP] diamond 366 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage RSP
31742286 31742286 PRJNA1067443_P_NODE_13957_length_262_cov_2.079365_g13939_i0 PRJNA1067443 13957 262 2.079365 5.4479363 Luteibacter phage vB_LflM-Pluto 2948611 Viruses Viruses 94.7 2.02e-20   NR USN16329.1 2948611 g13939 i0 64 0.984732824427481 86 31 98.5 0 260 3 140 225 USN16329.1 hypothetical protein PLUTO_00130 [Luteibacter phage vB_LflM-Pluto] diamond 258 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Lindbergviridae Plutovirus Plutovirus pluto
31932096 31932096 PRJNA1067443_P_NODE_18297_length_248_cov_0.880000_g18279_i0 PRJNA1067443 18297 248 0.88 2.1824 Pseudomonas phage 98PfluR6 3060164 Viruses Viruses 101 2.4399999999999997e-24   NR YP_010659292.1 2163965 g18279 i0 86.2 0.701612903225806 58 8 70.2 0 75 248 1 58 YP_010659292.1 virion structural protein [Pseudomonas phage 98PfluR60PP] diamond 174 101 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Littlefixvirus Littlefixvirus 98Pflur60pp
32565339 32565339 PRJNA1067443_P_NODE_14119_length_261_cov_3.686170_g14101_i0 PRJNA1067443 14119 261 3.68617 9.6209037 Pseudomonas phage Littlefix 2079289 Viruses Viruses 71.6 1.39e-13   NR YP_009837294.1 2079289 g14101 i0 67.9 0.64367816091954 56 18 64.4 0 2 169 82 137 YP_009837294.1 hypothetical protein HWB52_gp92 [Pseudomonas phage Littlefix] diamond 168 71.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Littlefixvirus Littlefixvirus littlefix

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