RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1175041" 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

  • PRJNA1175041 · 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
16893501 16893501 PRJNA1175041_P_NODE_101494_length_245_cov_0.883721_g98626_i0 PRJNA1175041 101494 245 0.883721 2.16511645 Angelakisella sp. 1935177 Bacteria Bacteria 139 2.56e-36   NR MCI9667402.1 1935177 g98626 i0 96.2 1.91020408163265 79 3 96.7 0 238 2 1 79 MCI9667402.1 hypothetical protein [Angelakisella sp.] diamond 468 139 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Angelakisella Angelakisella sp.
26964737 26964737 PRJNA1175041_P_NODE_99382_length_247_cov_0.873563_g96514_i0 PRJNA1175041 99382 247 0.873563 2.15770061 Bacillati 1783272 Bacteria Bacteria 105 1.13e-25   NR WP_261197916.1 1423 g96514 i0 71.3 16.0931174089069 80 23 97.2 0 242 3 19 98 WP_261197916.1 hypothetical protein [Bacillus subtilis] diamond 3975 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
27103675 27103675 PRJNA1175041_P_NODE_99982_length_246_cov_0.878613_g97114_i0 PRJNA1175041 99982 246 0.878613 2.16138798 uncultured Dubosiella sp. 1937011 Bacteria Bacteria 168 1.63e-49   NR WP_289197645.1 1937011 g97114 i0 98.8 1 82 1 100 0 246 1 120 201 WP_289197645.1 PolC-type DNA polymerase III [uncultured Dubosiella sp.] diamond 246 168 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Dubosiella uncultured Dubosiella sp.
27514595 27514595 PRJNA1175041_P_NODE_82003_length_288_cov_1.093023_g79135_i0 PRJNA1175041 82003 288 1.093023 3.14790624 Eubacterium sp. 142586 Bacteria Bacteria 202 9.95e-63   NR MCI9209700.1 142586 g79135 i0 100 1 96 0 100 0 1 288 214 309 MCI9209700.1 alpha/beta hydrolase [Eubacterium sp.] diamond 288 202 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
27577714 27577714 PRJNA1175041_P_NODE_107804_length_239_cov_0.915663_g104936_i0 PRJNA1175041 107804 239 0.915663 2.18843457 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 157 8.44e-44   NR MDY2789824.1 1898203 g104936 i0 94.9 6.94142259414226 79 4 99.2 0 2 238 285 363 MDY2789824.1 amidophosphoribosyltransferase [Lachnospiraceae bacterium] diamond 1659 157 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27798906 27798906 PRJNA1175041_P_NODE_107224_length_240_cov_0.886228_g104356_i0 PRJNA1175041 107224 240 0.886228 2.1269472 Eubacterium sp. 142586 Bacteria Bacteria 89.4 3.27e-19   NR MCI9412796.1 142586 g104356 i0 73.1 0.65 52 14 65 0 3 158 250 301 MCI9412796.1 restriction endonuclease [Eubacterium sp.] diamond 156 89.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
28619849 28619849 PRJNA1175041_P_NODE_102187_length_244_cov_0.888889_g99319_i0 PRJNA1175041 102187 244 0.888889 2.16888916 unclassified Turicibacter 2638206 Bacteria Bacteria 67.8 1.6e-12   NR WP_262953588.1 2638206 g99319 i0 67.3 0.602459016393443 49 16 60.2 0 178 32 55 103 WP_262953588.1 MULTISPECIES: helix-turn-helix domain-containing protein [unclassified Turicibacter] diamond 147 67.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Turicibacteraceae Turicibacter  
30420088 30420088 PRJNA1175041_P_NODE_96513_length_249_cov_0.863636_g93645_i0 PRJNA1175041 96513 249 0.863636 2.15045364 Lachnospiraceae bacterium 1 1898203 Bacteria Bacteria 120 1.15e-31   NR EOS78106.1 1235800 g93645 i0 77.5 0.963855421686747 80 18 96.4 0 9 248 6 85 EOS78106.1 hypothetical protein C819_00417 [Lachnospiraceae bacterium 10-1] diamond 240 120 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium 10-1
30862062 30862062 PRJNA1175041_P_NODE_96934_length_249_cov_0.863636_g94066_i0 PRJNA1175041 96934 249 0.863636 2.15045364 Acetatifactor sp. 1872090 Bacteria Bacteria 166 1.92e-48   NR MFG6356014.1 1872090 g94066 i0 100 0.987951807228916 82 0 98.8 0 248 3 152 233 MFG6356014.1 Rpn family recombination-promoting nuclease/putative transposase [Acetatifactor sp.] diamond 246 166 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Acetatifactor Acetatifactor sp.
31336035 31336035 PRJNA1175041_P_NODE_78416_length_299_cov_1.039823_g75548_i0 PRJNA1175041 78416 299 1.039823 3.10907077 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 91.3 3.82e-21   NR POH17992.1 1625 g75548 i0 84.1 0.632107023411371 63 10 63.2 0 1 189 69 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 189 91.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
32664249 32664249 PRJNA1175041_P_NODE_106680_length_240_cov_0.910180_g103812_i0 PRJNA1175041 106680 240 0.91018 2.184432 Dorea sp. 2040332 Bacteria Bacteria 148 4.56e-41   NR MCI8321910.1 2040332 g103812 i0 100 1 80 0 100 0 1 240 15 94 MCI8321910.1 hypothetical protein [Dorea sp.] diamond 240 148 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Dorea Dorea 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);;