contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1035831 | 1035831 | PRJNA1148190_P_NODE_601601_length_250_cov_1.299435_g590428_i0 | PRJNA1148190 | 601601 | 250 | 1.299435 | 3.2485875 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 226 | 1.26e-54 | NTclustered | gi|2874253817|emb|OY969801.1| | 2212470 | g590428 | i0 | 83.265 | 16.084 | 245 | 41 | 98 | 0 | 3 | 247 | 956745 | 956989 | MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 | blastn | 4021 | 228 | 0.991228070175439 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 6676814 | 6676814 | PRJNA1148190_P_NODE_679126_length_246_cov_0.890173_g667953_i0 | PRJNA1148190 | 679126 | 246 | 0.890173 | 2.18982558 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 71.3 | 6.13e-8 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g667953 | i0 | 92.157 | 0.796747967479675 | 51 | 3 | 20 | 1 | 87 | 136 | 246315 | 246365 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 196 | 71.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 7949668 | 7949668 | PRJNA1148190_P_NODE_507407_length_265_cov_1.505208_g496234_i0 | PRJNA1148190 | 507407 | 265 | 1.505208 | 3.9888012 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 148 | 3.0000000000000003e-31 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g496234 | i0 | 80.808 | 27.4528301886792 | 198 | 31 | 74 | 6 | 29 | 223 | 3393722 | 3393915 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 7275 | 148 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 10498724 | 10498724 | PRJNA1148190_P_NODE_392469_length_288_cov_1.083721_g381296_i0 | PRJNA1148190 | 392469 | 288 | 1.083721 | 3.12111648 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 224 | 5.34e-54 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g381296 | i0 | 80.969 | 113.149305555556 | 289 | 50 | 100 | 3 | 1 | 288 | 607474 | 607190 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 32587 | 224 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 15597140 | 15597140 | PRJNA1148190_P_NODE_34013_length_1162_cov_2.606061_g24007_i0 | PRJNA1148190 | 34013 | 1162 | 2.606061 | 30.28242882 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 1005 | 0 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g24007 | i0 | 85.655 | 80.2065404475043 | 962 | 130 | 82 | 6 | 15 | 972 | 2705441 | 2706398 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 93200 | 1005 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 23249330 | 23249330 | PRJNA1148190_P_NODE_534779_length_260_cov_1.235294_g523606_i0 | PRJNA1148190 | 534779 | 260 | 1.235294 | 3.2117644 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 231 | 2.84e-56 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g523606 | i0 | 84.232 | 67.9346153846154 | 241 | 35 | 92 | 3 | 15 | 253 | 1814006 | 1813767 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 17663 | 231 | 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);;