RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1123686" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 23 ✖

bioproject 1

  • PRJNA1123686 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
19406776 19406776 PRJNA1123686_S_NODE_20416_length_153_cov_6.451613_g20384_i0 PRJNA1123686 20416 153 6.451613 9.87096789 Cutibacterium acnes 1747 Bacteria Bacteria 68.9 2.36e-12   NR MES8420751.1 1747 g20384 i0 69.8 3.09803921568627 53 13 98 2 150 1 169 221 MES8420751.1 hypothetical protein [Cutibacterium acnes] diamond 474 68.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27006839 27006839 PRJNA1123686_S_NODE_8122_length_200_cov_20.111111_g8090_i0 PRJNA1123686 8122 200 20.111111 40.222222 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 40.4 0.0347   NR WP_252130203.1 1590 g8090 i0 58.6 0.435 29 12 43.5 0 104 190 1 29 WP_252130203.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 87 40.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27891372 27891372 PRJNA1123686_S_NODE_6485_length_214_cov_4.491892_g6453_i0 PRJNA1123686 6485 214 4.491892 9.61264888 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 144 3.929999999999999e-40   NR WP_187150667.1 432608 g6453 i0 97.1 0.981308411214953 70 2 98.1 0 2 211 197 266 WP_187150667.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 210 144 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27943898 27943898 PRJNA1123686_S_NODE_6505_length_213_cov_48.788043_g6473_i0 PRJNA1123686 6505 213 48.788043 103.91853159 root 1 Root_unresolved Root_unresolved 59.3 2.4e-9   NR WP_252130084.1 1590 g6473 i0 81.8 27.0422535211268 33 6 46.5 0 212 114 65 97 WP_252130084.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 5760 59.7 0.993299832495812 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28523102 28523102 PRJNA1123686_S_NODE_6007_length_219_cov_4.126316_g5975_i0 PRJNA1123686 6007 219 4.126316 9.03663204 Mycoplasma wenyonii 65123 Bacteria Bacteria 62.4 1.38e-9   NR WP_014850079.1 65123 g5975 i0 51.9 1.50684931506849 54 24 74 1 162 1 164 215 WP_014850079.1 hypothetical protein [Mycoplasma wenyonii] diamond 330 62.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29112174 29112174 PRJNA1123686_S_NODE_18248_length_158_cov_9.744186_g18216_i0 PRJNA1123686 18248 158 9.744186 15.39581388 Bacillati 1783272 Bacteria Bacteria 120 1.23e-31   NR PYC99595.1 57043 g18216 i0 100 1.9746835443038 52 0 98.7 0 1 156 70 121 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 312 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
29186257 29186257 PRJNA1123686_S_NODE_20169_length_154_cov_2.448000_g20137_i0 PRJNA1123686 20169 154 2.448 3.76992 Mycoplasma wenyonii 65123 Bacteria Bacteria 74.7 5.9e-14   NR WP_014849727.1 65123 g20137 i0 86.7 1.75324675324675 45 6 87.7 0 136 2 77 121 WP_014849727.1 hypothetical protein [Mycoplasma wenyonii] diamond 270 74.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29659253 29659253 PRJNA1123686_S_NODE_4390_length_237_cov_2.923077_g4358_i0 PRJNA1123686 4390 237 2.923077 6.92769249 Streptomyces sp. AV19 2793068 Bacteria Bacteria 166 8.66e-46   NR WP_234429916.1 2793068 g4358 i0 98.7 0.987341772151899 78 1 98.7 0 235 2 111 188 WP_234429916.1 immunoglobulin domain-containing protein, partial [Streptomyces sp. AV19] diamond 234 166 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AV19
29690899 29690899 PRJNA1123686_S_NODE_18590_length_157_cov_15.546875_g18558_i0 PRJNA1123686 18590 157 15.546875 24.40859375 Staphylococcus aureus 1280 Bacteria Bacteria 87 3.9800000000000006e-21   NR QHG77600.1 1280 g18558 i0 76.9 3.89808917197452 52 12 99.4 0 2 157 8 59 QHG77600.1 hypothetical protein EAX85_13930 [Staphylococcus aureus] diamond 612 87 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30038652 30038652 PRJNA1123686_S_NODE_19651_length_155_cov_2.293651_g19619_i0 PRJNA1123686 19651 155 2.293651 3.55515905 Galactobacillus timonensis 2041840 Bacteria Bacteria 48.9 7.44e-5   NR WP_277018500.1 2041840 g19619 i0 100 0.406451612903226 21 0 40.6 0 1 63 562 582 WP_277018500.1 ABC transporter ATP-binding protein [Galactobacillus timonensis] diamond 63 48.9 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Galactobacillus Galactobacillus timonensis
30164833 30164833 PRJNA1123686_S_NODE_7752_length_203_cov_13.218391_g7720_i0 PRJNA1123686 7752 203 13.218391 26.83333373 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0304   NR MBQ2991229.1 2044939 g7720 i0 42.6 0.694581280788177 47 27 69.5 0 7 147 252 298 MBQ2991229.1 cadmium-translocating P-type ATPase [Clostridia bacterium] diamond 141 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30291843 30291843 PRJNA1123686_S_NODE_7612_length_204_cov_16.325714_g7580_i0 PRJNA1123686 7612 204 16.325714 33.30445656 Exiguobacterium aurantiacum 33987 Bacteria Bacteria 49.7 5.13e-6   NR WP_233005565.1 33987 g7580 i0 51.6 0.941176470588235 64 30 92.6 1 204 16 1 64 WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum] diamond 192 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium aurantiacum
30638847 30638847 PRJNA1123686_S_NODE_8753_length_196_cov_12.700599_g8721_i0 PRJNA1123686 8753 196 12.700599 24.89317404 Clostridium sp. CAG:44 1506 Bacteria Bacteria 42.4 0.0262   NR CDE26200.1 1262807 g8721 i0 35.7 0.857142857142857 56 36 85.7 0 12 179 192 247 CDE26200.1 putative uncharacterized protein [Clostridium sp. CAG:440] diamond 168 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CAG:440
30828502 30828502 PRJNA1123686_S_NODE_13014_length_175_cov_7.109589_g12982_i0 PRJNA1123686 13014 175 7.109589 12.44178075 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 40 0.0475   NR WP_252130024.1 1590 g12982 i0 61.8 1.16571428571429 34 13 58.3 0 67 168 27 60 WP_252130024.1 60S acidic ribosomal protein P2, partial [Lactiplantibacillus plantarum] diamond 204 40 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31133377 31133377 PRJNA1123686_S_NODE_15855_length_165_cov_6.352941_g15823_i0 PRJNA1123686 15855 165 6.352941 10.48235265 root 1 Root_unresolved Root_unresolved 99 2.09e-25   NR WP_305021979.1 1590 g15823 i0 86.8 24.0727272727273 53 7 96.4 0 3 161 10 62 WP_305021979.1 nucleoside-diphosphate kinase, partial [Lactiplantibacillus plantarum] diamond 3972 100 0.99 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31260143 31260143 PRJNA1123686_S_NODE_5915_length_219_cov_658.526316_g5883_i0 PRJNA1123686 5915 219 658.526316 1442.17263204 root 1 Root_unresolved Root_unresolved 42.4 0.0217   NR SJR19085.1 1496 g5883 i0 54.3 1.73972602739726 35 16 47.9 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 381 42.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31576480 31576480 PRJNA1123686_S_NODE_5916_length_219_cov_643.468421_g5884_i0 PRJNA1123686 5916 219 643.468421 1409.19584199 root 1 Root_unresolved Root_unresolved 42.4 0.0217   NR SJR19085.1 1496 g5884 i0 54.3 1.73972602739726 35 16 47.9 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 381 42.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31618844 31618844 PRJNA1123686_S_NODE_7556_length_205_cov_3.255682_g7524_i0 PRJNA1123686 7556 205 3.255682 6.6741481 Streptomyces sp. AV19 2793068 Bacteria Bacteria 131 1.45e-33   NR WP_234429916.1 2793068 g7524 i0 100 0.980487804878049 67 0 98 0 3 203 181 247 WP_234429916.1 immunoglobulin domain-containing protein, partial [Streptomyces sp. AV19] diamond 201 131 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AV19
32082466 32082466 PRJNA1123686_S_NODE_358_length_408_cov_80.775726_g328_i0 PRJNA1123686 358 408 80.775726 329.56496208 root 1 Root_unresolved Root_unresolved 84.3 2.74e-17   NR QHG80041.1 1280 g328 i0 56.5 38.0514705882353 115 50 84.6 0 406 62 73 187 QHG80041.1 30S ribosomal protein S13 [Staphylococcus aureus] diamond 15525 85.1 0.990599294947121 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32220033 32220033 PRJNA1123686_S_NODE_38_length_813_cov_4.082908_g30_i0 PRJNA1123686 38 813 4.082908 33.19404204 Streptomyces sp. AV19 2793068 Bacteria Bacteria 545 1.88e-188   NR WP_234429916.1 2793068 g30 i0 100 0.996309963099631 270 0 99.6 0 812 3 373 642 WP_234429916.1 immunoglobulin domain-containing protein, partial [Streptomyces sp. AV19] diamond 810 545 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AV19
32430654 32430654 PRJNA1123686_S_NODE_6019_length_218_cov_130.063492_g5987_i0 PRJNA1123686 6019 218 130.063492 283.53841256 root 1 Root_unresolved Root_unresolved 42.7 0.0156   NR SJR19085.1 1496 g5987 i0 54.3 0.963302752293578 35 16 48.2 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 210 42.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
32599585 32599585 PRJNA1123686_S_NODE_21480_length_151_cov_2.344262_g21448_i0 PRJNA1123686 21480 151 2.344262 3.53983562 Mycoplasma wenyonii 65123 Bacteria Bacteria 72.4 2.44e-13   NR WP_110555174.1 65123 g21448 i0 77.1 0.95364238410596 48 11 95.4 0 1 144 274 321 WP_110555174.1 L-lactate dehydrogenase [Mycoplasma wenyonii] diamond 144 72.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32630771 32630771 PRJNA1123686_S_NODE_7280_length_207_cov_5.050562_g7248_i0 PRJNA1123686 7280 207 5.050562 10.45466334 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 62.4 1.9e-9   NR WP_187150208.1 432608 g7248 i0 100 0.434782608695652 30 0 43.5 0 190 101 255 284 WP_187150208.1 50S ribosomal protein L2 [Candidatus Mycoplasma haematobovis] diamond 90 62.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis

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