RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 4 ✖

bioproject 1

  • PRJNA782235 · 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
16065746 16065746 PRJNA782235_P_NODE_17833_length_250_cov_0.870056_g17644_i0 PRJNA782235 17833 250 0.870056 2.17514 Haloarchaeobius sp. FL176 2967129 Archaea Archaea 158 8.89e-44   NR WP_257297707.1 2967129 g17644 i0 93.9 0.984 82 5 98.4 0 1 246 223 304 WP_257297707.1 succinic semialdehyde dehydrogenase [Haloarchaeobius sp. FL176] diamond 246 158 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halorubellaceae Haloarchaeobius Haloarchaeobius sp. FL176
28032905 28032905 PRJNA782235_P_NODE_15925_length_252_cov_1.720670_g15736_i0 PRJNA782235 15925 252 1.72067 4.3360884 Methanofastidiosum sp. 2666341 Archaea Archaea 135 4.51e-35   NR HNU62018.1 2666341 g15736 i0 69.9 0.988095238095238 83 25 98.8 0 251 3 161 243 HNU62018.1 DnaB-like helicase C-terminal domain-containing protein [Methanofastidiosum sp.] diamond 249 135 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
30622182 30622182 PRJNA782235_P_NODE_4353_length_422_cov_1.103152_g4164_i0 PRJNA782235 4353 422 1.103152 4.65530144 Methanofastidiosum sp. 2666341 Archaea Archaea 246 6.65e-76   NR HNU62018.1 2666341 g4164 i0 86.4 0.995260663507109 140 19 99.5 0 3 422 385 524 HNU62018.1 DnaB-like helicase C-terminal domain-containing protein [Methanofastidiosum sp.] diamond 420 246 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
31444019 31444019 PRJNA782235_P_NODE_27136_length_242_cov_0.911243_g26947_i0 PRJNA782235 27136 242 0.911243 2.20520806 Halosimplex pelagicum 869886 Archaea Archaea 53.1 7.5e-6   NR WP_246391716.1 869886 g26947 i0 46.8 0.768595041322314 62 33 76.9 0 56 241 7 68 WP_246391716.1 S1C family serine protease [Halosimplex pelagicum] diamond 186 53.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex pelagicum

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