contig_metadata
4 rows where bioproject = "PRJNA385396", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12555209 | 12555209 | PRJNA385396_P_NODE_14210_length_250_cov_0.870056_g14118_i0 | PRJNA385396 | 14210 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 79.3 | 5.32e-15 | NR | MCM2282129.1 | 2026715 | g14118 | i0 | 48.7 | 9.408 | 78 | 37 | 92.4 | 2 | 20 | 250 | 513 | 588 | MCM2282129.1 translational GTPase TypA [Pseudobdellovibrionaceae bacterium] | diamond | 2352 | 79.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 13160904 | 13160904 | PRJNA385396_P_NODE_6451_length_334_cov_1.180077_g6359_i0 | PRJNA385396 | 6451 | 334 | 1.180077 | 3.94145718 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 107 | 3.11e-27 | NR | MBK9324200.1 | 2026715 | g6359 | i0 | 57.5 | 6.41317365269461 | 87 | 37 | 78.1 | 0 | 31 | 291 | 4 | 90 | MBK9324200.1 RNA-binding protein [Pseudobdellovibrionaceae bacterium] | diamond | 2142 | 107 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 15709614 | 15709614 | PRJNA385396_P_NODE_16973_length_247_cov_0.885057_g16881_i0 | PRJNA385396 | 16973 | 247 | 0.885057 | 2.18609079 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 156 | 2.4999999999999993e-43 | NR | HXH29741.1 | 2081706 | g16881 | i0 | 87.7 | 0.983805668016194 | 81 | 10 | 98.4 | 0 | 4 | 246 | 24 | 104 | HXH29741.1 5'-nucleotidase C-terminal domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 243 | 156 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32478269 | 32478269 | PRJNA385396_P_NODE_20479_length_242_cov_0.911243_g20387_i0 | PRJNA385396 | 20479 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 128 | 7.04e-33 | NR | MBK7889904.1 | 2053517 | g20387 | i0 | 76.3 | 2.96280991735537 | 80 | 19 | 99.2 | 0 | 3 | 242 | 379 | 458 | MBK7889904.1 type I glutamate--ammonia ligase [Bdellovibrionales bacterium] | diamond | 717 | 128 | 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);;