RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Shotokuvirae · 2 ✖

bioproject 1

  • PRJEB10140 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
13735715 13735715 PRJEB10140_P_NODE_252451_length_168_cov_0.873950_g235142_i0 PRJEB10140 252451 168 0.87395 1.468236 root 1 Root_unresolved Root_unresolved 67.6 5.04e-7   NTclustered gi|2302020969|gb|MT208472.1| 1954248 g235142 i0 93.333 18080.3214285714 45 3 27 0 124 168 783 827 MAG: Circoviridae sp. isolate CN3_L19_3559, complete genome blastn 3037494 67.6 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
19138540 19138540 PRJEB10140_P_NODE_292496_length_162_cov_0.893805_g275187_i0 PRJEB10140 292496 162 0.893805 1.4479641 Bosavirus sp. 2340908 Viruses Viruses 300 4.36e-77   NTclustered gi|2277478567|gb|MZ502234.1| 2340908 g275187 i0 100 5.99382716049383 162 0 100 0 1 162 617 456 Bosavirus sp. isolate NCS1/USA nonstructural protein and structural protein genes, complete cds blastn 971 300 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Copiparvovirus Bosavirus 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);;