contig_metadata
10 rows where bioproject = "PRJNA1247234", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6729281 | 6729281 | PRJNA1247234_P_NODE_24786_length_246_cov_0.901734_g24630_i0 | PRJNA1247234 | 24786 | 246 | 0.901734 | 2.21826564 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 159 | 1.03e-45 | NR | MCO5114273.1 | 2026715 | g24630 | i0 | 91.5 | 1 | 82 | 7 | 100 | 0 | 1 | 246 | 244 | 325 | MCO5114273.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Pseudobdellovibrionaceae bacterium] | diamond | 246 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 20752941 | 20752941 | PRJNA1247234_P_NODE_21657_length_251_cov_0.876404_g21501_i0 | PRJNA1247234 | 21657 | 251 | 0.876404 | 2.19977404 | Bdellovibrio sp. HCB288 | 3394355 | Bacteria | Bacteria | 150 | 7.84e-32 | NTclustered | gi|2895994964|gb|CP178619.1| | 3394355 | g21501 | i0 | 78.367 | 135.573705179283 | 245 | 44 | 96 | 9 | 1 | 240 | 574765 | 574525 | Bdellovibrio sp. HCB288 chromosome, complete genome | blastn | 34029 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB288 | ||
| 22028163 | 22028163 | PRJNA1247234_P_NODE_21158_length_252_cov_0.871508_g21002_i0 | PRJNA1247234 | 21158 | 252 | 0.871508 | 2.19620016 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 162 | 9.29e-50 | NR | MCO5114024.1 | 2026715 | g21002 | i0 | 98.8 | 0.976190476190476 | 82 | 1 | 97.6 | 0 | 251 | 6 | 46 | 127 | MCO5114024.1 RidA family protein [Pseudobdellovibrionaceae bacterium] | diamond | 246 | 162 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 26598478 | 26598478 | PRJNA1247234_P_NODE_8861_length_359_cov_1.433566_g8705_i0 | PRJNA1247234 | 8861 | 359 | 1.433566 | 5.14650194 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 62.4 | 3.59e-10 | NR | MCB0370123.1 | 2053517 | g8705 | i0 | 50 | 0.417827298050139 | 50 | 25 | 41.8 | 0 | 162 | 13 | 1 | 50 | MCB0370123.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 150 | 62.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27010191 | 27010191 | PRJNA1247234_P_NODE_21662_length_251_cov_0.876404_g21506_i0 | PRJNA1247234 | 21662 | 251 | 0.876404 | 2.19977404 | Bdellovibrio sp. HAGR | 28201 | Bacteria | Bacteria | 122 | 1.27e-30 | NR | BFD67524.1 | 3113895 | g21506 | i0 | 95.2 | 0.741035856573705 | 62 | 3 | 74.1 | 0 | 2 | 187 | 420 | 481 | BFD67524.1 phage terminase large subunit [Bdellovibrio sp. HAGR004] | diamond | 186 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HAGR004 | ||
| 30073455 | 30073455 | PRJNA1247234_P_NODE_24132_length_247_cov_0.896552_g23976_i0 | PRJNA1247234 | 24132 | 247 | 0.896552 | 2.21448344 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 145 | 7.179999999999999e-40 | NR | MCO5114072.1 | 2026715 | g23976 | i0 | 87.8 | 0.995951417004049 | 82 | 10 | 99.6 | 0 | 2 | 247 | 60 | 141 | MCO5114072.1 agmatine deiminase family protein [Pseudobdellovibrionaceae bacterium] | diamond | 246 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30453002 | 30453002 | PRJNA1247234_P_NODE_25573_length_245_cov_0.906977_g25417_i0 | PRJNA1247234 | 25573 | 245 | 0.906977 | 2.22209365 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 89.4 | 1.5e-18 | NR | MCO5112569.1 | 2026715 | g25417 | i0 | 91.8 | 0.6 | 49 | 4 | 60 | 0 | 245 | 99 | 183 | 231 | MCO5112569.1 ABC transporter permease [Pseudobdellovibrionaceae bacterium] | diamond | 147 | 89.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30831818 | 30831818 | PRJNA1247234_P_NODE_24834_length_246_cov_0.901734_g24678_i0 | PRJNA1247234 | 24834 | 246 | 0.901734 | 2.21826564 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 142 | 1.11e-38 | NR | MCO5113033.1 | 2026715 | g24678 | i0 | 81.5 | 0.98780487804878 | 81 | 15 | 98.8 | 0 | 244 | 2 | 154 | 234 | MCO5113033.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 243 | 142 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 31906888 | 31906888 | PRJNA1247234_P_NODE_20557_length_253_cov_0.866667_g20401_i0 | PRJNA1247234 | 20557 | 253 | 0.866667 | 2.19266751 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 87 | 3.85e-18 | NR | MCO5113716.1 | 2026715 | g20401 | i0 | 90.9 | 0.521739130434783 | 44 | 4 | 52.2 | 0 | 1 | 132 | 281 | 324 | MCO5113716.1 nitronate monooxygenase [Pseudobdellovibrionaceae bacterium] | diamond | 132 | 87 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 32571562 | 32571562 | PRJNA1247234_P_NODE_25459_length_245_cov_0.906977_g25303_i0 | PRJNA1247234 | 25459 | 245 | 0.906977 | 2.22209365 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 157 | 1.23e-46 | NR | MCO5114477.1 | 2026715 | g25303 | i0 | 91.4 | 0.991836734693878 | 81 | 7 | 99.2 | 0 | 245 | 3 | 121 | 201 | MCO5114477.1 ribonuclease HII [Pseudobdellovibrionaceae bacterium] | diamond | 243 | 157 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae 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);;