RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA890871" 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 · 5 ✖

bioproject 1

  • PRJNA890871 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
28161155 28161155 PRJNA890871_P_NODE_10765_length_472_cov_6.290727_g10630_i0 PRJNA890871 10765 472 6.290727 29.69223144 Candidatus Methanofastidiosia archaeon 2099674 Archaea Archaea 53.9 3.61e-5   NR NMC58615.1 2099674 g10630 i0 41.8 1.04872881355932 55 32 35 0 471 307 216 270 NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] diamond 495 53.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia       Candidatus Methanofastidiosia archaeon
30687351 30687351 PRJNA890871_P_NODE_5253_length_656_cov_2.828473_g5118_i0 PRJNA890871 5253 656 2.828473 18.55478288 Methanofastidiosum sp. 2666341 Archaea Archaea 65.5 9.31e-10   NR MFA5559230.1 2666341 g5118 i0 36 0.507621951219512 111 66 48.5 2 6 323 9 119 MFA5559230.1 hypothetical protein [Methanofastidiosum sp.] diamond 333 65.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
30813815 30813815 PRJNA890871_P_NODE_94194_length_198_cov_7.144000_g94059_i0 PRJNA890871 94194 198 7.144 14.14512 Candidatus Methanofastidiosia archaeon 2099674 Archaea Archaea 44.7 0.00404   NR NMC58615.1 2099674 g94059 i0 53.8 0.590909090909091 39 18 59.1 0 15 131 233 271 NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] diamond 117 44.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia       Candidatus Methanofastidiosia archaeon
31161003 31161003 PRJNA890871_P_NODE_1755_length_1393_cov_3.536364_g1649_i0 PRJNA890871 1755 1393 3.536364 49.26155052 Candidatus Methanofastidiosia archaeon 2099674 Archaea Archaea 110 3.909999999999999e-23   NR NMC58615.1 2099674 g1649 i0 35.2 0.525484565685571 244 142 50.6 10 71 775 35 271 NMC58615.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] diamond 732 110 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia       Candidatus Methanofastidiosia archaeon
32585025 32585025 PRJNA890871_P_NODE_22159_length_350_cov_2.014440_g22024_i0 PRJNA890871 22159 350 2.01444 7.05054 Haloarculaceae archaeon 2497615 Archaea Archaea 43.9 0.0419   NR MFB6172384.1 2497615 g22024 i0 35.6 0.865714285714286 101 64 86.6 1 1 303 15 114 MFB6172384.1 SDR family oxidoreductase [Haloarculaceae archaeon] diamond 303 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae   Haloarculaceae 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);;