contig_metadata
5 rows where bioproject = "PRJNA758398", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1204298 | 1204298 | PRJNA758398_S_NODE_45201_length_166_cov_0.871795_g45060_i0 | PRJNA758398 | 45201 | 166 | 0.871795 | 1.4471797 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 74.3 | 9.3e-14 | NR | MBK7104655.1 | 2026749 | g45060 | i0 | 60 | 1.98795180722892 | 55 | 22 | 99.4 | 0 | 166 | 2 | 238 | 292 | MBK7104655.1 NAD-dependent succinate-semialdehyde dehydrogenase [Ignavibacteriota bacterium] | diamond | 330 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 26831588 | 26831588 | PRJNA758398_S_NODE_36901_length_177_cov_1.593750_g36760_i0 | PRJNA758398 | 36901 | 177 | 1.59375 | 2.8209375 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 42 | 0.0294 | NR | NPV12827.1 | 2053306 | g36760 | i0 | 57.1 | 0.474576271186441 | 28 | 12 | 47.5 | 0 | 96 | 13 | 76 | 103 | NPV12827.1 adenylyltransferase/cytidyltransferase family protein [Ignavibacteria bacterium] | diamond | 84 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27400846 | 27400846 | PRJNA758398_S_NODE_3823_length_483_cov_2.373272_g3682_i0 | PRJNA758398 | 3823 | 483 | 2.373272 | 11.46290376 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 51.2 | 4.88e-4 | NR | MCF8412200.1 | 2614255 | g3682 | i0 | 36.1 | 1.46583850931677 | 119 | 60 | 69.6 | 4 | 81 | 416 | 722 | 831 | MCF8412200.1 choice-of-anchor A family protein [Melioribacteraceae bacterium] | diamond | 708 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 29210304 | 29210304 | PRJNA758398_S_NODE_23589_length_213_cov_1.243902_g23448_i0 | PRJNA758398 | 23589 | 213 | 1.243902 | 2.64951126 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.2 | 4.49e-7 | NR | WP_014856938.1 | 1134405 | g23448 | i0 | 50 | 5.12676056338028 | 52 | 26 | 73.2 | 0 | 58 | 213 | 96 | 147 | WP_014856938.1 protein kinase domain-containing protein [Melioribacter roseus] | diamond | 1092 | 56.6 | 0.992932862190813 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter roseus | |
| 30179277 | 30179277 | PRJNA758398_S_NODE_10812_length_295_cov_2.455285_g10671_i0 | PRJNA758398 | 10812 | 295 | 2.455285 | 7.24309075 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 61.2 | 1.74e-8 | NR | MBX3009837.1 | 2614255 | g10671 | i0 | 68.3 | 0.416949152542373 | 41 | 13 | 41.7 | 0 | 293 | 171 | 47 | 87 | MBX3009837.1 EF-hand domain-containing protein [Melioribacteraceae bacterium] | diamond | 123 | 61.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae 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);;