contig_metadata
8 rows where bioproject = "PRJNA1111082", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27352494 | 27352494 | PRJNA1111082_P_NODE_12743_length_240_cov_2.580838_g12698_i0 | PRJNA1111082 | 12743 | 240 | 2.580838 | 6.1940112 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 77 | 2.96e-14 | NR | MFA6095649.1 | 2053589 | g12698 | i0 | 46.8 | 0.9625 | 77 | 40 | 95 | 1 | 238 | 11 | 198 | 274 | MFA6095649.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 231 | 77 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28109927 | 28109927 | PRJNA1111082_P_NODE_9225_length_268_cov_1.066667_g9180_i0 | PRJNA1111082 | 9225 | 268 | 1.066667 | 2.85866756 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 153 | 2.7499999999999993e-43 | NR | HEY6020310.1 | 2053589 | g9180 | i0 | 78.7 | 0.996268656716418 | 89 | 19 | 99.6 | 0 | 268 | 2 | 213 | 301 | HEY6020310.1 phage terminase large subunit [Candidatus Paceibacterota bacterium] | diamond | 267 | 153 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28394160 | 28394160 | PRJNA1111082_P_NODE_9606_length_262_cov_2.063492_g9561_i0 | PRJNA1111082 | 9606 | 262 | 2.063492 | 5.40634904 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 102 | 1.36e-25 | NR | HEY4515574.1 | 2053589 | g9561 | i0 | 64.7 | 0.973282442748092 | 85 | 30 | 97.3 | 0 | 3 | 257 | 33 | 117 | HEY4515574.1 type II secretion system protein [Candidatus Paceibacterota bacterium] | diamond | 255 | 102 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28489015 | 28489015 | PRJNA1111082_P_NODE_9207_length_268_cov_1.415385_g9162_i0 | PRJNA1111082 | 9207 | 268 | 1.415385 | 3.7932318 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 150 | 2.76e-44 | NR | MBP9818958.1 | 2053589 | g9162 | i0 | 79.8 | 0.996268656716418 | 89 | 18 | 99.6 | 0 | 268 | 2 | 36 | 124 | MBP9818958.1 IS200/IS605 family transposase [Candidatus Paceibacterota bacterium] | diamond | 267 | 150 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28638249 | 28638249 | PRJNA1111082_P_NODE_1147_length_649_cov_1.631944_g1103_i0 | PRJNA1111082 | 1147 | 649 | 1.631944 | 10.59131656 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 134 | 3.58e-36 | NR | MDD5152819.1 | 2053589 | g1103 | i0 | 49.3 | 2.03852080123267 | 140 | 68 | 63.3 | 1 | 448 | 38 | 15 | 154 | MDD5152819.1 DUF4446 family protein [Candidatus Paceibacterota bacterium] | diamond | 1323 | 134 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28899217 | 28899217 | PRJNA1111082_P_NODE_10068_length_256_cov_1.415301_g10023_i0 | PRJNA1111082 | 10068 | 256 | 1.415301 | 3.62317056 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 109 | 1.0600000000000002e-27 | NR | MCF7865580.1 | 2053589 | g10023 | i0 | 82.5 | 2.21484375 | 63 | 11 | 73.8 | 0 | 67 | 255 | 16 | 78 | MCF7865580.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 567 | 109 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30036232 | 30036232 | PRJNA1111082_P_NODE_6431_length_316_cov_1.086420_g6386_i0 | PRJNA1111082 | 6431 | 316 | 1.08642 | 3.4330872 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.8 | 0.00674 | NR | MDD3048279.1 | 2053589 | g6386 | i0 | 48.8 | 0.408227848101266 | 43 | 22 | 40.8 | 0 | 220 | 92 | 83 | 125 | MDD3048279.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 129 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30225714 | 30225714 | PRJNA1111082_P_NODE_1912_length_531_cov_1.672489_g1867_i0 | PRJNA1111082 | 1912 | 531 | 1.672489 | 8.88091659 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 197 | 2e-61 | NR | MDI9407801.1 | 2053589 | g1867 | i0 | 62.2 | 0.807909604519774 | 143 | 54 | 80.8 | 0 | 92 | 520 | 1 | 143 | MDI9407801.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 429 | 197 | 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);;