contig_metadata
9 rows where bioproject = "PRJNA641707", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5714764 | 5714764 | PRJNA641707_P_NODE_114965_length_246_cov_2.116751_g112302_i0 | PRJNA641707 | 114965 | 246 | 2.116751 | 5.20720746 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 145 | 3.56e-30 | NTclustered | gi|2621701202|emb|OY759724.1| | 2035772 | g112302 | i0 | 93.75 | 56.1869918699187 | 96 | 6 | 39 | 0 | 6 | 101 | 2373721 | 2373816 | MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1 | blastn | 13822 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 6995985 | 6995985 | PRJNA641707_P_NODE_87066_length_246_cov_6.279188_g84403_i0 | PRJNA641707 | 87066 | 246 | 6.279188 | 15.44680248 | Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_ | 2035772 | Bacteria | Bacteria | 54.3 | 1.73e-6 | NR | PIQ85924.1 | 1974748 | g84403 | i0 | 71 | 0.768292682926829 | 31 | 9 | 37.8 | 0 | 95 | 3 | 15 | 45 | PIQ85924.1 MAG: peroxiredoxin [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_45_26] | diamond | 189 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Abzuiibacterium | Candidatus Abzuiibacterium crystallinum | ||||
| 26828153 | 26828153 | PRJNA641707_P_NODE_277741_length_171_cov_4.901639_g275078_i0 | PRJNA641707 | 277741 | 171 | 4.901639 | 8.38180269 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.4 | 0.0193 | NR | MCA9406114.1 | 2035772 | g275078 | i0 | 42.9 | 1.75438596491228 | 49 | 26 | 86 | 1 | 164 | 18 | 363 | 409 | MCA9406114.1 acyl-CoA dehydrogenase family protein [Candidatus Omnitrophota bacterium] | diamond | 300 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28439317 | 28439317 | PRJNA641707_P_NODE_270366_length_174_cov_4.000000_g267703_i0 | PRJNA641707 | 270366 | 174 | 4 | 6.96 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 95.5 | 1.21e-21 | NR | MBN1444831.1 | 2035772 | g267703 | i0 | 75 | 0.96551724137931 | 56 | 14 | 96.6 | 0 | 6 | 173 | 37 | 92 | MBN1444831.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 168 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29575517 | 29575517 | PRJNA641707_P_NODE_121190_length_245_cov_6.724490_g118527_i0 | PRJNA641707 | 121190 | 245 | 6.72449 | 16.4750005 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 55.5 | 1.14e-6 | NR | MBI2167690.1 | 2035772 | g118527 | i0 | 67.7 | 0.379591836734694 | 31 | 10 | 38 | 0 | 150 | 242 | 41 | 71 | MBI2167690.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 93 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31250212 | 31250212 | PRJNA641707_P_NODE_332955_length_153_cov_4.490385_g330292_i0 | PRJNA641707 | 332955 | 153 | 4.490385 | 6.87028905 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.1 | 0.00568 | NR | MCX5706781.1 | 2035772 | g330292 | i0 | 61.8 | 0.666666666666667 | 34 | 13 | 66.7 | 0 | 105 | 4 | 1 | 34 | MCX5706781.1 translation elongation factor Ts [Candidatus Omnitrophota bacterium] | diamond | 102 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31503438 | 31503438 | PRJNA641707_P_NODE_280316_length_170_cov_4.818182_g277653_i0 | PRJNA641707 | 280316 | 170 | 4.818182 | 8.1909094 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 40 | 0.0484 | NR | MBF0511328.1 | 2035772 | g277653 | i0 | 32.7 | 0.970588235294118 | 55 | 36 | 95.3 | 1 | 6 | 167 | 36 | 90 | MBF0511328.1 HAD family hydrolase [Candidatus Omnitrophota bacterium] | diamond | 165 | 40 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31566722 | 31566722 | PRJNA641707_P_NODE_202456_length_197_cov_4.405405_g199793_i0 | PRJNA641707 | 202456 | 197 | 4.405405 | 8.67864785 | Candidatus Omnitrophica bacterium CG1_ | 2035772 | Bacteria | Bacteria | 40.4 | 0.0469 | NR | OIO36084.1 | 1805287 | g199793 | i0 | 36.5 | 0.791878172588833 | 52 | 33 | 79.2 | 0 | 196 | 41 | 43 | 94 | OIO36084.1 MAG: hypothetical protein AUJ74_03695 [Candidatus Omnitrophica bacterium CG1_02_44_16] | diamond | 156 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Phelpsiimicrobium | Candidatus Phelpsiimicrobium noxiivivens | ||||
| 32779960 | 32779960 | PRJNA641707_P_NODE_271920_length_173_cov_7.346774_g269257_i0 | PRJNA641707 | 271920 | 173 | 7.346774 | 12.70991902 | Bacteria | 2 | Bacteria | Bacteria | 108 | 6.99e-26 | NR | OGW82947.1 | 1801823 | g269257 | i0 | 98.2 | 14.3410404624277 | 55 | 1 | 95.4 | 0 | 8 | 172 | 199 | 253 | OGW82947.1 MAG: ribonucleoside-diphosphate reductase, adenosylcobalamin-dependent [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18] | diamond | 2481 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18 |
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);;