RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
7777427 7777427 PRJEB58983_P_NODE_2687_length_762_cov_3.304790_g2307_i0 PRJEB58983 2687 762 3.30479 25.1824998 Paenibacillus sophorae 1333845 Bacteria Bacteria 297 7.66e-99   NR WP_216700392.1 1333845 g2307 i0 66.8 1.69685039370079 214 69 84.3 2 56 697 5 216 WP_216700392.1 HD domain-containing protein [Paenibacillus sophorae] diamond 1293 297 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sophorae
10327735 10327735 PRJEB58983_P_NODE_14189_length_337_cov_3.462121_g13774_i0 PRJEB58983 14189 337 3.462121 11.66734777 Clostridium sp. 1506 Bacteria Bacteria 97.4 1.0799999999999999e-23   NR MBO5574138.1 1506 g13774 i0 56.3 1.70029673590504 96 42 85.5 0 304 17 1 96 MBO5574138.1 HU family DNA-binding protein [Clostridium sp.] diamond 573 97.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
21801406 21801406 PRJEB58983_P_NODE_12918_length_352_cov_1.358423_g12503_i0 PRJEB58983 12918 352 1.358423 4.78164896 Defluviitaleaceae bacterium 2660712 Bacteria Bacteria 142 7.589999999999999e-40   NR MCL1994644.1 2660712 g12503 i0 69.8 4.90909090909091 96 29 81.8 0 60 347 1 96 MCL1994644.1 IS607 family transposase [Defluviitaleaceae bacterium] diamond 1728 142 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Defluviitaleaceae   Defluviitaleaceae bacterium
21801550 21801550 PRJEB58983_P_NODE_20138_length_289_cov_1.949074_g19723_i0 PRJEB58983 20138 289 1.949074 5.63282386 Bacteria 2 Bacteria Bacteria 146 1.07e-38   NR NLI68905.1 1903720 g19723 i0 78.1 18.9342560553633 96 21 99.7 0 289 2 355 450 NLI68905.1 molecular chaperone DnaK [Bacilli bacterium] diamond 5472 147 0.993197278911565 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
26685286 26685286 PRJEB58983_P_NODE_29021_length_250_cov_0.881356_g28606_i0 PRJEB58983 29021 250 0.881356 2.20339 Bacilli bacterium 1903720 Bacteria Bacteria 107 6.2600000000000005e-27   NR MEG2847184.1 1903720 g28606 i0 65.1 0.996 83 29 99.6 0 1 249 2 84 MEG2847184.1 ADP-ribosyltransferase [Bacilli bacterium] diamond 249 107 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
26812105 26812105 PRJEB58983_P_NODE_13441_length_345_cov_4.275735_g13026_i0 PRJEB58983 13441 345 4.275735 14.75128575 Clostridium sp. UBA1652 1946348 Bacteria Bacteria 110 7.060000000000001e-26   NR WP_286904851.1 1946348 g13026 i0 48.2 0.991304347826087 114 59 99.1 0 342 1 118 231 WP_286904851.1 AAA family ATPase [Clostridium sp. UBA1652] diamond 342 110 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. UBA1652
26843905 26843905 PRJEB58983_P_NODE_31561_length_244_cov_0.912281_g31146_i0 PRJEB58983 31561 244 0.912281 2.22596564 Clostridia bacterium 2044939 Bacteria Bacteria 154 9.04e-44   NR MBN2793995.1 2044939 g31146 i0 88.9 1.99180327868852 81 9 99.6 0 243 1 12 92 MBN2793995.1 restriction endonuclease subunit S [Clostridia bacterium] diamond 486 154 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
26868802 26868802 PRJEB58983_P_NODE_28161_length_252_cov_1.720670_g27746_i0 PRJEB58983 28161 252 1.72067 4.3360884 Bacillati 1783272 Bacteria Bacteria 62.8 2.14e-9   NR WP_090549096.1 393762 g27746 i0 43.4 4.94047619047619 83 44 98.8 1 251 3 18 97 WP_090549096.1 flagellar basal-body rod protein FlgG [Natronincola ferrireducens] diamond 1245 63.2 0.993670886075949 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Natronincolaceae Natronincola Natronincola ferrireducens
26963344 26963344 PRJEB58983_P_NODE_21102_length_284_cov_1.431280_g20687_i0 PRJEB58983 21102 284 1.43128 4.0648352 FCB group 1783270 Bacteria Bacteria 54.7 3.77e-6   NR WP_378049520.1 986710 g20687 i0 64.7 1.08802816901408 34 12 35.9 0 3 104 40 73 WP_378049520.1 WG repeat-containing protein [Cohnella cellulosilytica] diamond 309 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella cellulosilytica
27381439 27381439 PRJEB58983_P_NODE_29843_length_248_cov_0.891429_g29428_i0 PRJEB58983 29843 248 0.891429 2.21074392 Metabacillus arenae 2771434 Bacteria Bacteria 78.2 9.55e-15   NR WP_191159945.1 2771434 g29428 i0 64.3 2.68548387096774 56 20 67.7 0 81 248 2 57 WP_191159945.1 molecular chaperone DnaJ [Metabacillus arenae] diamond 666 78.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus arenae
27444733 27444733 PRJEB58983_P_NODE_31723_length_243_cov_3.070588_g31308_i0 PRJEB58983 31723 243 3.070588 7.46152884 Pelotomaculum propionicicum 258475 Bacteria Bacteria 62 1.16e-9   NR TEB09188.1 258475 g31308 i0 59.5 0.518518518518518 42 17 51.9 0 166 41 64 105 TEB09188.1 hypothetical protein Pmgp_03320 [Pelotomaculum propionicicum] diamond 126 62 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfotomaculaceae Pelotomaculum Pelotomaculum propionicicum
27507756 27507756 PRJEB58983_P_NODE_18283_length_301_cov_3.903509_g17868_i0 PRJEB58983 18283 301 3.903509 11.74956209 Halanaerobium praevalens 2331 Bacteria Bacteria 93.2 2.5000000000000002e-22   NR WP_014554168.1 2331 g17868 i0 46.3 0.946843853820598 95 46 94.7 2 16 300 2 91 WP_014554168.1 HNH endonuclease [Halanaerobium praevalens] diamond 285 93.2 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium praevalens
27722255 27722255 PRJEB58983_P_NODE_24224_length_268_cov_3.389744_g23809_i0 PRJEB58983 24224 268 3.389744 9.08451392 Clostridium 1485 Bacteria Bacteria 44.7 0.0102   NR MFQ7538204.1 1506 g23809 i0 34.7 3.22388059701493 72 45 78.4 1 53 262 180 251 MFQ7538204.1 BglG family transcription antiterminator [Clostridium sp.] diamond 864 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
27791865 27791865 PRJEB58983_P_NODE_33884_length_232_cov_3.433962_g33469_i0 PRJEB58983 33884 232 3.433962 7.96679184 Peptostreptococcaceae bacterium 1904861 Bacteria Bacteria 139 1.5499999999999998e-37   NR MBQ1793306.1 1904861 g33469 i0 90.9 1.99137931034483 77 7 99.6 0 232 2 322 398 MBQ1793306.1 S1 RNA-binding domain-containing protein [Peptostreptococcaceae bacterium] diamond 462 139 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae   Peptostreptococcaceae bacterium
27981253 27981253 PRJEB58983_P_NODE_33965_length_232_cov_2.144654_g33550_i0 PRJEB58983 33965 232 2.144654 4.97559728 Paenibacillus aquistagni 1852522 Bacteria Bacteria 52 1.71e-5   NR WP_088549130.1 1852522 g33550 i0 40 0.969827586206897 75 45 97 0 231 7 263 337 WP_088549130.1 glycosyltransferase family A protein [Paenibacillus aquistagni] diamond 225 52 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus aquistagni
28075789 28075789 PRJEB58983_P_NODE_21865_length_280_cov_1.507246_g21450_i0 PRJEB58983 21865 280 1.507246 4.2202888 Streptococcus pneumoniae 1313 Bacteria Bacteria 43.5 0.0303   NR CTM16003.1 1313 g21450 i0 38.7 1.32857142857143 62 36 66.4 1 259 74 102 161 CTM16003.1 hyaluronate lyase [Streptococcus pneumoniae] diamond 372 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28233505 28233505 PRJEB58983_P_NODE_22466_length_277_cov_1.279412_g22051_i0 PRJEB58983 22466 277 1.279412 3.54397124 Streptococcus pneumoniae 1313 Bacteria Bacteria 53.9 3.94e-6   NR VNI85500.1 1313 g22051 i0 40 0.866425992779783 80 47 86.6 1 2 241 131 209 VNI85500.1 Uncharacterised protein [Streptococcus pneumoniae] diamond 240 53.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28795108 28795108 PRJEB58983_P_NODE_9687_length_401_cov_1.149390_g9273_i0 PRJEB58983 9687 401 1.14939 4.6090539 Bacillaceae 186817 Bacteria Bacteria 92.4 5.77e-19   NR WP_148977135.1 324767 g9273 i0 34.6 3.65835411471322 127 79 95 3 398 18 274 396 WP_148977135.1 ABC transporter substrate-binding protein [Bacillus infantis] diamond 1467 92.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus infantis
30191463 30191463 PRJEB58983_P_NODE_13472_length_345_cov_2.165441_g13057_i0 PRJEB58983 13472 345 2.165441 7.47077145 Bacillus sp. SH5-2 2217834 Bacteria Bacteria 134 1.34e-33   NR KAA0760315.1 2217834 g13057 i0 61.6 2.89565217391304 112 43 97.4 0 339 4 989 1100 KAA0760315.1 DUF11 domain-containing protein [Bacillus sp. SH5-2] diamond 999 134 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SH5-2
30690237 30690237 PRJEB58983_P_NODE_25873_length_261_cov_1.521277_g25458_i0 PRJEB58983 25873 261 1.521277 3.97053297 Bacteria 2 Bacteria Bacteria 159 1.5399999999999998e-48   NR MEG2848368.1 1903720 g25458 i0 97.6 2.93103448275862 85 2 97.7 0 1 255 15 99 MEG2848368.1 MotA/TolQ/ExbB proton channel family protein [Bacilli bacterium] diamond 765 159 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31139110 31139110 PRJEB58983_P_NODE_19935_length_290_cov_2.336406_g19520_i0 PRJEB58983 19935 290 2.336406 6.7755774 Bacilli 91061 Bacteria Bacteria 134 3.85e-39   NR WP_048395409.1 91061 g19520 i0 100 0.724137931034483 70 0 72.4 0 79 288 1 70 WP_048395409.1 MULTISPECIES: hypothetical protein [Bacilli] diamond 210 134 1 Bacteria   Bacillati Bacillota Bacilli        
31424009 31424009 PRJEB58983_P_NODE_33476_length_235_cov_2.777778_g33061_i0 PRJEB58983 33476 235 2.777778 6.5277783 uncultured Clostridium sp. 59620 Bacteria Bacteria 127 1.29e-36   NR WP_297636589.1 59620 g33061 i0 77.6 0.970212765957447 76 17 97 0 7 234 1 76 WP_297636589.1 hypothetical protein [uncultured Clostridium sp.] diamond 228 127 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
32056656 32056656 PRJEB58983_P_NODE_13278_length_347_cov_4.007299_g12863_i0 PRJEB58983 13278 347 4.007299 13.90532753 Clostridium sp. UBA1652 1946348 Bacteria Bacteria 97.1 5.07e-21   NR WP_286904851.1 1946348 g12863 i0 66.2 0.613832853025937 71 24 61.4 0 345 133 329 399 WP_286904851.1 AAA family ATPase [Clostridium sp. UBA1652] diamond 213 97.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. UBA1652
32088332 32088332 PRJEB58983_P_NODE_23278_length_273_cov_1.730000_g22863_i0 PRJEB58983 23278 273 1.73 4.7229 Clostridium 1485 Bacteria Bacteria 87 4.71e-18   NR WP_185966727.1 1485 g22863 i0 50.6 1.93406593406593 87 41 93.4 2 269 15 223 309 WP_185966727.1 MULTISPECIES: radical SAM/SPASM domain-containing protein [Clostridium] diamond 528 87 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium  
32278389 32278389 PRJEB58983_P_NODE_16899_length_312_cov_3.677824_g16484_i0 PRJEB58983 16899 312 3.677824 11.47481088 Hungatella hathewayi 154046 Bacteria Bacteria 45.1 0.0025   NR WP_006783152.1 154046 g16484 i0 43.4 1.125 53 24 51 1 208 50 3 49 WP_006783152.1 thioredoxin [Hungatella hathewayi] diamond 351 45.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Hungatella Hungatella hathewayi
32303343 32303343 PRJEB58983_P_NODE_10479_length_387_cov_2.127389_g10064_i0 PRJEB58983 10479 387 2.127389 8.23299543 Bacteria 2 Bacteria Bacteria 129 1.53e-33   NR WP_185966727.1 1485 g10064 i0 49.6 4.08527131782946 131 58 95.3 2 371 3 6 136 WP_185966727.1 MULTISPECIES: radical SAM/SPASM domain-containing protein [Clostridium] diamond 1581 129 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium  

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