RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA540466" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJNA540466 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27077829 27077829 PRJNA540466_S_NODE_11602_length_502_cov_7.060606_g11061_i0 PRJNA540466 11602 502 7.060606 35.44424212 Euryarchaeota archaeon CG 2026739 Archaea Archaea 67.4 1.67e-10   NR PIV67904.1 1975560 g11061 i0 33.6 0.657370517928287 110 72 65.1 1 470 144 34 143 PIV67904.1 MAG: acetyl-CoA carboxylase biotin carboxyl carrier protein subunit [Euryarchaeota archaeon CG01_land_8_20_14_3_00_38_12] diamond 330 67.4 1 Archaea   Methanobacteriati Methanobacteriota         Euryarchaeota archaeon CG01_land_8_20_14_3_00_38_12
27472051 27472051 PRJNA540466_S_NODE_12523_length_487_cov_2.958937_g11979_i0 PRJNA540466 12523 487 2.958937 14.41002319 Methanobrevibacter 2172 Archaea Archaea 47 0.0136   NR WP_116670267.1 190976 g11979 i0 30 1.23819301848049 100 69 61 1 458 162 684 783 WP_116670267.1 OB-fold nucleic acid binding domain-containing protein [Methanobrevibacter woesei] diamond 603 47 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter woesei
30962570 30962570 PRJNA540466_S_NODE_19694_length_398_cov_4.055385_g19145_i0 PRJNA540466 19694 398 4.055385 16.1404323 Halobacteria archaeon 2670410 Archaea Archaea 49.7 8.11e-4   NR MEM3086957.1 2670410 g19145 i0 40.7 1.10050251256281 59 31 44.5 1 188 364 951 1005 MEM3086957.1 LamG-like jellyroll fold domain-containing protein [Halobacteria archaeon] diamond 438 49.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria       Halobacteria archaeon
31531757 31531757 PRJNA540466_S_NODE_61776_length_244_cov_1.631579_g61227_i0 PRJNA540466 61776 244 1.631579 3.98105276 Methanobacteriaceae archaeon 2099680 Archaea Archaea 137 7.1e-40   NR MBX7076498.1 2099680 g61227 i0 94.2 0.848360655737705 69 4 84.8 0 242 36 50 118 MBX7076498.1 30S ribosomal protein S12 [Methanobacteriaceae archaeon] diamond 207 137 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);;