contig_metadata
13 rows where bioproject = "PRJNA874604", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26960141 | 26960141 | PRJNA874604_P_NODE_61822_length_263_cov_0.978947_g61470_i0 | PRJNA874604 | 61822 | 263 | 0.978947 | 2.57463061 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 123 | 1.11e-30 | NR | MBK7747780.1 | 2711154 | g61470 | i0 | 65.9 | 1.00380228136882 | 88 | 29 | 99.2 | 1 | 262 | 2 | 437 | 524 | MBK7747780.1 ABC transporter ATP-binding protein/permease [Candidatus Obscuribacter sp.] | diamond | 264 | 123 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27086911 | 27086911 | PRJNA874604_P_NODE_75282_length_249_cov_0.875000_g74930_i0 | PRJNA874604 | 75282 | 249 | 0.875 | 2.17875 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 164 | 1.49e-48 | NR | PZM86040.1 | 2052166 | g74930 | i0 | 97.6 | 1 | 83 | 2 | 100 | 0 | 1 | 249 | 180 | 262 | PZM86040.1 MAG: hypothetical protein DKT66_01140 [Candidatus Melainabacteria bacterium] | diamond | 249 | 164 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27758580 | 27758580 | PRJNA874604_P_NODE_64784_length_257_cov_2.043478_g64432_i0 | PRJNA874604 | 64784 | 257 | 2.043478 | 5.25173846 | Bacteria | 2 | Bacteria | Bacteria | 119 | 1.7599999999999998e-31 | NR | HNB23518.1 | 2052166 | g64432 | i0 | 64.7 | 6.93385214007782 | 85 | 30 | 99.2 | 0 | 3 | 257 | 63 | 147 | HNB23518.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Melainabacteria bacterium] | diamond | 1782 | 119 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27844754 | 27844754 | PRJNA874604_P_NODE_82064_length_247_cov_0.885057_g81712_i0 | PRJNA874604 | 82064 | 247 | 0.885057 | 2.18609079 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 162 | 8.64e-46 | NR | MBN9395772.1 | 2052166 | g81712 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 2 | 247 | 379 | 460 | MBN9395772.1 efflux RND transporter periplasmic adaptor subunit [Candidatus Melainabacteria bacterium] | diamond | 246 | 162 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27971178 | 27971178 | PRJNA874604_P_NODE_83725_length_246_cov_0.890173_g83373_i0 | PRJNA874604 | 83725 | 246 | 0.890173 | 2.18982558 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 90.9 | 1.02e-20 | NR | MBL8086383.1 | 2711154 | g83373 | i0 | 67.5 | 0.975609756097561 | 80 | 13 | 97.6 | 3 | 241 | 2 | 61 | 127 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 240 | 90.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27971185 | 27971185 | PRJNA874604_P_NODE_99165_length_241_cov_0.916667_g98813_i0 | PRJNA874604 | 99165 | 241 | 0.916667 | 2.20916747 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 104 | 1.45e-25 | NR | MFA6212237.1 | 2364082 | g98813 | i0 | 56.8 | 3.52282157676349 | 74 | 28 | 87.1 | 1 | 240 | 31 | 153 | 226 | MFA6212237.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 849 | 104 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29265563 | 29265563 | PRJNA874604_P_NODE_84109_length_246_cov_0.890173_g83757_i0 | PRJNA874604 | 84109 | 246 | 0.890173 | 2.18982558 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 60.1 | 8.24e-9 | NR | MBL8086383.1 | 2711154 | g83757 | i0 | 66 | 0.573170731707317 | 47 | 16 | 57.3 | 0 | 203 | 63 | 58 | 104 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 141 | 60.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29273642 | 29273642 | PRJNA874604_P_NODE_76889_length_248_cov_2.640000_g76537_i0 | PRJNA874604 | 76889 | 248 | 2.64 | 6.5472 | Candidatus Obscuribacter | 1906156 | Bacteria | Bacteria | 82.4 | 3.32e-16 | NR | MFA6211094.1 | 2364082 | g76537 | i0 | 50.7 | 1.66935483870968 | 69 | 34 | 83.5 | 0 | 248 | 42 | 339 | 407 | MFA6211094.1 M23 family metallopeptidase [Candidatus Obscuribacterales bacterium] | diamond | 414 | 83.2 | 0.990384615384615 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30695141 | 30695141 | PRJNA874604_P_NODE_60993_length_264_cov_1.612565_g60641_i0 | PRJNA874604 | 60993 | 264 | 1.612565 | 4.2571716 | Bacillati | 1783272 | Bacteria | Bacteria | 124 | 1.34e-30 | NR | HEY9785708.1 | 2364082 | g60641 | i0 | 72.3 | 5.68181818181818 | 83 | 23 | 94.3 | 0 | 259 | 11 | 246 | 328 | HEY9785708.1 DEAD/DEAH box helicase family protein [Candidatus Obscuribacterales bacterium] | diamond | 1500 | 124 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30971638 | 30971638 | PRJNA874604_P_NODE_98694_length_241_cov_0.916667_g98342_i0 | PRJNA874604 | 98694 | 241 | 0.916667 | 2.20916747 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 64.3 | 9.12e-10 | NR | MFA6208459.1 | 2364082 | g98342 | i0 | 42.5 | 0.995850622406639 | 80 | 46 | 99.6 | 0 | 241 | 2 | 187 | 266 | MFA6208459.1 YfhO family protein [Candidatus Obscuribacterales bacterium] | diamond | 240 | 64.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31445684 | 31445684 | PRJNA874604_P_NODE_64596_length_258_cov_1.248649_g64244_i0 | PRJNA874604 | 64596 | 258 | 1.248649 | 3.22151442 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 113 | 6.82e-27 | NR | MCA0315251.1 | 2052166 | g64244 | i0 | 71.1 | 1.93023255813953 | 83 | 24 | 96.5 | 0 | 6 | 254 | 132 | 214 | MCA0315251.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 498 | 113 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31666984 | 31666984 | PRJNA874604_P_NODE_59437_length_267_cov_1.273196_g59085_i0 | PRJNA874604 | 59437 | 267 | 1.273196 | 3.39943332 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 93.6 | 3.59e-21 | NR | HMW89675.1 | 2711154 | g59085 | i0 | 81.1 | 1.19101123595506 | 53 | 10 | 59.6 | 0 | 107 | 265 | 1 | 53 | HMW89675.1 GGDEF domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 318 | 93.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31793376 | 31793376 | PRJNA874604_P_NODE_70017_length_251_cov_0.865169_g69665_i0 | PRJNA874604 | 70017 | 251 | 0.865169 | 2.17157419 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 77.4 | 7.54e-16 | NR | MBK7747772.1 | 2711154 | g69665 | i0 | 67.9 | 0.669322709163347 | 56 | 18 | 66.9 | 0 | 83 | 250 | 5 | 60 | MBK7747772.1 thioredoxin [Candidatus Obscuribacter sp.] | diamond | 168 | 77.4 | 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);;