RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA738523 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
22875214 22875214 PRJNA738523_P_NODE_8798_length_266_cov_1.735751_g8727_i0 PRJNA738523 8798 266 1.735751 4.61709766 Bacteria 2 Bacteria Bacteria 180 4.93e-57   NR MBN9940364.1 1639 g8727 i0 97.7 1.98496240601504 88 2 99.2 0 266 3 3 90 MBN9940364.1 hypothetical protein [Listeria monocytogenes] diamond 528 180 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
26682673 26682673 PRJNA738523_P_NODE_8101_length_273_cov_1.520000_g8030_i0 PRJNA738523 8101 273 1.52 4.1496 Bacillota 1239 Bacteria Bacteria 84.7 9.12e-17   NR WP_248891511.1 1471 g8030 i0 84.3 2.21978021978022 51 8 56 0 271 119 507 557 WP_248891511.1 tail fiber protein [Bacillus methanolicus] diamond 606 84.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus methanolicus
26799258 26799258 PRJNA738523_P_NODE_8281_length_271_cov_1.555556_g8210_i0 PRJNA738523 8281 271 1.555556 4.21555676 Neobacillus cucumis 1740721 Bacteria Bacteria 70.9 3.88e-13   NR WP_378575637.1 1740721 g8210 i0 64 0.952029520295203 86 30 95.2 1 261 4 15 99 WP_378575637.1 hypothetical protein, partial [Neobacillus cucumis] diamond 258 70.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
26925914 26925914 PRJNA738523_P_NODE_15282_length_242_cov_1.621302_g15211_i0 PRJNA738523 15282 242 1.621302 3.92355084 Ruminococcus sp. 41978 Bacteria Bacteria 42 0.0195   NR MBQ8904807.1 41978 g15211 i0 51.3 0.483471074380165 39 18 47.1 1 61 174 42 80 MBQ8904807.1 hypothetical protein [Ruminococcus sp.] diamond 117 42 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
27188896 27188896 PRJNA738523_P_NODE_3362_length_368_cov_0.857627_g3291_i0 PRJNA738523 3362 368 0.857627 3.15606736 Streptococcus 1301 Bacteria Bacteria 136 9.969999999999999e-35   NR WP_239110322.1 1334 g3291 i0 49.3 2.25 138 54 99.5 1 1 366 350 487 WP_239110322.1 A17 family peptidase, partial [Streptococcus dysgalactiae] diamond 828 136 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27220398 27220398 PRJNA738523_P_NODE_10082_length_254_cov_2.127072_g10011_i0 PRJNA738523 10082 254 2.127072 5.40276288 Clostridium 1485 Bacteria Bacteria 85.9 3.48e-20   NR NLB20714.1 1506 g10011 i0 74.5 3.2007874015748 47 12 55.5 0 183 43 1 47 NLB20714.1 cytochrome C551 [Clostridium sp.] diamond 813 85.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
27305476 27305476 PRJNA738523_P_NODE_4883_length_322_cov_1.108434_g4812_i0 PRJNA738523 4883 322 1.108434 3.56915748 Streptococcus dysgalactiae 1334 Bacteria Bacteria 182 4.7e-53   NR WP_204107520.1 1334 g4812 i0 82.1 0.987577639751553 106 19 98.8 0 322 5 161 266 WP_204107520.1 reverse transcriptase domain-containing protein [Streptococcus dysgalactiae] diamond 318 182 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27652881 27652881 PRJNA738523_P_NODE_15764_length_242_cov_0.911243_g15693_i0 PRJNA738523 15764 242 0.911243 2.20520806 Clostridia bacterium 2044939 Bacteria Bacteria 117 1.7699999999999999e-28   NR MBR3672723.1 2044939 g15693 i0 65 5.97520661157025 80 28 99.2 0 1 240 31 110 MBR3672723.1 V-type ATPase subunit A [Clostridia bacterium] diamond 1446 117 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27883862 27883862 PRJNA738523_P_NODE_10805_length_251_cov_0.865169_g10734_i0 PRJNA738523 10805 251 0.865169 2.17157419 PVC group 1783257 Bacteria Bacteria 85.9 4.68e-18   NR WP_204819836.1 206163 g10734 i0 48.8 2.90438247011952 84 42 99.2 1 251 3 172 255 WP_204819836.1 sugar phosphate isomerase/epimerase family protein [Paenibacillus mendelii] diamond 729 86.3 0.995365005793743 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus mendelii
28158174 28158174 PRJNA738523_P_NODE_15265_length_242_cov_1.822485_g15194_i0 PRJNA738523 15265 242 1.822485 4.4104137 Streptococcus dysgalactiae 1334 Bacteria Bacteria 96.7 3.91e-21   NR MBM6549257.1 119602 g15194 i0 58.8 0.991735537190083 80 33 99.2 0 241 2 725 804 MBM6549257.1 hypothetical protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 240 96.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
28168128 28168128 PRJNA738523_P_NODE_8745_length_267_cov_1.283505_g8674_i0 PRJNA738523 8745 267 1.283505 3.42695835 Streptococcus 1301 Bacteria Bacteria 92.8 1.21e-19   NR WP_239110322.1 1334 g8674 i0 49.4 2 89 45 100 0 1 267 232 320 WP_239110322.1 A17 family peptidase, partial [Streptococcus dysgalactiae] diamond 534 92.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
28220918 28220918 PRJNA738523_P_NODE_7786_length_276_cov_1.482759_g7715_i0 PRJNA738523 7786 276 1.482759 4.09241484 Caldifermentibacillus hisashii 996558 Bacteria Bacteria 87 4.35e-20   NR WP_342021003.1 996558 g7715 i0 100 0.456521739130435 42 0 45.7 0 276 151 48 89 WP_342021003.1 hypothetical protein [Caldifermentibacillus hisashii] diamond 126 87 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Caldifermentibacillus Caldifermentibacillus hisashii
28505193 28505193 PRJNA738523_P_NODE_15327_length_242_cov_0.911243_g15256_i0 PRJNA738523 15327 242 0.911243 2.20520806 Clostridiales bacterium 1898207 Bacteria Bacteria 49.7 1.78e-5   NR MBE5757402.1 1898207 g15256 i0 32.4 0.84297520661157 68 46 84.3 0 24 227 12 79 MBE5757402.1 thioredoxin [Clostridiales bacterium] diamond 204 49.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28884053 28884053 PRJNA738523_P_NODE_5068_length_317_cov_1.213115_g4997_i0 PRJNA738523 5068 317 1.213115 3.84557455 Streptococcus dysgalactiae 1334 Bacteria Bacteria 109 3.36e-25   NR WP_204107583.1 1334 g4997 i0 79.6 0.511041009463722 54 11 51.1 0 243 82 322 375 WP_204107583.1 RNase H-like domain-containing protein, partial [Streptococcus dysgalactiae] diamond 162 109 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
28915407 28915407 PRJNA738523_P_NODE_2168_length_440_cov_1.689373_g2097_i0 PRJNA738523 2168 440 1.689373 7.4332412 Streptococcus dysgalactiae 1334 Bacteria Bacteria 116 2.4199999999999998e-27   NR WP_204107570.1 1334 g2097 i0 58.8 0.695454545454545 102 42 69.5 0 310 5 404 505 WP_204107570.1 RNA-directed DNA polymerase, partial [Streptococcus dysgalactiae] diamond 306 116 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
29168486 29168486 PRJNA738523_P_NODE_7909_length_275_cov_1.282178_g7838_i0 PRJNA738523 7909 275 1.282178 3.5259895 Streptococcus dysgalactiae 1334 Bacteria Bacteria 72.8 1.39e-12   NR MBM6549304.1 119602 g7838 i0 42.9 0.992727272727273 91 52 99.3 0 3 275 205 295 MBM6549304.1 reverse transcriptase family protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 273 72.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
29336374 29336374 PRJNA738523_P_NODE_8029_length_274_cov_1.149254_g7958_i0 PRJNA738523 8029 274 1.149254 3.14895596 Bacteria 2 Bacteria Bacteria 47 0.00144   NR MDO4316874.1 1898203 g7958 i0 40.4 3.93065693430657 52 30 55.8 1 10 162 182 233 MDO4316874.1 ribonuclease III [Lachnospiraceae bacterium] diamond 1077 47.4 0.991561181434599 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29515396 29515396 PRJNA738523_P_NODE_14250_length_244_cov_1.573099_g14179_i0 PRJNA738523 14250 244 1.573099 3.83836156 Streptococcus dysgalactiae 1334 Bacteria Bacteria 106 1.16e-24   NR WP_204107583.1 1334 g14179 i0 63 0.995901639344262 81 30 99.6 0 244 2 491 571 WP_204107583.1 RNase H-like domain-containing protein, partial [Streptococcus dysgalactiae] diamond 243 106 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
30021068 30021068 PRJNA738523_P_NODE_11971_length_248_cov_2.394286_g11900_i0 PRJNA738523 11971 248 2.394286 5.93782928 Weizmannia acidilactici 2607726 Bacteria Bacteria 158 1.15e-47   NR WP_151680469.1 2607726 g11900 i0 100 0.991935483870968 82 0 99.2 0 248 3 42 123 WP_151680469.1 phage tail tube protein [Weizmannia acidilactici] diamond 246 158 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Weizmannia acidilactici
30852483 30852483 PRJNA738523_P_NODE_6474_length_289_cov_1.754630_g6403_i0 PRJNA738523 6474 289 1.75463 5.0708807 Bacteria 2 Bacteria Bacteria 140 1.43e-40   NR WP_415410978.1 985762 g6403 i0 97.4 3.23875432525952 78 2 81 0 235 2 1 78 WP_415410978.1 POTRA domain-containing protein, partial [Staphylococcus agnetis] diamond 936 140 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
31032188 31032188 PRJNA738523_P_NODE_12975_length_247_cov_0.885057_g12904_i0 PRJNA738523 12975 247 0.885057 2.18609079 Streptococcus dysgalactiae 1334 Bacteria Bacteria 82.8 1.75e-16   NR WP_204107648.1 1334 g12904 i0 58.6 7.1417004048583 58 24 70.4 0 175 2 26 83 WP_204107648.1 integrase zinc binding domain-containing protein, partial [Streptococcus dysgalactiae] diamond 1764 83.2 0.995192307692308 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
31263337 31263337 PRJNA738523_P_NODE_14415_length_244_cov_0.900585_g14344_i0 PRJNA738523 14415 244 0.900585 2.1974274 Streptococcus 1301 Bacteria Bacteria 95.5 9.87e-21   NR WP_204107535.1 1334 g14344 i0 57.7 2.86475409836066 78 33 95.9 0 5 238 363 440 WP_204107535.1 reverse transcriptase domain-containing protein [Streptococcus dysgalactiae] diamond 699 95.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
31538017 31538017 PRJNA738523_P_NODE_7016_length_284_cov_1.056872_g6945_i0 PRJNA738523 7016 284 1.056872 3.00151648 Neobacillus cucumis 1740721 Bacteria Bacteria 116 2.2799999999999997e-31   NR WP_378575789.1 1740721 g6945 i0 77.9 1.62676056338028 77 17 81.3 0 2 232 45 121 WP_378575789.1 HU family DNA-binding protein, partial [Neobacillus cucumis] diamond 462 116 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
31674359 31674359 PRJNA738523_P_NODE_16257_length_241_cov_0.916667_g16186_i0 PRJNA738523 16257 241 0.916667 2.20916747 Streptococcus 1301 Bacteria Bacteria 52.8 1.09e-5   NR WP_348538379.1 1334 g16186 i0 38.3 2.00414937759336 81 48 99.6 2 241 2 219 298 WP_348538379.1 reverse transcriptase family protein [Streptococcus dysgalactiae] diamond 483 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
31790674 31790674 PRJNA738523_P_NODE_13697_length_245_cov_1.755814_g13626_i0 PRJNA738523 13697 245 1.755814 4.3017443 Neobacillus cucumis 1740721 Bacteria Bacteria 109 9.31e-29   NR WP_378575619.1 1740721 g13626 i0 84.1 1.68979591836735 69 11 84.5 0 9 215 61 129 WP_378575619.1 hypothetical protein [Neobacillus cucumis] diamond 414 109 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
32170746 32170746 PRJNA738523_P_NODE_11038_length_250_cov_0.909605_g10967_i0 PRJNA738523 11038 250 0.909605 2.2740125 Neobacillus cucumis 1740721 Bacteria Bacteria 107 4.44e-28   NR WP_378575789.1 1740721 g10967 i0 77.5 0.852 71 16 85.2 0 248 36 51 121 WP_378575789.1 HU family DNA-binding protein, partial [Neobacillus cucumis] diamond 213 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
32307580 32307580 PRJNA738523_P_NODE_4999_length_319_cov_1.252033_g4928_i0 PRJNA738523 4999 319 1.252033 3.99398527 Bacteria 2 Bacteria Bacteria 125 4.39e-35   NR MBN9993934.1 1639 g4928 i0 100 1.73040752351097 60 0 56.4 0 319 140 17 76 MBN9993934.1 hypothetical protein [Listeria monocytogenes] diamond 552 125 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32654540 32654540 PRJNA738523_P_NODE_10420_length_251_cov_1.691011_g10349_i0 PRJNA738523 10420 251 1.691011 4.24443761 Bacillota 1239 Bacteria Bacteria 72.8 3.4e-13   NR WP_075491360.1 417368 g10349 i0 66.1 3.52589641434263 59 20 70.5 0 2 178 1 59 WP_075491360.1 DeoR/GlpR family DNA-binding transcription regulator [Enterococcus thailandicus] diamond 885 72.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus thailandicus
32833645 32833645 PRJNA738523_P_NODE_13860_length_245_cov_0.895349_g13789_i0 PRJNA738523 13860 245 0.895349 2.19360505 Anaerococcus sp. Marseille-P9784 2614127 Bacteria Bacteria 142 1.68e-37   NR WP_151410426.1 2614127 g13789 i0 96.3 0.991836734693878 81 3 99.2 0 3 245 369 449 WP_151410426.1 PTS fructose transporter subunit IIABC [Anaerococcus sp. Marseille-P9784] diamond 243 142 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp. Marseille-P9784
32896496 32896496 PRJNA738523_P_NODE_14180_length_245_cov_0.866279_g14109_i0 PRJNA738523 14180 245 0.866279 2.12238355 Dialister sp. 1955814 Bacteria Bacteria 169 9.71e-51   NR MFR3115804.1 1955814 g14109 i0 100 0.991836734693878 81 0 99.2 0 2 244 47 127 MFR3115804.1 NAD-dependent protein deacylase [Dialister sp.] diamond 243 169 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Dialister Dialister sp.

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