contig_metadata
13 rows where bioproject = "PRJNA688352" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19793764 | 19793764 | PRJNA688352_P_NODE_10876_length_244_cov_0.900585_g10773_i0 | PRJNA688352 | 10876 | 244 | 0.900585 | 2.1974274 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 133 | 3.95e-34 | NR | MEW6235980.1 | 2035772 | g10773 | i0 | 71.3 | 0.983606557377049 | 80 | 23 | 98.4 | 0 | 3 | 242 | 147 | 226 | MEW6235980.1 sugar-binding domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 240 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26607231 | 26607231 | PRJNA688352_P_NODE_10101_length_245_cov_0.895349_g9998_i0 | PRJNA688352 | 10101 | 245 | 0.895349 | 2.19360505 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 125 | 4.29e-33 | NR | MFH0754828.1 | 2035772 | g9998 | i0 | 65 | 0.979591836734694 | 80 | 28 | 98 | 0 | 242 | 3 | 86 | 165 | MFH0754828.1 inositol monophosphatase family protein [Candidatus Omnitrophota bacterium] | diamond | 240 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27176877 | 27176877 | PRJNA688352_P_NODE_9682_length_246_cov_0.890173_g9579_i0 | PRJNA688352 | 9682 | 246 | 0.890173 | 2.18982558 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 159 | 1.18e-44 | NR | MBN1526433.1 | 2035772 | g9579 | i0 | 85.4 | 3 | 82 | 12 | 100 | 0 | 1 | 246 | 90 | 171 | MBN1526433.1 homospermidine synthase [Candidatus Omnitrophota bacterium] | diamond | 738 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27398422 | 27398422 | PRJNA688352_P_NODE_11623_length_242_cov_0.911243_g11520_i0 | PRJNA688352 | 11623 | 242 | 0.911243 | 2.20520806 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 98.2 | 3.37e-23 | NR | MFA5144257.1 | 2035772 | g11520 | i0 | 79.7 | 4.38842975206612 | 59 | 12 | 73.1 | 0 | 178 | 2 | 1 | 59 | MFA5144257.1 aromatic aminobenezylarsenical efflux permease ArsG family transporter [Candidatus Omnitrophota bacterium] | diamond | 1062 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27524587 | 27524587 | PRJNA688352_P_NODE_11703_length_242_cov_0.911243_g11600_i0 | PRJNA688352 | 11703 | 242 | 0.911243 | 2.20520806 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 78.2 | 1.21e-14 | NR | MDD5347013.1 | 2035772 | g11600 | i0 | 53.6 | 0.855371900826446 | 69 | 32 | 85.5 | 0 | 1 | 207 | 639 | 707 | MDD5347013.1 response regulator [Candidatus Omnitrophota bacterium] | diamond | 207 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27651030 | 27651030 | PRJNA688352_P_NODE_7604_length_250_cov_0.870056_g7501_i0 | PRJNA688352 | 7604 | 250 | 0.870056 | 2.17514 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 86.7 | 1.82e-19 | NR | MCB9783662.1 | 2035772 | g7501 | i0 | 64.6 | 2.352 | 65 | 23 | 78 | 0 | 51 | 245 | 1 | 65 | MCB9783662.1 type II toxin-antitoxin system VapC family toxin [Candidatus Omnitrophota bacterium] | diamond | 588 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28629898 | 28629898 | PRJNA688352_P_NODE_7727_length_250_cov_0.870056_g7624_i0 | PRJNA688352 | 7727 | 250 | 0.870056 | 2.17514 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 105 | 2.15e-25 | NR | MFA5159095.1 | 2035772 | g7624 | i0 | 86.9 | 3.66 | 61 | 7 | 73.2 | 1 | 2 | 184 | 212 | 271 | MFA5159095.1 FtsQ-type POTRA domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 915 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29008922 | 29008922 | PRJNA688352_P_NODE_11768_length_242_cov_0.911243_g11665_i0 | PRJNA688352 | 11768 | 242 | 0.911243 | 2.20520806 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 144 | 2.3299999999999998e-38 | NR | MCA9423946.1 | 2035772 | g11665 | i0 | 78.8 | 0.991735537190083 | 80 | 17 | 99.2 | 0 | 242 | 3 | 319 | 398 | MCA9423946.1 MCE family protein [Candidatus Omnitrophota bacterium] | diamond | 240 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29103454 | 29103454 | PRJNA688352_P_NODE_9248_length_247_cov_0.885057_g9145_i0 | PRJNA688352 | 9248 | 247 | 0.885057 | 2.18609079 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 101 | 1.9099999999999998e-23 | NR | MDD5156226.1 | 2035772 | g9145 | i0 | 92 | 9.7165991902834 | 50 | 4 | 60.7 | 0 | 1 | 150 | 285 | 334 | MDD5156226.1 aspartate-semialdehyde dehydrogenase [Candidatus Omnitrophota bacterium] | diamond | 2400 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29608105 | 29608105 | PRJNA688352_P_NODE_8910_length_248_cov_0.880000_g8807_i0 | PRJNA688352 | 8910 | 248 | 0.88 | 2.1824 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 159 | 3.68e-45 | NR | MDD5422182.1 | 2035772 | g8807 | i0 | 95.1 | 4.95967741935484 | 82 | 4 | 99.2 | 0 | 3 | 248 | 311 | 392 | MDD5422182.1 phosphoglycerate kinase [Candidatus Omnitrophota bacterium] | diamond | 1230 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30935413 | 30935413 | PRJNA688352_P_NODE_10554_length_244_cov_0.900585_g10451_i0 | PRJNA688352 | 10554 | 244 | 0.900585 | 2.1974274 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 147 | 4.07e-39 | NR | MDD5156125.1 | 2035772 | g10451 | i0 | 91.4 | 6.97131147540984 | 81 | 7 | 99.6 | 0 | 244 | 2 | 317 | 397 | MDD5156125.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Candidatus Omnitrophota bacterium] | diamond | 1701 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32548636 | 32548636 | PRJNA688352_P_NODE_9779_length_246_cov_0.890173_g9676_i0 | PRJNA688352 | 9779 | 246 | 0.890173 | 2.18982558 | Candidatus Omnitrophica bacterium ADurb.Bin2 | 2035772 | Bacteria | Bacteria | 128 | 3.76e-35 | NR | OQB11197.1 | 1852852 | g9676 | i0 | 93 | 3.5 | 71 | 5 | 86.6 | 0 | 22 | 234 | 1 | 71 | OQB11197.1 MAG: LexA repressor [Candidatus Omnitrophica bacterium ADurb.Bin205] | diamond | 861 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophica bacterium ADurb.Bin205 | |||||
| 32768763 | 32768763 | PRJNA688352_P_NODE_8780_length_248_cov_0.880000_g8677_i0 | PRJNA688352 | 8780 | 248 | 0.88 | 2.1824 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 120 | 4.25e-30 | NR | MFC1666681.1 | 2035772 | g8677 | i0 | 70 | 0.967741935483871 | 80 | 24 | 96.8 | 0 | 2 | 241 | 134 | 213 | MFC1666681.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 240 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;