RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA744060", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 10 ✖

tax_phylum 1

  • Nitrososphaerota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA744060 · 10 ✖

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
23676002 23676002 PRJNA744060_P_NODE_15599_length_407_cov_2.398204_g15270_i0 PRJNA744060 15599 407 2.398204 9.76069028 root 1 Root_unresolved Root_unresolved 157 2.8199999999999994e-42   NR HYC12586.1 2268197 g15270 i0 52.6 3.95823095823096 135 60 99.5 1 3 407 330 460 HYC12586.1 S9 family peptidase [Nitrososphaerales archaeon] diamond 1611 157 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
27084338 27084338 PRJNA744060_P_NODE_10562_length_493_cov_1.728571_g10234_i0 PRJNA744060 10562 493 1.728571 8.52185503 Nitrosotalea sp. 2833567 Archaea Archaea 45.8 0.0306   NR HXU95171.1 2833567 g10234 i0 26.8 0.955375253549696 157 96 85.8 6 4 426 120 273 HXU95171.1 polysaccharide deacetylase family protein [Nitrosotalea sp.] diamond 471 45.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
28442468 28442468 PRJNA744060_P_NODE_44146_length_252_cov_3.134078_g43817_i0 PRJNA744060 44146 252 3.134078 7.89787656 Nitrosopumilus sp. 2024843 Archaea Archaea 48.9 2.81e-4   NR MDH3780695.1 2024843 g43817 i0 37.2 1.94047619047619 78 36 78.6 2 242 45 211 287 MDH3780695.1 fibronectin type III domain-containing protein [Nitrosopumilus sp.] diamond 489 48.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
28473945 28473945 PRJNA744060_P_NODE_27946_length_308_cov_3.165957_g27617_i0 PRJNA744060 27946 308 3.165957 9.75114756 Nitrososphaerota archaeon 2026795 Archaea Archaea 99 1.47e-21   NR MDG6922547.1 2026795 g27617 i0 53.5 0.983766233766234 101 47 98.4 0 2 304 697 797 MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] diamond 303 99 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28789415 28789415 PRJNA744060_P_NODE_18007_length_380_cov_1.814332_g17678_i0 PRJNA744060 18007 380 1.814332 6.8944616 Nitrosotalea sp. 2833567 Archaea Archaea 60.1 1.45e-7   NR HJU14120.1 2833567 g17678 i0 42.4 1.24736842105263 66 37 52.1 1 270 73 46 110 HJU14120.1 polysaccharide deacetylase family protein [Nitrosotalea sp.] diamond 474 60.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
29610203 29610203 PRJNA744060_P_NODE_38070_length_269_cov_1.382653_g37741_i0 PRJNA744060 38070 269 1.382653 3.71933657 Nitrososphaera sp. 1971748 Archaea Archaea 55.5 1.7e-6   NR MEO9294162.1 1971748 g37741 i0 47.4 0.635687732342007 57 30 63.6 0 264 94 50 106 MEO9294162.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Nitrososphaera sp.] diamond 171 55.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30567924 30567924 PRJNA744060_P_NODE_14873_length_416_cov_3.743440_g14544_i0 PRJNA744060 14873 416 3.74344 15.5727104 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 171 9.56e-49   NR WP_196817273.1 1353260 g14544 i0 59.7 10.0240384615385 139 54 99.5 2 2 415 71 208 WP_196817273.1 ammonium transporter [Candidatus Nitrosocosmicus oleophilus] diamond 4170 172 0.994186046511628 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
31506603 31506603 PRJNA744060_P_NODE_30856_length_295_cov_1.756757_g30527_i0 PRJNA744060 30856 295 1.756757 5.18243315 Nitrosotalea sp. 2833567 Archaea Archaea 53.5 1.07e-5   NR HEU5488859.1 2833567 g30527 i0 41.5 1.98305084745763 65 37 66.1 1 280 86 31 94 HEU5488859.1 polysaccharide deacetylase family protein [Nitrosotalea sp.] diamond 585 53.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
31706183 31706183 PRJNA744060_P_NODE_53737_length_230_cov_2.382166_g53408_i0 PRJNA744060 53737 230 2.382166 5.4789818 Nitrososphaeria 1643678 Archaea Archaea 56.2 5.43e-7   NR MEO9276542.1 1971748 g53408 i0 42.6 2.66086956521739 68 37 88.7 2 211 8 31 96 MEO9276542.1 polysaccharide deacetylase family protein [Nitrososphaera sp.] diamond 612 56.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32865387 32865387 PRJNA744060_P_NODE_51920_length_239_cov_4.433735_g51591_i0 PRJNA744060 51920 239 4.433735 10.59662665 Nitrososphaerota archaeon 2026795 Archaea Archaea 77 3e-14   NR MDG6922547.1 2026795 g51591 i0 57.8 0.803347280334728 64 26 79.1 1 191 3 890 953 MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] diamond 192 77 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;