contig_metadata
7 rows where bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26770272 | 26770272 | PRJNA861969_P_NODE_26161_length_270_cov_1.563452_g25930_i0 | PRJNA861969 | 26161 | 270 | 1.563452 | 4.2213204 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 161 | 4.53e-44 | NR | MBX9672589.1 | 2364082 | g25930 | i0 | 100 | 0.988888888888889 | 89 | 0 | 98.9 | 0 | 269 | 3 | 409 | 497 | MBX9672589.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium] | diamond | 267 | 161 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29486421 | 29486421 | PRJNA861969_P_NODE_42290_length_233_cov_2.775000_g42059_i0 | PRJNA861969 | 42290 | 233 | 2.775 | 6.46575 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 74.7 | 3.33e-14 | NR | MBK9774186.1 | 2711154 | g42059 | i0 | 44.3 | 0.901287553648069 | 70 | 39 | 90.1 | 0 | 5 | 214 | 9 | 78 | MBK9774186.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 210 | 74.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29675766 | 29675766 | PRJNA861969_P_NODE_22690_length_286_cov_1.446009_g22459_i0 | PRJNA861969 | 22690 | 286 | 1.446009 | 4.13558574 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 64.7 | 1.38e-10 | NR | MDR3614999.1 | 2364082 | g22459 | i0 | 56.6 | 1.6993006993007 | 53 | 23 | 55.6 | 0 | 285 | 127 | 100 | 152 | MDR3614999.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 486 | 64.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30031735 | 30031735 | PRJNA861969_P_NODE_36191_length_246_cov_0.890173_g35960_i0 | PRJNA861969 | 36191 | 246 | 0.890173 | 2.18982558 | Bacillati | 1783272 | Bacteria | Bacteria | 78.6 | 1.93e-15 | NR | MCC7528080.1 | 2052166 | g35960 | i0 | 82.1 | 1.92682926829268 | 39 | 7 | 47.6 | 0 | 244 | 128 | 208 | 246 | MCC7528080.1 response regulator transcription factor [Candidatus Melainabacteria bacterium] | diamond | 474 | 79.3 | 0.991172761664565 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30876580 | 30876580 | PRJNA861969_P_NODE_31114_length_251_cov_0.865169_g30883_i0 | PRJNA861969 | 31114 | 251 | 0.865169 | 2.17157419 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 166 | 4.539999999999999e-46 | NR | PZM78708.1 | 2052166 | g30883 | i0 | 98.8 | 0.99203187250996006 | 83 | 1 | 99.2 | 0 | 2 | 250 | 235 | 317 | PZM78708.1 MAG: hypothetical protein DKT66_23540 [Candidatus Melainabacteria bacterium] | diamond | 249 | 166 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31003041 | 31003041 | PRJNA861969_P_NODE_22654_length_286_cov_1.446009_g22423_i0 | PRJNA861969 | 22654 | 286 | 1.446009 | 4.13558574 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 99.8 | 5.7099999999999996e-24 | NR | MBP6348882.1 | 2711154 | g22423 | i0 | 86.8 | 0.555944055944056 | 53 | 7 | 55.6 | 0 | 160 | 2 | 6 | 58 | MBP6348882.1 gamma carbonic anhydrase family protein [Candidatus Obscuribacter sp.] | diamond | 159 | 99.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31603788 | 31603788 | PRJNA861969_P_NODE_36476_length_246_cov_0.890173_g36245_i0 | PRJNA861969 | 36476 | 246 | 0.890173 | 2.18982558 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 73.6 | 5.28e-13 | NR | MBN9396211.1 | 2052166 | g36245 | i0 | 51.6 | 0.75609756097561 | 62 | 30 | 75.6 | 0 | 187 | 2 | 1 | 62 | MBN9396211.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 186 | 73.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;