RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJEB36940 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
17908343 17908343 PRJEB36940_P_NODE_13495_length_249_cov_0.880682_g13366_i0 PRJEB36940 13495 249 0.880682 2.19289818 Bacillati 1783272 Bacteria Bacteria 73.9 4.32e-13   NR WP_413783343.1 61624 g13366 i0 52.6 8.56626506024096 78 36 92.8 1 19 249 1035 1112 WP_413783343.1 amino acid adenylation domain-containing protein [Paenibacillus mucilaginosus] diamond 2133 73.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus mucilaginosus
21733556 21733556 PRJEB36940_P_NODE_4498_length_403_cov_1.675758_g4369_i0 PRJEB36940 4498 403 1.675758 6.75330474 root 1 Root_unresolved Root_unresolved 171 3.08e-51   NR MCJ0157547.1 1496 g4369 i0 61.7 3.96029776674938 133 46 99 2 399 1 9 136 MCJ0157547.1 WD40 repeat domain-containing protein [Clostridioides difficile] diamond 1596 171 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
27159452 27159452 PRJEB36940_P_NODE_13102_length_250_cov_0.875706_g12973_i0 PRJEB36940 13102 250 0.875706 2.189265 Desulfitobacterium sp. 49981 Bacteria Bacteria 47.8 6.96e-4   NR WP_325393922.1 49981 g12973 i0 37.3 0.708 59 35 70.8 1 64 240 300 356 WP_325393922.1 Stk1 family PASTA domain-containing Ser/Thr kinase [Desulfitobacterium sp.] diamond 177 47.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
27854576 27854576 PRJEB36940_P_NODE_13725_length_248_cov_0.891429_g13596_i0 PRJEB36940 13725 248 0.891429 2.21074392 Clostridium sp. C8-1-8 2698831 Bacteria Bacteria 49.7 7.27e-5   NR WP_160677557.1 2698831 g13596 i0 44.8 2.03225806451613 58 26 69 3 248 78 129 181 WP_160677557.1 C40 family peptidase [Clostridium sp. C8-1-8] diamond 504 49.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. C8-1-8
28896436 28896436 PRJEB36940_P_NODE_14408_length_246_cov_0.901734_g14279_i0 PRJEB36940 14408 246 0.901734 2.21826564 Paenibacillus fonticola 379896 Bacteria Bacteria 159 3.6999999999999995e-44   NR WP_019636202.1 379896 g14279 i0 97.5 0.98780487804878 81 2 98.8 0 245 3 290 370 WP_019636202.1 S-layer homology domain-containing protein [Paenibacillus fonticola] diamond 243 159 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus fonticola
29748771 29748771 PRJEB36940_P_NODE_8191_length_302_cov_4.484716_g8062_i0 PRJEB36940 8191 302 4.484716 13.54384232 Bacillota bacterium 1879010 Bacteria Bacteria 47.4 4.21e-4   NR HEX7715580.1 1879010 g8062 i0 38.5 0.774834437086093 78 46 75.5 1 232 5 46 123 HEX7715580.1 hypothetical protein [Bacillota bacterium] diamond 234 47.4 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29970125 29970125 PRJEB36940_P_NODE_9571_length_282_cov_1.440191_g9442_i0 PRJEB36940 9571 282 1.440191 4.06133862 Eubacterium sp. 142586 Bacteria Bacteria 125 3.93e-33   NR MCI9020654.1 142586 g9442 i0 64.5 5.93617021276596 93 33 98.9 0 3 281 38 130 MCI9020654.1 cation transporter [Eubacterium sp.] diamond 1674 125 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
30127834 30127834 PRJEB36940_P_NODE_7312_length_320_cov_0.829960_g7183_i0 PRJEB36940 7312 320 0.82996 2.655872 Eubacterium sp. 142586 Bacteria Bacteria 48.9 2.05e-4   NR MDE5985619.1 142586 g7183 i0 38.4 0.80625 86 48 77.8 3 282 34 2 85 MDE5985619.1 GNAT family N-acetyltransferase [Eubacterium sp.] diamond 258 48.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
30254780 30254780 PRJEB36940_P_NODE_16092_length_240_cov_3.245509_g15963_i0 PRJEB36940 16092 240 3.245509 7.7892216 Priestia megaterium 1404 Bacteria Bacteria 56.2 1.2e-7   NR WP_098901367.1 1404 g15963 i0 64.3 0.525 42 14 51.3 1 1 123 31 72 WP_098901367.1 fascin domain-containing protein [Priestia megaterium] diamond 126 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia megaterium
30374761 30374761 PRJEB36940_P_NODE_5532_length_364_cov_1.735395_g5403_i0 PRJEB36940 5532 364 1.735395 6.3168378 Bacillati 1783272 Bacteria Bacteria 43.1 0.0305   NR MCD8096347.1 41978 g5403 i0 43.1 1.78021978021978 51 29 42 0 172 20 3 53 MCD8096347.1 50S ribosomal protein L7/L12 [Ruminococcus sp.] diamond 648 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30848282 30848282 PRJEB36940_P_NODE_8014_length_306_cov_1.197425_g7885_i0 PRJEB36940 8014 306 1.197425 3.6641205 Acetobacterium 33951 Bacteria Bacteria 80.1 1.15e-15   NR WP_243166222.1 52691 g7885 i0 58.3 1.17647058823529 60 25 58.8 0 2 181 192 251 WP_243166222.1 peptidylprolyl isomerase [Acetobacterium fimetarium] diamond 360 80.9 0.990111248454882 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Acetobacterium Acetobacterium fimetarium
30886420 30886420 PRJEB36940_P_NODE_11534_length_260_cov_1.112299_g11405_i0 PRJEB36940 11534 260 1.112299 2.8919774 Lactovum miscens 190387 Bacteria Bacteria 70.5 7.97e-12   NR WP_331035221.1 190387 g11405 i0 41 0.957692307692308 83 48 94.6 1 249 4 317 399 WP_331035221.1 reverse transcriptase domain-containing protein [Lactovum miscens] diamond 249 70.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactovum Lactovum miscens
30949748 30949748 PRJEB36940_P_NODE_3074_length_484_cov_2.863747_g2947_i0 PRJEB36940 3074 484 2.863747 13.86053548 Clostridia bacterium 2044939 Bacteria Bacteria 49.3 1.29e-4   NR MBQ6847602.1 2044939 g2947 i0 38.9 0.446280991735537 72 36 44 2 272 484 4 68 MBQ6847602.1 acyl carrier protein [Clostridia bacterium] diamond 216 49.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31233782 31233782 PRJEB36940_P_NODE_13075_length_250_cov_0.881356_g12946_i0 PRJEB36940 13075 250 0.881356 2.20339 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 71.2 3.78e-12   NR MBE6125453.1 2049044 g12946 i0 39.2 0.888 74 45 88.8 0 22 243 445 518 MBE6125453.1 calcium-translocating P-type ATPase, PMCA-type [Erysipelotrichaceae bacterium] diamond 222 71.2 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
31322224 31322224 PRJEB36940_P_NODE_10135_length_275_cov_1.539604_g10006_i0 PRJEB36940 10135 275 1.539604 4.233911 root 1 Root_unresolved Root_unresolved 117 2.07e-28   NR HIS58241.1 2840844 g10006 i0 56.8 8.60727272727273 88 38 96 0 4 267 59 146 HIS58241.1 alpha-glucosidase [Candidatus Limadaptatus stercoravium] diamond 2367 117 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Candidatus Limadaptatus Candidatus Limadaptatus stercoravium
31385726 31385726 PRJEB36940_P_NODE_8196_length_302_cov_2.772926_g8067_i0 PRJEB36940 8196 302 2.772926 8.37423652 Peptostreptococcus 1257 Bacteria Bacteria 101 2.65e-25   NR WP_002845271.1 1257 g8067 i0 53.2 7.47019867549669 94 42 93.4 1 283 2 12 103 WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus] diamond 2256 102 0.990196078431373 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptostreptococcus  
32183102 32183102 PRJEB36940_P_NODE_13338_length_249_cov_0.886364_g13209_i0 PRJEB36940 13338 249 0.886364 2.20704636 Anaerobacillus isosaccharinicus 1532552 Bacteria Bacteria 57.4 2.8e-7   NR WP_071318201.1 1532552 g13209 i0 43.5 1.72289156626506 69 39 83.1 0 27 233 195 263 WP_071318201.1 AAA family ATPase [Anaerobacillus isosaccharinicus] diamond 429 57.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Anaerobacillus Anaerobacillus isosaccharinicus
32341406 32341406 PRJEB36940_P_NODE_9299_length_285_cov_4.962264_g9170_i0 PRJEB36940 9299 285 4.962264 14.1424524 Paenibacillus silvisoli 3110539 Bacteria Bacteria 113 3.76e-30   NR WP_308634904.1 3110539 g9170 i0 69.2 4.1157894736842104 78 24 82.1 0 51 284 6 83 WP_308634904.1 group 1 truncated hemoglobin [Paenibacillus silvisoli] diamond 1173 113 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus silvisoli

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