RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA888104" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA888104 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
862197 862197 PRJNA888104_P_NODE_15501_length_261_cov_2.098958_g15432_i0 PRJNA888104 15501 261 2.098958 5.47828038 Escherichia phage TR1 2972435 Viruses Viruses 483 7.12e-132   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g15432 i0 100 2 261 0 100 0 1 261 19753 19493 Escherichia phage TR1, complete genome blastn 522 483 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
2137575 2137575 PRJNA888104_P_NODE_14242_length_272_cov_1.596059_g14173_i0 PRJNA888104 14242 272 1.596059 4.34128048 Escherichia phage TR1 2972435 Viruses Viruses 503 5.729999999999998e-138   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g14173 i0 100 65.0404411764706 272 0 100 0 1 272 22688 22417 Escherichia phage TR1, complete genome blastn 17691 503 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
5965635 5965635 PRJNA888104_P_NODE_4525_length_453_cov_1.752604_g4456_i0 PRJNA888104 4525 453 1.752604 7.93929612 Christensenvirus IME542 2734000 Viruses Viruses 538 2.7599999999999993e-148   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g4456 i0 99.66 28.0397350993377 294 1 100 0 1 294 13291 13584 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 12702 538 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
11065794 11065794 PRJNA888104_P_NODE_20429_length_233_cov_0.890244_g20360_i0 PRJNA888104 20429 233 0.890244 2.07426852 Caudoviricetes sp. 2832643 Viruses Viruses 403 4.9999999999999985e-108   NTclustered gi|2915033111|gb|OR222673.1| 2832643 g20360 i0 97.854 15.450643776824 233 5 100 0 1 233 95167 94935 MAG: Caudoviricetes sp. isolate MSP0260 genomic sequence blastn 3600 403 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12341426 12341426 PRJNA888104_P_NODE_22010_length_230_cov_0.906832_g21941_i0 PRJNA888104 22010 230 0.906832 2.0857136 Christensenvirus IME542 2734000 Viruses Viruses 420 4.89e-113   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g21941 i0 99.565 1 230 1 100 0 1 230 20563 20792 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 230 420 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
14890130 14890130 PRJNA888104_P_NODE_15832_length_259_cov_1.389474_g15763_i0 PRJNA888104 15832 259 1.389474 3.59873766 Christensenvirus IME542 2734000 Viruses Viruses 473 4.25e-129   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g15763 i0 99.614 1 259 1 100 0 1 259 24906 24648 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 259 473 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
16164837 16164837 PRJNA888104_P_NODE_13013_length_284_cov_1.358140_g12944_i0 PRJNA888104 13013 284 1.35814 3.8571176 Christensenvirus IME542 2734000 Viruses Viruses 525 1.2899999999999994e-144   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g12944 i0 100 1.99647887323944 284 0 100 0 1 284 19114 18831 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 567 525 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
20367908 20367908 PRJNA888104_P_NODE_10356_length_313_cov_0.897541_g10287_i0 PRJNA888104 10356 313 0.897541 2.80930333 Christensenvirus 2732061 Viruses Viruses 579 1.0899999999999999e-160   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g10287 i0 100 22.9201277955272 313 0 100 0 1 313 43386 43074 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 7174 579 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542

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