contig_metadata
11 rows where bioproject = "PRJNA853203", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 841297 | 841297 | PRJNA853203_P_NODE_1101_length_581_cov_5.448819_g954_i0 | PRJNA853203 | 1101 | 581 | 5.448819 | 31.65763839 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 422 | 3.7999999999999987e-113 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g954 | i0 | 81.204 | 79.592082616179 | 548 | 82 | 92 | 17 | 47 | 581 | 3681455 | 3680916 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 46243 | 422 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 9769381 | 9769381 | PRJNA853203_P_NODE_16968_length_273_cov_1.115000_g16819_i0 | PRJNA853203 | 16968 | 273 | 1.115 | 3.04395 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 274 | 4.91e-69 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g16819 | i0 | 89.862 | 116.772893772894 | 217 | 16 | 78 | 6 | 27 | 240 | 1478441 | 1478228 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 31879 | 274 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 13595148 | 13595148 | PRJNA853203_P_NODE_25231_length_255_cov_1.714286_g25082_i0 | PRJNA853203 | 25231 | 255 | 1.714286 | 4.3714293 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 165 | 2.85e-36 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g25082 | i0 | 85.185 | 95.6274509803922 | 162 | 23 | 64 | 1 | 13 | 174 | 3679976 | 3679816 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 24385 | 165 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27371392 | 27371392 | PRJNA853203_P_NODE_19343_length_267_cov_2.335052_g19194_i0 | PRJNA853203 | 19343 | 267 | 2.335052 | 6.23458884 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 150 | 4.63e-44 | NR | HIA53542.1 | 2052166 | g19194 | i0 | 97.7 | 0.98876404494382 | 88 | 2 | 98.9 | 0 | 265 | 2 | 7 | 94 | HIA53542.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 264 | 150 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27907607 | 27907607 | PRJNA853203_P_NODE_46825_length_242_cov_1.497041_g46676_i0 | PRJNA853203 | 46825 | 242 | 1.497041 | 3.62283922 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 126 | 1.0599999999999998e-31 | NR | MBX9685264.1 | 2364082 | g46676 | i0 | 79.2 | 1.78512396694215 | 72 | 15 | 89.3 | 0 | 216 | 1 | 4 | 75 | MBX9685264.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 432 | 126 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28886558 | 28886558 | PRJNA853203_P_NODE_17288_length_272_cov_1.402010_g17139_i0 | PRJNA853203 | 17288 | 272 | 1.40201 | 3.8134672 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 65.1 | 7.33e-10 | NR | MBY0359354.1 | 2364082 | g17139 | i0 | 44.1 | 1.02573529411765 | 93 | 47 | 99.3 | 4 | 1 | 270 | 846 | 936 | MBY0359354.1 amino acid adenylation domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 279 | 65.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31761761 | 31761761 | PRJNA853203_P_NODE_30157_length_251_cov_0.876404_g30008_i0 | PRJNA853203 | 30157 | 251 | 0.876404 | 2.19977404 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 143 | 3.7e-40 | NR | MBX9720640.1 | 2364082 | g30008 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 250 | 2 | 79 | 161 | MBX9720640.1 4-hydroxy-tetrahydrodipicolinate synthase [Candidatus Obscuribacterales bacterium] | diamond | 249 | 143 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32204767 | 32204767 | PRJNA853203_P_NODE_22418_length_261_cov_1.414894_g22269_i0 | PRJNA853203 | 22418 | 261 | 1.414894 | 3.69287334 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 137 | 2.77e-36 | NR | MBY0358753.1 | 2364082 | g22269 | i0 | 76.5 | 0.977011494252874 | 85 | 20 | 97.7 | 0 | 260 | 6 | 48 | 132 | MBY0358753.1 cytosine permease [Candidatus Obscuribacterales bacterium] | diamond | 255 | 137 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32268178 | 32268178 | PRJNA853203_P_NODE_31058_length_251_cov_0.876404_g30909_i0 | PRJNA853203 | 31058 | 251 | 0.876404 | 2.19977404 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 130 | 1.82e-33 | NR | MBX9719837.1 | 2364082 | g30909 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 3 | 251 | 259 | 341 | MBX9719837.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 249 | 130 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32553078 | 32553078 | PRJNA853203_P_NODE_31759_length_250_cov_1.322034_g31610_i0 | PRJNA853203 | 31759 | 250 | 1.322034 | 3.305085 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 162 | 8.249999999999998e-47 | NR | MBX3152124.1 | 2364082 | g31610 | i0 | 98.8 | 0.984 | 82 | 1 | 98.4 | 0 | 248 | 3 | 276 | 357 | MBX3152124.1 PAS domain S-box protein [Candidatus Obscuribacterales bacterium] | diamond | 246 | 162 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32553080 | 32553080 | PRJNA853203_P_NODE_38159_length_247_cov_0.896552_g38010_i0 | PRJNA853203 | 38159 | 247 | 0.896552 | 2.21448344 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 118 | 6.42e-30 | NR | MBX9668642.1 | 2364082 | g38010 | i0 | 73.2 | 0.995951417004049 | 82 | 22 | 99.6 | 0 | 246 | 1 | 197 | 278 | MBX9668642.1 site-specific integrase [Candidatus Obscuribacterales bacterium] | diamond | 246 | 118 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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);;