RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA330616" 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

  • PRJNA330616 · 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
27011235 27011235 PRJNA330616_P_NODE_11442_length_244_cov_2.092308_g11033_i0 PRJNA330616 11442 244 2.092308 5.10523152 Methanopyrus 2319 Archaea Archaea 45.1 4.93e-4   NR WP_011019823.1 2319 g11033 i0 47.7 0.971311475409836 44 22 52.9 1 244 116 17 60 WP_011019823.1 MULTISPECIES: 30S ribosomal protein S27ae [Methanopyrus] diamond 237 45.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanopyri Methanopyrales Methanopyraceae Methanopyrus  
27295876 27295876 PRJNA330616_P_NODE_28963_length_164_cov_0.886957_g28554_i0 PRJNA330616 28963 164 0.886957 1.45460948 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 42.7 0.0129   NR MEI6797334.1 1906667 g28554 i0 41.2 0.932926829268293 51 26 86 1 1 141 558 608 MEI6797334.1 fibronectin type III domain-containing protein [Methanomassiliicoccales archaeon] diamond 153 42.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
28070998 28070998 PRJNA330616_P_NODE_29105_length_164_cov_0.886957_g28696_i0 PRJNA330616 29105 164 0.886957 1.45460948 root 1 Root_unresolved Root_unresolved 84.3 9.83e-18   NR MBU38126.1 2026739 g28696 i0 75 5.79878048780488 52 13 95.1 0 164 9 229 280 MBU38126.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Methanobacteriota archaeon] diamond 951 85.1 0.990599294947121 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29365637 29365637 PRJNA330616_P_NODE_8409_length_286_cov_1.649789_g8000_i0 PRJNA330616 8409 286 1.649789 4.71839654 root 1 Root_unresolved Root_unresolved 108 5.85e-25   NR RMG24825.1 2026739 g8000 i0 57.1 2.88461538461538 84 36 88.1 0 1 252 511 594 RMG24825.1 MAG: DUF2813 domain-containing protein [Methanobacteriota archaeon] diamond 825 108 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);;