contig_metadata
7 rows where bioproject = "PRJNA565584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10760051 | 10760051 | PRJNA565584_P_NODE_177169_length_249_cov_0.875000_g176017_i0 | PRJNA565584 | 177169 | 249 | 0.875 | 2.17875 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 86.7 | 4.05e-19 | NR | HSV29188.1 | 2035772 | g176017 | i0 | 73.3 | 0.903614457831325 | 75 | 20 | 90.4 | 0 | 2 | 226 | 103 | 177 | HSV29188.1 F0F1 ATP synthase subunit B [Candidatus Omnitrophota bacterium] | diamond | 225 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27205635 | 27205635 | PRJNA565584_P_NODE_65222_length_368_cov_1.040678_g64071_i0 | PRJNA565584 | 65222 | 368 | 1.040678 | 3.82969504 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 45.4 | 0.0181 | NR | MFA5499444.1 | 2035772 | g64071 | i0 | 28.4 | 0.717391304347826 | 88 | 60 | 71.7 | 2 | 2 | 265 | 1859 | 1943 | MFA5499444.1 PEP/pyruvate-binding domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 264 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27584928 | 27584928 | PRJNA565584_P_NODE_54344_length_403_cov_2.039394_g53193_i0 | PRJNA565584 | 54344 | 403 | 2.039394 | 8.21875782 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 68.6 | 2.27e-10 | NR | MFA5143646.1 | 2035772 | g53193 | i0 | 34.4 | 0.90818858560794 | 122 | 69 | 90.8 | 4 | 37 | 402 | 2207 | 2317 | MFA5143646.1 glucose-6-phosphate isomerase family protein [Candidatus Omnitrophota bacterium] | diamond | 366 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27806070 | 27806070 | PRJNA565584_P_NODE_160544_length_255_cov_1.692308_g159392_i0 | PRJNA565584 | 160544 | 255 | 1.692308 | 4.3153854 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.7 | 0.0417 | NR | MBU3959075.1 | 2035772 | g159392 | i0 | 47.4 | 0.670588235294118 | 57 | 29 | 67.1 | 1 | 61 | 231 | 222 | 277 | MBU3959075.1 threonine synthase [Candidatus Omnitrophota bacterium] | diamond | 171 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30124460 | 30124460 | PRJNA565584_P_NODE_55532_length_399_cov_1.297546_g54381_i0 | PRJNA565584 | 55532 | 399 | 1.297546 | 5.17720854 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.9 | 3.48e-7 | NR | HOY09570.1 | 2035772 | g54381 | i0 | 30.8 | 1.90977443609023 | 91 | 63 | 68.4 | 0 | 41 | 313 | 207 | 297 | HOY09570.1 PDZ domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 762 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30237350 | 30237350 | PRJNA565584_P_NODE_147012_length_264_cov_1.612565_g145860_i0 | PRJNA565584 | 147012 | 264 | 1.612565 | 4.2571716 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 119 | 1.9499999999999999e-31 | NR | MBN1688043.1 | 2035772 | g145860 | i0 | 61.6 | 2.94318181818182 | 86 | 33 | 97.7 | 0 | 3 | 260 | 8 | 93 | MBN1688043.1 superoxide dismutase [Fe] [Candidatus Omnitrophota bacterium] | diamond | 777 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31311642 | 31311642 | PRJNA565584_P_NODE_201075_length_244_cov_0.900585_g199923_i0 | PRJNA565584 | 201075 | 244 | 0.900585 | 2.1974274 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 79.7 | 1.88e-17 | NR | MSR77670.1 | 2035772 | g199923 | i0 | 42.5 | 0.897540983606557 | 73 | 40 | 89.8 | 1 | 235 | 17 | 1 | 71 | MSR77670.1 glutaredoxin 3 [Candidatus Omnitrophota bacterium] | diamond | 219 | 79.7 | 1 | 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);;