RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA874604" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA874604 · 17 ✖
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
2127587 2127587 PRJNA874604_P_NODE_63062_length_260_cov_2.192513_g62710_i0 PRJNA874604 63062 260 2.192513 5.7005338 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 130 5.43e-33   NR MEJ7812963.1 2026741 g62710 i0 71.4 0.969230769230769 84 24 96.9 0 9 260 353 436 MEJ7812963.1 DUF885 domain-containing protein [Gemmatimonadaceae bacterium] diamond 252 130 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
7230683 7230683 PRJNA874604_P_NODE_73846_length_250_cov_0.870056_g73494_i0 PRJNA874604 73846 250 0.870056 2.17514 Roseisolibacter sp. H3M3-2 3031323 Bacteria Bacteria 123 3.33e-31   NR WP_275833286.1 3031323 g73494 i0 74.7 0.996 83 21 99.6 0 250 2 219 301 WP_275833286.1 M16 family metallopeptidase [Roseisolibacter sp. H3M3-2] diamond 249 123 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter sp. H3M3-2
13605133 13605133 PRJNA874604_P_NODE_21131_length_395_cov_0.947205_g20779_i0 PRJNA874604 21131 395 0.947205 3.74145975 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 91.6 8.01e-14   NTclustered gi|2107953857|gb|CP070792.1| 2026742 g20779 i0 91.176 1.91898734177215 68 4 17 2 301 366 902044 902111 MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome blastn 758 91.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
13606646 13606646 PRJNA874604_P_NODE_99471_length_241_cov_0.916667_g99119_i0 PRJNA874604 99471 241 0.916667 2.20916747 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 172 1.6e-38   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g99119 i0 81.166 2.74688796680498 223 35 90 6 1 218 1441321 1441101 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 662 172 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
17430150 17430150 PRJNA874604_P_NODE_47434_length_289_cov_1.398148_g47082_i0 PRJNA874604 47434 289 1.398148 4.04064772 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 281 3.13e-71   NTclustered gi|575456455|gb|CP007128.1| 861299 g47082 i0 84.965 106.557093425606 286 33 97 8 1 280 3042327 3042608 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 30795 281 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
22915422 22915422 PRJNA874604_P_NODE_12958_length_483_cov_1.314634_g12606_i0 PRJNA874604 12958 483 1.314634 6.34968222 Longimicrobium sp. 2029185 Bacteria Bacteria 233 4.31e-75   NR HEX6750180.1 2029185 g12606 i0 72.4 1.90062111801242 152 42 94.4 0 458 3 1 152 HEX6750180.1 GNAT family N-acetyltransferase [Longimicrobium sp.] diamond 918 233 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27971161 27971161 PRJNA874604_P_NODE_100165_length_241_cov_0.916667_g99813_i0 PRJNA874604 100165 241 0.916667 2.20916747 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 97.4 2e-21   NR HEX3926874.1 2448054 g99813 i0 60.3 4.50622406639004 73 29 90.9 0 3 221 187 259 HEX3926874.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadales bacterium] diamond 1086 97.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28413330 28413330 PRJNA874604_P_NODE_53266_length_278_cov_1.370732_g52914_i0 PRJNA874604 53266 278 1.370732 3.81063496 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 42.4 0.048   NR MBA3671164.1 2026741 g52914 i0 30.6 0.776978417266187 72 45 72.3 1 241 41 59 130 MBA3671164.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 216 42.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29084479 29084479 PRJNA874604_P_NODE_90168_length_244_cov_0.900585_g89816_i0 PRJNA874604 90168 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 135 3.8e-36   NR HYD54562.1 2026741 g89816 i0 76.3 7.79508196721311 80 19 98.4 0 240 1 154 233 HYD54562.1 glycoside hydrolase family 172 protein [Gemmatimonadaceae bacterium] diamond 1902 135 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29210830 29210830 PRJNA874604_P_NODE_75369_length_249_cov_0.875000_g75017_i0 PRJNA874604 75369 249 0.875 2.17875 Pseudomonadati 3379134 Bacteria Bacteria 62.4 2.89e-9   NR MBP9106683.1 2026741 g75017 i0 43.4 1.92771084337349 83 44 96.4 3 240 1 36 118 MBP9106683.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 480 62.8 0.993630573248408 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29392141 29392141 PRJNA874604_P_NODE_100929_length_239_cov_2.500000_g100577_i0 PRJNA874604 100929 239 2.5 5.975 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 89.7 5.57e-19   NR MEO7103829.1 2026741 g100577 i0 55.8 0.96652719665272 77 33 96.7 1 231 1 129 204 MEO7103829.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadaceae bacterium] diamond 231 89.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29802454 29802454 PRJNA874604_P_NODE_79771_length_248_cov_0.880000_g79419_i0 PRJNA874604 79771 248 0.88 2.1824 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 79.3 1.7e-15   NR HYJ80700.1 3047548 g79419 i0 55.2 1.31854838709677 58 26 70.2 0 246 73 219 276 HYJ80700.1 M15 family metallopeptidase [Longimicrobiaceae bacterium] diamond 327 79.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30466272 30466272 PRJNA874604_P_NODE_54673_length_275_cov_2.287129_g54321_i0 PRJNA874604 54673 275 2.287129 6.28960475 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 55.5 1.84e-6   NR HET7584050.1 2026741 g54321 i0 39.3 1.74545454545455 89 53 97.1 1 1 267 115 202 HET7584050.1 penicillin acylase family protein [Gemmatimonadaceae bacterium] diamond 480 55.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31255899 31255899 PRJNA874604_P_NODE_67235_length_253_cov_1.455556_g66883_i0 PRJNA874604 67235 253 1.455556 3.68255668 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 98.2 1.25e-21   NR NNE08319.1 2026742 g66883 i0 55.1 0.924901185770751 78 35 92.5 0 15 248 205 282 NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] diamond 234 98.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32394881 32394881 PRJNA874604_P_NODE_80519_length_247_cov_0.885057_g80167_i0 PRJNA874604 80519 247 0.885057 2.18609079 Longimicrobiales bacterium 2910168 Bacteria Bacteria 54.3 2.33e-6   NR HEX6694358.1 2910168 g80167 i0 45.2 1.02024291497976 84 34 96 3 237 1 71 147 HEX6694358.1 4'-phosphopantetheinyl transferase superfamily protein [Longimicrobiales bacterium] diamond 252 54.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
32710396 32710396 PRJNA874604_P_NODE_90740_length_244_cov_0.900585_g90388_i0 PRJNA874604 90740 244 0.900585 2.1974274 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 128 3.25e-36   NR HEY2848380.1 2026741 g90388 i0 72.2 0.971311475409836 79 22 97.1 0 8 244 6 84 HEY2848380.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 237 128 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32836309 32836309 PRJNA874604_P_NODE_58200_length_269_cov_1.510204_g57848_i0 PRJNA874604 58200 269 1.510204 4.06244876 Gemmatimonadetes bacterium T265 2839016 Bacteria Bacteria 166 4.67e-48   NR GJG86879.1 2839016 g57848 i0 91 0.992565055762082 89 8 99.3 0 268 2 45 133 GJG86879.1 aerobic magnesium-protoporphyrin IX monomethyl ester [oxidative] cyclase [Gemmatimonadetes bacterium T265] diamond 267 166 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium T265

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