RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA195897" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA195897 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
10570066 10570066 PRJNA195897_P_NODE_5009_length_215_cov_1.566265_g4976_i0 PRJNA195897 5009 215 1.566265 3.36746975 Bacillus sp. 1P1 3132265 Bacteria Bacteria 63.9 3.69e-10   NR WP_413303918.1 3132265 g4976 i0 41.4 0.976744186046512 70 38 97.7 1 214 5 46 112 WP_413303918.1 SDR family oxidoreductase [Bacillus sp. 1P10SD] diamond 210 63.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. 1P10SD
27136733 27136733 PRJNA195897_P_NODE_722_length_639_cov_2.555932_g692_i0 PRJNA195897 722 639 2.555932 16.33240548 Pontibacillus sp. HMF3514 2692425 Bacteria Bacteria 147 2.51e-41   NR WP_160098424.1 2692425 g692 i0 47.9 1.94366197183099 140 73 65.7 0 132 551 5 144 WP_160098424.1 OsmC family protein [Pontibacillus sp. HMF3514] diamond 1242 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Pontibacillus Pontibacillus sp. HMF3514
27168547 27168547 PRJNA195897_P_NODE_10162_length_167_cov_0.881356_g10129_i0 PRJNA195897 10162 167 0.881356 1.47186452 Clostridia bacterium 2044939 Bacteria Bacteria 54.7 4.78e-7   NR MEI3390343.1 2044939 g10129 i0 46.4 2.04790419161677 56 29 98.8 1 167 3 131 186 MEI3390343.1 HD domain-containing protein [Clostridia bacterium] diamond 342 54.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27895102 27895102 PRJNA195897_P_NODE_3865_length_245_cov_1.061224_g3832_i0 PRJNA195897 3865 245 1.061224 2.5999988 Geobacillus sp. BCO2 1547578 Bacteria Bacteria 72.4 4.01e-13   NR KPC99382.1 1547578 g3832 i0 47.4 2.79183673469388 76 39 93.1 1 243 16 92 166 KPC99382.1 Purine nucleoside phosphorylase 1 [Geobacillus sp. BCO2] diamond 684 72.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus sp. BCO2
27912782 27912782 PRJNA195897_P_NODE_6165_length_198_cov_1.026846_g6132_i0 PRJNA195897 6165 198 1.026846 2.03315508 Bacillales 1385 Bacteria Bacteria 99.8 7.23e-25   NR WP_036801903.1 1372 g6132 i0 69.2 27.5454545454545 65 20 98.5 0 197 3 45 109 WP_036801903.1 MULTISPECIES: nucleoside-diphosphate kinase [Planococcus] diamond 5454 100 0.998 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus  
28323309 28323309 PRJNA195897_P_NODE_12686_length_162_cov_0.902655_g12653_i0 PRJNA195897 12686 162 0.902655 1.4623011 Clostridiaceae 31979 Bacteria Bacteria 47.8 2.15e-5   NR RXI58444.1 1513 g12653 i0 66.7 1.66666666666667 30 10 55.6 0 2 91 47 76 RXI58444.1 hypothetical protein DP131_00720 [Clostridium tetani] diamond 270 48.1 0.993762993762994 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tetani
28463708 28463708 PRJNA195897_P_NODE_7306_length_185_cov_0.845588_g7273_i0 PRJNA195897 7306 185 0.845588 1.5643378 Alicyclobacillus kakegawensis 392012 Bacteria Bacteria 96.3 1.68e-21   NR WP_067932131.1 392012 g7273 i0 60.7 1.97837837837838 61 24 98.9 0 183 1 313 373 WP_067932131.1 glycoside hydrolase family 30 protein [Alicyclobacillus kakegawensis] diamond 366 96.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Alicyclobacillus Alicyclobacillus kakegawensis
29333839 29333839 PRJNA195897_P_NODE_2029_length_359_cov_1.845161_g1996_i0 PRJNA195897 2029 359 1.845161 6.62412799 root 1 Root_unresolved Root_unresolved 97.4 4.1699999999999996e-24   NR WP_369599335.1 1590 g1996 i0 91.3 85.6963788300836 46 4 38.4 0 357 220 14 59 WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 30765 97.8 0.995910020449898 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29523266 29523266 PRJNA195897_P_NODE_2530_length_315_cov_1.770677_g2497_i0 PRJNA195897 2530 315 1.770677 5.57763255 Acetivibrio 35829 Bacteria Bacteria 53.9 1.07e-5   NR WP_038290891.1 253314 g2497 i0 31.8 1.67619047619048 88 57 83.8 1 11 274 1705 1789 WP_038290891.1 S8 family serine peptidase [Acetivibrio straminisolvens] diamond 528 53.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Acetivibrio Acetivibrio straminisolvens
29820980 29820980 PRJNA195897_P_NODE_1471_length_435_cov_1.305699_g1438_i0 PRJNA195897 1471 435 1.305699 5.67979065 Bacillus thuringiensis 1428 Bacteria Bacteria 42.7 0.03   NR MRA76181.1 1428 g1438 i0 40.4 0.358620689655172 52 31 35.9 0 193 348 20 71 MRA76181.1 hypothetical protein [Bacillus thuringiensis] diamond 156 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
30136757 30136757 PRJNA195897_P_NODE_5892_length_201_cov_1.546053_g5859_i0 PRJNA195897 5892 201 1.546053 3.10756653 Ruminococcus sp. 41978 Bacteria Bacteria 67 2.78e-11   NR MBQ6180627.1 41978 g5859 i0 55.2 12.5970149253731 58 25 86.6 1 178 5 4 60 MBQ6180627.1 methyltransferase domain-containing protein [Ruminococcus sp.] diamond 2532 67 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30534010 30534010 PRJNA195897_P_NODE_3413_length_263_cov_1.700935_g3380_i0 PRJNA195897 3413 263 1.700935 4.47345905 Paenibacillaceae 186822 Bacteria Bacteria 110 4.17e-29   NR WP_204516782.1 1125967 g3380 i0 68.5 4.17490494296578 73 23 83.3 0 223 5 2 74 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 1098 111 0.990990990990991 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
30691976 30691976 PRJNA195897_P_NODE_12733_length_160_cov_2.342342_g12700_i0 PRJNA195897 12733 160 2.342342 3.7477472 Bacteria 2 Bacteria Bacteria 74.7 6.16e-14   NR MDR3288635.1 2052179 g12700 i0 65.4 3.80625 52 18 97.5 0 3 158 242 293 MDR3288635.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Peptococcaceae bacterium] diamond 609 75.1 0.994673768308922 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae   Peptococcaceae bacterium
30913368 30913368 PRJNA195897_P_NODE_3834_length_246_cov_1.319797_g3801_i0 PRJNA195897 3834 246 1.319797 3.24670062 root 1 Root_unresolved Root_unresolved 62.4 7.14e-11   NR WP_369599335.1 1590 g3801 i0 100 75.890243902439 27 0 32.9 0 6 86 33 59 WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 18669 62.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30913369 30913369 PRJNA195897_P_NODE_4034_length_238_cov_3.137566_g4001_i0 PRJNA195897 4034 238 3.137566 7.46740708 root 1 Root_unresolved Root_unresolved 61.6 3.73e-9   NR WP_016820924.1 44249 g4001 i0 61.1 5.38235294117647 54 20 68.1 1 52 213 1 53 WP_016820924.1 MULTISPECIES: SDR family oxidoreductase [Paenibacillus] diamond 1281 62 0.993548387096774 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus  
30927230 30927230 PRJNA195897_P_NODE_3414_length_263_cov_1.696262_g3381_i0 PRJNA195897 3414 263 1.696262 4.46116906 Solobacterium sp. 2060878 Bacteria Bacteria 66.2 2.53e-10   NR MBR3364292.1 2060878 g3381 i0 48.5 1.50570342205323 66 34 75.3 0 202 5 204 269 MBR3364292.1 family 16 glycosylhydrolase [Solobacterium sp.] diamond 396 66.2 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Solobacterium Solobacterium sp.
31323978 31323978 PRJNA195897_P_NODE_11675_length_164_cov_0.904348_g11642_i0 PRJNA195897 11675 164 0.904348 1.48313072 Bacteria 2 Bacteria Bacteria 80.5 6.26e-16   NR NMC31602.1 2049049 g11642 i0 70.8 4.40853658536585 48 14 87.8 0 145 2 572 619 NMC31602.1 transketolase [Veillonellaceae bacterium] diamond 723 80.5 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae   Veillonellaceae bacterium
31355847 31355847 PRJNA195897_P_NODE_9316_length_168_cov_1.882353_g9283_i0 PRJNA195897 9316 168 1.882353 3.16235304 root 1 Root_unresolved Root_unresolved 61.6 1.32e-10   NR MRC56834.1 1428 g9283 i0 56.6 2.91071428571429 53 23 94.6 0 9 167 18 70 MRC56834.1 hypothetical protein [Bacillus thuringiensis] diamond 489 61.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
31735103 31735103 PRJNA195897_P_NODE_11737_length_163_cov_1.807018_g11704_i0 PRJNA195897 11737 163 1.807018 2.94543934 root 1 Root_unresolved Root_unresolved 55.8 6.6e-8   NR WP_229295436.1 1311 g11704 i0 62 16.6932515337423 50 17 88.3 2 144 1 6 55 WP_229295436.1 ubiquitin-like protein, partial [Streptococcus agalactiae] diamond 2721 55.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
31829939 31829939 PRJNA195897_P_NODE_3157_length_276_cov_1.475771_g3124_i0 PRJNA195897 3157 276 1.475771 4.07312796 Bacteria 2 Bacteria Bacteria 88.2 3.32e-20   NR WP_229725710.1 373054 g3124 i0 45.5 4.77173913043478 88 48 95.7 0 11 274 5 92 WP_229725710.1 group I truncated hemoglobin [Calditerricola satsumensis] diamond 1317 88.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Calditerricola Calditerricola satsumensis
31924984 31924984 PRJNA195897_P_NODE_11137_length_165_cov_0.896552_g11104_i0 PRJNA195897 11137 165 0.896552 1.4793108 Peptoniphilus 162289 Bacteria Bacteria 104 1.88e-24   NR WP_307495097.1 507751 g11104 i0 100 1.96363636363636 54 0 98.2 0 164 3 1945 1998 WP_307495097.1 S-layer homology domain-containing protein [Peptoniphilus koenoeneniae] diamond 324 104 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus koenoeneniae

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