RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB7366" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7366 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
15437727 15437727 PRJEB7366_P_NODE_16573_length_190_cov_1.806452_g16139_i0 PRJEB7366 16573 190 1.806452 3.4322588 Bacillales 1385 Bacteria Bacteria 86.7 5.89e-18   NR WP_340672963.1 51101 g16139 i0 80.4 7.35789473684211 46 9 72.6 0 190 53 450 495 WP_340672963.1 aldehyde dehydrogenase family protein [Brevibacillus agri] diamond 1398 87 0.996551724137931 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus agri
26812656 26812656 PRJEB7366_P_NODE_11501_length_240_cov_1.756098_g11067_i0 PRJEB7366 11501 240 1.756098 4.2146352 Selenomonadaceae bacterium 2652289 Bacteria Bacteria 94.7 8.45e-22   NR MBR3458837.1 2652289 g11067 i0 53.2 4.9375 79 37 98.8 0 239 3 105 183 MBR3458837.1 TIGR00266 family protein [Selenomonadaceae bacterium] diamond 1185 94.7 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Selenomonadaceae   Selenomonadaceae bacterium
26907571 26907571 PRJEB7366_P_NODE_22302_length_160_cov_0.872000_g21868_i0 PRJEB7366 22302 160 0.872 1.3952 Christensenellaceae bacterium 2054177 Bacteria Bacteria 44.3 0.00345   NR MBR3841983.1 2054177 g21868 i0 46.8 2.86875 47 22 88.1 2 156 16 189 232 MBR3841983.1 GTPase HflX [Christensenellaceae bacterium] diamond 459 44.3 1 Bacteria   Bacillati Bacillota Clostridia Christensenellales Christensenellaceae   Christensenellaceae bacterium
27128523 27128523 PRJEB7366_P_NODE_2382_length_626_cov_136.707276_g2007_i0 PRJEB7366 2382 626 136.707276 855.78754776 Romboutsia sp. 1965302 Bacteria Bacteria 169 1.25e-50   NR MCA9749906.1 1965302 g2007 i0 78.4 0.531948881789137 111 24 53.2 0 352 20 1 111 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 333 169 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
28455529 28455529 PRJEB7366_P_NODE_1646_length_768_cov_6.937244_g1322_i0 PRJEB7366 1646 768 6.937244 53.27803392 Syntrophomonadaceae bacterium 2093811 Bacteria Bacteria 64.7 5.62e-8   NR MBS3977505.1 2093811 g1322 i0 33.3 0.69140625 177 93 63.3 5 702 217 184 350 MBS3977505.1 LysM peptidoglycan-binding domain-containing protein [Syntrophomonadaceae bacterium] diamond 531 64.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae   Syntrophomonadaceae bacterium
28581794 28581794 PRJEB7366_P_NODE_19427_length_173_cov_1.449275_g18993_i0 PRJEB7366 19427 173 1.449275 2.50724575 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 50.4 2.26e-5   NR MBR4812635.1 1898203 g18993 i0 76 0.433526011560694 25 6 43.4 0 87 161 220 244 MBR4812635.1 hypothetical protein [Lachnospiraceae bacterium] diamond 75 50.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29118639 29118639 PRJEB7366_P_NODE_6149_length_357_cov_1.897516_g5716_i0 PRJEB7366 6149 357 1.897516 6.77413212 Tissierellia bacterium 2049431 Bacteria Bacteria 55.5 1.45e-6   NR NLJ99194.1 2049431 g5716 i0 43.9 0.554621848739496 66 35 53.8 1 119 310 67 132 NLJ99194.1 LysM peptidoglycan-binding domain-containing protein [Tissierellia bacterium] diamond 198 55.5 1 Bacteria   Bacillati Bacillota Tissierellia       Tissierellia bacterium
29497276 29497276 PRJEB7366_P_NODE_5290_length_393_cov_2.455307_g4857_i0 PRJEB7366 5290 393 2.455307 9.64935651 Paenibacillus odorifer 189426 Bacteria Bacteria 63.9 3.52e-10   NR WP_111505207.1 189426 g4857 i0 57.1 0.374045801526718 49 21 37.4 0 47 193 2 50 WP_111505207.1 lectin [Paenibacillus odorifer] diamond 147 63.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus odorifer
30034270 30034270 PRJEB7366_P_NODE_24091_length_153_cov_1.016949_g23657_i0 PRJEB7366 24091 153 1.016949 1.55593197 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 40 0.0461   NR HCM13517.1 1898203 g23657 i0 42.6 0.92156862745098 47 24 92.2 1 12 152 14 57 HCM13517.1 peptidase [Lachnospiraceae bacterium] diamond 141 40 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30350626 30350626 PRJEB7366_P_NODE_3172_length_533_cov_2.040161_g2765_i0 PRJEB7366 3172 533 2.040161 10.87405813 Massilistercora timonensis 2086584 Bacteria Bacteria 45.4 0.0174   NR WP_106790073.1 2086584 g2765 i0 41.2 0.287054409005629 51 30 28.7 0 45 197 31 81 WP_106790073.1 DMT family transporter [Massilistercora timonensis] diamond 153 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Massilistercora Massilistercora timonensis
30382116 30382116 PRJEB7366_P_NODE_2053_length_680_cov_1.863566_g1693_i0 PRJEB7366 2053 680 1.863566 12.6722488 Clostridiaceae bacterium 1898204 Bacteria Bacteria 116 6.91e-26   NR NLE26273.1 1898204 g1693 i0 53.5 1.30588235294118 99 46 43.7 0 211 507 496 594 NLE26273.1 phosphoenolpyruvate carboxykinase (GTP) [Clostridiaceae bacterium] diamond 888 116 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
31108241 31108241 PRJEB7366_P_NODE_735_length_1121_cov_3.753223_g538_i0 PRJEB7366 735 1121 3.753223 42.07362983 Desulfotomaculum sp. 41211 Bacteria Bacteria 97.1 3.16e-18   NR MBO8137203.1 41211 g538 i0 26.1 0.952720785013381 356 169 85.6 13 108 1067 71 368 MBO8137203.1 LysM peptidoglycan-binding domain-containing protein [Desulfotomaculum sp.] diamond 1068 97.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfotomaculaceae Desulfotomaculum Desulfotomaculum sp.
31551347 31551347 PRJEB7366_P_NODE_2456_length_617_cov_1.929553_g2074_i0 PRJEB7366 2456 617 1.929553 11.90534201 Ruminococcaceae bacterium OttesenSCG-928-A16 2885180 Bacteria Bacteria 62 2.4e-7   NR MDL2323811.1 2885180 g2074 i0 39 0.846029173419773 82 44 37 1 295 68 415 496 MDL2323811.1 trypsin-like peptidase domain-containing protein [Ruminococcaceae bacterium OttesenSCG-928-A16] diamond 522 62 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Ruminococcaceae bacterium OttesenSCG-928-A16
31891795 31891795 PRJEB7366_P_NODE_18857_length_176_cov_1.418440_g18423_i0 PRJEB7366 18857 176 1.41844 2.4964544 Fictibacillus 1329200 Bacteria Bacteria 58.2 4.54e-9   NR HHY92641.1 1879010 g18423 i0 71.1 6.39204545454545 38 10 64.8 1 116 3 9 45 HHY92641.1 hypothetical protein [Bacillota bacterium] diamond 1125 58.5 0.994871794871795 Bacteria   Bacillati Bacillota         Bacillota bacterium
32120665 32120665 PRJEB7366_P_NODE_17078_length_187_cov_1.052632_g16644_i0 PRJEB7366 17078 187 1.052632 1.96842184 Bacillota bacterium 1879010 Bacteria Bacteria 67.4 4.16e-12   NR MBE3556895.1 1879010 g16644 i0 49.2 2.93582887700535 61 31 97.9 0 186 4 58 118 MBE3556895.1 inorganic diphosphatase [Bacillota bacterium] diamond 549 67.4 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32240118 32240118 PRJEB7366_P_NODE_23718_length_154_cov_1.344538_g23284_i0 PRJEB7366 23718 154 1.344538 2.07058852 Bacteria candidate phyla 1783234 Bacteria Bacteria 44.7 0.00236   NR NLC26468.1 1938886 g23284 i0 39.1 8.47402597402597 46 27 89.6 1 145 8 556 600 NLC26468.1 polyribonucleotide nucleotidyltransferase [Fastidiosipila sp.] diamond 1305 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Fastidiosipila Fastidiosipila sp.
32650497 32650497 PRJEB7366_P_NODE_19020_length_175_cov_1.628571_g18586_i0 PRJEB7366 19020 175 1.628571 2.84999925 Bacilli 91061 Bacteria Bacteria 78.2 4.77e-16   NR WP_328275783.1 59846 g18586 i0 65 13.3714285714286 60 19 99.4 1 175 2 54 113 WP_328275783.1 short chain dehydrogenase [Paenibacillus chibensis] diamond 2340 78.6 0.994910941475827 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus chibensis
32783782 32783782 PRJEB7366_P_NODE_2060_length_678_cov_4.880249_g1700_i0 PRJEB7366 2060 678 4.880249 33.08808822 Bacillota bacterium 1879010 Bacteria Bacteria 57.8 6.54e-6   NR HHY61764.1 1879010 g1700 i0 32.2 0.756637168141593 171 97 68.6 5 576 112 5 172 HHY61764.1 LysM peptidoglycan-binding domain-containing protein [Bacillota bacterium] diamond 513 57.8 1 Bacteria   Bacillati Bacillota         Bacillota bacterium

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