RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA888821 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
27023804 27023804 PRJNA888821_P_NODE_36222_length_248_cov_0.880000_g36139_i0 PRJNA888821 36222 248 0.88 2.1824 archaeon 1906665 Archaea Archaea 109 1.23e-27   NR RYH30363.1 1906665 g36139 i0 73.1 0.810483870967742 67 18 81 0 248 48 159 225 RYH30363.1 MAG: hypothetical protein EON65_05400 [archaeon] diamond 201 109 1 Archaea               archaeon
27149872 27149872 PRJNA888821_P_NODE_45582_length_219_cov_7.924658_g45499_i0 PRJNA888821 45582 219 7.924658 17.35500102 Halobacterium bonnevillei 2692200 Archaea Archaea 72.4 5.29e-13   NR WP_159526771.1 2692200 g45499 i0 85 1.08219178082192 40 6 54.8 0 2 121 262 301 WP_159526771.1 ABC transporter permease [Halobacterium bonnevillei] diamond 237 72.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium bonnevillei
28097715 28097715 PRJNA888821_P_NODE_49465_length_207_cov_8.037313_g49382_i0 PRJNA888821 49465 207 8.037313 16.63723791 Halobacteriaceae archaeon 1931997 Archaea Archaea 98.2 6.29e-22   NR MFB6255096.1 1931997 g49382 i0 69.6 2 69 21 100 0 1 207 111 179 MFB6255096.1 uracil-xanthine permease family protein [Halobacteriaceae archaeon] diamond 414 98.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae   Halobacteriaceae archaeon
28571314 28571314 PRJNA888821_P_NODE_24727_length_293_cov_3.477273_g24645_i0 PRJNA888821 24727 293 3.477273 10.18840989 Methanothrix sp. 90426 Archaea Archaea 61.2 4.67e-9   NR MCK9566439.1 90426 g24645 i0 78.1 0.327645051194539 32 7 32.8 0 122 27 1 32 MCK9566439.1 HNH endonuclease [Methanothrix sp.] diamond 96 61.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28855348 28855348 PRJNA888821_P_NODE_27448_length_281_cov_7.442308_g27366_i0 PRJNA888821 27448 281 7.442308 20.91288548 Halolamina sp. 1940283 Archaea Archaea 66.2 2.28e-12   NR WP_014050829.1 1940283 g27366 i0 82.9 0.437722419928826 41 7 43.8 0 47 169 1 41 WP_014050829.1 hypothetical protein [Halolamina sp.] diamond 123 66.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halolamina Halolamina sp.
28918492 28918492 PRJNA888821_P_NODE_44308_length_223_cov_26.386667_g44225_i0 PRJNA888821 44308 223 26.386667 58.84226741 Thermoproteota archaeon 2056631 Archaea Archaea 154 1.77e-46   NR MDQ3727269.1 2056631 g44225 i0 98.6 2.94618834080717 74 1 99.6 0 222 1 15 88 MDQ3727269.1 hypothetical protein [Thermoproteota archaeon] diamond 657 154 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29265826 29265826 PRJNA888821_P_NODE_37409_length_245_cov_4.075581_g37326_i0 PRJNA888821 37409 245 4.075581 9.98517345 Halolamina sp. 1940283 Archaea Archaea 67.4 4.51e-11   NR MFB6221925.1 1940283 g37326 i0 70 1.22448979591837 50 12 61.2 1 204 55 55 101 MFB6221925.1 hypothetical protein [Halolamina sp.] diamond 300 67.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halolamina Halolamina sp.
29392425 29392425 PRJNA888821_P_NODE_8809_length_310_cov_12.852321_g8727_i0 PRJNA888821 8809 310 12.852321 39.8421951 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 59.3 1.23e-7   NR MEM5878277.1 3121606 g8727 i0 50 0.483870967741935 50 25 48.4 0 309 160 496 545 MEM5878277.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] diamond 150 59.3 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
30308729 30308729 PRJNA888821_P_NODE_40052_length_238_cov_15.660606_g39969_i0 PRJNA888821 40052 238 15.660606 37.27224228 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 51.6 1.23e-5   NR MEM5877746.1 3121606 g39969 i0 48 1.27310924369748 50 26 63 0 87 236 2 51 MEM5877746.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] diamond 303 51.6 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
30348222 30348222 PRJNA888821_P_NODE_38752_length_242_cov_4.254438_g38669_i0 PRJNA888821 38752 242 4.254438 10.29573996 Halobacteriales 2235 Archaea Archaea 120 2.0099999999999997e-30   NR WP_338914891.1 2162630 g38669 i0 72.4 1.88429752066116 76 21 94.2 0 242 15 184 259 WP_338914891.1 MULTISPECIES: amidohydrolase family protein [Salinirubellus] diamond 456 120 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Salinirubellus  
31192530 31192530 PRJNA888821_P_NODE_14675_length_310_cov_6.793249_g14593_i0 PRJNA888821 14675 310 6.793249 21.0590719 Nitrososphaerales archaeon 2268197 Archaea Archaea 60.5 1e-8   NR MFI5407391.1 2268197 g14593 i0 63.6 0.851612903225806 44 16 42.6 0 149 18 124 167 MFI5407391.1 endonuclease/exonuclease/phosphatase family protein [Nitrososphaerales archaeon] diamond 264 60.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
31604143 31604143 PRJNA888821_P_NODE_35856_length_248_cov_9.708571_g35773_i0 PRJNA888821 35856 248 9.708571 24.07725608 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 92.4 5.2e-20   NR MFH8120400.1 3121606 g35773 i0 62 0.858870967741935 71 26 85.9 1 248 36 174 243 MFH8120400.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] diamond 213 92.4 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
31667253 31667253 PRJNA888821_P_NODE_29457_length_272_cov_6.788945_g29375_i0 PRJNA888821 29457 272 6.788945 18.4659304 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 53.5 1.97e-6   NR MDR4489495.1 2109671 g29375 i0 57.4 0.518382352941177 47 19 51.8 1 149 9 1 46 MDR4489495.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] diamond 141 53.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
32300464 32300464 PRJNA888821_P_NODE_31379_length_264_cov_3.952880_g31296_i0 PRJNA888821 31379 264 3.95288 10.4356032 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 139 9.74e-39   NR HEX6646956.1 2169593 g31296 i0 83.5 0.897727272727273 79 13 89.8 0 237 1 1 79 HEX6646956.1 phosphate ABC transporter ATP-binding protein PstB [Nitrososphaeraceae archaeon] diamond 237 139 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32426713 32426713 PRJNA888821_P_NODE_8759_length_310_cov_12.957806_g8677_i0 PRJNA888821 8759 310 12.957806 40.1691986 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 58.2 3.26e-7   NR MEM5878506.1 3121606 g8677 i0 59.2 0.474193548387097 49 19 47.4 1 163 309 809 856 MEM5878506.1 M15 family metallopeptidase [Candidatus Aenigmatarchaeota archaeon] diamond 147 58.2 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
32553513 32553513 PRJNA888821_P_NODE_16719_length_310_cov_5.350211_g16637_i0 PRJNA888821 16719 310 5.350211 16.5856541 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 105 1.0099999999999999e-23   NR MEM5877803.1 3121606 g16637 i0 50.5 0.996774193548387 103 47 95.8 1 308 12 707 809 MEM5877803.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] diamond 309 105 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
32742347 32742347 PRJNA888821_P_NODE_25380_length_290_cov_17.783410_g25298_i0 PRJNA888821 25380 290 17.78341 51.571889 archaeon 1906665 Archaea Archaea 95.5 2.16e-21   NR NCQ51819.1 1906665 g25298 i0 44.2 0.982758620689655 95 53 98.3 0 289 5 86 180 NCQ51819.1 hypothetical protein [archaeon] diamond 285 95.5 1 Archaea               archaeon
32836583 32836583 PRJNA888821_P_NODE_49380_length_207_cov_11.768657_g49297_i0 PRJNA888821 49380 207 11.768657 24.36111999 halophilic archaeon DL31 756883 Archaea Archaea 62.8 2.78e-11   NR AEN07052.1 756883 g49297 i0 78.9 0.550724637681159 38 8 55.1 0 115 2 3 40 AEN07052.1 hypothetical protein Halar_3454 [halophilic archaeon DL31] diamond 114 62.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon DL31

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