contig_metadata
26 rows where bioproject = "PRJNA690592", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1946770 | 1946770 | PRJNA690592_S_NODE_107182_length_319_cov_0.918699_g106168_i0 | PRJNA690592 | 107182 | 319 | 0.918699 | 2.93064981 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 174 | 6.12e-39 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g106168 | i0 | 77.778 | 4.59247648902821 | 297 | 56 | 92 | 9 | 19 | 310 | 3177916 | 3177625 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 1465 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 2454250 | 2454250 | PRJNA690592_S_NODE_178202_length_256_cov_1.262295_g177188_i0 | PRJNA690592 | 178202 | 256 | 1.262295 | 3.2314752 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 68.9 | 2.52e-11 | NR | HET7552997.1 | 2026741 | g177188 | i0 | 47.4 | 1.7109375 | 78 | 38 | 89.1 | 2 | 254 | 27 | 99 | 175 | HET7552997.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 438 | 68.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 13424504 | 13424504 | PRJNA690592_S_NODE_101511_length_326_cov_0.909091_g100497_i0 | PRJNA690592 | 101511 | 326 | 0.909091 | 2.96363666 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 155 | 3.98e-42 | NR | HEX5727329.1 | 3047548 | g100497 | i0 | 68.9 | 0.975460122699387 | 106 | 33 | 97.5 | 0 | 321 | 4 | 476 | 581 | HEX5727329.1 DUF885 domain-containing protein [Longimicrobiaceae bacterium] | diamond | 318 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 17250009 | 17250009 | PRJNA690592_S_NODE_98014_length_330_cov_1.657588_g97000_i0 | PRJNA690592 | 98014 | 330 | 1.657588 | 5.4700404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 126 | 2.29e-33 | NR | MEZ4423172.1 | 2026742 | g97000 | i0 | 60.6 | 3.97272727272727 | 109 | 42 | 99.1 | 1 | 330 | 4 | 64 | 171 | MEZ4423172.1 SDR family oxidoreductase [Gemmatimonadota bacterium] | diamond | 1311 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27019195 | 27019195 | PRJNA690592_S_NODE_172062_length_260_cov_1.588235_g171048_i0 | PRJNA690592 | 172062 | 260 | 1.588235 | 4.129411 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.8 | 0.00363 | NR | HEU4628704.1 | 2026741 | g171048 | i0 | 43.6 | 0.634615384615385 | 55 | 30 | 63.5 | 1 | 10 | 174 | 334 | 387 | HEU4628704.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 165 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27050987 | 27050987 | PRJNA690592_S_NODE_53162_length_428_cov_1.946479_g52148_i0 | PRJNA690592 | 53162 | 428 | 1.946479 | 8.33093012 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 85.1 | 8.47e-17 | NR | HEX2210215.1 | 2029185 | g52148 | i0 | 46 | 2.09579439252336 | 100 | 53 | 69.4 | 1 | 5 | 301 | 149 | 248 | HEX2210215.1 DUF2382 domain-containing protein [Longimicrobium sp.] | diamond | 897 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 27504860 | 27504860 | PRJNA690592_S_NODE_200403_length_246_cov_1.011561_g199389_i0 | PRJNA690592 | 200403 | 246 | 1.011561 | 2.48844006 | Bacteria | 2 | Bacteria | Bacteria | 80.5 | 1.92e-16 | NR | HEY3287390.1 | 2026741 | g199389 | i0 | 55.4 | 1.46341463414634 | 65 | 28 | 79.3 | 1 | 229 | 35 | 133 | 196 | HEY3287390.1 carbonate dehydratase [Gemmatimonadaceae bacterium] | diamond | 360 | 80.9 | 0.995055624227441 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27714668 | 27714668 | PRJNA690592_S_NODE_13944_length_786_cov_2.723703_g13077_i0 | PRJNA690592 | 13944 | 786 | 2.723703 | 21.40830558 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 128 | 1.1699999999999998e-31 | NR | HRQ78234.1 | 2026741 | g13077 | i0 | 37.7 | 1.27480916030534 | 167 | 104 | 63.7 | 0 | 33 | 533 | 38 | 204 | HRQ78234.1 CAP domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 1002 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28250928 | 28250928 | PRJNA690592_S_NODE_34086_length_521_cov_2.133929_g33079_i0 | PRJNA690592 | 34086 | 521 | 2.133929 | 11.11777009 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 47.4 | 0.00325 | NR | HEX4933705.1 | 2026741 | g33079 | i0 | 25.9 | 0.777351247600768 | 135 | 88 | 70.8 | 3 | 516 | 148 | 5 | 139 | HEX4933705.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 405 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28314269 | 28314269 | PRJNA690592_S_NODE_209726_length_243_cov_0.905882_g208712_i0 | PRJNA690592 | 209726 | 243 | 0.905882 | 2.20129326 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 53.9 | 4.1e-6 | NR | HET6617441.1 | 2026742 | g208712 | i0 | 41.2 | 3.12345679012346 | 85 | 43 | 97.5 | 3 | 5 | 241 | 316 | 399 | HET6617441.1 sugar porter family MFS transporter [Gemmatimonadota bacterium] | diamond | 759 | 53.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28345798 | 28345798 | PRJNA690592_S_NODE_73246_length_373_cov_1.283333_g72232_i0 | PRJNA690592 | 73246 | 373 | 1.283333 | 4.78683209 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 79.3 | 1.79e-14 | NR | MEZ4415972.1 | 2026742 | g72232 | i0 | 46.2 | 0.731903485254692 | 91 | 40 | 70.8 | 2 | 34 | 297 | 296 | 380 | MEZ4415972.1 serine hydrolase domain-containing protein [Gemmatimonadota bacterium] | diamond | 273 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28377224 | 28377224 | PRJNA690592_S_NODE_184546_length_252_cov_1.122905_g183532_i0 | PRJNA690592 | 184546 | 252 | 1.122905 | 2.8297206 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 47 | 5.12e-4 | NR | MFQ5747496.1 | 2026742 | g183532 | i0 | 35.7 | 4.22619047619048 | 70 | 39 | 78.6 | 2 | 39 | 236 | 28 | 95 | MFQ5747496.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium] | diamond | 1065 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28609765 | 28609765 | PRJNA690592_S_NODE_146367_length_280_cov_1.115942_g145353_i0 | PRJNA690592 | 146367 | 280 | 1.115942 | 3.1246376 | Bacteria | 2 | Bacteria | Bacteria | 93.2 | 3.57e-21 | NR | MCH7932895.1 | 2026742 | g145353 | i0 | 59 | 7.21071428571429 | 83 | 33 | 88.9 | 1 | 3 | 251 | 127 | 208 | MCH7932895.1 aquaporin [Gemmatimonadota bacterium] | diamond | 2019 | 93.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28661537 | 28661537 | PRJNA690592_S_NODE_11287_length_862_cov_9.073511_g10495_i0 | PRJNA690592 | 11287 | 862 | 9.073511 | 78.21366482 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 9.98e-22 | NR | HEX7118166.1 | 2910168 | g10495 | i0 | 32.2 | 2.51624129930394 | 236 | 133 | 82.1 | 4 | 49 | 756 | 5 | 213 | HEX7118166.1 aquaporin [Longimicrobiales bacterium] | diamond | 2169 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 29999238 | 29999238 | PRJNA690592_S_NODE_153791_length_274_cov_1.149254_g152777_i0 | PRJNA690592 | 153791 | 274 | 1.149254 | 3.14895596 | Bacteria | 2 | Bacteria | Bacteria | 46.6 | 0.00244 | NR | MEE8446990.1 | 2026742 | g152777 | i0 | 52.6 | 1.71897810218978 | 38 | 18 | 41.6 | 0 | 234 | 121 | 7 | 44 | MEE8446990.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium] | diamond | 471 | 47 | 0.991489361702128 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30019392 | 30019392 | PRJNA690592_S_NODE_104571_length_322_cov_1.212851_g103557_i0 | PRJNA690592 | 104571 | 322 | 1.212851 | 3.90538022 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.1 | 2.41e-13 | NR | HKH91170.1 | 2026741 | g103557 | i0 | 56.6 | 0.708074534161491 | 76 | 33 | 70.8 | 0 | 2 | 229 | 232 | 307 | HKH91170.1 DUF2382 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 228 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30252047 | 30252047 | PRJNA690592_S_NODE_218892_length_231_cov_3.367089_g217878_i0 | PRJNA690592 | 218892 | 231 | 3.367089 | 7.77797559 | Longimicrobium | 1804994 | Bacteria | Bacteria | 94 | 1.45e-20 | NR | HEU0013587.1 | 2029185 | g217878 | i0 | 56.6 | 7.8961038961039 | 76 | 33 | 98.7 | 0 | 3 | 230 | 91 | 166 | HEU0013587.1 molybdopterin-synthase adenylyltransferase MoeB [Longimicrobium sp.] | diamond | 1824 | 94 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30304116 | 30304116 | PRJNA690592_S_NODE_175672_length_258_cov_1.048649_g174658_i0 | PRJNA690592 | 175672 | 258 | 1.048649 | 2.70551442 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 86.7 | 1.59e-17 | NR | NIM49516.1 | 2448054 | g174658 | i0 | 47.1 | 1.01162790697674 | 87 | 43 | 97.7 | 1 | 3 | 254 | 568 | 654 | NIM49516.1 tandem-95 repeat protein [Gemmatimonadales bacterium] | diamond | 261 | 86.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31042084 | 31042084 | PRJNA690592_S_NODE_212695_length_242_cov_0.911243_g211681_i0 | PRJNA690592 | 212695 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.5 | 3.35e-4 | NR | HEX3867004.1 | 2026741 | g211681 | i0 | 41 | 1.82231404958678 | 78 | 34 | 85.5 | 2 | 1 | 207 | 175 | 249 | HEX3867004.1 putative Ig domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 441 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31093533 | 31093533 | PRJNA690592_S_NODE_190775_length_249_cov_1.750000_g189761_i0 | PRJNA690592 | 190775 | 249 | 1.75 | 4.3575 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 77 | 9.91e-15 | NR | MEX2473071.1 | 2026742 | g189761 | i0 | 52.5 | 1.93975903614458 | 80 | 38 | 96.4 | 0 | 3 | 242 | 125 | 204 | MEX2473071.1 slipin family protein [Gemmatimonadota bacterium] | diamond | 483 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31473039 | 31473039 | PRJNA690592_S_NODE_107396_length_318_cov_1.975510_g106382_i0 | PRJNA690592 | 107396 | 318 | 1.97551 | 6.2821218 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 52.4 | 3.81e-5 | NR | PYP69836.1 | 2026742 | g106382 | i0 | 68.8 | 0.30188679245283 | 32 | 10 | 30.2 | 0 | 4 | 99 | 1 | 32 | PYP69836.1 MAG: hypothetical protein DMD36_08525, partial [Gemmatimonadota bacterium] | diamond | 96 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31504710 | 31504710 | PRJNA690592_S_NODE_13096_length_809_cov_4.089674_g12249_i0 | PRJNA690592 | 13096 | 809 | 4.089674 | 33.08546266 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 58.2 | 1.11e-5 | NR | MFO7586795.1 | 2026742 | g12249 | i0 | 50.9 | 1.99134734239802 | 57 | 28 | 21.1 | 0 | 807 | 637 | 251 | 307 | MFO7586795.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 1611 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31789045 | 31789045 | PRJNA690592_S_NODE_22157_length_636_cov_2.310835_g21179_i0 | PRJNA690592 | 22157 | 636 | 2.310835 | 14.6969106 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 82.8 | 4.46e-15 | NR | HEX6372403.1 | 2029185 | g21179 | i0 | 48.1 | 1.47641509433962 | 104 | 53 | 48.6 | 1 | 315 | 7 | 135 | 238 | HEX6372403.1 DUF2382 domain-containing protein [Longimicrobium sp.] | diamond | 939 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32327546 | 32327546 | PRJNA690592_S_NODE_214199_length_241_cov_1.375000_g213185_i0 | PRJNA690592 | 214199 | 241 | 1.375 | 3.31375 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 77.8 | 1.9e-15 | NR | HEX5577042.1 | 2026741 | g213185 | i0 | 46.8 | 0.983402489626556 | 79 | 42 | 98.3 | 0 | 237 | 1 | 3 | 81 | HEX5577042.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium] | diamond | 237 | 77.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32390520 | 32390520 | PRJNA690592_S_NODE_87699_length_345_cov_2.360294_g86685_i0 | PRJNA690592 | 87699 | 345 | 2.360294 | 8.1430143 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 67 | 1.13e-10 | NR | HEX2080112.1 | 2029185 | g86685 | i0 | 37.1 | 1.6 | 105 | 59 | 87 | 2 | 46 | 345 | 88 | 190 | HEX2080112.1 hypothetical protein [Longimicrobium sp.] | diamond | 552 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32737768 | 32737768 | PRJNA690592_S_NODE_153520_length_274_cov_1.532338_g152506_i0 | PRJNA690592 | 153520 | 274 | 1.532338 | 4.19860612 | Gemmatimonadetes bacterium 13_1_4 | 1805192 | Bacteria | Bacteria | 90.5 | 5.42e-19 | NR | OLC45040.1 | 1805192 | g152506 | i0 | 64.9 | 2.52919708029197 | 77 | 26 | 84.3 | 1 | 6 | 236 | 328 | 403 | OLC45040.1 MAG: MFS transporter [Gemmatimonadetes bacterium 13_1_40CM_4_69_5] | diamond | 693 | 90.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium 13_1_40CM_4_69_5 |
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);;