RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1111146", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1111146 · 5 ✖

analysis 1

tax_clade 0

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
27532965 27532965 PRJNA1111146_P_NODE_336183_length_183_cov_0.876923_g335045_i0 PRJNA1111146 336183 183 0.876923 1.60476909 Thermoproteati 1783275 Archaea Archaea 122 3.94e-34   NR HWS20938.1 1971748 g335045 i0 96.7 2.95081967213115 60 2 98.4 0 182 3 64 123 HWS20938.1 hypothetical protein [Nitrososphaera sp.] diamond 540 123 0.991869918699187 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29152384 29152384 PRJNA1111146_P_NODE_297729_length_187_cov_1.694030_g296591_i0 PRJNA1111146 297729 187 1.69403 3.1678361 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 65.1 4.23e-11   NR MEM4301557.1 2972665 g296591 i0 96.9 0.513368983957219 32 1 51.3 0 97 2 1 32 MEM4301557.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 96 65.1 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
29499267 29499267 PRJNA1111146_P_NODE_235030_length_199_cov_1.561644_g233892_i0 PRJNA1111146 235030 199 1.561644 3.10767156 Candidatus Caldarchaeales archaeon 3071590 Archaea Archaea 76.3 2e-14   NR MDT7877103.1 3071590 g233892 i0 84.6 0.587939698492462 39 6 58.8 0 82 198 1 39 MDT7877103.1 polysaccharide pyruvyl transferase family protein [Candidatus Caldarchaeales archaeon] diamond 117 76.3 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales     Candidatus Caldarchaeales archaeon
31426619 31426619 PRJNA1111146_P_NODE_405316_length_179_cov_0.888889_g404178_i0 PRJNA1111146 405316 179 0.888889 1.59111131 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 110 1.06e-26   NR HYJ02854.1 2169593 g404178 i0 96.6 3.95530726256983 59 2 98.9 0 2 178 188 246 HYJ02854.1 ArsB/NhaD family transporter [Nitrososphaeraceae archaeon] diamond 708 110 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32027713 32027713 PRJNA1111146_P_NODE_221598_length_202_cov_1.369128_g220460_i0 PRJNA1111146 221598 202 1.369128 2.76563856 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 52.8 5.41e-6   NR HVD07366.1 2169593 g220460 i0 43.8 1.78217821782178 64 36 95 0 6 197 180 243 HVD07366.1 retropepsin-like aspartic protease [Nitrososphaeraceae archaeon] diamond 360 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;