contig_metadata
7 rows where bioproject = "PRJNA493632", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27677045 | 27677045 | PRJNA493632_P_NODE_258084_length_310_cov_9.510549_g254648_i0 | PRJNA493632 | 258084 | 310 | 9.510549 | 29.4827019 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 53.5 | 1.29e-5 | NR | MBP7829185.1 | 2212473 | g254648 | i0 | 54.2 | 1.38387096774194 | 48 | 22 | 46.5 | 0 | 161 | 304 | 416 | 463 | MBP7829185.1 L-seryl-tRNA(Sec) selenium transferase [Kiritimatiellia bacterium] | diamond | 429 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29034695 | 29034695 | PRJNA493632_P_NODE_264088_length_310_cov_2.974684_g260652_i0 | PRJNA493632 | 264088 | 310 | 2.974684 | 9.2215204 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 146 | 2.85e-38 | NR | HNX33894.1 | 2212473 | g260652 | i0 | 58.5 | 1.14193548387097 | 118 | 33 | 98.7 | 1 | 5 | 310 | 144 | 261 | HNX33894.1 DUF6259 domain-containing protein [Kiritimatiellia bacterium] | diamond | 354 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30898313 | 30898313 | PRJNA493632_P_NODE_711394_length_219_cov_4.157534_g707952_i0 | PRJNA493632 | 711394 | 219 | 4.157534 | 9.10499946 | Pontiella sp. | 2837462 | Bacteria | Bacteria | 105 | 2.9299999999999998e-24 | NR | WP_372807674.1 | 2837462 | g707952 | i0 | 71.8 | 1.95890410958904 | 71 | 20 | 97.3 | 0 | 217 | 5 | 424 | 494 | WP_372807674.1 potassium/proton antiporter, partial [Pontiella sp.] | diamond | 429 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Pontiellaceae | Pontiella | Pontiella sp. | |
| 30961481 | 30961481 | PRJNA493632_P_NODE_704454_length_226_cov_2.156863_g701013_i0 | PRJNA493632 | 704454 | 226 | 2.156863 | 4.87451038 | Kiritimatiellaceae bacterium | 2026752 | Bacteria | Bacteria | 43.1 | 0.0216 | NR | MAS98139.1 | 2026752 | g701013 | i0 | 32.8 | 0.809734513274336 | 61 | 41 | 81 | 0 | 4 | 186 | 44 | 104 | MAS98139.1 hypothetical protein [Kiritimatiellaceae bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellaceae | Kiritimatiellaceae bacterium | ||
| 31656722 | 31656722 | PRJNA493632_P_NODE_610777_length_244_cov_0.900585_g607336_i0 | PRJNA493632 | 610777 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 83.6 | 1.62e-16 | NR | MBN1269769.1 | 2212473 | g607336 | i0 | 48.1 | 2.90163934426229 | 81 | 42 | 99.6 | 0 | 243 | 1 | 36 | 116 | MBN1269769.1 inverse autotransporter beta domain-containing protein [Kiritimatiellia bacterium] | diamond | 708 | 83.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31814935 | 31814935 | PRJNA493632_P_NODE_312557_length_291_cov_2.422018_g309118_i0 | PRJNA493632 | 312557 | 291 | 2.422018 | 7.04807238 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 112 | 6.050000000000001e-27 | NR | HQL50801.1 | 2212473 | g309118 | i0 | 83.6 | 0.690721649484536 | 67 | 11 | 69.1 | 0 | 289 | 89 | 327 | 393 | HQL50801.1 Fic family protein [Kiritimatiellia bacterium] | diamond | 201 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32416260 | 32416260 | PRJNA493632_P_NODE_385299_length_275_cov_2.019802_g381860_i0 | PRJNA493632 | 385299 | 275 | 2.019802 | 5.5544555 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 182 | 1.72e-52 | NR | MDD2462102.1 | 2212473 | g381860 | i0 | 100 | 0.992727272727273 | 91 | 0 | 99.3 | 0 | 2 | 274 | 464 | 554 | MDD2462102.1 putative Ig domain-containing protein [Kiritimatiellia bacterium] | diamond | 273 | 182 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;