contig_metadata
6 rows where bioproject = "PRJNA1068513", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4841649 | 4841649 | PRJNA1068513_S_NODE_2784_length_511_cov_2.794521_g2740_i0 | PRJNA1068513 | 2784 | 511 | 2.794521 | 14.28000231 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 601 | 3.96e-167 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g2740 | i0 | 90.57 | 111.405088062622 | 456 | 39 | 89 | 4 | 41 | 494 | 44 | 497 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 56928 | 601 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 11660458 | 11660458 | PRJNA1068513_S_NODE_12550_length_249_cov_0.886364_g12504_i0 | PRJNA1068513 | 12550 | 249 | 0.886364 | 2.20704636 | Pseudobdellovibrio sp. | 2862747 | Bacteria | Bacteria | 150 | 4.71e-44 | NR | MFN3454084.1 | 2862747 | g12504 | i0 | 90.2 | 1.97590361445783 | 82 | 8 | 98.8 | 0 | 248 | 3 | 27 | 108 | MFN3454084.1 Tex-like N-terminal domain-containing protein [Pseudobdellovibrio sp.] | diamond | 492 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. | ||
| 18033615 | 18033615 | PRJNA1068513_S_NODE_5355_length_393_cov_1.428125_g5309_i0 | PRJNA1068513 | 5355 | 393 | 1.428125 | 5.61253125 | Pseudobdellovibrio sp. HCB154 | 3386277 | Bacteria | Bacteria | 252 | 3.45e-62 | NTclustered | gi|2872995934|gb|CP176530.1| | 3386277 | g5309 | i0 | 78.796 | 3.06870229007634 | 382 | 76 | 96 | 4 | 16 | 393 | 2536614 | 2536234 | Pseudobdellovibrio sp. HCB154 chromosome, complete genome | blastn | 1206 | 252 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. HCB154 | ||
| 27596138 | 27596138 | PRJNA1068513_S_NODE_5204_length_398_cov_3.433846_g5159_i0 | PRJNA1068513 | 5204 | 398 | 3.433846 | 13.66670708 | Bdellovibrio | 958 | Bacteria | Bacteria | 156 | 4.49e-45 | NR | MBO9668790.1 | 28201 | g5159 | i0 | 70.1 | 12.7311557788945 | 107 | 32 | 80.7 | 0 | 3 | 323 | 127 | 233 | MBO9668790.1 PLP-dependent transferase [Bdellovibrio sp.] | diamond | 5067 | 157 | 0.993630573248408 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 29972515 | 29972515 | PRJNA1068513_S_NODE_9871_length_285_cov_2.080189_g9825_i0 | PRJNA1068513 | 9871 | 285 | 2.080189 | 5.92853865 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 52 | 1.98e-5 | NR | MDA8792049.1 | 2081706 | g9825 | i0 | 34.1 | 0.957894736842105 | 91 | 52 | 92.6 | 3 | 266 | 3 | 124 | 209 | MDA8792049.1 trypsin-like serine protease [Bacteriovoracaceae bacterium] | diamond | 273 | 52 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31615919 | 31615919 | PRJNA1068513_S_NODE_5996_length_372_cov_2.652174_g5950_i0 | PRJNA1068513 | 5996 | 372 | 2.652174 | 9.86608728 | Bacteriovorax sp. DB6_IX | 1353530 | Bacteria | Bacteria | 44.7 | 0.0277 | NR | WP_021278921.1 | 1353530 | g5950 | i0 | 35.3 | 0.685483870967742 | 85 | 43 | 68.5 | 3 | 321 | 67 | 210 | 282 | WP_021278921.1 proline iminopeptidase-family hydrolase [Bacteriovorax sp. DB6_IX] | diamond | 255 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. DB6_IX |
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);;