RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA168635", 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 · 5 ✖

tax_kingdom 1

tax_clade 1

  • Methanomada group · 5 ✖

bioproject 1

  • PRJNA168635 · 5 ✖

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
7432161 7432161 PRJNA168635_P_NODE_21966_length_176_cov_3.228346_g21550_i0 PRJNA168635 21966 176 3.228346 5.68188896 root 1 Root_unresolved Root_unresolved 309 7.98e-80   NTclustered gi|575790347|gb|KF697731.1| 2162 g21550 i0 98.305 101.522727272727 177 2 100 1 1 176 670 846 Methanobacterium sp. BRM9 16S ribosomal RNA gene, partial sequence blastn 17868 309 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium formicicum
13807600 13807600 PRJNA168635_P_NODE_18691_length_187_cov_1.420290_g18275_i0 PRJNA168635 18691 187 1.42029 2.6559423 Methanobacterium 2160 Archaea Archaea 213 6.94e-51   NTclustered gi|584298067|gb|KF882006.1| 392018 g18275 i0 98.347 81.9732620320856 121 2 65 0 67 187 1065 945 Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence blastn 15329 213 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium alcaliphilum
17631860 17631860 PRJNA168635_P_NODE_19354_length_184_cov_4.214815_g18938_i0 PRJNA168635 19354 184 4.214815 7.7552596 Methanobacterium 2160 Archaea Archaea 285 1.42e-72   NTclustered gi|584298059|gb|KF881998.1| 2161 g18938 i0 95.506 158.79347826087 178 8 97 0 7 184 1774 1951 Methanobacterium bryantii strain M.o.H. 23S ribosomal RNA gene, partial sequence blastn 29218 285 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium bryantii
22730941 22730941 PRJNA168635_P_NODE_11838_length_238_cov_0.941799_g11422_i0 PRJNA168635 11838 238 0.941799 2.24148162 Methanobacterium 2160 Archaea Archaea 335 1.9e-87   NTclustered gi|584298058|gb|KF881997.1| 256826 g11422 i0 92.05 147.453781512605 239 18 100 1 1 238 2135 2373 Methanobacterium aarhusense strain H2-LR 23S ribosomal RNA gene, partial sequence blastn 35094 335 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium aarhusense
23316571 23316571 PRJNA168635_P_NODE_21679_length_177_cov_1.921875_g21263_i0 PRJNA168635 21679 177 1.921875 3.40171875 Methanobacterium alcaliphilum 392018 Archaea Archaea 222 1.08e-53   NTclustered gi|584298067|gb|KF882006.1| 392018 g21263 i0 89.326 108.576271186441 178 18 100 1 1 177 1197 1374 Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence blastn 19218 222 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium alcaliphilum

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