contig_metadata
8 rows where bioproject = "PRJNA782235", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7142044 | 7142044 | PRJNA782235_P_NODE_8726_length_307_cov_0.987179_g8537_i0 | PRJNA782235 | 8726 | 307 | 0.987179 | 3.03063953 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 396 | 1.15e-105 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g8537 | i0 | 91.93 | 202.954397394137 | 285 | 20 | 92 | 3 | 8 | 290 | 2750194 | 2750477 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 62307 | 396 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 27211426 | 27211426 | PRJNA782235_P_NODE_11762_length_278_cov_1.331707_g11573_i0 | PRJNA782235 | 11762 | 278 | 1.331707 | 3.70214546 | Prosthecobacter debontii | 48467 | Bacteria | Bacteria | 76.6 | 5.68e-14 | NR | WP_078815981.1 | 48467 | g11573 | i0 | 44.6 | 2.97841726618705 | 92 | 51 | 99.3 | 0 | 278 | 3 | 152 | 243 | WP_078815981.1 PfkB family carbohydrate kinase [Prosthecobacter debontii] | diamond | 828 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter debontii | |
| 28727413 | 28727413 | PRJNA782235_P_NODE_21967_length_246_cov_0.890173_g21778_i0 | PRJNA782235 | 21967 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.7 | 0.0344 | NR | MBN8459160.1 | 2026799 | g21778 | i0 | 28.2 | 0.865853658536585 | 71 | 47 | 85.4 | 2 | 36 | 245 | 173 | 240 | MBN8459160.1 CAAX prenyl protease-related protein [Verrucomicrobiota bacterium] | diamond | 213 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29327186 | 29327186 | PRJNA782235_P_NODE_24269_length_244_cov_0.900585_g24080_i0 | PRJNA782235 | 24269 | 244 | 0.900585 | 2.1974274 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 110 | 7.79e-29 | NR | WP_348217506.1 | 1962973 | g24080 | i0 | 67.5 | 0.983606557377049 | 80 | 26 | 98.4 | 0 | 243 | 4 | 56 | 135 | WP_348217506.1 DUF6157 family protein [Luteolibacter sp.] | diamond | 240 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 29927404 | 29927404 | PRJNA782235_P_NODE_28531_length_241_cov_0.898810_g28342_i0 | PRJNA782235 | 28531 | 241 | 0.89881 | 2.1661321 | Rubellicoccus peritrichatus | 3080537 | Bacteria | Bacteria | 145 | 1.94e-41 | NR | WP_317834364.1 | 3080537 | g28342 | i0 | 85.7 | 0.95850622406639 | 77 | 11 | 95.9 | 0 | 236 | 6 | 166 | 242 | WP_317834364.1 response regulator transcription factor [Rubellicoccus peritrichatus] | diamond | 231 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Rubellicoccus | Rubellicoccus peritrichatus | |
| 30780278 | 30780278 | PRJNA782235_P_NODE_22334_length_246_cov_0.890173_g22145_i0 | PRJNA782235 | 22334 | 246 | 0.890173 | 2.18982558 | Rubellicoccus peritrichatus | 3080537 | Bacteria | Bacteria | 132 | 5.91e-35 | NR | WP_317832957.1 | 3080537 | g22145 | i0 | 80.2 | 0.98780487804878 | 81 | 16 | 98.8 | 0 | 2 | 244 | 100 | 180 | WP_317832957.1 peptidase [Rubellicoccus peritrichatus] | diamond | 243 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Rubellicoccus | Rubellicoccus peritrichatus | |
| 31855180 | 31855180 | PRJNA782235_P_NODE_23117_length_245_cov_0.895349_g22928_i0 | PRJNA782235 | 23117 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 71.6 | 7.14e-13 | NR | HTJ73245.1 | 2499141 | g22928 | i0 | 45.7 | 0.991836734693878 | 81 | 42 | 99.2 | 2 | 2 | 244 | 54 | 132 | HTJ73245.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 243 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32076754 | 32076754 | PRJNA782235_P_NODE_26178_length_243_cov_0.905882_g25989_i0 | PRJNA782235 | 26178 | 243 | 0.905882 | 2.20129326 | Rubritalea halochordaticola | 714537 | Bacteria | Bacteria | 43.1 | 0.0105 | NR | WP_346190057.1 | 714537 | g25989 | i0 | 56.7 | 0.703703703703704 | 30 | 13 | 37 | 0 | 90 | 1 | 1 | 30 | WP_346190057.1 DUF2750 domain-containing protein [Rubritalea halochordaticola] | diamond | 171 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Rubritaleaceae | Rubritalea | Rubritalea halochordaticola |
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);;