contig_metadata
9 rows where bioproject = "PRJNA799842" and tax_phylum = "Candidatus Deferrimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25020280 | 25020280 | PRJNA799842_P_NODE_157620_length_247_cov_0.885057_g156047_i0 | PRJNA799842 | 157620 | 247 | 0.885057 | 2.18609079 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 159 | 2.1e-44 | NR | HSQ49046.1 | 3069220 | g156047 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 247 | 2 | 8 | 89 | HSQ49046.1 preprotein translocase subunit SecY [Candidatus Deferrimicrobiaceae bacterium] | diamond | 246 | 159 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 26958893 | 26958893 | PRJNA799842_P_NODE_148162_length_249_cov_0.875000_g146589_i0 | PRJNA799842 | 148162 | 249 | 0.875 | 2.17875 | Candidatus Deferrimicrobium sp. | 3060586 | Bacteria | Bacteria | 155 | 1.5299999999999998e-42 | NR | HEX2709340.1 | 3060586 | g146589 | i0 | 95.1 | 2.96385542168675 | 82 | 4 | 98.8 | 0 | 248 | 3 | 127 | 208 | HEX2709340.1 AMIN domain-containing protein [Candidatus Deferrimicrobium sp.] | diamond | 738 | 155 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobium | Candidatus Deferrimicrobium sp. | |||
| 27401849 | 27401849 | PRJNA799842_P_NODE_90423_length_305_cov_1.090517_g88850_i0 | PRJNA799842 | 90423 | 305 | 1.090517 | 3.32607685 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 94.7 | 2.22e-22 | NR | HSQ48434.1 | 3069220 | g88850 | i0 | 88 | 0.491803278688525 | 50 | 6 | 49.2 | 0 | 152 | 3 | 25 | 74 | HSQ48434.1 type II toxin-antitoxin system VapC family toxin [Candidatus Deferrimicrobiaceae bacterium] | diamond | 150 | 94.7 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 29296099 | 29296099 | PRJNA799842_P_NODE_141089_length_250_cov_0.870056_g139516_i0 | PRJNA799842 | 141089 | 250 | 0.870056 | 2.17514 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 152 | 3.05e-44 | NR | HSQ48759.1 | 3069220 | g139516 | i0 | 97.6 | 0.984 | 82 | 2 | 98.4 | 0 | 247 | 2 | 54 | 135 | HSQ48759.1 archaeal proteasome endopeptidase complex subunit beta [Candidatus Deferrimicrobiaceae bacterium] | diamond | 246 | 152 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 29422254 | 29422254 | PRJNA799842_P_NODE_92149_length_302_cov_1.344978_g90576_i0 | PRJNA799842 | 92149 | 302 | 1.344978 | 4.06183356 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 188 | 1.03e-56 | NR | HSQ48794.1 | 3069220 | g90576 | i0 | 96 | 0.983443708609272 | 99 | 4 | 98.3 | 0 | 298 | 2 | 43 | 141 | HSQ48794.1 trypsin-like peptidase domain-containing protein [Candidatus Deferrimicrobiaceae bacterium] | diamond | 297 | 188 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 30780685 | 30780685 | PRJNA799842_P_NODE_159434_length_247_cov_0.885057_g157861_i0 | PRJNA799842 | 159434 | 247 | 0.885057 | 2.18609079 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 120 | 6.209999999999999e-31 | NR | HSQ48725.1 | 3069220 | g157861 | i0 | 80.3 | 3.44939271255061 | 71 | 14 | 86.2 | 0 | 215 | 3 | 137 | 207 | HSQ48725.1 DUF2090 domain-containing protein [Candidatus Deferrimicrobiaceae bacterium] | diamond | 852 | 120 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 32425235 | 32425235 | PRJNA799842_P_NODE_149659_length_248_cov_1.320000_g148086_i0 | PRJNA799842 | 149659 | 248 | 1.32 | 3.2736 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 147 | 3.27e-41 | NR | HSQ48813.1 | 3069220 | g148086 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 246 | 1 | 214 | 295 | HSQ48813.1 magnesium transporter CorA family protein [Candidatus Deferrimicrobiaceae bacterium] | diamond | 246 | 147 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 32614826 | 32614826 | PRJNA799842_P_NODE_157400_length_247_cov_0.885057_g155827_i0 | PRJNA799842 | 157400 | 247 | 0.885057 | 2.18609079 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 102 | 8.45e-25 | NR | HSQ49606.1 | 3069220 | g155827 | i0 | 80.9 | 0.825910931174089 | 68 | 12 | 82.6 | 1 | 204 | 1 | 43 | 109 | HSQ49606.1 endonuclease III [Candidatus Deferrimicrobiaceae bacterium] | diamond | 204 | 102 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae bacterium | ||||
| 32866631 | 32866631 | PRJNA799842_P_NODE_185320_length_242_cov_0.911243_g183747_i0 | PRJNA799842 | 185320 | 242 | 0.911243 | 2.20520806 | Candidatus Deferrimicrobiaceae bacterium | 3069220 | Bacteria | Bacteria | 165 | 1.53e-46 | NR | HSQ49424.1 | 3069220 | g183747 | i0 | 96.3 | 0.991735537190083 | 80 | 3 | 99.2 | 0 | 3 | 242 | 340 | 419 | HSQ49424.1 glycoside hydrolase family 57 protein [Candidatus Deferrimicrobiaceae bacterium] | diamond | 240 | 165 | 1 | Bacteria | Candidatus Deferrimicrobiota | Candidatus Deferrimicrobia | Candidatus Deferrimicrobiales | Candidatus Deferrimicrobiaceae | Candidatus Deferrimicrobiaceae 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);;