contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Levyibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3152949 | 3152949 | PRJNA630162_P_NODE_18903_length_427_cov_3.113757_g17391_i0 | PRJNA630162 | 18903 | 427 | 3.113757 | 13.29574239 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 263 | 1.75e-65 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g17391 | i0 | 90.244 | 120.377049180328 | 205 | 15 | 47 | 4 | 223 | 424 | 719516 | 719718 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 51401 | 263 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 3153413 | 3153413 | PRJNA630162_P_NODE_63363_length_222_cov_1.919075_g61840_i0 | PRJNA630162 | 63363 | 222 | 1.919075 | 4.2603465 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 174 | 4.03e-39 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g61840 | i0 | 81.614 | 4.82432432432432 | 223 | 29 | 96 | 10 | 6 | 218 | 719922 | 720142 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 1071 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 6980736 | 6980736 | PRJNA630162_P_NODE_36306_length_297_cov_1.233871_g34783_i0 | PRJNA630162 | 36306 | 297 | 1.233871 | 3.66459687 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 272 | 1.9499999999999993e-68 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g34783 | i0 | 83.784 | 4.23905723905724 | 296 | 39 | 99 | 4 | 5 | 297 | 718313 | 718602 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 1259 | 272 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 6981147 | 6981147 | PRJNA630162_P_NODE_77906_length_204_cov_1.303226_g76383_i0 | PRJNA630162 | 77906 | 204 | 1.303226 | 2.65858104 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 171 | 4.71e-38 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g76383 | i0 | 96.154 | 54.1029411764706 | 104 | 4 | 65 | 0 | 4 | 107 | 719881 | 719778 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 11037 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 9529852 | 9529852 | PRJNA630162_P_NODE_10588_length_588_cov_9.333952_g3436_i1 | PRJNA630162 | 10588 | 588 | 9.333952 | 54.88363776 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 409 | 2.9899999999999997e-109 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g3436 | i1 | 81.453 | 86.3860544217687 | 523 | 76 | 87 | 17 | 3 | 516 | 718483 | 718993 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 50795 | 409 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 12081759 | 12081759 | PRJNA630162_P_NODE_48590_length_253_cov_1.911765_g47067_i0 | PRJNA630162 | 48590 | 253 | 1.911765 | 4.83676545 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 244 | 3.53e-60 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g47067 | i0 | 84.585 | 204.588932806324 | 253 | 31 | 99 | 8 | 1 | 250 | 717514 | 717761 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 51761 | 244 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 13355734 | 13355734 | PRJNA630162_P_NODE_121151_length_174_cov_1.256000_g119628_i0 | PRJNA630162 | 121151 | 174 | 1.256 | 2.18544 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 169 | 1.3899999999999998e-37 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g119628 | i0 | 87.582 | 102.327586206897 | 153 | 10 | 84 | 4 | 7 | 153 | 720344 | 720493 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 17805 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 15905573 | 15905573 | PRJNA630162_P_NODE_83653_length_197_cov_3.533784_g82130_i0 | PRJNA630162 | 83653 | 197 | 3.533784 | 6.96155448 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 180 | 7.499999999999998e-41 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g82130 | i0 | 90.511 | 59.243654822335 | 137 | 11 | 70 | 2 | 56 | 192 | 505056 | 504922 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 11671 | 180 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 18454388 | 18454388 | PRJNA630162_P_NODE_48015_length_254_cov_6.731707_g46492_i0 | PRJNA630162 | 48015 | 254 | 6.731707 | 17.09853578 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 309 | 1.24e-79 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g46492 | i0 | 90.336 | 32.8228346456693 | 238 | 20 | 93 | 3 | 2 | 237 | 718482 | 718718 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 8337 | 309 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 21003850 | 21003850 | PRJNA630162_P_NODE_11277_length_569_cov_2.184615_g9834_i0 | PRJNA630162 | 11277 | 569 | 2.184615 | 12.43045935 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 126 | 3.26e-24 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g9834 | i0 | 86.842 | 23.414762741652 | 114 | 14 | 20 | 1 | 33 | 146 | 718881 | 718993 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 13323 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 21005163 | 21005163 | PRJNA630162_P_NODE_87697_length_193_cov_3.388889_g86174_i0 | PRJNA630162 | 87697 | 193 | 3.388889 | 6.54055577 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 231 | 1.9900000000000002e-56 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g86174 | i0 | 88.889 | 2.32124352331606 | 189 | 20 | 97 | 1 | 6 | 193 | 718560 | 718372 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 448 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 22279470 | 22279470 | PRJNA630162_P_NODE_47518_length_256_cov_2.048309_g45995_i0 | PRJNA630162 | 47518 | 256 | 2.048309 | 5.24367104 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 246 | 9.95e-61 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g45995 | i0 | 84.585 | 487.71484375 | 253 | 33 | 98 | 6 | 1 | 250 | 719176 | 719425 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 124855 | 246 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 24827605 | 24827605 | PRJNA630162_P_NODE_108340_length_180_cov_4.541985_g106817_i0 | PRJNA630162 | 108340 | 180 | 4.541985 | 8.175573 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 172 | 1.1199999999999999e-38 | NTclustered | gi|2874253967|emb|OY970292.1| | 2052151 | g106817 | i0 | 87.097 | 1.20555555555556 | 155 | 17 | 86 | 3 | 2 | 155 | 720156 | 720308 | MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1 | blastn | 217 | 172 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota 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);;