RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA795983", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

  • Nanobdellota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA795983 · 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
17794186 17794186 PRJNA795983_S_NODE_11354_length_371_cov_2.560403_g11229_i0 PRJNA795983 11354 371 2.560403 9.49909513 Nanobdellota archaeon 2026764 Archaea Archaea 173 1.15e-47   NR MCA9485224.1 2026764 g11229 i0 67.5 0.970350404312669 120 39 97 0 362 3 285 404 MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] diamond 360 173 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29548317 29548317 PRJNA795983_S_NODE_2350_length_675_cov_1.528239_g2240_i0 PRJNA795983 2350 675 1.528239 10.31561325 Nanobdellota archaeon 2026764 Archaea Archaea 48.1 0.0185   NR MEK6859808.1 2026764 g2240 i0 66.7 0.133333333333333 30 10 13.3 0 99 10 107 136 MEK6859808.1 hypothetical protein [Nanoarchaeota archaeon] diamond 90 48.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29832677 29832677 PRJNA795983_S_NODE_27791_length_275_cov_1.361386_g27666_i0 PRJNA795983 27791 275 1.361386 3.7438115 Nanobdellota archaeon 2026764 Archaea Archaea 114 2.7300000000000003e-27   NR MCA9485224.1 2026764 g27666 i0 57.8 0.981818181818182 90 37 97.1 1 8 274 224 313 MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] diamond 270 114 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);;