contig_metadata
7 rows where bioproject = "PRJNA946307", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28320266 | 28320266 | PRJNA946307_P_NODE_130906_length_170_cov_2.371901_g130032_i0 | PRJNA946307 | 130906 | 170 | 2.371901 | 4.0322317 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 45.8 | 0.00112 | NR | PYN74208.1 | 2053607 | g130032 | i0 | 63.3 | 0.529411764705882 | 30 | 11 | 52.9 | 0 | 5 | 94 | 296 | 325 | PYN74208.1 MAG: glycosyl transferase [Candidatus Rokuibacteriota bacterium] | diamond | 90 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28509754 | 28509754 | PRJNA946307_P_NODE_105207_length_182_cov_1.451128_g104333_i0 | PRJNA946307 | 105207 | 182 | 1.451128 | 2.64105296 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 66.2 | 1.01e-11 | NR | PYN46023.1 | 2053607 | g104333 | i0 | 63.8 | 2.34065934065934 | 47 | 17 | 77.5 | 0 | 5 | 145 | 114 | 160 | PYN46023.1 MAG: hypothetical protein DMD95_07275 [Candidatus Rokuibacteriota bacterium] | diamond | 426 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28604531 | 28604531 | PRJNA946307_P_NODE_171967_length_154_cov_2.723810_g171093_i0 | PRJNA946307 | 171967 | 154 | 2.72381 | 4.1946674 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 95.1 | 3.18e-21 | NR | PYN68605.1 | 2053607 | g171093 | i0 | 95.7 | 5.37662337662338 | 46 | 2 | 89.6 | 0 | 153 | 16 | 395 | 440 | PYN68605.1 MAG: amidohydrolase [Candidatus Rokuibacteriota bacterium] | diamond | 828 | 95.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29046660 | 29046660 | PRJNA946307_P_NODE_26448_length_251_cov_1.648515_g25574_i0 | PRJNA946307 | 26448 | 251 | 1.648515 | 4.13777265 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 104 | 3.3299999999999998e-25 | NR | MBM3221458.1 | 2053607 | g25574 | i0 | 69.2 | 4.74501992031873 | 78 | 19 | 93.2 | 2 | 247 | 14 | 151 | 223 | MBM3221458.1 taurine dioxygenase [Candidatus Rokuibacteriota bacterium] | diamond | 1191 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30310334 | 30310334 | PRJNA946307_P_NODE_39712_length_213_cov_2.713415_g38838_i0 | PRJNA946307 | 39712 | 213 | 2.713415 | 5.77957395 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 55.5 | 4.58e-7 | NR | MBI4635732.1 | 2053607 | g38838 | i0 | 71.9 | 0.450704225352113 | 32 | 9 | 45.1 | 0 | 8 | 103 | 69 | 100 | MBI4635732.1 hypothetical protein [Candidatus Rokuibacteriota bacterium] | diamond | 96 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 30657338 | 30657338 | PRJNA946307_P_NODE_69513_length_199_cov_3.166667_g68639_i0 | PRJNA946307 | 69513 | 199 | 3.166667 | 6.30166733 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 66.6 | 7.93e-11 | NR | PYM16494.1 | 2053607 | g68639 | i0 | 56.5 | 1.55276381909548 | 62 | 24 | 88.9 | 1 | 22 | 198 | 113 | 174 | PYM16494.1 MAG: hypothetical protein DMD81_12365 [Candidatus Rokuibacteriota bacterium] | diamond | 309 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32648995 | 32648995 | PRJNA946307_P_NODE_82680_length_192_cov_2.433566_g81806_i0 | PRJNA946307 | 82680 | 192 | 2.433566 | 4.67244672 | Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19 | 1802109 | Bacteria | Bacteria | 42 | 0.0359 | NR | OGL16340.1 | 1802109 | g81806 | i0 | 50 | 0.75 | 48 | 22 | 75 | 1 | 154 | 11 | 501 | 546 | OGL16340.1 MAG: hypothetical protein A3K12_00660 [Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19] | diamond | 144 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_19 |
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);;