RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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

  • PRJNA1195551 · 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
11801124 11801124 PRJNA1195551_S_NODE_35810_length_170_cov_5.818182_g35457_i0 PRJNA1195551 35810 170 5.818182 9.8909094 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 108 3.9e-26   NR GKH46160.1 2485925 g35457 i0 89.1 0.970588235294118 55 6 97.1 0 4 168 83 137 GKH46160.1 hypothetical protein CE91St45_07220 [Oscillospiraceae bacterium] diamond 165 108 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
26723804 26723804 PRJNA1195551_S_NODE_41861_length_159_cov_3.309091_g41508_i0 PRJNA1195551 41861 159 3.309091 5.26145469 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 39.3 0.0455   NR MBR5381399.1 2485925 g41508 i0 45.9 0.69811320754717 37 19 67.9 1 50 157 17 53 MBR5381399.1 hypothetical protein [Oscillospiraceae bacterium] diamond 111 39.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27262211 27262211 PRJNA1195551_S_NODE_15463_length_250_cov_1.293532_g15110_i0 PRJNA1195551 15463 250 1.293532 3.23383 Gemella haemolysans 1379 Bacteria Bacteria 156 5.0799999999999996e-42   NR WP_304096177.1 1379 g15110 i0 97.4 0.936 78 2 93.6 0 236 3 319 396 WP_304096177.1 DUF1542 domain-containing protein, partial [Gemella haemolysans] diamond 234 156 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
27325349 27325349 PRJNA1195551_S_NODE_21323_length_217_cov_4.136905_g20970_i0 PRJNA1195551 21323 217 4.136905 8.97708385 Mogibacterium sp. 2049035 Bacteria Bacteria 116 1e-30   NR MBR0307923.1 2049035 g20970 i0 77.5 0.981566820276498 71 16 98.2 0 213 1 54 124 MBR0307923.1 macro domain-containing protein [Mogibacterium sp.] diamond 213 116 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae Mogibacterium Mogibacterium sp.
28020162 28020162 PRJNA1195551_S_NODE_21645_length_216_cov_2.179641_g21292_i0 PRJNA1195551 21645 216 2.179641 4.70802456 Anaerococcus 165779 Bacteria Bacteria 136 3.51e-36   NR WP_117520670.1 165779 g21292 i0 98.6 1.97222222222222 71 1 98.6 0 215 3 192 262 WP_117520670.1 MULTISPECIES: transcription termination factor NusA [Anaerococcus] diamond 426 136 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus  
28146501 28146501 PRJNA1195551_S_NODE_16705_length_241_cov_20.395833_g16352_i0 PRJNA1195551 16705 241 20.395833 49.15395753 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 42.7 0.0366   NR MEA5061696.1 2049044 g16352 i0 33.8 0.846473029045643 68 38 78.4 2 4 192 183 248 MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium] diamond 204 42.7 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
28177637 28177637 PRJNA1195551_S_NODE_9906_length_296_cov_4.623482_g9553_i0 PRJNA1195551 9906 296 4.623482 13.68550672 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 181 4.889999999999999e-55   NR MEE1164214.1 1898203 g9553 i0 89.8 0.993243243243243 98 10 99.3 0 296 3 130 227 MEE1164214.1 tail fiber domain-containing protein [Lachnospiraceae bacterium] diamond 294 181 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28462270 28462270 PRJNA1195551_S_NODE_33606_length_175_cov_4.769841_g33253_i0 PRJNA1195551 33606 175 4.769841 8.34722175 Clostridiales bacterium 1898207 Bacteria Bacteria 41.6 0.0393   NR NLE68665.1 1898207 g33253 i0 51.4 0.634285714285714 37 15 63.4 1 31 141 97 130 NLE68665.1 hypothetical protein [Clostridiales bacterium] diamond 111 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28588519 28588519 PRJNA1195551_S_NODE_42207_length_158_cov_3.770642_g41854_i0 PRJNA1195551 42207 158 3.770642 5.95761436 Blautia sp. CAG:257 1262756 Bacteria Bacteria 41.2 0.0395   NR WP_022068475.1 1262756 g41854 i0 52.9 0.645569620253165 34 16 64.6 0 13 114 105 138 WP_022068475.1 tRNA (N6-threonylcarbamoyladenosine(37)-N6)-methyltransferase TrmO [Blautia sp. CAG:257] diamond 102 41.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia sp. CAG:257
28746202 28746202 PRJNA1195551_S_NODE_27807_length_192_cov_1.454545_g27454_i0 PRJNA1195551 27807 192 1.454545 2.7927264 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 82.4 2.53e-18   NR WP_297281722.1 293428 g27454 i0 69.4 0.96875 62 19 96.9 0 187 2 1 62 WP_297281722.1 YbgA family protein [uncultured Anaerococcus sp.] diamond 186 82.4 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
28809037 28809037 PRJNA1195551_S_NODE_18368_length_232_cov_2.546448_g18015_i0 PRJNA1195551 18368 232 2.546448 5.90775936 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 42.7 0.0134   NR PWM72267.1 2485925 g18015 i0 43.8 0.620689655172414 48 25 62.1 1 13 156 80 125 PWM72267.1 MAG: hypothetical protein DBX45_09220 [Oscillospiraceae bacterium] diamond 144 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28903858 28903858 PRJNA1195551_S_NODE_20408_length_221_cov_6.732558_g20055_i0 PRJNA1195551 20408 221 6.732558 14.87895318 Atopostipes sp. 1872652 Bacteria Bacteria 106 2.57e-28   NR HZK47593.1 1872652 g20055 i0 98.1 0.719457013574661 53 1 71.9 0 2 160 26 78 HZK47593.1 DUF2922 domain-containing protein [Atopostipes sp.] diamond 159 106 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes sp.
29219979 29219979 PRJNA1195551_S_NODE_26909_length_195_cov_1.780822_g26556_i0 PRJNA1195551 26909 195 1.780822 3.4726029 Ligaoa zhengdingensis 2763658 Bacteria Bacteria 42.7 0.0176   NR WP_249283445.1 2763658 g26556 i0 36.2 1.06153846153846 69 29 93.8 2 5 187 20 81 WP_249283445.1 putative ABC transporter permease [Ligaoa zhengdingensis] diamond 207 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ligaoa Ligaoa zhengdingensis
29301983 29301983 PRJNA1195551_S_NODE_5029_length_384_cov_4.564179_g4676_i0 PRJNA1195551 5029 384 4.564179 17.52644736 Bacillaceae 186817 Bacteria Bacteria 186 8.929999999999999e-56   NR WP_035178386.1 246272 g4676 i0 77.4 4.140625 106 24 82.8 0 319 2 196 301 WP_035178386.1 VanW family protein [Alkalihalobacterium bogoriense] diamond 1590 187 0.994652406417112 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacterium Alkalihalobacterium bogoriense
29472122 29472122 PRJNA1195551_S_NODE_18930_length_229_cov_2.222222_g18577_i0 PRJNA1195551 18930 229 2.222222 5.08888838 Streptococcus mitis 28037 Bacteria Bacteria 95.1 1.3700000000000002e-21   NR WP_414339826.1 28037 g18577 i0 76.3 2.84279475982533 76 18 99.6 0 229 2 14 89 WP_414339826.1 DUF1542 domain-containing protein, partial [Streptococcus mitis] diamond 651 95.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
29819520 29819520 PRJNA1195551_S_NODE_20951_length_219_cov_1.711765_g20598_i0 PRJNA1195551 20951 219 1.711765 3.74876535 Siminovitchia terrae 1914933 Bacteria Bacteria 42.4 0.0283   NR WP_213020544.1 1914933 g20598 i0 44.7 0.643835616438356 47 25 64.4 1 34 174 33 78 WP_213020544.1 sigma-70 family RNA polymerase sigma factor [Siminovitchia terrae] diamond 141 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Siminovitchia Siminovitchia terrae
29965110 29965110 PRJNA1195551_S_NODE_16031_length_246_cov_2.639594_g15678_i0 PRJNA1195551 16031 246 2.639594 6.49340124 FCB group 1783270 Bacteria Bacteria 86.3 1.42e-17   NR WP_031263556.1 33018 g15678 i0 52.6 23.1463414634146 76 36 92.7 0 246 19 282 357 WP_031263556.1 NADP-dependent isocitrate dehydrogenase [Sporolactobacillus laevolacticus] diamond 5694 87 0.991954022988506 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus laevolacticus
31304713 31304713 PRJNA1195551_S_NODE_10875_length_286_cov_3.417722_g10522_i0 PRJNA1195551 10875 286 3.417722 9.77468492 Clostridia bacterium 2044939 Bacteria Bacteria 78.6 1e-14   NR MBQ6789641.1 2044939 g10522 i0 93 0.451048951048951 43 3 45.1 0 180 52 51 93 MBQ6789641.1 phenylalanine--tRNA ligase subunit alpha [Clostridia bacterium] diamond 129 78.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31399847 31399847 PRJNA1195551_S_NODE_39376_length_164_cov_2.234783_g39023_i0 PRJNA1195551 39376 164 2.234783 3.66504412 [Clostridium] innocuum 1522 Bacteria Bacteria 43.1 0.00924   NR WP_233106945.1 1522 g39023 i0 45.5 0.804878048780488 44 22 80.5 1 30 161 69 110 WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum] diamond 132 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
31608436 31608436 PRJNA1195551_S_NODE_10076_length_294_cov_6.404082_g9723_i0 PRJNA1195551 10076 294 6.404082 18.82800108 root 1 Root_unresolved Root_unresolved 68.6 4.88e-11   NR WP_330942626.1 1328 g9723 i0 37.5 1.63265306122449 80 45 76.5 2 247 23 251 330 WP_330942626.1 hypothetical protein [Streptococcus anginosus] diamond 480 68.9 0.995645863570392 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus anginosus
32032376 32032376 PRJNA1195551_S_NODE_22318_length_213_cov_1.902439_g21965_i0 PRJNA1195551 22318 213 1.902439 4.05219507 Anaerococcus nagyae 1755241 Bacteria Bacteria 88.6 1.49e-19   NR WP_117520402.1 1755241 g21965 i0 100 0.605633802816901 43 0 60.6 0 212 84 192 234 WP_117520402.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Anaerococcus nagyae] diamond 129 88.6 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus nagyae

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