contig_metadata
7 rows where bioproject = "PRJNA690124", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5773131 | 5773131 | PRJNA690124_P_NODE_46525_length_250_cov_0.881356_g46159_i0 | PRJNA690124 | 46525 | 250 | 0.881356 | 2.20339 | Bacteria | 2 | Bacteria | Bacteria | 161 | 4.3199999999999997e-47 | NR | OGX28364.1 | 1801860 | g46159 | i0 | 88 | 1.992 | 83 | 10 | 99.6 | 0 | 2 | 250 | 22 | 104 | OGX28364.1 MAG: quinolinate synthase [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20] | diamond | 498 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_67_20 | |||||
| 9598063 | 9598063 | PRJNA690124_P_NODE_45988_length_251_cov_0.876404_g45622_i0 | PRJNA690124 | 45988 | 251 | 0.876404 | 2.19977404 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 379 | 9.189999999999998e-101 | NTclustered | gi|2108353487|gb|CP070655.1| | 2035772 | g45622 | i0 | 94.332 | 5.0796812749004 | 247 | 14 | 98 | 0 | 1 | 247 | 390193 | 390439 | MAG: Candidatus Omnitrophota bacterium isolate bin81 chromosome | blastn | 1275 | 379 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27272005 | 27272005 | PRJNA690124_P_NODE_41123_length_259_cov_1.376344_g40757_i0 | PRJNA690124 | 41123 | 259 | 1.376344 | 3.56473096 | Omnitrophica bacterium GWA2_41_15 | 1801814 | Bacteria | Bacteria | 147 | 1.94e-41 | NR | OGW71125.1 | 1801814 | g40757 | i0 | 78.6 | 1.95752895752896 | 84 | 18 | 97.3 | 0 | 258 | 7 | 228 | 311 | OGW71125.1 MAG: hypothetical protein A2047_01825 [Omnitrophica bacterium GWA2_41_15] | diamond | 507 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium GWA2_41_15 | |||||
| 29450488 | 29450488 | PRJNA690124_P_NODE_33950_length_285_cov_1.264151_g33584_i0 | PRJNA690124 | 33950 | 285 | 1.264151 | 3.60283035 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 171 | 2.91e-47 | NR | MEK6715005.1 | 2035772 | g33584 | i0 | 88.3 | 4.94736842105263 | 94 | 11 | 98.9 | 0 | 3 | 284 | 744 | 837 | MEK6715005.1 pyruvate, phosphate dikinase [Candidatus Omnitrophota bacterium] | diamond | 1410 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32212034 | 32212034 | PRJNA690124_P_NODE_55678_length_242_cov_0.923077_g55312_i0 | PRJNA690124 | 55678 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 2.88e-9 | NR | MCK9428687.1 | 2035772 | g55312 | i0 | 77.4 | 0.805785123966942 | 31 | 7 | 38.4 | 0 | 127 | 219 | 1 | 31 | MCK9428687.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 195 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32548761 | 32548761 | PRJNA690124_P_NODE_43599_length_253_cov_0.866667_g43233_i0 | PRJNA690124 | 43599 | 253 | 0.866667 | 2.19266751 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 52.4 | 1.65e-5 | NR | MDP3787361.1 | 2035772 | g43233 | i0 | 33.7 | 1.05533596837945 | 89 | 51 | 96 | 2 | 251 | 9 | 65 | 153 | MDP3787361.1 DUF6259 domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 267 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32611602 | 32611602 | PRJNA690124_P_NODE_55840_length_242_cov_0.923077_g55474_i0 | PRJNA690124 | 55840 | 242 | 0.923077 | 2.23384634 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 115 | 1.27e-27 | NR | MBI4353952.1 | 2035772 | g55474 | i0 | 69.6 | 1.95867768595041 | 79 | 24 | 97.9 | 0 | 3 | 239 | 241 | 319 | MBI4353952.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 474 | 115 | 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);;