RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA596867" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 20 ✖

bioproject 1

  • PRJNA596867 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
8221197 8221197 PRJNA596867_P_NODE_13927_length_244_cov_0.900585_g13852_i0 PRJNA596867 13927 244 0.900585 2.1974274 uncultured Lawsonella sp. 1847727 Bacteria Bacteria 160 3.59e-45   NR WP_298576765.1 1847727 g13852 i0 96.3 0.995901639344262 81 3 99.6 0 244 2 365 445 WP_298576765.1 type I glutamate--ammonia ligase [uncultured Lawsonella sp.] diamond 243 160 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella uncultured Lawsonella sp.
10772326 10772326 PRJNA596867_P_NODE_1569_length_557_cov_1.756198_g1495_i0 PRJNA596867 1569 557 1.756198 9.78202286 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 195 6.669999999999999e-60   NR MFA6213564.1 2364082 g1495 i0 67.8 3.19389587073609 146 47 78.6 0 460 23 1 146 MFA6213564.1 ParB/Srx family N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 1779 195 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
15870723 15870723 PRJNA596867_P_NODE_13273_length_246_cov_0.890173_g13198_i0 PRJNA596867 13273 246 0.890173 2.18982558 Parenemella sanctibonifatiensis 2016505 Bacteria Bacteria 168 3.64e-48   NR WP_094454757.1 2016505 g13198 i0 100 1 82 0 100 0 246 1 166 247 WP_094454757.1 class II 3-deoxy-7-phosphoheptulonate synthase [Parenemella sanctibonifatiensis] diamond 246 168 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Parenemella Parenemella sanctibonifatiensis
26731229 26731229 PRJNA596867_P_NODE_11621_length_250_cov_1.372881_g11546_i0 PRJNA596867 11621 250 1.372881 3.4322025 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 45.1 0.00628   NR MCW5936368.1 2682144 g11546 i0 32.1 0.972 81 52 93.6 1 7 240 367 447 MCW5936368.1 hypothetical protein [Fimbriimonadaceae bacterium] diamond 243 45.1 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
26731230 26731230 PRJNA596867_P_NODE_12381_length_248_cov_1.320000_g12306_i0 PRJNA596867 12381 248 1.32 3.2736 Staphylococcus equorum 246432 Bacteria Bacteria 125 7.62e-36   NR WP_269354497.1 246432 g12306 i0 100 0.713709677419355 59 0 71.4 0 248 72 2 60 WP_269354497.1 hypothetical protein, partial [Staphylococcus equorum] diamond 177 125 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus equorum
26795023 26795023 PRJNA596867_P_NODE_9941_length_267_cov_1.572165_g9866_i0 PRJNA596867 9941 267 1.572165 4.19768055 Clostridia bacterium 2044939 Bacteria Bacteria 42 0.0318   NR MEG1204422.1 2044939 g9866 i0 32.8 0.685393258426966 61 38 65.2 2 255 82 32 92 MEG1204422.1 hypothetical protein [Clostridia bacterium] diamond 183 42 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28261574 28261574 PRJNA596867_P_NODE_13806_length_244_cov_3.280702_g13731_i0 PRJNA596867 13806 244 3.280702 8.00491288 Lawsonella 1847725 Bacteria Bacteria 159 1.22e-43   NR WP_303678668.1 1528099 g13731 i0 100 1.99180327868852 81 0 99.6 0 2 244 283 363 WP_303678668.1 peptidoglycan D,D-transpeptidase FtsI family protein [Lawsonella clevelandensis] diamond 486 159 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
28406320 28406320 PRJNA596867_P_NODE_7646_length_297_cov_0.946429_g7571_i0 PRJNA596867 7646 297 0.946429 2.81089413 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.1 0.0193   NR TMC87456.1 2026724 g7571 i0 38.5 0.525252525252525 52 32 52.5 0 220 65 53 104 TMC87456.1 MAG: hypothetical protein E6J12_13035 [Chloroflexota bacterium] diamond 156 43.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28690630 28690630 PRJNA596867_P_NODE_11767_length_250_cov_0.870056_g11692_i0 PRJNA596867 11767 250 0.870056 2.17514 Actinomyces naeslundii 1655 Bacteria Bacteria 141 2.25e-40   NR WP_076080639.1 1655 g11692 i0 95.8 0.852 71 3 85.2 0 248 36 124 194 WP_076080639.1 hypothetical protein [Actinomyces naeslundii] diamond 213 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces naeslundii
28753530 28753530 PRJNA596867_P_NODE_12147_length_249_cov_0.875000_g12072_i0 PRJNA596867 12147 249 0.875 2.17875 Clostridium sp. 1506 Bacteria Bacteria 43.5 0.0109   NR MFQ7536942.1 1506 g12072 i0 39 1.48192771084337 41 25 49.4 0 114 236 56 96 MFQ7536942.1 isoaspartyl peptidase/L-asparaginase [Clostridium sp.] diamond 369 43.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
29921993 29921993 PRJNA596867_P_NODE_9451_length_273_cov_1.510000_g9376_i0 PRJNA596867 9451 273 1.51 4.1223 Mycobacterium sp. 11 1785 Bacteria Bacteria 44.7 0.00998   NR OBA62656.1 1834067 g9376 i0 47.2 0.582417582417582 53 26 58.2 2 182 24 120 170 OBA62656.1 hypothetical protein A5647_07230 [Mycobacterium sp. 1100029.7] diamond 159 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. 1100029.7
29985065 29985065 PRJNA596867_P_NODE_10031_length_266_cov_1.595855_g9956_i0 PRJNA596867 10031 266 1.595855 4.2449743 Aurantimicrobium sp. 1930784 Bacteria Bacteria 148 8.930000000000001e-44   NR WP_332627286.1 1930784 g9956 i0 91.1 0.890977443609023 79 7 89.1 0 265 29 68 146 WP_332627286.1 hypothetical protein [Aurantimicrobium sp.] diamond 237 148 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aurantimicrobium Aurantimicrobium sp.
30333063 30333063 PRJNA596867_P_NODE_14132_length_244_cov_0.900585_g14057_i0 PRJNA596867 14132 244 0.900585 2.1974274 uncultured Pseudonocardia sp. 211455 Bacteria Bacteria 43.5 0.0192   NR WP_298800451.1 211455 g14057 i0 38.6 0.700819672131147 57 29 67.6 2 176 12 359 411 WP_298800451.1 helicase associated domain-containing protein [uncultured Pseudonocardia sp.] diamond 171 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia uncultured Pseudonocardia sp.
30522119 30522119 PRJNA596867_P_NODE_12233_length_249_cov_0.875000_g12158_i0 PRJNA596867 12233 249 0.875 2.17875 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42 0.0415   NR WP_383750080.1 3346213 g12158 i0 34.6 0.626506024096386 52 34 62.7 0 5 160 92 143 WP_383750080.1 hypothetical protein [Streptomyces sp. NPDC057689] diamond 156 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC057689
30711690 30711690 PRJNA596867_P_NODE_10874_length_256_cov_1.502732_g10799_i0 PRJNA596867 10874 256 1.502732 3.84699392 Streptomyces lydicus 47763 Bacteria Bacteria 43.9 0.017   NR MDC7341148.1 47763 g10799 i0 45.5 0.64453125 55 25 62.1 3 67 225 370 421 MDC7341148.1 MMPL family transporter [Streptomyces lydicus] diamond 165 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lydicus
31027853 31027853 PRJNA596867_P_NODE_12135_length_249_cov_0.875000_g12060_i0 PRJNA596867 12135 249 0.875 2.17875 Nocardioides sp. GXZ 35761 Bacteria Bacteria 42.4 0.0257   NR WP_340539027.1 3136018 g12060 i0 33.3 0.903614457831325 75 46 89.2 2 245 24 38 109 WP_340539027.1 hypothetical protein [Nocardioides sp. GXZ039] diamond 225 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp. GXZ039
31153685 31153685 PRJNA596867_P_NODE_11975_length_249_cov_1.710227_g11900_i0 PRJNA596867 11975 249 1.710227 4.25846523 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 45.1 0.00614   NR HEY5988987.1 2339230 g11900 i0 32.5 1.92771084337349 80 47 91.6 2 243 16 289 365 HEY5988987.1 S9 family peptidase [Streptosporangiaceae bacterium] diamond 480 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
32039733 32039733 PRJNA596867_P_NODE_10078_length_266_cov_0.953368_g10003_i0 PRJNA596867 10078 266 0.953368 2.53595888 Baekduia sp. 2600305 Bacteria Bacteria 43.9 0.0176   NR HEY6758934.1 2600305 g10003 i0 46 0.710526315789474 63 32 69.9 2 71 256 123 184 HEY6758934.1 DMT family transporter [Baekduia sp.] diamond 189 43.9 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Baekduiaceae Baekduia Baekduia sp.
32197926 32197926 PRJNA596867_P_NODE_13558_length_245_cov_0.895349_g13483_i0 PRJNA596867 13558 245 0.895349 2.19360505 Rhodococcus zopfii 43772 Bacteria Bacteria 47 0.00116   NR WP_238072421.1 43772 g13483 i0 39.4 1.61632653061224 66 40 80.8 0 22 219 164 229 WP_238072421.1 2Fe-2S iron-sulfur cluster-binding protein [Rhodococcus zopfii] diamond 396 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus zopfii
32735144 32735144 PRJNA596867_P_NODE_14880_length_242_cov_0.911243_g14805_i0 PRJNA596867 14880 242 0.911243 2.20520806 Aedoeadaptatus coli 2058292 Bacteria Bacteria 149 2.3299999999999993e-40   NR WP_108831055.1 2058292 g14805 i0 96.3 0.991735537190083 80 3 99.2 0 3 242 196 275 WP_108831055.1 histidine kinase N-terminal 7TM domain-containing protein [Aedoeadaptatus coli] diamond 240 149 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus coli

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