RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1020854" and tax_clade = "Methanomada group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Methanomada group · 3 ✖

bioproject 1

  • PRJNA1020854 · 3 ✖
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
1003526 1003526 PRJNA1020854_S_NODE_7741_length_532_cov_393.558648_g5102_i0 PRJNA1020854 7741 532 393.558648 2093.73200736 Methanobrevibacter 2172 Archaea Archaea 776 0   NTclustered gi|470484903|ref|NR_076674.1| 83816 g5102 i0 95.842 152.934210526316 481 19 90 1 48 527 1045 1525 Methanobrevibacter ruminantium strain M1 23S ribosomal RNA gene, complete sequence blastn 81361 780 0.994871794871795 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
15464022 15464022 PRJNA1020854_S_NODE_5613_length_804_cov_402.772903_g3255_i0 PRJNA1020854 5613 804 402.772903 3238.29414012 Methanobrevibacter sp. 66852 Archaea Archaea 463 1.0599999999999998e-162   NR MEE3444449.1 66852 g3255 i0 97.2 1.88059701492537 252 7 94 0 3 758 46 297 MEE3444449.1 HAD-IC family P-type ATPase [Methanobrevibacter sp.] diamond 1512 463 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
30603511 30603511 PRJNA1020854_S_NODE_6533_length_653_cov_4.607372_g4009_i0 PRJNA1020854 6533 653 4.607372 30.08613916 Methanosphaera sp. rholeuAM27 2666342 Archaea Archaea 93.6 3.02e-18   NR RAP51160.1 1945577 g4009 i0 37.1 0.767228177641654 167 97 73.5 3 634 155 257 422 RAP51160.1 MAG: hypothetical protein BZ138_05820 [Methanosphaera sp. rholeuAM270] diamond 501 93.6 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. rholeuAM270

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