RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA951412 · 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
934881 934881 PRJNA951412_P_NODE_7721_length_242_cov_0.923077_g7636_i0 PRJNA951412 7721 242 0.923077 2.23384634 Halosimplex sp. 1882270 Archaea Archaea 132 1.2599999999999999e-34   NR MFB6138835.1 1882270 g7636 i0 77.5 3.96694214876033 80 17 99.2 1 3 242 14 92 MFB6138835.1 NAD(P)/FAD-dependent oxidoreductase [Halosimplex sp.] diamond 960 132 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex sp.
7312828 7312828 PRJNA951412_P_NODE_6706_length_245_cov_0.906977_g6621_i0 PRJNA951412 6706 245 0.906977 2.22209365 Natronomonas sp. LN261 2750669 Archaea Archaea 156 4.52e-44   NR WP_181691280.1 2750669 g6621 i0 95.1 0.991836734693878 81 4 99.2 0 243 1 167 247 WP_181691280.1 M20 family metallopeptidase [Natronomonas sp. LN261] diamond 243 156 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
11138469 11138469 PRJNA951412_P_NODE_4729_length_251_cov_0.865169_g4644_i0 PRJNA951412 4729 251 0.865169 2.17157419 Natronomonas sp. LN261 2750669 Archaea Archaea 149 1.6899999999999996e-41   NR WP_181692432.1 2750669 g4644 i0 91.5 0.9800796812749 82 7 98 0 246 1 96 177 WP_181692432.1 chemotaxis protein CheC [Natronomonas sp. LN261] diamond 246 149 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
13688505 13688505 PRJNA951412_P_NODE_7731_length_242_cov_0.923077_g7646_i0 PRJNA951412 7731 242 0.923077 2.23384634 Natronomonas sp. LN261 2750669 Archaea Archaea 93.2 1.76e-20   NR WP_181693485.1 2750669 g7646 i0 95.5 0.545454545454545 44 2 54.5 0 109 240 1 44 WP_181693485.1 NAD-dependent epimerase/dehydratase family protein [Natronomonas sp. LN261] diamond 132 93.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
14962661 14962661 PRJNA951412_P_NODE_4412_length_252_cov_0.865922_g4327_i0 PRJNA951412 4412 252 0.865922 2.18212344 Halonotius roseus 2511997 Archaea Archaea 156 4.5599999999999996e-46   NR WP_142443841.1 2511997 g4327 i0 97.6 0.988095238095238 83 2 98.8 0 3 251 9 91 WP_142443841.1 thiamine phosphate synthase [Halonotius roseus] diamond 249 156 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halonotius Halonotius roseus
16237660 16237660 PRJNA951412_P_NODE_6293_length_246_cov_0.901734_g6208_i0 PRJNA951412 6293 246 0.901734 2.21826564 Natronomonas sp. LN261 2750669 Archaea Archaea 86.7 9.14e-18   NR WP_181692432.1 2750669 g6208 i0 95.5 0.536585365853659 44 2 53.7 0 246 115 355 398 WP_181692432.1 chemotaxis protein CheC [Natronomonas sp. LN261] diamond 132 86.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
18786540 18786540 PRJNA951412_P_NODE_4255_length_252_cov_0.871508_g4170_i0 PRJNA951412 4255 252 0.871508 2.19620016 Halonotius aquaticus 2216978 Archaea Archaea 163 2.75e-46   NR WP_120103076.1 2216978 g4170 i0 98.8 0.988095238095238 83 1 98.8 0 2 250 275 357 WP_120103076.1 NAD(P)/FAD-dependent oxidoreductase [Halonotius aquaticus] diamond 249 163 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halonotius Halonotius aquaticus
26867591 26867591 PRJNA951412_P_NODE_4321_length_252_cov_0.871508_g4236_i0 PRJNA951412 4321 252 0.871508 2.19620016 Halodesulfurarchaeum sp. 1980530 Archaea Archaea 95.1 1.2600000000000002e-21   NR MBS3760554.1 1980530 g4236 i0 77.4 0.738095238095238 62 14 73.8 0 186 1 16 77 MBS3760554.1 DNA repair and recombination protein RadB [Halodesulfurarchaeum sp.] diamond 186 95.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halodesulfurarchaeum Halodesulfurarchaeum sp.
28005007 28005007 PRJNA951412_P_NODE_3725_length_260_cov_1.352941_g3640_i0 PRJNA951412 3725 260 1.352941 3.5176466 Halegenticoccus soli 1985678 Archaea Archaea 64.7 8.59e-10   NR WP_101294165.1 1985678 g3640 i0 43.7 1.00384615384615 87 48 99.2 1 259 2 179 265 WP_101294165.1 hypothetical protein [Halegenticoccus soli] diamond 261 64.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halegenticoccus Halegenticoccus soli
28383643 28383643 PRJNA951412_P_NODE_4586_length_251_cov_0.876404_g4501_i0 PRJNA951412 4586 251 0.876404 2.19977404 Halodesulfurarchaeum sp. 1980530 Archaea Archaea 156 2.66e-45   NR MDZ7850522.1 1980530 g4501 i0 90.4 0.99203187250996006 83 8 99.2 0 1 249 188 270 MDZ7850522.1 ethylbenzene dehydrogenase-related protein [Halodesulfurarchaeum sp.] diamond 249 156 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halodesulfurarchaeum Halodesulfurarchaeum sp.
29369035 29369035 PRJNA951412_P_NODE_4289_length_252_cov_0.871508_g4204_i0 PRJNA951412 4289 252 0.871508 2.19620016 Halobacteriales 2235 Archaea Archaea 117 1.68e-28   NR WP_230888756.1 2896367 g4204 i0 72 3.94047619047619 82 23 97.6 0 246 1 380 461 WP_230888756.1 PAS domain S-box protein [Halobacterium sp. KA-4] diamond 993 117 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium sp. KA-4
29899379 29899379 PRJNA951412_P_NODE_5271_length_249_cov_0.886364_g5186_i0 PRJNA951412 5271 249 0.886364 2.20704636 Haloarcula argentinensis 43776 Archaea Archaea 152 1.0699999999999998e-41   NR WP_188853907.1 43776 g5186 i0 95.1 0.987951807228916 82 4 98.8 0 2 247 453 534 WP_188853907.1 TrkH family potassium uptake protein [Haloarcula argentinensis] diamond 246 152 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula argentinensis
30436625 30436625 PRJNA951412_P_NODE_2353_length_308_cov_1.323404_g2268_i0 PRJNA951412 2353 308 1.323404 4.07608432 Halohasta salina 2961621 Archaea Archaea 176 3.53e-50   NR WP_253737513.1 2961621 g2268 i0 94 0.974025974025974 100 6 97.4 0 2 301 465 564 WP_253737513.1 L-lactate permease [Halohasta salina] diamond 300 176 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halohasta Halohasta salina
30468229 30468229 PRJNA951412_P_NODE_7893_length_242_cov_0.917160_g7808_i0 PRJNA951412 7893 242 0.91716 2.2195272 Natronomonas sp. LN261 2750669 Archaea Archaea 143 6.48e-42   NR WP_181692987.1 2750669 g7808 i0 90 0.991735537190083 80 8 99.2 0 240 1 4 83 WP_181692987.1 universal stress protein [Natronomonas sp. LN261] diamond 240 143 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
30822040 30822040 PRJNA951412_P_NODE_7814_length_242_cov_0.923077_g7729_i0 PRJNA951412 7814 242 0.923077 2.23384634 Halorubrum 56688 Archaea Archaea 89.4 1.44e-18   NR WP_049984111.1 1498500 g7729 i0 63.1 3.14876033057851 65 24 80.6 0 43 237 372 436 WP_049984111.1 3'-5' exonuclease [Halorubrum sp. BV1] diamond 762 89.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. BV1
31068439 31068439 PRJNA951412_P_NODE_6595_length_245_cov_0.906977_g6510_i0 PRJNA951412 6595 245 0.906977 2.22209365 Halanaeroarchaeum sp. HSR-CO 2866382 Archaea Archaea 159 2.05e-45   NR WP_259517120.1 2866382 g6510 i0 92.6 1.98367346938776 81 6 99.2 0 243 1 219 299 WP_259517120.1 site-specific integrase [Halanaeroarchaeum sp. HSR-CO] diamond 486 159 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halanaeroarchaeum Halanaeroarchaeum sp. HSR-CO
31257854 31257854 PRJNA951412_P_NODE_7755_length_242_cov_0.923077_g7670_i0 PRJNA951412 7755 242 0.923077 2.23384634 Haloplanus sp. GCM1 1961696 Archaea Archaea 120 1.0699999999999999e-32   NR WP_379798641.1 3252679 g7670 i0 72.5 0.991735537190083 80 22 99.2 0 1 240 9 88 WP_379798641.1 hypothetical protein [Haloplanus sp. GCM10025708] diamond 240 120 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus sp. GCM10025708
32112011 32112011 PRJNA951412_P_NODE_4838_length_250_cov_0.881356_g4753_i0 PRJNA951412 4838 250 0.881356 2.20339 Natronomonas sp. LN261 2750669 Archaea Archaea 154 8.4e-45   NR WP_181693334.1 2750669 g4753 i0 98.8 0.996 83 1 99.6 0 249 1 59 141 WP_181693334.1 PHP domain-containing protein [Natronomonas sp. LN261] diamond 249 154 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261

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