RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA896554" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA896554 · 4 ✖

analysis 1

  • diamond · 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
17450690 17450690 PRJNA896554_P_NODE_88994_length_364_cov_1.587629_g81454_i0 PRJNA896554 88994 364 1.587629 5.77896956 Escherichia phage IMM- 3102713 Viruses Viruses 181 1.04e-54   NR ATI17120.1 2041759 g81454 i0 71 4.4010989010989 107 31 88.2 0 25 345 2 108 ATI17120.1 site-specific DNA-methyltransferase [Escherichia phage IMM-001] diamond 1602 181 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae   Escherichia phage IMM-001
30631939 30631939 PRJNA896554_P_NODE_153673_length_250_cov_0.870056_g146133_i0 PRJNA896554 153673 250 0.870056 2.17514 Maltschvirus 2948815 Viruses Viruses 103 4.48e-24   NR CAB4123191.1 2100421 g146133 i0 57.8 1.992 83 35 99.6 0 249 1 26 108 CAB4123191.1 PcnB tRNA nucleotidyltransferase/poly(A) polymerase [uncultured Caudovirales phage] diamond 498 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31129548 31129548 PRJNA896554_P_NODE_128735_length_278_cov_1.370732_g121195_i0 PRJNA896554 128735 278 1.370732 3.81063496 Thermus phage phiFa 1400796 Viruses Viruses 66.2 5.58e-12   NR AYJ74777.1 1400796 g121195 i0 56.9 0.550359712230216 51 22 55 0 277 125 30 80 AYJ74777.1 hypothetical protein phiFa_76 [Thermus phage phiFa] diamond 153 66.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage phiFa
32237380 32237380 PRJNA896554_P_NODE_165778_length_245_cov_0.895349_g158238_i0 PRJNA896554 165778 245 0.895349 2.19360505 Gordonia phage Bradissa 2510501 Viruses Viruses 50.4 1.14e-5   NR QAY17589.1 2510501 g158238 i0 59.5 0.514285714285714 42 17 51.4 0 32 157 11 52 QAY17589.1 helix-turn-helix DNA-binding protein [Gordonia phage Bradissa] diamond 126 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Gordonia phage Bradissa

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