RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 17 ✖

bioproject 1

  • PRJNA358009 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
2348461 2348461 PRJNA358009_P_NODE_902_length_390_cov_165.199413_g843_i0 PRJNA358009 902 390 165.199413 644.27771069999994 Autosignataviridae 3424636 Viruses Viruses 702 0   NTclustered gi|15462|emb|Y00105.1| 10761 g843 i0 99.739 11.7692307692308 383 1 98 0 1 383 1262 880 Bacteriophage SP6 gene for RNA polymerase blastn 4590 702 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
2948916 2948916 PRJNA358009_P_NODE_43_length_1058_cov_90.565907_g23_i0 PRJNA358009 43 1058 90.565907 958.18729606 Caudoviricetes sp. 2832643 Viruses Viruses 743 0   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g23 i0 97.907 330.793950850662 430 8 47 1 1 429 17990 18419 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 349980 743 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7450981 7450981 PRJNA358009_P_NODE_7446_length_242_cov_168.948187_g7378_i0 PRJNA358009 7446 242 168.948187 408.85461254 Autosignataviridae 3424636 Viruses Viruses 377 3.17e-100   NTclustered gi|15462|emb|Y00105.1| 10761 g7378 i0 100 8.19834710743802 204 0 84 0 18 221 2040 2243 Bacteriophage SP6 gene for RNA polymerase blastn 1984 377 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
8725735 8725735 PRJNA358009_P_NODE_847_length_401_cov_168.019886_g789_i0 PRJNA358009 847 401 168.019886 673.75974286 Autosignataviridae 3424636 Viruses Viruses 697 0   NTclustered gi|15462|emb|Y00105.1| 10761 g789 i0 100 10.3316708229426 377 0 94 0 8 384 1638 1262 Bacteriophage SP6 gene for RNA polymerase blastn 4143 697 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
12551591 12551591 PRJNA358009_P_NODE_7310_length_255_cov_62.368932_g7242_i0 PRJNA358009 7310 255 62.368932 159.0407766 Autosignataviridae 3424636 Viruses Viruses 460 3.25e-125   NTclustered gi|15462|emb|Y00105.1| 10761 g7242 i0 100 16.4509803921569 249 0 98 0 7 255 236 484 Bacteriophage SP6 gene for RNA polymerase blastn 4195 460 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
13152027 13152027 PRJNA358009_P_NODE_5971_length_327_cov_1.582734_g5908_i0 PRJNA358009 5971 327 1.582734 5.17554018 Caudoviricetes sp. 2832643 Viruses Viruses 185 2.91e-42   NTclustered gi|2054537789|tpg|BK047792.1| 2832643 g5908 i0 100 4.217125382263 100 0 59 0 228 327 46433 46334 MAG TPA_asm: Caudoviricetes sp. isolate cta1k23, partial genome blastn 1379 185 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15700860 15700860 PRJNA358009_P_NODE_14973_length_163_cov_3.701754_g14904_i0 PRJNA358009 14973 163 3.701754 6.03385902 Caudoviricetes sp. 2832643 Viruses Viruses 84.2 4.82e-12   NTclustered gi|2914823328|gb|OR222120.1| 2832643 g14904 i0 86.842 0.650306748466258 76 9 46 1 8 82 18400 18325 MAG: Caudoviricetes sp. isolate MSP0867 genomic sequence blastn 106 84.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16975687 16975687 PRJNA358009_P_NODE_2454_length_327_cov_3.884892_g2391_i0 PRJNA358009 2454 327 3.884892 12.70359684 Caudoviricetes sp. 2832643 Viruses Viruses 62.1 5.11e-5   NTclustered gi|2054712798|tpg|BK053261.1| 2832643 g2391 i0 89.583 0.146788990825688 48 5 15 0 12 59 7925 7972 MAG TPA_asm: Caudoviricetes sp. isolate ct0r67, partial genome blastn 48 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16975717 16975717 PRJNA358009_P_NODE_5414_length_327_cov_1.766187_g5351_i0 PRJNA358009 5414 327 1.766187 5.77543149 Caudoviricetes sp. 2832643 Viruses Viruses 159 1.76e-34   NTclustered gi|2054736228|tpg|BK038834.1| 2832643 g5351 i0 93 2.19877675840979 100 7 31 0 228 327 35430 35331 MAG TPA_asm: Caudoviricetes sp. isolate ct18f3, partial genome blastn 719 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18249777 18249777 PRJNA358009_P_NODE_1115_length_363_cov_50.971338_g1054_i0 PRJNA358009 1115 363 50.971338 185.02595694 Caudoviricetes sp. 2832643 Viruses Viruses 372 2.3299999999999995e-98   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g1054 i0 92.941 219.798898071625 255 18 70 0 1 255 17735 17989 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 79787 372 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18249947 18249947 PRJNA358009_P_NODE_3735_length_327_cov_2.474820_g3672_i0 PRJNA358009 3735 327 2.47482 8.0926614 Caudoviricetes sp. 2832643 Viruses Viruses 137 8.25e-28   NTclustered gi|2914836155|gb|OR222699.1| 2832643 g3672 i0 91.837 3.04587155963303 98 8 30 0 227 324 29511 29414 MAG: Caudoviricetes sp. isolate MSP0229 genomic sequence blastn 996 137 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19524187 19524187 PRJNA358009_P_NODE_8396_length_198_cov_4.114094_g8327_i0 PRJNA358009 8396 198 4.114094 8.14590612 Caudoviricetes sp. 2832643 Viruses Viruses 231 2.0499999999999996e-56   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g8327 i0 88.601 130.848484848485 193 18 96 4 1 191 17990 18180 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 25908 231 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21474747 21474747 PRJNA358009_P_NODE_7797_length_220_cov_46.602339_g7728_i0 PRJNA358009 7797 220 46.602339 102.5251458 Autosignataviridae 3424636 Viruses Viruses 344 2.87e-90   NTclustered gi|15462|emb|Y00105.1| 10761 g7728 i0 100 8.43636363636364 186 0 85 0 28 213 2464 2279 Bacteriophage SP6 gene for RNA polymerase blastn 1856 344 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
22749770 22749770 PRJNA358009_P_NODE_13338_length_166_cov_4.589744_g13269_i0 PRJNA358009 13338 166 4.589744 7.61897504 Pahexavirus 1982251 Viruses Viruses 279 5.86e-71   NTclustered gi|1070064454|ref|NC_031003.1| 1654781 g13269 i0 98.125 96.789156626506 160 3 96 0 4 163 11929 11770 Propionibacterium phage Moyashi, complete genome blastn 16067 279 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Propionibacterium phage Moyashi
22749911 22749911 PRJNA358009_P_NODE_838_length_402_cov_169.087819_g780_i0 PRJNA358009 838 402 169.087819 679.73303238 Autosignataviridae 3424636 Viruses Viruses 737 0   NTclustered gi|15462|emb|Y00105.1| 10761 g780 i0 99.751 9.99751243781095 402 1 100 0 1 402 2040 1639 Bacteriophage SP6 gene for RNA polymerase blastn 4019 737 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6
23350329 23350329 PRJNA358009_P_NODE_7239_length_262_cov_130.014085_g7171_i0 PRJNA358009 7239 262 130.014085 340.6369027 Zindervirus SP6 194966 Viruses Viruses 372 1.62e-98   NTclustered gi|31880044|ref|NC_004831.2| 2907955 g7171 i0 100 5.35496183206107 201 0 77 0 46 246 6018 5818 Enterobacteria phage SP6, complete genome blastn 1403 372 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autosignataviridae Zindervirus Zindervirus SP6
25299186 25299186 PRJNA358009_P_NODE_1960_length_330_cov_188.266904_g1897_i0 PRJNA358009 1960 330 188.266904 621.2807832 Autosignataviridae 3424636 Viruses Viruses 527 4.229999999999999e-145   NTclustered gi|15462|emb|Y00105.1| 10761 g1897 i0 99.653 9.84545454545455 288 1 87 0 22 309 588 875 Bacteriophage SP6 gene for RNA polymerase blastn 3249 527 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lederbergvirus Lederbergvirus Sf6

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