RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA737474", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Nanobdellota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA737474 · 4 ✖

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
33003849 33003849 PRJNA737474b_S_NODE_21115_length_349_cov_1.402174_g20076_i0 PRJNA737474 21115 349 1.402174 4.89358726 Nanobdellota archaeon 2026764 Archaea Archaea 127 1.05e-32   NR MEK6886790.1 2026764 g20076 i0 61.7 1.61604584527221 94 36 80.8 0 345 64 280 373 MEK6886790.1 phosphonopyruvate decarboxylase [Nanoarchaeota archaeon] diamond 564 127 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
33095300 33095300 PRJNA737474f_S_NODE_159054_length_263_cov_5.852632_g158376_i0 PRJNA737474 159054 263 5.852632 15.39242216 Methanomada group 2283794 Archaea Archaea 59.3 2.05e-9   NR MBU0898836.1 2026764 g158376 i0 71.4 3.31939163498099 35 9 39.9 1 248 144 38 71 MBU0898836.1 30S ribosomal protein S14 [Nanoarchaeota archaeon] diamond 873 59.7 0.993299832495812 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
33175775 33175775 PRJNA737474f_S_NODE_21104_length_447_cov_4.267380_g20427_i0 PRJNA737474 21104 447 4.26738 19.0751886 Nanobdellota archaeon 2026764 Archaea Archaea 80.9 1.61e-16   NR MBU1322236.1 2026764 g20427 i0 45.3 1.12751677852349 86 45 57.7 1 6 263 32 115 MBU1322236.1 hypothetical protein [Nanoarchaeota archaeon] diamond 504 80.9 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
33175919 33175919 PRJNA737474f_S_NODE_296736_length_237_cov_2.054878_g296058_i0 PRJNA737474 296736 237 2.054878 4.87006086 Nanobdellota archaeon 2026764 Archaea Archaea 65.9 1.06e-10   NR MBU0758679.1 2026764 g296058 i0 76.7 1.74683544303797 43 10 54.4 0 234 106 196 238 MBU0758679.1 DNA alkylation repair protein [Nanoarchaeota archaeon] diamond 414 65.9 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon

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