contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Levyibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129616 | 129616 | PRJEB64798_P_NODE_81101_length_214_cov_4.666667_g79335_i0 | PRJEB64798 | 81101 | 214 | 4.666667 | 9.98666738 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 167 | 6.449999999999999e-37 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g79335 | i0 | 88.571 | 82.4485981308411 | 140 | 13 | 64 | 2 | 50 | 186 | 717449 | 717588 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 17644 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 12880231 | 12880231 | PRJEB64798_P_NODE_119631_length_206_cov_12.025478_g117865_i0 | PRJEB64798 | 119631 | 206 | 12.025478 | 24.77248468 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 185 | 1.7e-42 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g117865 | i0 | 83.251 | 68.6990291262136 | 203 | 32 | 98 | 2 | 1 | 202 | 718581 | 718782 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 14152 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 17980018 | 17980018 | PRJEB64798_P_NODE_244235_length_153_cov_18.326923_g242469_i0 | PRJEB64798 | 244235 | 153 | 18.326923 | 28.04019219 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 167 | 4.2899999999999995e-37 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g242469 | i0 | 87.943 | 84.6732026143791 | 141 | 17 | 92 | 0 | 1 | 141 | 719455 | 719595 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 12955 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 23079592 | 23079592 | PRJEB64798_P_NODE_183199_length_173_cov_2.717742_g181433_i0 | PRJEB64798 | 183199 | 173 | 2.717742 | 4.70169366 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 231 | 1.7399999999999998e-56 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g181433 | i0 | 90.805 | 1.00578034682081 | 174 | 15 | 100 | 1 | 1 | 173 | 718671 | 718498 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 174 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota 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);;