contig_metadata
12 rows where bioproject = "PRJDB4470", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12762642 | 12762642 | PRJDB4470_P_NODE_112031_length_165_cov_0.879310_g110876_i0 | PRJDB4470 | 112031 | 165 | 0.87931 | 1.4508615 | Bdellovibrio | 958 | Bacteria | Bacteria | 100 | 8.22e-23 | NR | WP_063244129.1 | 959 | g110876 | i0 | 89.1 | 2.96363636363636 | 55 | 6 | 100 | 0 | 1 | 165 | 431 | 485 | WP_063244129.1 sensor histidine kinase [Bdellovibrio bacteriovorus] | diamond | 489 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 12763046 | 12763046 | PRJDB4470_P_NODE_4231_length_1127_cov_4.569573_g3707_i0 | PRJDB4470 | 4231 | 1127 | 4.569573 | 51.49908771 | Bdellovibrio sp. CG1 | 28201 | Bacteria | Bacteria | 476 | 8.049999999999999e-164 | NR | PIS10887.1 | 1975526 | g3707 | i0 | 62.1 | 0.976929902395741 | 367 | 135 | 97.7 | 1 | 25 | 1125 | 53 | 415 | PIS10887.1 MAG: MFS transporter [Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8] | diamond | 1101 | 476 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8 | ||
| 14037096 | 14037096 | PRJDB4470_P_NODE_105652_length_167_cov_0.864407_g104497_i0 | PRJDB4470 | 105652 | 167 | 0.864407 | 1.44355969 | Bdellovibrio sp. HCB-162 | 3394234 | Bacteria | Bacteria | 193 | 7.909999999999999e-45 | NTclustered | gi|2898207634|gb|CP178861.1| | 3394234 | g104497 | i0 | 87.425 | 1 | 167 | 21 | 100 | 0 | 1 | 167 | 800386 | 800552 | Bdellovibrio sp. HCB-162 chromosome, complete genome | blastn | 167 | 193 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB-162 | ||
| 17860901 | 17860901 | PRJDB4470_P_NODE_108575_length_166_cov_0.871795_g107420_i0 | PRJDB4470 | 108575 | 166 | 0.871795 | 1.4471797 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 121 | 3.76e-23 | NTclustered | gi|2800914199|gb|CP168971.1| | 959 | g107420 | i0 | 80.921 | 1.16867469879518 | 152 | 29 | 92 | 0 | 3 | 154 | 2455235 | 2455386 | Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome | blastn | 194 | 121 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 21686196 | 21686196 | PRJDB4470_P_NODE_54798_length_269_cov_1.850000_g53643_i0 | PRJDB4470 | 54798 | 269 | 1.85 | 4.9765 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 396 | 9.88e-106 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g53643 | i0 | 93.284 | 240.28624535316 | 268 | 18 | 99 | 0 | 1 | 268 | 1661418 | 1661151 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 64637 | 396 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 27506644 | 27506644 | PRJDB4470_P_NODE_112823_length_165_cov_0.879310_g111668_i0 | PRJDB4470 | 112823 | 165 | 0.87931 | 1.4508615 | Bacteriovorax sp. | 2608087 | Bacteria | Bacteria | 83.6 | 2.88e-17 | NR | MDO9183135.1 | 2608087 | g111668 | i0 | 72.2 | 0.981818181818182 | 54 | 15 | 98.2 | 0 | 2 | 163 | 183 | 236 | MDO9183135.1 recombinase family protein [Bacteriovorax sp.] | diamond | 162 | 83.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 27980085 | 27980085 | PRJDB4470_P_NODE_112205_length_165_cov_0.879310_g111050_i0 | PRJDB4470 | 112205 | 165 | 0.87931 | 1.4508615 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 55.1 | 5.27e-7 | NR | MBL7688214.1 | 2026715 | g111050 | i0 | 41.5 | 1.90909090909091 | 53 | 31 | 96.4 | 0 | 161 | 3 | 112 | 164 | MBL7688214.1 trypsin-like serine protease [Pseudobdellovibrionaceae bacterium] | diamond | 315 | 55.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29337818 | 29337818 | PRJDB4470_P_NODE_95449_length_175_cov_1.619048_g94294_i0 | PRJDB4470 | 95449 | 175 | 1.619048 | 2.833334 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 60.5 | 8.01e-9 | NR | MCO5142403.1 | 2599941 | g94294 | i0 | 66.7 | 0.72 | 42 | 14 | 72 | 0 | 3 | 128 | 493 | 534 | MCO5142403.1 membrane protein insertase YidC [Oligoflexia bacterium] | diamond | 126 | 60.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30411942 | 30411942 | PRJDB4470_P_NODE_100173_length_169_cov_1.700000_g99018_i0 | PRJDB4470 | 100173 | 169 | 1.7 | 2.873 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 54.7 | 8.43e-7 | NR | WP_374077481.1 | 959 | g99018 | i0 | 48.2 | 0.994082840236686 | 56 | 29 | 99.4 | 0 | 1 | 168 | 637 | 692 | WP_374077481.1 hypothetical protein [Bdellovibrio bacteriovorus] | diamond | 168 | 54.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 30948911 | 30948911 | PRJDB4470_P_NODE_111654_length_165_cov_0.879310_g110499_i0 | PRJDB4470 | 111654 | 165 | 0.87931 | 1.4508615 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 61.2 | 3.79e-9 | NR | HMN67922.1 | 2053517 | g110499 | i0 | 53.7 | 0.981818181818182 | 54 | 25 | 98.2 | 0 | 164 | 3 | 714 | 767 | HMN67922.1 response regulator [Bdellovibrionales bacterium] | diamond | 162 | 61.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31517901 | 31517901 | PRJDB4470_P_NODE_111736_length_165_cov_0.879310_g110581_i0 | PRJDB4470 | 111736 | 165 | 0.87931 | 1.4508615 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 105 | 7.27e-25 | NR | MCC6137366.1 | 2026715 | g110581 | i0 | 84.9 | 1.92727272727273 | 53 | 8 | 96.4 | 0 | 2 | 160 | 146 | 198 | MCC6137366.1 alkaline phosphatase D family protein [Pseudobdellovibrionaceae bacterium] | diamond | 318 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 32782067 | 32782067 | PRJDB4470_P_NODE_105360_length_167_cov_0.864407_g104205_i0 | PRJDB4470 | 105360 | 167 | 0.864407 | 1.44355969 | Bdellovibrio sp. HCB2-146 | 3394362 | Bacteria | Bacteria | 104 | 2.6799999999999998e-24 | NR | WP_413938630.1 | 3394362 | g104205 | i0 | 90.9 | 0.988023952095808 | 55 | 5 | 98.8 | 0 | 3 | 167 | 289 | 343 | WP_413938630.1 excinuclease ABC subunit UvrA [Bdellovibrio sp. HCB2-146] | diamond | 165 | 104 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB2-146 |
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);;