RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 17 ✖

bioproject 1

  • PRJEB73599 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
2270626 2270626 PRJEB73599_P_NODE_4482_length_318_cov_2.484429_g4195_i0 PRJEB73599 4482 318 2.484429 7.90048422 Streptomyces polyasparticus 2767826 Bacteria Bacteria 172 1.9799999999999994e-52   NR WP_187820194.1 2767826 g4195 i0 87.9 0.933962264150943 99 10 93.4 1 20 316 35 131 WP_187820194.1 chlorophyll a-b binding domain-containing protein, partial [Streptomyces polyasparticus] diamond 297 172 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces polyasparticus
3961322 3961322 PRJEB73599_P_NODE_9784_length_157_cov_1.671875_g9497_i0 PRJEB73599 9784 157 1.671875 2.62484375 PVC group 1783257 Bacteria Bacteria 88.6 8.21e-19   NR WP_325390658.1 49981 g9497 i0 74.5 15.5923566878981 51 13 97.5 0 2 154 275 325 WP_325390658.1 molecular chaperone HtpG [Desulfitobacterium sp.] diamond 2448 89 0.995505617977528 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
6513266 6513266 PRJEB73599_P_NODE_3646_length_369_cov_1.764706_g3360_i0 PRJEB73599 3646 369 1.764706 6.51176514 Listeria portnoyi 2713504 Bacteria Bacteria 72.8 3.2e-12   NR WP_187131572.1 2713504 g3360 i0 64.7 1.49593495934959 51 18 41.5 0 7 159 5 55 WP_187131572.1 ParA family protein [Listeria portnoyi] diamond 552 72.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria portnoyi
7787572 7787572 PRJEB73599_P_NODE_727_length_886_cov_2.033839_g583_i0 PRJEB73599 727 886 2.033839 18.01981354 Nocardiopsis alborubida 146802 Bacteria Bacteria 95.5 7.78e-18   NR WP_168443938.1 146802 g583 i0 36 1.01580135440181 150 79 47.7 4 878 456 258 399 WP_168443938.1 type I polyketide synthase [Nocardiopsis alborubida] diamond 900 95.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Nocardiopsis Nocardiopsis alborubida
26907555 26907555 PRJEB73599_P_NODE_6102_length_247_cov_7.568807_g5815_i0 PRJEB73599 6102 247 7.568807 18.69495329 Clostridiales bacterium 1898207 Bacteria Bacteria 43.9 0.0148   NR NLE68665.1 1898207 g5815 i0 51.4 0.449392712550607 37 15 44.9 1 185 75 97 130 NLE68665.1 hypothetical protein [Clostridiales bacterium] diamond 111 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27469475 27469475 PRJEB73599_P_NODE_743_length_878_cov_2.027091_g597_i0 PRJEB73599 743 878 2.027091 17.79785898 Cylindrospermum 56106 Bacteria Bacteria 160 3.5499999999999993e-40   NR WP_051503061.1 1161 g597 i0 35 5.76423690205011 286 171 97.4 5 1 855 1057 1328 WP_051503061.1 MULTISPECIES: amino acid adenylation domain-containing protein [Nostocales] diamond 5061 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales      
27539762 27539762 PRJEB73599_P_NODE_5364_length_276_cov_2.048583_g5077_i0 PRJEB73599 5364 276 2.048583 5.65408908 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.5 0.0295   NR WP_363135002.1 3157097 g5077 i0 43.8 0.521739130434783 48 27 52.2 0 88 231 84 131 WP_363135002.1 PQQ-binding-like beta-propeller repeat protein [Streptomyces sp. NPDC050610] diamond 144 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC050610
27729500 27729500 PRJEB73599_P_NODE_1004_length_751_cov_4.897507_g827_i0 PRJEB73599 1004 751 4.897507 36.78027757 Actinomadura sp. 1989 Bacteria Bacteria 108 1.56e-24   NR HEV7933428.1 1989 g827 i0 32.4 0.838881491344874 210 135 81.5 4 704 93 18 226 HEV7933428.1 hypothetical protein [Actinomadura sp.] diamond 630 108 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura sp.
28739515 28739515 PRJEB73599_P_NODE_6767_length_226_cov_2.060914_g6480_i0 PRJEB73599 6767 226 2.060914 4.65766564 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 101 2.45e-24   NR MCB0958566.1 2201156 g6480 i0 60 1.99115044247788 75 30 99.6 0 1 225 153 227 MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium] diamond 450 101 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29181708 29181708 PRJEB73599_P_NODE_4569_length_313_cov_4.035211_g4282_i0 PRJEB73599 4569 313 4.035211 12.63021043 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 47.8 1.15e-4   NR MEL7079773.1 3023143 g4282 i0 57.8 0.431309904153355 45 19 43.1 0 137 271 15 59 MEL7079773.1 hypothetical protein [Cyanobacteria bacterium J06582_2] diamond 135 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
29749567 29749567 PRJEB73599_P_NODE_9471_length_162_cov_3.218045_g9184_i0 PRJEB73599 9471 162 3.218045 5.2132329 Enterococcus faecium 1352 Bacteria Bacteria 61.2 3.72e-10   NR RBT11052.1 1352 g9184 i0 60 0.925925925925926 50 20 92.6 0 161 12 20 69 RBT11052.1 hypothetical protein EA95_02947, partial [Enterococcus faecium] diamond 150 61.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
30350614 30350614 PRJEB73599_P_NODE_6872_length_223_cov_2.262887_g6585_i0 PRJEB73599 6872 223 2.262887 5.04623801 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 90.9 3.2e-20   NR MCB0958566.1 2201156 g6585 i0 53.4 5.91928251121076 73 34 98.2 0 221 3 153 225 MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium] diamond 1320 90.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31132465 31132465 PRJEB73599_P_NODE_755_length_868_cov_2.537545_g524_i2 PRJEB73599 755 868 2.537545 22.0258906 FCB group 1783270 Bacteria Bacteria 170 1.5899999999999996e-43   NR MCW2687244.1 1785 g524 i2 39.5 21.1624423963134 263 152 89.9 6 7 786 595 853 MCW2687244.1 Polyketide synthase [Mycobacterium sp.] diamond 18369 170 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
31354163 31354163 PRJEB73599_P_NODE_7996_length_192_cov_1.754601_g7709_i0 PRJEB73599 7996 192 1.754601 3.36883392 FCB group 1783270 Bacteria Bacteria 71.6 4.62e-13   NR MEZ5183991.1 2201156 g7709 i0 46 4.90625 63 34 98.4 0 2 190 152 214 MEZ5183991.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium] diamond 942 71.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31512449 31512449 PRJEB73599_P_NODE_676_length_915_cov_2.551919_g524_i1 PRJEB73599 676 915 2.551919 23.35005885 delta/epsilon subdivisions 68525 Bacteria Bacteria 171 7.699999999999998e-44   NR WP_085249783.1 486698 g524 i1 38 21.2065573770492 266 154 85.9 5 46 831 571 829 WP_085249783.1 type I polyketide synthase [Mycobacterium riyadhense] diamond 19404 172 0.994186046511628 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium riyadhense
32057199 32057199 PRJEB73599_P_NODE_10038_length_152_cov_2.853659_g9751_i0 PRJEB73599 10038 152 2.853659 4.33756168 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 73.6 4.86e-14   NR MCB0958566.1 2201156 g9751 i0 61.7 0.927631578947368 47 18 92.8 0 3 143 183 229 MCB0958566.1 PqqD family peptide modification chaperone [Acidimicrobiales bacterium] diamond 141 73.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
32152176 32152176 PRJEB73599_P_NODE_4958_length_294_cov_1.739623_g4671_i0 PRJEB73599 4958 294 1.739623 5.11449162 Trichodesmium sp. St18_bin1 2954180 Bacteria Bacteria 100 3.59e-22   NR MDE5080684.1 2954180 g4671 i0 53.1 1.8469387755102 98 42 99 2 294 4 156 250 MDE5080684.1 5-histidylcysteine sulfoxide synthase [Trichodesmium sp. St18_bin1] diamond 543 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Trichodesmium Trichodesmium sp. St18_bin1

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