RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1108009", 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

  • PRJNA1108009 · 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
4039985 4039985 PRJNA1108009_P_NODE_31184_length_242_cov_0.911243_g30866_i0 PRJNA1108009 31184 242 0.911243 2.20520806 uncultured Methanobrevibacter sp. 253161 Archaea Archaea 159 6.76e-46   NR WP_367242884.1 253161 g30866 i0 100 0.991735537190083 80 0 99.2 0 2 241 219 298 WP_367242884.1 acyltransferase [uncultured Methanobrevibacter sp.] diamond 240 159 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter uncultured Methanobrevibacter sp.
27825933 27825933 PRJNA1108009_P_NODE_24564_length_251_cov_1.707865_g24246_i0 PRJNA1108009 24564 251 1.707865 4.28674115 Methanosphaera sp. 2666342 Archaea Archaea 135 3.69e-39   NR MEE3325253.1 2666342 g24246 i0 76.8 0.9800796812749 82 19 98 0 4 249 1 82 MEE3325253.1 hypothetical protein [Methanosphaera sp.] diamond 246 135 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp.
28267693 28267693 PRJNA1108009_P_NODE_27446_length_247_cov_0.885057_g27128_i0 PRJNA1108009 27446 247 0.885057 2.18609079 Methanobrevibacter smithii 2173 Archaea Archaea 41.6 0.013   NR WP_400216637.1 2173 g27128 i0 81.8 0.267206477732794 22 4 26.7 0 247 182 35 56 WP_400216637.1 hypothetical protein, partial [Methanobrevibacter smithii] diamond 66 41.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii
28299373 28299373 PRJNA1108009_P_NODE_28326_length_246_cov_0.890173_g28008_i0 PRJNA1108009 28326 246 0.890173 2.18982558 Methanobrevibacter sp. 66852 Archaea Archaea 91.7 2.02e-19   NR WP_405288967.1 66852 g28008 i0 58 0.98780487804878 81 34 98.8 0 2 244 246 326 WP_405288967.1 Ig-like domain repeat protein [Methanobrevibacter sp.] diamond 243 91.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
29435787 29435787 PRJNA1108009_P_NODE_12190_length_383_cov_0.993548_g11872_i0 PRJNA1108009 12190 383 0.993548 3.80528884 Methanobrevibacter sp. 66852 Archaea Archaea 86.3 4.42e-17   NR WP_292806969.1 66852 g11872 i0 39.8 0.963446475195822 123 69 96.3 2 381 13 97 214 WP_292806969.1 WD40 repeat domain-containing protein [Methanobrevibacter sp.] diamond 369 86.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
31995987 31995987 PRJNA1108009_P_NODE_30858_length_242_cov_0.911243_g30540_i0 PRJNA1108009 30858 242 0.911243 2.20520806 Methanobrevibacter sp. 66852 Archaea Archaea 57 8.45e-8   NR MBO7731832.1 66852 g30540 i0 65.7 0.433884297520661 35 12 43.4 0 137 241 65 99 MBO7731832.1 hypothetical protein [Methanobrevibacter sp.] diamond 105 57 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);;