contig_metadata
26 rows where bioproject = "PRJNA557436", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18387600 | 18387600 | PRJNA557436_S_NODE_5675_length_176_cov_1.567376_g5627_i0 | PRJNA557436 | 5675 | 176 | 1.567376 | 2.75858176 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.13e-29 | NR | WP_353268876.1 | 1962908 | g5627 | i0 | 87.9 | 5.93181818181818 | 58 | 7 | 98.9 | 0 | 175 | 2 | 3 | 60 | WP_353268876.1 DNA cytosine methyltransferase [Gemmatimonas sp.] | diamond | 1044 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 27110249 | 27110249 | PRJNA557436_S_NODE_6442_length_169_cov_1.261194_g6394_i0 | PRJNA557436 | 6442 | 169 | 1.261194 | 2.13141786 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 62 | 1.46e-9 | NR | MBA2683778.1 | 2026741 | g6394 | i0 | 53.6 | 0.994082840236686 | 56 | 25 | 97.6 | 1 | 167 | 3 | 67 | 122 | MBA2683778.1 PD-(D/E)XK nuclease-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 168 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27868381 | 27868381 | PRJNA557436_S_NODE_2685_length_233_cov_1.727273_g2637_i0 | PRJNA557436 | 2685 | 233 | 1.727273 | 4.02454609 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 84.7 | 5.5e-17 | NR | MBK7786840.1 | 2026742 | g2637 | i0 | 69.5 | 0.759656652360515 | 59 | 18 | 76 | 0 | 179 | 3 | 182 | 240 | MBK7786840.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 177 | 84.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27931671 | 27931671 | PRJNA557436_S_NODE_4225_length_196_cov_1.534161_g4177_i0 | PRJNA557436 | 4225 | 196 | 1.534161 | 3.00695556 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 47.8 | 2.89e-4 | NR | MBK8006763.1 | 2026742 | g4177 | i0 | 54.2 | 0.73469387755102 | 48 | 22 | 73.5 | 0 | 51 | 194 | 36 | 83 | MBK8006763.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 144 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28436969 | 28436969 | PRJNA557436_S_NODE_3246_length_216_cov_1.790055_g3198_i0 | PRJNA557436 | 3246 | 216 | 1.790055 | 3.8665188 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 93.2 | 5.07e-21 | NR | MCR4338513.1 | 2026741 | g3198 | i0 | 79.7 | 1.63888888888889 | 59 | 12 | 81.9 | 0 | 179 | 3 | 1 | 59 | MCR4338513.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 354 | 93.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28657999 | 28657999 | PRJNA557436_S_NODE_6767_length_166_cov_1.610687_g6719_i0 | PRJNA557436 | 6767 | 166 | 1.610687 | 2.67374042 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 54.3 | 1.08e-6 | NR | MQA91969.1 | 1962908 | g6719 | i0 | 50 | 1.7710843373494 | 48 | 24 | 86.7 | 0 | 13 | 156 | 78 | 125 | MQA91969.1 DUF932 domain-containing protein [Gemmatimonas sp.] | diamond | 294 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 29163299 | 29163299 | PRJNA557436_S_NODE_5369_length_180_cov_1.413793_g5321_i0 | PRJNA557436 | 5369 | 180 | 1.413793 | 2.5448274 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 57.8 | 8.1e-8 | NR | MBK7352201.1 | 2026742 | g5321 | i0 | 73 | 1.23333333333333 | 37 | 10 | 61.7 | 0 | 70 | 180 | 1 | 37 | MBK7352201.1 DEAD/DEAH box helicase family protein [Gemmatimonadota bacterium] | diamond | 222 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29871820 | 29871820 | PRJNA557436_S_NODE_8291_length_156_cov_1.280992_g8243_i0 | PRJNA557436 | 8291 | 156 | 1.280992 | 1.99834752 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.5 | 1.81e-12 | NR | HEX4936991.1 | 2026741 | g8243 | i0 | 64 | 1.90384615384615 | 50 | 18 | 96.2 | 0 | 151 | 2 | 216 | 265 | HEX4936991.1 phage terminase large subunit [Gemmatimonadaceae bacterium] | diamond | 297 | 70.9 | 0.994358251057828 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30029871 | 30029871 | PRJNA557436_S_NODE_5871_length_174_cov_1.474820_g5823_i0 | PRJNA557436 | 5871 | 174 | 1.47482 | 2.5661868 | FCB group | 1783270 | Bacteria | Bacteria | 82.8 | 5.05e-17 | NR | MBK8251033.1 | 2026742 | g5823 | i0 | 88.4 | 2.22413793103448 | 43 | 5 | 74.1 | 0 | 130 | 2 | 1 | 43 | MBK8251033.1 DNA adenine methylase [Gemmatimonadota bacterium] | diamond | 387 | 83.6 | 0.990430622009569 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30141600 | 30141600 | PRJNA557436_S_NODE_692_length_426_cov_2.578005_g644_i0 | PRJNA557436 | 692 | 426 | 2.578005 | 10.9823013 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 62 | 8.75e-9 | NR | MBK7786953.1 | 2026742 | g644 | i0 | 40 | 0.598591549295775 | 85 | 41 | 59.2 | 2 | 337 | 86 | 97 | 172 | MBK7786953.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 255 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30204948 | 30204948 | PRJNA557436_S_NODE_9032_length_152_cov_1.914530_g8984_i0 | PRJNA557436 | 9032 | 152 | 1.91453 | 2.9100856 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.9 | 0.00418 | NR | HXB28089.1 | 2026741 | g8984 | i0 | 84 | 0.493421052631579 | 25 | 4 | 49.3 | 0 | 148 | 74 | 310 | 334 | HXB28089.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Gemmatimonadaceae bacterium] | diamond | 75 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30489611 | 30489611 | PRJNA557436_S_NODE_6493_length_168_cov_2.165414_g6445_i0 | PRJNA557436 | 6493 | 168 | 2.165414 | 3.63789552 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 46.6 | 7.25e-5 | NR | MFL5381283.1 | 3047548 | g6445 | i0 | 50 | 0.785714285714286 | 44 | 13 | 62.5 | 2 | 37 | 141 | 30 | 73 | MFL5381283.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 132 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 30584177 | 30584177 | PRJNA557436_S_NODE_5533_length_178_cov_1.230769_g5485_i0 | PRJNA557436 | 5533 | 178 | 1.230769 | 2.19076882 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 129 | 2.9699999999999993e-34 | NR | MBP9106036.1 | 2026741 | g5485 | i0 | 98.3 | 0.97752808988764 | 58 | 1 | 97.8 | 0 | 176 | 3 | 297 | 354 | MBP9106036.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 174 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30710690 | 30710690 | PRJNA557436_S_NODE_5694_length_176_cov_1.418440_g5646_i0 | PRJNA557436 | 5694 | 176 | 1.41844 | 2.4964544 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 119 | 2.66e-31 | NR | MBP7622037.1 | 2448054 | g5646 | i0 | 98.3 | 0.988636363636364 | 58 | 1 | 98.9 | 0 | 1 | 174 | 82 | 139 | MBP7622037.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 174 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30805566 | 30805566 | PRJNA557436_S_NODE_7734_length_159_cov_1.943548_g7686_i0 | PRJNA557436 | 7734 | 159 | 1.943548 | 3.09024132 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 78.2 | 3.81e-15 | NR | MBK7352201.1 | 2026742 | g7686 | i0 | 69.2 | 1.9622641509434 | 52 | 16 | 98.1 | 0 | 156 | 1 | 31 | 82 | MBK7352201.1 DEAD/DEAH box helicase family protein [Gemmatimonadota bacterium] | diamond | 312 | 78.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30900448 | 30900448 | PRJNA557436_S_NODE_2874_length_226_cov_2.727749_g2826_i0 | PRJNA557436 | 2874 | 226 | 2.727749 | 6.16471274 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 79.7 | 7.93e-16 | NR | MCR4338513.1 | 2026741 | g2826 | i0 | 68.4 | 0.756637168141593 | 57 | 18 | 75.7 | 0 | 1 | 171 | 215 | 271 | MCR4338513.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 171 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30931985 | 30931985 | PRJNA557436_S_NODE_8634_length_154_cov_1.596639_g8586_i0 | PRJNA557436 | 8634 | 154 | 1.596639 | 2.45882406 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 54.3 | 8.84e-7 | NR | MBK7786849.1 | 2026742 | g8586 | i0 | 61 | 3.37012987012987 | 41 | 16 | 79.9 | 0 | 12 | 134 | 37 | 77 | MBK7786849.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 519 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31026859 | 31026859 | PRJNA557436_S_NODE_795_length_400_cov_1.780822_g747_i0 | PRJNA557436 | 795 | 400 | 1.780822 | 7.123288 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 131 | 6.55e-36 | NR | TFG65467.1 | 2448054 | g747 | i0 | 67.9 | 0.585 | 78 | 25 | 58.5 | 0 | 166 | 399 | 46 | 123 | TFG65467.1 MAG: class I SAM-dependent methyltransferase [Gemmatimonadales bacterium] | diamond | 234 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31501115 | 31501115 | PRJNA557436_S_NODE_1596_length_293_cov_2.368217_g1548_i0 | PRJNA557436 | 1596 | 293 | 2.368217 | 6.93887581 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 103 | 1.9699999999999998e-23 | NR | MBK7352201.1 | 2026742 | g1548 | i0 | 55.6 | 2.02730375426621 | 99 | 42 | 99.3 | 2 | 292 | 2 | 347 | 445 | MBK7352201.1 DEAD/DEAH box helicase family protein [Gemmatimonadota bacterium] | diamond | 594 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31785403 | 31785403 | PRJNA557436_S_NODE_3837_length_203_cov_1.172619_g3789_i0 | PRJNA557436 | 3837 | 203 | 1.172619 | 2.38041657 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 55.8 | 4.76e-7 | NR | MCR4338329.1 | 2026741 | g3789 | i0 | 48.3 | 0.886699507389163 | 60 | 30 | 88.7 | 1 | 23 | 202 | 254 | 312 | MCR4338329.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 180 | 55.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31943616 | 31943616 | PRJNA557436_S_NODE_7777_length_159_cov_1.483871_g7729_i0 | PRJNA557436 | 7777 | 159 | 1.483871 | 2.35935489 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 70.5 | 6.79e-14 | NR | MBK8251035.1 | 2026742 | g7729 | i0 | 78 | 0.773584905660377 | 41 | 9 | 77.4 | 0 | 125 | 3 | 1 | 41 | MBK8251035.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 123 | 70.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31957818 | 31957818 | PRJNA557436_S_NODE_3537_length_209_cov_1.965517_g3489_i0 | PRJNA557436 | 3537 | 209 | 1.965517 | 4.10793053 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 110 | 1.93e-26 | NR | MBK7352201.1 | 2026742 | g3489 | i0 | 73.5 | 1.95215311004785 | 68 | 18 | 97.6 | 0 | 2 | 205 | 193 | 260 | MBK7352201.1 DEAD/DEAH box helicase family protein [Gemmatimonadota bacterium] | diamond | 408 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31975416 | 31975416 | PRJNA557436_S_NODE_5958_length_173_cov_1.811594_g5910_i0 | PRJNA557436 | 5958 | 173 | 1.811594 | 3.13405762 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42.4 | 0.0202 | NR | HEY2066437.1 | 2026741 | g5910 | i0 | 47.4 | 0.658959537572254 | 38 | 19 | 64.2 | 1 | 118 | 8 | 538 | 575 | HEY2066437.1 2Fe-2S iron-sulfur cluster-binding protein [Gemmatimonadaceae bacterium] | diamond | 114 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32070346 | 32070346 | PRJNA557436_S_NODE_7138_length_163_cov_1.906250_g7090_i0 | PRJNA557436 | 7138 | 163 | 1.90625 | 3.1071875 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 80.1 | 2.81e-17 | NR | HEX4935563.1 | 2026741 | g7090 | i0 | 75 | 0.957055214723926 | 52 | 13 | 95.7 | 0 | 161 | 6 | 12 | 63 | HEX4935563.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 156 | 80.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32418481 | 32418481 | PRJNA557436_S_NODE_6019_length_173_cov_1.144928_g5971_i0 | PRJNA557436 | 6019 | 173 | 1.144928 | 1.98072544 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 125 | 2.08e-33 | NR | MBP7622037.1 | 2448054 | g5971 | i0 | 100 | 0.988439306358382 | 57 | 0 | 98.8 | 0 | 3 | 173 | 15 | 71 | MBP7622037.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 171 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32891284 | 32891284 | PRJNA557436_S_NODE_9160_length_152_cov_1.213675_g9112_i0 | PRJNA557436 | 9160 | 152 | 1.213675 | 1.844786 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 48.9 | 7.12e-5 | NR | MDP9203647.1 | 2026742 | g9112 | i0 | 56.5 | 0.907894736842105 | 46 | 20 | 90.8 | 0 | 9 | 146 | 102 | 147 | MDP9203647.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 138 | 48.9 | 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);;