RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB55122 · 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
10323448 10323448 PRJEB55122_P_NODE_14689_length_307_cov_2.089147_g14292_i0 PRJEB55122 14689 307 2.089147 6.41368129 Halanaerobiales bacterium 2094029 Bacteria Bacteria 139 6.95e-36   NR MBS3812162.1 2094029 g14292 i0 98.4 0.615635179153095 63 1 61.6 0 117 305 1 63 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 189 139 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
26875645 26875645 PRJEB55122_P_NODE_41421_length_164_cov_0.904348_g41024_i0 PRJEB55122 41421 164 0.904348 1.48313072 Streptococcus sp. S784/96/1 2653499 Bacteria Bacteria 102 1.42e-24   NR WP_161979865.1 2653499 g41024 i0 100 0.98780487804878 54 0 98.8 0 1 162 102 155 WP_161979865.1 DMT family transporter, partial [Streptococcus sp. S784/96/1] diamond 162 102 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. S784/96/1
27191484 27191484 PRJEB55122_P_NODE_37382_length_168_cov_1.386555_g36985_i0 PRJEB55122 37382 168 1.386555 2.3294124 Halanaerobiales bacterium 2094029 Bacteria Bacteria 47 4.28e-4   NR MBS3812162.1 2094029 g36985 i0 38.9 1.28571428571429 72 23 91.1 2 12 164 690 761 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 216 47 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
27507734 27507734 PRJEB55122_P_NODE_6903_length_532_cov_1.850932_g6514_i0 PRJEB55122 6903 532 1.850932 9.84695824 Romboutsia sp. 1965302 Bacteria Bacteria 134 2.68e-37   NR MCA9749906.1 1965302 g6514 i0 79.3 0.490601503759398 87 18 49.1 0 262 2 1 87 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 261 134 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
28100571 28100571 PRJEB55122_P_NODE_13265_length_331_cov_1.347518_g12868_i0 PRJEB55122 13265 331 1.347518 4.46028458 Bacillati 1783272 Bacteria Bacteria 52 4.14e-5   NR HEX3047039.1 1879010 g12868 i0 52.9 1.3595166163142 51 24 46.2 0 325 173 143 193 HEX3047039.1 LysM peptidoglycan-binding domain-containing protein [Bacillota bacterium] diamond 450 52.4 0.99236641221374 Bacteria   Bacillati Bacillota         Bacillota bacterium
28170599 28170599 PRJEB55122_P_NODE_42246_length_163_cov_0.912281_g41849_i0 PRJEB55122 42246 163 0.912281 1.48701803 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 105 9.31e-25   NR MBR4289067.1 2485925 g41849 i0 85.2 0.993865030674847 54 8 99.4 0 162 1 283 336 MBR4289067.1 D-alanyl-D-alanine carboxypeptidase [Oscillospiraceae bacterium] diamond 162 105 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28960204 28960204 PRJEB55122_P_NODE_32008_length_184_cov_1.540741_g31611_i0 PRJEB55122 32008 184 1.540741 2.83496344 Thalassobacillus sp. FIB228 493020 Bacteria Bacteria 97.1 1.28e-21   NR WP_394463813.1 493020 g31611 i0 73.8 2.98369565217391 61 16 99.5 0 1 183 238 298 WP_394463813.1 type IV secretory system conjugative DNA transfer family protein [Thalassobacillus sp. FIB228] diamond 549 97.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Thalassobacillus Thalassobacillus sp. FIB228
29591063 29591063 PRJEB55122_P_NODE_35210_length_173_cov_1.612903_g34813_i0 PRJEB55122 35210 173 1.612903 2.79032219 Bacilli bacterium 1903720 Bacteria Bacteria 45.4 5.23e-4   NR MEG0407283.1 1903720 g34813 i0 43.3 1.04046242774566 60 30 98.8 2 2 172 53 111 MEG0407283.1 hypothetical protein [Bacilli bacterium] diamond 180 45.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
30128065 30128065 PRJEB55122_P_NODE_17812_length_268_cov_1.520548_g17415_i0 PRJEB55122 17812 268 1.520548 4.07506864 Halanaerobiales bacterium 2094029 Bacteria Bacteria 81.6 1.06e-15   NR MBS3812162.1 2094029 g17415 i0 67.9 0.626865671641791 56 18 62.7 0 190 23 766 821 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 168 81.6 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
30949994 30949994 PRJEB55122_P_NODE_17574_length_271_cov_1.081081_g17177_i0 PRJEB55122 17574 271 1.081081 2.92972951 Streptococcus peroris 68891 Bacteria Bacteria 42.7 0.00364   NR WP_316599878.1 68891 g17177 i0 94.4 0.199261992619926 18 1 19.9 0 59 112 1 18 WP_316599878.1 hypothetical protein [Streptococcus peroris] diamond 54 42.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus peroris
31550757 31550757 PRJEB55122_P_NODE_39396_length_166_cov_0.888889_g38999_i0 PRJEB55122 39396 166 0.888889 1.47555574 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 61.6 2.86e-9   NR MCD7950961.1 2049044 g38999 i0 54.5 0.993975903614458 55 23 99.4 1 166 2 305 357 MCD7950961.1 aldehyde dehydrogenase [Erysipelotrichaceae bacterium] diamond 165 61.6 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium

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