contig_metadata
5 rows where bioproject = "PRJNA681822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1170250 | 1170250 | PRJNA681822_P_NODE_248541_length_287_cov_1.168224_g247052_i0 | PRJNA681822 | 248541 | 287 | 1.168224 | 3.35280288 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 192 | 4.310000000000001e-59 | NR | PYN43001.1 | 2053607 | g247052 | i0 | 97.9 | 0.982578397212544 | 94 | 2 | 98.3 | 0 | 284 | 3 | 39 | 132 | PYN43001.1 MAG: hypothetical protein DME00_27875, partial [Candidatus Rokuibacteriota bacterium] | diamond | 282 | 192 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 2446325 | 2446325 | PRJNA681822_P_NODE_460122_length_243_cov_0.905882_g458632_i0 | PRJNA681822 | 460122 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 156 | 4.68e-42 | NR | MBM4443122.1 | 2053607 | g458632 | i0 | 93.4 | 2.81481481481481 | 76 | 5 | 93.8 | 0 | 229 | 2 | 554 | 629 | MBM4443122.1 indolepyruvate ferredoxin oxidoreductase family protein [Candidatus Rokuibacteriota bacterium] | diamond | 684 | 157 | 0.993630573248408 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 21572528 | 21572528 | PRJNA681822_P_NODE_247397_length_287_cov_1.425234_g245908_i0 | PRJNA681822 | 247397 | 287 | 1.425234 | 4.09042158 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 175 | 4.62e-50 | NR | MBM3221892.1 | 2053607 | g245908 | i0 | 90.5 | 0.993031358885017 | 95 | 9 | 99.3 | 0 | 286 | 2 | 253 | 347 | MBM3221892.1 acyl-CoA carboxylase subunit beta [Candidatus Rokuibacteriota bacterium] | diamond | 285 | 175 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 22330894 | 22330894 | PRJNA681822_P_NODE_248718_length_287_cov_1.112150_g247229_i0 | PRJNA681822 | 248718 | 287 | 1.11215 | 3.1918705 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 191 | 3.2799999999999997e-56 | NR | MBM3219383.1 | 2053607 | g247229 | i0 | 97.9 | 1.98606271777003 | 95 | 2 | 99.3 | 0 | 286 | 2 | 90 | 184 | MBM3219383.1 hypothetical protein [Candidatus Rokuibacteriota bacterium] | diamond | 570 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31314315 | 31314315 | PRJNA681822_P_NODE_220355_length_296_cov_2.959641_g218866_i0 | PRJNA681822 | 220355 | 296 | 2.959641 | 8.76053736 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 50.8 | 8.6700000000000007e-05 | NR | MBI2162004.1 | 2053607 | g218866 | i0 | 54.1 | 0.689189189189189 | 37 | 17 | 37.5 | 0 | 294 | 184 | 71 | 107 | MBI2162004.1 universal stress protein [Candidatus Rokuibacteriota bacterium] | diamond | 204 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota 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);;