contig_metadata
12 rows where bioproject = "PRJEB43370" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26709912 | 26709912 | PRJEB43370_P_NODE_8921_length_166_cov_0.888889_g8878_i0 | PRJEB43370 | 8921 | 166 | 0.888889 | 1.47555574 | Bacteria | 2 | Bacteria | Bacteria | 41.6 | 0.0329 | NR | MBI4433403.1 | 2053634 | g8878 | i0 | 56.7 | 1.5 | 30 | 13 | 54.2 | 0 | 125 | 36 | 289 | 318 | MBI4433403.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Uhrbacteria bacterium] | diamond | 249 | 42 | 0.990476190476191 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 27412965 | 27412965 | PRJEB43370_P_NODE_1923_length_314_cov_1.347170_g1880_i0 | PRJEB43370 | 1923 | 314 | 1.34717 | 4.2301138 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 46.6 | 0.00388 | NR | MCC7436249.1 | 2052152 | g1880 | i0 | 39.5 | 0.821656050955414 | 86 | 43 | 74.5 | 3 | 8 | 241 | 1015 | 1099 | MCC7436249.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 258 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 28359784 | 28359784 | PRJEB43370_P_NODE_5686_length_191_cov_1.380282_g5643_i0 | PRJEB43370 | 5686 | 191 | 1.380282 | 2.63633862 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 44.7 | 0.00395 | NR | NNF07904.1 | 2212470 | g5643 | i0 | 40.3 | 0.973821989528796 | 62 | 30 | 95.8 | 2 | 189 | 7 | 411 | 466 | NNF07904.1 choice-of-anchor B family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 186 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30721796 | 30721796 | PRJEB43370_P_NODE_9314_length_165_cov_0.896552_g9271_i0 | PRJEB43370 | 9314 | 165 | 0.896552 | 1.4793108 | Bacteria | 2 | Bacteria | Bacteria | 82.4 | 1.34e-16 | NR | KPJ49515.1 | 1703771 | g9271 | i0 | 65.5 | 8 | 55 | 19 | 100 | 0 | 165 | 1 | 11 | 65 | KPJ49515.1 MAG: methylmalonyl-CoA carboxyltransferase [candidate division TA06 bacterium DG_26] | diamond | 1320 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | candidate division TA06 bacterium DG_26 | |||||||
| 30886571 | 30886571 | PRJEB43370_P_NODE_7934_length_168_cov_0.873950_g7891_i0 | PRJEB43370 | 7934 | 168 | 0.87395 | 1.468236 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 55.1 | 5.93e-7 | NR | MDD4319423.1 | 2735830 | g7891 | i0 | 52.4 | 1.57142857142857 | 42 | 18 | 71.4 | 1 | 121 | 2 | 347 | 388 | MDD4319423.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 264 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 31107572 | 31107572 | PRJEB43370_P_NODE_8915_length_166_cov_0.888889_g8872_i0 | PRJEB43370 | 8915 | 166 | 0.888889 | 1.47555574 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 91.3 | 7.12e-20 | NR | MDF2378969.1 | 2044595 | g8872 | i0 | 69.1 | 0.993975903614458 | 55 | 17 | 99.4 | 0 | 165 | 1 | 59 | 113 | MDF2378969.1 adenylosuccinate synthase [Candidatus Altimarinota bacterium] | diamond | 165 | 91.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31740043 | 31740043 | PRJEB43370_P_NODE_8917_length_166_cov_0.888889_g8874_i0 | PRJEB43370 | 8917 | 166 | 0.888889 | 1.47555574 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 75.9 | 2.65e-14 | NR | MCX7000201.1 | 2107588 | g8874 | i0 | 64.7 | 4.69879518072289 | 51 | 16 | 92.2 | 1 | 158 | 6 | 527 | 575 | MCX7000201.1 NAD-glutamate dehydrogenase [Candidatus Sumerlaeota bacterium] | diamond | 780 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 31898379 | 31898379 | PRJEB43370_P_NODE_4697_length_207_cov_1.398734_g4654_i0 | PRJEB43370 | 4697 | 207 | 1.398734 | 2.89537938 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 48.1 | 3.41e-5 | NR | RTL06915.1 | 2030827 | g4654 | i0 | 66.7 | 0.434782608695652 | 30 | 10 | 43.5 | 0 | 92 | 3 | 36 | 65 | RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium] | diamond | 90 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 32239999 | 32239999 | PRJEB43370_P_NODE_6678_length_178_cov_0.930233_g6635_i0 | PRJEB43370 | 6678 | 178 | 0.930233 | 1.65581474 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 49.7 | 5.35e-5 | NR | MAQ77375.1 | 2026716 | g6635 | i0 | 66.7 | 1.01123595505618 | 30 | 10 | 50.6 | 0 | 81 | 170 | 6 | 35 | MAQ77375.1 F0F1 ATP synthase subunit beta [Candidatus Campbellbacteria bacterium] | diamond | 180 | 50.1 | 0.992015968063872 | Bacteria | Bacteria candidate phyla | Candidatus Campbelliibacteriota | Candidatus Campbellbacteria bacterium | ||||||
| 32751748 | 32751748 | PRJEB43370_P_NODE_3020_length_250_cov_1.512438_g2977_i0 | PRJEB43370 | 3020 | 250 | 1.512438 | 3.781095 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 46.6 | 3.02e-4 | NR | MCK9467482.1 | 2927939 | g2977 | i0 | 57.9 | 0.456 | 38 | 16 | 45.6 | 0 | 3 | 116 | 54 | 91 | MCK9467482.1 RNA-binding protein [Candidatus Absconditabacterales bacterium] | diamond | 114 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32783069 | 32783069 | PRJEB43370_P_NODE_4940_length_203_cov_1.350649_g4897_i0 | PRJEB43370 | 4940 | 203 | 1.350649 | 2.74181747 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 80.9 | 8.01e-16 | NR | HEY2772621.1 | 2838779 | g4897 | i0 | 64.5 | 0.916256157635468 | 62 | 21 | 90.1 | 1 | 202 | 20 | 297 | 358 | HEY2772621.1 DUF4215 domain-containing protein [Candidatus Binatia bacterium] | diamond | 186 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32877683 | 32877683 | PRJEB43370_P_NODE_5260_length_197_cov_2.087838_g5217_i0 | PRJEB43370 | 5260 | 197 | 2.087838 | 4.11304086 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 77.8 | 8.52e-15 | NR | GIW41541.1 | 2838779 | g5217 | i0 | 58.5 | 0.989847715736041 | 65 | 27 | 99 | 0 | 196 | 2 | 290 | 354 | GIW41541.1 MAG: succinyl-diaminopimelate desuccinylase [Candidatus Binatia bacterium] | diamond | 195 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;