RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA529241" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 20 ✖

bioproject 1

  • PRJNA529241 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
26982458 26982458 PRJNA529241_P_NODE_11002_length_798_cov_12.127464_g5561_i1 PRJNA529241 11002 798 12.127464 96.77716272 Thermoproteota archaeon 2056631 Archaea Archaea 59.3 9.55e-8   NR RDJ34928.1 2056631 g5561 i1 43.5 0.259398496240602 69 39 25.9 0 419 213 2 70 RDJ34928.1 MAG: hypothetical protein DWQ19_08830 [Thermoproteota archaeon] diamond 207 59.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
26982488 26982488 PRJNA529241_P_NODE_190862_length_173_cov_6.926471_g188540_i0 PRJNA529241 190862 173 6.926471 11.98279483 Thermoproteota archaeon 2056631 Archaea Archaea 44.7 0.00211   NR MDT7864672.1 2056631 g188540 i0 91.7 0.416184971098266 24 2 41.6 0 74 3 31 54 MDT7864672.1 phosphoribosyltransferase family protein [Thermoproteota archaeon] diamond 72 44.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
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
28182598 28182598 PRJNA529241_P_NODE_183866_length_173_cov_7.764706_g181544_i0 PRJNA529241 183866 173 7.764706 13.43294138 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 79.3 1.74e-15   NR HEX9430277.1 3045160 g181544 i0 62.3 1.05780346820809 61 19 98.8 1 2 172 349 409 HEX9430277.1 DNA polymerase A family protein [Candidatus Bathyarchaeia archaeon] diamond 183 79.3 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia 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.
28372325 28372325 PRJNA529241_P_NODE_567386_length_150_cov_5.035398_g565064_i0 PRJNA529241 567386 150 5.035398 7.553097 Candidatus Methanomethylicaceae archaeon 2282146 Archaea Archaea 41.2 0.0381   NR MCS7098217.1 2282146 g565064 i0 36.4 0.88 44 28 88 0 138 7 288 331 MCS7098217.1 type IV secretion system DNA-binding domain-containing protein [Candidatus Methanomethyliaceae archaeon] diamond 132 41.2 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia Candidatus Methanomethylicales Candidatus Methanomethylicaceae   Candidatus Methanomethylicaceae archaeon
28845841 28845841 PRJNA529241_P_NODE_6628_length_1253_cov_13.075658_g5561_i0 PRJNA529241 6628 1253 13.075658 163.83799474 Thermoproteota archaeon 2056631 Archaea Archaea 59.3 2.11e-7   NR RDJ34928.1 2056631 g5561 i0 43.5 0.165203511572227 69 39 16.5 0 874 668 2 70 RDJ34928.1 MAG: hypothetical protein DWQ19_08830 [Thermoproteota archaeon] diamond 207 59.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
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.
30425388 30425388 PRJNA529241_P_NODE_11213_length_785_cov_12.233957_g5561_i2 PRJNA529241 11213 785 12.233957 96.03656245 Thermoproteota archaeon 2056631 Archaea Archaea 59.3 9.17e-8   NR RDJ34928.1 2056631 g5561 i2 43.5 0.263694267515924 69 39 26.4 0 406 200 2 70 RDJ34928.1 MAG: hypothetical protein DWQ19_08830 [Thermoproteota archaeon] diamond 207 59.3 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
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
32259128 32259128 PRJNA529241_P_NODE_134418_length_194_cov_1.242038_g132096_i0 PRJNA529241 134418 194 1.242038 2.40955372 Desulfurococcales archaeon 2480821 Archaea Archaea 41.6 0.0492   NR NAZ13377.1 2480821 g132096 i0 34.4 0.989690721649485 64 39 94.3 1 190 8 172 235 NAZ13377.1 glycosyltransferase [Desulfurococcales archaeon] diamond 192 41.6 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales     Desulfurococcales 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
32716283 32716283 PRJNA529241_P_NODE_558700_length_150_cov_6.955752_g556378_i0 PRJNA529241 558700 150 6.955752 10.433628 Archaea 2157 Archaea Archaea 54.7 4.2e-7   NR MDT7864923.1 2056631 g556378 i0 100 1 25 0 50 0 74 148 134 158 MDT7864923.1 hypothetical protein [Thermoproteota archaeon] diamond 150 54.7 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;