contig_metadata
8 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742415 | 742415 | PRJNA760976_P_NODE_49101_length_249_cov_0.875000_g48780_i0 | PRJNA760976 | 49101 | 249 | 0.875 | 2.17875 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 135 | 1.1699999999999999e-34 | NR | MAV91622.1 | 2026715 | g48780 | i0 | 80.5 | 1.96385542168675 | 82 | 16 | 98.8 | 0 | 246 | 1 | 340 | 421 | MAV91622.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 489 | 135 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 7121154 | 7121154 | PRJNA760976_P_NODE_48486_length_250_cov_1.152542_g48165_i0 | PRJNA760976 | 48486 | 250 | 1.152542 | 2.881355 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 136 | 3.47e-36 | NR | MCB0368368.1 | 2053517 | g48165 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 1 | 249 | 132 | 214 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27410724 | 27410724 | PRJNA760976_P_NODE_52643_length_244_cov_1.350877_g52322_i0 | PRJNA760976 | 52643 | 244 | 1.350877 | 3.29613988 | Bacteria | 2 | Bacteria | Bacteria | 45.1 | 0.00581 | NR | WP_325139870.1 | 1971216 | g52322 | i0 | 38.7 | 4.77049180327869 | 75 | 38 | 92.2 | 2 | 10 | 234 | 443 | 509 | WP_325139870.1 fasciclin domain-containing protein [Oligoflexus sp.] | diamond | 1164 | 45.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 27852420 | 27852420 | PRJNA760976_P_NODE_28744_length_307_cov_1.294872_g28423_i0 | PRJNA760976 | 28744 | 307 | 1.294872 | 3.97525704 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 59.3 | 1.64e-8 | NR | WP_324960231.1 | 1971216 | g28423 | i0 | 45 | 2.29641693811075 | 60 | 33 | 58.6 | 0 | 124 | 303 | 1 | 60 | WP_324960231.1 fasciclin domain-containing protein [Oligoflexus sp.] | diamond | 705 | 59.7 | 0.993299832495812 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 28032394 | 28032394 | PRJNA760976_P_NODE_29925_length_303_cov_0.947826_g29604_i0 | PRJNA760976 | 29925 | 303 | 0.947826 | 2.87191278 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 54.3 | 6.11e-7 | NR | MCB0368407.1 | 2053517 | g29604 | i0 | 54 | 0.495049504950495 | 50 | 23 | 49.5 | 0 | 153 | 4 | 2 | 51 | MCB0368407.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 150 | 54.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28379561 | 28379561 | PRJNA760976_P_NODE_43966_length_261_cov_1.218085_g43645_i0 | PRJNA760976 | 43966 | 261 | 1.218085 | 3.17920185 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 118 | 1.37e-28 | NR | NRA44133.1 | 2687297 | g43645 | i0 | 66.7 | 2 | 87 | 29 | 100 | 0 | 1 | 261 | 332 | 418 | NRA44133.1 dihydrofolate reductase [Oligoflexales bacterium] | diamond | 522 | 118 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 29800324 | 29800324 | PRJNA760976_P_NODE_54931_length_242_cov_1.319527_g54610_i0 | PRJNA760976 | 54931 | 242 | 1.319527 | 3.19325534 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 117 | 8.35e-31 | NR | MFN8790765.1 | 2053517 | g54610 | i0 | 61.3 | 3.95454545454545 | 80 | 31 | 99.2 | 0 | 2 | 241 | 41 | 120 | MFN8790765.1 lipocalin family protein [Bdellovibrionales bacterium] | diamond | 957 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31601889 | 31601889 | PRJNA760976_P_NODE_14356_length_392_cov_1.404389_g14036_i0 | PRJNA760976 | 14356 | 392 | 1.404389 | 5.50520488 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 211 | 2.3899999999999997e-67 | NR | MBP9675022.1 | 2081706 | g14036 | i0 | 81.7 | 0.964285714285714 | 126 | 22 | 95.7 | 1 | 5 | 379 | 1 | 126 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 378 | 211 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;