RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1241156", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Preplasmiviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1241156 · 4 ✖

analysis 1

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
27673992 27673992 PRJNA1241156_S_NODE_71844_length_221_cov_4.292135_g71384_i0 PRJNA1241156 71844 221 4.292135 9.48561835 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 59.7 1.4e-8   NR DAC81259.1 2609866 g71384 i0 72.2 0.48868778280543 36 10 48.9 0 8 115 185 220 DAC81259.1 TPA_asm: FtsK [Astyanax tetra cavefish adintovirus] diamond 108 59.7 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus
28544620 28544620 PRJNA1241156_S_NODE_12547_length_404_cov_4.498615_g12087_i0 PRJNA1241156 12547 404 4.498615 18.1744046 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 76.3 6.66e-14   NR YP_010796956.1 2609866 g12087 i0 64.7 0.764851485148515 51 18 37.9 0 252 404 153 203 YP_010796956.1 FtsK [Terrapene box turtle adintovirus] diamond 309 77 0.990909090909091 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Amphintovirales Eupolintoviridae Betadintovirus Astyanax tetra cavefish adintovirus
31053313 31053313 PRJNA1241156_S_NODE_36555_length_311_cov_10.156716_g36095_i0 PRJNA1241156 36555 311 10.156716 31.58738676 Larimichthys croaker adintovirus 2609857 Viruses Viruses 135 7.92e-36   NR DAC81309.1 2609857 g36095 i0 64.6 0.92604501607717 96 34 92.6 0 21 308 177 272 DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus] diamond 288 135 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus
31387464 31387464 PRJNA1241156_S_NODE_22696_length_355_cov_3.099359_g22236_i0 PRJNA1241156 22696 355 3.099359 11.00272445 Viruses 10239 Viruses Viruses 65.9 1.73e-10   NR DAC81313.1 2609857 g22236 i0 50 0.963380281690141 56 24 43.9 1 122 277 67 122 DAC81313.1 TPA_asm: adenain [Larimichthys croaker adintovirus] diamond 342 65.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus

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