RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA883229" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA883229 · 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
27403149 27403149 PRJNA883229_P_NODE_5283_length_302_cov_0.986900_g5237_i0 PRJNA883229 5283 302 0.9869 2.980438 Dicistroviridae sp. 1955144 Viruses Viruses 132 2.51e-33   NR XCO49407.1 1955144 g5237 i0 57 0.993377483443709 100 43 99.3 0 300 1 643 742 XCO49407.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 300 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28666132 28666132 PRJNA883229_P_NODE_6467_length_282_cov_1.277512_g6421_i0 PRJNA883229 6467 282 1.277512 3.60258384 Chuvivirus 2842604 Viruses Viruses 43.1 0.0434   NR WET19891.1 2842604 g6421 i0 60 0.319148936170213 30 12 31.9 0 282 193 468 497 WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] diamond 90 43.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
29581313 29581313 PRJNA883229_P_NODE_1930_length_452_cov_0.992084_g1884_i0 PRJNA883229 1930 452 0.992084 4.48421968 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.7 1.88e-16   NR QJI53524.1 3003959 g1884 i0 38.1 0.889380530973451 134 74 88.9 2 451 50 2203 2327 QJI53524.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 402 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29865826 29865826 PRJNA883229_P_NODE_5431_length_299_cov_1.035398_g5385_i0 PRJNA883229 5431 299 1.035398 3.09584002 African cichlid piscichuvirus 3065075 Viruses Viruses 83.2 4.66e-16   NR WLN26256.1 3065075 g5385 i0 43.6 1.0133779264214 101 55 99.3 1 1 297 110 210 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 303 83.2 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus

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