RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400171 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
10617715 10617715 PRJNA400171_S_NODE_589_length_403_cov_3.114973_g499_i0 PRJNA400171 589 403 3.114973 12.55334119 Paenibacillus sp. FSL H8- 58172 Bacteria Bacteria 69.3 1.1e-10   NR WP_341154791.1 2954671 g499 i0 62.7 1.16873449131514 51 19 38 0 392 240 147 197 WP_341154791.1 dockerin type I domain-containing protein [Paenibacillus sp. FSL H8-0034] diamond 471 69.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. FSL H8-0034
23365770 23365770 PRJNA400171_S_NODE_2499_length_251_cov_2.576577_g2409_i0 PRJNA400171 2499 251 2.576577 6.46720827 Bacillati 1783272 Bacteria Bacteria 105 6.38e-26   NR WP_332277687.1 1396 g2409 i0 91.7 2.199203187251 48 4 57.4 0 146 3 61 108 WP_332277687.1 DNA methyltransferase, partial [Bacillus cereus] diamond 552 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
27265141 27265141 PRJNA400171_S_NODE_443_length_441_cov_3.012136_g354_i0 PRJNA400171 443 441 3.012136 13.28351976 Syntrophomonas sp. 2053627 Bacteria Bacteria 74.3 4.86e-13   NR MEN6462707.1 2053627 g354 i0 36.7 1 147 74 95.9 8 439 17 38 171 MEN6462707.1 hypothetical protein [Syntrophomonas sp.] diamond 441 74.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae Syntrophomonas Syntrophomonas sp.
27328414 27328414 PRJNA400171_S_NODE_4623_length_201_cov_2.668605_g4533_i0 PRJNA400171 4623 201 2.668605 5.36389605 uncultured Blautia sp. 765821 Bacteria Bacteria 89.4 7.18e-19   NR WP_294436031.1 765821 g4533 i0 66.7 7.80597014925373 66 22 98.5 0 198 1 333 398 WP_294436031.1 PBSX family phage terminase large subunit [uncultured Blautia sp.] diamond 1569 89.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia uncultured Blautia sp.
28086022 28086022 PRJNA400171_S_NODE_5625_length_186_cov_11.171975_g5535_i0 PRJNA400171 5625 186 11.171975 20.7798735 Staphylococcus aureus 1280 Bacteria Bacteria 47.8 4.47e-5   NR MCS4580470.1 1280 g5535 i0 77.5 0.645161290322581 40 9 64.5 0 177 58 1 40 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 120 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28086023 28086023 PRJNA400171_S_NODE_805_length_366_cov_84.540059_g715_i0 PRJNA400171 805 366 84.540059 309.41661594 Criibacterium bergeronii 1871336 Bacteria Bacteria 130 2.61e-36   NR RDY20310.1 1871336 g715 i0 98 0.80327868852459 98 2 80.3 0 296 3 1 98 RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii] diamond 294 130 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Criibacterium Criibacterium bergeronii
28559882 28559882 PRJNA400171_S_NODE_4207_length_208_cov_2.782123_g4117_i0 PRJNA400171 4207 208 2.782123 5.78681584 Symbiobacteriaceae bacterium 2602712 Bacteria Bacteria 79.7 2.25e-15   NR HYF95174.1 2602712 g4117 i0 52.2 8.16346153846154 69 33 99.5 0 208 2 340 408 HYF95174.1 DEAD/DEAH box helicase [Symbiobacteriaceae bacterium] diamond 1698 79.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae   Symbiobacteriaceae bacterium
28749177 28749177 PRJNA400171_S_NODE_6587_length_175_cov_3.116438_g6497_i0 PRJNA400171 6587 175 3.116438 5.4537665 Symbiobacteriaceae bacterium 2602712 Bacteria Bacteria 77.4 8.7e-15   NR HYF95174.1 2602712 g6497 i0 62.5 6.73714285714286 56 21 96 0 3 170 754 809 HYF95174.1 DEAD/DEAH box helicase [Symbiobacteriaceae bacterium] diamond 1179 77.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae   Symbiobacteriaceae bacterium
28812004 28812004 PRJNA400171_S_NODE_4008_length_212_cov_2.628415_g3918_i0 PRJNA400171 4008 212 2.628415 5.5722398 Paenibacillus sabuli 2772509 Bacteria Bacteria 47.4 5.84e-4   NR WP_317890144.1 2772509 g3918 i0 36.4 0.933962264150943 66 41 92 1 2 196 666 731 WP_317890144.1 RNA polymerase recycling motor HelD [Paenibacillus sabuli] diamond 198 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sabuli
32478486 32478486 PRJNA400171_S_NODE_319_length_499_cov_75.921277_g231_i0 PRJNA400171 319 499 75.921277 378.84717223 Criibacterium bergeronii 1871336 Bacteria Bacteria 130 1.31e-35   NR RDY20310.1 1871336 g231 i0 98 0.589178356713427 98 2 58.9 0 296 3 1 98 RDY20310.1 hypothetical protein BBG48_010870, partial [Criibacterium bergeronii] diamond 294 130 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Criibacterium Criibacterium bergeronii
32887852 32887852 PRJNA400171_S_NODE_700_length_381_cov_3.568182_g610_i0 PRJNA400171 700 381 3.568182 13.59477342 Syntrophothermus lipocalidus 86170 Bacteria Bacteria 87.8 9.09e-18   NR WP_013174397.1 86170 g610 i0 54.2 3.11023622047244 83 36 65.4 2 126 374 1 81 WP_013174397.1 HNH endonuclease [Syntrophothermus lipocalidus] diamond 1185 87.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae Syntrophothermus Syntrophothermus lipocalidus

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