contig_metadata
11 rows where bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3677559 | 3677559 | PRJNA556992_P_NODE_431603_length_273_cov_3.180000_g429414_i0 | PRJNA556992 | 431603 | 273 | 3.18 | 8.6814 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 499 | 7.45e-137 | NTclustered | gi|1419285073|gb|CP030759.1| | 2250252 | g429414 | i0 | 99.634 | 109 | 273 | 1 | 100 | 0 | 1 | 273 | 2029473 | 2029745 | Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome | blastn | 29757 | 499 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaea | Candidatus Sumerlaea chitinivorans | ||
| 26857591 | 26857591 | PRJNA556992_P_NODE_881961_length_241_cov_7.904762_g879771_i0 | PRJNA556992 | 881961 | 241 | 7.904762 | 19.05047642 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 131 | 5.09e-35 | NR | MCX7044289.1 | 2107588 | g879771 | i0 | 74.4 | 0.970954356846473 | 78 | 20 | 97.1 | 0 | 239 | 6 | 78 | 155 | MCX7044289.1 alpha/beta hydrolase [Candidatus Sumerlaeota bacterium] | diamond | 234 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 27299977 | 27299977 | PRJNA556992_P_NODE_756543_length_248_cov_2.022857_g754354_i0 | PRJNA556992 | 756543 | 248 | 2.022857 | 5.01668536 | Candidatus Sumerlaeaceae bacterium | 2315423 | Bacteria | Bacteria | 101 | 4.57e-26 | NR | MBX7244758.1 | 2315423 | g754354 | i0 | 59.2 | 0.919354838709677 | 76 | 31 | 91.9 | 0 | 246 | 19 | 2 | 77 | MBX7244758.1 hypothetical protein [Candidatus Sumerlaeaceae bacterium] | diamond | 228 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaeaceae bacterium | |||
| 27615540 | 27615540 | PRJNA556992_P_NODE_1082944_length_216_cov_16.783217_g1080753_i0 | PRJNA556992 | 1082944 | 216 | 16.783217 | 36.25174872 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 90.1 | 4.42e-19 | NR | MCC5875663.1 | 2715255 | g1080753 | i0 | 57.7 | 0.986111111111111 | 71 | 30 | 98.6 | 0 | 214 | 2 | 32 | 102 | MCC5875663.1 protein kinase [Candidatus Sumerlaeia bacterium] | diamond | 213 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 28025965 | 28025965 | PRJNA556992_P_NODE_1116445_length_209_cov_4.389706_g1114254_i0 | PRJNA556992 | 1116445 | 209 | 4.389706 | 9.17448554 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 84 | 1.4e-17 | NR | MBX3729993.1 | 2715255 | g1114254 | i0 | 65.5 | 1.63636363636364 | 58 | 20 | 83.3 | 0 | 35 | 208 | 98 | 155 | MBX3729993.1 serine/threonine protein kinase [Candidatus Sumerlaeia bacterium] | diamond | 342 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 29162836 | 29162836 | PRJNA556992_P_NODE_118749_length_384_cov_4.723473_g116562_i0 | PRJNA556992 | 118749 | 384 | 4.723473 | 18.13813632 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 112 | 1.08e-28 | NR | NUP90114.1 | 2715255 | g116562 | i0 | 91.2 | 0.4453125 | 57 | 5 | 44.5 | 0 | 171 | 1 | 1 | 57 | NUP90114.1 type VI secretion system tube protein Hcp [Candidatus Sumerlaeia bacterium] | diamond | 171 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 29446606 | 29446606 | PRJNA556992_P_NODE_234070_length_310_cov_3.468354_g231882_i0 | PRJNA556992 | 234070 | 310 | 3.468354 | 10.7518974 | Sumerlaeia bacterium | 3066091 | Bacteria | Bacteria | 61.2 | 2.51e-8 | NR | MEQ8822032.1 | 3066091 | g231882 | i0 | 56.5 | 0.445161290322581 | 46 | 20 | 44.5 | 0 | 166 | 303 | 104 | 149 | MEQ8822032.1 RHS repeat-associated core domain-containing protein [Sumerlaeia bacterium] | diamond | 138 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Sumerlaeia bacterium | |||||
| 29794278 | 29794278 | PRJNA556992_P_NODE_817351_length_245_cov_1.441860_g815161_i0 | PRJNA556992 | 817351 | 245 | 1.44186 | 3.532557 | Candidatus Sumerlaeaceae bacterium | 2315423 | Bacteria | Bacteria | 86.7 | 3.09e-18 | NR | MCX7625309.1 | 2315423 | g815161 | i0 | 56.3 | 0.979591836734694 | 80 | 35 | 98 | 0 | 2 | 241 | 193 | 272 | MCX7625309.1 NAD(P)H-binding protein [Candidatus Sumerlaeaceae bacterium] | diamond | 240 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaeaceae bacterium | |||
| 30363570 | 30363570 | PRJNA556992_P_NODE_950932_length_235_cov_5.191358_g948742_i0 | PRJNA556992 | 950932 | 235 | 5.191358 | 12.1996913 | Candidatus Sumerlaeaceae bacterium | 2315423 | Bacteria | Bacteria | 62.4 | 3.93e-9 | NR | MBX7245978.1 | 2315423 | g948742 | i0 | 64.2 | 0.676595744680851 | 53 | 16 | 67.7 | 2 | 2 | 160 | 154 | 203 | MBX7245978.1 polysaccharide deacetylase family protein [Candidatus Sumerlaeaceae bacterium] | diamond | 159 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaeaceae bacterium | |||
| 31722031 | 31722031 | PRJNA556992_P_NODE_512077_length_266_cov_2.072539_g509888_i0 | PRJNA556992 | 512077 | 266 | 2.072539 | 5.51295374 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 44.3 | 0.00444 | NR | MCH8332731.1 | 2107588 | g509888 | i0 | 59.3 | 0.304511278195489 | 27 | 11 | 30.5 | 0 | 1 | 81 | 98 | 124 | MCH8332731.1 response regulator [Candidatus Sumerlaeota bacterium] | diamond | 81 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 32449870 | 32449870 | PRJNA556992_P_NODE_272379_length_295_cov_7.990991_g270190_i0 | PRJNA556992 | 272379 | 295 | 7.990991 | 23.57342345 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 161 | 2.6099999999999998e-48 | NR | NUP90114.1 | 2715255 | g270190 | i0 | 80.6 | 0.996610169491525 | 98 | 19 | 99.7 | 0 | 2 | 295 | 67 | 164 | NUP90114.1 type VI secretion system tube protein Hcp [Candidatus Sumerlaeia bacterium] | diamond | 294 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia 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);;