RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA493632 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27234698 27234698 PRJNA493632_P_NODE_594003_length_245_cov_1.075581_g590562_i0 PRJNA493632 594003 245 1.075581 2.63517345 Methanobacterium sp. MZD13 2164 Archaea Archaea 160 2.22e-46   NR WP_416111966.1 3394378 g590562 i0 96.3 0.991836734693878 81 3 99.2 0 3 245 199 279 WP_416111966.1 methanogenesis marker 2 protein [Methanobacterium sp. MZD130B] diamond 243 160 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp. MZD130B
27834599 27834599 PRJNA493632_P_NODE_479904_length_256_cov_1.415301_g476465_i0 PRJNA493632 479904 256 1.415301 3.62317056 Methanobacterium sp. 2164 Archaea Archaea 167 7.08e-48   NR TMS42675.1 2164 g476465 i0 96.5 1.9921875 85 3 99.6 0 255 1 182 266 TMS42675.1 MAG: homoserine dehydrogenase [Methanobacterium sp.] diamond 510 167 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
28781849 28781849 PRJNA493632_P_NODE_707387_length_223_cov_4.720000_g703946_i0 PRJNA493632 707387 223 4.72 10.5256 Methanobrevibacter sp. 66852 Archaea Archaea 81.6 3.98e-16   NR MBO7716426.1 66852 g703946 i0 52.1 0.982062780269058 73 34 98.2 1 223 5 29 100 MBO7716426.1 phage DNA encapsidation protein [Methanobrevibacter sp.] diamond 219 81.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
30866349 30866349 PRJNA493632_P_NODE_295394_length_297_cov_2.156250_g291956_i0 PRJNA493632 295394 297 2.15625 6.4040625 Methanobacterium sp. 2164 Archaea Archaea 166 5.07e-49   NR HEY0196704.1 2164 g291956 i0 81.6 0.98989898989899 98 18 99 0 296 3 50 147 HEY0196704.1 hypothetical protein [Methanobacterium sp.] diamond 294 166 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
32353099 32353099 PRJNA493632_P_NODE_285319_length_302_cov_1.493450_g281883_i0 PRJNA493632 285319 302 1.49345 4.510219 Methanobrevibacter sp. 66852 Archaea Archaea 79.3 6.07e-17   NR MBO7696420.1 66852 g281883 i0 48.6 2.20529801324503 74 38 73.5 0 21 242 1 74 MBO7696420.1 hypothetical protein [Methanobrevibacter sp.] diamond 666 79.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.

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