RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB41113", tax_kingdom = "Methanobacteriati" 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

  • Methanobacteriati · 5 ✖

bioproject 1

  • PRJEB41113 · 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
26589972 26589972 PRJEB41113_S_NODE_7041_length_174_cov_2.810219_g7032_i0 PRJEB41113 7041 174 2.810219 4.88978106 Methanoregula sp. 2052170 Archaea Archaea 42.7 0.0144   NR MDO8871794.1 2052170 g7032 i0 63.3 1.68965517241379 30 11 51.7 0 103 14 5 34 MDO8871794.1 Gfo/Idh/MocA family oxidoreductase [Methanoregula sp.] diamond 294 42.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
27381301 27381301 PRJEB41113_S_NODE_2543_length_215_cov_3.758427_g2534_i0 PRJEB41113 2543 215 3.758427 8.08061805 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 72 1.24e-12   NR MCZ7404273.1 2032688 g2534 i0 78 0.572093023255814 41 9 57.2 0 4 126 105 145 MCZ7404273.1 DUF5666 domain-containing protein [Candidatus Methanoperedens sp.] diamond 123 72 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens sp.
28132394 28132394 PRJEB41113_S_NODE_11705_length_155_cov_3.949153_g11696_i0 PRJEB41113 11705 155 3.949153 6.12118715 root 1 Root_unresolved Root_unresolved 69.7 8.18e-14   NR MBX7076462.1 2099680 g11696 i0 84 3.89032258064516 50 8 96.8 0 154 5 32 81 MBX7076462.1 NADH-quinone oxidoreductase subunit NuoK [Methanobacteriaceae archaeon] diamond 603 70.1 0.994293865905849 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
30222962 30222962 PRJEB41113_S_NODE_8572_length_165_cov_9.062500_g8563_i0 PRJEB41113 8572 165 9.0625 14.953125 Halobacteriales archaeon QS_1_68_2 1904752 Archaea Archaea 106 3.93e-25   NR PSP76452.1 1919169 g8563 i0 85.2 0.981818181818182 54 8 98.2 0 164 3 477 530 PSP76452.1 MAG: S9 family peptidase [Halobacteriales archaeon QS_1_68_20] diamond 162 106 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     Halobacteriales archaeon QS_1_68_20
31233934 31233934 PRJEB41113_S_NODE_6575_length_177_cov_2.192857_g6566_i0 PRJEB41113 6575 177 2.192857 3.88135689 Methanobrevibacter 2172 Archaea Archaea 64.7 5e-12   NR WP_069574170.1 2172 g6566 i0 100 0.525423728813559 31 0 52.5 0 71 163 1 31 WP_069574170.1 MULTISPECIES: hypothetical protein [Methanobrevibacter] diamond 93 64.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter  

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