RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA911178", 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

  • PRJNA911178 · 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
5996473 5996473 PRJNA911178_P_NODE_52505_length_479_cov_1.312808_g50070_i0 PRJNA911178 52505 479 1.312808 6.28835032 Methanobacterium palustre 2171 Archaea Archaea 800 0   NTclustered gi|584298062|gb|KF882001.1| 2171 g50070 i0 96.875 131.254697286013 480 11 99 2 4 479 599 1078 Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence blastn 62871 800 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre
15278204 15278204 PRJNA911178_P_NODE_275312_length_244_cov_1.456140_g272838_i0 PRJNA911178 275312 244 1.45614 3.5529816 Methanomada group 2283794 Archaea Archaea 113 9.95e-21   NTclustered gi|2891700162|gb|CP178165.1| 213231 g272838 i0 89.773 39.3688524590164 88 9 36 0 5 92 710149 710236 Methanocaldococcus indicus strain SL43 chromosome, complete genome blastn 9606 113 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus indicus
17827903 17827903 PRJNA911178_P_NODE_304654_length_227_cov_3.071429_g302180_i0 PRJNA911178 304654 227 3.071429 6.97214383 Methanobacterium 2160 Archaea Archaea 353 4.95e-93   NTclustered gi|110180147|gb|DQ649333.1| 2171 g302180 i0 96.729 112.42731277533 214 3 93 2 1 210 214 1 Methanobacterium palustre strain 21 16S ribosomal RNA gene, partial sequence blastn 25521 353 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre

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