contig_metadata
10 rows where bioproject = "PRJNA944406" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924125 | 924125 | PRJNA944406_P_NODE_107681_length_241_cov_0.916667_g106722_i0 | PRJNA944406 | 107681 | 241 | 0.916667 | 2.20916747 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 183 | 7.369999999999998e-42 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g106722 | i0 | 80.498 | 72.6473029045643 | 241 | 45 | 99 | 2 | 1 | 240 | 738167 | 738406 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 17508 | 183 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 7637453 | 7637453 | PRJNA944406_P_NODE_17726_length_310_cov_2.421941_g16767_i0 | PRJNA944406 | 17726 | 310 | 2.421941 | 7.5080171 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 82 | 6.95e-16 | NR | MEP7027059.1 | 2212470 | g16767 | i0 | 86 | 0.483870967741935 | 50 | 7 | 48.4 | 0 | 310 | 161 | 249 | 298 | MEP7027059.1 aldo/keto reductase [Candidatus Eiseniibacteriota bacterium] | diamond | 150 | 82 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 17502356 | 17502356 | PRJNA944406_P_NODE_109494_length_241_cov_0.916667_g108535_i0 | PRJNA944406 | 109494 | 241 | 0.916667 | 2.20916747 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 274 | 4.2499999999999997e-69 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g108535 | i0 | 87.764 | 106.668049792531 | 237 | 25 | 98 | 4 | 7 | 241 | 737550 | 737784 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 25707 | 274 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 18776397 | 18776397 | PRJNA944406_P_NODE_49935_length_263_cov_1.621053_g48976_i0 | PRJNA944406 | 49935 | 263 | 1.621053 | 4.26336939 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 134 | 2.16e-34 | NR | MEO6461763.1 | 2212470 | g48976 | i0 | 78.2 | 1.98479087452471 | 87 | 19 | 99.2 | 0 | 263 | 3 | 305 | 391 | MEO6461763.1 NAD+ synthase [Candidatus Eiseniibacteriota bacterium] | diamond | 522 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 19110983 | 19110983 | PRJNA944406_P_NODE_98015_length_243_cov_1.552941_g97056_i0 | PRJNA944406 | 98015 | 243 | 1.552941 | 3.77364663 | Bacteria | 2 | Bacteria | Bacteria | 200 | 7.39e-47 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g97056 | i0 | 81.641 | 211.069958847737 | 256 | 33 | 100 | 12 | 1 | 243 | 737783 | 737529 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 51290 | 202 | 0.99009900990099 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 28856828 | 28856828 | PRJNA944406_P_NODE_57108_length_256_cov_2.202186_g56149_i0 | PRJNA944406 | 57108 | 256 | 2.202186 | 5.63759616 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 66.6 | 1.69e-10 | NR | HTS07638.1 | 2212470 | g56149 | i0 | 45 | 0.9375 | 80 | 39 | 92.6 | 2 | 238 | 2 | 87 | 162 | HTS07638.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 240 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29456577 | 29456577 | PRJNA944406_P_NODE_56150_length_257_cov_1.673913_g55191_i0 | PRJNA944406 | 56150 | 257 | 1.673913 | 4.30195641 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 53.5 | 4.07e-6 | NR | HET9325670.1 | 2212470 | g55191 | i0 | 65.9 | 0.478599221789883 | 41 | 14 | 47.9 | 0 | 252 | 130 | 165 | 205 | HET9325670.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 123 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30341845 | 30341845 | PRJNA944406_P_NODE_69272_length_250_cov_0.870056_g68313_i0 | PRJNA944406 | 69272 | 250 | 0.870056 | 2.17514 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 166 | 2.11e-48 | NR | HEU5311548.1 | 2212470 | g68313 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 249 | 1 | 215 | 297 | HEU5311548.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Eiseniibacteriota bacterium] | diamond | 249 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31130911 | 31130911 | PRJNA944406_P_NODE_75175_length_249_cov_0.875000_g74216_i0 | PRJNA944406 | 75175 | 249 | 0.875 | 2.17875 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 159 | 1.6299999999999999e-43 | NR | HET9252452.1 | 2212470 | g74216 | i0 | 93.9 | 0.987951807228916 | 82 | 5 | 98.8 | 0 | 248 | 3 | 242 | 323 | HET9252452.1 DNA primase [Candidatus Eiseniibacteriota bacterium] | diamond | 246 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32680420 | 32680420 | PRJNA944406_P_NODE_73080_length_249_cov_0.875000_g72121_i0 | PRJNA944406 | 73080 | 249 | 0.875 | 2.17875 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 51.6 | 3.93e-6 | NR | HET9232769.1 | 2212470 | g72121 | i0 | 72.5 | 0.903614457831325 | 40 | 11 | 48.2 | 0 | 197 | 78 | 61 | 100 | HET9232769.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 225 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;