contig_metadata
23 rows where bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278355 | 278355 | PRJNA1123309_P_NODE_34261_length_285_cov_1.014151_g33881_i0 | PRJNA1123309 | 34261 | 285 | 1.014151 | 2.89033035 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 364 | 2.9799999999999998e-96 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g33881 | i0 | 91.923 | 129.238596491228 | 260 | 21 | 91 | 0 | 1 | 260 | 423157 | 422898 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 36833 | 364 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 2304328 | 2304328 | PRJNA1123309_P_NODE_42842_length_263_cov_1.768421_g42462_i0 | PRJNA1123309 | 42842 | 263 | 1.768421 | 4.65094723 | Gemmatimonas | 173479 | Bacteria | Bacteria | 398 | 2.6799999999999995e-106 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g42462 | i0 | 95.219 | 131.140684410646 | 251 | 12 | 95 | 0 | 5 | 255 | 1229 | 979 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 34490 | 398 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 4105468 | 4105468 | PRJNA1123309_P_NODE_43884_length_261_cov_1.111702_g43504_i0 | PRJNA1123309 | 43884 | 261 | 1.111702 | 2.90154222 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 364 | 2.689999999999999e-96 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g43504 | i0 | 92.578 | 103.103448275862 | 256 | 16 | 97 | 2 | 8 | 261 | 3043018 | 3043272 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 26910 | 364 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 5381472 | 5381472 | PRJNA1123309_P_NODE_36385_length_279_cov_1.941748_g36005_i0 | PRJNA1123309 | 36385 | 279 | 1.941748 | 5.41747692 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 104 | 6.99e-18 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g36005 | i0 | 90.909 | 0.275985663082437 | 77 | 7 | 28 | 0 | 2 | 78 | 1630188 | 1630264 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 77 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 7931443 | 7931443 | PRJNA1123309_P_NODE_53007_length_250_cov_0.881356_g52627_i0 | PRJNA1123309 | 53007 | 250 | 0.881356 | 2.20339 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 257 | 4.47e-64 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g52627 | i0 | 85.542 | 17.368 | 249 | 32 | 99 | 3 | 4 | 250 | 3208422 | 3208668 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 4342 | 257 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 9206293 | 9206293 | PRJNA1123309_P_NODE_36388_length_279_cov_1.888350_g36008_i0 | PRJNA1123309 | 36388 | 279 | 1.88835 | 5.2684965 | Gemmatimonas aurantiaca | 173480 | Bacteria | Bacteria | 113 | 1.16e-20 | NTclustered | gi|226088597|dbj|AP009153.1| | 379066 | g36008 | i0 | 82.308 | 0.46594982078853 | 130 | 23 | 47 | 0 | 22 | 151 | 175630 | 175501 | Gemmatimonas aurantiaca T-27 DNA, complete genome | blastn | 130 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 13032171 | 13032171 | PRJNA1123309_P_NODE_55591_length_248_cov_0.891429_g55211_i0 | PRJNA1123309 | 55591 | 248 | 0.891429 | 2.21074392 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 122 | 3.5899999999999995e-32 | NR | HEY0780140.1 | 2510638 | g55211 | i0 | 71.6 | 0.979838709677419 | 81 | 23 | 98 | 0 | 246 | 4 | 42 | 122 | HEY0780140.1 CheB methylesterase domain-containing protein [Gemmatirosa sp.] | diamond | 243 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 14307278 | 14307278 | PRJNA1123309_P_NODE_43412_length_262_cov_1.343915_g43032_i0 | PRJNA1123309 | 43412 | 262 | 1.343915 | 3.5210573 | uncultured Gemmatimonas sp. | 221169 | Bacteria | Bacteria | 457 | 4.34e-124 | NTclustered | gi|2908993102|gb|PV095908.1| | 221169 | g43032 | i0 | 99.213 | 96.5725190839695 | 254 | 1 | 97 | 1 | 10 | 262 | 158 | 411 | Uncultured Gemmatimonas sp. clone b95e052ff97de7274ac009cc16b7aba4 16S ribosomal RNA gene, partial sequence | blastn | 25302 | 457 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | uncultured Gemmatimonas sp. | |
| 21955325 | 21955325 | PRJNA1123309_P_NODE_56498_length_248_cov_0.880000_g56118_i0 | PRJNA1123309 | 56498 | 248 | 0.88 | 2.1824 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 231 | 2.68e-56 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g56118 | i0 | 85.973 | 161.895161290323 | 221 | 25 | 88 | 5 | 32 | 248 | 171553 | 171771 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 40150 | 231 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26679327 | 26679327 | PRJNA1123309_P_NODE_47981_length_253_cov_0.866667_g47601_i0 | PRJNA1123309 | 47981 | 253 | 0.866667 | 2.19266751 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 136 | 5.08e-36 | NR | WP_025415014.1 | 861299 | g47601 | i0 | 81 | 3.77075098814229 | 79 | 15 | 93.7 | 0 | 251 | 15 | 339 | 417 | WP_025415014.1 acetylxylan esterase [Gemmatirosa kalamazoonensis] | diamond | 954 | 136 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 27059411 | 27059411 | PRJNA1123309_P_NODE_65722_length_242_cov_0.923077_g65342_i0 | PRJNA1123309 | 65722 | 242 | 0.923077 | 2.23384634 | Gemmatimonas | 173479 | Bacteria | Bacteria | 42 | 0.0426 | NR | WP_291162412.1 | 1946568 | g65342 | i0 | 57.6 | 1.22727272727273 | 33 | 14 | 40.9 | 0 | 20 | 118 | 134 | 166 | WP_291162412.1 hypothetical protein [Gemmatimonas sp. UBA7669] | diamond | 297 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. UBA7669 | |
| 27639046 | 27639046 | PRJNA1123309_P_NODE_50524_length_251_cov_0.876404_g50144_i0 | PRJNA1123309 | 50524 | 251 | 0.876404 | 2.19977404 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 61.6 | 3.53e-9 | NR | MBI3792292.1 | 2026742 | g50144 | i0 | 56.5 | 3.1792828685259 | 62 | 22 | 71.7 | 2 | 186 | 7 | 13 | 71 | MBI3792292.1 SCO family protein [Gemmatimonadota bacterium] | diamond | 798 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27765367 | 27765367 | PRJNA1123309_P_NODE_38104_length_275_cov_1.534653_g37724_i0 | PRJNA1123309 | 38104 | 275 | 1.534653 | 4.22029575 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 171 | 1.07e-47 | NR | HEX6559043.1 | 2910168 | g37724 | i0 | 85.6 | 1.96363636363636 | 90 | 13 | 98.2 | 0 | 2 | 271 | 561 | 650 | HEX6559043.1 outer membrane protein assembly factor BamA [Longimicrobiales bacterium] | diamond | 540 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 28396626 | 28396626 | PRJNA1123309_P_NODE_62566_length_244_cov_0.912281_g62186_i0 | PRJNA1123309 | 62566 | 244 | 0.912281 | 2.22596564 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 117 | 2.7000000000000003e-28 | NR | HEX2779855.1 | 2026741 | g62186 | i0 | 66.7 | 0.959016393442623 | 78 | 26 | 95.9 | 0 | 236 | 3 | 735 | 812 | HEX2779855.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 234 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28543946 | 28543946 | PRJNA1123309_P_NODE_57807_length_247_cov_0.896552_g57427_i0 | PRJNA1123309 | 57807 | 247 | 0.896552 | 2.21448344 | Bacteria | 2 | Bacteria | Bacteria | 116 | 6.91e-30 | NR | MDQ3208438.1 | 2026742 | g57427 | i0 | 90 | 1.7004048582996 | 70 | 7 | 85 | 0 | 38 | 247 | 1 | 70 | MDQ3208438.1 cytochrome c [Gemmatimonadota bacterium] | diamond | 420 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28870174 | 28870174 | PRJNA1123309_P_NODE_38968_length_273_cov_1.475000_g38588_i0 | PRJNA1123309 | 38968 | 273 | 1.475 | 4.02675 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 48.1 | 3.96e-4 | NR | HEX9705446.1 | 2448054 | g38588 | i0 | 38.8 | 0.934065934065934 | 85 | 48 | 89 | 1 | 28 | 270 | 20 | 104 | HEX9705446.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 255 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28901640 | 28901640 | PRJNA1123309_P_NODE_5688_length_614_cov_0.955638_g5339_i0 | PRJNA1123309 | 5688 | 614 | 0.955638 | 5.86761732 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 47.8 | 0.0154 | NR | HEY4130013.1 | 2026741 | g5339 | i0 | 34 | 0.503257328990228 | 103 | 60 | 47.4 | 3 | 372 | 82 | 169 | 269 | HEY4130013.1 DNA recombination protein RmuC [Gemmatimonadaceae bacterium] | diamond | 309 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29406963 | 29406963 | PRJNA1123309_P_NODE_64689_length_243_cov_0.917647_g64309_i0 | PRJNA1123309 | 64689 | 243 | 0.917647 | 2.22988221 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 56.6 | 4.95e-7 | NR | HEY7611715.1 | 2448054 | g64309 | i0 | 54.3 | 0.567901234567901 | 46 | 20 | 55.6 | 1 | 31 | 165 | 430 | 475 | HEY7611715.1 PAS domain S-box protein [Gemmatimonadales bacterium] | diamond | 138 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29533321 | 29533321 | PRJNA1123309_P_NODE_6990_length_562_cov_1.196319_g6629_i0 | PRJNA1123309 | 6990 | 562 | 1.196319 | 6.72331278 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 46.2 | 0.0415 | NR | GJG88030.1 | 2839016 | g6629 | i0 | 35.2 | 0.469750889679715 | 88 | 48 | 47 | 2 | 165 | 428 | 58 | 136 | GJG88030.1 penicillin-binding protein [Gemmatimonadetes bacterium T265] | diamond | 264 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 30291780 | 30291780 | PRJNA1123309_P_NODE_64692_length_243_cov_0.917647_g64312_i0 | PRJNA1123309 | 64692 | 243 | 0.917647 | 2.22988221 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 118 | 1.08e-29 | NR | HJR15400.1 | 2448054 | g64312 | i0 | 76.6 | 1.88888888888889 | 77 | 16 | 95.1 | 1 | 234 | 4 | 263 | 337 | HJR15400.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 459 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30575471 | 30575471 | PRJNA1123309_P_NODE_42973_length_263_cov_1.410526_g42593_i0 | PRJNA1123309 | 42973 | 263 | 1.410526 | 3.70968338 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 42.7 | 0.0443 | NR | HVH13180.1 | 2029185 | g42593 | i0 | 37.3 | 0.855513307984791 | 75 | 42 | 82.1 | 2 | 253 | 38 | 141 | 213 | HVH13180.1 diguanylate cyclase [Longimicrobium sp.] | diamond | 225 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30891839 | 30891839 | PRJNA1123309_P_NODE_60634_length_245_cov_0.906977_g60254_i0 | PRJNA1123309 | 60634 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 165 | 2.7399999999999997e-48 | NR | MFL5562939.1 | 2026741 | g60254 | i0 | 93.6 | 0.955102040816327 | 78 | 5 | 95.5 | 0 | 6 | 239 | 227 | 304 | MFL5562939.1 lipoate--protein ligase [Gemmatimonadaceae bacterium] | diamond | 234 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31966643 | 31966643 | PRJNA1123309_P_NODE_48078_length_253_cov_0.866667_g47698_i0 | PRJNA1123309 | 48078 | 253 | 0.866667 | 2.19266751 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 56.2 | 2.25e-7 | NR | MBK7786953.1 | 2026742 | g47698 | i0 | 40.5 | 0.936758893280632 | 79 | 37 | 92.5 | 2 | 237 | 4 | 101 | 170 | MBK7786953.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 237 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium |
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);;