RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA792582 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
2052933 2052933 PRJNA792582_P_NODE_40262_length_277_cov_1.411765_g39448_i0 PRJNA792582 40262 277 1.411765 3.91058905 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 141 1.4e-36   NR MBL8995832.1 2026742 g39448 i0 84.8 2.98916967509025 92 14 99.6 0 2 277 285 376 MBL8995832.1 serine hydrolase [Gemmatimonadota bacterium] diamond 828 141 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
10143917 10143917 PRJNA792582_P_NODE_35488_length_289_cov_3.356481_g34674_i0 PRJNA792582 35488 289 3.356481 9.70023009 Roseisolibacter agri 2014610 Bacteria Bacteria 97.4 2.8400000000000003e-21   NR WP_284352341.1 2014610 g34674 i0 93.9 0.508650519031142 49 3 50.9 0 142 288 36 84 WP_284352341.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Roseisolibacter agri] diamond 147 97.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
10981096 10981096 PRJNA792582_P_NODE_51629_length_249_cov_0.875000_g50815_i0 PRJNA792582 51629 249 0.875 2.17875 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 102 2.79e-25   NR HEU6450968.1 2026741 g50815 i0 71.2 2.3855421686747 66 19 79.5 0 199 2 1 66 HEU6450968.1 GNAT family protein [Gemmatimonadaceae bacterium] diamond 594 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
13530730 13530730 PRJNA792582_P_NODE_49111_length_252_cov_1.720670_g48297_i0 PRJNA792582 49111 252 1.72067 4.3360884 Bacteria 2 Bacteria Bacteria 112 9.11e-27   NR MEO7217680.1 2026741 g48297 i0 68.7 6.83333333333333 83 26 98.8 0 251 3 182 264 MEO7217680.1 PBP1A family penicillin-binding protein [Gemmatimonadaceae bacterium] diamond 1722 112 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
17355337 17355337 PRJNA792582_P_NODE_44654_length_265_cov_1.604167_g43840_i0 PRJNA792582 44654 265 1.604167 4.25104255 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 172 1.59e-50   NR MBW3570171.1 2026742 g43840 i0 87.5 0.99622641509434 88 11 99.6 0 265 2 167 254 MBW3570171.1 glycosyltransferase [Gemmatimonadota bacterium] diamond 264 172 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
18628492 18628492 PRJNA792582_P_NODE_35515_length_289_cov_2.560185_g34701_i0 PRJNA792582 35515 289 2.560185 7.39893465 Gemmatirosa sp. 2510638 Bacteria Bacteria 159 1.06e-45   NR HZF69154.1 2510638 g34701 i0 80.2 2.98961937716263 96 19 99.7 0 2 289 181 276 HZF69154.1 decarboxylating 6-phosphogluconate dehydrogenase [Gemmatirosa sp.] diamond 864 159 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
20341855 20341855 PRJNA792582_P_NODE_39496_length_279_cov_1.354369_g38682_i0 PRJNA792582 39496 279 1.354369 3.77868951 Roseisolibacter agri 2014610 Bacteria Bacteria 105 6.89e-24   NR WP_284350442.1 2014610 g38682 i0 67.5 0.860215053763441 80 26 86 0 3 242 1164 1243 WP_284350442.1 DUF4175 family protein [Roseisolibacter agri] diamond 240 105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
26673583 26673583 PRJNA792582_P_NODE_47521_length_257_cov_1.375000_g46707_i0 PRJNA792582 47521 257 1.375 3.53375 Roseisolibacter sp. H3M3-2 3031323 Bacteria Bacteria 63.5 5.24e-11   NR WP_275834931.1 3031323 g46707 i0 69.4 1.66926070038911 49 14 57.2 1 64 210 35 82 WP_275834931.1 hypothetical protein [Roseisolibacter sp. H3M3-2] diamond 429 63.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter sp. H3M3-2
28348630 28348630 PRJNA792582_P_NODE_35906_length_288_cov_2.404651_g35092_i0 PRJNA792582 35906 288 2.404651 6.92539488 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 144 4.85e-41   NR GJG88456.1 2839016 g35092 i0 77.9 0.989583333333333 95 20 99 1 3 287 77 170 GJG88456.1 hypothetical protein tb265_36370 [Gemmatimonadetes bacterium T265] diamond 285 144 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265
29548269 29548269 PRJNA792582_P_NODE_37170_length_285_cov_1.509434_g36356_i0 PRJNA792582 37170 285 1.509434 4.3018869 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.3 0.0178   NR HXT14879.1 2026741 g36356 i0 40.8 0.515789473684211 49 29 51.6 0 193 47 773 821 HXT14879.1 transcription-repair coupling factor [Gemmatimonadaceae bacterium] diamond 147 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30275218 30275218 PRJNA792582_P_NODE_35212_length_290_cov_1.917051_g34398_i0 PRJNA792582 35212 290 1.917051 5.5594479 Longimicrobium sp. 2029185 Bacteria Bacteria 169 6.4e-48   NR WP_329683937.1 2029185 g34398 i0 85.1 2.95862068965517 94 14 97.2 0 7 288 310 403 WP_329683937.1 hypothetical protein [Longimicrobium sp.] diamond 858 169 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30338591 30338591 PRJNA792582_P_NODE_47012_length_258_cov_2.264865_g46198_i0 PRJNA792582 47012 258 2.264865 5.8433517 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 118 1.35e-28   NR WP_158508910.1 861299 g46198 i0 73.3 1 86 23 100 0 1 258 284 369 WP_158508910.1 VWA domain-containing protein [Gemmatirosa kalamazoonensis] diamond 258 118 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
30527658 30527658 PRJNA792582_P_NODE_44553_length_265_cov_2.255208_g43739_i0 PRJNA792582 44553 265 2.255208 5.9763012 Roseisolibacter agri 2014610 Bacteria Bacteria 57 4.39e-7   NR WP_284352059.1 2014610 g43739 i0 78.1 0.362264150943396 32 7 36.2 0 263 168 431 462 WP_284352059.1 hypothetical protein [Roseisolibacter agri] diamond 96 57 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
32203498 32203498 PRJNA792582_P_NODE_44258_length_266_cov_1.595855_g43444_i0 PRJNA792582 44258 266 1.595855 4.2449743 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 46.2 0.00128   NR MCH7532820.1 2026742 g43444 i0 46.4 0.631578947368421 56 19 54.1 2 220 77 103 155 MCH7532820.1 hypothetical protein [Gemmatimonadota bacterium] diamond 168 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32708954 32708954 PRJNA792582_P_NODE_57460_length_243_cov_0.905882_g56646_i0 PRJNA792582 57460 243 0.905882 2.20129326 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 41.2 0.0209   NR HEV2733865.1 3047548 g56646 i0 33.9 0.765432098765432 62 32 65.4 1 220 62 2 63 HEV2733865.1 thioredoxin family protein [Longimicrobiaceae bacterium] diamond 186 41.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae 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);;