contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 561928 | 561928 | PRJNA577226_S_NODE_38901_length_199_cov_2.530864_g37962_i0 | PRJNA577226 | 38901 | 199 | 2.530864 | 5.03641936 | Candidatus Sumerlaea chitinivorans | 2250252 | Bacteria | Bacteria | 211 | 2.69e-50 | NTclustered | gi|1419285073|gb|CP030759.1| | 2250252 | g37962 | i0 | 86.667 | 248.321608040201 | 195 | 20 | 96 | 6 | 1 | 192 | 163311 | 163120 | Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome | blastn | 49416 | 211 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaea | Candidatus Sumerlaea chitinivorans | ||
| 3112209 | 3112209 | PRJNA577226_S_NODE_20983_length_276_cov_3.004184_g20044_i0 | PRJNA577226 | 20983 | 276 | 3.004184 | 8.29154784 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 324 | 4.87e-84 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g20044 | i0 | 88.764 | 109.974637681159 | 267 | 27 | 96 | 3 | 2 | 266 | 1425432 | 1425697 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 30353 | 324 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 4389103 | 4389103 | PRJNA577226_S_NODE_2964_length_924_cov_17.997745_g2165_i0 | PRJNA577226 | 2964 | 924 | 17.997745 | 166.2991638 | Vermiphilus pyriformis | 1763547 | Bacteria | Bacteria | 1535 | 0 | NTclustered | gi|2207817285|gb|CP074345.1| | 1763547 | g2165 | i0 | 96.75 | 70.3279220779221 | 923 | 26 | 99 | 4 | 3 | 924 | 974808 | 973889 | MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome | blastn | 64983 | 1535 | 1 | Bacteria | Bacteria candidate phyla | Vermiphilus | Vermiphilus pyriformis | ||||||
| 4389706 | 4389706 | PRJNA577226_S_NODE_52024_length_173_cov_1.720588_g51085_i0 | PRJNA577226 | 52024 | 173 | 1.720588 | 2.97661724 | candidate division WWE3 bacterium CSP1-7 | 1576480 | Bacteria | Bacteria | 115 | 1.8300000000000003e-21 | NTclustered | gi|729058634|gb|KM985816.1| | 1576480 | g51085 | i0 | 79.878 | 0.947976878612717 | 164 | 28 | 93 | 5 | 1 | 161 | 127797 | 127636 | Uncultured bacterium CSP1-7 CD WWE3 genomic sequence | blastn | 164 | 115 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium CSP1-7 | ||||||
| 4389753 | 4389753 | PRJNA577226_S_NODE_53764_length_170_cov_2.894737_g52825_i0 | PRJNA577226 | 53764 | 170 | 2.894737 | 4.9210529 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 254 | 3.63e-63 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g52825 | i0 | 93.529 | 60.9294117647059 | 170 | 11 | 100 | 0 | 1 | 170 | 4158280 | 4158449 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 10358 | 254 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 5665521 | 5665521 | PRJNA577226_S_NODE_36745_length_205_cov_1.958333_g35806_i0 | PRJNA577226 | 36745 | 205 | 1.958333 | 4.01458265 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 346 | 7.33e-91 | NTclustered | gi|2306681518|gb|CP075337.1| | 2980174 | g35806 | i0 | 97.073 | 119.468292682927 | 205 | 6 | 100 | 0 | 1 | 205 | 667673 | 667469 | Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome | blastn | 24491 | 346 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 6940701 | 6940701 | PRJNA577226_S_NODE_64046_length_157_cov_2.525000_g63107_i0 | PRJNA577226 | 64046 | 157 | 2.525 | 3.96425 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 193 | 7.32e-45 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g63107 | i0 | 89.032 | 4.29936305732484 | 155 | 17 | 99 | 0 | 1 | 155 | 4159305 | 4159459 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 675 | 193 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 8214681 | 8214681 | PRJNA577226_S_NODE_27767_length_237_cov_3.310000_g26828_i0 | PRJNA577226 | 27767 | 237 | 3.31 | 7.8447 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 100 | 7.49e-17 | NTclustered | gi|2556887672|gb|CP129474.1| | 2053589 | g26828 | i0 | 89.744 | 3.87763713080169 | 78 | 8 | 33 | 0 | 150 | 227 | 274741 | 274664 | MAG: Candidatus Paceibacterota bacterium isolate cMAG.22 chromosome, complete genome | blastn | 919 | 100 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 8789919 | 8789919 | PRJNA577226_S_NODE_12587_length_366_cov_1.747720_g11648_i0 | PRJNA577226 | 12587 | 366 | 1.74772 | 6.3966552 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 660 | 0 | NTclustered | gi|1842053267|gb|CP039998.1| | 713059 | g11648 | i0 | 99.18 | 74.5846994535519 | 366 | 3 | 100 | 0 | 1 | 366 | 147114 | 146749 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome | blastn | 27298 | 660 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 14590370 | 14590370 | PRJNA577226_S_NODE_26892_length_241_cov_2.602941_g25953_i0 | PRJNA577226 | 26892 | 241 | 2.602941 | 6.27308781 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 396 | 8.7e-106 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g25953 | i0 | 96.266 | 189.091286307054 | 241 | 9 | 100 | 0 | 1 | 241 | 4159072 | 4158832 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 45571 | 396 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 14591290 | 14591290 | PRJNA577226_S_NODE_6152_length_554_cov_15.441006_g5230_i0 | PRJNA577226 | 6152 | 554 | 15.441006 | 85.54317324 | Vermiphilus pyriformis | 1763547 | Bacteria | Bacteria | 1002 | 0 | NTclustered | gi|2207817285|gb|CP074345.1| | 1763547 | g5230 | i0 | 99.281 | 177.684115523466 | 556 | 1 | 100 | 2 | 1 | 554 | 973829 | 973275 | MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome | blastn | 98437 | 1002 | 1 | Bacteria | Bacteria candidate phyla | Vermiphilus | Vermiphilus pyriformis | ||||||
| 16440380 | 16440380 | PRJNA577226_S_NODE_67113_length_154_cov_2.136752_g66174_i0 | PRJNA577226 | 67113 | 154 | 2.136752 | 3.29059808 | Bacteria | 2 | Bacteria | Bacteria | 230 | 5.439999999999998e-56 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g66174 | i0 | 94.631 | 60.5844155844156 | 149 | 7 | 97 | 1 | 6 | 154 | 963524 | 963377 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 9330 | 231 | 0.995670995670996 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 17139430 | 17139430 | PRJNA577226_S_NODE_36014_length_207_cov_2.858824_g35075_i0 | PRJNA577226 | 36014 | 207 | 2.858824 | 5.91776568 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 337 | 4.469999999999999e-88 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g35075 | i0 | 96.117 | 229.251207729469 | 206 | 8 | 99 | 0 | 2 | 207 | 4155724 | 4155929 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 47455 | 337 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 18414609 | 18414609 | PRJNA577226_S_NODE_7035_length_511_cov_9.523207_g6107_i0 | PRJNA577226 | 7035 | 511 | 9.523207 | 48.66358777 | Vermiphilus pyriformis | 1763547 | Bacteria | Bacteria | 939 | 0 | NTclustered | gi|2207817285|gb|CP074345.1| | 1763547 | g6107 | i0 | 99.804 | 67.5381604696673 | 511 | 1 | 100 | 0 | 1 | 511 | 973309 | 972799 | MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome | blastn | 34512 | 939 | 1 | Bacteria | Bacteria candidate phyla | Vermiphilus | Vermiphilus pyriformis | ||||||
| 23514758 | 23514758 | PRJNA577226_S_NODE_56999_length_166_cov_1.209302_g56060_i0 | PRJNA577226 | 56999 | 166 | 1.209302 | 2.00744132 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 220 | 3.6e-53 | NTclustered | gi|1958097300|gb|CP065004.1| | 2282149 | g56060 | i0 | 93.289 | 4.52409638554217 | 149 | 10 | 90 | 0 | 1 | 149 | 1104355 | 1104503 | MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome | blastn | 751 | 220 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 24788019 | 24788019 | PRJNA577226_S_NODE_38840_length_199_cov_28.154321_g37901_i0 | PRJNA577226 | 38840 | 199 | 28.154321 | 56.02709879 | Candidatus Sumerlaea chitinivorans | 2250252 | Bacteria | Bacteria | 147 | 7.699999999999999e-31 | NTclustered | gi|1419285073|gb|CP030759.1| | 2250252 | g37901 | i0 | 81.183 | 111.763819095477 | 186 | 32 | 93 | 3 | 9 | 194 | 163320 | 163138 | Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome | blastn | 22241 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaea | Candidatus Sumerlaea chitinivorans |
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);;