contig_metadata
17 rows where bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5850342 | 5850342 | PRJNA770826_P_NODE_11445_length_238_cov_1.650794_g11274_i0 | PRJNA770826 | 11445 | 238 | 1.650794 | 3.92888972 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 78.6 | 7.83e-15 | NR | MEO7502219.1 | 2026741 | g11274 | i0 | 60 | 3.64285714285714 | 75 | 26 | 89.5 | 1 | 236 | 24 | 319 | 393 | MEO7502219.1 S8 family serine peptidase [Gemmatimonadaceae bacterium] | diamond | 867 | 78.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 5850363 | 5850363 | PRJNA770826_P_NODE_14565_length_211_cov_1.604938_g14394_i0 | PRJNA770826 | 14565 | 211 | 1.604938 | 3.38641918 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 92.8 | 5.22e-20 | NR | MEJ7809183.1 | 2026741 | g14394 | i0 | 69.4 | 13.2227488151659 | 62 | 19 | 88.2 | 0 | 210 | 25 | 345 | 406 | MEJ7809183.1 acyl-CoA carboxylase subunit beta [Gemmatimonadaceae bacterium] | diamond | 2790 | 92.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 8400075 | 8400075 | PRJNA770826_P_NODE_19067_length_185_cov_1.845588_g18896_i0 | PRJNA770826 | 19067 | 185 | 1.845588 | 3.4143378 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.6 | 2.13e-13 | NR | HIF20432.1 | 2026742 | g18896 | i0 | 67.2 | 2.96756756756757 | 61 | 17 | 98.9 | 2 | 184 | 2 | 309 | 366 | HIF20432.1 epoxide hydrolase [Gemmatimonadota bacterium] | diamond | 549 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 9675354 | 9675354 | PRJNA770826_P_NODE_34288_length_165_cov_0.896552_g34117_i0 | PRJNA770826 | 34288 | 165 | 0.896552 | 1.4793108 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 87.9 | 3.78e-13 | NTclustered | gi|2518596698|emb|OX639991.1| | 2910168 | g34117 | i0 | 82.692 | 0.866666666666667 | 104 | 13 | 61 | 4 | 57 | 156 | 870169 | 870271 | MAG: Longimicrobiales bacterium isolate affa3490-31b4-448a-b7fc-cc7950b7f85b genome assembly, chromosome: 1 | blastn | 143 | 87.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 13500733 | 13500733 | PRJNA770826_P_NODE_7111_length_310_cov_1.590038_g6940_i0 | PRJNA770826 | 7111 | 310 | 1.590038 | 4.9291178 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 451 | 2.44e-122 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g6940 | i0 | 92.926 | 186.841935483871 | 311 | 21 | 100 | 1 | 1 | 310 | 421302 | 421612 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 57921 | 451 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 28642038 | 28642038 | PRJNA770826_P_NODE_43567_length_162_cov_0.920354_g43396_i0 | PRJNA770826 | 43567 | 162 | 0.920354 | 1.49097348 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.00651 | NR | MBW3552209.1 | 2026742 | g43396 | i0 | 34.1 | 2.27777777777778 | 41 | 27 | 75.9 | 0 | 145 | 23 | 177 | 217 | MBW3552209.1 LLM class flavin-dependent oxidoreductase [Gemmatimonadota bacterium] | diamond | 369 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28758572 | 28758572 | PRJNA770826_P_NODE_37767_length_164_cov_0.904348_g37596_i0 | PRJNA770826 | 37767 | 164 | 0.904348 | 1.48313072 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 48.1 | 1.31e-4 | NR | MCH7475715.1 | 2026742 | g37596 | i0 | 52 | 0.914634146341463 | 50 | 22 | 89.6 | 2 | 156 | 10 | 123 | 171 | MCH7475715.1 CAP domain-containing protein [Gemmatimonadota bacterium] | diamond | 150 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29484550 | 29484550 | PRJNA770826_P_NODE_6850_length_317_cov_1.361940_g6679_i0 | PRJNA770826 | 6850 | 317 | 1.36194 | 4.3173498 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 117 | 3.28e-28 | NR | MEN8145548.1 | 2026742 | g6679 | i0 | 56 | 2.90536277602524 | 100 | 44 | 94.6 | 0 | 307 | 8 | 440 | 539 | MEN8145548.1 NAD-dependent malic enzyme [Gemmatimonadota bacterium] | diamond | 921 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30495754 | 30495754 | PRJNA770826_P_NODE_38873_length_163_cov_1.368421_g38702_i0 | PRJNA770826 | 38873 | 163 | 1.368421 | 2.23052623 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 41.6 | 0.0195 | NR | TVR53363.1 | 2448054 | g38702 | i0 | 46.5 | 0.791411042944785 | 43 | 22 | 77.3 | 1 | 22 | 147 | 2 | 44 | TVR53363.1 MAG: hypothetical protein EA421_11390 [Gemmatimonadales bacterium] | diamond | 129 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30874738 | 30874738 | PRJNA770826_P_NODE_35654_length_165_cov_0.896552_g35483_i0 | PRJNA770826 | 35654 | 165 | 0.896552 | 1.4793108 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 92.4 | 4.17e-20 | NR | MDE2804053.1 | 2026742 | g35483 | i0 | 72.7 | 4 | 55 | 13 | 100 | 1 | 165 | 1 | 106 | 158 | MDE2804053.1 aldehyde dehydrogenase family protein [Gemmatimonadota bacterium] | diamond | 660 | 92.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31127100 | 31127100 | PRJNA770826_P_NODE_13875_length_216_cov_1.544910_g13704_i0 | PRJNA770826 | 13875 | 216 | 1.54491 | 3.3370056 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 72 | 1.19e-12 | NR | HEX6631285.1 | 2026741 | g13704 | i0 | 51.3 | 1.93055555555556 | 76 | 33 | 100 | 2 | 1 | 216 | 223 | 298 | HEX6631285.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 417 | 72 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31728314 | 31728314 | PRJNA770826_P_NODE_43057_length_162_cov_0.920354_g42886_i0 | PRJNA770826 | 43057 | 162 | 0.920354 | 1.49097348 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.1 | 0.00131 | NR | HUF27274.1 | 2026741 | g42886 | i0 | 55.3 | 1.53703703703704 | 38 | 17 | 70.4 | 0 | 144 | 31 | 25 | 62 | HUF27274.1 CAP domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 249 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31759981 | 31759981 | PRJNA770826_P_NODE_25357_length_168_cov_1.310924_g25186_i0 | PRJNA770826 | 25357 | 168 | 1.310924 | 2.20235232 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 60.5 | 5.01e-9 | NR | MEX2473071.1 | 2026742 | g25186 | i0 | 56.6 | 6.625 | 53 | 23 | 94.6 | 0 | 167 | 9 | 137 | 189 | MEX2473071.1 slipin family protein [Gemmatimonadota bacterium] | diamond | 1113 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31801042 | 31801042 | PRJNA770826_P_NODE_32317_length_166_cov_0.888889_g32146_i0 | PRJNA770826 | 32317 | 166 | 0.888889 | 1.47555574 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 3.32e-5 | NR | MBT4500739.1 | 2026742 | g32146 | i0 | 45.3 | 1.8433734939759 | 53 | 28 | 94 | 1 | 6 | 161 | 254 | 306 | MBT4500739.1 choice-of-anchor D domain-containing protein [Gemmatimonadota bacterium] | diamond | 306 | 50.4 | 0.994047619047619 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32076422 | 32076422 | PRJNA770826_P_NODE_27838_length_168_cov_0.873950_g27667_i0 | PRJNA770826 | 27838 | 168 | 0.87395 | 1.468236 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 48.1 | 1.3e-4 | NR | MBP6442554.1 | 2448054 | g27667 | i0 | 45.9 | 1.48214285714286 | 37 | 20 | 66.1 | 0 | 55 | 165 | 91 | 127 | MBP6442554.1 carboxymuconolactone decarboxylase family protein [Gemmatimonadales bacterium] | diamond | 249 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32139758 | 32139758 | PRJNA770826_P_NODE_19978_length_181_cov_1.378788_g19807_i0 | PRJNA770826 | 19978 | 181 | 1.378788 | 2.49560628 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 79.3 | 2.07e-15 | NR | NNE08319.1 | 2026742 | g19807 | i0 | 59 | 1.01104972375691 | 61 | 24 | 99.4 | 1 | 2 | 181 | 215 | 275 | NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] | diamond | 183 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32551294 | 32551294 | PRJNA770826_P_NODE_12279_length_229_cov_1.733333_g12108_i0 | PRJNA770826 | 12279 | 229 | 1.733333 | 3.96933257 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 110 | 1.1300000000000002e-27 | NR | MBB29019.1 | 2026742 | g12108 | i0 | 71.1 | 2.98689956331878 | 76 | 22 | 99.6 | 0 | 228 | 1 | 169 | 244 | MBB29019.1 glucosamine-6-phosphate deaminase [Gemmatimonadota bacterium] | diamond | 684 | 110 | 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);;