contig_metadata
25 rows where bioproject = "PRJNA737474", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25571069 | 25571069 | PRJNA737474c_S_NODE_19081_length_279_cov_3.281553_g18250_i0 | PRJNA737474 | 19081 | 279 | 3.281553 | 9.15553287 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 65.8 | 3.3e-6 | NTclustered | gi|2107779373|gb|CP070829.1| | 2448054 | g18250 | i0 | 100 | 20.9641577060932 | 35 | 0 | 13 | 0 | 27 | 61 | 4018085 | 4018119 | MAG: Gemmatimonadales bacterium isolate bin109 chromosome | blastn | 5849 | 65.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 25723012 | 25723012 | PRJNA737474g_S_NODE_348986_length_248_cov_0.880000_g347692_i0 | PRJNA737474 | 348986 | 248 | 0.88 | 2.1824 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 110 | 1.13e-26 | NR | MEO8000078.1 | 2026741 | g347692 | i0 | 83.6 | 9.41129032258065 | 67 | 11 | 81 | 0 | 214 | 14 | 34 | 100 | MEO8000078.1 cystathionine gamma-synthase [Gemmatimonadaceae bacterium] | diamond | 2334 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 25986144 | 25986144 | PRJNA737474f_S_NODE_171532_length_259_cov_1.166667_g170854_i0 | PRJNA737474 | 171532 | 259 | 1.166667 | 3.02166753 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g170854 | i0 | 96.97 | 0.127413127413127 | 33 | 0 | 13 | 1 | 197 | 229 | 5009523 | 5009492 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 33 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 26268483 | 26268483 | PRJNA737474g_S_NODE_439374_length_241_cov_0.904762_g438080_i0 | PRJNA737474 | 439374 | 241 | 0.904762 | 2.18047642 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 119 | 2.11e-22 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g438080 | i0 | 80.745 | 45.8215767634855 | 161 | 24 | 65 | 6 | 14 | 169 | 3088166 | 3088008 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 11043 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26270547 | 26270547 | PRJNA737474g_S_NODE_84774_length_343_cov_1.825926_g83480_i0 | PRJNA737474 | 84774 | 343 | 1.825926 | 6.26292618 | FCB group | 1783270 | Bacteria | Bacteria | 104 | 2.9099999999999996e-23 | NR | MBA2669744.1 | 2026742 | g83480 | i0 | 52.4 | 9.91836734693878 | 103 | 48 | 89.2 | 1 | 22 | 327 | 108 | 210 | MBA2669744.1 protein kinase [Gemmatimonadota bacterium] | diamond | 3402 | 105 | 0.990476190476191 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26522419 | 26522419 | PRJNA737474b_S_NODE_44680_length_246_cov_0.768786_g43641_i0 | PRJNA737474 | 44680 | 246 | 0.768786 | 1.89121356 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 70.9 | 3.82e-13 | NR | HEU4640827.1 | 2026741 | g43641 | i0 | 78.9 | 0.841463414634146 | 38 | 8 | 46.3 | 0 | 132 | 245 | 42 | 79 | HEU4640827.1 NIPSNAP family protein [Gemmatimonadaceae bacterium] | diamond | 207 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32919399 | 32919399 | PRJNA737474f_S_NODE_133201_length_274_cov_1.034826_g132523_i0 | PRJNA737474 | 133201 | 274 | 1.034826 | 2.83542324 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.9 | 0.0109 | NR | HET9798782.1 | 2026741 | g132523 | i0 | 32.2 | 0.952554744525547 | 87 | 50 | 93.1 | 4 | 10 | 264 | 79 | 158 | HET9798782.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 261 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32953358 | 32953358 | PRJNA737474d_S_NODE_28218_length_288_cov_2.195349_g27624_i0 | PRJNA737474 | 28218 | 288 | 2.195349 | 6.32260512 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.1 | 0.0453 | NR | HYD51287.1 | 2026741 | g27624 | i0 | 32.5 | 0.802083333333333 | 77 | 52 | 80.2 | 0 | 28 | 258 | 37 | 113 | HYD51287.1 class I SAM-dependent RNA methyltransferase [Gemmatimonadaceae bacterium] | diamond | 231 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32954094 | 32954094 | PRJNA737474f_S_NODE_264930_length_243_cov_1.011765_g264252_i0 | PRJNA737474 | 264930 | 243 | 1.011765 | 2.45858895 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 148 | 1.06e-43 | NR | MEW5919030.1 | 2026742 | g264252 | i0 | 93.5 | 0.950617283950617 | 77 | 5 | 95.1 | 0 | 232 | 2 | 58 | 134 | MEW5919030.1 salicylate hydroxylase [Gemmatimonadota bacterium] | diamond | 231 | 148 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32954682 | 32954682 | PRJNA737474g_S_NODE_172746_length_287_cov_1.705607_g171452_i0 | PRJNA737474 | 172746 | 287 | 1.705607 | 4.89509209 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 44.3 | 0.0134 | NR | HEX5724568.1 | 3047548 | g171452 | i0 | 36.3 | 0.951219512195122 | 91 | 41 | 80.5 | 4 | 22 | 252 | 23 | 110 | HEX5724568.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 273 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 32954893 | 32954893 | PRJNA737474g_S_NODE_252146_length_263_cov_1.700000_g250852_i0 | PRJNA737474 | 252146 | 263 | 1.7 | 4.471 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 54.7 | 2.97e-6 | NR | HZI29697.1 | 2026741 | g250852 | i0 | 39.4 | 4.6425855513308 | 71 | 43 | 81 | 0 | 40 | 252 | 626 | 696 | HZI29697.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 1221 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32958971 | 32958971 | PRJNA737474f_S_NODE_7890_length_733_cov_2.553030_g7297_i0 | PRJNA737474 | 7890 | 733 | 2.55303 | 18.7137099 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 162 | 8.64e-46 | NR | HEY9228765.1 | 2026741 | g7297 | i0 | 75 | 1.64529331514325 | 100 | 25 | 40.9 | 0 | 308 | 607 | 97 | 196 | HEY9228765.1 SMC-Scp complex subunit ScpB [Gemmatimonadaceae bacterium] | diamond | 1206 | 163 | 0.993865030674847 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32970931 | 32970931 | PRJNA737474f_S_NODE_14578_length_528_cov_4.123077_g13910_i0 | PRJNA737474 | 14578 | 528 | 4.123077 | 21.76984656 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 144 | 2.7599999999999997e-37 | NR | HUP00018.1 | 2026742 | g13910 | i0 | 57.7 | 1.35795454545455 | 123 | 48 | 69.9 | 2 | 2 | 370 | 328 | 446 | HUP00018.1 allantoinase AllB [Gemmatimonadota bacterium] | diamond | 717 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32993077 | 32993077 | PRJNA737474g_S_NODE_102923_length_325_cov_1.857143_g101629_i0 | PRJNA737474 | 102923 | 325 | 1.857143 | 6.03571475 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 7.59e-25 | NR | MBA2669828.1 | 2026742 | g101629 | i0 | 61.9 | 7.07076923076923 | 84 | 32 | 77.5 | 0 | 15 | 266 | 82 | 165 | MBA2669828.1 threonine ammonia-lyase [Gemmatimonadota bacterium] | diamond | 2298 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 33022065 | 33022065 | PRJNA737474f_S_NODE_16452_length_499_cov_1.326291_g15779_i0 | PRJNA737474 | 16452 | 499 | 1.326291 | 6.61819209 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 94.7 | 4.48e-19 | NR | HET6616550.1 | 2026742 | g15779 | i0 | 39.5 | 0.715430861723447 | 119 | 71 | 70.9 | 1 | 143 | 496 | 649 | 767 | HET6616550.1 isoleucine--tRNA ligase [Gemmatimonadota bacterium] | diamond | 357 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 33027274 | 33027274 | PRJNA737474g_S_NODE_20444_length_667_cov_2.309764_g19232_i0 | PRJNA737474 | 20444 | 667 | 2.309764 | 15.40612588 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 2.72e-23 | NR | HEX8696136.1 | 2029185 | g19232 | i0 | 58.3 | 0.926536731634183 | 108 | 45 | 48.6 | 0 | 332 | 9 | 23 | 130 | HEX8696136.1 hypothetical protein [Longimicrobium sp.] | diamond | 618 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 33056224 | 33056224 | PRJNA737474f_S_NODE_215101_length_249_cov_0.880682_g214423_i0 | PRJNA737474 | 215101 | 249 | 0.880682 | 2.19289818 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 51.2 | 3.2e-5 | NR | HLL46508.1 | 3047548 | g214423 | i0 | 40 | 2.57831325301205 | 65 | 36 | 78.3 | 3 | 2 | 196 | 80 | 141 | HLL46508.1 metallophosphoesterase [Longimicrobiaceae bacterium] | diamond | 642 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 33061249 | 33061249 | PRJNA737474g_S_NODE_231909_length_268_cov_4.020513_g230615_i0 | PRJNA737474 | 231909 | 268 | 4.020513 | 10.77497484 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 118 | 9.279999999999999e-30 | NR | MFL5561389.1 | 2026741 | g230615 | i0 | 78.9 | 3.13432835820896 | 71 | 15 | 79.5 | 0 | 233 | 21 | 6 | 76 | MFL5561389.1 NAD-dependent epimerase/dehydratase family protein [Gemmatimonadaceae bacterium] | diamond | 840 | 119 | 0.991596638655462 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 33107519 | 33107519 | PRJNA737474f_S_NODE_272526_length_242_cov_1.343195_g271848_i0 | PRJNA737474 | 272526 | 242 | 1.343195 | 3.2505319 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 81.3 | 5.94e-16 | NR | MBA2670853.1 | 2026742 | g271848 | i0 | 56.3 | 0.880165289256198 | 71 | 31 | 88 | 0 | 224 | 12 | 67 | 137 | MBA2670853.1 AAA family ATPase [Gemmatimonadota bacterium] | diamond | 213 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 33108339 | 33108339 | PRJNA737474g_S_NODE_272598_length_259_cov_0.935484_g271304_i0 | PRJNA737474 | 272598 | 259 | 0.935484 | 2.42290356 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 58.5 | 1.24e-7 | NR | WP_331876762.1 | 2029185 | g271304 | i0 | 44.4 | 2.77992277992278 | 72 | 33 | 78.8 | 2 | 233 | 30 | 419 | 487 | WP_331876762.1 amino acid adenylation domain-containing protein, partial [Longimicrobium sp.] | diamond | 720 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 33112281 | 33112281 | PRJNA737474f_S_NODE_322262_length_228_cov_2.135484_g321584_i0 | PRJNA737474 | 322262 | 228 | 2.135484 | 4.86890352 | Bacteria | 2 | Bacteria | Bacteria | 58.5 | 8.48e-8 | NR | MCI0432059.1 | 2026742 | g321584 | i0 | 45.3 | 4.11842105263158 | 64 | 32 | 84.2 | 1 | 1 | 192 | 278 | 338 | MCI0432059.1 serine hydrolase [Gemmatimonadota bacterium] | diamond | 939 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 33112371 | 33112371 | PRJNA737474g_S_NODE_145806_length_298_cov_2.906667_g144512_i0 | PRJNA737474 | 145806 | 298 | 2.906667 | 8.66186766 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.23e-27 | NR | MDX2059672.1 | 2448054 | g144512 | i0 | 86.7 | 1.20805369127517 | 60 | 8 | 60.4 | 0 | 253 | 74 | 197 | 256 | MDX2059672.1 enoyl-ACP reductase FabI [Gemmatimonadales bacterium] | diamond | 360 | 112 | 0.991071428571429 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33142424 | 33142424 | PRJNA737474g_S_NODE_265215_length_260_cov_2.106952_g263921_i0 | PRJNA737474 | 265215 | 260 | 2.106952 | 5.4780752 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 118 | 1.31e-29 | NR | HEY7480050.1 | 2448054 | g263921 | i0 | 76.7 | 1.68461538461538 | 73 | 17 | 84.2 | 0 | 259 | 41 | 318 | 390 | HEY7480050.1 zinc-dependent alcohol dehydrogenase [Gemmatimonadales bacterium] | diamond | 438 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33158671 | 33158671 | PRJNA737474f_S_NODE_39240_length_364_cov_2.044674_g38562_i0 | PRJNA737474 | 39240 | 364 | 2.044674 | 7.44261336 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 57 | 1.49e-6 | NR | MBP6444623.1 | 2448054 | g38562 | i0 | 44.1 | 2.20879120879121 | 68 | 35 | 54.4 | 2 | 360 | 163 | 144 | 210 | MBP6444623.1 M28 family peptidase [Gemmatimonadales bacterium] | diamond | 804 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33163753 | 33163753 | PRJNA737474g_S_NODE_91904_length_335_cov_2.312977_g90610_i0 | PRJNA737474 | 91904 | 335 | 2.312977 | 7.74847295 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.9 | 2.22e-11 | NR | OPX30730.1 | 1956166 | g90610 | i0 | 60.7 | 2.00597014925373 | 56 | 22 | 50.1 | 0 | 332 | 165 | 40 | 95 | OPX30730.1 MAG: co-chaperone GroES [Gemmatimonadaceae bacterium 4484_173] | diamond | 672 | 66.2 | 0.995468277945619 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium 4484_173 |
Advanced export
JSON shape: default, array, newline-delimited
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);;