RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 4 ✖

bioproject 1

  • PRJNA421571 · 4 ✖

analysis 1

  • blastn · 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
5526548 5526548 PRJNA421571_P_NODE_36945_length_498_cov_1.472941_g34402_i0 PRJNA421571 36945 498 1.472941 7.33524618 Arthrobacter phage Berka 2832316 Viruses Viruses 52.8 0.049   NTclustered gi|2513086167|gb|OQ938593.1| 2832316 g34402 i0 100 0.0562248995983936 28 0 6 0 12 39 1828 1801 Arthrobacter phage Berka, complete genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Arthrobacter phage Berka
18275305 18275305 PRJNA421571_P_NODE_64055_length_324_cov_1.533865_g61506_i0 PRJNA421571 64055 324 1.533865 4.9697226 Micrococcus phage Olihed 3092209 Viruses Viruses 52.8 0.03   NTclustered gi|2716668726|gb|OR756648.1| 3092209 g61506 i0 100 0.0864197530864197 28 0 9 0 82 109 26939 26912 Micrococcus phage Olihed, complete genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Micrococcus phage Olihed
18275968 18275968 PRJNA421571_P_NODE_89455_length_255_cov_2.093407_g86906_i0 PRJNA421571 89455 255 2.093407 5.33818785 Omegavirus littlee 1034111 Viruses Viruses 63.9 1.07e-5   NTclustered gi|1666222188|ref|NC_042322.1| 2922212 g86906 i0 97.297 3.28235294117647 37 1 15 0 92 128 62508 62472 Mycobacterium virus LittleE, complete genome blastn 837 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Omegavirus Omegavirus littlee
24650311 24650311 PRJNA421571_P_NODE_77820_length_282_cov_1.473684_g75271_i0 PRJNA421571 77820 282 1.473684 4.15578888 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.026   NTclustered gi|2054695587|tpg|BK052891.1| 2832643 g75271 i0 100 0.49645390070922 28 0 10 0 31 58 33622 33595 MAG TPA_asm: Caudoviricetes sp. isolate ct0OI38, partial genome blastn 140 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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