RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1011844 · 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
27603691 27603691 PRJNA1011844_P_NODE_171564_length_226_cov_3.784314_g162983_i0 PRJNA1011844 171564 226 3.784314 8.55254964 Crogonang virus 54 3063037 Viruses Viruses 137 1.48e-35   NR WPR18275.1 3063037 g162983 i0 92.8 0.915929203539823 69 5 91.6 0 18 224 1059 1127 WPR18275.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 54] diamond 207 137 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 54
28961390 28961390 PRJNA1011844_P_NODE_159888_length_242_cov_0.911243_g151308_i0 PRJNA1011844 159888 242 0.911243 2.20520806 Skokie dicistro-like virus 2789443 Viruses Viruses 110 5.440000000000001e-26   NR QPG92978.1 2789443 g151308 i0 91.5 0.731404958677686 59 5 73.1 0 3 179 337 395 QPG92978.1 polyprotein 1 [Skokie dicistro-like virus] diamond 177 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
31615047 31615047 PRJNA1011844_P_NODE_79936_length_400_cov_3.626911_g71414_i0 PRJNA1011844 79936 400 3.626911 14.507644 Neofusicoccum luteum fusarivirus 1 1985188 Viruses Viruses 91.3 1.78e-18   NR YP_009553472.1 1985188 g71414 i0 48.8 0.645 86 44 64.5 0 263 6 234 319 YP_009553472.1 hypothetical protein [Neofusicoccum luteum fusarivirus 1] diamond 258 91.3 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Fusariviridae Alphafusarivirus Alphafusarivirus neofusicocci
32405998 32405998 PRJNA1011844_P_NODE_152239_length_247_cov_0.885057_g143660_i0 PRJNA1011844 152239 247 0.885057 2.18609079 Marine RNA virus SF-3 1419327 Viruses Viruses 100 1.85e-22   NR YP_009666362.1 1419327 g143660 i0 76.4 0.668016194331984 55 13 66.8 0 179 15 1882 1936 YP_009666362.1 polyprotein [Marine RNA virus SF-3] diamond 165 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus rohweri

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