RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA482207" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA482207 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
28150282 28150282 PRJNA482207_P_NODE_19145_length_251_cov_1.443820_g19035_i0 PRJNA482207 19145 251 1.44382 3.6239882 Escherichia phage D2 2915331 Viruses Viruses 88.2 8.4e-21   NR ULG00791.1 2915331 g19035 i0 63.2 0.812749003984064 68 25 81.3 0 244 41 13 80 ULG00791.1 hypothetical protein, partial [Escherichia phage D2] diamond 204 88.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Bievrevirus Escherichia phage D2
30329557 30329557 PRJNA482207_P_NODE_27692_length_243_cov_1.376471_g27582_i0 PRJNA482207 27692 243 1.376471 3.34482453 Caudoviricetes sp. 2832643 Viruses Viruses 49.3 3.27e-5   NR DAH93386.1 2832643 g27582 i0 56.4 0.481481481481481 39 17 48.1 0 241 125 34 72 DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] diamond 117 49.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30992618 30992618 PRJNA482207_P_NODE_24694_length_246_cov_0.890173_g24584_i0 PRJNA482207 24694 246 0.890173 2.18982558 Cellulophaga phage Nekkels_1 2745692 Viruses Viruses 68.9 2.32e-11   NR YP_010357532.1 2745692 g24584 i0 76.3 0.463414634146341 38 9 46.3 0 133 246 1 38 YP_010357532.1 DNA primase/helicase [Cellulophaga phage Nekkels_1] diamond 114 68.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Assiduviridae Nekkelsvirus Nekkelsvirus Nekkels
31181792 31181792 PRJNA482207_P_NODE_21755_length_249_cov_0.875000_g21645_i0 PRJNA482207 21755 249 0.875 2.17875 Vibrio phage 1.242.O._1 1881235 Viruses Viruses 70.5 6.09e-13   NR AUR97566.1 1881235 g21645 i0 69 0.506024096385542 42 13 50.6 0 248 123 124 165 AUR97566.1 AP2/ERF domain protein [Vibrio phage 1.242.O._10N.261.54.B2] diamond 126 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 1.242.O._10N.261.54.B2
31181798 31181798 PRJNA482207_P_NODE_29095_length_242_cov_0.911243_g28985_i0 PRJNA482207 29095 242 0.911243 2.20520806 Vibrio phage vB_ValP_IME271 2024229 Viruses Viruses 85.9 1.19e-18   NR ASR73830.1 2024229 g28985 i0 48.1 0.979338842975207 79 41 97.9 0 241 5 5 83 ASR73830.1 hypothetical protein [Vibrio phage vB_ValP_IME271] diamond 237 85.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage vB_ValP_IME271

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