contig_metadata
11 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Zixiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28557693 | 28557693 | PRJNA1237347_P_NODE_461227_length_255_cov_1.269231_g454654_i0 | PRJNA1237347 | 461227 | 255 | 1.269231 | 3.23653905 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 52 | 1.32e-5 | NR | MEZ5359667.1 | 2053527 | g454654 | i0 | 35.1 | 1.14117647058824 | 97 | 42 | 95.3 | 4 | 244 | 2 | 56 | 147 | MEZ5359667.1 lectin-like protein [Candidatus Zixiibacteriota bacterium] | diamond | 291 | 52 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 28747043 | 28747043 | PRJNA1237347_P_NODE_47787_length_1085_cov_4.924901_g42986_i0 | PRJNA1237347 | 47787 | 1085 | 4.924901 | 53.43517585 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 90.9 | 7.82e-16 | NR | MCK4372493.1 | 2053527 | g42986 | i0 | 41.8 | 0.83778801843318 | 141 | 80 | 39 | 2 | 445 | 867 | 256 | 394 | MCK4372493.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 909 | 90.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29000140 | 29000140 | PRJNA1237347_P_NODE_78808_length_794_cov_2.052705_g72737_i0 | PRJNA1237347 | 78808 | 794 | 2.052705 | 16.2984777 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 281 | 1.68e-83 | NR | TET94847.1 | 2053527 | g72737 | i0 | 51.9 | 9.88035264483627 | 260 | 125 | 98.2 | 0 | 6 | 785 | 761 | 1020 | TET94847.1 MAG: DUF748 domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 7845 | 281 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29693398 | 29693398 | PRJNA1237347_P_NODE_100870_length_677_cov_2.600993_g94475_i0 | PRJNA1237347 | 100870 | 677 | 2.600993 | 17.60872261 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 47.4 | 0.0052 | NR | MBI3873046.1 | 2053527 | g94475 | i0 | 31.7 | 1.19645494830133 | 145 | 80 | 64.3 | 6 | 205 | 639 | 5 | 130 | MBI3873046.1 30S ribosomal protein S11 [Candidatus Zixiibacteriota bacterium] | diamond | 810 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29996994 | 29996994 | PRJNA1237347_P_NODE_65251_length_895_cov_2.267640_g59593_i0 | PRJNA1237347 | 65251 | 895 | 2.26764 | 20.295378 | FCB group | 1783270 | Bacteria | Bacteria | 125 | 1.4399999999999998e-30 | NR | MCI0531590.1 | 2053527 | g59593 | i0 | 31.3 | 2.2927374301676 | 230 | 147 | 76.4 | 4 | 66 | 749 | 4 | 224 | MCI0531590.1 MIP family channel protein [Candidatus Zixiibacteriota bacterium] | diamond | 2052 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30041305 | 30041305 | PRJNA1237347_P_NODE_226691_length_399_cov_1.846626_g220119_i0 | PRJNA1237347 | 226691 | 399 | 1.846626 | 7.36803774 | candidate division Zixibacteria bacterium 4484_95 | 1970781 | Bacteria | Bacteria | 48.9 | 4.04e-4 | NR | OQX92923.1 | 1970781 | g220119 | i0 | 51.4 | 0.609022556390977 | 37 | 18 | 27.8 | 0 | 22 | 132 | 111 | 147 | OQX92923.1 MAG: hypothetical protein B6D58_00400 [candidate division Zixibacteria bacterium 4484_95] | diamond | 243 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | candidate division Zixibacteria bacterium 4484_95 | |||||
| 30135869 | 30135869 | PRJNA1237347_P_NODE_301872_length_333_cov_0.888462_g295299_i0 | PRJNA1237347 | 301872 | 333 | 0.888462 | 2.95857846 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 118 | 3.44e-28 | NR | MEW5702720.1 | 2053527 | g295299 | i0 | 60.9 | 1.65765765765766 | 92 | 36 | 82.9 | 0 | 1 | 276 | 417 | 508 | MEW5702720.1 S8 family serine peptidase [Candidatus Zixiibacteriota bacterium] | diamond | 552 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30483619 | 30483619 | PRJNA1237347_P_NODE_140833_length_546_cov_1.158562_g134295_i0 | PRJNA1237347 | 140833 | 546 | 1.158562 | 6.32574852 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 72.4 | 1.96e-11 | NR | MCP4581588.1 | 2053527 | g134295 | i0 | 43.2 | 0.483516483516484 | 88 | 49 | 47.8 | 1 | 271 | 531 | 27 | 114 | MCP4581588.1 alpha/beta hydrolase [Candidatus Zixiibacteriota bacterium] | diamond | 264 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30704913 | 30704913 | PRJNA1237347_P_NODE_33454_length_1339_cov_17.930490_g29661_i0 | PRJNA1237347 | 33454 | 1339 | 17.93049 | 240.0892611 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 352 | 1.15e-108 | NR | MCH7946189.1 | 2053527 | g29661 | i0 | 44.5 | 3.81777445855116 | 427 | 210 | 89.8 | 8 | 1252 | 50 | 22 | 447 | MCH7946189.1 trypsin-like peptidase domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 5112 | 352 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31020778 | 31020778 | PRJNA1237347_P_NODE_151195_length_521_cov_2.176339_g144644_i0 | PRJNA1237347 | 151195 | 521 | 2.176339 | 11.33872619 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 47.8 | 0.00939 | NR | MEW6015194.1 | 2053527 | g144644 | i0 | 28.4 | 0.81190019193858 | 141 | 91 | 80.6 | 5 | 517 | 98 | 160 | 291 | MEW6015194.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 423 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31355648 | 31355648 | PRJNA1237347_P_NODE_337396_length_310_cov_1.949367_g330823_i0 | PRJNA1237347 | 337396 | 310 | 1.949367 | 6.0430377 | Bacteria | 2 | Bacteria | Bacteria | 71.2 | 1.35e-12 | NR | MCH7879697.1 | 2053527 | g330823 | i0 | 37.6 | 2.98064516129032 | 101 | 61 | 95.8 | 2 | 11 | 307 | 20 | 120 | MCH7879697.1 AMP-binding protein [Candidatus Zixiibacteriota bacterium] | diamond | 924 | 71.6 | 0.994413407821229 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota 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);;