RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA800090" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA800090 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
26832630 26832630 PRJNA800090_P_NODE_187121_length_230_cov_0.906832_g184936_i0 PRJNA800090 187121 230 0.906832 2.0857136 Halomarina litorea 2961595 Archaea Archaea 42.4 0.044   NR WP_254534769.1 2961595 g184936 i0 38.7 0.808695652173913 62 37 80.9 1 45 230 184 244 WP_254534769.1 PKD domain-containing protein [Halomarina litorea] diamond 186 42.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina litorea
27970053 27970053 PRJNA800090_P_NODE_181045_length_232_cov_1.914110_g178860_i0 PRJNA800090 181045 232 1.91411 4.4407352 Archaeoglobus neptunius 2798580 Archaea Archaea 43.5 0.0138   NR WP_202319282.1 2798580 g178860 i0 47.9 0.620689655172414 48 23 62.1 1 149 6 8 53 WP_202319282.1 protein-L-isoaspartate O-methyltransferase [Archaeoglobus neptunius] diamond 144 43.5 1 Archaea   Methanobacteriati Methanobacteriota Archaeoglobi Archaeoglobales Archaeoglobaceae Archaeoglobus Archaeoglobus neptunius
30094473 30094473 PRJNA800090_P_NODE_172672_length_236_cov_0.874251_g170487_i0 PRJNA800090 172672 236 0.874251 2.06323236 root 1 Root_unresolved Root_unresolved 67 3.15e-11   NR MDI6644206.1 2099680 g170487 i0 37.5 6.0635593220339 80 48 99.2 2 234 1 92 171 MDI6644206.1 MEDS domain-containing protein [Methanobacteriaceae archaeon] diamond 1431 67.4 0.99406528189911 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae   Methanobacteriaceae archaeon
30370521 30370521 PRJNA800090_P_NODE_181092_length_232_cov_1.766871_g178907_i0 PRJNA800090 181092 232 1.766871 4.09914072 Methanobacteriota archaeon 2026739 Archaea Archaea 45.1 0.00484   NR MAY13136.1 2026739 g178907 i0 39.1 0.827586206896552 64 36 78.9 1 227 45 387 450 MAY13136.1 hypothetical protein [Methanobacteriota archaeon] diamond 192 45.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30970534 30970534 PRJNA800090_P_NODE_82154_length_368_cov_1.555184_g79969_i0 PRJNA800090 82154 368 1.555184 5.72307712 Theionarchaea archaeon 2747605 Archaea Archaea 94.4 4.07e-21   NR MBU7014147.1 2747605 g79969 i0 50.5 1.64673913043478 101 46 79.1 2 292 2 6 106 MBU7014147.1 DUF2589 domain-containing protein [Theionarchaea archaeon] diamond 606 94.4 1 Archaea   Methanobacteriati Methanobacteriota Theionarchaea       Theionarchaea archaeon
31634229 31634229 PRJNA800090_P_NODE_145296_length_261_cov_1.088542_g143111_i0 PRJNA800090 145296 261 1.088542 2.84109462 Methanobacteriota archaeon 2026739 Archaea Archaea 57 2.15e-7   NR RZD40951.1 2026739 g143111 i0 43.8 0.839080459770115 73 35 79.3 2 50 256 12 82 RZD40951.1 MAG: hypothetical protein CXT73_05865 [Methanobacteriota archaeon] diamond 219 57 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon

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