contig_metadata
3 rows where bioproject = "PRJNA986481" and tax_phylum = "Candidatus Kapaibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28068685 | 28068685 | PRJNA986481_P_NODE_28325_length_308_cov_1.683398_g27800_i0 | PRJNA986481 | 28325 | 308 | 1.683398 | 5.18486584 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 51.6 | 5.88e-5 | NR | HET6512553.1 | 2447898 | g27800 | i0 | 31.6 | 0.954545454545455 | 98 | 63 | 91.6 | 2 | 306 | 25 | 238 | 335 | HET6512553.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 294 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 28605474 | 28605474 | PRJNA986481_P_NODE_31767_length_290_cov_1.593361_g31242_i0 | PRJNA986481 | 31767 | 290 | 1.593361 | 4.6207469 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 54.7 | 4.07e-6 | NR | HVZ37761.1 | 2447898 | g31242 | i0 | 48.3 | 0.620689655172414 | 60 | 27 | 62.1 | 1 | 182 | 3 | 513 | 568 | HVZ37761.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 180 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29615504 | 29615504 | PRJNA986481_P_NODE_35910_length_272_cov_1.874439_g35385_i0 | PRJNA986481 | 35910 | 272 | 1.874439 | 5.09847408 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 164 | 3.849999999999999e-47 | NR | MCU0426337.1 | 2447898 | g35385 | i0 | 88.6 | 0.970588235294118 | 88 | 10 | 97.1 | 0 | 7 | 270 | 23 | 110 | MCU0426337.1 CoA transferase [Candidatus Kapaibacterium sp.] | diamond | 264 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. |
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);;