contig_metadata
13 rows where bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002396 | 2002396 | PRJNA751877_P_NODE_23222_length_250_cov_0.870056_g23100_i0 | PRJNA751877 | 23222 | 250 | 0.870056 | 2.17514 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 144 | 5.92e-38 | NR | HEY9839857.1 | 2364082 | g23100 | i0 | 87.8 | 0.984 | 82 | 10 | 98.4 | 0 | 248 | 3 | 627 | 708 | HEY9839857.1 ATP-dependent RecD-like DNA helicase [Candidatus Obscuribacterales bacterium] | diamond | 246 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 16503234 | 16503234 | PRJNA751877_P_NODE_26173_length_246_cov_0.890173_g26051_i0 | PRJNA751877 | 26173 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 161 | 5.62e-44 | NR | HEY9839850.1 | 2364082 | g26051 | i0 | 90.2 | 2 | 82 | 8 | 100 | 0 | 246 | 1 | 40 | 121 | HEY9839850.1 alanine--tRNA ligase [Candidatus Obscuribacterales bacterium] | diamond | 492 | 161 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 26682747 | 26682747 | PRJNA751877_P_NODE_24981_length_248_cov_0.880000_g24859_i0 | PRJNA751877 | 24981 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 129 | 4.84e-34 | NR | PKL78988.1 | 2013813 | g24859 | i0 | 74.4 | 2.95161290322581 | 82 | 21 | 99.2 | 0 | 246 | 1 | 156 | 237 | PKL78988.1 MAG: anion permease [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 732 | 129 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 26767954 | 26767954 | PRJNA751877_P_NODE_6321_length_403_cov_1.360606_g6199_i0 | PRJNA751877 | 6321 | 403 | 1.360606 | 5.48324218 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 183 | 2.9699999999999996e-56 | NR | PKL75061.1 | 2013813 | g6199 | i0 | 89.2 | 0.759305210918114 | 102 | 11 | 75.9 | 0 | 1 | 306 | 85 | 186 | PKL75061.1 MAG: hypothetical protein CVV27_17300 [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 306 | 183 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 27094300 | 27094300 | PRJNA751877_P_NODE_27322_length_245_cov_0.895349_g27200_i0 | PRJNA751877 | 27322 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 85.9 | 2.3e-17 | NR | HEY9843278.1 | 2364082 | g27200 | i0 | 61.7 | 1.98367346938776 | 81 | 31 | 99.2 | 0 | 2 | 244 | 225 | 305 | HEY9843278.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 486 | 85.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27188972 | 27188972 | PRJNA751877_P_NODE_21882_length_253_cov_1.266667_g21760_i0 | PRJNA751877 | 21882 | 253 | 1.266667 | 3.20466751 | Bacteria | 2 | Bacteria | Bacteria | 115 | 1.67e-28 | NR | HEY9844049.1 | 2364082 | g21760 | i0 | 57.8 | 1.96837944664032 | 83 | 35 | 98.4 | 0 | 251 | 3 | 267 | 349 | HEY9844049.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Obscuribacterales bacterium] | diamond | 498 | 115 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27726521 | 27726521 | PRJNA751877_P_NODE_22704_length_251_cov_0.865169_g22582_i0 | PRJNA751877 | 22704 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 129 | 8.96e-34 | NR | HEY9841248.1 | 2364082 | g22582 | i0 | 72 | 1.9601593625498 | 82 | 23 | 98 | 0 | 250 | 5 | 164 | 245 | HEY9841248.1 ATP-grasp domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 492 | 129 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28442538 | 28442538 | PRJNA751877_P_NODE_30266_length_241_cov_0.916667_g30144_i0 | PRJNA751877 | 30266 | 241 | 0.916667 | 2.20916747 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 152 | 1.3899999999999996e-42 | NR | PKL74936.1 | 2013813 | g30144 | i0 | 97.5 | 0.995850622406639 | 80 | 2 | 99.6 | 0 | 240 | 1 | 174 | 253 | PKL74936.1 MAG: acyl-CoA dehydrogenase [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 240 | 152 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 28989332 | 28989332 | PRJNA751877_P_NODE_24368_length_249_cov_0.875000_g24246_i0 | PRJNA751877 | 24368 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 131 | 1.13e-34 | NR | PKL79497.1 | 2013813 | g24246 | i0 | 75 | 1.93975903614458 | 80 | 20 | 96.4 | 0 | 244 | 5 | 85 | 164 | PKL79497.1 MAG: cytochrome-c peroxidase [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 483 | 132 | 0.992424242424242 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 29263091 | 29263091 | PRJNA751877_P_NODE_28889_length_243_cov_0.905882_g28767_i0 | PRJNA751877 | 28889 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 151 | 2.07e-44 | NR | PKL75833.1 | 2013813 | g28767 | i0 | 93.8 | 1 | 81 | 5 | 100 | 0 | 1 | 243 | 74 | 154 | PKL75833.1 MAG: F420-0:Gamma-glutamyl ligase, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 243 | 151 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 31759482 | 31759482 | PRJNA751877_P_NODE_24317_length_249_cov_0.875000_g24195_i0 | PRJNA751877 | 24317 | 249 | 0.875 | 2.17875 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 97.1 | 2.7800000000000003e-21 | NR | HEY9843538.1 | 2364082 | g24195 | i0 | 58.5 | 0.987951807228916 | 82 | 34 | 98.8 | 0 | 248 | 3 | 369 | 450 | HEY9843538.1 class I SAM-dependent methyltransferase [Candidatus Obscuribacterales bacterium] | diamond | 246 | 97.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31854363 | 31854363 | PRJNA751877_P_NODE_8237_length_370_cov_1.030303_g8115_i0 | PRJNA751877 | 8237 | 370 | 1.030303 | 3.8121211 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 123 | 7.339999999999999e-30 | NR | PKL75227.1 | 2013813 | g8115 | i0 | 52.6 | 1.86486486486486 | 116 | 55 | 94.1 | 0 | 23 | 370 | 89 | 204 | PKL75227.1 MAG: hypothetical protein CVV27_16445, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 690 | 123 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 32171064 | 32171064 | PRJNA751877_P_NODE_18618_length_274_cov_1.388060_g18496_i0 | PRJNA751877 | 18618 | 274 | 1.38806 | 3.8032844 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 144 | 1.27e-39 | NR | PKL76434.1 | 2013813 | g18496 | i0 | 72.5 | 1.99270072992701 | 91 | 25 | 99.6 | 0 | 273 | 1 | 124 | 214 | PKL76434.1 MAG: cysteine synthase A [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 546 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 |
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);;