RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA811725" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJNA811725 · 3 ✖

analysis 1

  • blastn · 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
12289444 12289444 PRJNA811725_P_NODE_9390_length_483_cov_1.553659_g9146_i0 PRJNA811725 9390 483 1.553659 7.50417297 Betanodavirus epinepheli 3427237 Viruses Viruses 893 0   NTclustered gi|156076357|gb|EF558368.1| 43763 g9146 i0 100 98.0600414078675 483 0 100 0 1 483 2506 2988 Redspotted grouper nervous necrosis virus isolate China 1 RNA-dependent RNA polymerase gene, complete cds blastn 47363 893 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Betanodavirus Betanodavirus epinepheli
17388340 17388340 PRJNA811725_P_NODE_30474_length_282_cov_1.846890_g30228_i0 PRJNA811725 30474 282 1.84689 5.2082298 Potexvirus marmormanihotis 3433851 Viruses Viruses 499 7.729999999999999e-137   NTclustered gi|1939515391|gb|MT334616.1| 39046 g30228 i0 98.582 17.6205673758865 282 4 100 0 1 282 2383 2102 Cassava common mosaic virus isolate PisVera RdRp, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and CP genes, complete cds blastn 4969 499 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus marmormanihotis
23762571 23762571 PRJNA811725_P_NODE_31839_length_276_cov_1.315271_g31593_i0 PRJNA811725 31839 276 1.315271 3.63014796 Potexvirus marmormanihotis 3433851 Viruses Viruses 505 1.62e-138   NTclustered gi|1939515391|gb|MT334616.1| 39046 g31593 i0 99.638 9.01086956521739 276 1 100 0 1 276 231 506 Cassava common mosaic virus isolate PisVera RdRp, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and CP genes, complete cds blastn 2487 505 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus marmormanihotis

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