contig_metadata
12 rows where bioproject = "PRJNA946307", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27278387 | 27278387 | PRJNA946307_P_NODE_38403_length_214_cov_9.551515_g37529_i0 | PRJNA946307 | 38403 | 214 | 9.551515 | 20.4402421 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 50.8 | 3.19e-6 | NR | MDP7368461.1 | 2053589 | g37529 | i0 | 70.4 | 0.378504672897196 | 27 | 8 | 37.9 | 0 | 201 | 121 | 42 | 68 | MDP7368461.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 81 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28509893 | 28509893 | PRJNA946307_P_NODE_93707_length_187_cov_1.413043_g92833_i0 | PRJNA946307 | 93707 | 187 | 1.413043 | 2.64239041 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 46.6 | 4.73e-4 | NR | HEY6019753.1 | 2053589 | g92833 | i0 | 46.7 | 0.962566844919786 | 60 | 29 | 91.4 | 1 | 186 | 16 | 73 | 132 | HEY6019753.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 180 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29204635 | 29204635 | PRJNA946307_P_NODE_67669_length_199_cov_4.040000_g66795_i0 | PRJNA946307 | 67669 | 199 | 4.04 | 8.0396 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.5 | 9.62e-10 | NR | HEY4523299.1 | 2053589 | g66795 | i0 | 57.1 | 0.949748743718593 | 63 | 1 | 55.8 | 1 | 16 | 126 | 562 | 624 | HEY4523299.1 glycosyltransferase family 39 protein [Candidatus Paceibacterota bacterium] | diamond | 189 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29930889 | 29930889 | PRJNA946307_P_NODE_65271_length_200_cov_3.033113_g64397_i0 | PRJNA946307 | 65271 | 200 | 3.033113 | 6.066226 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.1 | 0.00331 | NR | HRY76683.1 | 2053589 | g64397 | i0 | 46.2 | 0.585 | 39 | 21 | 58.5 | 0 | 186 | 70 | 953 | 991 | HRY76683.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 117 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30657333 | 30657333 | PRJNA946307_P_NODE_61193_length_205_cov_1.756410_g60319_i0 | PRJNA946307 | 61193 | 205 | 1.75641 | 3.6006405 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 104 | 1.15e-26 | NR | MFA5934563.1 | 2053589 | g60319 | i0 | 76.6 | 1.87317073170732 | 64 | 15 | 93.7 | 0 | 14 | 205 | 28 | 91 | MFA5934563.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 384 | 104 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31447553 | 31447553 | PRJNA946307_P_NODE_70216_length_199_cov_3.120000_g69342_i0 | PRJNA946307 | 70216 | 199 | 3.12 | 6.2088 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 78.6 | 4.16e-15 | NR | MDI9407646.1 | 2053589 | g69342 | i0 | 64.9 | 0.85929648241206 | 57 | 13 | 75.4 | 1 | 18 | 167 | 1 | 57 | MDI9407646.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 171 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31985119 | 31985119 | PRJNA946307_P_NODE_122778_length_174_cov_1.552000_g121904_i0 | PRJNA946307 | 122778 | 174 | 1.552 | 2.70048 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94 | 4.13e-21 | NR | MDA8596735.1 | 2053589 | g121904 | i0 | 84.9 | 0.913793103448276 | 53 | 8 | 91.4 | 0 | 2 | 160 | 120 | 172 | MDA8596735.1 AI-2E family transporter [Candidatus Paceibacterota bacterium] | diamond | 159 | 94 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32396760 | 32396760 | PRJNA946307_P_NODE_99339_length_184_cov_3.125926_g98465_i0 | PRJNA946307 | 99339 | 184 | 3.125926 | 5.75170384 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.9 | 1.18e-10 | NR | MDP7368527.1 | 2053589 | g98465 | i0 | 55.6 | 1.76086956521739 | 54 | 24 | 88 | 0 | 167 | 6 | 114 | 167 | MDP7368527.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 324 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32428380 | 32428380 | PRJNA946307_P_NODE_91379_length_188_cov_1.489209_g90505_i0 | PRJNA946307 | 91379 | 188 | 1.489209 | 2.79971292 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 41.2 | 0.00975 | NR | MFA5747003.1 | 2053589 | g90505 | i0 | 53.8 | 0.622340425531915 | 39 | 17 | 62.2 | 1 | 117 | 1 | 7 | 44 | MFA5747003.1 helix-turn-helix transcriptional regulator [Candidatus Paceibacterota bacterium] | diamond | 117 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32459947 | 32459947 | PRJNA946307_P_NODE_120859_length_175_cov_1.325397_g119985_i0 | PRJNA946307 | 120859 | 175 | 1.325397 | 2.31944475 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 97.1 | 2.42e-22 | NR | MDI9407818.1 | 2053589 | g119985 | i0 | 81.8 | 2.79428571428571 | 55 | 10 | 94.3 | 0 | 174 | 10 | 271 | 325 | MDI9407818.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 489 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32491690 | 32491690 | PRJNA946307_P_NODE_58879_length_209_cov_3.700000_g58005_i0 | PRJNA946307 | 58879 | 209 | 3.7 | 7.733 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 129 | 5.05e-33 | NR | MDI9397058.1 | 2053589 | g58005 | i0 | 88.1 | 1.92344497607656 | 67 | 8 | 96.2 | 0 | 1 | 201 | 109 | 175 | MDI9397058.1 primosomal protein N' [Candidatus Paceibacterota bacterium] | diamond | 402 | 129 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32617728 | 32617728 | PRJNA946307_P_NODE_110820_length_179_cov_2.184615_g109946_i0 | PRJNA946307 | 110820 | 179 | 2.184615 | 3.91046085 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 46.6 | 1.35e-4 | NR | HEY6018801.1 | 2053589 | g109946 | i0 | 78.6 | 0.46927374301676 | 28 | 6 | 46.9 | 0 | 166 | 83 | 72 | 99 | HEY6018801.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 84 | 46.6 | 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);;