contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26714037 | 26714037 | PRJNA724039_S_NODE_11501_length_190_cov_1.692810_g11294_i0 | PRJNA724039 | 11501 | 190 | 1.69281 | 3.216339 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.8 | 2.08e-4 | NR | MBN1442006.1 | 2026780 | g11294 | i0 | 44.4 | 3.25263157894737 | 54 | 21 | 85.3 | 1 | 3 | 164 | 153 | 197 | MBN1442006.1 TraR/DksA family transcriptional regulator [Planctomycetota bacterium] | diamond | 618 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 26862706 | 26862706 | PRJNA724039_S_NODE_17061_length_154_cov_3.307692_g16854_i0 | PRJNA724039 | 17061 | 154 | 3.307692 | 5.09384568 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 46.2 | 1.47e-4 | NR | GMU84755.1 | 2026780 | g16854 | i0 | 64.5 | 1.28571428571429 | 31 | 11 | 60.4 | 0 | 11 | 103 | 49 | 79 | GMU84755.1 MAG: hypothetical protein AMXMBFR47_46240 [Planctomycetota bacterium] | diamond | 198 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27716025 | 27716025 | PRJNA724039_S_NODE_17644_length_152_cov_1.652174_g17437_i0 | PRJNA724039 | 17644 | 152 | 1.652174 | 2.51130448 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 79.7 | 6.79e-16 | NR | MBX9625399.1 | 2052164 | g17437 | i0 | 71.4 | 5.80263157894737 | 49 | 14 | 96.7 | 0 | 149 | 3 | 282 | 330 | MBX9625399.1 hypothetical protein [Gemmataceae bacterium] | diamond | 882 | 79.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 28073211 | 28073211 | PRJNA724039_S_NODE_13525_length_174_cov_1.963504_g13318_i0 | PRJNA724039 | 13525 | 174 | 1.963504 | 3.41649696 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 104 | 5.47e-25 | NR | HTL69415.1 | 1961806 | g13318 | i0 | 85.7 | 14.6379310344828 | 56 | 8 | 96.6 | 0 | 169 | 2 | 45 | 100 | HTL69415.1 alkene reductase [Lacunisphaera sp.] | diamond | 2547 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 28157940 | 28157940 | PRJNA724039_S_NODE_17125_length_154_cov_1.846154_g16918_i0 | PRJNA724039 | 17125 | 154 | 1.846154 | 2.84307716 | Lentimonas sp. | 3100297 | Bacteria | Bacteria | 83.6 | 5.18e-18 | NR | MEN8662823.1 | 3100297 | g16918 | i0 | 78.7 | 1.87012987012987 | 47 | 10 | 91.6 | 0 | 150 | 10 | 28 | 74 | MEN8662823.1 ABC transporter ATP-binding protein [Lentimonas sp.] | diamond | 288 | 83.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Lentimonas | Lentimonas sp. | ||||
| 29231350 | 29231350 | PRJNA724039_S_NODE_11129_length_193_cov_3.211538_g10922_i0 | PRJNA724039 | 11129 | 193 | 3.211538 | 6.19826834 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 47.8 | 3.35e-4 | NR | MCC5823099.1 | 2026780 | g10922 | i0 | 39.4 | 2.02072538860104 | 66 | 38 | 99.5 | 1 | 193 | 2 | 473 | 538 | MCC5823099.1 serine/threonine protein kinase [Planctomycetota bacterium] | diamond | 390 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32581711 | 32581711 | PRJNA724039_S_NODE_16119_length_159_cov_1.180328_g15912_i0 | PRJNA724039 | 16119 | 159 | 1.180328 | 1.87672152 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.6 | 4.09e-14 | NR | MBT3842500.1 | 2026799 | g15912 | i0 | 69.2 | 2.94339622641509 | 52 | 16 | 98.1 | 0 | 4 | 159 | 122 | 173 | MBT3842500.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 468 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;