contig_metadata
10 rows where bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26879602 | 26879602 | PRJNA1120060_P_NODE_2767321_length_247_cov_0.890805_g2749237_i0 | PRJNA1120060 | 2767321 | 247 | 0.890805 | 2.20028835 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 44.7 | 0.00798 | NR | MFT5365747.1 | 2053570 | g2749237 | i0 | 38.6 | 0.692307692307692 | 57 | 32 | 65.6 | 1 | 216 | 55 | 216 | 272 | MFT5365747.1 molecular chaperone DnaJ [Candidatus Latescibacterota bacterium] | diamond | 171 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 28458496 | 28458496 | PRJNA1120060_P_NODE_2010266_length_272_cov_2.608040_g1992233_i0 | PRJNA1120060 | 2010266 | 272 | 2.60804 | 7.0938688 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 43.5 | 0.027 | NR | MFT5365747.1 | 2053570 | g1992233 | i0 | 35.9 | 0.705882352941177 | 64 | 36 | 67.3 | 2 | 9 | 191 | 212 | 273 | MFT5365747.1 molecular chaperone DnaJ [Candidatus Latescibacterota bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 28774252 | 28774252 | PRJNA1120060_P_NODE_2510307_length_253_cov_3.444444_g2492235_i0 | PRJNA1120060 | 2510307 | 253 | 3.444444 | 8.71444332 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 43.9 | 0.0154 | NR | MBT3606604.1 | 2053570 | g2492235 | i0 | 47.7 | 0.521739130434783 | 44 | 23 | 52.2 | 0 | 167 | 36 | 96 | 139 | MBT3606604.1 glycosyltransferase family 4 protein [Candidatus Latescibacterota bacterium] | diamond | 132 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 28900598 | 28900598 | PRJNA1120060_P_NODE_2607708_length_251_cov_0.865169_g2589631_i0 | PRJNA1120060 | 2607708 | 251 | 0.865169 | 2.17157419 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 46.2 | 8.21e-4 | NR | MDP6124978.1 | 2053570 | g2589631 | i0 | 35.4 | 1.94820717131474 | 82 | 46 | 98 | 1 | 5 | 250 | 54 | 128 | MDP6124978.1 ribonuclease HI family protein [Candidatus Latescibacterota bacterium] | diamond | 489 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 30195892 | 30195892 | PRJNA1120060_P_NODE_3560272_length_202_cov_4.302326_g3542145_i0 | PRJNA1120060 | 3560272 | 202 | 4.302326 | 8.69069852 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 43.5 | 0.0116 | NR | MFT5365747.1 | 2053570 | g3542145 | i0 | 33.3 | 0.935643564356436 | 63 | 39 | 89.1 | 1 | 20 | 199 | 216 | 278 | MFT5365747.1 molecular chaperone DnaJ [Candidatus Latescibacterota bacterium] | diamond | 189 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 30448921 | 30448921 | PRJNA1120060_P_NODE_3246013_length_229_cov_3.564103_g3227906_i0 | PRJNA1120060 | 3246013 | 229 | 3.564103 | 8.16179587 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 44.3 | 0.00875 | NR | MFT5365747.1 | 2053570 | g3227906 | i0 | 39.2 | 1.33624454148472 | 51 | 28 | 62.9 | 1 | 83 | 226 | 216 | 266 | MFT5365747.1 molecular chaperone DnaJ [Candidatus Latescibacterota bacterium] | diamond | 306 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 30795660 | 30795660 | PRJNA1120060_P_NODE_2458654_length_255_cov_2.719780_g2440584_i0 | PRJNA1120060 | 2458654 | 255 | 2.71978 | 6.935439 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 43.1 | 0.0325 | NR | MBT4140225.1 | 2053570 | g2440584 | i0 | 40.6 | 1.50588235294118 | 64 | 35 | 71.8 | 1 | 243 | 61 | 460 | 523 | MBT4140225.1 hypothetical protein [Candidatus Latescibacterota bacterium] | diamond | 384 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 31016812 | 31016812 | PRJNA1120060_P_NODE_2298735_length_261_cov_2.186170_g2280676_i0 | PRJNA1120060 | 2298735 | 261 | 2.18617 | 5.7059037 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 42.7 | 0.0456 | NR | MDP6778530.1 | 2053570 | g2280676 | i0 | 40.7 | 0.620689655172414 | 54 | 29 | 58.6 | 1 | 259 | 107 | 106 | 159 | MDP6778530.1 MBL fold metallo-hydrolase [Candidatus Latescibacterota bacterium] | diamond | 162 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 31744032 | 31744032 | PRJNA1120060_P_NODE_2443337_length_256_cov_1.387978_g2425268_i0 | PRJNA1120060 | 2443337 | 256 | 1.387978 | 3.55322368 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 43.5 | 0.0143 | NR | MBT4136829.1 | 2053570 | g2425268 | i0 | 34.7 | 1.78125 | 72 | 47 | 84.4 | 0 | 5 | 220 | 57 | 128 | MBT4136829.1 ribonuclease HI family protein [Candidatus Latescibacterota bacterium] | diamond | 456 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 32881271 | 32881271 | PRJNA1120060_P_NODE_2042880_length_271_cov_1.570707_g2024843_i0 | PRJNA1120060 | 2042880 | 271 | 1.570707 | 4.25661597 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 45.1 | 0.00798 | NR | MFA6110589.1 | 2053570 | g2024843 | i0 | 29.4 | 0.940959409594096 | 85 | 53 | 86.3 | 2 | 234 | 1 | 230 | 314 | MFA6110589.1 M14 family zinc carboxypeptidase [Candidatus Latescibacterota bacterium] | diamond | 255 | 45.1 | 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);;