contig_metadata
12 rows where bioproject = "PRJNA330616", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389739 | 389739 | PRJNA330616_P_NODE_26201_length_167_cov_0.864407_g25792_i0 | PRJNA330616 | 26201 | 167 | 0.864407 | 1.44355969 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 196 | 6.12e-46 | NTclustered | gi|2800920897|gb|CP168968.1| | 959 | g25792 | i0 | 88.75 | 7.25149700598802 | 160 | 18 | 96 | 0 | 1 | 160 | 1808663 | 1808822 | Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome | blastn | 1211 | 196 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 2344699 | 2344699 | PRJNA330616_P_NODE_30462_length_163_cov_0.894737_g30053_i0 | PRJNA330616 | 30462 | 163 | 0.894737 | 1.45842131 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99 | 1.72e-16 | NTclustered | gi|2800914199|gb|CP168971.1| | 959 | g30053 | i0 | 87.209 | 19.6319018404908 | 86 | 11 | 53 | 0 | 59 | 144 | 3049418 | 3049503 | Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome | blastn | 3200 | 99 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 2940334 | 2940334 | PRJNA330616_P_NODE_22723_length_177_cov_1.593750_g22314_i0 | PRJNA330616 | 22723 | 177 | 1.59375 | 2.8209375 | Spirobacillus cienkowskii | 495820 | Bacteria | Bacteria | 100 | 5.27e-17 | NTclustered | gi|2696024138|gb|CP146516.1| | 495820 | g22314 | i0 | 96.667 | 31.4689265536723 | 60 | 2 | 36 | 0 | 118 | 177 | 385944 | 385885 | Spirobacillus cienkowskii strain FI-SP1 chromosome, complete genome | blastn | 5570 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Spirobacillus | Spirobacillus cienkowskii | |||
| 7447141 | 7447141 | PRJNA330616_P_NODE_15166_length_214_cov_1.854545_g14757_i0 | PRJNA330616 | 15166 | 214 | 1.854545 | 3.9687263 | Micavibrio | 213485 | Bacteria | Bacteria | 241 | 3.75e-59 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g14757 | i0 | 87.097 | 479.845794392523 | 217 | 23 | 100 | 5 | 1 | 214 | 463023 | 462809 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 102687 | 241 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 10593502 | 10593502 | PRJNA330616_P_NODE_31389_length_162_cov_0.902655_g30980_i0 | PRJNA330616 | 31389 | 162 | 0.902655 | 1.4623011 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 217 | 4.5199999999999996e-52 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g30980 | i0 | 91.72 | 8.82716049382716 | 157 | 11 | 96 | 2 | 7 | 162 | 665743 | 665588 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 1430 | 217 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 11272536 | 11272536 | PRJNA330616_P_NODE_22189_length_179_cov_1.961538_g21780_i0 | PRJNA330616 | 22189 | 179 | 1.961538 | 3.51115302 | Bdellovibrio | 958 | Bacteria | Bacteria | 193 | 8.56e-45 | NTclustered | gi|2800914199|gb|CP168971.1| | 959 | g21780 | i0 | 89.542 | 52.340782122905 | 153 | 14 | 84 | 2 | 29 | 179 | 753178 | 753026 | Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome | blastn | 9369 | 193 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 12547895 | 12547895 | PRJNA330616_P_NODE_24790_length_169_cov_1.775000_g24381_i0 | PRJNA330616 | 24790 | 169 | 1.775 | 2.99975 | Peredibacter | 263370 | Bacteria | Bacteria | 313 | 5.859999999999999e-81 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g24381 | i0 | 100 | 201.153846153846 | 169 | 0 | 100 | 0 | 1 | 169 | 511232 | 511400 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 33995 | 313 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 16967073 | 16967073 | PRJNA330616_P_NODE_25474_length_167_cov_1.296610_g25065_i0 | PRJNA330616 | 25474 | 167 | 1.29661 | 2.1653387 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 158 | 2.89e-34 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g25065 | i0 | 83.929 | 382.095808383234 | 168 | 23 | 100 | 4 | 1 | 167 | 3447869 | 3448033 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 63810 | 158 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 24615965 | 24615965 | PRJNA330616_P_NODE_4040_length_426_cov_2.710875_g3632_i0 | PRJNA330616 | 4040 | 426 | 2.710875 | 11.5483275 | Pseudobdellovibrio sp. HCB154 | 3386277 | Bacteria | Bacteria | 749 | 0 | NTclustered | gi|2872995934|gb|CP176530.1| | 3386277 | g3632 | i0 | 98.357 | 181.037558685446 | 426 | 7 | 100 | 0 | 1 | 426 | 699454 | 699879 | Pseudobdellovibrio sp. HCB154 chromosome, complete genome | blastn | 77122 | 749 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. HCB154 | ||
| 31401998 | 31401998 | PRJNA330616_P_NODE_16936_length_204_cov_0.954839_g16527_i0 | PRJNA330616 | 16936 | 204 | 0.954839 | 1.94787156 | Bdellovibrio reynosensis | 2835041 | Bacteria | Bacteria | 47 | 5.99e-4 | NR | WP_243537368.1 | 2835041 | g16527 | i0 | 38.7 | 2.44117647058824 | 62 | 27 | 89.7 | 2 | 2 | 184 | 92 | 143 | WP_243537368.1 DUF5602 domain-containing protein [Bdellovibrio reynosensis] | diamond | 498 | 47 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio reynosensis | ||
| 32192778 | 32192778 | PRJNA330616_P_NODE_31978_length_161_cov_0.910714_g31569_i0 | PRJNA330616 | 31978 | 161 | 0.910714 | 1.46624954 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 110 | 9.87e-28 | NR | MBX9702590.1 | 2654442 | g31569 | i0 | 66.7 | 1.45341614906832 | 78 | 1 | 98.8 | 1 | 2 | 160 | 117 | 194 | MBX9702590.1 serine/threonine-protein kinase [Silvanigrellaceae bacterium] | diamond | 234 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 32287969 | 32287969 | PRJNA330616_P_NODE_8859_length_278_cov_14.855895_g8450_i0 | PRJNA330616 | 8859 | 278 | 14.855895 | 41.2993881 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 43.5 | 0.0306 | NR | MEE2745177.1 | 3034175 | g8450 | i0 | 33.3 | 1.10071942446043 | 78 | 44 | 77.7 | 3 | 223 | 8 | 636 | 711 | MEE2745177.1 penicillin acylase family protein [Bdellovibrionota bacterium] | diamond | 306 | 43.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota 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);;