contig_metadata
9 rows where bioproject = "PRJNA384462", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1680134 | 1680134 | PRJNA384462_S_NODE_10202_length_182_cov_1.533835_g10086_i0 | PRJNA384462 | 10202 | 182 | 1.533835 | 2.7915797 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 270 | 3.93e-68 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g10086 | i0 | 93.407 | 38.8571428571429 | 182 | 12 | 100 | 0 | 1 | 182 | 1292529 | 1292348 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 7072 | 270 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 2956040 | 2956040 | PRJNA384462_S_NODE_9163_length_190_cov_1.063830_g9047_i0 | PRJNA384462 | 9163 | 190 | 1.06383 | 2.021277 | uncultured Pseudobdellovibrionaceae bacterium | 269677 | Bacteria | Bacteria | 313 | 6.78e-81 | NTclustered | gi|2237331304|emb|OW746704.1| | 269677 | g9047 | i0 | 96.316 | 99.8315789473684 | 190 | 7 | 100 | 0 | 1 | 190 | 231 | 42 | uncultured Bdellovibrionaceae bacterium DNA containing 16S-23S intergenic spacer region, clone 43 | blastn | 18968 | 313 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | uncultured Pseudobdellovibrionaceae bacterium | |||
| 18927361 | 18927361 | PRJNA384462_S_NODE_15075_length_162_cov_0.893805_g14959_i0 | PRJNA384462 | 15075 | 162 | 0.893805 | 1.4479641 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 67.8 | 1.78e-11 | NR | TVQ84352.1 | 2024841 | g14959 | i0 | 64.2 | 1.96296296296296 | 53 | 19 | 98.1 | 0 | 2 | 160 | 325 | 377 | TVQ84352.1 MAG: electron transfer flavoprotein-ubiquinone oxidoreductase [Micavibrio sp.] | diamond | 318 | 67.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 27106611 | 27106611 | PRJNA384462_S_NODE_8522_length_195_cov_1.397260_g8406_i0 | PRJNA384462 | 8522 | 195 | 1.39726 | 2.724657 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 111 | 5.2900000000000005e-27 | NR | MCB0368368.1 | 2053517 | g8406 | i0 | 88.9 | 0.969230769230769 | 63 | 7 | 96.9 | 0 | 191 | 3 | 126 | 188 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 189 | 111 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27296420 | 27296420 | PRJNA384462_S_NODE_14963_length_162_cov_0.902655_g14847_i0 | PRJNA384462 | 14963 | 162 | 0.902655 | 1.4623011 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 65.5 | 1.22e-10 | NR | MFT6631004.1 | 2081706 | g14847 | i0 | 60.4 | 0.888888888888889 | 48 | 19 | 88.9 | 0 | 162 | 19 | 830 | 877 | MFT6631004.1 alpha-tubulin suppressor-like RCC1 family protein [Bacteriovoracaceae bacterium] | diamond | 144 | 65.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29001935 | 29001935 | PRJNA384462_S_NODE_1808_length_387_cov_2.701183_g1692_i0 | PRJNA384462 | 1808 | 387 | 2.701183 | 10.45357821 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 121 | 4.65e-29 | NR | MBI2521824.1 | 28201 | g1692 | i0 | 53.2 | 0.961240310077519 | 124 | 52 | 93 | 2 | 25 | 384 | 947 | 1068 | MBI2521824.1 hypothetical protein [Bdellovibrio sp.] | diamond | 372 | 121 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31718692 | 31718692 | PRJNA384462_S_NODE_10897_length_178_cov_1.186047_g10781_i0 | PRJNA384462 | 10897 | 178 | 1.186047 | 2.11116366 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 79.7 | 1.87e-17 | NR | MCB0370576.1 | 2053517 | g10781 | i0 | 70.7 | 0.97752808988764 | 58 | 17 | 97.8 | 0 | 176 | 3 | 49 | 106 | MCB0370576.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 174 | 79.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32256902 | 32256902 | PRJNA384462_S_NODE_7878_length_201_cov_1.006579_g7762_i0 | PRJNA384462 | 7878 | 201 | 1.006579 | 2.02322379 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 107 | 1.85e-27 | NR | MBP9675022.1 | 2081706 | g7762 | i0 | 94.5 | 0.82089552238806 | 55 | 3 | 82.1 | 0 | 200 | 36 | 58 | 112 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 165 | 107 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32288523 | 32288523 | PRJNA384462_S_NODE_919_length_534_cov_2.775258_g806_i0 | PRJNA384462 | 919 | 534 | 2.775258 | 14.81987772 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 79 | 1.61e-13 | NR | MEQ1876897.1 | 3034169 | g806 | i0 | 52.3 | 0.48314606741573 | 86 | 36 | 48.3 | 2 | 1 | 258 | 241 | 321 | MEQ1876897.1 hypothetical protein [Bdellovibrionia bacterium] | diamond | 258 | 79 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia 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);;