contig_metadata
8 rows where bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23748693 | 23748693 | PRJNA799842_P_NODE_94119_length_299_cov_1.362832_g92546_i0 | PRJNA799842 | 94119 | 299 | 1.362832 | 4.07486768 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 52.8 | 0.028 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g92546 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 40 | 67 | 1020018 | 1019991 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29264354 | 29264354 | PRJNA799842_P_NODE_176309_length_243_cov_0.905882_g174736_i0 | PRJNA799842 | 176309 | 243 | 0.905882 | 2.20129326 | Vampirovibrionales bacterium | 2692181 | Bacteria | Bacteria | 134 | 3.12e-34 | NR | MEB3286461.1 | 2692181 | g174736 | i0 | 82.3 | 0.975308641975309 | 79 | 14 | 97.5 | 0 | 239 | 3 | 735 | 813 | MEB3286461.1 DNA polymerase I [Vampirovibrionales bacterium] | diamond | 237 | 134 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrionales bacterium | |||
| 29273342 | 29273342 | PRJNA799842_P_NODE_82629_length_317_cov_2.192623_g81056_i0 | PRJNA799842 | 82629 | 317 | 2.192623 | 6.95061491 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 45.8 | 0.00486 | NR | MBI1857911.1 | 2052166 | g81056 | i0 | 43.6 | 1.19242902208202 | 55 | 30 | 51.1 | 1 | 65 | 226 | 24 | 78 | MBI1857911.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Candidatus Melainabacteria bacterium] | diamond | 378 | 45.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29296103 | 29296103 | PRJNA799842_P_NODE_153349_length_248_cov_0.880000_g151776_i0 | PRJNA799842 | 153349 | 248 | 0.88 | 2.1824 | Vampirovibrio sp. | 2717857 | Bacteria | Bacteria | 146 | 4.8299999999999996e-40 | NR | MCE3236232.1 | 2717857 | g151776 | i0 | 89.7 | 0.943548387096774 | 78 | 8 | 94.4 | 0 | 248 | 15 | 354 | 431 | MCE3236232.1 sensor signal transduction histidine kinase [Vampirovibrio sp.] | diamond | 234 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio sp. | ||
| 30717384 | 30717384 | PRJNA799842_P_NODE_119934_length_267_cov_1.587629_g118361_i0 | PRJNA799842 | 119934 | 267 | 1.587629 | 4.23896943 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 152 | 9.35e-45 | NR | MDR3614393.1 | 2364082 | g118361 | i0 | 84.1 | 0.98876404494382 | 88 | 14 | 98.9 | 0 | 2 | 265 | 28 | 115 | MDR3614393.1 DNA-3-methyladenine glycosylase I [Candidatus Obscuribacterales bacterium] | diamond | 264 | 152 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31381387 | 31381387 | PRJNA799842_P_NODE_164296_length_246_cov_0.890173_g162723_i0 | PRJNA799842 | 164296 | 246 | 0.890173 | 2.18982558 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 68.2 | 8.42e-12 | NR | MBX9941337.1 | 2364082 | g162723 | i0 | 56.9 | 0.707317073170732 | 58 | 25 | 70.7 | 0 | 177 | 4 | 21 | 78 | MBX9941337.1 SRPBCC family protein [Candidatus Obscuribacterales bacterium] | diamond | 174 | 68.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32614818 | 32614818 | PRJNA799842_P_NODE_138600_length_251_cov_0.865169_g137027_i0 | PRJNA799842 | 138600 | 251 | 0.865169 | 2.17157419 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 157 | 2.74e-44 | NR | MDR3616425.1 | 2364082 | g137027 | i0 | 90.4 | 0.99203187250996006 | 83 | 8 | 99.2 | 0 | 1 | 249 | 199 | 281 | MDR3616425.1 FAD-binding oxidoreductase [Candidatus Obscuribacterales bacterium] | diamond | 249 | 157 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32803612 | 32803612 | PRJNA799842_P_NODE_102760_length_287_cov_1.911215_g101187_i0 | PRJNA799842 | 102760 | 287 | 1.911215 | 5.48518705 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 144 | 3.83e-39 | NR | MDR3613387.1 | 2364082 | g101187 | i0 | 80 | 0.993031358885017 | 95 | 19 | 99.3 | 0 | 286 | 2 | 45 | 139 | MDR3613387.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 285 | 144 | 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);;