RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 22 ✖

bioproject 1

  • PRJNA1011833 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
27002852 27002852 PRJNA1011833_S_NODE_4002_length_499_cov_20.945175_g3602_i0 PRJNA1011833 4002 499 20.945175 104.51642325 Actinomycetota bacterium 2900548 Bacteria Bacteria 129 9.93e-33   NR MBM3680260.1 2900548 g3602 i0 46.7 1.80360721442886 150 67 87.8 4 498 61 182 322 MBM3680260.1 malate dehydrogenase [Actinomycetota bacterium] diamond 900 129 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27445814 27445814 PRJNA1011833_S_NODE_28223_length_223_cov_1.038889_g27803_i0 PRJNA1011833 28223 223 1.038889 2.31672247 unclassified Amedibacterium 3088137 Bacteria Bacteria 42 0.05   NR WP_233511338.1 3088137 g27803 i0 42.6 0.726457399103139 54 27 70 3 19 174 188 239 WP_233511338.1 MULTISPECIES: hypothetical protein [unclassified Amedibacterium] diamond 162 42 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Amedibacterium  
27761566 27761566 PRJNA1011833_S_NODE_40344_length_183_cov_1.671429_g39924_i0 PRJNA1011833 40344 183 1.671429 3.05871507 Mycoplasma wenyonii 65123 Bacteria Bacteria 122 1e-30   NR WP_112665766.1 65123 g39924 i0 100 0.983606557377049 60 0 98.4 0 2 181 262 321 WP_112665766.1 elongation factor G [Mycoplasma wenyonii] diamond 180 122 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27824571 27824571 PRJNA1011833_S_NODE_34104_length_200_cov_2.369427_g33684_i0 PRJNA1011833 34104 200 2.369427 4.738854 Holdemanella biformis 1735 Bacteria Bacteria 43.1 0.0155   NR WP_227976277.1 1735 g33684 i0 39 1.23 82 31 97.5 3 5 199 153 232 WP_227976277.1 glycoside hydrolase family 13 protein [Holdemanella biformis] diamond 246 43.1 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Holdemanella Holdemanella biformis
27824573 27824573 PRJNA1011833_S_NODE_58104_length_152_cov_1.045872_g57684_i0 PRJNA1011833 58104 152 1.045872 1.58972544 Mycoplasma wenyonii 65123 Bacteria Bacteria 98.2 3.07e-22   NR WP_274506156.1 65123 g57684 i0 94 0.986842105263158 50 3 98.7 0 151 2 470 519 WP_274506156.1 GTP-binding protein [Mycoplasma wenyonii] diamond 150 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28006468 28006468 PRJNA1011833_S_NODE_51585_length_161_cov_1.220339_g51165_i0 PRJNA1011833 51585 161 1.220339 1.96474579 Clostridia 186801 Bacteria Bacteria 100 4.53e-24   NR MCI5596461.1 1898203 g51165 i0 81.1 18.6335403726708 53 10 98.8 0 3 161 131 183 MCI5596461.1 UDP-glucose 4-epimerase GalE [Lachnospiraceae bacterium] diamond 3000 101 0.99009900990099 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28297953 28297953 PRJNA1011833_S_NODE_51566_length_161_cov_1.220339_g51146_i0 PRJNA1011833 51566 161 1.220339 1.96474579 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 103 3.32e-25   NR WP_187150589.1 432608 g51146 i0 98.1 0.987577639751553 53 1 98.8 0 159 1 104 156 WP_187150589.1 FoF1 ATP synthase subunit gamma [Candidatus Mycoplasma haematobovis] diamond 159 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28361053 28361053 PRJNA1011833_S_NODE_16246_length_300_cov_2.050584_g15826_i0 PRJNA1011833 16246 300 2.050584 6.151752 Cyanobacteria bacterium J06633_8 3023197 Bacteria Bacteria 55.5 1.18e-6   NR MEO1431450.1 3023197 g15826 i0 36.8 0.87 87 54 87 1 18 278 119 204 MEO1431450.1 SDR family oxidoreductase [Cyanobacteria bacterium J06633_8] diamond 261 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06633_8
28574481 28574481 PRJNA1011833_S_NODE_9847_length_372_cov_5.595745_g9429_i0 PRJNA1011833 9847 372 5.595745 20.8161714 Bacteria 2 Bacteria Bacteria 149 7.36e-40   NR HSJ34736.1 2080302 g9429 i0 60.7 12.6370967741935 112 44 90.3 0 371 36 373 484 HSJ34736.1 betaine-aldehyde dehydrogenase [Acidimicrobiia bacterium] diamond 4701 149 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
28606128 28606128 PRJNA1011833_S_NODE_10727_length_360_cov_5.182965_g10308_i0 PRJNA1011833 10727 360 5.182965 18.658674 Bacteria 2 Bacteria Bacteria 58.9 2.67e-7   NR WP_029699112.1 1391647 g10308 i0 32.2 5.675 115 69 93.3 6 359 24 122 230 WP_029699112.1 DEAD/DEAH box helicase [Clostridium sp. Ade.TY] diamond 2043 58.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. Ade.TY
29268978 29268978 PRJNA1011833_S_NODE_55349_length_155_cov_1.196429_g54929_i0 PRJNA1011833 55349 155 1.196429 1.85446495 root 1 Root_unresolved Root_unresolved 42.7 0.00609   NR WP_262458101.1 1496 g54929 i0 48.7 3.01935483870968 39 17 69.7 1 42 149 68 106 WP_262458101.1 endonuclease/exonuclease/phosphatase family protein [Clostridioides difficile] diamond 468 42.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
29560821 29560821 PRJNA1011833_S_NODE_60390_length_150_cov_1.710280_g59970_i0 PRJNA1011833 60390 150 1.71028 2.56542 Chloroflexi bacterium ADurb.Bin36 1852861 Bacteria Bacteria 42 0.0194   NR OQA15659.1 1852861 g59970 i0 47.4 0.76 38 20 76 0 12 125 362 399 OQA15659.1 MAG: ATP-dependent RNA helicase DbpA [Chloroflexi bacterium ADurb.Bin360] diamond 114 42 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium ADurb.Bin360
29655307 29655307 PRJNA1011833_S_NODE_56350_length_153_cov_1.745455_g55930_i0 PRJNA1011833 56350 153 1.745455 2.67054615 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.4 0.0154   NR MCY3782836.1 2026724 g55930 i0 35.7 2.23529411764706 42 27 82.4 0 153 28 312 353 MCY3782836.1 DEAD/DEAH box helicase [Chloroflexota bacterium] diamond 342 42.4 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29710860 29710860 PRJNA1011833_S_NODE_11310_length_352_cov_8.896440_g10890_i0 PRJNA1011833 11310 352 8.89644 31.3154688 Bacteria 2 Bacteria Bacteria 112 8.130000000000001e-27   NR WP_221880430.1 1399 g10890 i0 50.5 15.7244318181818 103 51 87.8 0 344 36 305 407 WP_221880430.1 NAD-dependent succinate-semialdehyde dehydrogenase, partial [Cytobacillus firmus] diamond 5535 113 0.991150442477876 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus firmus
30003242 30003242 PRJNA1011833_S_NODE_55911_length_154_cov_1.297297_g55491_i0 PRJNA1011833 55911 154 1.297297 1.99783738 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 98.2 8.809999999999999e-24   NR WP_187150533.1 432608 g55491 i0 98 0.993506493506494 51 1 99.4 0 154 2 122 172 WP_187150533.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 153 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30034779 30034779 PRJNA1011833_S_NODE_51291_length_161_cov_2.313559_g50871_i0 PRJNA1011833 51291 161 2.313559 3.72482999 Fodinicola acaciae 2681555 Bacteria Bacteria 41.6 0.0314   NR WP_163510641.1 2681555 g50871 i0 51.1 0.838509316770186 45 18 83.9 1 149 15 272 312 WP_163510641.1 serine hydrolase domain-containing protein [Fodinicola acaciae] diamond 135 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales   Fodinicola Fodinicola acaciae
30698122 30698122 PRJNA1011833_S_NODE_16594_length_297_cov_1.854331_g16174_i0 PRJNA1011833 16594 297 1.854331 5.50736307 Leuconostoc pseudomesenteroides 33968 Bacteria Bacteria 43.5 0.0158   NR WP_349550031.1 33968 g16174 i0 27.2 0.818181818181818 81 53 77.8 2 51 281 30 108 WP_349550031.1 single-stranded DNA-binding protein [Leuconostoc pseudomesenteroides] diamond 243 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Leuconostoc Leuconostoc pseudomesenteroides
30729760 30729760 PRJNA1011833_S_NODE_43674_length_176_cov_1.082707_g43254_i0 PRJNA1011833 43674 176 1.082707 1.90556432 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 115 8.07e-31   NR WP_187149865.1 432608 g43254 i0 94.6 1.89204545454545 56 3 95.5 0 3 170 33 88 WP_187149865.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 333 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31267030 31267030 PRJNA1011833_S_NODE_38515_length_188_cov_0.958621_g38095_i0 PRJNA1011833 38515 188 0.958621 1.80220748 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 42.7 0.0174   NR MCC8043763.1 2485925 g38095 i0 40.5 0.670212765957447 42 24 65.4 1 137 15 100 141 MCC8043763.1 sugar phosphate isomerase/epimerase [Oscillospiraceae bacterium] diamond 126 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
31828489 31828489 PRJNA1011833_S_NODE_58037_length_152_cov_1.211009_g57617_i0 PRJNA1011833 58037 152 1.211009 1.84073368 Bacillati 1783272 Bacteria Bacteria 42.7 0.00598   NR MCJ7716686.1 2073117 g57617 i0 40.5 2.48684210526316 42 25 82.9 0 17 142 6 47 MCJ7716686.1 acyl-CoA dehydrogenase family protein [Anaerolineales bacterium] diamond 378 42.7 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
32057768 32057768 PRJNA1011833_S_NODE_5418_length_455_cov_12.621359_g5006_i0 PRJNA1011833 5418 455 12.621359 57.42718345 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 87.4 3.45e-19   NR MBQ5561215.1 1898203 g5006 i0 40.7 1.21978021978022 86 51 56.7 0 292 35 16 101 MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium] diamond 555 87.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32847391 32847391 PRJNA1011833_S_NODE_52120_length_160_cov_1.230769_g51700_i0 PRJNA1011833 52120 160 1.230769 1.9692304 Mycoplasma wenyonii 65123 Bacteria Bacteria 66.2 5.96e-11   NR WP_112665122.1 65123 g51700 i0 80 0.75 40 8 75 0 128 9 914 953 WP_112665122.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 120 66.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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