RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_clade = "Methanomada group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Methanomada group · 10 ✖

bioproject 1

  • PRJNA1240804 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
18901887 18901887 PRJNA1240804_P_NODE_79155_length_187_cov_1.391304_g78789_i0 PRJNA1240804 79155 187 1.391304 2.60173848 Methanobacterium sp. PtaU1.Bin 2164 Archaea Archaea 113 8.480000000000001e-29   NR OPY20905.1 1811675 g78789 i0 93.2 0.946524064171123 59 4 94.7 0 10 186 95 153 OPY20905.1 MAG: hypothetical protein A4E26_01753 [Methanobacterium sp. PtaU1.Bin097] diamond 177 113 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. PtaU1.Bin097
27073411 27073411 PRJNA1240804_P_NODE_112202_length_168_cov_1.546218_g111836_i0 PRJNA1240804 112202 168 1.546218 2.59764624 Methanobacteriaceae archaeon 2099680 Archaea Archaea 94.4 3.14e-22   NR NYB27483.1 2099680 g111836 i0 100 0.785714285714286 44 0 78.6 0 166 35 91 134 NYB27483.1 flavodoxin family protein [Methanobacteriaceae archaeon] diamond 132 94.4 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
27073504 27073504 PRJNA1240804_P_NODE_71942_length_192_cov_1.342657_g71576_i0 PRJNA1240804 71942 192 1.342657 2.57790144 Methanobacterium sp. 2164 Archaea Archaea 115 1.82e-28   NR MCC7564072.1 2164 g71576 i0 98.3 0.921875 59 1 92.2 0 1 177 12 70 MCC7564072.1 nucleotide sugar dehydrogenase [Methanobacterium sp.] diamond 177 115 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
27673879 27673879 PRJNA1240804_P_NODE_121464_length_167_cov_0.881356_g121098_i0 PRJNA1240804 121464 167 0.881356 1.47186452 Methanobacteriaceae archaeon 2099680 Archaea Archaea 94.7 9.27e-24   NR NYB26638.1 2099680 g121098 i0 98 0.880239520958084 49 1 88 0 18 164 1 49 NYB26638.1 hypothetical protein [Methanobacteriaceae archaeon] diamond 147 94.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
27957867 27957867 PRJNA1240804_P_NODE_11545_length_386_cov_2.427300_g11180_i0 PRJNA1240804 11545 386 2.4273 9.369378 Methanosphaera sp. rholeuAM27 2666342 Archaea Archaea 56.6 2.36e-6   NR RAP51160.1 1945577 g11180 i0 34.2 0.932642487046632 120 76 91.7 2 354 1 222 340 RAP51160.1 MAG: hypothetical protein BZ138_05820 [Methanosphaera sp. rholeuAM270] diamond 360 56.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. rholeuAM270
28273488 28273488 PRJNA1240804_P_NODE_149566_length_162_cov_0.920354_g149200_i0 PRJNA1240804 149566 162 0.920354 1.49097348 Methanobacterium sp. PtaU1.Bin 2164 Archaea Archaea 88.2 5.76e-20   NR OPY19753.1 1811675 g149200 i0 100 0.814814814814815 44 0 81.5 0 151 20 5 48 OPY19753.1 MAG: Ribonuclease HII [Methanobacterium sp. PtaU1.Bin097] diamond 132 88.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. PtaU1.Bin097
29378806 29378806 PRJNA1240804_P_NODE_82929_length_184_cov_2.148148_g82563_i0 PRJNA1240804 82929 184 2.148148 3.95259232 Methanobacteriaceae archaeon 2099680 Archaea Archaea 112 1.53e-28   NR NYB27879.1 2099680 g82563 i0 98.3 0.945652173913043 58 1 94.6 0 183 10 149 206 NYB27879.1 diphthine synthase [Methanobacteriaceae archaeon] diamond 174 112 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
29568032 29568032 PRJNA1240804_P_NODE_128250_length_166_cov_0.888889_g127884_i0 PRJNA1240804 128250 166 0.888889 1.47555574 Methanobacterium sp. 2164 Archaea Archaea 97.1 4.1800000000000003e-22   NR HEY0196123.1 2164 g127884 i0 88.9 1.93373493975904 54 6 97.6 0 164 3 207 260 HEY0196123.1 acetylornithine transaminase [Methanobacterium sp.] diamond 321 97.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
31653530 31653530 PRJNA1240804_P_NODE_121417_length_167_cov_0.881356_g121051_i0 PRJNA1240804 121417 167 0.881356 1.47186452 Methanobacterium congolense 118062 Archaea Archaea 60.5 7.4e-9   NR WP_071906846.1 118062 g121051 i0 54.2 0.862275449101796 48 21 86.2 1 1 144 372 418 WP_071906846.1 pseudomurein-binding repeat-containing protein [Methanobacterium congolense] diamond 144 60.5 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium congolense
32728681 32728681 PRJNA1240804_P_NODE_128180_length_166_cov_0.888889_g127814_i0 PRJNA1240804 128180 166 0.888889 1.47555574 Methanobacteriaceae archaeon 2099680 Archaea Archaea 90.1 2.69e-19   NR NYB27195.1 2099680 g127814 i0 93.5 0.831325301204819 46 3 83.1 0 16 153 210 255 NYB27195.1 right-handed parallel beta-helix repeat-containing protein [Methanobacteriaceae archaeon] diamond 138 90.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon

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