contig_metadata
9 rows where bioproject = "PRJNA340009", tax_clade = "FCB group" and tax_phylum = "Candidatus Latescibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13145734 | 13145734 | PRJNA340009_P_NODE_35071_length_212_cov_29.754601_g34764_i0 | PRJNA340009 | 35071 | 212 | 29.754601 | 63.07975412 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 52.8 | 0.019 | NTclustered | gi|2108425585|gb|CP070631.1| | 2053570 | g34764 | i0 | 100 | 0.132075471698113 | 28 | 0 | 13 | 0 | 164 | 191 | 3278671 | 3278644 | MAG: Candidatus Latescibacterota bacterium isolate bin977 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 20196213 | 20196213 | PRJNA340009_P_NODE_63836_length_166_cov_1.717949_g63529_i0 | PRJNA340009 | 63836 | 166 | 1.717949 | 2.85179534 | Bacteria | 2 | Bacteria | Bacteria | 174 | 2.84e-39 | NTclustered | gi|2518550840|emb|OX638317.1| | 199737 | g63529 | i0 | 85.629 | 264.698795180723 | 167 | 22 | 100 | 2 | 1 | 166 | 3960900 | 3961065 | MAG: uncultured Latescibacteria bacterium isolate cbbe8a84-e08a-4d06-a76e-2eb930d8ff24 genome assembly, chromosome: 1 | blastn | 43940 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 28211488 | 28211488 | PRJNA340009_P_NODE_26226_length_240_cov_273.172775_g25919_i0 | PRJNA340009 | 26226 | 240 | 273.172775 | 655.61466 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 112 | 2.75e-28 | NR | MBT5829377.1 | 2053570 | g25919 | i0 | 69.3 | 0.9375 | 75 | 23 | 93.8 | 0 | 240 | 16 | 209 | 283 | MBT5829377.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Latescibacterota bacterium] | diamond | 225 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 29506179 | 29506179 | PRJNA340009_P_NODE_74570_length_162_cov_0.902655_g74263_i0 | PRJNA340009 | 74570 | 162 | 0.902655 | 1.4623011 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 65.1 | 1.5e-10 | NR | MCC7263500.1 | 2053570 | g74263 | i0 | 55.8 | 0.962962962962963 | 52 | 23 | 96.3 | 0 | 7 | 162 | 220 | 271 | MCC7263500.1 hypothetical protein [Candidatus Latescibacterota bacterium] | diamond | 156 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 29853664 | 29853664 | PRJNA340009_P_NODE_59411_length_170_cov_1.685950_g59104_i0 | PRJNA340009 | 59411 | 170 | 1.68595 | 2.866115 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 62 | 1.96e-9 | NR | MEW6753161.1 | 2053570 | g59104 | i0 | 55.4 | 5.87647058823529 | 56 | 25 | 98.8 | 0 | 3 | 170 | 57 | 112 | MEW6753161.1 site-specific integrase [Candidatus Latescibacterota bacterium] | diamond | 999 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 29965651 | 29965651 | PRJNA340009_P_NODE_79151_length_156_cov_4.728972_g78844_i0 | PRJNA340009 | 79151 | 156 | 4.728972 | 7.37719632 | Bacteria | 2 | Bacteria | Bacteria | 62.4 | 2.64e-10 | NR | RKY69496.1 | 2053570 | g78844 | i0 | 78.9 | 8.75 | 38 | 8 | 73.1 | 0 | 155 | 42 | 34 | 71 | RKY69496.1 MAG: translation initiation factor IF-3 [Candidatus Latescibacterota bacterium] | diamond | 1365 | 62.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 31781353 | 31781353 | PRJNA340009_P_NODE_73117_length_162_cov_1.805310_g72810_i0 | PRJNA340009 | 73117 | 162 | 1.80531 | 2.9246022 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 99 | 4.709999999999999e-23 | NR | MBI4551439.1 | 2053570 | g72810 | i0 | 94.3 | 0.981481481481482 | 53 | 3 | 98.1 | 0 | 161 | 3 | 258 | 310 | MBI4551439.1 hypothetical protein [Candidatus Latescibacterota bacterium] | diamond | 159 | 99 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 32273517 | 32273517 | PRJNA340009_P_NODE_71538_length_163_cov_0.894737_g71231_i0 | PRJNA340009 | 71538 | 163 | 0.894737 | 1.45842131 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 3.84e-6 | NR | MBI4552011.1 | 2053570 | g71231 | i0 | 100 | 0.809815950920245 | 22 | 0 | 40.5 | 0 | 163 | 98 | 39 | 60 | MBI4552011.1 type II toxin-antitoxin system HicA family toxin [Candidatus Latescibacterota bacterium] | diamond | 132 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 32319721 | 32319721 | PRJNA340009_P_NODE_64879_length_166_cov_0.871795_g64572_i0 | PRJNA340009 | 64879 | 166 | 0.871795 | 1.4471797 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 41.2 | 0.0442 | NR | HIE04775.1 | 2053570 | g64572 | i0 | 55.6 | 0.650602409638554 | 36 | 14 | 61.4 | 1 | 104 | 3 | 169 | 204 | HIE04775.1 hypothetical protein [Candidatus Latescibacterota bacterium] | diamond | 108 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota 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);;