RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJDB4470", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Duplornaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJDB4470 · 6 ✖

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
2559428 2559428 PRJDB4470_P_NODE_48023_length_299_cov_1.784000_g46870_i0 PRJDB4470 48023 299 1.784 5.33416 Skokie reo-like virus 2789444 Viruses Viruses 494 3.84e-135   NTclustered gi|1933757587|gb|MW177748.1| 2789444 g46870 i0 97.895 0.953177257525084 285 6 95 0 15 299 193 477 Skokie reo-like virus strain USAdf hypothetical protein 2 gene, complete cds blastn 285 494 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus
7661971 7661971 PRJDB4470_P_NODE_58707_length_254_cov_2.429268_g57552_i0 PRJDB4470 58707 254 2.429268 6.17034072 Alphachrysovirus perseae 2955248 Viruses Viruses 433 7.05e-117   NTclustered gi|1694999054|ref|NC_043506.1| 1587509 g57552 i0 100 0.921259842519685 234 0 92 0 1 234 2839 2606 Persea americana chrysovirus segment RNA1, complete sequence blastn 234 433 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Alphachrysovirus Alphachrysovirus perseae
27790758 27790758 PRJDB4470_P_NODE_73144_length_213_cov_1.847561_g71989_i0 PRJDB4470 73144 213 1.847561 3.93530493 Erysiphe necator associated totivirus 7 2737097 Viruses Viruses 52.8 7.24e-6   NR QJW70338.1 2737097 g71989 i0 40.6 0.971830985915493 69 41 97.2 0 5 211 62 130 QJW70338.1 coat protein [Erysiphe necator associated totivirus 7] diamond 207 52.8 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Erysiphe necator associated totivirus 7
29369368 29369368 PRJDB4470_P_NODE_53629_length_274_cov_1.360000_g52474_i0 PRJDB4470 53629 274 1.36 3.7264 Totiviridae sp. 1955172 Viruses Viruses 73.6 7.87e-13   NR WAK77569.1 1955172 g52474 i0 48.1 0.843065693430657 77 40 84.3 0 35 265 200 276 WAK77569.1 MAG: capsid protein [Totiviridae sp.] diamond 231 73.6 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
29495620 29495620 PRJDB4470_P_NODE_66070_length_231_cov_1.390110_g64915_i0 PRJDB4470 66070 231 1.39011 3.2111541 Totivirus sp. 2776824 Viruses Viruses 85.9 9.58e-18   NR QOQ37361.1 2776824 g64915 i0 87.2 0.61038961038961 47 6 61 0 142 2 1 47 QOQ37361.1 capsid protein, partial [Totivirus sp.] diamond 141 85.9 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
29773728 29773728 PRJDB4470_P_NODE_54151_length_272_cov_1.134529_g52996_i0 PRJDB4470 54151 272 1.134529 3.08591888 Ghabrivirales 2732540 Viruses Viruses 83.2 3.14e-16   NR WAK77569.1 1955172 g52996 i0 45.6 1.98529411764706 90 49 99.3 0 270 1 75 164 WAK77569.1 MAG: capsid protein [Totiviridae sp.] diamond 540 83.2 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);;