RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA640350" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640350 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
610528 610528 PRJNA640350_P_NODE_38921_length_153_cov_4.322581_g38760_i0 PRJNA640350 38921 153 4.322581 6.61354893 Streptococcus suis 1307 Bacteria Bacteria 98.6 1.94e-25   NR WP_319443961.1 1307 g38760 i0 100 0.980392156862745 50 0 98 0 151 2 2 51 WP_319443961.1 LysR substrate-binding domain-containing protein, partial [Streptococcus suis] diamond 150 98.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
610529 610529 PRJNA640350_P_NODE_39041_length_153_cov_2.693548_g38880_i0 PRJNA640350 39041 153 2.693548 4.12112844 Anaerococcus urinomassiliensis 1745712 Bacteria Bacteria 92.4 2.16e-20   NR WP_073998320.1 1745712 g38880 i0 88 1.90196078431373 50 6 98 0 151 2 208 257 WP_073998320.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Anaerococcus urinomassiliensis] diamond 291 92.4 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus urinomassiliensis
9538974 9538974 PRJNA640350_P_NODE_26288_length_185_cov_1.166667_g26127_i0 PRJNA640350 26288 185 1.166667 2.15833395 Anaerococcus 165779 Bacteria Bacteria 96.3 3.58e-22   NR WP_073998015.1 1745712 g26127 i0 78.7 4.94594594594595 61 13 98.9 0 183 1 151 211 WP_073998015.1 UDP-N-acetylmuramate dehydrogenase [Anaerococcus urinomassiliensis] diamond 915 96.7 0.995863495346432 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus urinomassiliensis
26922864 26922864 PRJNA640350_P_NODE_24702_length_192_cov_1.122699_g24541_i0 PRJNA640350 24702 192 1.122699 2.15558208 Staphylococcus aureus 1280 Bacteria Bacteria 40.4 0.0168   NR WP_348968627.1 1280 g24541 i0 100 0.3125 20 0 31.3 0 131 190 1 20 WP_348968627.1 SDR family NAD(P)-dependent oxidoreductase, partial [Staphylococcus aureus] diamond 60 40.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28439192 28439192 PRJNA640350_P_NODE_31006_length_170_cov_1.539007_g30845_i0 PRJNA640350 31006 170 1.539007 2.6163119 Streptococcus suis 1307 Bacteria Bacteria 57.8 2.86e-9   NR WP_319443993.1 1307 g30845 i0 100 0.494117647058824 28 0 49.4 0 85 168 1 28 WP_319443993.1 alpha/beta fold hydrolase, partial [Streptococcus suis] diamond 84 57.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus suis
28483110 28483110 PRJNA640350_P_NODE_22826_length_202_cov_1.768786_g22665_i0 PRJNA640350 22826 202 1.768786 3.57294772 Bacteria 2 Bacteria Bacteria 126 3.3e-36   NR WP_342899827.1 1293 g22665 i0 100 1.99009900990099 67 0 99.5 0 2 202 16 82 WP_342899827.1 TolC family protein, partial [Staphylococcus gallinarum] diamond 402 126 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus gallinarum
28483111 28483111 PRJNA640350_P_NODE_32026_length_167_cov_2.449275_g31865_i0 PRJNA640350 32026 167 2.449275 4.09028925 Streptococcus 1301 Bacteria Bacteria 106 1.26e-27   NR WP_414323689.1 1318 g31865 i0 100 2.96407185628743 55 0 98.8 0 165 1 24 78 WP_414323689.1 replication initiation protein, partial [Streptococcus parasanguinis] diamond 495 106 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus parasanguinis
28609363 28609363 PRJNA640350_P_NODE_40627_length_151_cov_1.500000_g40466_i0 PRJNA640350 40627 151 1.5 2.265 Bacteria 2 Bacteria Bacteria 103 9.12e-28   NR WP_164305588.1 1313 g40466 i0 100 1.98675496688742 50 0 99.3 0 151 2 19 68 WP_164305588.1 TonB-dependent receptor, partial [Streptococcus pneumoniae] diamond 300 103 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28691852 28691852 PRJNA640350_P_NODE_28507_length_177_cov_1.547297_g28346_i0 PRJNA640350 28507 177 1.547297 2.73871569 Anaerococcus 165779 Bacteria Bacteria 115 5.03e-29   NR WP_288223367.1 165779 g28346 i0 98.3 2.94915254237288 58 1 98.3 0 2 175 104 161 WP_288223367.1 MULTISPECIES: class C sortase [Anaerococcus] diamond 522 115 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus  
28754792 28754792 PRJNA640350_P_NODE_37147_length_157_cov_1.367188_g36986_i0 PRJNA640350 37147 157 1.367188 2.14648516 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 99.4 6.5e-23   NR WP_296112447.1 293428 g36986 i0 84.6 3.97452229299363 52 8 99.4 0 2 157 336 387 WP_296112447.1 DNA polymerase Y family protein [uncultured Anaerococcus sp.] diamond 624 99.4 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
28912380 28912380 PRJNA640350_P_NODE_29548_length_174_cov_0.882759_g29387_i0 PRJNA640350 29548 174 0.882759 1.53600066 Fenollaria timonensis 1723384 Bacteria Bacteria 109 6.41e-28   NR WP_058259828.1 1723384 g29387 i0 98.2 0.982758620689655 57 1 98.3 0 2 172 96 152 WP_058259828.1 trimeric intracellular cation channel family protein [Fenollaria timonensis] diamond 171 109 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Fenollaria Fenollaria timonensis
29083075 29083075 PRJNA640350_P_NODE_5428_length_406_cov_3.148541_g5272_i0 PRJNA640350 5428 406 3.148541 12.78307646 Geobacillus 129337 Bacteria Bacteria 53.9 1.38e-5   NR AZM68782.1 33941 g5272 i0 72.9 0.724137931034483 48 11 35.5 2 68 211 20 65 AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans] diamond 294 53.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus thermoleovorans
29259757 29259757 PRJNA640350_P_NODE_30089_length_172_cov_2.013986_g29928_i0 PRJNA640350 30089 172 2.013986 3.46405592 Clostridia bacterium 2044939 Bacteria Bacteria 48.5 1.27e-4   NR MBQ8109216.1 2044939 g29928 i0 95.5 0.383720930232558 22 1 38.4 0 107 172 1 22 MBQ8109216.1 glycosyltransferase [Clostridia bacterium] diamond 66 48.5 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29335566 29335566 PRJNA640350_P_NODE_26549_length_184_cov_1.077419_g26388_i0 PRJNA640350 26549 184 1.077419 1.98245096 Streptococcus 1301 Bacteria Bacteria 117 8.5e-29   NR WP_247935593.1 28037 g26388 i0 98.3 2.93478260869565 60 1 97.8 0 182 3 1124 1183 WP_247935593.1 Cna B-type domain-containing protein, partial [Streptococcus mitis] diamond 540 117 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
29619309 29619309 PRJNA640350_P_NODE_39990_length_152_cov_1.479675_g39829_i0 PRJNA640350 39990 152 1.479675 2.249106 Bacteria 2 Bacteria Bacteria 107 5.49e-29   NR WP_348968599.1 1280 g39829 i0 100 2.96052631578947 50 0 98.7 0 1 150 39 88 WP_348968599.1 hypothetical protein, partial [Staphylococcus aureus] diamond 450 107 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29670054 29670054 PRJNA640350_P_NODE_39190_length_153_cov_1.983871_g39029_i0 PRJNA640350 39190 153 1.983871 3.03532263 Veillonella sp. CHU11 1926307 Bacteria Bacteria 69.3 2.84e-12   NR WP_127009733.1 2490947 g39029 i0 94.3 0.686274509803922 35 2 68.6 0 1 105 258 292 WP_127009733.1 prephenate dehydrogenase [Veillonella sp. CHU110] diamond 105 69.3 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. CHU110
30649497 30649497 PRJNA640350_P_NODE_19653_length_227_cov_1.782828_g19492_i0 PRJNA640350 19653 227 1.782828 4.04701956 Streptococcus pseudopneumoniae 257758 Bacteria Bacteria 81.6 2.26e-16   NR WP_049524543.1 257758 g19492 i0 71.8 0.9383259911894268 71 19 92.5 1 210 1 1 71 WP_049524543.1 DUF1542 domain-containing protein, partial [Streptococcus pseudopneumoniae] diamond 213 81.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pseudopneumoniae
30997368 30997368 PRJNA640350_P_NODE_38154_length_155_cov_1.460317_g37993_i0 PRJNA640350 38154 155 1.460317 2.26349135 Veillonella sp. CHU732 2490949 Bacteria Bacteria 98.6 4.059999999999999e-23   NR WP_127167034.1 2490949 g37993 i0 88.2 0.987096774193548 51 6 98.7 0 155 3 81 131 WP_127167034.1 2-hydroxyacid dehydrogenase [Veillonella sp. CHU732] diamond 153 98.6 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. CHU732
31768574 31768574 PRJNA640350_P_NODE_38737_length_154_cov_1.472000_g38576_i0 PRJNA640350 38737 154 1.472 2.26688 Fenollaria 1686313 Bacteria Bacteria 102 3.14e-24   NR MFR7871897.1 1723384 g38576 i0 98 1.98701298701299 51 1 99.4 0 154 2 163 213 MFR7871897.1 NAD(P)H-dependent oxidoreductase [Fenollaria timonensis] diamond 306 102 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Fenollaria Fenollaria timonensis
32040967 32040967 PRJNA640350_P_NODE_38558_length_154_cov_2.192000_g38397_i0 PRJNA640350 38558 154 2.192 3.37568 Tissierellia bacterium 2049431 Bacteria Bacteria 73.9 1.02e-13   NR MDO5037813.1 2049431 g38397 i0 66 1.94805194805195 50 17 97.4 0 152 3 193 242 MDO5037813.1 citrate synthase [Tissierellia bacterium] diamond 300 73.9 1 Bacteria   Bacillati Bacillota Tissierellia       Tissierellia bacterium
32053305 32053305 PRJNA640350_P_NODE_14038_length_331_cov_1.463576_g13877_i0 PRJNA640350 14038 331 1.463576 4.84443656 Solobacterium 123375 Bacteria Bacteria 44.3 0.0286   NR WP_314231708.1 102148 g13877 i0 88 1.13293051359517 25 3 22.7 0 257 331 18 42 WP_314231708.1 MBOAT family O-acyltransferase [Solobacterium moorei] diamond 375 44.3 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Solobacterium Solobacterium moorei
32230974 32230974 PRJNA640350_P_NODE_28938_length_175_cov_3.445205_g28777_i0 PRJNA640350 28938 175 3.445205 6.02910875 Streptococcus mitis 28037 Bacteria Bacteria 115 4.82e-28   NR WP_414362133.1 28037 g28777 i0 100 0.977142857142857 57 0 97.7 0 3 173 2523 2579 WP_414362133.1 Rib/alpha-like domain-containing protein, partial [Streptococcus mitis] diamond 171 115 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
32306810 32306810 PRJNA640350_P_NODE_33019_length_165_cov_1.345588_g32858_i0 PRJNA640350 33019 165 1.345588 2.2202202 Anaerococcus 165779 Bacteria Bacteria 55.8 3e-7   NR WP_117522019.1 165779 g32858 i0 90 1.63636363636364 30 3 54.5 0 2 91 410 439 WP_117522019.1 MULTISPECIES: NCS2 family permease [Anaerococcus] diamond 270 56.2 0.99288256227758 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus  

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