RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB28589", tax_phylum = "Uroviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28589 · 4 ✖

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
5128320 5128320 PRJEB28589_S_NODE_1145_length_502_cov_5.389011_g1041_i0 PRJEB28589 1145 502 5.389011 27.05283522 Caudoviricetes sp. 2832643 Viruses Viruses 58.4 0.001   NTclustered gi|2052202977|tpg|BK056165.1| 2832643 g1041 i0 100 0.0617529880478088 31 0 6 0 268 298 12641 12611 MAG TPA_asm: Caudoviricetes sp. isolate ctF2x39, partial genome blastn 31 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7678256 7678256 PRJEB28589_S_NODE_8187_length_274_cov_4.026432_g8079_i0 PRJEB28589 8187 274 4.026432 11.03242368 Irtavirus CFP3 3429987 Viruses Viruses 396 1.0099999999999997e-105   NTclustered gi|2430282791|gb|OQ025560.1| 3017169 g8079 i0 92.701 11.8029197080292 274 20 100 0 1 274 20082 20355 Pasteurella phage vB_PmuM_CFP3, complete genome blastn 3234 396 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Irtavirus Irtavirus CFP3
10228710 10228710 PRJEB28589_S_NODE_15469_length_183_cov_1.875000_g15361_i0 PRJEB28589 15469 183 1.875 3.43125 Caudoviricetes sp. 2832643 Viruses Viruses 305 1.08e-78   NTclustered gi|2057906025|tpg|BK051241.1| 2832643 g15361 i0 96.721 11.8688524590164 183 6 100 0 1 183 19437 19255 MAG TPA_asm: Caudoviricetes sp. isolate ctSX721, partial genome blastn 2172 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29117678 29117678 PRJEB28589_S_NODE_3929_length_346_cov_4.635452_g3821_i0 PRJEB28589 3929 346 4.635452 16.03866392 uncultured phage cr111_1 2772071 Viruses Viruses 122 3.28e-32   NR YP_010111344.1 2772071 g3821 i0 61.7 0.927745664739884 107 41 92.8 0 20 340 3 109 YP_010111344.1 homing endonuclease [uncultured phage cr111_1] diamond 321 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Crassvirales Steigviridae Lahndsivirus Lahndsivirus rarus

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