contig_metadata
3 rows where bioproject = "PRJEB58983", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11603511 | 11603511 | PRJEB58983_P_NODE_31950_length_243_cov_1.335294_g31535_i0 | PRJEB58983 | 31950 | 243 | 1.335294 | 3.24476442 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 331 | 2.51e-86 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g31535 | i0 | 91.358 | 117.40329218107 | 243 | 20 | 100 | 1 | 1 | 243 | 342445 | 342686 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 28529 | 331 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 30255080 | 30255080 | PRJEB58983_P_NODE_34112_length_231_cov_2.196203_g33697_i0 | PRJEB58983 | 34112 | 231 | 2.196203 | 5.07322893 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42.4 | 0.0428 | NR | HKO15661.1 | 2026741 | g33697 | i0 | 39.6 | 0.688311688311688 | 53 | 32 | 68.8 | 0 | 178 | 20 | 439 | 491 | HKO15661.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 159 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31069680 | 31069680 | PRJEB58983_P_NODE_20895_length_285_cov_1.466981_g20480_i0 | PRJEB58983 | 20895 | 285 | 1.466981 | 4.18089585 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 2.02e-6 | NR | MCY4351975.1 | 2026742 | g20480 | i0 | 38.7 | 4.89473684210526 | 93 | 44 | 91.6 | 3 | 18 | 278 | 61 | 146 | MCY4351975.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 1395 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;