contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax_phylum = "Candidatus Sumerlaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14875317 | 14875317 | PRJNA864829_S_NODE_7192_length_229_cov_1.444444_g7106_i0 | PRJNA864829 | 7192 | 229 | 1.444444 | 3.30777676 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 137 | 7.81e-37 | NR | MDX2176735.1 | 2715255 | g7106 | i0 | 89.2 | 0.96943231441048 | 74 | 8 | 96.9 | 0 | 225 | 4 | 113 | 186 | MDX2176735.1 serine/threonine-protein kinase [Candidatus Sumerlaeia bacterium] | diamond | 222 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 27371480 | 27371480 | PRJNA864829_S_NODE_9043_length_208_cov_1.691824_g8957_i0 | PRJNA864829 | 9043 | 208 | 1.691824 | 3.51899392 | Candidatus Sumerlaeaceae bacterium | 2315423 | Bacteria | Bacteria | 81.3 | 6e-16 | NR | MBX7246206.1 | 2315423 | g8957 | i0 | 57.4 | 0.879807692307692 | 61 | 26 | 88 | 0 | 206 | 24 | 477 | 537 | MBX7246206.1 DUF1800 domain-containing protein [Candidatus Sumerlaeaceae bacterium] | diamond | 183 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaeaceae bacterium | |||
| 28918134 | 28918134 | PRJNA864829_S_NODE_7668_length_223_cov_1.534483_g7582_i0 | PRJNA864829 | 7668 | 223 | 1.534483 | 3.42189709 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 99 | 2.54e-22 | NR | MBI1784187.1 | 2107588 | g7582 | i0 | 63 | 0.982062780269058 | 73 | 27 | 98.2 | 0 | 3 | 221 | 14 | 86 | MBI1784187.1 VCBS repeat-containing protein [Candidatus Sumerlaeota bacterium] | diamond | 219 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 29171056 | 29171056 | PRJNA864829_S_NODE_13309_length_176_cov_1.259843_g13223_i0 | PRJNA864829 | 13309 | 176 | 1.259843 | 2.21732368 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 103 | 5.9e-25 | NR | MBI3735722.1 | 2107588 | g13223 | i0 | 81 | 0.988636363636364 | 58 | 11 | 98.9 | 0 | 2 | 175 | 153 | 210 | MBI3735722.1 FAD binding domain-containing protein [Candidatus Sumerlaeota bacterium] | diamond | 174 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 29360417 | 29360417 | PRJNA864829_S_NODE_13609_length_174_cov_1.672000_g13523_i0 | PRJNA864829 | 13609 | 174 | 1.672 | 2.90928 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 49.3 | 7.14e-5 | NR | MBI1785113.1 | 2107588 | g13523 | i0 | 45.1 | 0.879310344827586 | 51 | 28 | 87.9 | 0 | 172 | 20 | 315 | 365 | MBI1785113.1 tetratricopeptide repeat protein [Candidatus Sumerlaeota bacterium] | diamond | 153 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 30118182 | 30118182 | PRJNA864829_S_NODE_2492_length_338_cov_1.301038_g2406_i0 | PRJNA864829 | 2492 | 338 | 1.301038 | 4.39750844 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 132 | 2.3499999999999997e-35 | NR | MBI1785660.1 | 2107588 | g2406 | i0 | 59.8 | 0.86094674556213 | 97 | 39 | 86.1 | 0 | 47 | 337 | 135 | 231 | MBI1785660.1 response regulator [Candidatus Sumerlaeota bacterium] | diamond | 291 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 31833116 | 31833116 | PRJNA864829_S_NODE_2657_length_330_cov_2.861210_g2571_i0 | PRJNA864829 | 2657 | 330 | 2.86121 | 9.441993 | Bacteria | 2 | Bacteria | Bacteria | 114 | 5.45e-29 | NR | MCC6546374.1 | 2107588 | g2571 | i0 | 77 | 1.35454545454545 | 74 | 17 | 67.3 | 0 | 227 | 6 | 10 | 83 | MCC6546374.1 glycosyltransferase family 2 protein [Candidatus Sumerlaeota bacterium] | diamond | 447 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 32836230 | 32836230 | PRJNA864829_S_NODE_16220_length_161_cov_2.169643_g16134_i0 | PRJNA864829 | 16220 | 161 | 2.169643 | 3.49312523 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 45.4 | 0.00137 | NR | MDX2177323.1 | 2715255 | g16134 | i0 | 45.7 | 0.857142857142857 | 46 | 22 | 85.7 | 1 | 159 | 22 | 150 | 192 | MDX2177323.1 hypothetical protein [Candidatus Sumerlaeia bacterium] | diamond | 138 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 32836231 | 32836231 | PRJNA864829_S_NODE_2880_length_321_cov_2.654412_g2794_i0 | PRJNA864829 | 2880 | 321 | 2.654412 | 8.52066252 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 159 | 1.12e-45 | NR | MBI1785705.1 | 2107588 | g2794 | i0 | 74.3 | 0.981308411214953 | 105 | 27 | 98.1 | 0 | 6 | 320 | 21 | 125 | MBI1785705.1 PP2C family protein-serine/threonine phosphatase [Candidatus Sumerlaeota bacterium] | diamond | 315 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota 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);;