contig_metadata
8 rows where bioproject = "PRJNA407368", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18933183 | 18933183 | PRJNA407368_S_NODE_4695_length_260_cov_7.008658_g4593_i0 | PRJNA407368 | 4695 | 260 | 7.008658 | 18.2225108 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 120 | 3.93e-33 | NR | MDR3570671.1 | 2053589 | g4593 | i0 | 79.2 | 0.830769230769231 | 72 | 15 | 83.1 | 0 | 42 | 257 | 1 | 72 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 216 | 120 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26854197 | 26854197 | PRJNA407368_S_NODE_2141_length_420_cov_7.813299_g2040_i0 | PRJNA407368 | 2141 | 420 | 7.813299 | 32.8158558 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 144 | 9.65e-40 | NR | MCF7898694.1 | 2053589 | g2040 | i0 | 51.1 | 0.992857142857143 | 139 | 68 | 99.3 | 0 | 3 | 419 | 27 | 165 | MCF7898694.1 aspartate/glutamate racemase family protein [Candidatus Paceibacterota bacterium] | diamond | 417 | 144 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28496753 | 28496753 | PRJNA407368_S_NODE_607_length_820_cov_6.715550_g552_i0 | PRJNA407368 | 607 | 820 | 6.71555 | 55.06751 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 108 | 5.77e-25 | NR | MFA5831620.1 | 2053589 | g552 | i0 | 39.4 | 1.18170731707317 | 165 | 88 | 60 | 3 | 147 | 638 | 19 | 172 | MFA5831620.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 969 | 108 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28749219 | 28749219 | PRJNA407368_S_NODE_4127_length_284_cov_2.819608_g4025_i0 | PRJNA407368 | 4127 | 284 | 2.819608 | 8.00768672 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 57 | 5.3e-7 | NR | HRH24767.1 | 2053589 | g4025 | i0 | 75.7 | 0.390845070422535 | 37 | 9 | 39.1 | 0 | 53 | 163 | 305 | 341 | HRH24767.1 ParB/RepB/Spo0J family partition protein [Candidatus Paceibacterota bacterium] | diamond | 111 | 57 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29696030 | 29696030 | PRJNA407368_S_NODE_2530_length_382_cov_3.555241_g2428_i0 | PRJNA407368 | 2530 | 382 | 3.555241 | 13.58102062 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 123 | 9.289999999999999e-30 | NR | MBP9843068.1 | 2053589 | g2428 | i0 | 66.4 | 0.840314136125654 | 107 | 35 | 84 | 1 | 58 | 378 | 69 | 174 | MBP9843068.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 321 | 123 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30960193 | 30960193 | PRJNA407368_S_NODE_10334_length_153_cov_2.000000_g10232_i0 | PRJNA407368 | 10334 | 153 | 2 | 3.06 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.3 | 1.07e-9 | NR | MBP6858351.1 | 2053589 | g10232 | i0 | 89.3 | 0.549019607843137 | 28 | 3 | 54.9 | 0 | 148 | 65 | 31 | 58 | MBP6858351.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 84 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31529340 | 31529340 | PRJNA407368_S_NODE_3016_length_343_cov_3.331210_g2914_i0 | PRJNA407368 | 3016 | 343 | 3.33121 | 11.4260503 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 103 | 7.3e-23 | NR | HVU06829.1 | 2053589 | g2914 | i0 | 60.6 | 0.822157434402332 | 94 | 35 | 80.5 | 1 | 13 | 288 | 85 | 178 | HVU06829.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 282 | 103 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32825100 | 32825100 | PRJNA407368_S_NODE_3480_length_315_cov_2.339161_g3378_i0 | PRJNA407368 | 3480 | 315 | 2.339161 | 7.36835715 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 100 | 4.08e-25 | NR | MEX0597376.1 | 2053589 | g3378 | i0 | 65.8 | 0.752380952380952 | 79 | 27 | 75.2 | 0 | 243 | 7 | 1 | 79 | MEX0597376.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 237 | 100 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;