RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA630162 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26732140 26732140 PRJNA630162_P_NODE_161441_length_162_cov_0.920354_g159918_i0 PRJNA630162 161441 162 0.920354 1.49097348 Microviridae sp. 2202644 Viruses Viruses 78.2 3.89e-15   NR DAT95611.1 2202644 g159918 i0 87.8 0.759259259259259 41 5 75.9 0 161 39 547 587 DAT95611.1 MAG TPA: Replication associated protein [Microviridae sp.] diamond 123 78.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
27775854 27775854 PRJNA630162_P_NODE_155904_length_163_cov_0.912281_g154381_i0 PRJNA630162 155904 163 0.912281 1.48701803 Microviridae sp. 2202644 Viruses Viruses 91.7 6.98e-20   NR XOF00470.1 2202644 g154381 i0 83.3 1.76687116564417 48 8 88.3 0 162 19 445 492 XOF00470.1 MAG: major head protein [Microviridae sp.] diamond 288 91.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
27996891 27996891 PRJNA630162_P_NODE_67545_length_215_cov_2.656627_g66022_i0 PRJNA630162 67545 215 2.656627 5.71174805 Microvirus sp. 2202559 Viruses Viruses 78.6 4.93e-16   NR QJB19271.1 2202559 g66022 i0 64.8 0.990697674418605 71 18 99.1 1 214 2 89 152 QJB19271.1 MAG: DNA pilot protein [Microvirus sp.] diamond 213 78.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30048904 30048904 PRJNA630162_P_NODE_149531_length_164_cov_3.304348_g148008_i0 PRJNA630162 149531 164 3.304348 5.41913072 Microviridae sp. 2202644 Viruses Viruses 79.3 1.58e-15   NR XOE96506.1 2202644 g148008 i0 90.2 0.75 41 4 75 0 163 41 55 95 XOE96506.1 MAG: major head protein [Microviridae sp.] diamond 123 79.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30522970 30522970 PRJNA630162_P_NODE_145813_length_165_cov_2.353448_g144290_i0 PRJNA630162 145813 165 2.353448 3.8831892 Microviridae sp. 2202644 Viruses Viruses 94.4 6.01e-23   NR XOE96504.1 2202644 g144290 i0 84.9 0.963636363636364 53 8 96.4 0 164 6 26 78 XOE96504.1 MAG: virion structural protein [Microviridae sp.] diamond 159 94.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30586086 30586086 PRJNA630162_P_NODE_172013_length_152_cov_3.097087_g170490_i0 PRJNA630162 172013 152 3.097087 4.70757224 Ariapismic virus 19 3376425 Viruses Viruses 58.2 1.15e-9   NR XJW05235.1 3376426 g170490 i0 87.9 1.30263157894737 33 4 65.1 0 54 152 1 33 XJW05235.1 MAG: hypothetical protein [Ariapismic virus 190] diamond 198 58.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 190
31818960 31818960 PRJNA630162_P_NODE_110837_length_179_cov_1.923077_g109314_i0 PRJNA630162 110837 179 1.923077 3.44230783 Apis mellifera associated microvirus 49 2494779 Viruses Viruses 113 1.3e-27   NR AZL82871.1 2494779 g109314 i0 80.7 0.955307262569832 57 11 95.5 0 177 7 35 91 AZL82871.1 major capsid protein [Apis mellifera associated microvirus 49] diamond 171 113 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Apis mellifera associated microvirus 49
31882268 31882268 PRJNA630162_P_NODE_158777_length_162_cov_2.070796_g157254_i0 PRJNA630162 158777 162 2.070796 3.35468952 Microviridae sp. 2202644 Viruses Viruses 62.4 9.66e-10   NR XOE96505.1 2202644 g157254 i0 68.4 2 57 11 92.6 1 162 13 165 221 XOE96505.1 MAG: pilot protein for DNA ejection [Microviridae sp.] diamond 324 62.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae 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);;