contig_metadata
9 rows where bioproject = "PRJNA658591" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4453403 | 4453403 | PRJNA658591_S_NODE_9444_length_166_cov_0.888889_g9381_i0 | PRJNA658591 | 9444 | 166 | 0.888889 | 1.47555574 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 215 | 1.68e-51 | NTclustered | gi|2874253749|emb|OY969623.1| | 1914239 | g9381 | i0 | 90 | 279.114457831325 | 170 | 11 | 100 | 6 | 1 | 166 | 7052303 | 7052470 | MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 | blastn | 46333 | 215 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 12640592 | 12640592 | PRJNA658591_S_NODE_10310_length_162_cov_1.079646_g10247_i0 | PRJNA658591 | 10310 | 162 | 1.079646 | 1.74902652 | Singulisphaera | 466152 | Bacteria | Bacteria | 250 | 4.45e-62 | NTclustered | gi|485099129|ref|NR_102524.1| | 466153 | g10247 | i0 | 94.444 | 173.246913580247 | 162 | 9 | 100 | 0 | 1 | 162 | 1593 | 1754 | Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence | blastn | 28066 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera acidiphila | |
| 27460735 | 27460735 | PRJNA658591_S_NODE_2163_length_288_cov_1.761506_g2100_i0 | PRJNA658591 | 2163 | 288 | 1.761506 | 5.07313728 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.7 | 0.0463 | NR | NOX57076.1 | 2026780 | g2100 | i0 | 40 | 0.46875 | 45 | 27 | 46.9 | 0 | 238 | 104 | 143 | 187 | NOX57076.1 hypothetical protein [Planctomycetota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29146588 | 29146588 | PRJNA658591_S_NODE_10329_length_162_cov_0.920354_g10266_i0 | PRJNA658591 | 10329 | 162 | 0.920354 | 1.49097348 | Bacteria | 2 | Bacteria | Bacteria | 61.6 | 6.39e-11 | NR | GBL24036.1 | 2026771 | g10266 | i0 | 59.6 | 7.55555555555556 | 47 | 19 | 87 | 0 | 2 | 142 | 18 | 64 | GBL24036.1 secretory immunoglobulin A-binding protein EsiB [Opitutia bacterium] | diamond | 1224 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29291846 | 29291846 | PRJNA658591_S_NODE_8849_length_169_cov_0.866667_g8786_i0 | PRJNA658591 | 8849 | 169 | 0.866667 | 1.46466723 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 42.7 | 0.0141 | NR | UCG46482.1 | 2052180 | g8786 | i0 | 45.1 | 0.905325443786982 | 51 | 23 | 90.5 | 2 | 157 | 5 | 99 | 144 | UCG46482.1 MAG: hypothetical protein JSU94_13365, partial [Phycisphaerales bacterium] | diamond | 153 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 30144204 | 30144204 | PRJNA658591_S_NODE_11252_length_154_cov_3.504762_g11189_i0 | PRJNA658591 | 11252 | 154 | 3.504762 | 5.39733348 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 67.8 | 5.22e-13 | NR | RYD73501.1 | 2026800 | g11189 | i0 | 78.6 | 0.818181818181818 | 42 | 9 | 81.8 | 0 | 128 | 3 | 3 | 44 | RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium] | diamond | 126 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30902916 | 30902916 | PRJNA658591_S_NODE_1994_length_298_cov_2.927711_g1931_i0 | PRJNA658591 | 1994 | 298 | 2.927711 | 8.72457878 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 144 | 1.07e-39 | NR | RYD65414.1 | 2026800 | g1931 | i0 | 82 | 0.895973154362416 | 89 | 16 | 89.6 | 0 | 294 | 28 | 73 | 161 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 267 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31218430 | 31218430 | PRJNA658591_S_NODE_3755_length_231_cov_1.510989_g3692_i0 | PRJNA658591 | 3755 | 231 | 1.510989 | 3.49038459 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 98.2 | 2.0900000000000002e-22 | NR | RYD65414.1 | 2026800 | g3692 | i0 | 64.5 | 0.987012987012987 | 76 | 27 | 98.7 | 0 | 229 | 2 | 177 | 252 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 228 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31693220 | 31693220 | PRJNA658591_S_NODE_57_length_1122_cov_5.536813_g42_i0 | PRJNA658591 | 57 | 1122 | 5.536813 | 62.12304186 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 251 | 5.65e-77 | NR | RYD71398.1 | 2026800 | g42 | i0 | 45.7 | 0.802139037433155 | 300 | 150 | 78.6 | 6 | 9 | 890 | 69 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 900 | 251 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;