RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1068830", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068830 · 3 ✖

analysis 1

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
1457638 1457638 PRJNA1068830_P_NODE_52742_length_301_cov_0.754386_g52039_i0 PRJNA1068830 52742 301 0.754386 2.27070186 Macrobrachium rosenbergii levi-like virus 1 3132580 Viruses Viruses 501 2.31e-137   NTclustered gi|2697475155|gb|PP215172.1| 3132580 g52039 i0 96.678 3.33887043189369 301 10 100 0 1 301 2266 2566 Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds blastn 1005 501 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Macrobrachium rosenbergii levi-like virus 1
7834790 7834790 PRJNA1068830_P_NODE_1887_length_1721_cov_2.976335_g1682_i0 PRJNA1068830 1887 1721 2.976335 51.22272535 Macrobrachium rosenbergii levi-like virus 1 3132580 Viruses Viruses 2663 0   NTclustered gi|2697475155|gb|PP215172.1| 3132580 g1682 i0 95.816 3.03021499128414 1649 69 96 0 1 1649 3418 1770 Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds blastn 5215 2663 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Macrobrachium rosenbergii levi-like virus 1
20583902 20583902 PRJNA1068830_P_NODE_43677_length_334_cov_8.681992_g42974_i0 PRJNA1068830 43677 334 8.681992 28.99785328 Macrobrachium rosenbergii levi-like virus 1 3132580 Viruses Viruses 479 1.2199999999999996e-130   NTclustered gi|2697475155|gb|PP215172.1| 3132580 g42974 i0 92.749 1.58083832335329 331 24 99 0 4 334 341 11 Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds blastn 528 479 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Macrobrachium rosenbergii levi-like virus 1

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