RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA689790 · 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
29513677 29513677 PRJNA689790_S_NODE_13370_length_164_cov_1.842520_g13255_i0 PRJNA689790 13370 164 1.84252 3.0217328 Methanobacteriota archaeon 2026739 Archaea Archaea 53.9 1.45e-6   NR MAL20712.1 2026739 g13255 i0 50 0.951219512195122 52 26 95.1 0 7 162 1217 1268 MAL20712.1 hypothetical protein [Methanobacteriota archaeon] diamond 156 53.9 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30398783 30398783 PRJNA689790_S_NODE_10553_length_183_cov_1.054795_g10438_i0 PRJNA689790 10553 183 1.054795 1.93027485 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 55.5 2.92e-7   NR HIA39890.1 2163009 g10438 i0 55 0.655737704918033 40 18 65.6 0 169 50 138 177 HIA39890.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 120 55.5 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
30493148 30493148 PRJNA689790_S_NODE_16293_length_152_cov_1.356522_g16178_i0 PRJNA689790 16293 152 1.356522 2.06191344 Methanobacteriota archaeon 2026739 Archaea Archaea 60.8 4.35e-9   NR RAH13712.1 2026739 g16178 i0 52.2 0.907894736842105 46 22 90.8 0 4 141 56 101 RAH13712.1 MAG: hypothetical protein CMB20_004395 [Methanobacteriota archaeon] diamond 138 60.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30947110 30947110 PRJNA689790_S_NODE_4594_length_283_cov_2.369919_g4479_i0 PRJNA689790 4594 283 2.369919 6.70687077 root 1 Root_unresolved Root_unresolved 44.7 0.0112   NR WP_320161787.1 1005933 g4479 i0 40.7 1.04946996466431 59 33 62.5 2 206 30 184 240 WP_320161787.1 CBS domain-containing protein [uncultured Methanoregula sp.] diamond 297 44.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula 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);;