contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16067828 | 16067828 | PRJNA784298_P_NODE_20753_length_270_cov_2.385787_g20552_i0 | PRJNA784298 | 20753 | 270 | 2.385787 | 6.4416249 | Bacteria | 2 | Bacteria | Bacteria | 134 | 6.86e-36 | NR | MBF0932399.1 | 2044938 | g20552 | i0 | 68.5 | 11.8666666666667 | 89 | 26 | 98.9 | 1 | 2 | 268 | 89 | 175 | MBF0932399.1 acetate kinase [candidate division SR1 bacterium] | diamond | 3204 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 26705206 | 26705206 | PRJNA784298_P_NODE_19501_length_280_cov_1.222222_g19300_i0 | PRJNA784298 | 19501 | 280 | 1.222222 | 3.4222216 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 73.9 | 6.31e-13 | NR | AHB41379.1 | 1394709 | g19300 | i0 | 47.7 | 1.88571428571429 | 88 | 43 | 91.1 | 2 | 275 | 21 | 964 | 1051 | AHB41379.1 hypothetical protein P148_SR1C00001G0588 [candidate division SR1 bacterium RAAC1_SR1_1] | diamond | 528 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 26958512 | 26958512 | PRJNA784298_P_NODE_3962_length_640_cov_1.654321_g3765_i0 | PRJNA784298 | 3962 | 640 | 1.654321 | 10.5876544 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 176 | 2.68e-48 | NR | MDD3262620.1 | 3018262 | g3765 | i0 | 64.9 | 0.628125 | 134 | 47 | 62.8 | 0 | 237 | 638 | 398 | 531 | MDD3262620.1 TaqI-like C-terminal specificity domain-containing protein [Candidatus Absconditabacteria bacterium] | diamond | 402 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria bacterium | ||||||
| 29327215 | 29327215 | PRJNA784298_P_NODE_17129_length_299_cov_3.261062_g16928_i0 | PRJNA784298 | 17129 | 299 | 3.261062 | 9.75057538 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 100 | 9.21e-23 | NR | PZM87108.1 | 2044938 | g16928 | i0 | 51.6 | 1.87625418060201 | 93 | 41 | 93.3 | 1 | 10 | 288 | 256 | 344 | PZM87108.1 MAG: hypothetical protein DLD55_03160 [candidate division SR1 bacterium] | diamond | 561 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 29453282 | 29453282 | PRJNA784298_P_NODE_3030_length_733_cov_7.150000_g2841_i0 | PRJNA784298 | 3030 | 733 | 7.15 | 52.4095 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 55.1 | 3.13e-5 | NR | WP_231176162.1 | 2735562 | g2841 | i0 | 20.4 | 0.961800818553888 | 235 | 132 | 94.1 | 6 | 43 | 732 | 6 | 190 | WP_231176162.1 hypothetical protein [Candidatus Absconditicoccus praedator] | diamond | 705 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator | |||
| 29958836 | 29958836 | PRJNA784298_P_NODE_19031_length_283_cov_3.823810_g18830_i0 | PRJNA784298 | 19031 | 283 | 3.82381 | 10.8213823 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 51.6 | 4.25e-5 | NR | MFA6256511.1 | 2927939 | g18830 | i0 | 46.3 | 0.57243816254417 | 54 | 29 | 57.2 | 0 | 6 | 167 | 297 | 350 | MFA6256511.1 MFS transporter [Candidatus Absconditabacterales bacterium] | diamond | 162 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 30906909 | 30906909 | PRJNA784298_P_NODE_11614_length_367_cov_3.993197_g11413_i0 | PRJNA784298 | 11614 | 367 | 3.993197 | 14.65503299 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 44.3 | 0.0348 | NR | MEF2175811.1 | 3018262 | g11413 | i0 | 29.8 | 1.01362397820163 | 124 | 65 | 98.1 | 3 | 5 | 364 | 86 | 191 | MEF2175811.1 hypothetical protein [Candidatus Absconditabacteria bacterium] | diamond | 372 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria bacterium | ||||||
| 31285844 | 31285844 | PRJNA784298_P_NODE_9335_length_411_cov_27.047337_g9134_i0 | PRJNA784298 | 9335 | 411 | 27.047337 | 111.16455507 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 53.9 | 4.98e-6 | NR | WP_231176587.1 | 2735562 | g9134 | i0 | 42 | 0.591240875912409 | 81 | 46 | 58.4 | 1 | 321 | 82 | 23 | 103 | WP_231176587.1 hypothetical protein [Candidatus Absconditicoccus praedator] | diamond | 243 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator | |||
| 31633811 | 31633811 | PRJNA784298_P_NODE_26636_length_241_cov_3.273810_g26435_i0 | PRJNA784298 | 26636 | 241 | 3.27381 | 7.8898821 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 80.9 | 1.36e-15 | NR | AKH33301.1 | 1643353 | g26435 | i0 | 60 | 2.5643153526971 | 70 | 24 | 87.1 | 2 | 240 | 31 | 138 | 203 | AKH33301.1 DNA gyrase subunit B [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 618 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 32045175 | 32045175 | PRJNA784298_P_NODE_15618_length_315_cov_0.954545_g15417_i0 | PRJNA784298 | 15618 | 315 | 0.954545 | 3.00681675 | SR1 bacterium human oral taxon HOT-345 | 1540874 | Bacteria | Bacteria | 54.7 | 3.41e-6 | NR | RAL56874.1 | 1540874 | g15417 | i0 | 67.6 | 1.76190476190476 | 37 | 12 | 35.2 | 0 | 203 | 313 | 1 | 37 | RAL56874.1 Fe-S cluster assembly ATPase SufC [SR1 bacterium human oral taxon HOT-345] | diamond | 555 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | SR1 bacterium human oral taxon HOT-345 | ||||||
| 32266844 | 32266844 | PRJNA784298_P_NODE_5298_length_549_cov_2.126050_g5099_i0 | PRJNA784298 | 5298 | 549 | 2.12605 | 11.6720145 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 94.4 | 9.04e-19 | NR | GHW02858.1 | 2044938 | g5099 | i0 | 45.6 | 1.25136612021858 | 114 | 61 | 62.3 | 1 | 345 | 4 | 79 | 191 | GHW02858.1 N-6 DNA methylase [candidate division SR1 bacterium] | diamond | 687 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 32708817 | 32708817 | PRJNA784298_P_NODE_26680_length_241_cov_2.053571_g26479_i0 | PRJNA784298 | 26680 | 241 | 2.053571 | 4.94910611 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 90.1 | 7.64e-19 | NR | MDD3263194.1 | 3018262 | g26479 | i0 | 56.3 | 4.41908713692946 | 71 | 31 | 88.4 | 0 | 1 | 213 | 83 | 153 | MDD3263194.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Absconditabacteria bacterium] | diamond | 1065 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria 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);;