RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA702290 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27240762 27240762 PRJNA702290_P_NODE_1103_length_191_cov_5.486842_g1095_i0 PRJNA702290 1103 191 5.486842 10.47986822 Totivirus sp. 2776824 Viruses Viruses 56.6 2.26e-7   NR QOQ37361.1 2776824 g1095 i0 88.5 0.408376963350785 26 3 40.8 0 79 2 198 223 QOQ37361.1 capsid protein, partial [Totivirus sp.] diamond 78 56.6 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
30872635 30872635 PRJNA702290_P_NODE_1614_length_158_cov_22.907563_g1606_i0 PRJNA702290 1614 158 22.907563 36.19394954 Neofusicoccum parvum victorivirus 1 2818054 Viruses Viruses 84.7 1.86e-17   NR QTE76047.1 2818054 g1606 i0 87.8 0.930379746835443 49 6 93 0 151 5 187 235 QTE76047.1 coat protein [Neofusicoccum parvum victorivirus 1] diamond 147 84.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Pseudototiviridae Victorivirus Neofusicoccum parvum victorivirus 1
32370425 32370425 PRJNA702290_P_NODE_2159_length_150_cov_6.036036_g2151_i0 PRJNA702290 2159 150 6.036036 9.054054 Ghabrivirales 2732540 Viruses Viruses 86.3 4.9e-18   NR UHS72521.1 1955172 g2151 i0 76.6 4.54 47 11 94 0 10 150 285 331 UHS72521.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.] diamond 681 86.3 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.

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