contig_metadata
8 rows where bioproject = "PRJNA642647", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12637740 | 12637740 | PRJNA642647_P_NODE_5290_length_165_cov_2.414062_g5240_i0 | PRJNA642647 | 5290 | 165 | 2.414062 | 3.9832023 | Bdellovibrio | 958 | Bacteria | Bacteria | 294 | 2.08e-75 | NTclustered | gi|2800924434|gb|CP168967.1| | 959 | g5240 | i0 | 98.788 | 101.763636363636 | 165 | 2 | 100 | 0 | 1 | 165 | 784964 | 784800 | Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome | blastn | 16791 | 294 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 14646923 | 14646923 | PRJNA642647_P_NODE_4732_length_168_cov_1.412214_g4682_i0 | PRJNA642647 | 4732 | 168 | 1.412214 | 2.37251952 | Pigmentibacter sp. JX0631 | 2976982 | Bacteria | Bacteria | 211 | 2.2e-50 | NTclustered | gi|2496589869|gb|CP123622.1| | 2976982 | g4682 | i0 | 91.558 | 44.9583333333333 | 154 | 12 | 91 | 1 | 12 | 164 | 368079 | 368232 | Pigmentibacter sp. JX0631 chromosome, complete genome | blastn | 7553 | 211 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Pigmentibacter | Pigmentibacter sp. JX0631 | ||
| 19010061 | 19010061 | PRJNA642647_P_NODE_455_length_518_cov_3.615385_g406_i0 | PRJNA642647 | 455 | 518 | 3.615385 | 18.7276943 | Bdellovibrio | 958 | Bacteria | Bacteria | 510 | 6.97e-140 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g406 | i0 | 85.371 | 242.032818532819 | 499 | 66 | 96 | 6 | 1 | 495 | 1677301 | 1677796 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 125373 | 514 | 0.992217898832685 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 22295089 | 22295089 | PRJNA642647_P_NODE_4778_length_167_cov_3.092308_g4728_i0 | PRJNA642647 | 4778 | 167 | 3.092308 | 5.16415436 | Pseudobdellovibrio sp. HCB154 | 3386277 | Bacteria | Bacteria | 248 | 1.66e-61 | NTclustered | gi|2872995934|gb|CP176530.1| | 3386277 | g4728 | i0 | 93.902 | 33.8802395209581 | 164 | 10 | 98 | 0 | 4 | 167 | 700163 | 700326 | Pseudobdellovibrio sp. HCB154 chromosome, complete genome | blastn | 5658 | 248 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. HCB154 | ||
| 25384948 | 25384948 | PRJNA642647_P_NODE_5760_length_159_cov_1.213115_g5710_i0 | PRJNA642647 | 5760 | 159 | 1.213115 | 1.92885285 | Pseudobdellovibrionaceae | 213483 | Bacteria | Bacteria | 239 | 9.42e-59 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g5710 | i0 | 93.711 | 167.534591194969 | 159 | 10 | 100 | 0 | 1 | 159 | 1677010 | 1677168 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 26638 | 239 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 27270879 | 27270879 | PRJNA642647_P_NODE_5123_length_166_cov_2.782946_g5073_i0 | PRJNA642647 | 5123 | 166 | 2.782946 | 4.61969036 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 41.2 | 0.045 | NR | MBK7892839.1 | 2053517 | g5073 | i0 | 70.8 | 0.433734939759036 | 24 | 7 | 43.4 | 0 | 93 | 164 | 181 | 204 | MBK7892839.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 72 | 41.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29998916 | 29998916 | PRJNA642647_P_NODE_5151_length_166_cov_2.736434_g5101_i0 | PRJNA642647 | 5151 | 166 | 2.736434 | 4.54248044 | Bdellovibrio | 958 | Bacteria | Bacteria | 45.4 | 0.00143 | NR | WP_015090556.1 | 959 | g5101 | i0 | 86.4 | 2.13253012048193 | 22 | 3 | 39.8 | 0 | 68 | 3 | 311 | 332 | WP_015090556.1 ABC-F family ATP-binding cassette domain-containing protein [Bdellovibrio bacteriovorus] | diamond | 354 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 32704781 | 32704781 | PRJNA642647_P_NODE_5380_length_164_cov_1.204724_g5330_i0 | PRJNA642647 | 5380 | 164 | 1.204724 | 1.97574736 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 73.6 | 1.7e-13 | NR | MBX2989447.1 | 2026715 | g5330 | i0 | 61.1 | 0.98780487804878 | 54 | 21 | 98.8 | 0 | 2 | 163 | 269 | 322 | MBX2989447.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 162 | 73.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae 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);;