RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 3 ✖

tax_kingdom 1

tax_clade 1

  • Methanomada group · 3 ✖

bioproject 1

  • PRJEB39643 · 3 ✖
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
7710826 7710826 PRJEB39643_P_NODE_7727_length_732_cov_3.060698_g7559_i0 PRJEB39643 7727 732 3.060698 22.40430936 Methanobacterium sp. BRmetb2 2025350 Archaea Archaea 54.7 0.02   NTclustered gi|1473087786|gb|CP022705.1| 2025350 g7559 i0 94.444 0.0491803278688525 36 1 5 1 439 473 861936 861901 MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome blastn 36 54.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. BRmetb2
27690589 27690589 PRJEB39643_P_NODE_6204_length_835_cov_3.692913_g6055_i0 PRJEB39643 6204 835 3.692913 30.83582355 Methanosphaera 2316 Archaea Archaea 45.8 0.0299   NR WP_288652866.1 262501 g6055 i0 30.6 0.610778443113772 85 53 30.2 2 541 792 51 130 WP_288652866.1 hypothetical protein [uncultured Methanosphaera sp.] diamond 510 45.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera uncultured Methanosphaera sp.
30949794 30949794 PRJEB39643_P_NODE_128654_length_249_cov_1.312500_g128461_i0 PRJEB39643 128654 249 1.3125 3.268125 Methanobrevibacter sp. DSM 116169 3242727 Archaea Archaea 53.1 8.98e-6   NR WP_409199671.1 3242727 g128461 i0 46.6 0.879518072289157 73 32 81.9 3 222 19 218 288 WP_409199671.1 C1 family peptidase [Methanobrevibacter sp. DSM 116169] diamond 219 53.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. DSM 116169

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