RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA675638" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 8 ✖

bioproject 1

  • PRJNA675638 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27239897 27239897 PRJNA675638_P_NODE_5423_length_291_cov_1.475207_g5226_i0 PRJNA675638 5423 291 1.475207 4.29285237 Promethearchaeota archaeon 2053489 Archaea Archaea 85.1 8.47e-17   NR MCJ7651480.1 2053489 g5226 i0 44.8 0.989690721649485 96 52 97.9 1 2 286 268 363 MCJ7651480.1 terminase family protein [Promethearchaeota archaeon] diamond 288 85.1 1 Archaea   Promethearchaeati Promethearchaeota         Promethearchaeota archaeon
28060969 28060969 PRJNA675638_P_NODE_14425_length_189_cov_0.935714_g14228_i0 PRJNA675638 14425 189 0.935714 1.76849946 Nitrosopumilus sp. 2024843 Archaea Archaea 41.6 0.0444   NR WP_299291794.1 2024843 g14228 i0 44.2 0.682539682539683 43 23 66.7 1 2 127 100 142 WP_299291794.1 LlaMI family restriction endonuclease [Nitrosopumilus sp.] diamond 129 41.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
28124262 28124262 PRJNA675638_P_NODE_14545_length_188_cov_1.431655_g14348_i0 PRJNA675638 14545 188 1.431655 2.6915114 Methanohalobium sp. 2837493 Archaea Archaea 75.1 6.73e-14   NR WP_292486519.1 2837493 g14348 i0 57.4 0.973404255319149 61 22 97.3 1 6 188 118 174 WP_292486519.1 DnaB-like helicase C-terminal domain-containing protein [Methanohalobium sp.] diamond 183 75.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanohalobium Methanohalobium sp.
28787058 28787058 PRJNA675638_P_NODE_7467_length_252_cov_1.256158_g7270_i0 PRJNA675638 7467 252 1.256158 3.16551816 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 63.9 1.23e-9   NR MFA5484894.1 2026773 g7270 i0 46.1 1.97619047619048 76 39 89.3 2 27 251 115 189 MFA5484894.1 RNA ligase family protein [Candidatus Pacearchaeota archaeon] diamond 498 63.9 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
29040074 29040074 PRJNA675638_P_NODE_17908_length_168_cov_1.285714_g17711_i0 PRJNA675638 17908 168 1.285714 2.15999952 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 77 3.99e-15   NR MDX1532672.1 2202732 g17711 i0 66.7 0.964285714285714 54 18 96.4 0 6 167 107 160 MDX1532672.1 zeta toxin family protein [Nitrosopumilaceae archaeon] diamond 162 77 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
29734191 29734191 PRJNA675638_P_NODE_16170_length_178_cov_2.186047_g15973_i0 PRJNA675638 16170 178 2.186047 3.89116366 Methanobacterium sp. 2164 Archaea Archaea 42.7 0.0144   NR MEN6291794.1 2164 g15973 i0 39.3 0.943820224719101 56 33 92.7 1 177 13 34 89 MEN6291794.1 hypothetical protein [Methanobacterium sp.] diamond 168 42.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
29987177 29987177 PRJNA675638_P_NODE_12251_length_203_cov_1.532468_g12054_i0 PRJNA675638 12251 203 1.532468 3.11091004 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 42 0.0339   NR PMB74857.1 2026714 g12054 i0 37.7 1.01970443349754 69 33 87.2 1 14 190 66 134 PMB74857.1 MAG: hypothetical protein C0195_00575 [Candidatus Bathyarchaeota archaeon] diamond 207 42 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
31409234 31409234 PRJNA675638_P_NODE_11296_length_210_cov_1.900621_g11099_i0 PRJNA675638 11296 210 1.900621 3.9913041 archaeon 1906665 Archaea Archaea 52 7.16e-6   NR MCP4761907.1 1906665 g11099 i0 39.7 0.971428571428571 68 40 97.1 1 206 3 119 185 MCP4761907.1 hypothetical protein [archaeon] diamond 204 52 1 Archaea               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);;