RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1139127" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 32 ✖

bioproject 1

  • PRJNA1139127 · 32 ✖

analysis 1

  • blastn · 32 ✖

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
284881 284881 PRJNA1139127_P_NODE_10201_length_671_cov_1.928094_g9747_i0 PRJNA1139127 10201 671 1.928094 12.93751074 Bacteriophage sp. 38018 Viruses Viruses 1240 0   NTclustered gi|2052999736|tpg|BK031003.1| 38018 g9747 i0 100 87.2518628912072 671 0 100 0 1 671 19408 20078 MAG TPA_asm: Bacteriophage sp. isolate ctSAu12, partial genome blastn 58546 1240 1 Viruses               Bacteriophage sp.
284919 284919 PRJNA1139127_P_NODE_12901_length_575_cov_3.366534_g12422_i0 PRJNA1139127 12901 575 3.366534 19.3575705 Myoviridae sp. ctYA416 2825125 Viruses Viruses 1009 0   NTclustered gi|2053172929|tpg|BK016136.1| 2825125 g12422 i0 99.459 0.965217391304348 555 3 97 0 21 575 99252 99806 MAG TPA_asm: Myoviridae sp. ctYA416, partial genome blastn 555 1009 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae sp. ctYA416
285134 285134 PRJNA1139127_P_NODE_31401_length_310_cov_1.426160_g30908_i0 PRJNA1139127 31401 310 1.42616 4.421096 Caudoviricetes sp. 2832643 Viruses Viruses 556 5.03e-154   NTclustered gi|2914941530|gb|OR221752.1| 2832643 g30908 i0 100 1.6741935483871 301 0 97 0 1 301 39625 39925 MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence blastn 519 556 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
285274 285274 PRJNA1139127_P_NODE_44141_length_249_cov_0.886364_g43648_i0 PRJNA1139127 44141 249 0.886364 2.20704636 Natansvirus SnaPR1 3431060 Viruses Viruses 316 7.239999999999998e-82   NTclustered gi|1799110873|gb|MN844877.1| 2696336 g43648 i0 89.6 1.00401606425703 250 24 100 2 1 249 31558 31310 Sphaerotilus phage vB_SnaP-R1, complete genome blastn 250 316 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autoscriptoviridae Natansvirus Natansvirus SnaPR1
1559552 1559552 PRJNA1139127_P_NODE_13462_length_559_cov_2.886831_g12983_i0 PRJNA1139127 13462 559 2.886831 16.13738529 Caudoviricetes sp. 2832643 Viruses Viruses 992 0   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g12983 i0 100 1.68694096601073 537 0 96 0 2 538 35237 34701 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 943 992 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2835930 2835930 PRJNA1139127_P_NODE_36263_length_280_cov_1.874396_g35770_i0 PRJNA1139127 36263 280 1.874396 5.2483088 Caudoviricetes sp. 2832643 Viruses Viruses 518 2.12e-142   NTclustered gi|2059699590|tpg|BK029580.1| 2832643 g35770 i0 100 50.9892857142857 280 0 100 0 1 280 13470 13749 MAG TPA_asm: Caudoviricetes sp. isolate ct5sF18, partial genome blastn 14277 518 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3582752 3582752 PRJNA1139127_P_NODE_19263_length_436_cov_1.484848_g18772_i0 PRJNA1139127 19263 436 1.484848 6.47393728 Pahexavirus 1982251 Viruses Viruses 750 0   NTclustered gi|1631925795|ref|NC_041954.1| 1655013 g18772 i0 97.706 99.8967889908257 436 10 100 0 1 436 22430 22865 Propionibacterium phage Keiki, complete genome blastn 43555 750 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus keiki
5388412 5388412 PRJNA1139127_P_NODE_37665_length_273_cov_1.540000_g37172_i0 PRJNA1139127 37665 273 1.54 4.2042 Caudoviricetes sp. 2832643 Viruses Viruses 505 1.6e-138   NTclustered gi|2057978434|tpg|BK046703.1| 2832643 g37172 i0 100 1 273 0 100 0 1 273 9866 9594 MAG TPA_asm: Caudoviricetes sp. isolate ctLaR6, partial genome blastn 273 505 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6663146 6663146 PRJNA1139127_P_NODE_44646_length_248_cov_1.760000_g44153_i0 PRJNA1139127 44646 248 1.76 4.3648 Caudoviricetes sp. 2832643 Viruses Viruses 420 5.34e-113   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g44153 i0 100 1.83064516129032 227 0 92 0 1 227 2811 2585 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 454 420 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7937969 7937969 PRJNA1139127_P_NODE_12067_length_601_cov_1.909091_g11596_i0 PRJNA1139127 12067 601 1.909091 11.47363691 Caudoviricetes sp. 2832643 Viruses Viruses 1094 0   NTclustered gi|2914941530|gb|OR221752.1| 2832643 g11596 i0 100 4.48585690515807 592 0 99 0 1 592 47481 46890 MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence blastn 2696 1094 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7938189 7938189 PRJNA1139127_P_NODE_29667_length_323_cov_1.236000_g29175_i0 PRJNA1139127 29667 323 1.236 3.99228 Caudoviricetes sp. 2832643 Viruses Viruses 597 3.11e-166   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g29175 i0 100 3.05263157894737 323 0 100 0 1 323 7239 7561 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 986 597 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7938457 7938457 PRJNA1139127_P_NODE_9427_length_704_cov_0.987322_g8979_i0 PRJNA1139127 9427 704 0.987322 6.95074688 Caudoviricetes sp. 2832643 Viruses Viruses 1301 0   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g8979 i0 100 1 704 0 100 0 1 704 36403 35700 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 704 1301 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9212974 9212974 PRJNA1139127_P_NODE_16248_length_491_cov_1.992823_g15761_i0 PRJNA1139127 16248 491 1.992823 9.78476093 Caudoviricetes sp. 2832643 Viruses Viruses 902 0   NTclustered gi|2059699590|tpg|BK029580.1| 2832643 g15761 i0 99.796 68.6293279022403 491 1 100 0 1 491 10818 11308 MAG TPA_asm: Caudoviricetes sp. isolate ct5sF18, partial genome blastn 33697 902 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9212977 9212977 PRJNA1139127_P_NODE_16368_length_489_cov_1.478365_g15880_i0 PRJNA1139127 16368 489 1.478365 7.22920485 Caudoviricetes sp. 2832643 Viruses Viruses 787 0   NTclustered gi|2059830058|tpg|BK040145.1| 2832643 g15880 i0 95.706 1 489 21 100 0 1 489 9181 8693 MAG TPA_asm: Caudoviricetes sp. isolate cthf53, partial genome blastn 489 787 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9213372 9213372 PRJNA1139127_P_NODE_7068_length_841_cov_5.442708_g6676_i0 PRJNA1139127 7068 841 5.442708 45.77317428 Erysiphe necator associated abispo virus 7 2741923 Viruses Viruses 185 7.999999999999998e-42   NTclustered gi|1848976863|gb|MN611693.1| 2741923 g6676 i0 96.46 0.25089179548157 113 2 13 2 728 839 126 15 Erysiphe necator associated abispo virus 7 isolate PMS5_DN313 segment RNA1, complete sequence blastn 211 185 1 Viruses               Erysiphe necator associated abispo virus 7
10488455 10488455 PRJNA1139127_P_NODE_10889_length_643_cov_1.926316_g10425_i0 PRJNA1139127 10889 643 1.926316 12.38621188 Caudoviricetes sp. 2832643 Viruses Viruses 1188 0   NTclustered gi|2059699590|tpg|BK029580.1| 2832643 g10425 i0 100 45.2379471228616 643 0 100 0 1 643 10067 10709 MAG TPA_asm: Caudoviricetes sp. isolate ct5sF18, partial genome blastn 29088 1188 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10488825 10488825 PRJNA1139127_P_NODE_45729_length_247_cov_0.890805_g45236_i0 PRJNA1139127 45729 247 0.890805 2.20028835 Caudoviricetes sp. 2832643 Viruses Viruses 322 1.54e-83   NTclustered gi|2057071447|tpg|BK037730.1| 2832643 g45236 i0 90.323 4.01619433198381 248 21 99 3 2 247 14512 14266 MAG TPA_asm: Caudoviricetes sp. isolate cttsF19, partial genome blastn 992 322 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11763902 11763902 PRJNA1139127_P_NODE_41150_length_256_cov_1.322404_g40657_i0 PRJNA1139127 41150 256 1.322404 3.38535424 Coltivirus dermacentoris 3428066 Viruses Viruses 241 4.630000000000001e-59   NTclustered gi|2758887253|gb|PP473574.1| 46839 g40657 i0 95.973 1.57421875 149 5 58 1 1 149 4633 4486 MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence blastn 403 241 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Spinareoviridae Coltivirus Coltivirus dermacentoris
11763938 11763938 PRJNA1139127_P_NODE_44470_length_249_cov_0.875000_g43977_i0 PRJNA1139127 44470 249 0.875 2.17875 Capillovirus mali 28347 Viruses Viruses 436 5.32e-118   NTclustered gi|2108669534|gb|MZ126530.1| 28347 g43977 i0 100 94.6907630522088 236 0 95 0 1 236 6443 6208 Apple stem grooving virus isolate 13TF142, complete genome blastn 23578 436 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
13039112 13039112 PRJNA1139127_P_NODE_8151_length_772_cov_4.081545_g7734_i0 PRJNA1139127 8151 772 4.081545 31.5095274 Caudoviricetes sp. 2832643 Viruses Viruses 1378 0   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g7734 i0 99.866 1.94041450777202 749 1 97 0 1 749 9384 8636 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 1498 1378 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16862016 16862016 PRJNA1139127_P_NODE_10734_length_649_cov_2.010417_g10271_i0 PRJNA1139127 10734 649 2.010417 13.04760633 Chemarfal virus 258 3063149 Viruses Viruses 1110 0   NTclustered gi|2626079799|gb|OR270470.1| 3063149 g10271 i0 97.535 1 649 16 100 0 1 649 1403 2051 MAG: Chemarfal virus 258 isolate ML188 genomic sequence blastn 649 1110 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Chemarfal virus 258
16862473 16862473 PRJNA1139127_P_NODE_694_length_2314_cov_3.116020_g628_i0 PRJNA1139127 694 2314 3.11602 72.1047028 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 4108 0   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g628 i0 98.704 1.14909248055315 2315 28 100 2 1 2314 2636 323 Malassezia restricta virus MrV40L, complete genome blastn 2659 4108 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
17609951 17609951 PRJNA1139127_P_NODE_26814_length_346_cov_1.131868_g26322_i0 PRJNA1139127 26814 346 1.131868 3.91626328 Viruses 10239 Viruses Viruses 158 6.7499999999999985e-34   NTclustered gi|1955693358|gb|MW349128.1| 2797423 g26322 i0 76.667 2.60115606936416 300 61 86 8 48 344 192943 192650 Staphylococcus phage Machias, complete genome blastn 900 158 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Machias
18136675 18136675 PRJNA1139127_P_NODE_12255_length_595_cov_2.804598_g11783_i0 PRJNA1139127 12255 595 2.804598 16.6873581 Siphoviridae sp. ct3tr1 2827773 Viruses Viruses 974 0   NTclustered gi|2052884511|tpg|BK032877.1| 2827773 g11783 i0 97.217 96.5226890756303 575 16 97 0 21 595 19385 18811 MAG TPA_asm: Siphoviridae sp. ct3tr1, partial genome blastn 57431 974 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ct3tr1
18136877 18136877 PRJNA1139127_P_NODE_28075_length_335_cov_1.774809_g27583_i0 PRJNA1139127 28075 335 1.774809 5.94561015 Caudoviricetes sp. 2832643 Viruses Viruses 599 8.999999999999997e-167   NTclustered gi|2914941530|gb|OR221752.1| 2832643 g27583 i0 99.694 0.976119402985075 327 1 98 0 9 335 39241 39567 MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence blastn 327 599 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18137004 18137004 PRJNA1139127_P_NODE_41395_length_255_cov_1.302198_g40902_i0 PRJNA1139127 41395 255 1.302198 3.3206049 Cutibacterium phage P104B 2686216 Viruses Viruses 351 2.04e-92   NTclustered gi|1789794947|gb|MN813675.1| 2686216 g40902 i0 94.714 89.5607843137255 227 11 89 1 9 234 23272 23498 Cutibacterium phage P104B, complete genome blastn 22838 351 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Cutibacterium phage P104B
20686541 20686541 PRJNA1139127_P_NODE_27797_length_337_cov_1.784091_g27305_i0 PRJNA1139127 27797 337 1.784091 6.01238667 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 571 1.97e-158   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g27305 i0 99.367 0.937685459940653 316 1 94 1 22 337 1 315 Malassezia restricta virus MrV40L, complete genome blastn 316 571 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
23237452 23237452 PRJNA1139127_P_NODE_2759_length_1373_cov_2.153846_g2535_i0 PRJNA1139127 2759 1373 2.153846 29.57230558 Caudoviricetes sp. 2832643 Viruses Viruses 2531 0   NTclustered gi|2059699590|tpg|BK029580.1| 2832643 g2535 i0 99.927 75.0203932993445 1373 1 100 0 1 1373 11324 12696 MAG TPA_asm: Caudoviricetes sp. isolate ct5sF18, partial genome blastn 103003 2531 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23237514 23237514 PRJNA1139127_P_NODE_32919_length_300_cov_1.352423_g32426_i0 PRJNA1139127 32919 300 1.352423 4.057269 Caudoviricetes sp. 2832643 Viruses Viruses 555 1.7399999999999995e-153   NTclustered gi|2057844767|tpg|BK055780.1| 2832643 g32426 i0 100 2 300 0 100 0 1 300 35260 35559 MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome blastn 600 555 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23237591 23237591 PRJNA1139127_P_NODE_41159_length_256_cov_1.278689_g40666_i0 PRJNA1139127 41159 256 1.278689 3.27344384 Myoviridae sp. ctYA416 2825125 Viruses Viruses 324 4.47e-84   NTclustered gi|2053172929|tpg|BK016136.1| 2825125 g40666 i0 89.453 1 256 27 100 0 1 256 15210 15465 MAG TPA_asm: Myoviridae sp. ctYA416, partial genome blastn 256 324 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae sp. ctYA416
24511055 24511055 PRJNA1139127_P_NODE_30300_length_318_cov_1.587755_g29808_i0 PRJNA1139127 30300 318 1.587755 5.0490609 Caudoviricetes sp. 2832643 Viruses Viruses 588 1.84e-163   NTclustered gi|2056745870|tpg|BK045204.1| 2832643 g29808 i0 100 13.7421383647799 318 0 100 0 1 318 3024 2707 MAG TPA_asm: Caudoviricetes sp. isolate ctjQv2, partial genome blastn 4370 588 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24511340 24511340 PRJNA1139127_P_NODE_9280_length_711_cov_1.189655_g8833_i0 PRJNA1139127 9280 711 1.189655 8.45844705 Caudoviricetes sp. 2832643 Viruses Viruses 1314 0   NTclustered gi|2059699590|tpg|BK029580.1| 2832643 g8833 i0 100 63.6497890295359 711 0 100 0 1 711 13414 12704 MAG TPA_asm: Caudoviricetes sp. isolate ct5sF18, partial genome blastn 45255 1314 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);;