contig_metadata
8 rows where bioproject = "PRJNA689790", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7047376 | 7047376 | PRJNA689790_S_NODE_9386_length_193_cov_2.288462_g9271_i0 | PRJNA689790 | 9386 | 193 | 2.288462 | 4.41673166 | Fluviispira sanaruensis | 2493639 | Bacteria | Bacteria | 78.2 | 6e-15 | NR | WP_130607314.1 | 2493639 | g9271 | i0 | 75.6 | 2.00518134715026 | 45 | 11 | 69.9 | 0 | 188 | 54 | 719 | 763 | WP_130607314.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Fluviispira sanaruensis] | diamond | 387 | 78.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Fluviispira | Fluviispira sanaruensis | ||
| 27398545 | 27398545 | PRJNA689790_S_NODE_4823_length_275_cov_5.029412_g4708_i0 | PRJNA689790 | 4823 | 275 | 5.029412 | 13.830883 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 57.4 | 2.78e-7 | NR | MBX2833619.1 | 2024841 | g4708 | i0 | 51.9 | 0.589090909090909 | 54 | 25 | 57.8 | 1 | 241 | 83 | 212 | 265 | MBX2833619.1 carbonic anhydrase family protein [Micavibrio sp.] | diamond | 162 | 57.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 29419008 | 29419008 | PRJNA689790_S_NODE_409_length_1153_cov_3.644265_g369_i0 | PRJNA689790 | 409 | 1153 | 3.644265 | 42.01837545 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 254 | 2.35e-73 | NR | MEZ4704431.1 | 3034175 | g369 | i0 | 39.2 | 3.77276669557676 | 360 | 195 | 92.1 | 7 | 1141 | 80 | 382 | 723 | MEZ4704431.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 4350 | 254 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29513675 | 29513675 | PRJNA689790_S_NODE_12330_length_170_cov_1.751880_g12215_i0 | PRJNA689790 | 12330 | 170 | 1.75188 | 2.978196 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 58.5 | 3.7e-8 | NR | HXH76202.1 | 2081706 | g12215 | i0 | 44.4 | 7.76470588235294 | 54 | 30 | 95.3 | 0 | 5 | 166 | 855 | 908 | HXH76202.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 1320 | 58.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29987607 | 29987607 | PRJNA689790_S_NODE_4631_length_282_cov_1.420408_g4516_i0 | PRJNA689790 | 4631 | 282 | 1.420408 | 4.00555056 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 75.9 | 1.36e-13 | NR | HLB59612.1 | 3034175 | g4516 | i0 | 47 | 0.882978723404255 | 83 | 44 | 88.3 | 0 | 1 | 249 | 619 | 701 | HLB59612.1 S8 family serine peptidase [Bdellovibrionota bacterium] | diamond | 249 | 75.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29999211 | 29999211 | PRJNA689790_S_NODE_7231_length_220_cov_2.344262_g7116_i0 | PRJNA689790 | 7231 | 220 | 2.344262 | 5.1573764 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 68.9 | 1.65e-11 | NR | HEX4925631.1 | 2053517 | g7116 | i0 | 49.3 | 9.17727272727273 | 69 | 34 | 94.1 | 1 | 219 | 13 | 1005 | 1072 | HEX4925631.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 2019 | 69.3 | 0.994227994227994 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31705720 | 31705720 | PRJNA689790_S_NODE_15657_length_154_cov_2.000000_g15542_i0 | PRJNA689790 | 15657 | 154 | 2 | 3.08 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.4 | 2.04e-4 | NR | MCB9063021.1 | 2026745 | g15542 | i0 | 43.5 | 1.79220779220779 | 46 | 22 | 89.6 | 1 | 2 | 139 | 172 | 213 | MCB9063021.1 glutathione S-transferase N-terminal domain-containing protein [Halobacteriovoraceae bacterium] | diamond | 276 | 47.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 32264006 | 32264006 | PRJNA689790_S_NODE_3978_length_308_cov_1.583026_g3863_i0 | PRJNA689790 | 3978 | 308 | 1.583026 | 4.87572008 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 127 | 2.02e-35 | NR | MBK7962734.1 | 2053517 | g3863 | i0 | 57 | 0.974025974025974 | 100 | 43 | 97.4 | 0 | 9 | 308 | 16 | 115 | MBK7962734.1 DUF1761 domain-containing protein [Bdellovibrionales bacterium] | diamond | 300 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;