contig_metadata
10 rows where bioproject = "PRJNA1255065", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24586540 | 24586540 | PRJNA1255065_P_NODE_152380_length_162_cov_0.920354_g150152_i0 | PRJNA1255065 | 152380 | 162 | 0.920354 | 1.49097348 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 255 | 9.570000000000001e-64 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g150152 | i0 | 95.062 | 78.141975308642 | 162 | 8 | 100 | 0 | 1 | 162 | 3679973 | 3679812 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 12659 | 255 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27042228 | 27042228 | PRJNA1255065_P_NODE_72562_length_214_cov_1.260606_g70334_i0 | PRJNA1255065 | 72562 | 214 | 1.260606 | 2.69769684 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 144 | 6.85e-39 | NR | MCC7531317.1 | 2052166 | g70334 | i0 | 97.2 | 0.995327102803738 | 71 | 2 | 99.5 | 0 | 214 | 2 | 248 | 318 | MCC7531317.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 213 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28052874 | 28052874 | PRJNA1255065_P_NODE_143545_length_163_cov_0.912281_g141317_i0 | PRJNA1255065 | 143545 | 163 | 0.912281 | 1.48701803 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 95.9 | 2.4e-21 | NR | RTL37211.1 | 2052166 | g141317 | i0 | 92.6 | 0.993865030674847 | 54 | 4 | 99.4 | 0 | 162 | 1 | 176 | 229 | RTL37211.1 MAG: HlyD family efflux transporter periplasmic adaptor subunit [Candidatus Melainabacteria bacterium] | diamond | 162 | 95.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28115984 | 28115984 | PRJNA1255065_P_NODE_153225_length_162_cov_0.920354_g150997_i0 | PRJNA1255065 | 153225 | 162 | 0.920354 | 1.49097348 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 55.1 | 4.15e-7 | NR | MBX9690163.1 | 2364082 | g150997 | i0 | 65.8 | 0.703703703703704 | 38 | 13 | 70.4 | 0 | 116 | 3 | 1 | 38 | MBX9690163.1 IS21-like element helper ATPase IstB [Candidatus Obscuribacterales bacterium] | diamond | 114 | 55.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28115986 | 28115986 | PRJNA1255065_P_NODE_48165_length_300_cov_0.828685_g45939_i0 | PRJNA1255065 | 48165 | 300 | 0.828685 | 2.486055 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 62 | 1.22e-8 | NR | PZM78708.1 | 2052166 | g45939 | i0 | 50.5 | 1.03 | 103 | 47 | 99 | 2 | 3 | 299 | 567 | 669 | PZM78708.1 MAG: hypothetical protein DKT66_23540 [Candidatus Melainabacteria bacterium] | diamond | 309 | 62 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28716100 | 28716100 | PRJNA1255065_P_NODE_89087_length_187_cov_1.507246_g86859_i0 | PRJNA1255065 | 89087 | 187 | 1.507246 | 2.81855002 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 61.6 | 8.51e-10 | NR | MBX9690164.1 | 2364082 | g86859 | i0 | 59.3 | 0.866310160427808 | 54 | 22 | 86.6 | 0 | 187 | 26 | 94 | 147 | MBX9690164.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 162 | 61.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31369637 | 31369637 | PRJNA1255065_P_NODE_146816_length_163_cov_0.912281_g144588_i0 | PRJNA1255065 | 146816 | 163 | 0.912281 | 1.48701803 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 89.4 | 4.79e-19 | NR | MBX9772732.1 | 2364082 | g144588 | i0 | 96.3 | 0.993865030674847 | 54 | 2 | 99.4 | 0 | 163 | 2 | 24 | 77 | MBX9772732.1 ATP-binding cassette domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 162 | 89.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31843726 | 31843726 | PRJNA1255065_P_NODE_152417_length_162_cov_0.920354_g150189_i0 | PRJNA1255065 | 152417 | 162 | 0.920354 | 1.49097348 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 85.9 | 4.56e-20 | NR | MBK7746005.1 | 2711154 | g150189 | i0 | 78.8 | 0.962962962962963 | 52 | 11 | 96.3 | 0 | 6 | 161 | 23 | 74 | MBK7746005.1 toxin-antitoxin system HicB family antitoxin [Candidatus Obscuribacter sp.] | diamond | 156 | 85.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31970334 | 31970334 | PRJNA1255065_P_NODE_118318_length_167_cov_0.881356_g116090_i0 | PRJNA1255065 | 118318 | 167 | 0.881356 | 1.47186452 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 107 | 3.8599999999999998e-28 | NR | RTL37214.1 | 2052166 | g116090 | i0 | 94.5 | 0.988023952095808 | 55 | 3 | 98.8 | 0 | 3 | 167 | 12 | 66 | RTL37214.1 MAG: hypothetical protein EKK48_24225 [Candidatus Melainabacteria bacterium] | diamond | 165 | 107 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32381788 | 32381788 | PRJNA1255065_P_NODE_137979_length_164_cov_0.904348_g135751_i0 | PRJNA1255065 | 137979 | 164 | 0.904348 | 1.48313072 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 59.3 | 1.73e-8 | NR | MDR3614028.1 | 2364082 | g135751 | i0 | 59.1 | 0.804878048780488 | 44 | 17 | 80.5 | 1 | 1 | 132 | 96 | 138 | MDR3614028.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 132 | 59.3 | 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);;