contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 777089 | 777089 | PRJNA792582_P_NODE_52761_length_248_cov_0.880000_g51947_i0 | PRJNA792582 | 52761 | 248 | 0.88 | 2.1824 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 137 | 1.6999999999999998e-36 | NR | MCB0412082.1 | 2053517 | g51947 | i0 | 78 | 2.9758064516129 | 82 | 18 | 99.2 | 0 | 248 | 3 | 136 | 217 | MCB0412082.1 DEAD/DEAH box helicase [Bdellovibrionales bacterium] | diamond | 738 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 21617763 | 21617763 | PRJNA792582_P_NODE_59697_length_241_cov_0.886905_g58883_i0 | PRJNA792582 | 59697 | 241 | 0.886905 | 2.13744105 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 127 | 5.579999999999998e-35 | NR | WP_321393881.1 | 28202 | g58883 | i0 | 72 | 1.15767634854772 | 93 | 10 | 95.9 | 1 | 234 | 4 | 12 | 104 | WP_321393881.1 DUF3015 family protein [Peredibacter starrii] | diamond | 279 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 27401572 | 27401572 | PRJNA792582_P_NODE_57563_length_243_cov_0.905882_g56749_i0 | PRJNA792582 | 57563 | 243 | 0.905882 | 2.20129326 | Bdellovibrio sp. SKB1291214 | 1732569 | Bacteria | Bacteria | 67 | 3.02e-12 | NR | WP_088616025.1 | 1732569 | g56749 | i0 | 54.2 | 2.69135802469136 | 72 | 33 | 88.9 | 0 | 223 | 8 | 1 | 72 | WP_088616025.1 ATP synthase F0 subunit C [Bdellovibrio sp. SKB1291214] | diamond | 654 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. SKB1291214 | ||
| 27654197 | 27654197 | PRJNA792582_P_NODE_54404_length_246_cov_1.323699_g53590_i0 | PRJNA792582 | 54404 | 246 | 1.323699 | 3.25629954 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 56.6 | 4.19e-8 | NR | MCB0331116.1 | 2053517 | g53590 | i0 | 46.2 | 3.26829268292683 | 65 | 31 | 79.3 | 1 | 204 | 10 | 16 | 76 | MCB0331116.1 50S ribosomal protein L23 [Bdellovibrionales bacterium] | diamond | 804 | 56.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28317143 | 28317143 | PRJNA792582_P_NODE_44766_length_265_cov_1.244792_g43952_i0 | PRJNA792582 | 44766 | 265 | 1.244792 | 3.2986988 | Bdellovibrio sp. 28-41-41 | 1970323 | Bacteria | Bacteria | 102 | 4.05e-24 | NR | OYZ24383.1 | 1970323 | g43952 | i0 | 61.8 | 0.860377358490566 | 76 | 28 | 86 | 1 | 36 | 263 | 166 | 240 | OYZ24383.1 MAG: hypothetical protein B7Y39_01625 [Bdellovibrio sp. 28-41-41] | diamond | 228 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 28-41-41 | ||
| 29620326 | 29620326 | PRJNA792582_P_NODE_39330_length_279_cov_2.072816_g38516_i0 | PRJNA792582 | 39330 | 279 | 2.072816 | 5.78315664 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 61.2 | 1.9e-9 | NR | MBK7891702.1 | 2053517 | g38516 | i0 | 48.4 | 2.26881720430108 | 64 | 33 | 68.8 | 0 | 241 | 50 | 7 | 70 | MBK7891702.1 flagellar basal body rod protein FlgB [Bdellovibrionales bacterium] | diamond | 633 | 61.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31136913 | 31136913 | PRJNA792582_P_NODE_54675_length_246_cov_0.890173_g53861_i0 | PRJNA792582 | 54675 | 246 | 0.890173 | 2.18982558 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 69.3 | 1.39e-11 | NR | WP_325144650.1 | 1971216 | g53861 | i0 | 82.9 | 0.841463414634146 | 35 | 6 | 42.7 | 0 | 244 | 140 | 142 | 176 | WP_325144650.1 IS3 family transposase [Oligoflexus sp.] | diamond | 207 | 69.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. |
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);;