contig_metadata
7 rows where bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4266088 | 4266088 | PRJNA450343_P_NODE_5524_length_226_cov_1.711864_g5456_i0 | PRJNA450343 | 5524 | 226 | 1.711864 | 3.86881264 | Candidatus Brocadia pituitae | 2608983 | Bacteria | Bacteria | 65.8 | 2.58e-6 | NTclustered | gi|1996211272|dbj|AP021856.1| | 2608983 | g5456 | i0 | 100 | 5.72566371681416 | 35 | 0 | 15 | 0 | 1 | 35 | 591991 | 592025 | Candidatus Brocadia pituitae DNA, complete genome | blastn | 1294 | 65.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Brocadiaceae | Candidatus Brocadia | Candidatus Brocadia pituitae | |
| 5542806 | 5542806 | PRJNA450343_P_NODE_10405_length_168_cov_1.714286_g10337_i0 | PRJNA450343 | 10405 | 168 | 1.714286 | 2.88000048 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 200 | 4.76e-47 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g10337 | i0 | 89.937 | 40.5416666666667 | 159 | 11 | 93 | 5 | 1 | 156 | 2003202 | 2003046 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 6811 | 200 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 20218712 | 20218712 | PRJNA450343_P_NODE_11016_length_167_cov_0.864407_g10948_i0 | PRJNA450343 | 11016 | 167 | 0.864407 | 1.44355969 | Singulisphaera | 466152 | Bacteria | Bacteria | 207 | 2.83e-49 | NTclustered | gi|485099129|ref|NR_102524.1| | 466153 | g10948 | i0 | 91.391 | 122.149700598802 | 151 | 13 | 90 | 0 | 1 | 151 | 680 | 530 | Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence | blastn | 20399 | 207 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera acidiphila | |
| 28086663 | 28086663 | PRJNA450343_P_NODE_13285_length_162_cov_0.902655_g13217_i0 | PRJNA450343 | 13285 | 162 | 0.902655 | 1.4623011 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.4 | 0.016 | NR | MDA0809678.1 | 2026780 | g13217 | i0 | 37.7 | 0.981481481481482 | 53 | 25 | 83.3 | 1 | 12 | 146 | 74 | 126 | MDA0809678.1 hypothetical protein [Planctomycetota bacterium] | diamond | 159 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28244466 | 28244466 | PRJNA450343_P_NODE_5166_length_233_cov_2.407609_g5098_i0 | PRJNA450343 | 5166 | 233 | 2.407609 | 5.60972897 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.1 | 0.0229 | NR | MBU6400767.1 | 2026799 | g5098 | i0 | 38.9 | 0.695278969957081 | 54 | 31 | 67 | 2 | 31 | 186 | 207 | 260 | MBU6400767.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28339385 | 28339385 | PRJNA450343_P_NODE_13146_length_162_cov_1.353982_g13078_i0 | PRJNA450343 | 13146 | 162 | 1.353982 | 2.19345084 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.032 | NR | MCC7510118.1 | 2026780 | g13078 | i0 | 35.6 | 0.833333333333333 | 45 | 29 | 83.3 | 0 | 158 | 24 | 1003 | 1047 | MCC7510118.1 hypothetical protein [Planctomycetota bacterium] | diamond | 135 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30676227 | 30676227 | PRJNA450343_P_NODE_12573_length_164_cov_0.886957_g12505_i0 | PRJNA450343 | 12573 | 164 | 0.886957 | 1.45460948 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 46.2 | 7.65e-4 | NR | HEY1053134.1 | 1965333 | g12505 | i0 | 43.4 | 0.969512195121951 | 53 | 30 | 97 | 0 | 164 | 6 | 576 | 628 | HEY1053134.1 ATP-dependent zinc metalloprotease FtsH [Prosthecobacter sp.] | diamond | 159 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. |
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);;