RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA1000943" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1000943 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
1419884 1419884 PRJNA1000943_P_NODE_4842_length_361_cov_1.083333_g4705_i0 PRJNA1000943 4842 361 1.083333 3.91083213 FCB group 1783270 Bacteria Bacteria 197 1.19e-58   NR HIW04378.1 1879010 g4705 i0 84 190.861495844875 119 19 98.9 0 3 359 212 330 HIW04378.1 molecular chaperone DnaK [Bacillota bacterium] diamond 68901 198 0.994949494949495 Bacteria   Bacillati Bacillota         Bacillota bacterium
17996799 17996799 PRJNA1000943_P_NODE_12415_length_249_cov_1.772727_g12277_i0 PRJNA1000943 12415 249 1.772727 4.41409023 Bacteria 2 Bacteria Bacteria 133 4.43e-36   NR WP_025747195.1 937334 g12277 i0 83.1 51.8915662650602 83 14 100 0 249 1 34 116 WP_025747195.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Caldicoprobacter faecalis] diamond 12921 134 0.992537313432836 Bacteria   Bacillati Bacillota Clostridia Caldicoprobacterales Caldicoprobacteraceae Caldicoprobacter Caldicoprobacter faecalis
26907792 26907792 PRJNA1000943_P_NODE_5002_length_356_cov_1.063604_g4865_i0 PRJNA1000943 5002 356 1.063604 3.78643024 Eubacteriales bacterium 2831996 Bacteria Bacteria 52 6.85e-5   NR MDO5444557.1 2831996 g4865 i0 37.5 0.674157303370786 80 47 64.9 2 118 348 123 202 MDO5444557.1 hypothetical protein [Eubacteriales bacterium] diamond 240 52 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
27121484 27121484 PRJNA1000943_P_NODE_12422_length_249_cov_1.772727_g12284_i0 PRJNA1000943 12422 249 1.772727 4.41409023 root 1 Root_unresolved Root_unresolved 43.5 0.0194   NR WP_095320368.1 1397 g12284 i0 37.3 6.60240963855422 67 40 78.3 1 249 55 124 190 WP_095320368.1 SDR family oxidoreductase [Niallia circulans] diamond 1644 43.9 0.990888382687927 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Niallia Niallia circulans
27382149 27382149 PRJNA1000943_P_NODE_14903_length_243_cov_0.917647_g14765_i0 PRJNA1000943 14903 243 0.917647 2.22988221 Enterococcus faecalis EnGen 1351 Bacteria Bacteria 40.4 0.0435   NR EOK37568.1 1169252 g14765 i0 38.3 0.740740740740741 60 32 67.9 1 50 214 17 76 EOK37568.1 hypothetical protein WUI_03011 [Enterococcus faecalis EnGen0335] diamond 180 40.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
27445495 27445495 PRJNA1000943_P_NODE_15943_length_229_cov_2.500000_g15805_i0 PRJNA1000943 15943 229 2.5 5.725 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 103 2.86e-24   NR HVI42036.1 3030912 g15805 i0 64.4 0.956331877729258 73 26 95.6 0 219 1 75 147 HVI42036.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Anaerovoracaceae bacterium] diamond 219 103 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
27792645 27792645 PRJNA1000943_P_NODE_14484_length_244_cov_0.912281_g14346_i0 PRJNA1000943 14484 244 0.912281 2.22596564 Catonella massiliensis 2799636 Bacteria Bacteria 102 2.12e-26   NR WP_208428106.1 2799636 g14346 i0 100 1.20491803278689 49 0 60.2 0 148 2 1 49 WP_208428106.1 DUF3343 domain-containing protein [Catonella massiliensis] diamond 294 102 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Catonella Catonella massiliensis
27855603 27855603 PRJNA1000943_P_NODE_1405_length_637_cov_1.618794_g1273_i0 PRJNA1000943 1405 637 1.618794 10.31171778 Clostridia bacterium 2044939 Bacteria Bacteria 73.2 4.06e-11   NR MBP3802252.1 2044939 g1273 i0 52.8 0.249607535321821 53 23 25 1 375 533 316 366 MBP3802252.1 hypothetical protein [Clostridia bacterium] diamond 159 73.2 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28550493 28550493 PRJNA1000943_P_NODE_14707_length_244_cov_0.912281_g14569_i0 PRJNA1000943 14707 244 0.912281 2.22596564 Oribacterium sinus 237576 Bacteria Bacteria 65.1 4.93e-10   NR WP_183683484.1 237576 g14569 i0 91.4 0.430327868852459 35 3 43 0 2 106 414 448 WP_183683484.1 dicarboxylate/amino acid:cation symporter [Oribacterium sinus] diamond 105 65.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oribacterium Oribacterium sinus
28771256 28771256 PRJNA1000943_P_NODE_11107_length_253_cov_0.866667_g10969_i0 PRJNA1000943 11107 253 0.866667 2.19266751 Alkalihalobacterium chitinilyticum 2980103 Bacteria Bacteria 41.2 0.0294   NR WP_373323094.1 2980103 g10969 i0 32.4 0.806324110671937 68 46 80.6 0 218 15 12 79 WP_373323094.1 sigma-G-dependent sporulation-specific acid-soluble spore protein CsgA [Alkalihalobacterium chitinilyticum] diamond 204 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacterium Alkalihalobacterium chitinilyticum
29395440 29395440 PRJNA1000943_P_NODE_9389_length_272_cov_1.175879_g9251_i0 PRJNA1000943 9389 272 1.175879 3.19839088 Bacteria 2 Bacteria Bacteria 113 2.33e-29   NR NLL39483.1 1898207 g9251 i0 65.5 5.84558823529412 87 30 96 0 266 6 25 111 NLL39483.1 hypoxanthine phosphoribosyltransferase [Clostridiales bacterium] diamond 1590 113 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
29465544 29465544 PRJNA1000943_P_NODE_15890_length_231_cov_2.683544_g15752_i0 PRJNA1000943 15890 231 2.683544 6.19898664 Clostridiales bacterium 1898207 Bacteria Bacteria 43.9 0.00937   NR MDR3318221.1 1898207 g15752 i0 55 0.519480519480519 40 18 51.9 0 189 70 146 185 MDR3318221.1 hypothetical protein [Clostridiales bacterium] diamond 120 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
29939771 29939771 PRJNA1000943_P_NODE_6671_length_315_cov_0.863636_g6533_i0 PRJNA1000943 6671 315 0.863636 2.7204534 Paenibacillus azoreducens 116718 Bacteria Bacteria 43.1 0.0198   NR WP_212979506.1 116718 g6533 i0 29.4 0.647619047619048 68 46 64.8 1 240 37 24 89 WP_212979506.1 hypothetical protein [Paenibacillus azoreducens] diamond 204 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus azoreducens
30634520 30634520 PRJNA1000943_P_NODE_9553_length_270_cov_1.228426_g9415_i0 PRJNA1000943 9553 270 1.228426 3.3167502 Ruminococcus sp. 41978 Bacteria Bacteria 41.2 0.0478   NR MBQ2486722.1 41978 g9415 i0 35.8 0.9 81 43 80 2 234 19 8 88 MBQ2486722.1 methyltransferase [Ruminococcus sp.] diamond 243 41.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30785270 30785270 PRJNA1000943_P_NODE_13214_length_247_cov_1.471264_g13076_i0 PRJNA1000943 13214 247 1.471264 3.63402208 Bacteria 2 Bacteria Bacteria 49.7 1.25e-4   NR WP_303869388.1 52694 g13076 i0 52.3 1.06882591093117 44 21 53.4 0 228 97 89 132 WP_303869388.1 hypothetical protein [Acetobacterium wieringae] diamond 264 49.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Acetobacterium Acetobacterium wieringae
30950828 30950828 PRJNA1000943_P_NODE_2634_length_472_cov_0.982456_g2497_i0 PRJNA1000943 2634 472 0.982456 4.63719232 Streptococcus suis 1307 Bacteria Bacteria 79.3 5.46e-14   NR HFI0464382.1 1307 g2497 i0 60.4 0.680084745762712 53 21 33.7 0 289 447 342 394 HFI0464382.1 LysM peptidoglycan-binding domain-containing protein [Streptococcus suis] diamond 321 79.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
31045749 31045749 PRJNA1000943_P_NODE_11855_length_251_cov_0.876404_g11717_i0 PRJNA1000943 11855 251 0.876404 2.19977404 Streptococcus thermophilus 1308 Bacteria Bacteria 114 1.97e-27   NR TKW62483.1 1308 g11717 i0 79.5 0.99203187250996006 83 17 99.2 0 249 1 245 327 TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus] diamond 249 114 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus thermophilus
31045753 31045753 PRJNA1000943_P_NODE_15355_length_242_cov_0.923077_g15217_i0 PRJNA1000943 15355 242 0.923077 2.23384634 Streptococcus thermophilus 1308 Bacteria Bacteria 48.9 2.47e-4   NR TKW62483.1 1308 g15217 i0 75.9 0.359504132231405 29 7 36 0 50 136 329 357 TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus] diamond 87 48.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus thermophilus
31108461 31108461 PRJNA1000943_P_NODE_14635_length_244_cov_0.912281_g14497_i0 PRJNA1000943 14635 244 0.912281 2.22596564 Clostridium thailandense 2794346 Bacteria Bacteria 56.6 4.79e-7   NR WP_218319331.1 2794346 g14497 i0 41.2 1.67213114754098 68 32 73.8 1 50 229 336 403 WP_218319331.1 MAC/perforin domain-containing protein [Clostridium thailandense] diamond 408 56.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium thailandense
31234860 31234860 PRJNA1000943_P_NODE_14295_length_245_cov_0.906977_g14157_i0 PRJNA1000943 14295 245 0.906977 2.22209365 Metabacillus iocasae 2291674 Bacteria Bacteria 101 3.669999999999999e-24   NR WP_205186488.1 2291674 g14157 i0 60.5 1.98367346938776 81 31 99.2 1 3 245 93 172 WP_205186488.1 SDR family NAD(P)-dependent oxidoreductase [Metabacillus iocasae] diamond 486 101 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia iocasae
31393343 31393343 PRJNA1000943_P_NODE_8156_length_289_cov_1.444444_g8018_i0 PRJNA1000943 8156 289 1.444444 4.17444316 Neobacillus niacini 86668 Bacteria Bacteria 44.3 0.0179   NR WP_310196129.1 86668 g8018 i0 32.7 0.508650519031142 49 33 50.9 0 141 287 76 124 WP_310196129.1 sensor histidine kinase [Neobacillus niacini] diamond 147 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus niacini
31646051 31646051 PRJNA1000943_P_NODE_7377_length_302_cov_2.026201_g7239_i0 PRJNA1000943 7377 302 2.026201 6.11912702 Listeria monocytogenes 1639 Bacteria Bacteria 49.3 3.29e-5   NR WP_333731483.1 1639 g7239 i0 35.9 0.635761589403974 64 41 63.6 0 255 64 13 76 WP_333731483.1 hypothetical protein, partial [Listeria monocytogenes] diamond 192 49.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
31677756 31677756 PRJNA1000943_P_NODE_9577_length_269_cov_2.387755_g9439_i0 PRJNA1000943 9577 269 2.387755 6.42306095 Clostridiales bacterium 1898207 Bacteria Bacteria 48.1 6.51e-4   NR HCY52033.1 1898207 g9439 i0 40.8 1.44981412639405 71 40 77 1 235 29 631 701 HCY52033.1 hypothetical protein [Clostridiales bacterium] diamond 390 48.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
31740954 31740954 PRJNA1000943_P_NODE_15377_length_242_cov_0.923077_g15239_i0 PRJNA1000943 15377 242 0.923077 2.23384634 Anaerococcus octavius 54007 Bacteria Bacteria 144 3.8099999999999996e-38   NR WP_115595279.1 54007 g15239 i0 100 1.98347107438017 80 0 99.2 0 1 240 17 96 WP_115595279.1 bifunctional metallophosphatase/5'-nucleotidase [Anaerococcus octavius] diamond 480 144 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus octavius
31994205 31994205 PRJNA1000943_P_NODE_6398_length_321_cov_1.185484_g6260_i0 PRJNA1000943 6398 321 1.185484 3.80540364 Pullulanibacillus sp. KACC 23 2057960 Bacteria Bacteria 164 7.11e-46   NR WP_275281172.1 3028315 g6260 i0 72.6 10.8971962616822 106 29 99.1 0 320 3 330 435 WP_275281172.1 bifunctional 2-methylcitrate dehydratase/aconitate hydratase [Pullulanibacillus sp. KACC 23026] diamond 3498 164 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Pullulanibacillus Pullulanibacillus sp. KACC 23026
32279165 32279165 PRJNA1000943_P_NODE_13179_length_247_cov_1.793103_g13041_i0 PRJNA1000943 13179 247 1.793103 4.42896441 Clostridia bacterium 2044939 Bacteria Bacteria 50.1 1.02e-4   NR MBQ4206815.1 2044939 g13041 i0 56.4 0.947368421052632 39 15 47.4 1 247 131 472 508 MBQ4206815.1 DNA translocase FtsK [Clostridia bacterium] diamond 234 50.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium

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