contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA785164" and tax_phylum = "Candidatus Moraniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27053733 | 27053733 | PRJNA785164_P_NODE_58442_length_244_cov_0.900585_g57977_i0 | PRJNA785164 | 58442 | 244 | 0.900585 | 2.1974274 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 60.8 | 9.77e-9 | NR | MBP9698155.1 | 2045217 | g57977 | i0 | 54.4 | 0.700819672131147 | 57 | 26 | 70.1 | 0 | 73 | 243 | 1 | 57 | MBP9698155.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Moraniibacteriota bacterium] | diamond | 171 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 28768187 | 28768187 | PRJNA785164_P_NODE_23747_length_384_cov_1.639871_g23282_i0 | PRJNA785164 | 23747 | 384 | 1.639871 | 6.29710464 | Bacteria | 2 | Bacteria | Bacteria | 92.4 | 7.99e-19 | NR | QQR77515.1 | 2045217 | g23282 | i0 | 52.6 | 2.2890625 | 95 | 43 | 73.4 | 2 | 282 | 1 | 518 | 611 | QQR77515.1 MAG: hypothetical protein IPJ67_05325 [Candidatus Moraniibacteriota bacterium] | diamond | 879 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 29516648 | 29516648 | PRJNA785164_P_NODE_31490_length_325_cov_1.269841_g31025_i0 | PRJNA785164 | 31490 | 325 | 1.269841 | 4.12698325 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 73.2 | 2.09e-12 | NR | HAI74055.1 | 2045217 | g31025 | i0 | 61.7 | 1.24615384615385 | 60 | 23 | 55.4 | 0 | 324 | 145 | 517 | 576 | HAI74055.1 hypothetical protein [Candidatus Moraniibacteriota bacterium] | diamond | 405 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota 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);;