RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA816527" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 16 ✖

bioproject 1

  • PRJNA816527 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
1227916 1227916 PRJNA816527_P_NODE_16261_length_256_cov_1.983607_g16211_i0 PRJNA816527 16261 256 1.983607 5.07803392 Lawsonella clevelandensis 1528099 Bacteria Bacteria 154 3.56e-41   NR PZP88466.1 1528099 g16211 i0 100 1.96875 84 0 98.4 0 254 3 251 334 PZP88466.1 MAG: cation:proton antiporter [Lawsonella clevelandensis] diamond 504 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
2095029 2095029 PRJNA816527_P_NODE_19302_length_244_cov_1.356725_g19252_i0 PRJNA816527 19302 244 1.356725 3.310409 Mycoplasma leachii 2105 Bacteria Bacteria 127 6.480000000000001e-33   NR WP_013447532.1 2105 g19252 i0 75.6 1.00819672131148 82 19 99.6 1 244 2 26 107 WP_013447532.1 ATP-binding protein [Mycoplasma leachii] diamond 246 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma leachii
7197506 7197506 PRJNA816527_P_NODE_14726_length_273_cov_1.505000_g14676_i0 PRJNA816527 14726 273 1.505 4.10865 Corynebacterium sp. ED61 2211360 Bacteria Bacteria 150 4.32e-40   NR WP_194186892.1 2211360 g14676 i0 92.5 0.879120879120879 80 6 87.9 0 33 272 1 80 WP_194186892.1 ATP-dependent DNA helicase UvrD2 [Corynebacterium sp. ED61] diamond 240 150 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium sp. ED61
9747555 9747555 PRJNA816527_P_NODE_20368_length_241_cov_1.833333_g20318_i0 PRJNA816527 20368 241 1.833333 4.41833253 Leifsonia shinshuensis 150026 Bacteria Bacteria 137 1.91e-35   NR WP_179604217.1 150026 g20318 i0 87.5 2.95020746887967 80 10 99.6 0 240 1 542 621 WP_179604217.1 flagellar biosynthesis protein FlhA [Leifsonia shinshuensis] diamond 711 137 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia shinshuensis
26642792 26642792 PRJNA816527_P_NODE_19561_length_244_cov_0.900585_g19511_i0 PRJNA816527 19561 244 0.900585 2.1974274 Microbacterium keratanolyticum 67574 Bacteria Bacteria 138 1.86e-39   NR WP_204938489.1 67574 g19511 i0 93.8 0.983606557377049 80 5 98.4 0 4 243 10 89 WP_204938489.1 PH domain-containing protein [Microbacterium keratanolyticum] diamond 240 138 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium keratanolyticum
26999648 26999648 PRJNA816527_P_NODE_13622_length_284_cov_2.146919_g13572_i0 PRJNA816527 13622 284 2.146919 6.09724996 Leifsonia 110932 Bacteria Bacteria 178 1.72e-49   NR WP_208038931.1 2815212 g13572 i0 83.2 2.38732394366197 113 0 99.3 1 283 2 448 560 WP_208038931.1 lamin tail domain-containing protein [Leifsonia sp. TF02-11] diamond 678 178 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
27433927 27433927 PRJNA816527_P_NODE_13843_length_282_cov_1.473684_g13793_i0 PRJNA816527 13843 282 1.473684 4.15578888 Streptomyces sp. CHB9.2 2841670 Bacteria Bacteria 104 4.36e-26   NR WP_252940792.1 2841670 g13793 i0 55.6 1.0531914893617 99 38 98.9 1 280 2 2 100 WP_252940792.1 hypothetical protein [Streptomyces sp. CHB9.2] diamond 297 104 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. CHB9.2
27781109 27781109 PRJNA816527_P_NODE_13024_length_290_cov_2.124424_g12974_i0 PRJNA816527 13024 290 2.124424 6.1608296 Rubrobacter sp. 2036010 Bacteria Bacteria 62.4 7.67e-9   NR HEX5849274.1 2036010 g12974 i0 58.7 0.651724137931034 63 25 65.2 1 264 76 278 339 HEX5849274.1 choice-of-anchor P family protein [Rubrobacter sp.] diamond 189 62.4 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae Rubrobacter Rubrobacter sp.
27875642 27875642 PRJNA816527_P_NODE_14345_length_277_cov_1.509804_g14295_i0 PRJNA816527 14345 277 1.509804 4.18215708 Bifidobacteriales bacterium 2478472 Bacteria Bacteria 179 1.4699999999999995e-55   NR MCT6839224.1 2478472 g14295 i0 100 0.985559566787004 91 0 98.6 0 275 3 81 171 MCT6839224.1 hypothetical protein [Bifidobacteriales bacterium] diamond 273 179 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales     Bifidobacteriales bacterium
28538985 28538985 PRJNA816527_P_NODE_19307_length_244_cov_1.350877_g19257_i0 PRJNA816527 19307 244 1.350877 3.29613988 Leifsonia sp. TF 1870902 Bacteria Bacteria 165 6.31e-47   NR WP_208040258.1 2815212 g19257 i0 100 0.995901639344262 81 0 99.6 0 243 1 250 330 WP_208040258.1 Ig domain-containing protein [Leifsonia sp. TF02-11] diamond 243 165 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
28642326 28642326 PRJNA816527_P_NODE_15887_length_260_cov_2.192513_g15837_i0 PRJNA816527 15887 260 2.192513 5.7005338 Microbacteriaceae 85023 Bacteria Bacteria 148 2.39e-41   NR WP_345834199.1 3144404 g15837 i0 90.7 2.97692307692308 86 8 99.2 0 2 259 189 274 WP_345834199.1 type VII secretion protein EssB [Microbacterium sp. X-17] diamond 774 148 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. X-17
28831513 28831513 PRJNA816527_P_NODE_18748_length_246_cov_0.890173_g18698_i0 PRJNA816527 18748 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 157 8.009999999999998e-47   NR MCT6837646.1 2478472 g18698 i0 100 1.8780487804878 77 0 93.9 0 3 233 102 178 MCT6837646.1 isoprenylcysteine carboxylmethyltransferase family protein [Bifidobacteriales bacterium] diamond 462 157 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales     Bifidobacteriales bacterium
29021392 29021392 PRJNA816527_P_NODE_14708_length_273_cov_1.540000_g14658_i0 PRJNA816527 14708 273 1.54 4.2042 Leifsonia 110932 Bacteria Bacteria 179 2.95e-51   NR WP_243768796.1 2815212 g14658 i0 100 2 91 0 100 0 273 1 34 124 WP_243768796.1 amylo-alpha-1,6-glucosidase [Leifsonia sp. TF02-11] diamond 546 179 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
29359791 29359791 PRJNA816527_P_NODE_19369_length_244_cov_0.900585_g19319_i0 PRJNA816527 19369 244 0.900585 2.1974274 Streptomyces sp. CHB9.2 2841670 Bacteria Bacteria 145 2.03e-38   NR WP_252941023.1 2841670 g19319 i0 79 0.995901639344262 81 17 99.6 0 244 2 16 96 WP_252941023.1 DUF7193 family protein [Streptomyces sp. CHB9.2] diamond 243 145 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. CHB9.2
29643512 29643512 PRJNA816527_P_NODE_17570_length_249_cov_0.875000_g17520_i0 PRJNA816527 17570 249 0.875 2.17875 Leifsonia sp. TF 1870902 Bacteria Bacteria 86.3 1.09e-17   NR WP_243768267.1 2815212 g17520 i0 100 0.457831325301205 38 0 45.8 0 1 114 333 370 WP_243768267.1 Lrp/AsnC family transcriptional regulator [Leifsonia sp. TF02-11] diamond 114 86.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
29833308 29833308 PRJNA816527_P_NODE_6371_length_406_cov_1.708709_g6321_i0 PRJNA816527 6371 406 1.708709 6.93735854 Mycoplasma sp. HU2 2108 Bacteria Bacteria 124 3.4499999999999996e-30   NR WP_050517646.1 1664275 g6321 i0 95.6 0.502463054187192 68 3 50.2 0 308 105 464 531 WP_050517646.1 BMP family ABC transporter substrate-binding protein [Mycoplasma sp. HU2014] diamond 204 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014

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