RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1197996" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 19 ✖

bioproject 1

  • PRJNA1197996 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
9251754 9251754 PRJNA1197996_S_NODE_13068_length_307_cov_1.303419_g13014_i0 PRJNA1197996 13068 307 1.303419 4.00149633 Enterococcus 1350 Bacteria Bacteria 169 3.61e-49   NR WP_413133017.1 37734 g13014 i0 72.5 1.99348534201954 102 28 99.7 0 307 2 168 269 WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus] diamond 612 169 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus casseliflavus
20725373 20725373 PRJNA1197996_S_NODE_217_length_1223_cov_6.174783_g197_i0 PRJNA1197996 217 1223 6.174783 75.51759609 Enterococcus casseliflavus 37734 Bacteria Bacteria 382 1.19e-127   NR WP_413133017.1 37734 g197 i0 54.2 1.61651676206051 349 147 82.4 2 1088 81 17 365 WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus] diamond 1977 382 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus casseliflavus
26755804 26755804 PRJNA1197996_S_NODE_23841_length_250_cov_1.435028_g23787_i0 PRJNA1197996 23841 250 1.435028 3.58757 Halanaerobiales bacterium 2094029 Bacteria Bacteria 42.4 0.0351   NR MBS3811332.1 2094029 g23787 i0 37.1 0.744 62 37 73.2 2 31 213 89 149 MBS3811332.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Halanaerobiales bacterium] diamond 186 42.4 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
27198720 27198720 PRJNA1197996_S_NODE_6502_length_382_cov_1.834951_g6448_i0 PRJNA1197996 6502 382 1.834951 7.00951282 Christensenellaceae bacterium 2054177 Bacteria Bacteria 44.7 0.0338   NR MDY2879560.1 2054177 g6448 i0 31.2 0.604712041884817 77 48 58.1 3 252 31 385 459 MDY2879560.1 MATE family efflux transporter [Christensenellaceae bacterium] diamond 231 44.7 1 Bacteria   Bacillati Bacillota Clostridia Christensenellales Christensenellaceae   Christensenellaceae bacterium
27293763 27293763 PRJNA1197996_S_NODE_7463_length_366_cov_3.464164_g7409_i0 PRJNA1197996 7463 366 3.464164 12.67884024 Clostridium cochlearium 1494 Bacteria Bacteria 43.1 0.0308   NR WP_171302903.1 1494 g7409 i0 32.2 0.737704918032787 90 43 68.9 3 34 285 40 117 WP_171302903.1 hypothetical protein [Clostridium cochlearium] diamond 270 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium cochlearium
27736244 27736244 PRJNA1197996_S_NODE_29284_length_231_cov_2.139241_g29230_i0 PRJNA1197996 29284 231 2.139241 4.94164671 Actinomycetota bacterium 2900548 Bacteria Bacteria 48.5 2.88e-4   NR NIA31726.1 2900548 g29230 i0 33.3 1.01298701298701 78 46 93.5 3 11 226 8 85 NIA31726.1 prolyl oligopeptidase family serine peptidase [Actinomycetota bacterium] diamond 234 48.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27862095 27862095 PRJNA1197996_S_NODE_26345_length_245_cov_1.343023_g26291_i0 PRJNA1197996 26345 245 1.343023 3.29040635 Actinomycetota bacterium 2900548 Bacteria Bacteria 94 1.95e-20   NR NBX70493.1 2900548 g26291 i0 67.2 3.12244897959184 64 21 78.4 0 1 192 144 207 NBX70493.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [Actinomycetota bacterium] diamond 765 94 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28335785 28335785 PRJNA1197996_S_NODE_10026_length_334_cov_1.521073_g9972_i0 PRJNA1197996 10026 334 1.521073 5.08038382 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 44.3 0.0268   NR MDD2958078.1 1898203 g9972 i0 30 0.988023952095808 110 69 98.8 3 333 4 121 222 MDD2958078.1 hypothetical protein [Lachnospiraceae bacterium] diamond 330 44.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28702146 28702146 PRJNA1197996_S_NODE_10707_length_327_cov_6.748031_g10653_i0 PRJNA1197996 10707 327 6.748031 22.06606137 Bacteria 2 Bacteria Bacteria 50.1 1.76e-4   NR HEX3832508.1 2586742 g10653 i0 60 1.57798165137615 35 14 32.1 0 14 118 193 227 HEX3832508.1 SDR family oxidoreductase [Solirubrobacteraceae bacterium] diamond 516 50.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
29220052 29220052 PRJNA1197996_S_NODE_25949_length_246_cov_0.890173_g25895_i0 PRJNA1197996 25949 246 0.890173 2.18982558 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.7 0.0387   NR MDE2900906.1 2026724 g25895 i0 37.5 0.585365853658537 48 30 58.5 0 10 153 4 51 MDE2900906.1 hypothetical protein [Chloroflexota bacterium] diamond 144 42.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29491319 29491319 PRJNA1197996_S_NODE_19430_length_269_cov_1.750000_g19376_i0 PRJNA1197996 19430 269 1.75 4.7075 Cyanophyceae 3028117 Bacteria Bacteria 157 6.02e-48   NR CAA05951.1 324056 g19376 i0 90.9 3.92565055762082 88 8 98.1 0 2 265 8 95 CAA05951.1 phycocyanin beta subunit, partial [Microcystis aeruginosa EAWAG175] diamond 1056 157 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa
30072444 30072444 PRJNA1197996_S_NODE_252_length_1166_cov_4.238792_g230_i0 PRJNA1197996 252 1166 4.238792 49.42431472 Melissococcus plutonius 33970 Bacteria Bacteria 283 9.31e-89   NR WP_231849637.1 33970 g230 i0 45.7 0.87221269296741 339 169 83.6 4 1009 35 35 372 WP_231849637.1 pectate lyase family protein [Melissococcus plutonius] diamond 1017 283 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Melissococcus Melissococcus plutonius
30849703 30849703 PRJNA1197996_S_NODE_20774_length_263_cov_1.215789_g20720_i0 PRJNA1197996 20774 263 1.215789 3.19752507 Thermoleophilia 1497346 Bacteria Bacteria 75.1 1.94e-13   NR MCU0309089.1 2026888 g20720 i0 43.4 12.4334600760456 83 46 94.7 1 262 14 600 681 MCU0309089.1 MMPL family transporter [Thermoleophilia bacterium] diamond 3270 75.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia       Thermoleophilia bacterium
30925831 30925831 PRJNA1197996_S_NODE_16994_length_282_cov_1.593301_g16940_i0 PRJNA1197996 16994 282 1.593301 4.49310882 Eubacteriales bacterium 2831996 Bacteria Bacteria 46.6 0.00255   NR MBS7228452.1 2831996 g16940 i0 39 0.627659574468085 59 35 62.8 1 89 265 506 563 MBS7228452.1 hypothetical protein [Eubacteriales bacterium] diamond 177 46.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
31450401 31450401 PRJNA1197996_S_NODE_2136_length_546_cov_6.945032_g2085_i0 PRJNA1197996 2136 546 6.945032 37.91987472 Nonomuraea 83681 Bacteria Bacteria 92.4 2.26e-19   NR WP_358132996.1 3154350 g2085 i0 51.8 2.32967032967033 85 37 46.2 2 1 252 147 228 WP_358132996.1 hypothetical protein [Nonomuraea sp. NPDC049152] diamond 1272 93.2 0.991416309012876 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC049152
31526389 31526389 PRJNA1197996_S_NODE_15936_length_288_cov_1.632558_g15882_i0 PRJNA1197996 15936 288 1.632558 4.70176704 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 120 3.05e-29   NR HEY9790360.1 2364082 g15882 i0 67.4 2.66666666666667 95 30 99 1 287 3 751 844 HEY9790360.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Obscuribacterales bacterium] diamond 768 120 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32063931 32063931 PRJNA1197996_S_NODE_12818_length_309_cov_1.254237_g12764_i0 PRJNA1197996 12818 309 1.254237 3.87559233 Nonomuraea sp. G32 3067274 Bacteria Bacteria 57.4 5.01e-7   NR WP_305917510.1 3067274 g12764 i0 58.1 0.41747572815534 43 17 40.8 1 6 131 288 330 WP_305917510.1 hypothetical protein [Nonomuraea sp. G32] diamond 129 57.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. G32
32127511 32127511 PRJNA1197996_S_NODE_21378_length_260_cov_1.780749_g21324_i0 PRJNA1197996 21378 260 1.780749 4.6299474 Caldilineaceae bacterium 2614250 Bacteria Bacteria 42.7 0.0468   NR MCC6168705.1 2614250 g21324 i0 35.8 0.773076923076923 67 40 77.3 1 212 12 490 553 MCC6168705.1 AAA family ATPase [Caldilineaceae bacterium] diamond 201 42.7 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
32412188 32412188 PRJNA1197996_S_NODE_16259_length_286_cov_2.417840_g16205_i0 PRJNA1197996 16259 286 2.41784 6.9150224 Paenibacillus sp. OSY-SE 1196323 Bacteria Bacteria 139 4.01e-36   NR WP_036702797.1 1196323 g16205 i0 69.6 0.965034965034965 92 28 96.5 0 285 10 229 320 WP_036702797.1 open beta-sheet domain-containing protein, partial [Paenibacillus sp. OSY-SE] diamond 276 139 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. OSY-SE

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