RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA986481 · 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
28321277 28321277 PRJNA986481_P_NODE_6426_length_634_cov_2.817094_g5949_i0 PRJNA986481 6426 634 2.817094 17.86037596 Qianjiang noda-like virus 85 3348674 Viruses Viruses 46.6 0.0464   NR XHA86068.1 3348674 g5949 i0 64.3 0.132492113564669 28 10 13.2 0 28 111 224 251 XHA86068.1 MAG: hypothetical protein [Qianjiang noda-like virus 85] diamond 84 46.6 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae   Qianjiang noda-like virus 85
28384408 28384408 PRJNA986481_P_NODE_21126_length_357_cov_1.142857_g20601_i0 PRJNA986481 21126 357 1.142857 4.07999949 Rhizopus microsporus phasma-like virus 1 3156537 Viruses Viruses 89.4 6.71e-18   NR BFM51670.1 3156537 g20601 i0 38.9 0.798319327731092 95 58 79.8 0 302 18 1455 1549 BFM51670.1 RNA-dependent RNA polymerase [Rhizopus microsporus phasma-like virus 1] diamond 285 89.4 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Rhizopus microsporus phasma-like virus 1
31195038 31195038 PRJNA986481_P_NODE_31475_length_291_cov_2.223140_g30950_i0 PRJNA986481 31475 291 2.22314 6.4693374 Bunyaviricetes sp. 3240187 Viruses Viruses 67.4 1.46e-10   NR XKB76341.1 3240187 g30950 i0 40.7 1.87628865979381 91 52 93.8 1 18 290 1557 1645 XKB76341.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.] diamond 546 67.4 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes       Bunyaviricetes sp.
32081054 32081054 PRJNA986481_P_NODE_21438_length_354_cov_1.832787_g20913_i0 PRJNA986481 21438 354 1.832787 6.48806598 Bunyaviricetes sp. 3240187 Viruses Viruses 71.2 1.42e-11   NR XKB76342.1 3240187 g20913 i0 42.6 0.855932203389831 101 55 85.6 2 21 323 574 671 XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] diamond 303 71.2 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes       Bunyaviricetes 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);;