contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27777216 | 27777216 | PRJNA682078_P_NODE_278024_length_243_cov_0.905882_g276247_i0 | PRJNA682078 | 278024 | 243 | 0.905882 | 2.20129326 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 106 | 8.96e-25 | NR | MDR3613792.1 | 2364082 | g276247 | i0 | 76.7 | 0.740740740740741 | 60 | 14 | 74.1 | 0 | 238 | 59 | 467 | 526 | MDR3613792.1 class I adenylate-forming enzyme family protein [Candidatus Obscuribacterales bacterium] | diamond | 180 | 106 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27808827 | 27808827 | PRJNA682078_P_NODE_216204_length_254_cov_1.265193_g214427_i0 | PRJNA682078 | 216204 | 254 | 1.265193 | 3.21359022 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 79 | 2.26e-16 | NR | MBX9941901.1 | 2364082 | g214427 | i0 | 45.2 | 0.992125984251969 | 84 | 46 | 99.2 | 0 | 252 | 1 | 43 | 126 | MBX9941901.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 252 | 79 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29103312 | 29103312 | PRJNA682078_P_NODE_294168_length_237_cov_3.000000_g292391_i0 | PRJNA682078 | 294168 | 237 | 3 | 7.11 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 146 | 9.07e-41 | NR | MBC7996343.1 | 2052166 | g292391 | i0 | 87.2 | 0.987341772151899 | 78 | 10 | 98.7 | 0 | 236 | 3 | 72 | 149 | MBC7996343.1 allantoicase [Candidatus Melainabacteria bacterium] | diamond | 234 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29260802 | 29260802 | PRJNA682078_P_NODE_196709_length_265_cov_1.218750_g194932_i0 | PRJNA682078 | 196709 | 265 | 1.21875 | 3.2296875 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 149 | 1.24e-39 | NR | MBK7750316.1 | 2711154 | g194932 | i0 | 92 | 3.93962264150943 | 87 | 7 | 98.5 | 0 | 263 | 3 | 546 | 632 | MBK7750316.1 tetratricopeptide repeat protein [Candidatus Obscuribacter sp.] | diamond | 1044 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29260850 | 29260850 | PRJNA682078_P_NODE_59389_length_446_cov_1.176944_g57616_i0 | PRJNA682078 | 59389 | 446 | 1.176944 | 5.24917024 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 174 | 5.529999999999999e-48 | NR | HEY9805388.1 | 2364082 | g57616 | i0 | 58.6 | 0.975336322869955 | 145 | 59 | 97.5 | 1 | 442 | 8 | 456 | 599 | HEY9805388.1 reverse transcriptase domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 435 | 174 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31104683 | 31104683 | PRJNA682078_P_NODE_236435_length_249_cov_0.875000_g234658_i0 | PRJNA682078 | 236435 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 146 | 1.6999999999999996e-38 | NR | MDX2085824.1 | 2052166 | g234658 | i0 | 89.2 | 7 | 83 | 9 | 100 | 0 | 249 | 1 | 645 | 727 | MDX2085824.1 preprotein translocase subunit SecA [Candidatus Melainabacteria bacterium] | diamond | 1743 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31377824 | 31377824 | PRJNA682078_P_NODE_255876_length_246_cov_0.890173_g254099_i0 | PRJNA682078 | 255876 | 246 | 0.890173 | 2.18982558 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 53.9 | 2.21e-6 | NR | MFA6212423.1 | 2364082 | g254099 | i0 | 45.6 | 1.39024390243902 | 57 | 30 | 69.5 | 1 | 246 | 76 | 144 | 199 | MFA6212423.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 342 | 53.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31757220 | 31757220 | PRJNA682078_P_NODE_251457_length_247_cov_0.885057_g249680_i0 | PRJNA682078 | 251457 | 247 | 0.885057 | 2.18609079 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 164 | 3.05e-48 | NR | PZM77116.1 | 2052166 | g249680 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 247 | 2 | 148 | 229 | PZM77116.1 MAG: hypothetical protein DKT66_28160 [Candidatus Melainabacteria bacterium] | diamond | 246 | 164 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32800020 | 32800020 | PRJNA682078_P_NODE_221740_length_251_cov_1.297753_g219963_i0 | PRJNA682078 | 221740 | 251 | 1.297753 | 3.25736003 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 120 | 1.1000000000000001e-30 | NR | MFN8658877.1 | 2364082 | g219963 | i0 | 69.4 | 0.860557768924303 | 72 | 22 | 86.1 | 0 | 218 | 3 | 203 | 274 | MFN8658877.1 alkaline phosphatase D family protein [Candidatus Obscuribacterales bacterium] | diamond | 216 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32863137 | 32863137 | PRJNA682078_P_NODE_236820_length_249_cov_0.875000_g235043_i0 | PRJNA682078 | 236820 | 249 | 0.875 | 2.17875 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 155 | 3.0299999999999996e-42 | NR | RTL35268.1 | 2052166 | g235043 | i0 | 89.4 | 1.02409638554217 | 85 | 6 | 98.8 | 1 | 248 | 3 | 261 | 345 | RTL35268.1 MAG: hypothetical protein EKK48_29330 [Candidatus Melainabacteria bacterium] | diamond | 255 | 155 | 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);;