contig_metadata
10 rows where bioproject = "PRJNA436017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1705777 | 1705777 | PRJNA436017_P_NODE_302_length_1459_cov_13.627989_g243_i0 | PRJNA436017 | 302 | 1459 | 13.627989 | 198.83235951 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 1122 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g243 | i0 | 80.92 | 73.4139821795751 | 1478 | 232 | 100 | 38 | 1 | 1459 | 3682680 | 3681234 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 107111 | 1122 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 6808747 | 6808747 | PRJNA436017_P_NODE_786_length_1034_cov_20.251755_g652_i0 | PRJNA436017 | 786 | 1034 | 20.251755 | 209.4031467 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 966 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g652 | i0 | 83.699 | 136.557059961315 | 1049 | 145 | 99 | 24 | 2 | 1034 | 3681642 | 3682680 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 141200 | 966 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 13184615 | 13184615 | PRJNA436017_P_NODE_431_length_1296_cov_32.846704_g352_i0 | PRJNA436017 | 431 | 1296 | 32.846704 | 425.69328384 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 1199 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g352 | i0 | 83.61 | 117.571759259259 | 1324 | 170 | 100 | 42 | 1 | 1296 | 3681376 | 3682680 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 152373 | 1199 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 14459752 | 14459752 | PRJNA436017_P_NODE_432_length_1296_cov_32.671962_g353_i0 | PRJNA436017 | 432 | 1296 | 32.671962 | 423.42862752 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 1194 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g353 | i0 | 83.535 | 117.571759259259 | 1324 | 171 | 100 | 42 | 1 | 1296 | 3682680 | 3681376 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 152373 | 1194 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 18282582 | 18282582 | PRJNA436017_P_NODE_555_length_1171_cov_14.016755_g452_i0 | PRJNA436017 | 555 | 1171 | 14.016755 | 164.13620105 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 1048 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g452 | i0 | 83.193 | 65.932536293766 | 1184 | 160 | 99 | 28 | 1 | 1170 | 3682680 | 3681522 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 77207 | 1048 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 20832316 | 20832316 | PRJNA436017_P_NODE_14497_length_219_cov_1.043956_g14199_i0 | PRJNA436017 | 14497 | 219 | 1.043956 | 2.28626364 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 143 | 1.12e-29 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g14199 | i0 | 78.924 | 351.826484018265 | 223 | 38 | 99 | 9 | 2 | 219 | 1479107 | 1479325 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 77050 | 143 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 27739566 | 27739566 | PRJNA436017_P_NODE_13364_length_229_cov_2.578125_g13066_i0 | PRJNA436017 | 13364 | 229 | 2.578125 | 5.90390625 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 97.4 | 1.6399999999999998e-23 | NR | MBX9724270.1 | 2364082 | g13066 | i0 | 98 | 0.641921397379913 | 49 | 1 | 64.2 | 0 | 228 | 82 | 122 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 147 | 97.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28275879 | 28275879 | PRJNA436017_P_NODE_22906_length_170_cov_2.849624_g22608_i0 | PRJNA436017 | 22906 | 170 | 2.849624 | 4.8443608 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 42 | 0.00961 | NR | PZM84364.1 | 2052166 | g22608 | i0 | 62.2 | 0.652941176470588 | 37 | 14 | 65.3 | 0 | 128 | 18 | 77 | 113 | PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] | diamond | 111 | 42 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29128728 | 29128728 | PRJNA436017_P_NODE_22649_length_171_cov_6.320896_g22351_i0 | PRJNA436017 | 22649 | 171 | 6.320896 | 10.80873216 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 61.2 | 3.03e-10 | NR | PZM84364.1 | 2052166 | g22351 | i0 | 59.6 | 0.912280701754386 | 52 | 21 | 91.2 | 0 | 2 | 157 | 64 | 115 | PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium] | diamond | 156 | 61.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30012781 | 30012781 | PRJNA436017_P_NODE_19631_length_184_cov_2.591837_g19333_i0 | PRJNA436017 | 19631 | 184 | 2.591837 | 4.76898008 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 45.1 | 2.19e-4 | NR | HEY9844071.1 | 2364082 | g19333 | i0 | 88 | 0.407608695652174 | 25 | 3 | 40.8 | 0 | 79 | 5 | 1 | 25 | HEY9844071.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 75 | 45.1 | 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);;