contig_metadata
18 rows where bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1369372 | 1369372 | PRJEB49404_P_NODE_16782_length_1911_cov_3.402778_g11324_i0 | PRJEB49404 | 16782 | 1911 | 3.402778 | 65.02708758 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 2152 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g11324 | i0 | 87.221 | 107.526425954997 | 1925 | 202 | 99 | 39 | 2 | 1911 | 3044204 | 3042309 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 205483 | 2152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 5219640 | 5219640 | PRJEB49404_P_NODE_636145_length_153_cov_1.052632_g622344_i0 | PRJEB49404 | 636145 | 153 | 1.052632 | 1.61052696 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 250 | 4.14e-62 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g622344 | i0 | 96.078 | 88.0196078431373 | 153 | 6 | 100 | 0 | 1 | 153 | 2075209 | 2075057 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 13467 | 250 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 6495680 | 6495680 | PRJEB49404_P_NODE_642386_length_151_cov_2.642857_g628585_i0 | PRJEB49404 | 642386 | 151 | 2.642857 | 3.99071407 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 209 | 6.91e-50 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g628585 | i0 | 92.617 | 179.794701986755 | 149 | 6 | 97 | 4 | 3 | 149 | 1902961 | 1902816 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 27149 | 209 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 10321876 | 10321876 | PRJEB49404_P_NODE_90009_length_620_cov_2.617900_g76776_i0 | PRJEB49404 | 90009 | 620 | 2.6179 | 16.23098 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 785 | 0 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g76776 | i0 | 89.666 | 104.608064516129 | 629 | 48 | 100 | 11 | 1 | 620 | 1903620 | 1903000 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 64857 | 785 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 14134170 | 14134170 | PRJEB49404_P_NODE_399872_length_214_cov_1.457143_g386071_i0 | PRJEB49404 | 399872 | 214 | 1.457143 | 3.11828602 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 287 | 4.75e-73 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g386071 | i0 | 91.748 | 436.429906542056 | 206 | 17 | 96 | 0 | 9 | 214 | 1903906 | 1904111 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 93396 | 287 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18842738 | 18842738 | PRJEB49404_P_NODE_576515_length_164_cov_1.312000_g562714_i0 | PRJEB49404 | 576515 | 164 | 1.312 | 2.15168 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 93.6 | 1.57e-20 | NR | HET6763538.1 | 3047548 | g562714 | i0 | 81.5 | 8.85365853658537 | 54 | 10 | 98.8 | 0 | 2 | 163 | 702 | 755 | HET6763538.1 heavy metal translocating P-type ATPase [Longimicrobiaceae bacterium] | diamond | 1452 | 93.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 23061465 | 23061465 | PRJEB49404_P_NODE_475919_length_188_cov_2.201342_g462118_i0 | PRJEB49404 | 475919 | 188 | 2.201342 | 4.13852296 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 276 | 8.780000000000001e-70 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g462118 | i0 | 93.085 | 222.239361702128 | 188 | 13 | 100 | 0 | 1 | 188 | 172334 | 172521 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 41781 | 276 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 24343501 | 24343501 | PRJEB49404_P_NODE_645660_length_151_cov_1.455357_g631859_i0 | PRJEB49404 | 645660 | 151 | 1.455357 | 2.19758907 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 159 | 7.059999999999998e-35 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g631859 | i0 | 85.906 | 53.3576158940397 | 149 | 21 | 99 | 0 | 3 | 151 | 422858 | 423006 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 8057 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26653380 | 26653380 | PRJEB49404_P_NODE_515441_length_178_cov_1.179856_g501640_i0 | PRJEB49404 | 515441 | 178 | 1.179856 | 2.10014368 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 104 | 1.19e-25 | NR | MBC7843561.1 | 2026741 | g501640 | i0 | 76.3 | 0.99438202247191 | 59 | 14 | 99.4 | 0 | 2 | 178 | 22 | 80 | MBC7843561.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 177 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 26837089 | 26837089 | PRJEB49404_P_NODE_493501_length_183_cov_2.888889_g479700_i0 | PRJEB49404 | 493501 | 183 | 2.888889 | 5.28666687 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42 | 0.0255 | NR | MEE2899207.1 | 2026742 | g479700 | i0 | 41.4 | 1.9344262295082 | 58 | 31 | 93.4 | 2 | 9 | 179 | 13 | 68 | MEE2899207.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 354 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27437900 | 27437900 | PRJEB49404_P_NODE_347203_length_237_cov_2.212121_g333402_i0 | PRJEB49404 | 347203 | 237 | 2.212121 | 5.24272677 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 139 | 4.18e-37 | NR | HEX6748314.1 | 2029185 | g333402 | i0 | 76.9 | 3.9493670886076 | 78 | 18 | 98.7 | 0 | 2 | 235 | 369 | 446 | HEX6748314.1 epoxide hydrolase [Longimicrobium sp.] | diamond | 936 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 27911013 | 27911013 | PRJEB49404_P_NODE_271525_length_283_cov_2.196721_g257724_i0 | PRJEB49404 | 271525 | 283 | 2.196721 | 6.21672043 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 0.00129 | NR | MBA3406070.1 | 2026741 | g257724 | i0 | 46.3 | 0.795053003533569 | 41 | 22 | 43.5 | 0 | 131 | 9 | 1 | 41 | MBA3406070.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 225 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28044247 | 28044247 | PRJEB49404_P_NODE_502625_length_181_cov_1.591549_g488824_i0 | PRJEB49404 | 502625 | 181 | 1.591549 | 2.88070369 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 60.5 | 9.08e-9 | NR | MCC6430334.1 | 2026741 | g488824 | i0 | 56.7 | 1.95580110497238 | 60 | 26 | 99.4 | 0 | 2 | 181 | 56 | 115 | MCC6430334.1 IS66 family transposase [Gemmatimonadaceae bacterium] | diamond | 354 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29149770 | 29149770 | PRJEB49404_P_NODE_616849_length_156_cov_1.589744_g603048_i0 | PRJEB49404 | 616849 | 156 | 1.589744 | 2.48000064 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 92 | 1.14e-22 | NR | HZD84984.1 | 2026741 | g603048 | i0 | 90.2 | 0.980769230769231 | 51 | 5 | 98.1 | 0 | 2 | 154 | 43 | 93 | HZD84984.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium] | diamond | 153 | 92 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31423941 | 31423941 | PRJEB49404_P_NODE_613076_length_157_cov_1.322034_g599275_i0 | PRJEB49404 | 613076 | 157 | 1.322034 | 2.07559338 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 53.1 | 2.47e-6 | NR | HXI32920.1 | 2448054 | g599275 | i0 | 50 | 1.98726114649682 | 52 | 26 | 99.4 | 0 | 157 | 2 | 444 | 495 | HXI32920.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 312 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31740100 | 31740100 | PRJEB49404_P_NODE_585057_length_162_cov_1.764228_g571256_i0 | PRJEB49404 | 585057 | 162 | 1.764228 | 2.85804936 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 52.8 | 3.25e-6 | NR | HXW96391.1 | 2448054 | g571256 | i0 | 52.1 | 0.888888888888889 | 48 | 23 | 88.9 | 0 | 17 | 160 | 57 | 104 | HXW96391.1 class I SAM-dependent methyltransferase [Gemmatimonadales bacterium] | diamond | 144 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31834964 | 31834964 | PRJEB49404_P_NODE_381337_length_221_cov_2.653846_g367536_i0 | PRJEB49404 | 381337 | 221 | 2.653846 | 5.86499966 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 79.3 | 2.69e-15 | NR | HEX6535207.1 | 2026741 | g367536 | i0 | 66.1 | 0.841628959276018 | 62 | 20 | 84.2 | 1 | 189 | 4 | 168 | 228 | HEX6535207.1 OmpA family protein [Gemmatimonadaceae bacterium] | diamond | 186 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31891672 | 31891672 | PRJEB49404_P_NODE_473297_length_189_cov_1.760000_g459496_i0 | PRJEB49404 | 473297 | 189 | 1.76 | 3.3264 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 4.13e-17 | NR | WP_331876069.1 | 2029185 | g459496 | i0 | 65.1 | 9 | 63 | 22 | 100 | 0 | 189 | 1 | 532 | 594 | WP_331876069.1 toxin TcdB middle/N-terminal domain-containing protein, partial [Longimicrobium sp.] | diamond | 1701 | 85.1 | 0.990599294947121 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. |
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);;