contig_metadata
11 rows where bioproject = "PRJNA983848", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20094198 | 20094198 | PRJNA983848_P_NODE_147036_length_248_cov_1.508571_g141153_i0 | PRJNA983848 | 147036 | 248 | 1.508571 | 3.74125608 | Geothrix sp. 21YS21S-2 | 3068893 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2566094019|gb|CP132910.1| | 3068893 | g141153 | i0 | 100 | 0.116935483870968 | 29 | 0 | 12 | 0 | 107 | 135 | 2203607 | 2203635 | Geothrix sp. 21YS21S-2 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. 21YS21S-2 | ||
| 26646211 | 26646211 | PRJNA983848_P_NODE_131241_length_260_cov_1.593583_g125358_i0 | PRJNA983848 | 131241 | 260 | 1.593583 | 4.1433158 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 47.8 | 3.31e-4 | NR | HEY2945801.1 | 2793154 | g125358 | i0 | 46.8 | 0.542307692307692 | 47 | 25 | 54.2 | 0 | 85 | 225 | 13 | 59 | HEY2945801.1 acyl-CoA dehydrogenase family protein [Vicinamibacteria bacterium] | diamond | 141 | 47.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 28068624 | 28068624 | PRJNA983848_P_NODE_122465_length_270_cov_1.959391_g116582_i0 | PRJNA983848 | 122465 | 270 | 1.959391 | 5.2903557 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0497 | NR | MCL4524571.1 | 1978231 | g116582 | i0 | 39.3 | 0.677777777777778 | 61 | 34 | 67.8 | 2 | 62 | 244 | 183 | 240 | MCL4524571.1 ATP-binding protein [Acidobacteriota bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28289524 | 28289524 | PRJNA983848_P_NODE_155866_length_244_cov_0.912281_g149983_i0 | PRJNA983848 | 155866 | 244 | 0.912281 | 2.22596564 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 147 | 4.25e-40 | NR | MBK7391840.1 | 2099375 | g149983 | i0 | 82.5 | 2.93852459016393 | 80 | 14 | 98.4 | 0 | 242 | 3 | 356 | 435 | MBK7391840.1 glutamate--tRNA ligase [Chloracidobacterium sp.] | diamond | 717 | 147 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 30026478 | 30026478 | PRJNA983848_P_NODE_140431_length_252_cov_0.871508_g134548_i0 | PRJNA983848 | 140431 | 252 | 0.871508 | 2.19620016 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 60.8 | 1.08e-8 | NR | HVG86686.1 | 2910147 | g134548 | i0 | 67.3 | 1.30952380952381 | 55 | 14 | 61.9 | 2 | 156 | 1 | 200 | 253 | HVG86686.1 cytochrome c3 family protein [Vicinamibacterales bacterium] | diamond | 330 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30342833 | 30342833 | PRJNA983848_P_NODE_156372_length_244_cov_0.912281_g150489_i0 | PRJNA983848 | 156372 | 244 | 0.912281 | 2.22596564 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 145 | 4.019999999999999e-40 | NR | MBM3737160.1 | 1978231 | g150489 | i0 | 85.2 | 0.995901639344262 | 81 | 12 | 99.6 | 0 | 1 | 243 | 134 | 214 | MBM3737160.1 Ldh family oxidoreductase [Acidobacteriota bacterium] | diamond | 243 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30658250 | 30658250 | PRJNA983848_P_NODE_114113_length_281_cov_1.658654_g108230_i0 | PRJNA983848 | 114113 | 281 | 1.658654 | 4.66081774 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 48.5 | 5.55e-4 | NR | HXJ94687.1 | 2081523 | g108230 | i0 | 38.6 | 0.608540925266904 | 57 | 35 | 60.9 | 0 | 279 | 109 | 494 | 550 | HXJ94687.1 reverse transcriptase domain-containing protein [Terriglobia bacterium] | diamond | 171 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 32176226 | 32176226 | PRJNA983848_P_NODE_149298_length_247_cov_0.896552_g143415_i0 | PRJNA983848 | 149298 | 247 | 0.896552 | 2.21448344 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.00574 | NR | MXY25396.1 | 1978231 | g143415 | i0 | 51.2 | 0.522267206477733 | 43 | 19 | 49.8 | 1 | 246 | 124 | 225 | 267 | MXY25396.1 dTDP-glucose 4,6-dehydratase [Acidobacteriota bacterium] | diamond | 129 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32618677 | 32618677 | PRJNA983848_P_NODE_111020_length_285_cov_2.273585_g105137_i0 | PRJNA983848 | 111020 | 285 | 2.273585 | 6.47971725 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.0329 | NR | MBI4874027.1 | 1978231 | g105137 | i0 | 34.5 | 0.610526315789474 | 58 | 35 | 57.9 | 1 | 251 | 87 | 777 | 834 | MBI4874027.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 174 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32776068 | 32776068 | PRJNA983848_P_NODE_158040_length_243_cov_0.917647_g152157_i0 | PRJNA983848 | 158040 | 243 | 0.917647 | 2.22988221 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 62 | 4.84e-9 | NR | HQU84504.1 | 2283092 | g152157 | i0 | 39.7 | 0.962962962962963 | 78 | 47 | 96.3 | 0 | 236 | 3 | 104 | 181 | HQU84504.1 TSUP family transporter [Pyrinomonadaceae bacterium] | diamond | 234 | 62 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32807578 | 32807578 | PRJNA983848_P_NODE_132840_length_258_cov_1.686486_g126957_i0 | PRJNA983848 | 132840 | 258 | 1.686486 | 4.35113388 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 40.8 | 0.0339 | NR | HEX3942023.1 | 2052142 | g126957 | i0 | 40.8 | 0.569767441860465 | 49 | 29 | 57 | 0 | 3 | 149 | 3 | 51 | HEX3942023.1 type II toxin-antitoxin system YafQ family toxin [Acidobacteriaceae bacterium] | diamond | 147 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae 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);;