RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068513 · 28 ✖

analysis 1

  • blastn · 28 ✖

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
181857 181857 PRJNA1068513_S_NODE_10041_length_282_cov_1.492823_g9995_i0 PRJNA1068513 10041 282 1.492823 4.20976086 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.2e-5   NTclustered gi|2056808531|tpg|BK057475.1| 2832643 g9995 i0 100 13.2021276595745 34 0 12 0 6 39 20 53 MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome blastn 3723 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2288880 2288880 PRJNA1068513_S_NODE_3202_length_487_cov_4.306763_g3157_i0 PRJNA1068513 3202 487 4.306763 20.97393581 Salasmaviridae 2842328 Viruses Viruses 104 1.29e-17   NTclustered gi|1549120968|gb|MK310228.1| 2500580 g3157 i0 92.105 4.82751540041068 76 3 15 3 414 487 80 6 Bacillus phage vB_BthP-HD73phi, complete genome blastn 2351 104 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Salasmaviridae Claudivirus Bacillus phage vB_BthP-HD73phi
2732350 2732350 PRJNA1068513_S_NODE_10783_length_271_cov_2.116162_g10737_i0 PRJNA1068513 10783 271 2.116162 5.73479902 Caudoviricetes sp. 2832643 Viruses Viruses 60.2 1.49e-4   NTclustered gi|2059855482|tpg|BK040575.1| 2832643 g10737 i0 100 6.59778597785978 32 0 12 0 240 271 11 42 MAG TPA_asm: Caudoviricetes sp. isolate ctwIV1, partial genome blastn 1788 60.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2732383 2732383 PRJNA1068513_S_NODE_1543_length_611_cov_531.578067_g1502_i0 PRJNA1068513 1543 611 531.578067 3247.94198937 Caudoviricetes sp. 2832643 Viruses Viruses 69.4 6.01e-7   NTclustered gi|2059855482|tpg|BK040575.1| 2832643 g1502 i0 95.455 6.42880523731588 44 0 7 2 5 46 4 47 MAG TPA_asm: Caudoviricetes sp. isolate ctwIV1, partial genome blastn 3928 69.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4008288 4008288 PRJNA1068513_S_NODE_11464_length_260_cov_6.358289_g11418_i0 PRJNA1068513 11464 260 6.358289 16.5315514 Bacillus phage vB_BthP-HD73phi 2500580 Viruses Viruses 58.4 5.09e-4   NTclustered gi|1549120968|gb|MK310228.1| 2500580 g11418 i0 97.143 0.696153846153846 35 0 13 1 1 35 50 83 Bacillus phage vB_BthP-HD73phi, complete genome blastn 181 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Salasmaviridae Claudivirus Bacillus phage vB_BthP-HD73phi
4008361 4008361 PRJNA1068513_S_NODE_4804_length_413_cov_2.023529_g4759_i0 PRJNA1068513 4804 413 2.023529 8.35717477 Salasvirus PZA 2843779 Viruses Viruses 60.2 2.37e-4   NTclustered gi|1971769499|gb|MW477480.1| 2803381 g4759 i0 100 7.82808716707022 32 0 8 0 382 413 19393 19424 Bacillus phage Whiting18, complete genome blastn 3233 60.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Salasmaviridae Salasvirus Salasvirus PZA
4841651 4841651 PRJNA1068513_S_NODE_3664_length_463_cov_26.628205_g3619_i0 PRJNA1068513 3664 463 26.628205 123.28858915 Viruses 10239 Viruses Viruses 67.6 1.61e-6   NTclustered gi|1549120429|gb|MK249308.1| 2500149 g3619 i0 100 8.4622030237581 36 0 8 0 10 45 31 66 Salmonella phage TS13, complete genome blastn 3918 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casjensviridae Chivirus Chivirus iEPS5
5284618 5284618 PRJNA1068513_S_NODE_12285_length_251_cov_1.106742_g12239_i0 PRJNA1068513 12285 251 1.106742 2.77792242 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.023   NTclustered gi|2057179698|tpg|BK058986.1| 2832643 g12239 i0 100 0.111553784860558 28 0 11 0 224 251 41121 41148 MAG TPA_asm: Caudoviricetes sp. isolate ctjRg17, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6559741 6559741 PRJNA1068513_S_NODE_1886_length_576_cov_8.316103_g1844_i0 PRJNA1068513 1886 576 8.316103 47.900753280000004 Klebsiella phage phiKp_32 2979986 Viruses Viruses 93.5 3.35e-14   NTclustered gi|2507497987|dbj|LC768500.1| 2979986 g1844 i0 93.548 10.9496527777778 62 4 11 0 515 576 72 11 Klebsiella phage phiKp_32 DNA, complete genome blastn 6307 93.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage phiKp_32
7834385 7834385 PRJNA1068513_S_NODE_2487_length_530_cov_13.435449_g2444_i0 PRJNA1068513 2487 530 13.435449 71.2078797 Paenibacillus phage Pahemo 2835998 Viruses Viruses 69.4 5.16e-7   NTclustered gi|2044627981|gb|MW927522.1| 2835998 g2444 i0 97.436 7.72264150943396 39 1 7 0 492 530 39546 39584 Paenibacillus phage Pahemo, complete genome blastn 4093 69.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fernvirus Paenibacillus phage Pahemo
7834421 7834421 PRJNA1068513_S_NODE_5387_length_391_cov_7.490566_g5341_i0 PRJNA1068513 5387 391 7.490566 29.28811306 Caudoviricetes sp. 2832643 Viruses Viruses 58.4 8.03e-4   NTclustered gi|2056839481|tpg|BK044098.1| 2832643 g5341 i0 97.059 7.88746803069054 34 1 9 0 357 390 34 1 MAG TPA_asm: Caudoviricetes sp. isolate ctI8r38, partial genome blastn 3084 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9109374 9109374 PRJNA1068513_S_NODE_13368_length_241_cov_7.154762_g13322_i0 PRJNA1068513 13368 241 7.154762 17.24297642 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1e-5   NTclustered gi|2056884685|tpg|BK053561.1| 2832643 g13322 i0 93.182 13.9917012448133 44 1 18 2 1 44 52627 52586 MAG TPA_asm: Caudoviricetes sp. isolate ct3lS3, partial genome blastn 3372 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9109473 9109473 PRJNA1068513_S_NODE_9388_length_294_cov_1.063348_g9342_i0 PRJNA1068513 9388 294 1.063348 3.12624312 Caudoviricetes sp. 2832643 Viruses Viruses 58.4 5.86e-4   NTclustered gi|2056884685|tpg|BK053561.1| 2832643 g9342 i0 92.683 10.6394557823129 41 2 14 1 234 274 52586 52625 MAG TPA_asm: Caudoviricetes sp. isolate ct3lS3, partial genome blastn 3128 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10385161 10385161 PRJNA1068513_S_NODE_4109_length_442_cov_6.035230_g4064_i0 PRJNA1068513 4109 442 6.03523 26.6757166 Caudoviricetes sp. 2832643 Viruses Viruses 67.6 1.53e-6   NTclustered gi|2056808531|tpg|BK057475.1| 2832643 g4064 i0 95.349 8.89140271493213 43 1 10 1 388 429 57 15 MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome blastn 3930 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11660439 11660439 PRJNA1068513_S_NODE_10870_length_270_cov_1.355330_g10824_i0 PRJNA1068513 10870 270 1.35533 3.659391 Paenibacillus phage Pahemo 2835998 Viruses Viruses 75 5.28e-9   NTclustered gi|2044627981|gb|MW927522.1| 2835998 g10824 i0 100 18.162962962963 40 0 15 0 12 51 41895 41934 Paenibacillus phage Pahemo, complete genome blastn 4904 75 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fernvirus Paenibacillus phage Pahemo
12935667 12935667 PRJNA1068513_S_NODE_7691_length_328_cov_0.917647_g7645_i0 PRJNA1068513 7691 328 0.917647 3.00988216 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.43e-5   NTclustered gi|2057092053|tpg|BK038136.1| 2832643 g7645 i0 100 10.2896341463415 34 0 10 0 1 34 38059 38026 MAG TPA_asm: Caudoviricetes sp. isolate ctolP12, partial genome blastn 3375 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14210596 14210596 PRJNA1068513_S_NODE_7312_length_337_cov_1.117424_g7266_i0 PRJNA1068513 7312 337 1.117424 3.76571888 Caudoviricetes sp. 2832643 Viruses Viruses 71.3 8.78e-8   NTclustered gi|2056808531|tpg|BK057475.1| 2832643 g7266 i0 97.561 11.786350148368 41 1 12 0 5 45 17 57 MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome blastn 3972 71.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15041291 15041291 PRJNA1068513_S_NODE_11212_length_264_cov_2.324607_g11166_i0 PRJNA1068513 11212 264 2.324607 6.13696248 Viruses 10239 Viruses Viruses 67.6 8.61e-7   NTclustered gi|1549120429|gb|MK249308.1| 2500149 g11166 i0 100 14.0454545454545 36 0 14 0 6 41 31 66 Salmonella phage TS13, complete genome blastn 3708 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casjensviridae Chivirus Chivirus iEPS5
15041311 15041311 PRJNA1068513_S_NODE_5072_length_402_cov_140.635258_g5027_i0 PRJNA1068513 5072 402 140.635258 565.35373716 Viruses 10239 Viruses Viruses 69.4 3.83e-7   NTclustered gi|1842001608|ref|NC_047813.1| 1958907 g5027 i0 97.5 10.4726368159204 40 1 10 0 3 42 17 56 Staphylococcus phage Andhra, complete genome blastn 4210 69.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Rountreeviridae Andhravirus Andhravirus andhra
16758850 16758850 PRJNA1068513_S_NODE_9514_length_291_cov_3.541284_g9468_i0 PRJNA1068513 9514 291 3.541284 10.30513644 Caudoviricetes sp. 2832643 Viruses Viruses 73.1 2.07e-8   NTclustered gi|2056884685|tpg|BK053561.1| 2832643 g9468 i0 93.878 15.3092783505155 49 1 17 2 12 60 52632 52586 MAG TPA_asm: Caudoviricetes sp. isolate ct3lS3, partial genome blastn 4455 73.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18033638 18033638 PRJNA1068513_S_NODE_7275_length_338_cov_1.547170_g7229_i0 PRJNA1068513 7275 338 1.54717 5.2294346 Caudoviricetes sp. 2832643 Viruses Viruses 56.5 0.002   NTclustered gi|2056839448|tpg|BK044097.1| 2832643 g7229 i0 100 3.94082840236686 30 0 9 0 1 30 2 31 MAG TPA_asm: Caudoviricetes sp. isolate ctJJy7, partial genome blastn 1332 56.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20583035 20583035 PRJNA1068513_S_NODE_4397_length_429_cov_8.348315_g4352_i0 PRJNA1068513 4397 429 8.348315 35.81427135 Salasvirus PZA 2843779 Viruses Viruses 67.6 1.48e-6   NTclustered gi|1971769499|gb|MW477480.1| 2803381 g4352 i0 100 8.38228438228438 36 0 8 0 1 36 19427 19392 Bacillus phage Whiting18, complete genome blastn 3596 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Salasmaviridae Salasvirus Salasvirus PZA
20583058 20583058 PRJNA1068513_S_NODE_6837_length_348_cov_17.952727_g6791_i0 PRJNA1068513 6837 348 17.952727 62.47548996 Valbvirus ValB1MD2 2956629 Viruses Viruses 69.4 3.27e-7   NTclustered gi|2047455040|ref|NC_055862.1| 2759177 g6791 i0 100 11.5862068965517 37 0 11 0 2 38 36616 36580 Vibrio phage ValB1MD-2, complete genome blastn 4032 69.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Valbvirus Valbvirus ValB1MD2
20583091 20583091 PRJNA1068513_S_NODE_9677_length_289_cov_1.083333_g9631_i0 PRJNA1068513 9677 289 1.083333 3.13083237 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.24e-5   NTclustered gi|2059855482|tpg|BK040575.1| 2832643 g9631 i0 93.182 11.6124567474048 44 1 15 2 246 289 48 7 MAG TPA_asm: Caudoviricetes sp. isolate ctwIV1, partial genome blastn 3356 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21858741 21858741 PRJNA1068513_S_NODE_7758_length_326_cov_2.944664_g7712_i0 PRJNA1068513 7758 326 2.944664 9.59960464 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 0.009   NTclustered gi|2059800674|tpg|BK039702.1| 2832643 g7712 i0 96.875 0.269938650306748 32 1 10 0 295 326 24758 24789 MAG TPA_asm: Caudoviricetes sp. isolate ctKXI2, partial genome blastn 88 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23134179 23134179 PRJNA1068513_S_NODE_2619_length_522_cov_4.567929_g2575_i0 PRJNA1068513 2619 522 4.567929 23.84458938 Klebsiella phage phiKp_32 2979986 Viruses Viruses 122 3.85e-23   NTclustered gi|2507497987|dbj|LC768500.1| 2979986 g2575 i0 97.222 15.2413793103448 72 2 14 0 15 86 1 72 Klebsiella phage phiKp_32 DNA, complete genome blastn 7956 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage phiKp_32
24407694 24407694 PRJNA1068513_S_NODE_11940_length_254_cov_1.055249_g11894_i0 PRJNA1068513 11940 254 1.055249 2.68033246 Caudoviricetes sp. 2832643 Viruses Viruses 67.6 8.24e-7   NTclustered gi|2056884685|tpg|BK053561.1| 2832643 g11894 i0 100 15.8228346456693 36 0 14 0 1 36 52628 52593 MAG TPA_asm: Caudoviricetes sp. isolate ct3lS3, partial genome blastn 4019 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24407814 24407814 PRJNA1068513_S_NODE_920_length_706_cov_13.260664_g882_i0 PRJNA1068513 920 706 13.260664 93.62028784 Caudoviricetes sp. 2832643 Viruses Viruses 71.3 1.95e-7   NTclustered gi|2056808531|tpg|BK057475.1| 2832643 g882 i0 100 5.88951841359773 38 0 5 0 8 45 15 52 MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome blastn 4158 71.3 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);;