contig_metadata
7 rows where bioproject = "PRJNA600413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26763408 | 26763408 | PRJNA600413_P_NODE_95781_length_170_cov_1.685950_g95080_i0 | PRJNA600413 | 95781 | 170 | 1.68595 | 2.866115 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.4 | 0.0195 | NR | MBI2166623.1 | 2035772 | g95080 | i0 | 54.1 | 0.652941176470588 | 37 | 17 | 65.3 | 0 | 55 | 165 | 386 | 422 | MBI2166623.1 VCBS repeat-containing protein [Candidatus Omnitrophota bacterium] | diamond | 111 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27427791 | 27427791 | PRJNA600413_P_NODE_108663_length_166_cov_1.743590_g107962_i0 | PRJNA600413 | 108663 | 166 | 1.74359 | 2.8943594 | Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_ | 2035772 | Bacteria | Bacteria | 100 | 3.909999999999999e-23 | NR | OGX28652.1 | 1801860 | g107962 | i0 | 85.5 | 2.98192771084337 | 55 | 8 | 99.4 | 0 | 166 | 2 | 316 | 370 | OGX28652.1 MAG: beta-ketoacyl-[acyl-carrier-protein] synthase II [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20] | diamond | 495 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20 | |||||
| 29227510 | 29227510 | PRJNA600413_P_NODE_142129_length_162_cov_0.902655_g141428_i0 | PRJNA600413 | 142129 | 162 | 0.902655 | 1.4623011 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 57 | 1.7e-8 | NR | HRK61703.1 | 2035772 | g141428 | i0 | 65.9 | 0.814814814814815 | 44 | 15 | 81.5 | 0 | 134 | 3 | 1 | 44 | HRK61703.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 132 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29795466 | 29795466 | PRJNA600413_P_NODE_77751_length_181_cov_1.545455_g77050_i0 | PRJNA600413 | 77751 | 181 | 1.545455 | 2.79727355 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 79.7 | 1.36e-15 | NR | MCM8778537.1 | 2035772 | g77050 | i0 | 67.8 | 0.977900552486188 | 59 | 19 | 97.8 | 0 | 5 | 181 | 4 | 62 | MCM8778537.1 HAMP domain-containing histidine kinase [Candidatus Omnitrophota bacterium] | diamond | 177 | 79.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29922090 | 29922090 | PRJNA600413_P_NODE_140191_length_162_cov_0.902655_g139490_i0 | PRJNA600413 | 140191 | 162 | 0.902655 | 1.4623011 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 65.5 | 1.07e-11 | NR | MBF0503745.1 | 2035772 | g139490 | i0 | 77.8 | 0.833333333333333 | 45 | 10 | 83.3 | 0 | 135 | 1 | 6 | 50 | MBF0503745.1 pilin [Candidatus Omnitrophota bacterium] | diamond | 135 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31312177 | 31312177 | PRJNA600413_P_NODE_129815_length_163_cov_1.789474_g129114_i0 | PRJNA600413 | 129815 | 163 | 1.789474 | 2.91684262 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 41.6 | 0.0331 | NR | MCX5702120.1 | 2035772 | g129114 | i0 | 37.1 | 1.14110429447853 | 62 | 29 | 95.7 | 1 | 157 | 2 | 42 | 103 | MCX5702120.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 186 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32261579 | 32261579 | PRJNA600413_P_NODE_132558_length_163_cov_0.894737_g131857_i0 | PRJNA600413 | 132558 | 163 | 0.894737 | 1.45842131 | Omnitrophica bacterium RIFCSPHIGHO2_ | 2035772 | Bacteria | Bacteria | 74.7 | 3.86e-14 | NR | OGW87980.1 | 1801820 | g131857 | i0 | 65.4 | 0.957055214723926 | 52 | 18 | 95.7 | 0 | 157 | 2 | 161 | 212 | OGW87980.1 MAG: hypothetical protein A3C35_08555 [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_46_11] | diamond | 156 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_46_11 |
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);;