contig_metadata
8 rows where bioproject = "PRJNA929522", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6008612 | 6008612 | PRJNA929522_S_NODE_8565_length_250_cov_1.677966_g8495_i0 | PRJNA929522 | 8565 | 250 | 1.677966 | 4.194915 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 131 | 5.86e-36 | NR | MBO9668790.1 | 28201 | g8495 | i0 | 68.7 | 11.94 | 83 | 26 | 99.6 | 0 | 249 | 1 | 86 | 168 | MBO9668790.1 PLP-dependent transferase [Bdellovibrio sp.] | diamond | 2985 | 132 | 0.992424242424242 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 20032007 | 20032007 | PRJNA929522_S_NODE_7496_length_264_cov_1.209424_g7426_i0 | PRJNA929522 | 7496 | 264 | 1.209424 | 3.19287936 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 104 | 6.56e-18 | NTclustered | gi|289320|gb|M61238.1|BDLDDAI | 28201 | g7426 | i0 | 80.42 | 19.4962121212121 | 143 | 22 | 53 | 6 | 3 | 142 | 742 | 603 | Bdellovibrio sp. 16S rRNA gene, partial cds | blastn | 5147 | 104 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 27877759 | 27877759 | PRJNA929522_S_NODE_2685_length_408_cov_2.268657_g2615_i0 | PRJNA929522 | 2685 | 408 | 2.268657 | 9.25612056 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 57.4 | 1.61e-6 | NR | RME15219.1 | 28201 | g2615 | i0 | 38.7 | 1.625 | 106 | 58 | 75 | 4 | 316 | 11 | 50 | 152 | RME15219.1 MAG: peptidase S8 [Bdellovibrio sp.] | diamond | 663 | 57.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 28224858 | 28224858 | PRJNA929522_S_NODE_7686_length_261_cov_1.638298_g7616_i0 | PRJNA929522 | 7686 | 261 | 1.638298 | 4.27595778 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 71.6 | 3.07e-12 | NR | MFL5815885.1 | 3034169 | g7616 | i0 | 57.5 | 0.839080459770115 | 73 | 29 | 83.9 | 1 | 236 | 18 | 48 | 118 | MFL5815885.1 right-handed parallel beta-helix repeat-containing protein [Bdellovibrionia bacterium] | diamond | 219 | 71.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 28667269 | 28667269 | PRJNA929522_S_NODE_8947_length_248_cov_0.880000_g8877_i0 | PRJNA929522 | 8947 | 248 | 0.88 | 2.1824 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 67.4 | 2.3e-12 | NR | HEU4838161.1 | 2024841 | g8877 | i0 | 37.8 | 3.36290322580645 | 74 | 46 | 89.5 | 0 | 247 | 26 | 25 | 98 | HEU4838161.1 ETC complex I subunit [Micavibrio sp.] | diamond | 834 | 67.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 32554566 | 32554566 | PRJNA929522_S_NODE_2599_length_415_cov_2.233918_g2529_i0 | PRJNA929522 | 2599 | 415 | 2.233918 | 9.2707597 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 120 | 2.72e-31 | NR | MCB0369154.1 | 2053517 | g2529 | i0 | 53.3 | 1.47469879518072 | 107 | 48 | 75.9 | 1 | 412 | 98 | 62 | 168 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 612 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32617293 | 32617293 | PRJNA929522_S_NODE_9460_length_245_cov_0.895349_g9390_i0 | PRJNA929522 | 9460 | 245 | 0.895349 | 2.19360505 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 60.1 | 2.09e-8 | NR | MCB0347311.1 | 2053517 | g9390 | i0 | 46.3 | 0.979591836734694 | 80 | 31 | 98 | 1 | 243 | 4 | 76 | 143 | MCB0347311.1 arginine--tRNA ligase [Bdellovibrionales bacterium] | diamond | 240 | 60.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32907652 | 32907652 | PRJNA929522_S_NODE_2600_length_415_cov_2.198830_g2530_i0 | PRJNA929522 | 2600 | 415 | 2.19883 | 9.1251445 | Bacteria | 2 | Bacteria | Bacteria | 118 | 4.43e-30 | NR | MCB0416831.1 | 2053517 | g2530 | i0 | 44.9 | 3.93253012048193 | 136 | 69 | 96.9 | 3 | 4 | 405 | 55 | 186 | MCB0416831.1 DUF1028 domain-containing protein [Bdellovibrionales bacterium] | diamond | 1632 | 119 | 0.991596638655462 | 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);;