contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2695297 | 2695297 | PRJNA1000943_P_NODE_12963_length_248_cov_0.891429_g12825_i0 | PRJNA1000943 | 12963 | 248 | 0.891429 | 2.21074392 | Pseudobacteriovorax | 1769746 | Bacteria | Bacteria | 121 | 7.1e-30 | NR | NRA68712.1 | 2020859 | g12825 | i0 | 73.8 | 6.7258064516129 | 80 | 21 | 96.8 | 0 | 247 | 8 | 148 | 227 | NRA68712.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Pseudobacteriovorax sp.] | diamond | 1668 | 122 | 0.991803278688525 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax sp. | ||
| 20546245 | 20546245 | PRJNA1000943_P_NODE_12317_length_250_cov_0.881356_g12179_i0 | PRJNA1000943 | 12317 | 250 | 0.881356 | 2.20339 | Bdellovibrio sp. 28-41-41 | 1970323 | Bacteria | Bacteria | 171 | 1.64e-53 | NR | OYZ13569.1 | 1970323 | g12179 | i0 | 98.8 | 0.996 | 83 | 1 | 99.6 | 0 | 1 | 249 | 2 | 84 | OYZ13569.1 MAG: thioredoxin [Bdellovibrio sp. 28-41-41] | diamond | 249 | 171 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 28-41-41 | ||
| 29213576 | 29213576 | PRJNA1000943_P_NODE_13869_length_246_cov_0.901734_g13731_i0 | PRJNA1000943 | 13869 | 246 | 0.901734 | 2.21826564 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 107 | 4.63e-26 | NR | WP_061834069.1 | 959 | g13731 | i0 | 67.1 | 2.89024390243902 | 79 | 26 | 96.3 | 0 | 10 | 246 | 1 | 79 | WP_061834069.1 SDR family oxidoreductase [Bdellovibrio bacteriovorus] | diamond | 711 | 107 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 30413790 | 30413790 | PRJNA1000943_P_NODE_11793_length_251_cov_0.876404_g11655_i0 | PRJNA1000943 | 11793 | 251 | 0.876404 | 2.19977404 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 70.9 | 2.12e-12 | NR | MCC6137820.1 | 2026715 | g11655 | i0 | 97 | 0.394422310756972 | 33 | 1 | 39.4 | 0 | 250 | 152 | 230 | 262 | MCC6137820.1 DUF1338 domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 99 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 31038343 | 31038343 | PRJNA1000943_P_NODE_4095_length_388_cov_0.946032_g3958_i0 | PRJNA1000943 | 4095 | 388 | 0.946032 | 3.67060416 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 111 | 1.99e-28 | NR | MFA4994930.1 | 2053517 | g3958 | i0 | 49.6 | 15.0927835051546 | 113 | 54 | 85.1 | 3 | 337 | 8 | 5 | 117 | MFA4994930.1 single-stranded DNA-binding protein [Bdellovibrionales bacterium] | diamond | 5856 | 112 | 0.991071428571429 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31298229 | 31298229 | PRJNA1000943_P_NODE_12975_length_248_cov_0.891429_g12837_i0 | PRJNA1000943 | 12975 | 248 | 0.891429 | 2.21074392 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 58.2 | 1.46e-7 | NR | MBT7608812.1 | 2081706 | g12837 | i0 | 45.6 | 1.28225806451613 | 57 | 31 | 69 | 0 | 197 | 27 | 676 | 732 | MBT7608812.1 penicillin acylase family protein [Bacteriovoracaceae bacterium] | diamond | 318 | 58.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32847060 | 32847060 | PRJNA1000943_P_NODE_6960_length_309_cov_2.644068_g6822_i0 | PRJNA1000943 | 6960 | 309 | 2.644068 | 8.17017012 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 51.6 | 4.04e-5 | NR | MCO4753379.1 | 2081706 | g6822 | i0 | 34.4 | 0.902912621359223 | 93 | 50 | 83.5 | 3 | 5 | 262 | 72 | 160 | MCO4753379.1 glutathione S-transferase [Bacteriovoracaceae bacterium] | diamond | 279 | 51.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;