RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB10140 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
26805012 26805012 PRJEB10140_P_NODE_37101_length_951_cov_3.443459_g23571_i0 PRJEB10140 37101 951 3.443459 32.74729509 root 1 Root_unresolved Root_unresolved 233 4.06e-70   NR WP_396206551.1 1962908 g23571 i0 45.4 1.84858044164038 291 146 91.8 4 23 895 119 396 WP_396206551.1 S8 family serine peptidase [Gemmatimonas sp.] diamond 1758 233 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
27285425 27285425 PRJEB10140_P_NODE_13903_length_1879_cov_5.144809_g7832_i0 PRJEB10140 13903 1879 5.144809 96.67096111 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 71.6 6e-9   NR MBI4545257.1 2026742 g7832 i0 25.8 0.346460883448643 217 151 33.8 8 1587 952 266 477 MBI4545257.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadota bacterium] diamond 651 71.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27285495 27285495 PRJEB10140_P_NODE_275803_length_164_cov_0.904348_g258494_i0 PRJEB10140 275803 164 0.904348 1.48313072 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 52.4 2.49e-6   NR HEX3534231.1 2026741 g258494 i0 42.6 0.98780487804878 54 31 98.8 0 2 163 122 175 HEX3534231.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 162 52.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27506852 27506852 PRJEB10140_P_NODE_48843_length_744_cov_5.097842_g33225_i0 PRJEB10140 48843 744 5.097842 37.92794448 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 65.1 3.54e-9   NR MBI3981754.1 2026742 g33225 i0 33.6 0.491935483870968 122 75 48.8 3 311 673 18 134 MBI3981754.1 nuclear transport factor 2 family protein [Gemmatimonadota bacterium] diamond 366 65.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27728007 27728007 PRJEB10140_P_NODE_259984_length_167_cov_0.864407_g242675_i0 PRJEB10140 259984 167 0.864407 1.44355969 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 70.1 7.55e-14   NR HJU64798.1 2026741 g242675 i0 67.3 3.03592814371257 55 17 98.8 1 3 167 12 65 HJU64798.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 507 70.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28074819 28074819 PRJEB10140_P_NODE_182525_length_210_cov_1.291925_g165216_i0 PRJEB10140 182525 210 1.291925 2.7130425 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.1 0.0171   NR HUQ83216.1 2026741 g165216 i0 32.9 1 70 38 90 3 205 17 148 215 HUQ83216.1 peptidyl-alpha-hydroxyglycine alpha-amidating lyase family protein [Gemmatimonadaceae bacterium] diamond 210 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28232490 28232490 PRJEB10140_P_NODE_125626_length_292_cov_0.855967_g108319_i0 PRJEB10140 125626 292 0.855967 2.49942364 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 58.9 1.33e-7   NR NJD10660.1 2026742 g108319 i0 49.4 0.791095890410959 77 36 79.1 2 1 231 108 181 NJD10660.1 hypothetical protein [Gemmatimonadota bacterium] diamond 231 58.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28738035 28738035 PRJEB10140_P_NODE_264527_length_166_cov_0.888889_g247218_i0 PRJEB10140 264527 166 0.888889 1.47555574 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 75.5 3.77e-14   NR HET8835284.1 2448054 g247218 i0 76.4 0.993975903614458 55 13 99.4 0 1 165 389 443 HET8835284.1 ATP-dependent DNA helicase RecQ [Gemmatimonadales bacterium] diamond 165 75.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28832573 28832573 PRJEB10140_P_NODE_136368_length_270_cov_0.873303_g119061_i0 PRJEB10140 136368 270 0.873303 2.3579181 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 43.5 0.0258   NR MEP7327357.1 2026742 g119061 i0 41.4 0.644444444444444 58 33 64.4 1 190 17 101 157 MEP7327357.1 ABC transporter permease [Gemmatimonadota bacterium] diamond 174 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28927430 28927430 PRJEB10140_P_NODE_252568_length_168_cov_0.873950_g235259_i0 PRJEB10140 252568 168 0.87395 1.468236 Longimicrobium sp. 2029185 Bacteria Bacteria 102 3.02e-25   NR WP_329681821.1 2029185 g235259 i0 92.7 0.982142857142857 55 4 98.2 0 2 166 146 200 WP_329681821.1 BON domain-containing protein, partial [Longimicrobium sp.] diamond 165 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29432294 29432294 PRJEB10140_P_NODE_164110_length_229_cov_1.672222_g146802_i0 PRJEB10140 164110 229 1.672222 3.82938838 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 42.4 0.0428   NR MCC6316304.1 2026741 g146802 i0 33.3 0.707423580786026 54 34 70.7 1 58 219 342 393 MCC6316304.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 162 42.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29457880 29457880 PRJEB10140_P_NODE_233130_length_175_cov_1.603175_g215821_i0 PRJEB10140 233130 175 1.603175 2.80555625 Bacteria 2 Bacteria Bacteria 41.6 0.0389   NR HET7188017.1 2026741 g215821 i0 46.9 2.52 49 24 80.6 1 153 13 280 328 HET7188017.1 phospholipase D-like domain-containing protein [Gemmatimonadaceae bacterium] diamond 441 41.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29868715 29868715 PRJEB10140_P_NODE_68051_length_540_cov_1.989817_g50985_i0 PRJEB10140 68051 540 1.989817 10.7450118 Pseudomonadati 3379134 Bacteria Bacteria 190 9.04e-58   NR MFV1987998.1 2026742 g50985 i0 49.2 6.59444444444444 177 90 98.3 0 536 6 32 208 MFV1987998.1 class I SAM-dependent methyltransferase [Gemmatimonadota bacterium] diamond 3561 190 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29937919 29937919 PRJEB10140_P_NODE_176951_length_215_cov_2.728916_g159642_i0 PRJEB10140 176951 215 2.728916 5.8671694 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 99 1.29e-22   NR TVR55788.1 2448054 g159642 i0 67.6 3.94883720930233 71 23 99.1 0 1 213 63 133 TVR55788.1 MAG: acyl-CoA dehydrogenase [Gemmatimonadales bacterium] diamond 849 99 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30158745 30158745 PRJEB10140_P_NODE_25272_length_1290_cov_2.116035_g15029_i0 PRJEB10140 25272 1290 2.116035 27.2968515 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 44.3 0.0352   NR MEO5799673.1 2448054 g15029 i0 32.8 0.134883720930233 58 30 13.5 1 1111 938 14 62 MEO5799673.1 zinc-ribbon domain-containing protein [Gemmatimonadales bacterium] diamond 174 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30538074 30538074 PRJEB10140_P_NODE_189733_length_203_cov_2.597403_g172424_i0 PRJEB10140 189733 203 2.597403 5.27272809 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 42.4 0.0305   NR MCX5767457.1 2026742 g172424 i0 43.1 0.753694581280788 51 29 75.4 0 171 19 96 146 MCX5767457.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadota bacterium] diamond 153 42.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30538084 30538084 PRJEB10140_P_NODE_210833_length_188_cov_1.453237_g193524_i0 PRJEB10140 210833 188 1.453237 2.73208556 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 40 0.049   NR HVF40654.1 2026741 g193524 i0 39.6 0.845744680851064 53 25 79.8 2 168 19 35 83 HVF40654.1 divalent metal cation transporter [Gemmatimonadaceae bacterium] diamond 159 40 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30632736 30632736 PRJEB10140_P_NODE_196573_length_198_cov_1.275168_g179264_i0 PRJEB10140 196573 198 1.275168 2.52483264 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 40.4 0.0416   NR NIP60528.1 2026742 g179264 i0 53.1 0.484848484848485 32 15 48.5 0 86 181 59 90 NIP60528.1 hypothetical protein [Gemmatimonadota bacterium] diamond 96 40.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31834074 31834074 PRJEB10140_P_NODE_23657_length_1350_cov_34.717141_g13936_i1 PRJEB10140 23657 1350 34.717141 468.6814035 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 89 3.6e-17   NR HEU4564687.1 2026741 g13936 i1 38.7 0.246666666666667 111 66 24.7 1 1043 711 18 126 HEU4564687.1 SgcJ/EcaC family oxidoreductase [Gemmatimonadaceae bacterium] diamond 333 89 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32150743 32150743 PRJEB10140_P_NODE_262458_length_166_cov_0.888889_g245149_i0 PRJEB10140 262458 166 0.888889 1.47555574 Longimicrobium sp. 2029185 Bacteria Bacteria 86.3 5.6e-18   NR HEX9938632.1 2029185 g245149 i0 83 2.87349397590361 53 9 95.8 0 161 3 63 115 HEX9938632.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Longimicrobium sp.] diamond 477 86.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32245851 32245851 PRJEB10140_P_NODE_14178_length_1857_cov_71.424779_g8005_i0 PRJEB10140 14178 1857 71.424779 1326.35814603 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 49.3 0.00678   NR MCH2460376.1 2026742 g8005 i0 36.1 0.098546042003231 61 39 9.9 0 814 632 65 125 MCH2460376.1 hypothetical protein [Gemmatimonadota bacterium] diamond 183 49.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32499010 32499010 PRJEB10140_P_NODE_75879_length_484_cov_1.737931_g58678_i0 PRJEB10140 75879 484 1.737931 8.41158604 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 48.5 0.00354   NR HJQ54038.1 2026741 g58678 i0 28.2 0.966942148760331 156 98 91.7 5 460 17 120 269 HJQ54038.1 HD domain-containing protein [Gemmatimonadaceae bacterium] diamond 468 48.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32876813 32876813 PRJEB10140_P_NODE_23620_length_1351_cov_66.608295_g13936_i0 PRJEB10140 23620 1351 66.608295 899.87806545 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 89 3.62e-17   NR HEU4564687.1 2026741 g13936 i0 38.7 0.246484085862324 111 66 24.6 1 1044 712 18 126 HEU4564687.1 SgcJ/EcaC family oxidoreductase [Gemmatimonadaceae bacterium] diamond 333 89 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;