RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA816047 · 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
32921061 32921061 PRJNA816047a_S_NODE_15569_length_512_cov_7.277904_g12944_i0 PRJNA816047 15569 512 7.277904 37.26286848 brine shrimp arlivirus 5 2900380 Viruses Viruses 273 3.0299999999999993e-81   NR UNI74094.1 2900380 g12944 i0 85.1 0.90234375 154 23 90.2 0 512 51 1897 2050 UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] diamond 462 273 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsafivalis
32956276 32956276 PRJNA816047d_S_NODE_29562_length_392_cov_2.430678_g27730_i0 PRJNA816047 29562 392 2.430678 9.52825776 Grapevine wood holobiome associated narna-like virus 22 3398659 Viruses Viruses 149 8.499999999999998e-39   NR XOD45402.1 3398659 g27730 i0 63.9 1.6530612244898 108 38 82.7 1 69 392 9 115 XOD45402.1 RdRp [Grapevine wood holobiome associated narna-like virus 22] diamond 648 149 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Grapevine wood holobiome associated narna-like virus 22
33057873 33057873 PRJNA816047a_S_NODE_46861_length_306_cov_0.798283_g44201_i0 PRJNA816047 46861 306 0.798283 2.44274598 brine shrimp partitivirus 1 2900392 Viruses Viruses 147 7.13e-40   NR UNI73932.1 2900392 g44201 i0 64.4 1.98039215686275 101 36 99 0 305 3 116 216 UNI73932.1 MAG: coat protein [brine shrimp partitivirus 1] diamond 606 147 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partitivirus 1
33160253 33160253 PRJNA816047a_S_NODE_73912_length_248_cov_6.634286_g71252_i0 PRJNA816047 73912 248 6.634286 16.45302928 brine shrimp arlivirus 5 2900380 Viruses Viruses 50.1 1e-4   NR UNI74090.1 2900380 g71252 i0 63.2 0.459677419354839 38 14 46 0 246 133 369 406 UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5] diamond 114 50.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsafivalis

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