RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA534016 · 35 ✖

analysis 1

  • blastn · 35 ✖

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
507625 507625 PRJNA534016_P_NODE_5841_length_345_cov_1.974265_g5751_i0 PRJNA534016 5841 345 1.974265 6.81121425 Caudoviricetes sp. 2832643 Viruses Viruses 424 6.01e-114   NTclustered gi|2914938318|gb|OR221696.1| 2832643 g5751 i0 89.381 11.4782608695652 339 32 98 3 9 345 27325 27661 MAG: Caudoviricetes sp. isolate MSP1347 genomic sequence blastn 3960 424 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
507641 507641 PRJNA534016_P_NODE_7141_length_316_cov_1.716049_g7051_i0 PRJNA534016 7141 316 1.716049 5.42271484 Caudoviricetes sp. 2832643 Viruses Viruses 518 2.4299999999999998e-142   NTclustered gi|2914971618|gb|OR222037.1| 2832643 g7051 i0 96.203 20.8512658227848 316 12 100 0 1 316 43199 42884 MAG: Caudoviricetes sp. isolate MSP0078 genomic sequence blastn 6589 518 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1782916 1782916 PRJNA534016_P_NODE_2742_length_494_cov_2.377672_g2652_i0 PRJNA534016 2742 494 2.377672 11.74569968 Pakpunavirus sp. 2833053 Viruses Viruses 507 8.559999999999998e-139   NTclustered gi|2780120392|gb|PP986816.1| 2833053 g2652 i0 87.248 1.37449392712551 447 53 90 4 50 494 4004 4448 MAG: Pakpunavirus sp. isolate vContig2 genomic sequence blastn 679 507 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Pakpunavirus Pakpunavirus sp.
1782966 1782966 PRJNA534016_P_NODE_6622_length_327_cov_1.811024_g6532_i0 PRJNA534016 6622 327 1.811024 5.92204848 Caudoviricetes sp. 2832643 Viruses Viruses 292 1.66e-74   NTclustered gi|2914804504|gb|OR221411.1| 2832643 g6532 i0 94.681 9.99388379204893 188 10 57 0 3 190 24546 24733 MAG: Caudoviricetes sp. isolate MSP1680 genomic sequence blastn 3268 292 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1782987 1782987 PRJNA534016_P_NODE_8282_length_295_cov_1.112613_g8192_i0 PRJNA534016 8282 295 1.112613 3.28220835 Caudoviricetes sp. 2832643 Viruses Viruses 172 2.0099999999999999e-38   NTclustered gi|2914952261|gb|OR221914.1| 2832643 g8192 i0 91.87 0.416949152542373 123 10 42 0 3 125 71419 71297 MAG: Caudoviricetes sp. isolate MSP0219 genomic sequence blastn 123 172 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3058442 3058442 PRJNA534016_P_NODE_2903_length_480_cov_1.916462_g2813_i0 PRJNA534016 2903 480 1.916462 9.1990176 Caudoviricetes sp. 2832643 Viruses Viruses 435 3.97e-117   NTclustered gi|2914946669|gb|OR221837.1| 2832643 g2813 i0 94.198 3.56458333333333 293 4 58 1 201 480 37587 37295 MAG: Caudoviricetes sp. isolate MSP1175 genomic sequence blastn 1711 435 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3058487 3058487 PRJNA534016_P_NODE_6223_length_336_cov_2.779468_g6133_i0 PRJNA534016 6223 336 2.779468 9.33901248 Pakpunavirus sp. 2833053 Viruses Viruses 549 9.219999999999997e-152   NTclustered gi|2780120392|gb|PP986816.1| 2833053 g6133 i0 96.131 8.46726190476191 336 13 100 0 1 336 11260 11595 MAG: Pakpunavirus sp. isolate vContig2 genomic sequence blastn 2845 549 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Pakpunavirus Pakpunavirus sp.
6885180 6885180 PRJNA534016_P_NODE_3166_length_459_cov_1.795337_g3076_i0 PRJNA534016 3166 459 1.795337 8.24059683 Caudoviricetes sp. 2832643 Viruses Viruses 787 0   NTclustered gi|2914991147|gb|OR222188.1| 2832643 g3076 i0 97.603 8.91067538126362 459 11 100 0 1 459 9421 8963 MAG: Caudoviricetes sp. isolate MSP0788 genomic sequence blastn 4090 787 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6885184 6885184 PRJNA534016_P_NODE_3526_length_436_cov_1.787879_g3436_i0 PRJNA534016 3526 436 1.787879 7.79515244 Caudoviricetes sp. 2832643 Viruses Viruses 473 7.58e-129   NTclustered gi|2914962068|gb|OR221989.1| 2832643 g3436 i0 97.81 3.91743119266055 274 6 63 0 4 277 69732 69459 MAG: Caudoviricetes sp. isolate MSP0135 genomic sequence blastn 1708 473 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7496346 7496346 PRJNA534016_P_NODE_1146_length_769_cov_1.678161_g1066_i0 PRJNA534016 1146 769 1.678161 12.90505809 Pakpunavirus 1921407 Viruses Viruses 1146 0   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g1066 i0 93.611 12.0416124837451 767 49 99 0 3 769 26531 25765 Pseudomonas phage PS-1 DNA, complete sequence blastn 9260 1155 0.992207792207792 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
10046711 10046711 PRJNA534016_P_NODE_14448_length_249_cov_1.982955_g14358_i0 PRJNA534016 14448 249 1.982955 4.93755795 root 1 Root_unresolved Root_unresolved 427 3.2e-115   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g14358 i0 97.59 2 249 6 100 0 1 249 53856 53608 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 498 427 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10711521 10711521 PRJNA534016_P_NODE_1549_length_656_cov_2.336192_g1463_i0 PRJNA534016 1549 656 2.336192 15.32541952 Pseudomonas phage PS-1 1573458 Viruses Viruses 228 1.01e-54   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g1463 i0 95.775 3.74542682926829 142 5 21 1 53 193 9812 9671 Pseudomonas phage PS-1 DNA, complete sequence blastn 2457 228 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
10711548 10711548 PRJNA534016_P_NODE_1729_length_624_cov_1.698730_g1642_i0 PRJNA534016 1729 624 1.69873 10.6000752 Caudoviricetes sp. 2832643 Viruses Viruses 520 1.41e-142   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g1642 i0 98 1.49358974358974 300 5 48 1 325 624 39247 39545 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 932 520 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10711630 10711630 PRJNA534016_P_NODE_4829_length_376_cov_1.976898_g4739_i0 PRJNA534016 4829 376 1.976898 7.43313648 Caudoviricetes sp. 2832643 Viruses Viruses 656 0   NTclustered gi|2914962068|gb|OR221989.1| 2832643 g4739 i0 98.138 4.68617021276596 376 7 100 0 1 376 62354 62729 MAG: Caudoviricetes sp. isolate MSP0135 genomic sequence blastn 1762 656 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11986161 11986161 PRJNA534016_P_NODE_12670_length_258_cov_1.794595_g12580_i0 PRJNA534016 12670 258 1.794595 4.6300551 Pseudomonas phage Lu11 1161927 Viruses Viruses 52.8 0.023   NTclustered gi|388684650|ref|NC_017972.1| 1161927 g12580 i0 100 0.108527131782946 28 0 11 0 170 197 131342 131369 Pseudomonas phage Lu11, complete genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Lu11
11986263 11986263 PRJNA534016_P_NODE_2290_length_542_cov_1.678038_g2201_i0 PRJNA534016 2290 542 1.678038 9.09496596 Caudoviricetes sp. 2832643 Viruses Viruses 719 0   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g2201 i0 91.028 3.69926199261993 535 44 99 2 1 535 42258 41728 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 2005 719 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11986338 11986338 PRJNA534016_P_NODE_890_length_877_cov_1.879353_g814_i0 PRJNA534016 890 877 1.879353 16.48192581 Caudoviricetes sp. 2832643 Viruses Viruses 1142 0   NTclustered gi|2914971618|gb|OR222037.1| 2832643 g814 i0 90.238 9.0285062713797 881 77 100 8 1 877 40499 41374 MAG: Caudoviricetes sp. isolate MSP0078 genomic sequence blastn 7918 1142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13261353 13261353 PRJNA534016_P_NODE_18831_length_233_cov_3.512500_g18741_i0 PRJNA534016 18831 233 3.5125 8.184125 Pseudomonas phage PS-1 1573458 Viruses Viruses 353 5.1e-93   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g18741 i0 93.991 1 233 14 100 0 1 233 28643 28411 Pseudomonas phage PS-1 DNA, complete sequence blastn 233 353 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
13261364 13261364 PRJNA534016_P_NODE_2151_length_556_cov_1.275362_g2062_i0 PRJNA534016 2151 556 1.275362 7.09101272 Caudoviricetes sp. 2832643 Viruses Viruses 503 1.2599999999999999e-137   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g2062 i0 85.366 3.28237410071942 492 65 88 7 2 489 53484 52996 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 1825 503 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13261433 13261433 PRJNA534016_P_NODE_7711_length_305_cov_2.112069_g7621_i0 PRJNA534016 7711 305 2.112069 6.44181045 Caudoviricetes sp. 2832643 Viruses Viruses 492 1.41e-134   NTclustered gi|2914991147|gb|OR222188.1| 2832643 g7621 i0 95.738 3.24590163934426 305 13 100 0 1 305 3680 3984 MAG: Caudoviricetes sp. isolate MSP0788 genomic sequence blastn 990 492 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14536284 14536284 PRJNA534016_P_NODE_1432_length_685_cov_3.084967_g1347_i0 PRJNA534016 1432 685 3.084967 21.13202395 Caudoviricetes sp. 2832643 Viruses Viruses 1112 0   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g1347 i0 96.047 22.8948905109489 683 27 99 0 1 683 42251 42933 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 15683 1112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15810168 15810168 PRJNA534016_P_NODE_11713_length_265_cov_2.505208_g11623_i0 PRJNA534016 11713 265 2.505208 6.6388012 Pseudomonas phage PS-1 1573458 Viruses Viruses 324 4.65e-84   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g11623 i0 88.679 1 265 30 100 0 1 265 27512 27776 Pseudomonas phage PS-1 DNA, complete sequence blastn 265 324 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
15810295 15810295 PRJNA534016_P_NODE_2733_length_495_cov_2.751185_g2643_i0 PRJNA534016 2733 495 2.751185 13.61836575 Pseudomonas phage PS-1 1573458 Viruses Viruses 616 1.3699999999999996e-171   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g2643 i0 89.113 1.0020202020202 496 52 100 2 1 495 28426 27932 Pseudomonas phage PS-1 DNA, complete sequence blastn 496 616 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
15810363 15810363 PRJNA534016_P_NODE_7733_length_305_cov_1.323276_g7643_i0 PRJNA534016 7733 305 1.323276 4.0359918 Caudoviricetes sp. 2832643 Viruses Viruses 388 1.91e-103   NTclustered gi|2914921208|gb|OR221390.1| 2832643 g7643 i0 90.476 10.4196721311475 294 28 96 0 12 305 30598 30305 MAG: Caudoviricetes sp. isolate MSP1706 genomic sequence blastn 3178 388 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15810368 15810368 PRJNA534016_P_NODE_853_length_898_cov_1.271515_g777_i0 PRJNA534016 853 898 1.271515 11.4182047 Caudoviricetes sp. 2832643 Viruses Viruses 1240 0   NTclustered gi|2914971618|gb|OR222037.1| 2832643 g777 i0 91.629 7.95879732739421 896 75 99 0 3 898 42020 42915 MAG: Caudoviricetes sp. isolate MSP0078 genomic sequence blastn 7147 1240 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18359007 18359007 PRJNA534016_P_NODE_16955_length_244_cov_0.900585_g16865_i0 PRJNA534016 16955 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.022   NTclustered gi|2914776434|gb|OR222139.1| 2832643 g16865 i0 100 0.114754098360656 28 0 11 0 7 34 15 42 MAG: Caudoviricetes sp. isolate MSP0844 genomic sequence blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19633572 19633572 PRJNA534016_P_NODE_1636_length_639_cov_2.028269_g1549_i0 PRJNA534016 1636 639 2.028269 12.96063891 Caudoviricetes sp. 2832643 Viruses Viruses 592 3.03e-164   NTclustered gi|2914945954|gb|OR221820.1| 2832643 g1549 i0 93.719 10.3176838810642 398 20 62 3 1 394 23453 23849 MAG: Caudoviricetes sp. isolate MSP1188 genomic sequence blastn 6593 592 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20909495 20909495 PRJNA534016_P_NODE_15317_length_247_cov_3.522989_g15227_i0 PRJNA534016 15317 247 3.522989 8.70178283 Pakpunavirus sp. 2833053 Viruses Viruses 411 3.199999999999999e-110   NTclustered gi|2780120392|gb|PP986816.1| 2833053 g15227 i0 97.5 12.5425101214575 240 6 97 0 8 247 3639 3400 MAG: Pakpunavirus sp. isolate vContig2 genomic sequence blastn 3098 411 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Pakpunavirus Pakpunavirus sp.
20909599 20909599 PRJNA534016_P_NODE_5197_length_363_cov_2.917241_g5107_i0 PRJNA534016 5197 363 2.917241 10.58958483 Caudoviricetes sp. 2832643 Viruses Viruses 204 8.98e-48   NTclustered gi|2914936328|gb|OR221666.1| 2832643 g5107 i0 96.721 3.68044077134986 122 4 34 0 1 122 18836 18715 MAG: Caudoviricetes sp. isolate MSP1379 genomic sequence blastn 1336 204 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20909631 20909631 PRJNA534016_P_NODE_7797_length_303_cov_4.021739_g7707_i0 PRJNA534016 7797 303 4.021739 12.18586917 Caudoviricetes sp. 2832643 Viruses Viruses 553 6.349999999999998e-153   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g7707 i0 99.669 38.5544554455446 302 1 99 0 2 303 51386 51687 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 11682 553 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22184331 22184331 PRJNA534016_P_NODE_2238_length_546_cov_2.911205_g2149_i0 PRJNA534016 2238 546 2.911205 15.8951793 Pakpunavirus sp. 2833053 Viruses Viruses 970 0   NTclustered gi|2780120392|gb|PP986816.1| 2833053 g2149 i0 98.718 4.34249084249084 546 7 100 0 1 546 7455 8000 MAG: Pakpunavirus sp. isolate vContig2 genomic sequence blastn 2371 970 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Pakpunavirus Pakpunavirus sp.
22184354 22184354 PRJNA534016_P_NODE_4338_length_396_cov_2.498452_g4248_i0 PRJNA534016 4338 396 2.498452 9.89386992 Caudoviricetes sp. 2832643 Viruses Viruses 636 8.229999999999999e-178   NTclustered gi|2914971618|gb|OR222037.1| 2832643 g4248 i0 95.696 6.3030303030303 395 17 99 0 2 396 23790 24184 MAG: Caudoviricetes sp. isolate MSP0078 genomic sequence blastn 2496 636 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23459784 23459784 PRJNA534016_P_NODE_3939_length_414_cov_2.304985_g3849_i0 PRJNA534016 3939 414 2.304985 9.5426379 Caudoviricetes sp. 2832643 Viruses Viruses 420 9.47e-113   NTclustered gi|2914818669|gb|OR222054.1| 2832643 g3849 i0 99.565 4.68599033816425 230 1 56 0 1 230 30444 30673 MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence blastn 1940 420 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24733406 24733406 PRJNA534016_P_NODE_15700_length_247_cov_0.885057_g15610_i0 PRJNA534016 15700 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 457 4.05e-124   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g15610 i0 100 1.14574898785425 247 0 100 0 1 247 42119 42365 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 283 457 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24733523 24733523 PRJNA534016_P_NODE_600_length_1056_cov_2.255341_g533_i0 PRJNA534016 600 1056 2.255341 23.81640096 Caudoviricetes sp. 2832643 Viruses Viruses 773 0   NTclustered gi|2914816844|gb|OR221975.1| 2832643 g533 i0 83.103 5.93276515151515 870 126 81 16 1 855 12039 11176 MAG: Caudoviricetes sp. isolate MSP0150 genomic sequence blastn 6265 773 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);;