RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA793147 · 25 ✖

analysis 1

  • blastn · 25 ✖

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
777672 777672 PRJNA793147_P_NODE_33681_length_289_cov_1.663636_g33415_i0 PRJNA793147 33681 289 1.663636 4.80790804 Hafnia phage TS33 3110108 Viruses Viruses 377 3.89e-100   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g33415 i0 90.278 9.60899653979239 288 28 99 0 1 288 10036 10323 Hafnia phage TS33, complete genome blastn 2777 377 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
4606584 4606584 PRJNA793147_P_NODE_57984_length_229_cov_0.900000_g57718_i0 PRJNA793147 57984 229 0.9 2.061 Moovirus moo 3060392 Viruses Viruses 318 1.82e-82   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g57718 i0 95.918 0.85589519650655 196 8 86 0 3 198 17747 17552 Shigella virus Moo19, complete genome blastn 196 318 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
5881727 5881727 PRJNA793147_P_NODE_58225_length_229_cov_0.900000_g57959_i0 PRJNA793147 58225 229 0.9 2.061 Christensenvirus IME542 2734000 Viruses Viruses 424 3.76e-114   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g57959 i0 100 14.2314410480349 229 0 100 0 1 229 1792 2020 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 3259 424 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
7156406 7156406 PRJNA793147_P_NODE_48106_length_242_cov_1.664740_g47840_i0 PRJNA793147 48106 242 1.66474 4.0286708 Hafnia phage TS33 3110108 Viruses Viruses 207 4.4e-49   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g47840 i0 92.466 0.603305785123967 146 10 60 1 1 146 22982 22838 Hafnia phage TS33, complete genome blastn 146 207 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
7156457 7156457 PRJNA793147_P_NODE_50706_length_235_cov_1.301205_g50440_i0 PRJNA793147 50706 235 1.301205 3.05783175 Seretavirus eta 3432373 Viruses Viruses 206 1.53e-48   NTclustered gi|514361045|ref|NC_021563.1| 1282995 g50440 i0 82.627 1.00425531914894 236 37 99 3 2 235 28866 28633 Serratia phage Eta, complete genome blastn 236 206 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
8430887 8430887 PRJNA793147_P_NODE_34407_length_286_cov_1.990783_g34141_i0 PRJNA793147 34407 286 1.990783 5.69363938 Hafnia phage TS33 3110108 Viruses Viruses 412 1.0499999999999999e-110   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g34141 i0 92.933 0.989510489510489 283 20 99 0 1 283 23987 23705 Hafnia phage TS33, complete genome blastn 283 412 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
10981617 10981617 PRJNA793147_P_NODE_30509_length_303_cov_1.230769_g30243_i0 PRJNA793147 30509 303 1.230769 3.72923007 Moovirus moo 3060392 Viruses Viruses 346 1.16e-90   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g30243 i0 95.794 1.00660066006601 214 9 95 0 1 214 16533 16746 Shigella virus Moo19, complete genome blastn 305 346 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
10981957 10981957 PRJNA793147_P_NODE_46509_length_247_cov_1.213483_g46243_i0 PRJNA793147 46509 247 1.213483 2.99730301 Hafnia phage TS33 3110108 Viruses Viruses 351 1.97e-92   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g46243 i0 92.308 1 247 19 100 0 1 247 8900 9146 Hafnia phage TS33, complete genome blastn 247 351 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
10982147 10982147 PRJNA793147_P_NODE_55909_length_231_cov_0.888889_g55643_i0 PRJNA793147 55909 231 0.888889 2.05333359 Caudoviricetes sp. 2832643 Viruses Viruses 289 1.45e-73   NTclustered gi|2914814131|gb|OR221916.1| 2832643 g55643 i0 89.224 8.23809523809524 232 23 100 2 1 231 3437 3667 MAG: Caudoviricetes sp. isolate MSP0211 genomic sequence blastn 1903 289 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12257560 12257560 PRJNA793147_P_NODE_47850_length_243_cov_1.494253_g47584_i0 PRJNA793147 47850 243 1.494253 3.63103479 Moovirus moo 3060392 Viruses Viruses 327 3.25e-85   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g47584 i0 90.947 10.0123456790123 243 22 100 0 1 243 42535 42293 Shigella virus Moo19, complete genome blastn 2433 327 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
12695665 12695665 PRJNA793147_P_NODE_56970_length_230_cov_0.894410_g56704_i0 PRJNA793147 56970 230 0.89441 2.057143 Tunavirus 187217 Viruses Viruses 414 2.27e-111   NTclustered gi|1842013656|ref|NC_047959.1| 2163886 g56704 i0 99.13 52.9304347826087 230 2 100 0 1 230 22927 23156 Enterobacteria phage vB_EcoS_IME18, complete genome blastn 12174 414 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Tunavirus Tunavirus IME18
13531200 13531200 PRJNA793147_P_NODE_25371_length_331_cov_1.099237_g25105_i0 PRJNA793147 25371 331 1.099237 3.63847447 Hafnia phage TS33 3110108 Viruses Viruses 209 1.75e-49   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g25105 i0 94.161 0.413897280966767 137 8 41 0 113 249 29055 28919 Hafnia phage TS33, complete genome blastn 137 209 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
13531930 13531930 PRJNA793147_P_NODE_61171_length_227_cov_0.911392_g60905_i0 PRJNA793147 61171 227 0.911392 2.06885984 Caudoviricetes sp. 2832643 Viruses Viruses 326 1.08e-84   NTclustered gi|2914885752|gb|OR222391.1| 2832643 g60905 i0 92.857 11.9383259911894 224 16 99 0 3 226 29960 30183 MAG: Caudoviricetes sp. isolate MSP1012 genomic sequence blastn 2710 326 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14806927 14806927 PRJNA793147_P_NODE_63072_length_219_cov_2.466667_g62806_i0 PRJNA793147 63072 219 2.466667 5.40200073 Hafnia phage TS33 3110108 Viruses Viruses 259 1.06e-64   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g62806 i0 95.122 0.748858447488584 164 8 75 0 1 164 185 22 Hafnia phage TS33, complete genome blastn 164 259 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
16079950 16079950 PRJNA793147_P_NODE_18433_length_390_cov_1.467290_g18167_i0 PRJNA793147 18433 390 1.46729 5.722431 Hafnia phage TS33 3110108 Viruses Viruses 148 4.619999999999999e-31   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g18167 i0 95.652 0.235897435897436 92 4 24 0 1 92 39507 39598 Hafnia phage TS33, complete genome blastn 92 148 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
16518806 16518806 PRJNA793147_P_NODE_40933_length_263_cov_2.000000_g40667_i0 PRJNA793147 40933 263 2 5.26 Schitoviridae 2842329 Viruses Viruses 126 1.39e-24   NTclustered gi|345461828|ref|NC_015933.1| 1054461 g40667 i0 100 2.28136882129278 68 0 26 0 196 263 2598 2665 Escherichia phage vB_EcoP_G7C, complete genome blastn 600 126 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Gamaleyavirus Gamaleyavirus G7C
21180093 21180093 PRJNA793147_P_NODE_25877_length_327_cov_1.899225_g25611_i0 PRJNA793147 25877 327 1.899225 6.21046575 Hafnia phage TS33 3110108 Viruses Viruses 503 7.06e-138   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g25611 i0 94.737 2.97859327217125 323 17 99 0 2 324 9601 9923 Hafnia phage TS33, complete genome blastn 974 503 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
21618059 21618059 PRJNA793147_P_NODE_39417_length_268_cov_1.447236_g39151_i0 PRJNA793147 39417 268 1.447236 3.87859248 Tunavirus 187217 Viruses Viruses 496 9.429999999999999e-136   NTclustered gi|1726255596|gb|MN153797.1| 1921008 g39151 i0 100 39.7761194029851 268 0 100 0 1 268 7559 7292 Tunavirus T1 isolate 22, complete genome blastn 10660 496 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Tunavirus Tunavirus T1
22454924 22454924 PRJNA793147_P_NODE_30238_length_304_cov_1.497872_g29972_i0 PRJNA793147 30238 304 1.497872 4.55353088 Hafnia phage TS33 3110108 Viruses Viruses 507 5.03e-139   NTclustered gi|2642095204|gb|OR844384.1| 3110108 g29972 i0 96.711 1 304 10 100 0 1 304 13839 14142 Hafnia phage TS33, complete genome blastn 304 507 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
22455448 22455448 PRJNA793147_P_NODE_58378_length_229_cov_0.900000_g58112_i0 PRJNA793147 58378 229 0.9 2.061 Salmonella phage NINP13076 2849628 Viruses Viruses 150 7.039999999999999e-32   NTclustered gi|2065691516|gb|MZ326168.1| 2849628 g58112 i0 79.717 1.68122270742358 212 39 92 4 9 218 17288 17497 Salmonella phage NINP13076, complete genome blastn 385 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Seunavirus Salmonella phage NINP13076
23730602 23730602 PRJNA793147_P_NODE_34979_length_284_cov_1.339535_g34713_i0 PRJNA793147 34979 284 1.339535 3.8042794 Moovirus moo 3060392 Viruses Viruses 484 2.1799999999999998e-132   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g34713 i0 97.857 0.985915492957746 280 6 99 0 1 280 22534 22813 Shigella virus Moo19, complete genome blastn 280 484 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
24167454 24167454 PRJNA793147_P_NODE_28859_length_311_cov_0.892562_g28593_i0 PRJNA793147 28859 311 0.892562 2.77586782 Tunavirus 187217 Viruses Viruses 553 6.539999999999998e-153   NTclustered gi|1841999771|ref|NC_047785.1| 1913048 g28593 i0 98.714 52.0192926045016 311 4 100 0 1 311 28409 28719 Shigella phage SH6, complete genome blastn 16178 558 0.991039426523297 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Tunavirus Tunavirus SH6
25004187 25004187 PRJNA793147_P_NODE_34920_length_284_cov_1.897674_g34654_i0 PRJNA793147 34920 284 1.897674 5.38939416 Moovirus moo 3060392 Viruses Viruses 394 3.78e-105   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g34654 i0 92.115 0.982394366197183 279 22 98 0 6 284 21191 20913 Shigella virus Moo19, complete genome blastn 279 394 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
25004280 25004280 PRJNA793147_P_NODE_40040_length_266_cov_1.461929_g39774_i0 PRJNA793147 40040 266 1.461929 3.88873114 Escherichia phage TR1 2972435 Viruses Viruses 492 1.2099999999999999e-134   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g39774 i0 100 45 266 0 100 0 1 266 26224 25959 Escherichia phage TR1, complete genome blastn 11970 492 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
25004522 25004522 PRJNA793147_P_NODE_53640_length_233_cov_0.878049_g53374_i0 PRJNA793147 53640 233 0.878049 2.04585417 Caudoviricetes sp. 2832643 Viruses Viruses 409 1.07e-109   NTclustered gi|2915007166|gb|OR222402.1| 2832643 g53374 i0 98.283 2.9656652360515 233 4 100 0 1 233 42011 42243 MAG: Caudoviricetes sp. isolate MSP0997 genomic sequence blastn 691 409 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);;