RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 3 ✖

bioproject 1

  • PRJNA1174234 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
316272 316272 PRJNA1174234_P_NODE_6641_length_529_cov_1.758772_g6445_i0 PRJNA1174234 6641 529 1.758772 9.30390388 Escherichia virus KFS-EC3 2836074 Viruses Viruses 60.2 3.1e-4   NTclustered gi|2045607952|gb|MZ065353.1| 2836074 g6445 i0 97.143 0.130434782608696 35 1 7 0 260 294 127645 127611 Escherichia virus KFS-EC3, complete genome blastn 69 60.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Escherichia virus KFS-EC3
2866876 2866876 PRJNA1174234_P_NODE_13223_length_378_cov_3.331148_g13027_i0 PRJNA1174234 13223 378 3.331148 12.59173944 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.036   NTclustered gi|2056962135|tpg|BK022939.1| 2832643 g13027 i0 100 0.148148148148148 28 0 7 0 214 241 7338 7365 MAG TPA_asm: Caudoviricetes sp. isolate ctDW64, partial genome blastn 56 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24542072 24542072 PRJNA1174234_P_NODE_21540_length_297_cov_4.562500_g21344_i0 PRJNA1174234 21540 297 4.5625 13.550625 Burkholderia phage BCSR5 2805747 Viruses Viruses 67.6 9.85e-7   NTclustered gi|1971775256|gb|MW460245.1| 2805747 g21344 i0 100 0.508417508417508 36 0 12 0 140 175 654 619 Burkholderia phage BCSR5, complete genome blastn 151 67.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage BCSR5

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