contig_metadata
12 rows where bioproject = "PRJNA415856", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5523202 | 5523202 | PRJNA415856_P_NODE_51905_length_161_cov_0.910714_g51644_i0 | PRJNA415856 | 51905 | 161 | 0.910714 | 1.46624954 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 108 | 3.5e-26 | NR | HMN68864.1 | 2053517 | g51644 | i0 | 90.6 | 2.96273291925466 | 53 | 5 | 98.8 | 0 | 2 | 160 | 65 | 117 | HMN68864.1 pitrilysin family protein [Bdellovibrionales bacterium] | diamond | 477 | 108 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 9347409 | 9347409 | PRJNA415856_P_NODE_30268_length_174_cov_1.424000_g30007_i0 | PRJNA415856 | 30268 | 174 | 1.424 | 2.47776 | Bdellovibrio | 958 | Bacteria | Bacteria | 114 | 4.17e-29 | NR | WP_063244947.1 | 959 | g30007 | i0 | 91.4 | 4 | 58 | 5 | 100 | 0 | 174 | 1 | 41 | 98 | WP_063244947.1 polyprenyl synthetase family protein [Bdellovibrio bacteriovorus] | diamond | 696 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 13836897 | 13836897 | PRJNA415856_P_NODE_25771_length_182_cov_1.285714_g25510_i0 | PRJNA415856 | 25771 | 182 | 1.285714 | 2.33999948 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 315 | 1.79e-81 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g25510 | i0 | 97.802 | 229.071428571429 | 182 | 4 | 100 | 0 | 1 | 182 | 2093 | 2274 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 41691 | 315 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 18270988 | 18270988 | PRJNA415856_P_NODE_39815_length_165_cov_1.758621_g39554_i0 | PRJNA415856 | 39815 | 165 | 1.758621 | 2.90172465 | uncultured Bdellovibrio sp. | 239744 | Bacteria | Bacteria | 305 | 9.59e-79 | NTclustered | gi|758818755|emb|HF912306.1| | 239744 | g39554 | i0 | 100 | 113.993939393939 | 165 | 0 | 100 | 0 | 1 | 165 | 515 | 351 | Uncultured Bdellovibrio sp. partial 16S rRNA gene, clone AcqueII_11 | blastn | 18809 | 305 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | uncultured Bdellovibrio sp. | ||
| 27043962 | 27043962 | PRJNA415856_P_NODE_32542_length_170_cov_1.685950_g32281_i0 | PRJNA415856 | 32542 | 170 | 1.68595 | 2.866115 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 61.2 | 4.09e-9 | NR | MCO5143639.1 | 2599941 | g32281 | i0 | 54.5 | 0.970588235294118 | 55 | 25 | 97.1 | 0 | 3 | 167 | 67 | 121 | MCO5143639.1 ABC transporter substrate-binding protein [Oligoflexia bacterium] | diamond | 165 | 61.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 28513370 | 28513370 | PRJNA415856_P_NODE_22027_length_189_cov_1.335714_g21766_i0 | PRJNA415856 | 22027 | 189 | 1.335714 | 2.52449946 | Bdellovibrio | 958 | Bacteria | Bacteria | 114 | 9.65e-29 | NR | WP_415064305.1 | 28201 | g21766 | i0 | 83.9 | 6.82539682539683 | 62 | 10 | 98.4 | 0 | 188 | 3 | 211 | 272 | WP_415064305.1 class I SAM-dependent methyltransferase [Bdellovibrio sp.] | diamond | 1290 | 114 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 29776210 | 29776210 | PRJNA415856_P_NODE_52971_length_161_cov_0.910714_g52710_i0 | PRJNA415856 | 52971 | 161 | 0.910714 | 1.46624954 | Bdellovibrio | 958 | Bacteria | Bacteria | 100 | 6.72e-24 | NR | WP_328517233.1 | 2972972 | g52710 | i0 | 86.5 | 3.8944099378882 | 52 | 7 | 96.9 | 0 | 158 | 3 | 42 | 93 | WP_328517233.1 alpha/beta hydrolase [Bdellovibrio svalbardensis] | diamond | 627 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio svalbardensis | ||
| 30423487 | 30423487 | PRJNA415856_P_NODE_39433_length_166_cov_0.871795_g39172_i0 | PRJNA415856 | 39433 | 166 | 0.871795 | 1.4471797 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 83.2 | 7.08e-17 | NR | HEX4924816.1 | 2053517 | g39172 | i0 | 66.7 | 0.975903614457831 | 54 | 18 | 97.6 | 0 | 3 | 164 | 817 | 870 | HEX4924816.1 zinc-dependent metalloprotease [Bdellovibrionales bacterium] | diamond | 162 | 83.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30865390 | 30865390 | PRJNA415856_P_NODE_42174_length_165_cov_0.879310_g41913_i0 | PRJNA415856 | 42174 | 165 | 0.87931 | 1.4508615 | Bdellovibrio | 958 | Bacteria | Bacteria | 41.6 | 0.0323 | NR | WP_374078522.1 | 958 | g41913 | i0 | 58.6 | 0.527272727272727 | 29 | 12 | 52.7 | 0 | 163 | 77 | 42 | 70 | WP_374078522.1 MULTISPECIES: S1 family peptidase [Bdellovibrio] | diamond | 87 | 41.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 30991963 | 30991963 | PRJNA415856_P_NODE_43714_length_164_cov_0.886957_g43453_i0 | PRJNA415856 | 43714 | 164 | 0.886957 | 1.45460948 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 54.3 | 1.02e-6 | NR | MBC7529947.1 | 1971216 | g43453 | i0 | 95.8 | 0.439024390243902 | 24 | 1 | 43.9 | 0 | 163 | 92 | 313 | 336 | MBC7529947.1 ligase-associated DNA damage response exonuclease [Oligoflexus sp.] | diamond | 72 | 54.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 32825236 | 32825236 | PRJNA415856_P_NODE_27260_length_179_cov_1.430769_g26999_i0 | PRJNA415856 | 27260 | 179 | 1.430769 | 2.56107651 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 94.7 | 4.019999999999999e-23 | NR | MBX3023249.1 | 2053517 | g26999 | i0 | 76.3 | 1.9608938547486 | 59 | 14 | 98.9 | 0 | 179 | 3 | 40 | 98 | MBX3023249.1 methylmalonyl-CoA epimerase [Bdellovibrionales bacterium] | diamond | 351 | 94.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32888010 | 32888010 | PRJNA415856_P_NODE_52680_length_161_cov_0.910714_g52419_i0 | PRJNA415856 | 52680 | 161 | 0.910714 | 1.46624954 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 99 | 2.76e-24 | NR | MBX3021525.1 | 2053517 | g52419 | i0 | 88.7 | 0.987577639751553 | 53 | 6 | 98.8 | 0 | 2 | 160 | 64 | 116 | MBX3021525.1 biopolymer transporter ExbD [Bdellovibrionales bacterium] | diamond | 159 | 99 | 1 | 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);;