RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA760904", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 3 ✖

tax_kingdom 1

tax_clade 1

  • Methanomada group · 3 ✖

bioproject 1

  • PRJNA760904 · 3 ✖

analysis 1

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
5845783 5845783 PRJNA760904_P_NODE_12265_length_269_cov_1.290816_g12208_i0 PRJNA760904 12265 269 1.290816 3.47229504 uncultured Methanobrevibacter sp. 253161 Archaea Archaea 126 2.24e-31   NR WP_295614768.1 253161 g12208 i0 68.5 0.992565055762082 89 28 99.3 0 2 268 681 769 WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] diamond 267 126 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter uncultured Methanobrevibacter sp.
29336534 29336534 PRJNA760904_P_NODE_13749_length_257_cov_2.250000_g13692_i0 PRJNA760904 13749 257 2.25 5.7825 Methanobacteriaceae 2159 Archaea Archaea 44.7 0.00955   NR WP_066973734.1 55758 g13692 i0 46.2 1.52918287937743 39 21 45.5 0 235 119 184 222 WP_066973734.1 beta strand repeat-containing protein [Methanobrevibacter filiformis] diamond 393 44.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter filiformis
32329707 32329707 PRJNA760904_P_NODE_2959_length_475_cov_1.703980_g2902_i0 PRJNA760904 2959 475 1.70398 8.093905 Methanobacterium sp. MZD13 2164 Archaea Archaea 57 4.67e-6   NR WP_416111484.1 3394378 g2902 i0 33.9 0.783157894736842 124 72 77.1 4 420 55 12 127 WP_416111484.1 Ig-like domain repeat protein, partial [Methanobacterium sp. MZD130B] diamond 372 57 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. MZD130B

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