contig_metadata
6 rows where bioproject = "PRJNA379145", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8054214 | 8054214 | PRJNA379145_P_NODE_50127_length_233_cov_1.305000_g47973_i0 | PRJNA379145 | 50127 | 233 | 1.305 | 3.04065 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 118 | 6.9e-29 | NR | MCQ9205303.1 | 2035772 | g47973 | i0 | 76.3 | 2.76824034334764 | 76 | 18 | 97.9 | 0 | 5 | 232 | 779 | 854 | MCQ9205303.1 pyruvate, phosphate dikinase [Candidatus Omnitrophota bacterium] | diamond | 645 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 15703420 | 15703420 | PRJNA379145_P_NODE_24333_length_507_cov_9.516878_g22321_i0 | PRJNA379145 | 24333 | 507 | 9.516878 | 48.25057146 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 223 | 3.84e-71 | NR | MCA9403081.1 | 2035772 | g22321 | i0 | 69.5 | 7.24260355029586 | 151 | 42 | 87 | 1 | 474 | 34 | 57 | 207 | MCA9403081.1 peptide-methionine (R)-S-oxide reductase MsrB [Candidatus Omnitrophota bacterium] | diamond | 3672 | 223 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26694985 | 26694985 | PRJNA379145_P_NODE_33821_length_366_cov_1.837838_g31676_i0 | PRJNA379145 | 33821 | 366 | 1.837838 | 6.72648708 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 82.8 | 1.42e-15 | NR | MEW6236892.1 | 2035772 | g31676 | i0 | 39.7 | 0.991803278688525 | 121 | 72 | 99.2 | 1 | 3 | 365 | 546 | 665 | MEW6236892.1 L-fucokinase [Candidatus Omnitrophota bacterium] | diamond | 363 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29127812 | 29127812 | PRJNA379145_P_NODE_31529_length_395_cov_2.436464_g29398_i0 | PRJNA379145 | 31529 | 395 | 2.436464 | 9.6240328 | Omnitrophica WOR_2 bacterium SM23_29 | 1703776 | Bacteria | Bacteria | 47 | 0.00582 | NR | KPK38701.1 | 1703776 | g29398 | i0 | 34.7 | 0.569620253164557 | 75 | 49 | 57 | 0 | 324 | 100 | 147 | 221 | KPK38701.1 MAG: hypothetical protein AMJ78_09595 [Omnitrophica WOR_2 bacterium SM23_29] | diamond | 225 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium SM23_29 | |||||
| 30043317 | 30043317 | PRJNA379145_P_NODE_5571_length_1280_cov_3.058540_g4886_i0 | PRJNA379145 | 5571 | 1280 | 3.05854 | 39.149312 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 144 | 3.93e-37 | NR | MFT5207936.1 | 2035772 | g4886 | i0 | 40 | 0.91171875 | 180 | 108 | 42.2 | 0 | 123 | 662 | 5 | 184 | MFT5207936.1 peroxiredoxin [Candidatus Omnitrophota bacterium] | diamond | 1167 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31798571 | 31798571 | PRJNA379145_P_NODE_35997_length_341_cov_2.172078_g33849_i0 | PRJNA379145 | 35997 | 341 | 2.172078 | 7.40678598 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 105 | 4.59e-25 | NR | MBU4478697.1 | 2035772 | g33849 | i0 | 74.3 | 7.3900293255132 | 70 | 18 | 61.6 | 0 | 213 | 4 | 179 | 248 | MBU4478697.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Omnitrophota bacterium] | diamond | 2520 | 106 | 0.990566037735849 | 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);;