RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 26 ✖

bioproject 1

  • PRJNA796753 · 26 ✖

analysis 1

  • blastn · 26 ✖

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
2056728 2056728 PRJNA796753_P_NODE_52362_length_242_cov_0.911243_g52050_i0 PRJNA796753 52362 242 0.911243 2.20520806 Caudoviricetes sp. 2832643 Viruses Viruses 425 1.11e-114   NTclustered gi|2059603068|tpg|BK037131.1| 2832643 g52050 i0 98.354 37.1694214876033 243 3 100 1 1 242 8515 8273 MAG TPA_asm: Caudoviricetes sp. isolate ctkBe9, partial genome blastn 8995 425 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3331853 3331853 PRJNA796753_P_NODE_44303_length_248_cov_0.880000_g43991_i0 PRJNA796753 44303 248 0.88 2.1824 Brevundimonas phage vB_BpoS-Bambus 2948597 Viruses Viruses 224 4.489999999999999e-54   NTclustered gi|2264474154|gb|ON529853.1| 2948597 g43991 i0 83.267 1.01209677419355 251 34 99 6 2 248 241742 241496 Brevundimonas phage vB_BpoS-Bambus, complete genome blastn 251 224 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Brevundimonas phage vB_BpoS-Bambus
4609128 4609128 PRJNA796753_P_NODE_44344_length_248_cov_0.880000_g44032_i0 PRJNA796753 44344 248 0.88 2.1824 Zebrafish picornavirus 1 2304617 Viruses Viruses 453 5.2600000000000005e-123   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g44032 i0 99.597 3 248 1 100 0 1 248 557 310 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 744 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5884173 5884173 PRJNA796753_P_NODE_26125_length_294_cov_1.262443_g25813_i0 PRJNA796753 26125 294 1.262443 3.71158242 Caudoviricetes sp. 2832643 Viruses Viruses 438 1.7899999999999995e-118   NTclustered gi|2058128472|tpg|BK034062.1| 2832643 g25813 i0 93.537 440.78231292517 294 19 100 0 1 294 39540 39833 MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome blastn 129590 438 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5884328 5884328 PRJNA796753_P_NODE_51325_length_243_cov_0.905882_g51013_i0 PRJNA796753 51325 243 0.905882 2.20129326 Caudoviricetes sp. 2832643 Viruses Viruses 316 7.03e-82   NTclustered gi|2054710215|tpg|BK053201.1| 2832643 g51013 i0 91.416 49.0617283950617 233 17 96 1 9 241 5237 5008 MAG TPA_asm: Caudoviricetes sp. isolate ctgME2, partial genome blastn 11922 316 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7159201 7159201 PRJNA796753_P_NODE_49346_length_244_cov_0.900585_g49034_i0 PRJNA796753 49346 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 451 1.86e-122   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g49034 i0 100 1 244 0 100 0 1 244 37737 37494 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 244 451 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7159220 7159220 PRJNA796753_P_NODE_53466_length_241_cov_1.589286_g53154_i0 PRJNA796753 53466 241 1.589286 3.83017926 Cutibacterium phage vB_CacS-HV1 3236917 Viruses Viruses 374 4.079999999999998e-99   NTclustered gi|2780182484|gb|PQ037195.1| 3236917 g53154 i0 95.69 97.3526970954357 232 10 96 0 10 241 25294 25525 Cutibacterium phage vB_CacS-HV1, complete genome blastn 23462 374 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Cutibacterium phage vB_CacS-HV1
7594834 7594834 PRJNA796753_P_NODE_38346_length_252_cov_1.446927_g38034_i0 PRJNA796753 38346 252 1.446927 3.64625604 root 1 Root_unresolved Root_unresolved 466 6.89e-127   NTclustered gi|2059799285|tpg|BK039676.1| 2832643 g38034 i0 100 23.8214285714286 252 0 100 0 1 252 5609 5860 MAG TPA_asm: Caudoviricetes sp. isolate ctIVQ1, partial genome blastn 6003 466 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8433667 8433667 PRJNA796753_P_NODE_10067_length_436_cov_1.550964_g9755_i0 PRJNA796753 10067 436 1.550964 6.76220304 Alexandravirus alexandra 2734081 Viruses Viruses 54.7 0.012   NTclustered gi|1842016503|ref|NC_047995.1| 2201424 g9755 i0 100 0.0665137614678899 29 0 7 0 77 105 106505 106533 Erwinia phage vB_EamM_Alexandra, complete genome blastn 29 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Alexandravirus Alexandravirus alexandra
8433852 8433852 PRJNA796753_P_NODE_40047_length_250_cov_1.740113_g39735_i0 PRJNA796753 40047 250 1.740113 4.3502825 Caudoviricetes sp. 2832643 Viruses Viruses 326 1.21e-84   NTclustered gi|2057959827|tpg|BK046364.1| 2832643 g39735 i0 96.923 6.756 195 4 78 2 8 202 10590 10398 MAG TPA_asm: Caudoviricetes sp. isolate ctThn6, partial genome blastn 1689 326 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8433863 8433863 PRJNA796753_P_NODE_42407_length_249_cov_0.875000_g42095_i0 PRJNA796753 42407 249 0.875 2.17875 Pseudomonas phage HHBS14_1 3390389 Viruses Viruses 399 6.989999999999999e-107   NTclustered gi|2905008725|gb|PQ287643.1| 3390389 g42095 i0 95.582 2 249 11 100 0 1 249 25365 25117 Pseudomonas phage HHBS14_1, complete genome blastn 498 399 1 Viruses               Pseudomonas phage HHBS14_1
10984663 10984663 PRJNA796753_P_NODE_31729_length_274_cov_1.532338_g31417_i0 PRJNA796753 31729 274 1.532338 4.19860612 Caudoviricetes sp. 2832643 Viruses Viruses 507 4.47e-139   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g31417 i0 100 1 274 0 100 0 1 274 47075 47348 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 274 507 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14809162 14809162 PRJNA796753_P_NODE_15972_length_359_cov_1.272727_g15660_i0 PRJNA796753 15972 359 1.272727 4.56908993 Zebrafish picornavirus 1 2304617 Viruses Viruses 586 7.539999999999998e-163   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g15660 i0 96.1 3 359 14 100 0 1 359 6215 5857 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1077 586 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14809165 14809165 PRJNA796753_P_NODE_16672_length_353_cov_1.307143_g16360_i0 PRJNA796753 16672 353 1.307143 4.61421479 Zebrafish picornavirus 1 2304617 Viruses Viruses 614 3.389999999999999e-171   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g16360 i0 98.017 3 353 7 100 0 1 353 7064 6712 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1059 614 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14809321 14809321 PRJNA796753_P_NODE_40792_length_250_cov_0.870056_g40480_i0 PRJNA796753 40792 250 0.870056 2.17514 Potyvirus phaseoluteum 3240594 Viruses Viruses 52.8 0.023   NTclustered gi|6409350|gb|AF192783.1|AF192783 12197 g40480 i0 100 0.112 28 0 11 0 84 111 38 65 Bean yellow mosaic virus strain LCbk-NN polyprotein mRNA, partial cds blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus phaseoluteum
14809348 14809348 PRJNA796753_P_NODE_45392_length_247_cov_0.885057_g45080_i0 PRJNA796753 45392 247 0.885057 2.18609079 Ripafren virus 3130475 Viruses Viruses 348 2.5400000000000004e-91   NTclustered gi|2717319844|gb|PP172777.1| 3130475 g45080 i0 92.308 496.113360323887 247 16 100 2 1 247 946 703 MAG: Ripafren virus isolate KCAP1_k141_546482 genomic sequence blastn 122540 348 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Ripafren virus
16083356 16083356 PRJNA796753_P_NODE_52833_length_242_cov_0.911243_g52521_i0 PRJNA796753 52833 242 0.911243 2.20520806 Caudoviricetes sp. 2832643 Viruses Viruses 274 4.27e-69   NTclustered gi|2914984909|gb|OR222109.1| 2832643 g52521 i0 88.839 1.85537190082645 224 24 92 1 20 242 234656 234879 MAG: Caudoviricetes sp. isolate MSP0001 genomic sequence blastn 449 274 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17359030 17359030 PRJNA796753_P_NODE_25954_length_295_cov_1.243243_g25642_i0 PRJNA796753 25954 295 1.243243 3.66756685 Caudoviricetes sp. 2832643 Viruses Viruses 501 2.259999999999999e-137   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g25642 i0 97.288 25.8169491525424 295 8 100 0 1 295 43500 43206 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 7616 501 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17359102 17359102 PRJNA796753_P_NODE_39514_length_251_cov_0.865169_g39202_i0 PRJNA796753 39514 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 425 1.16e-114   NTclustered gi|2914837892|gb|OR222723.1| 2832643 g39202 i0 97.211 101.808764940239 251 7 100 0 1 251 11394 11644 MAG: Caudoviricetes sp. isolate MSP0643 genomic sequence blastn 25554 425 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17794399 17794399 PRJNA796753_P_NODE_34494_length_265_cov_1.557292_g34182_i0 PRJNA796753 34494 265 1.557292 4.1268238 Pahexavirus 1982251 Viruses Viruses 446 9.51e-121   NTclustered gi|330858398|ref|NC_015454.1| 504501 g34182 i0 96.981 99.8641509433962 265 8 100 0 1 265 6036 5772 Propionibacterium phage PAD20 endogenous virus, complete genome blastn 26464 448 0.995535714285714 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PAD20
18632072 18632072 PRJNA796753_P_NODE_14755_length_370_cov_3.582492_g14443_i0 PRJNA796753 14755 370 3.582492 13.2552204 Sopigix virus 3131702 Viruses Viruses 97.1 1.6e-15   NTclustered gi|2717323189|gb|PP174003.1| 3131702 g14443 i0 81.667 18.6918918918919 120 19 32 3 227 344 172 54 MAG: Sopigix virus isolate SP1B_k141_275369 genomic sequence blastn 6916 97.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Sopigix virus
19907461 19907461 PRJNA796753_P_NODE_24376_length_304_cov_1.000000_g24064_i0 PRJNA796753 24376 304 1 3.04 Zebrafish picornavirus 1 2304617 Viruses Viruses 512 1.08e-140   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g24064 i0 97.039 3 304 9 100 0 1 304 2012 2315 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 912 512 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22894360 22894360 PRJNA796753_P_NODE_47918_length_245_cov_0.895349_g47606_i0 PRJNA796753 47918 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 211 3.45e-50   NTclustered gi|2914921414|gb|OR221392.1| 2832643 g47606 i0 95.455 4.83673469387755 132 6 54 0 114 245 33391 33522 MAG: Caudoviricetes sp. isolate MSP1708 genomic sequence blastn 1185 211 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23733547 23733547 PRJNA796753_P_NODE_44919_length_247_cov_0.885057_g44607_i0 PRJNA796753 44919 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 233 7.429999999999999e-57   NTclustered gi|2915037218|gb|OR222698.1| 2832643 g44607 i0 93.59 7.81376518218624 156 10 63 0 92 247 36206 36051 MAG: Caudoviricetes sp. isolate MSP0233 genomic sequence blastn 1930 233 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23733548 23733548 PRJNA796753_P_NODE_45139_length_247_cov_0.885057_g44827_i0 PRJNA796753 45139 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 193 1.26e-44   NTclustered gi|2915037218|gb|OR222698.1| 2832643 g44827 i0 93.13 6.57894736842105 131 9 53 0 9 139 57064 56934 MAG: Caudoviricetes sp. isolate MSP0233 genomic sequence blastn 1625 193 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
25007055 25007055 PRJNA796753_P_NODE_20680_length_325_cov_1.222222_g20368_i0 PRJNA796753 20680 325 1.222222 3.9722215 Zebrafish picornavirus 1 2304617 Viruses Viruses 540 5.35e-149   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g20368 i0 96.615 3 325 11 100 0 1 325 1352 1676 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 975 540 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1

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