contig_metadata
16 rows where bioproject = "PRJNA533114", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 504439 | 504439 | PRJNA533114_P_NODE_104581_length_247_cov_0.885057_g104329_i0 | PRJNA533114 | 104581 | 247 | 0.885057 | 2.18609079 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 116 | 8.39e-31 | NR | MBL8086383.1 | 2711154 | g104329 | i0 | 74.7 | 0.959514170040486 | 79 | 19 | 94.7 | 1 | 246 | 13 | 65 | 143 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 237 | 116 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 4332167 | 4332167 | PRJNA533114_P_NODE_50944_length_330_cov_2.719844_g50692_i0 | PRJNA533114 | 50944 | 330 | 2.719844 | 8.9754852 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 203 | 1.09e-64 | NR | MBX9724270.1 | 2364082 | g50692 | i0 | 94.2 | 0.936363636363636 | 103 | 6 | 93.6 | 0 | 329 | 21 | 68 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 309 | 203 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 6883242 | 6883242 | PRJNA533114_P_NODE_84866_length_264_cov_1.115183_g84614_i0 | PRJNA533114 | 84866 | 264 | 1.115183 | 2.94408312 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 130 | 5.7199999999999985e-34 | NR | MBX9569696.1 | 2364082 | g84614 | i0 | 64.4 | 4.93181818181818 | 87 | 31 | 98.9 | 0 | 263 | 3 | 237 | 323 | MBX9569696.1 NAD(P)-binding domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 1302 | 130 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 13258883 | 13258883 | PRJNA533114_P_NODE_42631_length_357_cov_1.045775_g42379_i0 | PRJNA533114 | 42631 | 357 | 1.045775 | 3.73341675 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 139 | 4.11e-39 | NR | MBL8086383.1 | 2711154 | g42379 | i0 | 78.7 | 0.747899159663866 | 89 | 15 | 71.4 | 1 | 328 | 74 | 56 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 267 | 139 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 20906589 | 20906589 | PRJNA533114_P_NODE_116017_length_243_cov_0.888235_g115765_i0 | PRJNA533114 | 116017 | 243 | 0.888235 | 2.15841105 | uncultured Candidatus Melainabacteria bacterium | 2682970 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|1781385025|gb|MN577570.1| | 2682970 | g115765 | i0 | 96.875 | 0.131687242798354 | 32 | 1 | 13 | 0 | 20 | 51 | 148264 | 148295 | Uncultured Candidatus Melainabacteria bacterium isolate LL20 clone UCI_2 | blastn | 32 | 54.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | uncultured Candidatus Melainabacteria bacterium | |||||
| 23457356 | 23457356 | PRJNA533114_P_NODE_45479_length_347_cov_1.642336_g45227_i0 | PRJNA533114 | 45479 | 347 | 1.642336 | 5.69890592 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 182 | 1.1399999999999997e-52 | NR | MDX2086181.1 | 2052166 | g45227 | i0 | 78.9 | 5.90489913544669 | 114 | 24 | 98.6 | 0 | 347 | 6 | 329 | 442 | MDX2086181.1 IMP dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 2049 | 182 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 26602648 | 26602648 | PRJNA533114_P_NODE_70681_length_286_cov_1.131455_g70429_i0 | PRJNA533114 | 70681 | 286 | 1.131455 | 3.2359613 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 88.2 | 1.98e-19 | NR | MBL8086383.1 | 2711154 | g70429 | i0 | 60.3 | 0.818181818181818 | 78 | 28 | 78.7 | 1 | 53 | 277 | 58 | 135 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 234 | 88.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27172300 | 27172300 | PRJNA533114_P_NODE_60402_length_307_cov_0.863248_g60150_i0 | PRJNA533114 | 60402 | 307 | 0.863248 | 2.65017136 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 53.9 | 8.96e-6 | NR | HMP54833.1 | 2052166 | g60150 | i0 | 50 | 1.57328990228013 | 72 | 33 | 70.4 | 2 | 84 | 299 | 429 | 497 | HMP54833.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium] | diamond | 483 | 53.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27235700 | 27235700 | PRJNA533114_P_NODE_37683_length_376_cov_1.613861_g37431_i0 | PRJNA533114 | 37683 | 376 | 1.613861 | 6.06811736 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 110 | 7.91e-28 | NR | MBL8086383.1 | 2711154 | g37431 | i0 | 70.1 | 0.61436170212766 | 77 | 23 | 61.4 | 0 | 374 | 144 | 68 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 231 | 110 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28119977 | 28119977 | PRJNA533114_P_NODE_76585_length_276_cov_2.221675_g76333_i0 | PRJNA533114 | 76585 | 276 | 2.221675 | 6.131823 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 100 | 1.94e-24 | NR | MBL8086383.1 | 2711154 | g76333 | i0 | 70.8 | 0.782608695652174 | 72 | 20 | 78.3 | 1 | 216 | 1 | 57 | 127 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 216 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28151713 | 28151713 | PRJNA533114_P_NODE_4185_length_1053_cov_2.448980_g4031_i0 | PRJNA533114 | 4185 | 1053 | 2.44898 | 25.7877594 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 51.2 | 0.00746 | NR | MBX3076112.1 | 2364082 | g4031 | i0 | 27.7 | 1.28490028490028 | 184 | 118 | 51.3 | 5 | 1010 | 471 | 1149 | 1321 | MBX3076112.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 1353 | 51.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28245967 | 28245967 | PRJNA533114_P_NODE_121646_length_238_cov_2.745455_g121394_i0 | PRJNA533114 | 121646 | 238 | 2.745455 | 6.5341829 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 52.8 | 4.55e-6 | NR | MBL8086383.1 | 2711154 | g121394 | i0 | 86.7 | 0.378151260504202 | 30 | 4 | 37.8 | 0 | 143 | 232 | 58 | 87 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 90 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28909051 | 28909051 | PRJNA533114_P_NODE_92028_length_253_cov_1.094444_g91776_i0 | PRJNA533114 | 92028 | 253 | 1.094444 | 2.76894332 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 105 | 2.19e-26 | NR | MBL8086383.1 | 2711154 | g91776 | i0 | 72.9 | 0.8300395256917 | 70 | 19 | 83 | 0 | 44 | 253 | 58 | 127 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 210 | 105 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 30520011 | 30520011 | PRJNA533114_P_NODE_52873_length_325_cov_1.257937_g52621_i0 | PRJNA533114 | 52873 | 325 | 1.257937 | 4.08829525 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 129 | 3e-34 | NR | HEY9791674.1 | 2364082 | g52621 | i0 | 57.5 | 0.978461538461538 | 106 | 45 | 97.8 | 0 | 1 | 318 | 187 | 292 | HEY9791674.1 bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Candidatus Obscuribacterales bacterium] | diamond | 318 | 129 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32653058 | 32653058 | PRJNA533114_P_NODE_65480_length_295_cov_1.387387_g65228_i0 | PRJNA533114 | 65480 | 295 | 1.387387 | 4.09279165 | root | 1 | Root_unresolved | Root_unresolved | 120 | 1.81e-29 | NR | MDX2086181.1 | 2052166 | g65228 | i0 | 67 | 4.84067796610169 | 94 | 29 | 95.6 | 1 | 293 | 12 | 130 | 221 | MDX2086181.1 IMP dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 1428 | 121 | 0.991735537190083 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32890194 | 32890194 | PRJNA533114_P_NODE_99800_length_249_cov_0.875000_g99548_i0 | PRJNA533114 | 99800 | 249 | 0.875 | 2.17875 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 112 | 3.86e-29 | NR | MBL8086383.1 | 2711154 | g99548 | i0 | 73.3 | 0.903614457831325 | 75 | 16 | 85.5 | 1 | 248 | 36 | 70 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 225 | 112 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter 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);;