RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJEB27957 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
26589704 26589704 PRJEB27957_P_NODE_52061_length_228_cov_1.162011_g51951_i0 PRJEB27957 52061 228 1.162011 2.64938508 Clostridia bacterium 2044939 Bacteria Bacteria 43.9 0.0121   NR MBO4422105.1 2044939 g51951 i0 38.3 0.789473684210526 60 30 69.7 1 62 220 239 298 MBO4422105.1 hypothetical protein [Clostridia bacterium] diamond 180 43.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
26875274 26875274 PRJEB27957_P_NODE_60081_length_216_cov_1.077844_g59971_i0 PRJEB27957 60081 216 1.077844 2.32814304 Ruminiclostridium sp. 2053608 Bacteria Bacteria 43.1 0.0193   NR HBR01483.1 2053608 g59971 i0 32.8 0.847222222222222 61 39 81.9 1 36 212 437 497 HBR01483.1 helicase [Ruminiclostridium sp.] diamond 183 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminiclostridium Ruminiclostridium sp.
26969776 26969776 PRJEB27957_P_NODE_68002_length_205_cov_1.666667_g67892_i0 PRJEB27957 68002 205 1.666667 3.41666735 Sulfobacillus thermosulfidooxidans 28034 Bacteria Bacteria 42 0.0402   NR WP_084661777.1 28034 g67892 i0 45.5 0.482926829268293 33 18 48.3 0 30 128 11 43 WP_084661777.1 adenosine deaminase [Sulfobacillus thermosulfidooxidans] diamond 99 42 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiales Family XVII. Incertae Sedis Sulfobacillus Sulfobacillus thermosulfidooxidans
27507354 27507354 PRJEB27957_P_NODE_68883_length_204_cov_1.535484_g68773_i0 PRJEB27957 68883 204 1.535484 3.13238736 Clostridiaceae bacterium 14S 1898204 Bacteria Bacteria 41.6 0.048   NR AWZ47724.1 2082193 g68773 i0 43.9 0.602941176470588 41 22 60.3 1 161 39 58 97 AWZ47724.1 hypothetical protein C3495_02175 [Clostridiaceae bacterium 14S0207] diamond 123 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium 14S0207
27980819 27980819 PRJEB27957_P_NODE_115745_length_165_cov_0.896552_g115635_i0 PRJEB27957 115745 165 0.896552 1.4793108 Aminipila sp. 2060095 Bacteria Bacteria 41.2 0.0431   NR MFV0518454.1 2060095 g115635 i0 47.2 0.654545454545455 36 19 65.5 0 110 3 47 82 MFV0518454.1 cell wall hydrolase [Aminipila sp.] diamond 108 41.2 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae Aminipila Aminipila sp.
28264781 28264781 PRJEB27957_P_NODE_60646_length_215_cov_1.253012_g60536_i0 PRJEB27957 60646 215 1.253012 2.6939758 Clostridiales bacterium 1898207 Bacteria Bacteria 42.7 0.0255   NR NLB16703.1 1898207 g60536 i0 35.8 0.73953488372093 53 34 74 0 31 189 349 401 NLB16703.1 hypothetical protein [Clostridiales bacterium] diamond 159 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28612293 28612293 PRJEB27957_P_NODE_51207_length_229_cov_2.055556_g51097_i0 PRJEB27957 51207 229 2.055556 4.70722324 Desulfolucanica intricata 1285191 Bacteria Bacteria 42.7 0.0192   NR WP_066639422.1 1285191 g51097 i0 30.6 0.641921397379913 49 34 64.2 0 18 164 17 65 WP_066639422.1 NuoI/complex I 23 kDa subunit family protein [Desulfolucanica intricata] diamond 147 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae Desulfolucanica Desulfolucanica intricata
28738573 28738573 PRJEB27957_P_NODE_38247_length_257_cov_1.711538_g38137_i0 PRJEB27957 38247 257 1.711538 4.39865266 Erysipelotrichales bacterium 2478483 Bacteria Bacteria 42.7 0.0406   NR MBQ9988074.1 2478483 g38137 i0 41.3 0.536964980544747 46 25 51.4 1 66 197 44 89 MBQ9988074.1 rod shape-determining protein MreC [Erysipelotrichales bacterium] diamond 138 42.7 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales     Erysipelotrichales bacterium
28864781 28864781 PRJEB27957_P_NODE_89048_length_182_cov_1.563910_g88938_i0 PRJEB27957 89048 182 1.56391 2.8463162 Bacillota bacterium 1879010 Bacteria Bacteria 43.9 0.00635   NR MCI8285172.1 1879010 g88938 i0 39.1 1.51648351648352 46 28 75.8 0 153 16 16 61 MCI8285172.1 MBL fold metallo-hydrolase [Bacillota bacterium] diamond 276 43.9 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28959798 28959798 PRJEB27957_P_NODE_115428_length_165_cov_0.896552_g115318_i0 PRJEB27957 115428 165 0.896552 1.4793108 Bacilli bacterium 1903720 Bacteria Bacteria 41.2 0.0469   NR MBP5551681.1 1903720 g115318 i0 45.9 0.672727272727273 37 20 67.3 0 159 49 253 289 MBP5551681.1 hypothetical protein [Bacilli bacterium] diamond 111 41.2 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29212337 29212337 PRJEB27957_P_NODE_94289_length_177_cov_1.218750_g94179_i0 PRJEB27957 94289 177 1.21875 2.1571875 Staphylococcus caeli 2201815 Bacteria Bacteria 42 0.0286   NR WP_069995404.1 2201815 g94179 i0 32.1 0.949152542372881 56 38 94.9 0 3 170 188 243 WP_069995404.1 poly(glycerol-phosphate) alpha-glucosyltransferase [Staphylococcus caeli] diamond 168 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus caeli
30033297 30033297 PRJEB27957_P_NODE_92531_length_179_cov_1.153846_g92421_i0 PRJEB27957 92531 179 1.153846 2.06538434 Staphylococcus aureus 1280 Bacteria Bacteria 40.8 0.0126   NR MDN8907574.1 1280 g92421 i0 76 0.418994413407821 25 6 41.9 0 80 154 30 54 MDN8907574.1 hypothetical protein [Staphylococcus aureus] diamond 75 40.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30096250 30096250 PRJEB27957_P_NODE_87612_length_184_cov_1.133333_g87502_i0 PRJEB27957 87612 184 1.133333 2.08533272 Desulfovirgula thermocuniculi 348842 Bacteria Bacteria 41.2 0.0411   NR WP_027717005.1 348842 g87502 i0 47.4 0.619565217391304 38 20 62 0 2 115 5 42 WP_027717005.1 rod shape-determining protein MreD [Desulfovirgula thermocuniculi] diamond 114 41.2 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Desulfovirgula Desulfovirgula thermocuniculi
30318084 30318084 PRJEB27957_P_NODE_55232_length_223_cov_1.195402_g55122_i0 PRJEB27957 55232 223 1.195402 2.66574646 Clostridiales bacterium 1898207 Bacteria Bacteria 40.4 0.0478   NR UKI37396.1 1898207 g55122 i0 39.1 0.618834080717489 46 26 60.5 2 53 187 25 69 UKI37396.1 MAG: hypothetical protein L6V93_04395 [Clostridiales bacterium] diamond 138 40.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
30475629 30475629 PRJEB27957_P_NODE_31293_length_278_cov_1.362445_g31183_i0 PRJEB27957 31293 278 1.362445 3.7875971 Carnobacterium gallinarum 2749 Bacteria Bacteria 43.5 0.0266   NR WP_034562090.1 2749 g31183 i0 36.8 0.615107913669065 57 33 60.4 2 172 5 143 197 WP_034562090.1 DUF1295 domain-containing protein [Carnobacterium gallinarum] diamond 171 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Carnobacterium Carnobacterium gallinarum
30475630 30475630 PRJEB27957_P_NODE_33873_length_269_cov_2.972727_g33763_i0 PRJEB27957 33873 269 2.972727 7.99663563 Roseburia inulinivorans 360807 Bacteria Bacteria 46.2 0.00284   NR WP_118202798.1 360807 g33763 i0 30.6 0.546468401486989 49 32 52.4 1 11 151 259 307 WP_118202798.1 glycosyltransferase family 2 protein [Roseburia inulinivorans] diamond 147 46.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Roseburia Roseburia inulinivorans
31107308 31107308 PRJEB27957_P_NODE_125535_length_162_cov_0.920354_g125425_i0 PRJEB27957 125535 162 0.920354 1.49097348 Streptococcus pneumoniae 1313 Bacteria Bacteria 38.9 0.0436   NR MFR7015324.1 1313 g125425 i0 76.2 0.388888888888889 21 5 38.9 0 70 8 31 51 MFR7015324.1 hypothetical protein [Streptococcus pneumoniae] diamond 63 38.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31392163 31392163 PRJEB27957_P_NODE_108676_length_167_cov_1.322034_g108566_i0 PRJEB27957 108676 167 1.322034 2.20779678 uncultured Clostridium sp. 59620 Bacteria Bacteria 42.7 0.0132   NR WP_294345193.1 59620 g108566 i0 45.7 0.62874251497006 35 19 62.9 0 162 58 58 92 WP_294345193.1 metallophosphoesterase [uncultured Clostridium sp.] diamond 105 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
31676537 31676537 PRJEB27957_P_NODE_30397_length_281_cov_1.568966_g30287_i0 PRJEB27957 30397 281 1.568966 4.40879446 Enterococcus hirae 1354 Bacteria Bacteria 47.4 1.36e-4   NR PWG73470.1 1354 g30287 i0 58.8 0.362989323843416 34 14 36.3 0 174 73 21 54 PWG73470.1 hypothetical protein DF186_22910, partial [Enterococcus hirae] diamond 102 47.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus hirae
31803035 31803035 PRJEB27957_P_NODE_8317_length_448_cov_2.416040_g8208_i0 PRJEB27957 8317 448 2.41604 10.8238592 Clostridiales bacterium 1898207 Bacteria Bacteria 42.7 0.0367   NR HBK25184.1 1898207 g8208 i0 34.7 0.328125 49 32 32.8 0 220 366 12 60 HBK25184.1 metal-dependent hydrolase with the TIM-barrel fold protein [Clostridiales bacterium] diamond 147 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
32246457 32246457 PRJEB27957_P_NODE_84238_length_187_cov_1.507246_g84128_i0 PRJEB27957 84238 187 1.507246 2.81855002 Clostridia bacterium 2044939 Bacteria Bacteria 40.4 0.0272   NR MBQ8683810.1 2044939 g84128 i0 29.5 0.978609625668449 61 29 97.9 2 1 183 5 51 MBQ8683810.1 membrane protein insertion efficiency factor YidD [Clostridia bacterium] diamond 183 40.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32271463 32271463 PRJEB27957_P_NODE_69958_length_203_cov_1.292208_g69848_i0 PRJEB27957 69958 203 1.292208 2.62318224 Ruminococcus 1263 Bacteria Bacteria 42.7 0.0222   NR WP_044976413.1 1514668 g69848 i0 41.1 1.59605911330049 56 33 82.8 0 177 10 411 466 WP_044976413.1 DNA primase [Ruminococcus sp. HUN007] diamond 324 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp. HUN007
32277981 32277981 PRJEB27957_P_NODE_79059_length_192_cov_2.181818_g78949_i0 PRJEB27957 79059 192 2.181818 4.18909056 Eubacteriales bacterium 2831996 Bacteria Bacteria 42 0.0347   NR MDD6603670.1 2831996 g78949 i0 38.5 0.8125 52 26 71.9 1 37 174 180 231 MDD6603670.1 sugar phosphate isomerase/epimerase [Eubacteriales bacterium] diamond 156 42 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
32372879 32372879 PRJEB27957_P_NODE_86479_length_185_cov_1.147059_g86369_i0 PRJEB27957 86479 185 1.147059 2.12205915 Enterococcus hirae 1354 Bacteria Bacteria 56.2 1.42e-8   NR PWG73470.1 1354 g86369 i0 46.9 0.794594594594595 49 26 79.5 0 152 6 12 60 PWG73470.1 hypothetical protein DF186_22910, partial [Enterococcus hirae] diamond 147 56.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus hirae
32594169 32594169 PRJEB27957_P_NODE_56160_length_221_cov_2.720930_g56050_i0 PRJEB27957 56160 221 2.72093 6.0132553 Veillonellales bacterium 2870862 Bacteria Bacteria 43.9 0.0103   NR MEN6566049.1 2870862 g56050 i0 46.5 0.583710407239819 43 23 58.4 0 72 200 225 267 MEN6566049.1 LysR family transcriptional regulator [Veillonellales bacterium] diamond 129 43.9 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales     Veillonellales 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);;