contig_metadata
12 rows where bioproject = "PRJNA278119", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27597440 | 27597440 | PRJNA278119_P_NODE_14244_length_292_cov_0.855967_g13995_i0 | PRJNA278119 | 14244 | 292 | 0.855967 | 2.49942364 | Bacillati | 1783272 | Bacteria | Bacteria | 147 | 9.28e-39 | NR | HEY9873594.1 | 2364082 | g13995 | i0 | 78.1 | 2.95890410958904 | 96 | 21 | 98.6 | 0 | 3 | 290 | 256 | 351 | HEY9873594.1 cellulose biosynthesis cyclic di-GMP-binding regulatory protein BcsB [Candidatus Obscuribacterales bacterium] | diamond | 864 | 147 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27769304 | 27769304 | PRJNA278119_P_NODE_39624_length_166_cov_1.316239_g39375_i0 | PRJNA278119 | 39624 | 166 | 1.316239 | 2.18495674 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 43.9 | 0.0022 | NR | MBX9722668.1 | 2364082 | g39375 | i0 | 63.9 | 1.30120481927711 | 36 | 13 | 65.1 | 0 | 161 | 54 | 101 | 136 | MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 216 | 43.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27849713 | 27849713 | PRJNA278119_P_NODE_35404_length_169_cov_0.866667_g35155_i0 | PRJNA278119 | 35404 | 169 | 0.866667 | 1.46466723 | Bacillati | 1783272 | Bacteria | Bacteria | 43.1 | 0.00508 | NR | HEY9874702.1 | 2364082 | g35155 | i0 | 74.1 | 0.958579881656805 | 27 | 6 | 46.2 | 1 | 76 | 153 | 94 | 120 | HEY9874702.1 IS4 family transposase [Candidatus Obscuribacterales bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28021811 | 28021811 | PRJNA278119_P_NODE_39345_length_166_cov_1.333333_g39096_i0 | PRJNA278119 | 39345 | 166 | 1.333333 | 2.21333278 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 102 | 1.73e-23 | NR | HEY9872584.1 | 2364082 | g39096 | i0 | 94.4 | 0.975903614457831 | 54 | 3 | 97.6 | 0 | 166 | 5 | 56 | 109 | HEY9872584.1 alpha-glucan family phosphorylase [Candidatus Obscuribacterales bacterium] | diamond | 162 | 102 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28905489 | 28905489 | PRJNA278119_P_NODE_35368_length_169_cov_0.866667_g35119_i0 | PRJNA278119 | 35368 | 169 | 0.866667 | 1.46466723 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 85.1 | 1.62e-17 | NR | HEY9807115.1 | 2364082 | g35119 | i0 | 75.9 | 1.95266272189349 | 54 | 13 | 95.9 | 0 | 165 | 4 | 80 | 133 | HEY9807115.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 330 | 85.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29144751 | 29144751 | PRJNA278119_P_NODE_23609_length_203_cov_1.688312_g23360_i0 | PRJNA278119 | 23609 | 203 | 1.688312 | 3.42727336 | Bacillati | 1783272 | Bacteria | Bacteria | 110 | 9.990000000000002e-27 | NR | HEY9859547.1 | 2364082 | g23360 | i0 | 80.6 | 2.95566502463054 | 67 | 13 | 99 | 0 | 201 | 1 | 28 | 94 | HEY9859547.1 glycosyltransferase [Candidatus Obscuribacterales bacterium] | diamond | 600 | 110 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29302301 | 29302301 | PRJNA278119_P_NODE_19609_length_227_cov_0.876404_g19360_i0 | PRJNA278119 | 19609 | 227 | 0.876404 | 1.98943708 | Bacillati | 1783272 | Bacteria | Bacteria | 137 | 2.08e-35 | NR | HEY9873593.1 | 2364082 | g19360 | i0 | 86.7 | 8.92070484581498 | 75 | 10 | 99.1 | 0 | 225 | 1 | 674 | 748 | HEY9873593.1 UDP-forming cellulose synthase catalytic subunit [Candidatus Obscuribacterales bacterium] | diamond | 2025 | 137 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30692019 | 30692019 | PRJNA278119_P_NODE_34353_length_169_cov_1.733333_g34104_i0 | PRJNA278119 | 34353 | 169 | 1.733333 | 2.92933277 | Bacillati | 1783272 | Bacteria | Bacteria | 73.9 | 9.51e-14 | NR | HEY9873296.1 | 2364082 | g34104 | i0 | 75 | 2.55621301775148 | 48 | 12 | 85.2 | 0 | 168 | 25 | 290 | 337 | HEY9873296.1 glycosyltransferase [Candidatus Obscuribacterales bacterium] | diamond | 432 | 73.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30786880 | 30786880 | PRJNA278119_P_NODE_19534_length_227_cov_1.460674_g19285_i0 | PRJNA278119 | 19534 | 227 | 1.460674 | 3.31572998 | Bacillati | 1783272 | Bacteria | Bacteria | 133 | 4.56e-34 | NR | HEY9876560.1 | 2364082 | g19285 | i0 | 84 | 2.97356828193833 | 75 | 12 | 99.1 | 0 | 225 | 1 | 696 | 770 | HEY9876560.1 cellulose biosynthesis cyclic di-GMP-binding regulatory protein BcsB [Candidatus Obscuribacterales bacterium] | diamond | 675 | 134 | 0.992537313432836 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31608796 | 31608796 | PRJNA278119_P_NODE_5816_length_495_cov_1.426009_g5570_i0 | PRJNA278119 | 5816 | 495 | 1.426009 | 7.05874455 | Bacillati | 1783272 | Bacteria | Bacteria | 114 | 3.16e-28 | NR | HEY9871999.1 | 2364082 | g5570 | i0 | 90.5 | 1.52727272727273 | 63 | 6 | 38.2 | 0 | 1 | 189 | 144 | 206 | HEY9871999.1 AAA family ATPase [Candidatus Obscuribacterales bacterium] | diamond | 756 | 114 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31654145 | 31654145 | PRJNA278119_P_NODE_30337_length_180_cov_1.190840_g30088_i0 | PRJNA278119 | 30337 | 180 | 1.19084 | 2.143512 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 75.1 | 6.16e-14 | NR | HEY9873099.1 | 2364082 | g30088 | i0 | 73.8 | 1.4 | 42 | 11 | 70 | 0 | 53 | 178 | 1 | 42 | HEY9873099.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 252 | 75.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32463098 | 32463098 | PRJNA278119_P_NODE_29219_length_183_cov_1.492537_g28970_i0 | PRJNA278119 | 29219 | 183 | 1.492537 | 2.73134271 | Bacillati | 1783272 | Bacteria | Bacteria | 81.6 | 2.93e-16 | NR | HEY9860723.1 | 2364082 | g28970 | i0 | 94.9 | 2.98360655737705 | 39 | 2 | 63.9 | 0 | 66 | 182 | 312 | 350 | HEY9860723.1 IS4 family transposase [Candidatus Obscuribacterales bacterium] | diamond | 546 | 81.6 | 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);;