RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA669701 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26650291 26650291 PRJNA669701_P_NODE_102581_length_256_cov_1.606557_g102186_i0 PRJNA669701 102581 256 1.606557 4.11278592 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 164 2.78e-47   NR GKS61920.1 2109671 g102186 i0 91.8 1.9921875 85 7 99.6 0 2 256 82 166 GKS61920.1 hypothetical protein YTPLAS21_13780 [Candidatus Nitrosocosmicus sp.] diamond 510 164 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
26923527 26923527 PRJNA669701_P_NODE_91562_length_268_cov_1.656410_g91167_i0 PRJNA669701 91562 268 1.65641 4.4391788 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 158 6.9399999999999985e-43   NR HKR72619.1 2109671 g91167 i0 89.9 0.996268656716418 89 9 99.6 0 2 268 347 435 HKR72619.1 HAMP domain-containing sensor histidine kinase [Candidatus Nitrosocosmicus sp.] diamond 267 158 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
27050130 27050130 PRJNA669701_P_NODE_143842_length_238_cov_3.321212_g143447_i0 PRJNA669701 143842 238 3.321212 7.90448456 Nitrososphaerales archaeon 2268197 Archaea Archaea 65.9 2.34e-11   NR MEM4726060.1 2268197 g143447 i0 70.7 0.516806722689076 41 12 51.7 0 114 236 6 46 MEM4726060.1 hypothetical protein [Nitrososphaerales archaeon] diamond 123 65.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
27081608 27081608 PRJNA669701_P_NODE_139502_length_242_cov_0.911243_g139107_i0 PRJNA669701 139502 242 0.911243 2.20520806 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 163 2.38e-50   NR HEX2408562.1 2169593 g139107 i0 100 0.991735537190083 80 0 99.2 0 240 1 10 89 HEX2408562.1 MGMT family protein [Nitrososphaeraceae archaeon] diamond 240 163 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27207866 27207866 PRJNA669701_P_NODE_98822_length_260_cov_1.748663_g98427_i0 PRJNA669701 98822 260 1.748663 4.5465238 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 171 1.97e-51   NR HJS63398.1 2169593 g98427 i0 93 2.97692307692308 86 6 99.2 0 2 259 65 150 HJS63398.1 zinc-binding dehydrogenase [Nitrososphaeraceae archaeon] diamond 774 171 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27682208 27682208 PRJNA669701_P_NODE_109024_length_251_cov_0.865169_g108629_i0 PRJNA669701 109024 251 0.865169 2.17157419 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 113 6.0599999999999996e-31   NR HEX2408513.1 2169593 g108629 i0 96.2 0.633466135458167 53 2 63.3 0 250 92 8 60 HEX2408513.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 159 113 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27934508 27934508 PRJNA669701_P_NODE_121825_length_247_cov_0.885057_g121430_i0 PRJNA669701 121825 247 0.885057 2.18609079 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 139 3.22e-40   NR HEX7143261.1 2169593 g121430 i0 91.5 1.9919028340081 82 7 99.6 0 247 2 16 97 HEX7143261.1 phosphohistidine phosphatase SixA [Nitrososphaeraceae archaeon] diamond 492 139 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28060663 28060663 PRJNA669701_P_NODE_102985_length_255_cov_3.609890_g102590_i0 PRJNA669701 102985 255 3.60989 9.2052195 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 54.3 3.55e-6   NR HKO65687.1 2109671 g102590 i0 45.3 2.03529411764706 53 29 62.4 0 253 95 513 565 HKO65687.1 DUF2254 family protein [Candidatus Nitrosocosmicus sp.] diamond 519 54.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
28186824 28186824 PRJNA669701_P_NODE_138746_length_242_cov_0.911243_g138351_i0 PRJNA669701 138746 242 0.911243 2.20520806 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 45.4 0.00125   NR HKO66053.1 2109671 g138351 i0 95.8 0.297520661157025 24 1 29.8 0 167 238 1 24 HKO66053.1 NAD(P)H-binding protein [Candidatus Nitrosocosmicus sp.] diamond 72 45.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
28629267 28629267 PRJNA669701_P_NODE_104227_length_254_cov_1.828729_g103832_i0 PRJNA669701 104227 254 1.828729 4.64497166 Nitrososphaerales archaeon 2268197 Archaea Archaea 61.6 1.92e-9   NR MEM4726185.1 2268197 g103832 i0 61.1 0.637795275590551 54 17 60.2 2 3 155 119 171 MEM4726185.1 hypothetical protein [Nitrososphaerales archaeon] diamond 162 61.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
28723863 28723863 PRJNA669701_P_NODE_89067_length_271_cov_1.555556_g88672_i0 PRJNA669701 89067 271 1.555556 4.21555676 Nitrososphaerota archaeon 2026795 Archaea Archaea 88.2 3.75e-19   NR RZD46545.1 2026795 g88672 i0 44.9 0.985239852398524 89 49 98.5 0 3 269 135 223 RZD46545.1 MAG: hypothetical protein CXT78_04015 [Nitrososphaerota archaeon] diamond 267 88.2 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29071335 29071335 PRJNA669701_P_NODE_86768_length_274_cov_1.238806_g86373_i0 PRJNA669701 86768 274 1.238806 3.39432844 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 50.8 7.18e-5   NR HKO41514.1 2169593 g86373 i0 85.2 0.295620437956204 27 4 29.6 0 134 214 1 27 HKO41514.1 helix-turn-helix domain-containing protein [Nitrososphaeraceae archaeon] diamond 81 50.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29134526 29134526 PRJNA669701_P_NODE_80629_length_281_cov_1.480769_g80234_i0 PRJNA669701 80629 281 1.480769 4.16096089 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 162 1.24e-46   NR HET6590540.1 2109671 g80234 i0 96.8 1.98576512455516 93 3 99.3 0 280 2 84 176 HET6590540.1 mechanosensitive ion channel family protein [Candidatus Nitrosocosmicus sp.] diamond 558 162 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
30398065 30398065 PRJNA669701_P_NODE_139973_length_241_cov_2.660714_g139578_i0 PRJNA669701 139973 241 2.660714 6.41232074 Candidatus Nitrosocosmicus sp. FF01 3397670 Archaea Archaea 92.8 8.339999999999999e-23   NR WP_415312390.1 3397670 g139578 i0 83.7 0.609958506224066 49 8 61 0 209 63 23 71 WP_415312390.1 hypothetical protein [Candidatus Nitrosocosmicus sp. FF01] diamond 147 92.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp. FF01
30757159 30757159 PRJNA669701_P_NODE_119214_length_248_cov_0.880000_g118819_i0 PRJNA669701 119214 248 0.88 2.1824 Thermoproteati 1783275 Archaea Archaea 158 1.53e-44   NR RPJ24498.1 2026768 g118819 i0 97.6 3.96774193548387 82 2 99.2 0 248 3 138 219 RPJ24498.1 MAG: acetolactate synthase large subunit, partial [Nitrosopumilales archaeon] diamond 984 158 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
32009896 32009896 PRJNA669701_P_NODE_103358_length_255_cov_1.692308_g102963_i0 PRJNA669701 103358 255 1.692308 4.3153854 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 150 9.179999999999997e-43   NR HKO41343.1 2169593 g102963 i0 88.2 1 85 10 100 0 255 1 161 245 HKO41343.1 AmmeMemoRadiSam system protein B [Nitrososphaeraceae archaeon] diamond 255 150 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32326696 32326696 PRJNA669701_P_NODE_85079_length_276_cov_1.285714_g84684_i0 PRJNA669701 85079 276 1.285714 3.54857064 Nitrosotalea sp. 2833567 Archaea Archaea 157 2.1299999999999994e-42   NR HUL51488.1 2833567 g84684 i0 79.1 0.989130434782609 91 19 98.9 0 275 3 711 801 HUL51488.1 DNA methyltransferase [Nitrosotalea sp.] diamond 273 157 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
32516367 32516367 PRJNA669701_P_NODE_147599_length_227_cov_2.487013_g147204_i0 PRJNA669701 147599 227 2.487013 5.64551951 Candidatus Nitrosocosmicus sp. FF01 3397670 Archaea Archaea 152 2.7499999999999993e-43   NR WP_415312392.1 3397670 g147204 i0 90.7 1.98237885462555 75 7 99.1 0 225 1 145 219 WP_415312392.1 DUF2182 domain-containing protein [Candidatus Nitrosocosmicus sp. FF01] diamond 450 152 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp. FF01

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);;