contig_metadata
7 rows where bioproject = "PRJNA1196438" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27040912 | 27040912 | PRJNA1196438_P_NODE_6502_length_396_cov_4.470588_g6080_i0 | PRJNA1196438 | 6502 | 396 | 4.470588 | 17.70352848 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 92.8 | 1.27e-19 | NR | MBP7806621.1 | 2044595 | g6080 | i0 | 51.2 | 0.621212121212121 | 82 | 39 | 61.4 | 1 | 42 | 284 | 6 | 87 | MBP7806621.1 sortase [Candidatus Altimarinota bacterium] | diamond | 246 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27451920 | 27451920 | PRJNA1196438_P_NODE_35543_length_296_cov_1.399103_g35117_i0 | PRJNA1196438 | 35543 | 296 | 1.399103 | 4.14134488 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 148 | 6.86e-40 | NR | MBP6921263.1 | 2044595 | g35117 | i0 | 78.6 | 0.993243243243243 | 98 | 21 | 99.3 | 0 | 1 | 294 | 24 | 121 | MBP6921263.1 oligosaccharide flippase family protein [Candidatus Altimarinota bacterium] | diamond | 294 | 148 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27514890 | 27514890 | PRJNA1196438_P_NODE_77603_length_239_cov_2.626506_g77176_i0 | PRJNA1196438 | 77603 | 239 | 2.626506 | 6.27734934 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 77.8 | 7.85e-15 | NR | MBP6920950.1 | 2044595 | g77176 | i0 | 65.5 | 1.38075313807531 | 55 | 19 | 69 | 0 | 239 | 75 | 87 | 141 | MBP6920950.1 tRNA lysidine(34) synthetase TilS [Candidatus Altimarinota bacterium] | diamond | 330 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28020212 | 28020212 | PRJNA1196438_P_NODE_7165_length_382_cov_3.090615_g6743_i0 | PRJNA1196438 | 7165 | 382 | 3.090615 | 11.8061493 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 84.3 | 4.47e-16 | NR | MBP7806843.1 | 2044595 | g6743 | i0 | 52.9 | 1.06806282722513 | 68 | 32 | 53.4 | 0 | 346 | 143 | 419 | 486 | MBP7806843.1 cysteine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 408 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28746229 | 28746229 | PRJNA1196438_P_NODE_49947_length_273_cov_2.105000_g49520_i0 | PRJNA1196438 | 49947 | 273 | 2.105 | 5.74665 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 119 | 1.7199999999999998e-32 | NR | MDP2103477.1 | 2044595 | g49520 | i0 | 64.3 | 0.923076923076923 | 84 | 30 | 92.3 | 0 | 8 | 259 | 1 | 84 | MDP2103477.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 252 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30925817 | 30925817 | PRJNA1196438_P_NODE_79554_length_235_cov_2.395062_g79127_i0 | PRJNA1196438 | 79554 | 235 | 2.395062 | 5.6283957 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 54.3 | 2.82e-6 | NR | MBP7806545.1 | 2044595 | g79127 | i0 | 46.6 | 0.740425531914894 | 58 | 31 | 74 | 0 | 4 | 177 | 387 | 444 | MBP7806545.1 AAA family ATPase [Candidatus Altimarinota bacterium] | diamond | 174 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31621071 | 31621071 | PRJNA1196438_P_NODE_9096_length_348_cov_3.098182_g8672_i0 | PRJNA1196438 | 9096 | 348 | 3.098182 | 10.78167336 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 75.1 | 3.22e-13 | NR | MBP6921059.1 | 2044595 | g8672 | i0 | 87.5 | 0.344827586206897 | 40 | 5 | 34.5 | 0 | 1 | 120 | 264 | 303 | MBP6921059.1 transketolase family protein [Candidatus Altimarinota bacterium] | diamond | 120 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;