RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1145574 · 29 ✖

analysis 1

  • diamond · 29 ✖
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
2839500 2839500 PRJNA1145574_P_NODE_1503_length_678_cov_1.905785_g1325_i0 PRJNA1145574 1503 678 1.905785 12.9212223 Tequintavirus 187218 Viruses Viruses 309 1.15e-97   NR QQM13548.1 2749424 g1325 i0 63.7 3.95132743362832 223 81 98.7 0 10 678 101 323 QQM13548.1 tail fiber protein [Salmonella phage vB_StyS-LmqsSP1] diamond 2679 312 0.990384615384615 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus LmqsSP1
3583756 3583756 PRJNA1145574_P_NODE_43_length_2607_cov_2.414759_g25_i0 PRJNA1145574 43 2607 2.414759 62.95276713 Salmonella phage Sw2 2316014 Viruses Viruses 149 1.7799999999999998e-37   NR YP_009812149.1 2316014 g25 i0 58.3 0.165707710011507 144 46 15 3 1660 2049 22 165 YP_009812149.1 endonuclease nicking abasic sites generated by host uracil glycosylase Ung [Salmonella phage Sw2] diamond 432 149 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus Sw2
6136138 6136138 PRJNA1145574_P_NODE_3985_length_414_cov_1.601173_g3801_i0 PRJNA1145574 3985 414 1.601173 6.62885622 Demerecviridae 2731690 Viruses Viruses 236 9.44e-70   NR YP_006906383.1 1204539 g3801 i0 79.7 4 138 28 100 0 414 1 163 300 YP_006906383.1 putative tail protein pb3 [Pectobacterium phage My1] diamond 1656 238 0.991596638655462 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Myunavirus Myunavirus My1
13786672 13786672 PRJNA1145574_P_NODE_8651_length_292_cov_1.424658_g8467_i0 PRJNA1145574 8651 292 1.424658 4.16000136 Yersinia phage phiR2- 3052187 Viruses Viruses 166 2.24e-48   NR YP_007237087.1 1206557 g8467 i0 81.3 1.96232876712329 96 18 98.6 0 2 289 26 121 YP_007237087.1 NAD-dependent DNA ligase [Yersinia phage phiR2-01] diamond 573 166 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus R201
18884855 18884855 PRJNA1145574_P_NODE_1455_length_688_cov_1.151220_g1277_i0 PRJNA1145574 1455 688 1.15122 7.9203936 Salmonella phage SP1a 2109652 Viruses Viruses 216 1.96e-67   NR ATI18522.1 2109652 g1277 i0 66.9 0.697674418604651 160 53 69.8 0 209 688 3 162 ATI18522.1 hypothetical protein [Salmonella phage SP1a] diamond 480 216 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Salmonella phage SP1a
26943891 26943891 PRJNA1145574_P_NODE_782_length_941_cov_1.923963_g633_i0 PRJNA1145574 782 941 1.923963 18.10449183 Klebsiella phage AmPh_EK8 3432625 Viruses Viruses 282 2.93e-82   NR QFR57412.1 2653643 g633 i0 49.5 0.997874601487779 313 158 99.8 0 939 1 1015 1327 QFR57412.1 tail length tape-measure protein [Klebsiella phage AmPh_EK80] diamond 939 282 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Sugarlandvirus Sugarlandvirus AmPhEK80
26975621 26975621 PRJNA1145574_P_NODE_2022_length_580_cov_1.842209_g1841_i0 PRJNA1145574 2022 580 1.842209 10.6848122 Salmonella phage Stp1 1971233 Viruses Viruses 204 4.340000000000001e-59   NR ARQ96292.1 1971233 g1841 i0 59.4 1.9551724137931 187 72 94.7 1 551 3 118 304 ARQ96292.1 receptor-binding protein [Salmonella phage Stp1] diamond 1134 204 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Salmonella phage Stp1
27122356 27122356 PRJNA1145574_P_NODE_10122_length_267_cov_1.608247_g9938_i0 PRJNA1145574 10122 267 1.608247 4.29401949 Tequintavirus 187218 Viruses Viruses 131 6.42e-36   NR UDL14111.1 2886210 g9938 i0 74.7 1.86516853932584 83 21 93.3 0 266 18 35 117 UDL14111.1 endonuclease [Salmonella phage vB_SenS_S124] diamond 498 132 0.992424242424242 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus S124
27344189 27344189 PRJNA1145574_P_NODE_6143_length_345_cov_1.143382_g5959_i0 PRJNA1145574 6143 345 1.143382 3.9446679 Epseptimavirus 2732017 Viruses Viruses 123 1.1e-32   NR QXV85202.1 2851991 g5959 i0 61.5 3.95652173913043 91 34 79.1 1 345 73 80 169 QXV85202.1 serine/threonine phosphatase [Escherichia phage TrudiGerster] diamond 1365 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus trudigerster
28523409 28523409 PRJNA1145574_P_NODE_1647_length_644_cov_1.502627_g1468_i0 PRJNA1145574 1647 644 1.502627 9.67691788 Salmonella phage misterkot 2713305 Viruses Viruses 123 2.69e-32   NR QIN99904.1 2713305 g1468 i0 51.3 0.554347826086957 119 44 49.4 3 186 503 1 118 QIN99904.1 hypothetical protein misterkot_124 [Salmonella phage misterkot] diamond 357 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus misterkot
28838933 28838933 PRJNA1145574_P_NODE_548_length_1122_cov_1.343184_g430_i0 PRJNA1145574 548 1122 1.343184 15.07052448 Escherichia phage HildyBeyeler 2852005 Viruses Viruses 343 1.41e-109   NR QXV80181.1 2852005 g430 i0 70 1.82085561497326 227 68 60.7 0 1 681 369 595 QXV80181.1 receptor-binding tail tip protein [Escherichia phage HildyBeyeler] diamond 2043 343 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus hildybeyeler
28933840 28933840 PRJNA1145574_P_NODE_9608_length_276_cov_1.152709_g9424_i0 PRJNA1145574 9608 276 1.152709 3.18147684 Klebsiella phage vB_Kpn_3 2836075 Viruses Viruses 121 1.01e-31   NR QXN67586.1 2836075 g9424 i0 64.4 4.40217391304348 90 32 97.8 0 3 272 25 114 QXN67586.1 hypothetical protein [Klebsiella phage vB_Kpn_3] diamond 1215 121 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Sugarlandvirus Klebsiella phage vB_Kpn_3
29627923 29627923 PRJNA1145574_P_NODE_8590_length_293_cov_1.772727_g8406_i0 PRJNA1145574 8590 293 1.772727 5.19409011 Escherichia phage TrudiGerster 2851991 Viruses Viruses 79.3 1.87e-15   NR QXV85193.1 2851991 g8406 i0 54.3 0.716723549488055 70 30 69.6 1 234 31 115 184 QXV85193.1 dNMP kinase [Escherichia phage TrudiGerster] diamond 210 79.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus trudigerster
30292142 30292142 PRJNA1145574_P_NODE_5552_length_360_cov_2.445993_g5368_i0 PRJNA1145574 5552 360 2.445993 8.8055748 Salmonella phage GSW6 3025422 Viruses Viruses 63.2 1.78e-9   NR WCX68789.1 3025422 g5368 i0 35.7 4.975 115 67 95.8 3 358 14 8 115 WCX68789.1 dihydrofolate reductase [Salmonella phage GSW6] diamond 1791 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus GSW6
30355431 30355431 PRJNA1145574_P_NODE_13012_length_247_cov_1.344828_g12828_i0 PRJNA1145574 13012 247 1.344828 3.32172516 Klebsiella phage vB_Kpn_3 2836075 Viruses Viruses 156 1.7899999999999996e-43   NR QXN67551.1 2836075 g12828 i0 89 4.97975708502024 82 9 99.6 0 246 1 374 455 QXN67551.1 DNA polymerase 1 [Klebsiella phage vB_Kpn_3] diamond 1230 156 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Sugarlandvirus Klebsiella phage vB_Kpn_3
30481338 30481338 PRJNA1145574_P_NODE_1713_length_633_cov_1.392857_g1534_i0 PRJNA1145574 1713 633 1.392857 8.81678481 Bacteriophage Eos 2662137 Viruses Viruses 117 3.53e-29   NR QGH45176.1 2662137 g1534 i0 44.1 0.677725118483412 143 74 64.9 3 191 601 7 149 QGH45176.1 hypothetical protein [Bacteriophage Eos] diamond 429 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae   Bacteriophage Eos
30722863 30722863 PRJNA1145574_P_NODE_10054_length_269_cov_1.010204_g9870_i0 PRJNA1145574 10054 269 1.010204 2.71744876 Tequintavirus 187218 Viruses Viruses 146 2.82e-41   NR YP_009966024.1 2886919 g9870 i0 79.8 1.98513011152416 89 18 99.3 0 268 2 151 239 YP_009966024.1 hypothetical protein FGG59_gp058 [Escherichia phage H8] diamond 534 147 0.993197278911565 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus H8
30722865 30722865 PRJNA1145574_P_NODE_2234_length_550_cov_1.471698_g2052_i0 PRJNA1145574 2234 550 1.471698 8.094339 Demerecviridae 2731690 Viruses Viruses 103 3.48e-24   NR YP_009804592.1 2053625 g2052 i0 43 3.94909090909091 142 76 74.7 3 114 524 5 146 YP_009804592.1 HNH endonuclease [Salmonella phage SP3] diamond 2172 103 1 Viruses Duplodnaviria Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus SP3
30754628 30754628 PRJNA1145574_P_NODE_3674_length_429_cov_1.533708_g3490_i0 PRJNA1145574 3674 429 1.533708 6.57960732 Hongcheonvirus 2732966 Viruses Viruses 183 6.289999999999999e-54   NR YP_009795268.1 2041492 g3490 i0 57.4 1.97902097902098 141 60 98.6 0 5 427 48 188 YP_009795268.1 hypothetical protein HOS40_gp108 [Pectobacterium phage DU_PP_V] diamond 849 184 0.994565217391304 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Hongcheonvirus Hongcheonvirus DUPPV
30765664 30765664 PRJNA1145574_P_NODE_5934_length_350_cov_2.119134_g5750_i0 PRJNA1145574 5934 350 2.119134 7.416969 Klebsiella phage AmPh_EK8 3432625 Viruses Viruses 150 2.21e-39   NR QFR57412.1 2653643 g5750 i0 71.2 0.951428571428571 111 32 95.1 0 3 335 813 923 QFR57412.1 tail length tape-measure protein [Klebsiella phage AmPh_EK80] diamond 333 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Sugarlandvirus Sugarlandvirus AmPhEK80
31524411 31524411 PRJNA1145574_P_NODE_9916_length_271_cov_1.181818_g9732_i0 PRJNA1145574 9916 271 1.181818 3.20272678 Yersinia phage phiR2- 3052187 Viruses Viruses 58.9 2.42e-9   NR YP_007237075.1 1206557 g9732 i0 53.6 0.619926199261993 56 26 62 0 41 208 3 58 YP_007237075.1 hypothetical protein BN79_115 [Yersinia phage phiR2-01] diamond 168 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus R201
31556164 31556164 PRJNA1145574_P_NODE_4796_length_383_cov_2.296774_g4612_i0 PRJNA1145574 4796 383 2.296774 8.79664442 Bacteroides phage BK735P2 2968570 Viruses Viruses 48.5 9.27e-5   NR WAX07975.1 2968570 g4612 i0 41.3 0.493472584856397 63 36 48.6 1 34 219 1 63 WAX07975.1 hypothetical protein BK735P2_00021 [Bacteroides phage BK735P2] diamond 189 48.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacteroides phage BK735P2
31650621 31650621 PRJNA1145574_P_NODE_9557_length_277_cov_1.147059_g9373_i0 PRJNA1145574 9557 277 1.147059 3.17735343 Yersinia phage phiR2- 3052187 Viruses Viruses 55.5 1.5e-6   NR YP_007237062.1 1206557 g9373 i0 63 0.498194945848375 46 16 48.7 1 1 135 234 279 YP_007237062.1 thymidylate synthase [Yersinia phage phiR2-01] diamond 138 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus R201
32177677 32177677 PRJNA1145574_P_NODE_4358_length_399_cov_1.435583_g4174_i0 PRJNA1145574 4358 399 1.435583 5.72797617 Demerecviridae 2731690 Viruses Viruses 215 9.999999999999999e-69   NR YP_007237014.1 1206557 g4174 i0 73.1 2.88721804511278 130 35 97.7 0 390 1 9 138 YP_007237014.1 ATP-dependent protease [Yersinia phage phiR2-01] diamond 1152 215 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus R201
32220313 32220313 PRJNA1145574_P_NODE_6758_length_331_cov_1.701550_g6574_i0 PRJNA1145574 6758 331 1.70155 5.6321305 Escherichia phage JLBYU43 2894751 Viruses Viruses 75.1 1.82e-14   NR UGO55740.1 2894751 g6574 i0 57.4 0.61631419939577 68 28 60.7 1 204 4 8 75 UGO55740.1 putative tape measure protein [Escherichia phage JLBYU43] diamond 204 75.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus JLBYU43
32599865 32599865 PRJNA1145574_P_NODE_7000_length_326_cov_1.541502_g6816_i0 PRJNA1145574 7000 326 1.541502 5.02529652 Yersinia phage phiR2- 3052187 Viruses Viruses 101 1.62e-22   NR YP_007237066.1 1206557 g6816 i0 72.5 6.24846625766871 69 17 61.7 1 1 201 382 450 YP_007237066.1 ribonucleotide reductase large subunit [Yersinia phage phiR2-01] diamond 2037 101 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Epseptimavirus Epseptimavirus R201
32851629 32851629 PRJNA1145574_P_NODE_4020_length_413_cov_1.147059_g3836_i0 PRJNA1145574 4020 413 1.147059 4.73735367 Salmonella phage Shivani 1572715 Viruses Viruses 152 5.8299999999999986e-43   NR YP_009194776.1 1572715 g3836 i0 64.9 2.41888619854722 111 38 80.6 1 333 1 2 111 YP_009194776.1 tail assembly chaperone [Salmonella phage Shivani] diamond 999 152 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Tequintavirus Tequintavirus shivani
32851630 32851630 PRJNA1145574_P_NODE_880_length_884_cov_2.970407_g726_i0 PRJNA1145574 880 884 2.970407 26.25839788 Pantoea phage vB_PagS_AAS21 2575261 Viruses Viruses 433 7.499999999999998e-147   NR QCW23944.1 2575261 g726 i0 69.2 6.02036199095023 295 90 99.8 1 2 883 214 508 QCW23944.1 A1 protein [Pantoea phage vB_PagS_AAS21] diamond 5322 433 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Keyvirus Keyvirus AAS21
32883008 32883008 PRJNA1145574_P_NODE_9460_length_279_cov_1.135922_g9276_i0 PRJNA1145574 9460 279 1.135922 3.16922238 Pectobacterium phage DU_PP_V 2041492 Viruses Viruses 102 5.02e-26   NR YP_009795265.1 2041492 g9276 i0 70 0.752688172043011 70 21 75.3 0 211 2 1 70 YP_009795265.1 hypothetical protein HOS40_gp111 [Pectobacterium phage DU_PP_V] diamond 210 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Hongcheonvirus Hongcheonvirus DUPPV

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