RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA529241", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 12 ✖

tax_phylum 1

  • Nitrososphaerota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA529241 · 12 ✖

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
26807937 26807937 PRJNA529241_P_NODE_302361_length_173_cov_3.500000_g300039_i0 PRJNA529241 302361 173 3.5 6.055 Nitrososphaera 497726 Archaea Archaea 48.1 1.79e-4   NR WP_227717367.1 1034015 g300039 i0 84 2.60115606936416 25 4 43.4 0 76 2 168 192 WP_227717367.1 DDE-type integrase/transposase/recombinase [Nitrososphaera viennensis] diamond 450 48.5 0.991752577319588 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera viennensis
27362277 27362277 PRJNA529241_P_NODE_531123_length_151_cov_3.517544_g528801_i0 PRJNA529241 531123 151 3.517544 5.31149144 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 74.7 8.09e-16   NR HEX5185941.1 2169593 g528801 i0 53.8 3.6953642384106 93 0 99.3 1 151 2 3 95 HEX5185941.1 PhoU domain-containing protein [Nitrososphaeraceae archaeon] diamond 558 74.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28245900 28245900 PRJNA529241_P_NODE_74626_length_246_cov_3.444976_g72304_i0 PRJNA529241 74626 246 3.444976 8.47464096 Nitrosopumilus sp. 2024843 Archaea Archaea 92 2.84e-20   NR MEK0370956.1 2024843 g72304 i0 88.2 0.621951219512195 51 6 62.2 0 245 93 135 185 MEK0370956.1 DNA adenine methylase [Nitrosopumilus sp.] diamond 153 92 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
28972412 28972412 PRJNA529241_P_NODE_545888_length_151_cov_3.026316_g543566_i0 PRJNA529241 545888 151 3.026316 4.56973716 Nitrosarchaeum sp. 2026886 Archaea Archaea 95.5 5.17e-22   NR PHY09415.1 2026886 g543566 i0 94.3 1.05298013245033 53 0 99.3 1 151 2 197 249 PHY09415.1 MAG: hydroxymethylbilane synthase [Nitrosarchaeum sp.] diamond 159 95.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
29225040 29225040 PRJNA529241_P_NODE_118409_length_203_cov_7.349398_g116087_i0 PRJNA529241 118409 203 7.349398 14.91927794 Nitrosopumilus sp. 2024843 Archaea Archaea 136 2.72e-38   NR MBA3286326.1 2024843 g116087 i0 86.6 5.91133004926108 67 9 99 0 201 1 16 82 MBA3286326.1 hypothetical protein [Nitrosopumilus sp.] diamond 1200 136 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
31183057 31183057 PRJNA529241_P_NODE_450675_length_156_cov_4.470588_g448353_i0 PRJNA529241 450675 156 4.470588 6.97411728 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 51.2 1.17e-5   NR HWY33581.1 2202732 g448353 i0 71.9 1.32692307692308 32 9 61.5 0 153 58 320 351 HWY33581.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 207 51.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
31499747 31499747 PRJNA529241_P_NODE_431356_length_163_cov_10.801587_g429034_i0 PRJNA529241 431356 163 10.801587 17.60658681 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 103 2.0299999999999998e-24   NR HWY33039.1 2202732 g429034 i0 96.3 0.993865030674847 54 2 99.4 0 1 162 32 85 HWY33039.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 162 103 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
31784061 31784061 PRJNA529241_P_NODE_21977_length_457_cov_8.216667_g19728_i0 PRJNA529241 21977 457 8.216667 37.55016819 Nitrososphaerota archaeon 2026795 Archaea Archaea 59.7 2.75e-7   NR NDB88320.1 2026795 g19728 i0 73.5 0.663019693654267 34 9 22.3 0 149 250 127 160 NDB88320.1 NAD-dependent epimerase/dehydratase family protein [Nitrososphaerota archaeon] diamond 303 59.7 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31942249 31942249 PRJNA529241_P_NODE_391277_length_173_cov_2.389706_g388955_i0 PRJNA529241 391277 173 2.389706 4.13419138 Nitrosopumilus sp. 2024843 Archaea Archaea 60.8 9.46e-10   NR MCI4432052.1 2024843 g388955 i0 47.8 1.16184971098266 67 23 95.4 1 7 171 45 111 MCI4432052.1 hypothetical protein [Nitrosopumilus sp.] diamond 201 60.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
32227315 32227315 PRJNA529241_P_NODE_20798_length_474_cov_9.107551_g18577_i0 PRJNA529241 20798 474 9.107551 43.16979174 Nitrososphaerota archaeon 2026795 Archaea Archaea 60.1 2.33e-7   NR NDB88320.1 2026795 g18577 i0 73.5 0.639240506329114 34 9 21.5 0 234 133 127 160 NDB88320.1 NAD-dependent epimerase/dehydratase family protein [Nitrososphaerota archaeon] diamond 303 60.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
32274207 32274207 PRJNA529241_P_NODE_363938_length_173_cov_2.727941_g361616_i0 PRJNA529241 363938 173 2.727941 4.71933793 Nitrosotalea 1078904 Archaea Archaea 95.1 1.27e-21   NR MDE1844897.1 2026795 g361616 i0 82.1 3.91907514450867 56 9 97.1 1 171 4 136 190 MDE1844897.1 biotin--[acetyl-CoA-carboxylase] ligase [Nitrososphaerota archaeon] diamond 678 95.5 0.995811518324607 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
32732850 32732850 PRJNA529241_P_NODE_573840_length_150_cov_4.176991_g571518_i0 PRJNA529241 573840 150 4.176991 6.2654865 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 48.1 1e-5   NR HWY35131.1 2202732 g571518 i0 100 0.96 24 0 48 0 74 3 3 26 HWY35131.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 144 48.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae 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);;