RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA438572 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
26617493 26617493 PRJNA438572_P_NODE_20861_length_247_cov_0.896552_g20742_i0 PRJNA438572 20861 247 0.896552 2.21448344 Bacillaceae 186817 Bacteria Bacteria 43.1 0.0284   NR WP_071312146.1 85682 g20742 i0 32.3 3.14574898785425 62 42 75.3 0 4 189 262 323 WP_071312146.1 MDR family MFS transporter [Anaerobacillus arseniciselenatis] diamond 777 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Anaerobacillus Anaerobacillus arseniciselenatis
26807575 26807575 PRJNA438572_P_NODE_23661_length_243_cov_0.917647_g23542_i0 PRJNA438572 23661 243 0.917647 2.22988221 Bacillaceae 186817 Bacteria Bacteria 84 1.29e-17   NR WP_036159089.1 202611 g23542 i0 60.3 3.79012345679012 78 28 96.3 1 234 1 37 111 WP_036159089.1 AIM24 family protein [Lysinibacillus odysseyi] diamond 921 84 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus odysseyi
27138825 27138825 PRJNA438572_P_NODE_8122_length_356_cov_7.031802_g8003_i0 PRJNA438572 8122 356 7.031802 25.03321512 Brevibacillus fulvus 1125967 Bacteria Bacteria 133 1.0499999999999998e-37   NR WP_204516782.1 1125967 g8003 i0 63.6 7.70224719101124 99 36 83.4 0 303 7 2 100 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 2742 133 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
27186942 27186942 PRJNA438572_P_NODE_7062_length_379_cov_1.826797_g6943_i0 PRJNA438572 7062 379 1.826797 6.92356063 Paenibacillus 44249 Bacteria Bacteria 56.2 2.31e-6   NR WP_157261081.1 268407 g6943 i0 32.1 4.60686015831135 106 59 83.9 3 378 61 70 162 WP_157261081.1 carbonic anhydrase [Paenibacillus wynnii] diamond 1746 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus wynnii
27613244 27613244 PRJNA438572_P_NODE_18064_length_251_cov_0.876404_g17945_i0 PRJNA438572 18064 251 0.876404 2.19977404 Ruoffia halotolerans 2748684 Bacteria Bacteria 147 1.46e-41   NR WP_218931581.1 2748684 g17945 i0 86.7 1.9840637450199201 83 11 99.2 0 3 251 99 181 WP_218931581.1 carbohydrate ABC transporter permease [Ruoffia halotolerans] diamond 498 147 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Ruoffia Ruoffia halotolerans
27945179 27945179 PRJNA438572_P_NODE_6745_length_386_cov_3.038339_g6626_i0 PRJNA438572 6745 386 3.038339 11.72798854 Paenibacillus 44249 Bacteria Bacteria 143 1.7699999999999993e-41   NR WP_377607390.1 306542 g6626 i0 62.2 1.74870466321244 111 42 86.3 0 52 384 4 114 WP_377607390.1 group I truncated hemoglobin [Paenibacillus gansuensis] diamond 675 143 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus gansuensis
28039917 28039917 PRJNA438572_P_NODE_5945_length_410_cov_1.379822_g5826_i0 PRJNA438572 5945 410 1.379822 5.6572702 root 1 Root_unresolved Root_unresolved 168 3.34e-48   NR WP_289900935.1 1352 g5826 i0 58.5 4.91707317073171 135 56 98.8 0 4 408 178 312 WP_289900935.1 HK97-fold major capsid protein [Enterococcus faecium] diamond 2016 168 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
28244385 28244385 PRJNA438572_P_NODE_14266_length_276_cov_1.123153_g14147_i0 PRJNA438572 14266 276 1.123153 3.09990228 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 61.2 1.72e-8   NR MBP3200262.1 1898203 g14147 i0 34.5 1.85869565217391 87 54 94.6 1 10 270 64 147 MBP3200262.1 hypothetical protein [Lachnospiraceae bacterium] diamond 513 61.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28307803 28307803 PRJNA438572_P_NODE_9786_length_327_cov_1.228346_g9667_i0 PRJNA438572 9786 327 1.228346 4.01669142 Limnochorda pilosa 1555112 Bacteria Bacteria 117 2.53e-28   NR WP_068137502.1 1555112 g9667 i0 49.5 0.981651376146789 107 54 98.2 0 2 322 334 440 WP_068137502.1 putrescine aminotransferase [Limnochorda pilosa] diamond 321 117 1 Bacteria   Bacillati Bacillota Limnochordia Limnochordales Limnochordaceae Limnochorda Limnochorda pilosa
28655095 28655095 PRJNA438572_P_NODE_7467_length_370_cov_3.589226_g7348_i0 PRJNA438572 7467 370 3.589226 13.2801362 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 50.4 3.18e-4   NR MCI5863028.1 1898203 g7348 i0 36 0.608108108108108 75 45 58.4 2 216 1 375 449 MCI5863028.1 RICIN domain-containing protein [Lachnospiraceae bacterium] diamond 225 50.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29002787 29002787 PRJNA438572_P_NODE_11388_length_305_cov_1.004310_g11269_i0 PRJNA438572 11388 305 1.00431 3.0631455 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 49.7 2.38e-4   NR MBQ3011017.1 2485925 g11269 i0 38 0.698360655737705 71 38 65.9 2 55 255 32 100 MBQ3011017.1 pentapeptide repeat-containing protein [Oscillospiraceae bacterium] diamond 213 49.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29823033 29823033 PRJNA438572_P_NODE_13311_length_284_cov_1.464455_g13192_i0 PRJNA438572 13311 284 1.464455 4.1590522 Planifilum fimeticola 201975 Bacteria Bacteria 201 1.55e-64   NR WP_106346328.1 201975 g13192 i0 96.8 0.992957746478873 94 3 99.3 0 283 2 10 103 WP_106346328.1 TlpA family protein disulfide reductase [Planifilum fimeticola] diamond 282 201 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Planifilum Planifilum fimeticola
29854927 29854927 PRJNA438572_P_NODE_6931_length_382_cov_1.501618_g6812_i0 PRJNA438572 6931 382 1.501618 5.73618076 Bacillota bacterium 1879010 Bacteria Bacteria 74.3 1.52e-12   NR HAX72755.1 1879010 g6812 i0 75 0.683246073298429 44 11 34.6 0 242 373 4 47 HAX72755.1 hydroxylamine reductase [Bacillota bacterium] diamond 261 74.3 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29871194 29871194 PRJNA438572_P_NODE_18571_length_251_cov_0.870787_g18452_i0 PRJNA438572 18571 251 0.870787 2.18567537 Bacteria 2 Bacteria Bacteria 45.4 0.00474   NR WP_083448429.1 33935 g18452 i0 35.9 5.67729083665339 64 39 76.5 2 6 197 554 615 WP_083448429.1 S-layer homology domain-containing protein [Lysinibacillus macroides] diamond 1425 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus macroides
29918187 29918187 PRJNA438572_P_NODE_4011_length_490_cov_3.270983_g3893_i0 PRJNA438572 4011 490 3.270983 16.0278167 Eubacteriales bacterium 2831996 Bacteria Bacteria 56.6 7.6e-6   NR MDD3765982.1 2831996 g3893 i0 48 0.306122448979592 50 25 30 1 200 54 3082 3131 MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium] diamond 150 56.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
30218596 30218596 PRJNA438572_P_NODE_4292_length_475_cov_0.776119_g4174_i0 PRJNA438572 4292 475 0.776119 3.68656525 root 1 Root_unresolved Root_unresolved 65.5 4.18e-9   NR WP_207658404.1 1512 g4174 i0 41.1 7.56631578947368 90 45 51.8 3 471 226 86 175 WP_207658404.1 pentapeptide repeat-containing protein [[Clostridium] symbiosum] diamond 3594 65.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Otoolea [Clostridium] symbiosum
30392429 30392429 PRJNA438572_P_NODE_5733_length_418_cov_1.249275_g5614_i0 PRJNA438572 5733 418 1.249275 5.2219695 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 74.3 1.02e-12   NR MDE6314041.1 1898203 g5614 i0 60.8 0.366028708133971 51 18 35.2 1 403 257 33 83 MDE6314041.1 pentapeptide repeat-containing protein [Lachnospiraceae bacterium] diamond 153 74.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30549841 30549841 PRJNA438572_P_NODE_3593_length_520_cov_4.749441_g3475_i0 PRJNA438572 3593 520 4.749441 24.6970932 Eubacteriales bacterium 2831996 Bacteria Bacteria 51.6 5.16e-4   NR MDD3765982.1 2831996 g3475 i0 45.8 0.276923076923077 48 25 27.1 1 312 452 3084 3131 MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium] diamond 144 51.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
30802682 30802682 PRJNA438572_P_NODE_3314_length_540_cov_8.762313_g3196_i0 PRJNA438572 3314 540 8.762313 47.3164902 Eubacteriales bacterium 2831996 Bacteria Bacteria 55.5 3e-5   NR MDD3765982.1 2831996 g3196 i0 46 0.277777777777778 50 26 27.2 1 331 477 3082 3131 MDD3765982.1 ZmpA/ZmpB/ZmpC family metallo-endopeptidase-related protein [Eubacteriales bacterium] diamond 150 55.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
30819029 30819029 PRJNA438572_P_NODE_21334_length_246_cov_1.393064_g21215_i0 PRJNA438572 21334 246 1.393064 3.42693744 Bacteria 2 Bacteria Bacteria 61.2 1.04e-8   NR MEI6285503.1 1879010 g21215 i0 40.5 4.70731707317073 79 45 93.9 1 245 15 65 143 MEI6285503.1 histidine-type phosphatase [Bacillota bacterium] diamond 1158 61.6 0.993506493506494 Bacteria   Bacillati Bacillota         Bacillota bacterium
30850547 30850547 PRJNA438572_P_NODE_23374_length_243_cov_0.917647_g23255_i0 PRJNA438572 23374 243 0.917647 2.22988221 Bacillati 1783272 Bacteria Bacteria 89.7 8.26e-19   NR WP_157456636.1 2751 g23255 i0 54.7 7.41975308641975 75 34 92.6 0 17 241 6 80 WP_157456636.1 flavin monoamine oxidase family protein [Carnobacterium maltaromaticum] diamond 1803 90.1 0.995560488346282 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Carnobacterium Carnobacterium maltaromaticum
30865810 30865810 PRJNA438572_P_NODE_674_length_1081_cov_1.603175_g607_i0 PRJNA438572 674 1081 1.603175 17.33032175 Cohnella ginsengisoli 425004 Bacteria Bacteria 60.8 5.7e-6   NR WP_277568854.1 425004 g607 i0 28.7 0.899167437557817 324 149 88.3 14 126 1079 255 502 WP_277568854.1 cadherin-like beta sandwich domain-containing protein [Cohnella ginsengisoli] diamond 972 60.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella ginsengisoli
30960756 30960756 PRJNA438572_P_NODE_18514_length_251_cov_0.876404_g18395_i0 PRJNA438572 18514 251 0.876404 2.19977404 Clostridiales bacterium 1898207 Bacteria Bacteria 48.1 5.25e-4   NR HCC03781.1 1898207 g18395 i0 45.6 0.681274900398406 57 31 68.1 0 208 38 841 897 HCC03781.1 hypothetical protein [Clostridiales bacterium] diamond 171 48.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
31403376 31403376 PRJNA438572_P_NODE_6156_length_404_cov_1.129909_g6037_i0 PRJNA438572 6156 404 1.129909 4.56483236 Paenibacillus thiaminolyticus 49283 Bacteria Bacteria 52 8.07e-5   NR WP_119791936.1 49283 g6037 i0 53.2 0.349009900990099 47 16 34.9 1 260 120 45 85 WP_119791936.1 CoA transferase subunit A [Paenibacillus thiaminolyticus] diamond 141 52 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus thiaminolyticus
31577747 31577747 PRJNA438572_P_NODE_11416_length_304_cov_1.350649_g11297_i0 PRJNA438572 11416 304 1.350649 4.10597296 Bacteria 2 Bacteria Bacteria 44.7 0.0168   NR HJJ12640.1 1898204 g11297 i0 33.8 1.34210526315789 68 41 67.1 1 2 205 439 502 HJJ12640.1 RICIN domain-containing protein [Clostridiaceae bacterium] diamond 408 45.1 0.991130820399113 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
31672494 31672494 PRJNA438572_P_NODE_2037_length_681_cov_4.940789_g1926_i0 PRJNA438572 2037 681 4.940789 33.64677309 FCB group 1783270 Bacteria Bacteria 231 5.179999999999999e-73   NR WP_038476179.1 300825 g1926 i0 55.4 13.7885462555066 195 87 85.9 0 595 11 29 223 WP_038476179.1 type 1 glutamine amidotransferase domain-containing protein [Shouchella lehensis] diamond 9390 232 0.995689655172414 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Shouchella Shouchella lehensis
31798896 31798896 PRJNA438572_P_NODE_16977_length_253_cov_0.866667_g16858_i0 PRJNA438572 16977 253 0.866667 2.19266751 Mammaliicoccus 2803850 Bacteria Bacteria 55.1 2.28e-7   NR WP_239371962.1 1296 g16858 i0 85.2 0.640316205533597 27 4 32 0 253 173 88 114 WP_239371962.1 hypothetical protein [Mammaliicoccus sciuri] diamond 162 55.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Mammaliicoccus Mammaliicoccus sciuri
32194140 32194140 PRJNA438572_P_NODE_13678_length_281_cov_1.125000_g13559_i0 PRJNA438572 13678 281 1.125 3.16125 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 53.5 8.51e-6   NR MBQ1567200.1 2049044 g13559 i0 57.1 1.55871886120996 42 18 44.8 0 103 228 31 72 MBQ1567200.1 nucleoside hydrolase [Erysipelotrichaceae bacterium] diamond 438 53.5 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
32225850 32225850 PRJNA438572_P_NODE_16738_length_253_cov_1.655556_g16619_i0 PRJNA438572 16738 253 1.655556 4.18855668 Thermicanus aegyptius 94009 Bacteria Bacteria 112 4.13e-29   NR WP_052329845.1 94009 g16619 i0 78.5 1.87351778656126 79 5 93.7 1 3 239 119 185 WP_052329845.1 hypothetical protein [Thermicanus aegyptius] diamond 474 112 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
32415685 32415685 PRJNA438572_P_NODE_22459_length_245_cov_0.906977_g22340_i0 PRJNA438572 22459 245 0.906977 2.22209365 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 47 0.00115   NR MBQ4363610.1 2485925 g22340 i0 66.7 0.930612244897959 30 10 36.7 0 235 146 14 43 MBQ4363610.1 hypothetical protein [Oscillospiraceae bacterium] diamond 228 47 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32825648 32825648 PRJNA438572_P_NODE_19080_length_250_cov_0.881356_g18961_i0 PRJNA438572 19080 250 0.881356 2.20339 Parasporobacterium sp. 2740533 Bacteria Bacteria 51.6 3.03e-5   NR MBQ6368637.1 2740533 g18961 i0 37.9 4.368 66 37 74.4 2 229 44 12 77 MBQ6368637.1 serine/threonine protein kinase [Parasporobacterium sp.] diamond 1092 51.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Parasporobacterium Parasporobacterium sp.
32888430 32888430 PRJNA438572_P_NODE_18360_length_251_cov_0.876404_g18241_i0 PRJNA438572 18360 251 0.876404 2.19977404 Clostridia bacterium 2044939 Bacteria Bacteria 54.3 3.7e-7   NR MBP5288465.1 2044939 g18241 i0 63.9 2.59362549800797 36 13 43 0 245 138 71 106 MBP5288465.1 SEC-C domain-containing protein [Clostridia bacterium] diamond 651 54.3 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);;