RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA591000 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
26731120 26731120 PRJNA591000_P_NODE_4561_length_688_cov_20.083460_g3610_i0 PRJNA591000 4561 688 20.08346 138.1742048 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 52.8 2.82e-4   NR MBE6124668.1 2049044 g3610 i0 61 0.178779069767442 41 16 17.9 0 211 89 98 138 MBE6124668.1 collagen-like protein [Erysipelotrichaceae bacterium] diamond 123 52.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
26763167 26763167 PRJNA591000_P_NODE_6161_length_576_cov_9.588665_g4868_i0 PRJNA591000 6161 576 9.588665 55.2307104 Alicyclobacillus sp. 61169 Bacteria Bacteria 62.8 1.92e-9   NR MCL6442060.1 61169 g4868 i0 84.6 0.614583333333333 39 6 20.3 0 172 288 37 75 MCL6442060.1 hypothetical protein [Alicyclobacillus sp.] diamond 354 62.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Alicyclobacillus Alicyclobacillus sp.
26858562 26858562 PRJNA591000_P_NODE_1001_length_1136_cov_8.589883_g689_i0 PRJNA591000 1001 1136 8.589883 97.58107088 Bacilli bacterium 1903720 Bacteria Bacteria 83.2 3.13e-14   NR MFA5407860.1 1903720 g689 i0 45.9 0.287852112676056 109 56 28.5 3 745 1068 16 122 MFA5407860.1 hypothetical protein [Bacilli bacterium] diamond 327 83.2 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27029876 27029876 PRJNA591000_P_NODE_6982_length_531_cov_4.077689_g5572_i0 PRJNA591000 6982 531 4.077689 21.65252859 Bacteria 2 Bacteria Bacteria 47.4 0.00624   NR OUK26017.1 1352 g5572 i0 50 2.80225988700565 40 20 22.6 0 460 341 147 186 OUK26017.1 peptide ABC transporter permease, partial [Enterococcus faecium] diamond 1488 47.8 0.99163179916318 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
28121976 28121976 PRJNA591000_P_NODE_6885_length_535_cov_2.737154_g5486_i0 PRJNA591000 6885 535 2.737154 14.6437739 Streptococcus pneumoniae 1313 Bacteria Bacteria 110 4.74e-28   NR MBZ4299771.1 1313 g5486 i0 100 0.308411214953271 55 0 30.8 0 534 370 21 75 MBZ4299771.1 hypothetical protein [Streptococcus pneumoniae] diamond 165 110 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28279622 28279622 PRJNA591000_P_NODE_3346_length_770_cov_1.357625_g2593_i0 PRJNA591000 3346 770 1.357625 10.4537125 Clostridium sp. 1506 Bacteria Bacteria 62 6.16e-7   NR NLB20595.1 1506 g2593 i0 44.8 0.662337662337662 58 30 22.6 1 1 174 439 494 NLB20595.1 chaperonin GroEL [Clostridium sp.] diamond 510 62 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
28311486 28311486 PRJNA591000_P_NODE_5586_length_616_cov_4.126065_g4404_i0 PRJNA591000 5586 616 4.126065 25.4165604 Staphylococcus pasteuri_A 3062664 Bacteria Bacteria 151 5.36e-44   NR WP_303522823.1 3062664 g4404 i0 96.2 0.37987012987013 78 3 38 0 341 108 1 78 WP_303522823.1 hypothetical protein, partial [Staphylococcus pasteuri_A] diamond 234 151 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pasteuri_A
28342984 28342984 PRJNA591000_P_NODE_13646_length_399_cov_0.972973_g12054_i0 PRJNA591000 13646 399 0.972973 3.88216227 Streptococcus pneumoniae 1313 Bacteria Bacteria 50.1 5.18e-5   NR WP_196302640.1 1313 g12054 i0 85.3 0.255639097744361 34 5 25.6 0 290 391 51 84 WP_196302640.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 102 50.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28406183 28406183 PRJNA591000_P_NODE_11666_length_421_cov_3.239796_g10083_i0 PRJNA591000 11666 421 3.239796 13.63954116 Parvimonas sp. M13 3110694 Bacteria Bacteria 43.5 0.0236   NR WP_324000490.1 3110694 g10083 i0 56.3 0.228028503562945 32 14 22.8 0 134 39 55 86 WP_324000490.1 endonuclease domain-containing protein, partial [Parvimonas sp. M13] diamond 96 43.5 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Parvimonas Parvimonas sp. M13
28609055 28609055 PRJNA591000_P_NODE_2247_length_875_cov_3.514184_g1669_i0 PRJNA591000 2247 875 3.514184 30.74911 Bacillati 1783272 Bacteria Bacteria 102 6.01e-22   NR MFG6369490.1 1898203 g1669 i0 42.5 0.857142857142857 146 74 47 4 712 302 19 163 MFG6369490.1 DNA adenine methylase [Lachnospiraceae bacterium] diamond 750 102 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28816324 28816324 PRJNA591000_P_NODE_16108_length_179_cov_2.173333_g14502_i0 PRJNA591000 16108 179 2.173333 3.89026607 Streptococcus pneumoniae 1313 Bacteria Bacteria 68.6 8.91e-14   NR MTW25846.1 1313 g14502 i0 100 0.603351955307263 36 0 60.3 0 108 1 1 36 MTW25846.1 hypothetical protein [Streptococcus pneumoniae] diamond 108 68.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29006459 29006459 PRJNA591000_P_NODE_2428_length_853_cov_10.111650_g1817_i0 PRJNA591000 2428 853 10.11165 86.2523745 Bacillota bacterium 1879010 Bacteria Bacteria 125 2.13e-28   NR MDO9535090.1 1879010 g1817 i0 59.1 0.446658851113716 127 50 44.7 1 782 402 247 371 MDO9535090.1 hypothetical protein [Bacillota bacterium] diamond 381 125 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29132483 29132483 PRJNA591000_P_NODE_4689_length_679_cov_5.349231_g3709_i0 PRJNA591000 4689 679 5.349231 36.32127849 Virgibacillus natechei 1216297 Bacteria Bacteria 47.4 0.00623   NR WP_264917277.1 1216297 g3709 i0 31.5 0.54786450662739306 124 72 51.7 3 633 283 13 130 WP_264917277.1 DUF5082 domain-containing protein [Virgibacillus natechei] diamond 372 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus natechei
29227289 29227289 PRJNA591000_P_NODE_5189_length_646_cov_3.719611_g4087_i0 PRJNA591000 5189 646 3.719611 24.02868706 Solibacillus kalamii 1748298 Bacteria Bacteria 106 2.98e-24   NR WP_087616020.1 1748298 g4087 i0 39.8 1.0030959752322 216 108 94.7 10 617 6 5 210 WP_087616020.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Solibacillus kalamii] diamond 648 106 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Solibacillus Solibacillus kalamii
29732018 29732018 PRJNA591000_P_NODE_6350_length_565_cov_3.559701_g5025_i0 PRJNA591000 6350 565 3.559701 20.11231065 Veillonella sp. 1926307 Bacteria Bacteria 55.5 3.17e-6   NR WP_295194076.1 1926307 g5025 i0 32.5 0.653097345132743 123 76 61.6 4 164 511 1 123 WP_295194076.1 hypothetical protein [Veillonella sp.] diamond 369 55.5 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp.
29953341 29953341 PRJNA591000_P_NODE_3871_length_732_cov_2.045519_g3035_i0 PRJNA591000 3871 732 2.045519 14.97319908 Saccharofermentanales bacterium 3107571 Bacteria Bacteria 77.8 5e-14   NR MFA5585532.1 3107571 g3035 i0 67.3 0.631147540983607 49 16 20.1 0 597 451 85 133 MFA5585532.1 hypothetical protein [Saccharofermentanales bacterium] diamond 462 77.8 1 Bacteria   Bacillati Bacillota Clostridia Saccharofermentanales     Saccharofermentanales bacterium
30047893 30047893 PRJNA591000_P_NODE_15831_length_203_cov_1.706897_g14225_i0 PRJNA591000 15831 203 1.706897 3.46500091 Streptococcus pneumoniae 1313 Bacteria Bacteria 75.9 3.14e-16   NR WP_155443339.1 1313 g14225 i0 86.4 0.650246305418719 44 6 65 0 200 69 35 78 WP_155443339.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 132 75.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
30124535 30124535 PRJNA591000_P_NODE_7332_length_516_cov_2.529774_g5881_i0 PRJNA591000 7332 516 2.529774 13.05363384 FCB group 1783270 Bacteria Bacteria 45.8 0.038   NR WP_307776693.1 69966 g5881 i0 25.5 1.86627906976744 137 83 79.7 2 14 424 301 418 WP_307776693.1 phage terminase large subunit [Macrococcoides caseolyticum] diamond 963 45.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcoides Macrococcoides caseolyticum
30535470 30535470 PRJNA591000_P_NODE_9193_length_461_cov_1.224537_g7646_i0 PRJNA591000 9193 461 1.224537 5.64511557 Lachnospiraceae 186803 Bacteria Bacteria 93.6 1.74e-19   NR HIX15249.1 2838620 g7646 i0 75 1.09327548806941 56 14 36.4 0 170 3 55 110 HIX15249.1 hypothetical protein [Candidatus Hungatella pullicola] diamond 504 93.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Hungatella Candidatus Hungatella pullicola
30743180 30743180 PRJNA591000_P_NODE_16194_length_173_cov_5.812500_g14588_i0 PRJNA591000 16194 173 5.8125 10.055625 Eubacteriales bacterium 2831996 Bacteria Bacteria 74.7 1.63e-14   NR MDO5361945.1 2831996 g14588 i0 60.4 0.919075144508671 53 21 91.9 0 171 13 102 154 MDO5361945.1 hypothetical protein [Eubacteriales bacterium] diamond 159 74.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
31090744 31090744 PRJNA591000_P_NODE_5415_length_630_cov_1.846922_g4266_i0 PRJNA591000 5415 630 1.846922 11.6356086 Streptococcus pneumoniae 1313 Bacteria Bacteria 107 1.6e-26   NR WP_196300888.1 1313 g4266 i0 100 0.261904761904762 55 0 26.2 0 173 9 1 55 WP_196300888.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 165 107 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31185253 31185253 PRJNA591000_P_NODE_6575_length_551_cov_4.796935_g5212_i0 PRJNA591000 6575 551 4.796935 26.43111185 Paenibacillus sp. FSL W8- 58172 Bacteria Bacteria 85.5 6.1e-18   NR WP_339273797.1 2921714 g5212 i0 51.9 0.833030852994555 77 34 40.3 1 226 5 2 78 WP_339273797.1 DUF7296 family protein [Paenibacillus sp. FSL W8-0426] diamond 459 85.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. FSL W8-0426
31438434 31438434 PRJNA591000_P_NODE_6076_length_581_cov_2.019928_g4798_i0 PRJNA591000 6076 581 2.019928 11.73578168 Saccharofermentanales bacterium 3107571 Bacteria Bacteria 78.6 8.21e-15   NR MFA5585532.1 3107571 g4798 i0 60 0.857142857142857 55 22 28.4 0 579 415 85 139 MFA5585532.1 hypothetical protein [Saccharofermentanales bacterium] diamond 498 78.6 1 Bacteria   Bacillati Bacillota Clostridia Saccharofermentanales     Saccharofermentanales bacterium
31470350 31470350 PRJNA591000_P_NODE_10896_length_431_cov_4.748756_g9319_i0 PRJNA591000 10896 431 4.748756 20.46713836 Streptococcus pneumoniae 1313 Bacteria Bacteria 142 1.74e-41   NR MBZ4299771.1 1313 g9319 i0 98.7 0.522041763341067 75 1 52.2 0 296 72 1 75 MBZ4299771.1 hypothetical protein [Streptococcus pneumoniae] diamond 225 142 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31470351 31470351 PRJNA591000_P_NODE_12996_length_406_cov_2.050398_g11407_i0 PRJNA591000 12996 406 2.050398 8.32461588 Streptococcus pneumoniae 1313 Bacteria Bacteria 108 7.25e-28   NR WP_196300888.1 1313 g11407 i0 100 0.4064039408867 55 0 40.6 0 26 190 1 55 WP_196300888.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 165 108 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31628284 31628284 PRJNA591000_P_NODE_8696_length_472_cov_1.593679_g7163_i0 PRJNA591000 8696 472 1.593679 7.52216488 Loigolactobacillus coryniformis 1610 Bacteria Bacteria 46.6 8.73e-4   NR WP_249567815.1 1610 g7163 i0 91.7 0.152542372881356 24 2 15.3 0 1 72 29 52 WP_249567815.1 hypothetical protein, partial [Loigolactobacillus coryniformis] diamond 72 46.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Loigolactobacillus Loigolactobacillus coryniformis
32324664 32324664 PRJNA591000_P_NODE_5099_length_652_cov_27.635634_g4022_i0 PRJNA591000 5099 652 27.635634 180.18433368 Streptococcus pseudopneumoniae 257758 Bacteria Bacteria 98.2 5.62e-23   NR WP_206688106.1 257758 g4022 i0 100 0.225460122699387 49 0 22.5 0 147 1 1 49 WP_206688106.1 hypothetical protein, partial [Streptococcus pseudopneumoniae] diamond 147 98.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pseudopneumoniae
32860749 32860749 PRJNA591000_P_NODE_3280_length_775_cov_1.470509_g2531_i0 PRJNA591000 3280 775 1.470509 11.39644475 Clostridium sp. 1506 Bacteria Bacteria 62 6.35e-7   NR NLB20595.1 1506 g2531 i0 44.8 0.658064516129032 58 30 22.5 1 775 602 439 494 NLB20595.1 chaperonin GroEL [Clostridium sp.] diamond 510 62 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium 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);;