RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • Methanomada group · 7 ✖

bioproject 1

  • PRJEB81327 · 7 ✖

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
27287120 27287120 PRJEB81327_P_NODE_44183_length_254_cov_1.668508_g43575_i0 PRJEB81327 44183 254 1.668508 4.23801032 Methanosphaera sp. rholeuAM27 2666342 Archaea Archaea 141 4.019999999999999e-40   NR RAP52248.1 1945577 g43575 i0 81.9 1.98425196850394 83 15 98 0 251 3 88 170 RAP52248.1 MAG: hypothetical protein BZ138_03455 [Methanosphaera sp. rholeuAM270] diamond 504 141 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. rholeuAM270
27603147 27603147 PRJEB81327_P_NODE_22324_length_295_cov_1.536036_g21716_i0 PRJEB81327 22324 295 1.536036 4.5313062 uncultured Methanobrevibacter sp. 253161 Archaea Archaea 109 1.9899999999999999e-25   NR WP_295614768.1 253161 g21716 i0 76.6 0.650847457627119 64 15 65.1 0 293 102 757 820 WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] diamond 192 109 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter uncultured Methanobrevibacter sp.
27981925 27981925 PRJEB81327_P_NODE_7525_length_512_cov_3.968109_g6921_i0 PRJEB81327 7525 512 3.968109 20.31671808 uncultured Methanobrevibacter sp. 253161 Archaea Archaea 57 1.55e-6   NR WP_297983794.1 253161 g6921 i0 32 1.470703125 122 73 69.7 3 24 380 67 181 WP_297983794.1 translationally-controlled tumor protein [uncultured Methanobrevibacter sp.] diamond 753 57 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter uncultured Methanobrevibacter sp.
29433959 29433959 PRJEB81327_P_NODE_55630_length_246_cov_0.890173_g55022_i0 PRJEB81327 55630 246 0.890173 2.18982558 Methanobrevibacter sp. 66852 Archaea Archaea 75.9 8.58e-14   NR WP_405277409.1 66852 g55022 i0 51.6 0.75609756097561 62 27 72 1 243 67 751 812 WP_405277409.1 AAA family ATPase [Methanobrevibacter sp.] diamond 186 75.9 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
31013709 31013709 PRJEB81327_P_NODE_47335_length_251_cov_0.865169_g46727_i0 PRJEB81327 47335 251 0.865169 2.17157419 Methanobrevibacter sp. 66852 Archaea Archaea 68.6 2.63e-11   NR WP_292806969.1 66852 g46727 i0 46.8 0.920318725099602 77 40 90.8 1 239 12 262 338 WP_292806969.1 WD40 repeat domain-containing protein [Methanobrevibacter sp.] diamond 231 68.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
31164099 31164099 PRJEB81327_P_NODE_32955_length_273_cov_1.535000_g32347_i0 PRJEB81327 32955 273 1.535 4.19055 root 1 Root_unresolved Root_unresolved 115 8.97e-28   NR WP_406531486.1 66852 g32347 i0 64.7 2.8021978021978 85 30 93.4 0 260 6 533 617 WP_406531486.1 hypothetical protein [Methanobrevibacter sp.] diamond 765 116 0.991379310344828 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
32563893 32563893 PRJEB81327_P_NODE_57559_length_245_cov_0.895349_g56951_i0 PRJEB81327 57559 245 0.895349 2.19360505 Methanobrevibacter sp. 66852 Archaea Archaea 45.1 0.00582   NR MBP5699769.1 66852 g56951 i0 38 2.87755102040816 79 35 96.7 2 237 1 281 345 MBP5699769.1 hypothetical protein [Methanobrevibacter sp.] diamond 705 45.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);;