contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9488398 | 9488398 | PRJNA575566_P_NODE_20748_length_230_cov_1.136095_g20551_i0 | PRJNA575566 | 20748 | 230 | 1.136095 | 2.6130185 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 150 | 3.6e-45 | NR | WP_413939772.1 | 3394362 | g20551 | i0 | 100 | 0.991304347826087 | 76 | 0 | 99.1 | 0 | 229 | 2 | 5 | 80 | WP_413939772.1 RNA recognition motif domain-containing protein [Bdellovibrio sp. HCB2-146] | diamond | 228 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 12039213 | 12039213 | PRJNA575566_P_NODE_25970_length_207_cov_0.876712_g25773_i0 | PRJNA575566 | 25970 | 207 | 0.876712 | 1.81479384 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 131 | 4.85e-34 | NR | WP_413938877.1 | 3394362 | g25773 | i0 | 100 | 0.985507246376812 | 68 | 0 | 98.6 | 0 | 206 | 3 | 3 | 70 | WP_413938877.1 microtubule-binding protein [Bdellovibrio sp. HCB2-146] | diamond | 204 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 20263235 | 20263235 | PRJNA575566_P_NODE_24696_length_208_cov_1.292517_g24499_i0 | PRJNA575566 | 24696 | 208 | 1.292517 | 2.68843536 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 124 | 1.22e-33 | NR | WP_413941498.1 | 3394362 | g24499 | i0 | 95.5 | 0.951923076923077 | 66 | 3 | 95.2 | 0 | 198 | 1 | 1 | 66 | WP_413941498.1 MotA/TolQ/ExbB proton channel family protein [Bdellovibrio sp. HCB2-146] | diamond | 198 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 26889934 | 26889934 | PRJNA575566_P_NODE_24281_length_209_cov_0.864865_g24084_i0 | PRJNA575566 | 24281 | 209 | 0.864865 | 1.80756785 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 118 | 3.32e-29 | NR | WP_413939334.1 | 3394362 | g24084 | i0 | 95.7 | 0.990430622009569 | 69 | 3 | 99 | 0 | 207 | 1 | 432 | 500 | WP_413939334.1 methyl-accepting chemotaxis protein [Bdellovibrio sp. HCB2-146] | diamond | 207 | 118 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 27205712 | 27205712 | PRJNA575566_P_NODE_27762_length_204_cov_0.895105_g27565_i0 | PRJNA575566 | 27762 | 204 | 0.895105 | 1.8260142 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 127 | 1.2e-34 | NR | WP_413941452.1 | 3394362 | g27565 | i0 | 85.1 | 0.985294117647059 | 67 | 10 | 98.5 | 0 | 2 | 202 | 33 | 99 | WP_413941452.1 3D domain-containing protein [Bdellovibrio sp. HCB2-146] | diamond | 201 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 28279477 | 28279477 | PRJNA575566_P_NODE_28386_length_203_cov_0.901408_g28189_i0 | PRJNA575566 | 28386 | 203 | 0.901408 | 1.82985824 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 131 | 3.76e-34 | NR | WP_413939910.1 | 3394362 | g28189 | i0 | 98.4 | 0.916256157635468 | 62 | 1 | 91.6 | 0 | 201 | 16 | 464 | 525 | WP_413939910.1 hypothetical protein [Bdellovibrio sp. HCB2-146] | diamond | 186 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 29164021 | 29164021 | PRJNA575566_P_NODE_27949_length_204_cov_0.895105_g27752_i0 | PRJNA575566 | 27949 | 204 | 0.895105 | 1.8260142 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 132 | 3.59e-35 | NR | WP_413939332.1 | 3394362 | g27752 | i0 | 100 | 0.985294117647059 | 67 | 0 | 98.5 | 0 | 202 | 2 | 305 | 371 | WP_413939332.1 cell division protein FtsA [Bdellovibrio sp. HCB2-146] | diamond | 201 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 32387454 | 32387454 | PRJNA575566_P_NODE_25959_length_207_cov_0.876712_g25762_i0 | PRJNA575566 | 25959 | 207 | 0.876712 | 1.81479384 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 129 | 1.14e-33 | NR | WP_413941783.1 | 3394362 | g25762 | i0 | 87 | 1 | 69 | 9 | 100 | 0 | 207 | 1 | 249 | 317 | WP_413941783.1 NAD(P)/FAD-dependent oxidoreductase [Bdellovibrio sp. HCB2-146] | diamond | 207 | 129 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 | ||
| 32482529 | 32482529 | PRJNA575566_P_NODE_29159_length_202_cov_0.907801_g28962_i0 | PRJNA575566 | 29159 | 202 | 0.907801 | 1.83375802 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 141 | 3.29e-39 | NR | WP_413940981.1 | 3394362 | g28962 | i0 | 100 | 0.98019801980198 | 66 | 0 | 98 | 0 | 200 | 3 | 67 | 132 | WP_413940981.1 tryptophan--tRNA ligase [Bdellovibrio sp. HCB2-146] | diamond | 198 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 |
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);;