RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • Methanomada group · 6 ✖

bioproject 1

  • PRJNA1067370 · 6 ✖

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
15483419 15483419 PRJNA1067370_P_NODE_1593_length_1279_cov_4.396352_g1305_i0 PRJNA1067370 1593 1279 4.396352 56.22934208 Methanobacteriaceae archaeon 2099680 Archaea Archaea 462 2.789999999999999e-158   NR MBX7076500.1 2099680 g1305 i0 61.7 0.881939014855356 376 143 88.2 1 1130 3 12 386 MBX7076500.1 elongation factor Tu [Methanobacteriaceae archaeon] diamond 1128 462 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
27153227 27153227 PRJNA1067370_P_NODE_30502_length_353_cov_1.500000_g29954_i0 PRJNA1067370 30502 353 1.5 5.295 root 1 Root_unresolved Root_unresolved 46.6 0.00334   NR WP_011018895.1 2320 g29954 i0 32.4 5.01416430594901 108 45 90.1 3 32 349 12 93 WP_011018895.1 CBS domain-containing protein [Methanopyrus kandleri] diamond 1770 47 0.991489361702128 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanopyri Methanopyrales Methanopyraceae Methanopyrus Methanopyrus kandleri
29593087 29593087 PRJNA1067370_P_NODE_55390_length_287_cov_1.079439_g54841_i0 PRJNA1067370 55390 287 1.079439 3.09798993 uncultured Methanobrevibacter sp. 253161 Archaea Archaea 44.7 0.0118   NR WP_295609040.1 253161 g54841 i0 31.3 1.4006968641115 67 43 70 1 17 217 215 278 WP_295609040.1 cation diffusion facilitator family transporter [uncultured Methanobrevibacter sp.] diamond 402 44.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter uncultured Methanobrevibacter sp.
31426030 31426030 PRJNA1067370_P_NODE_57236_length_284_cov_1.317536_g56687_i0 PRJNA1067370 57236 284 1.317536 3.74180224 Methanocaldococcus indicus 213231 Archaea Archaea 75.5 1.45e-13   NR XMY58590.1 213231 g56687 i0 39.4 2.97887323943662 94 57 99.3 0 282 1 26 119 XMY58590.1 AAA family ATPase [Methanocaldococcus indicus] diamond 846 75.5 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus indicus
31678963 31678963 PRJNA1067370_P_NODE_56117_length_286_cov_1.084507_g55568_i0 PRJNA1067370 56117 286 1.084507 3.10169002 Methanobrevibacter ruminantium 83816 Archaea Archaea 51.6 4.78e-5   NR WP_304163574.1 83816 g55568 i0 37 1.6993006993007 81 40 80.8 2 263 33 185 258 WP_304163574.1 beta strand repeat-containing protein [Methanobrevibacter ruminantium] diamond 486 51.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
32871535 32871535 PRJNA1067370_P_NODE_44880_length_310_cov_0.974684_g44332_i0 PRJNA1067370 44880 310 0.974684 3.0215204 root 1 Root_unresolved Root_unresolved 55.1 3.85e-6   NR WP_292800363.1 66852 g44332 i0 30.2 2.09032258064516 106 57 96.8 3 302 3 688 782 WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] diamond 648 55.1 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);;