contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA897077" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873617 | 873617 | PRJNA897077_P_NODE_15221_length_253_cov_0.866667_g15094_i0 | PRJNA897077 | 15221 | 253 | 0.866667 | 2.19266751 | Candidatus Kuenenbacteria bacterium | 2699743 | Bacteria | Bacteria | 124 | 3.19e-31 | NR | MFH1890774.1 | 2699743 | g15094 | i0 | 73.5 | 0.984189723320158 | 83 | 22 | 98.4 | 0 | 3 | 251 | 202 | 284 | MFH1890774.1 ribosome biogenesis GTPase Der [Candidatus Kuenenbacteria bacterium] | diamond | 249 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kueneniibacteriota | Candidatus Kuenenbacteria bacterium | ||||||
| 3424388 | 3424388 | PRJNA897077_P_NODE_15743_length_252_cov_0.871508_g15616_i0 | PRJNA897077 | 15743 | 252 | 0.871508 | 2.19620016 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 160 | 1.16e-45 | NR | HEY6364415.1 | 2838779 | g15616 | i0 | 96.4 | 0.988095238095238 | 83 | 3 | 98.8 | 0 | 250 | 2 | 101 | 183 | HEY6364415.1 hydantoinase/oxoprolinase family protein [Candidatus Binatia bacterium] | diamond | 249 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 3424413 | 3424413 | PRJNA897077_P_NODE_17243_length_248_cov_0.891429_g17116_i0 | PRJNA897077 | 17243 | 248 | 0.891429 | 2.21074392 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 152 | 2.94e-42 | NR | HJQ83281.1 | 2838779 | g17116 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 247 | 2 | 295 | 376 | HJQ83281.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Candidatus Binatia bacterium] | diamond | 246 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 12352553 | 12352553 | PRJNA897077_P_NODE_17530_length_248_cov_0.891429_g17403_i0 | PRJNA897077 | 17530 | 248 | 0.891429 | 2.21074392 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 126 | 1.64e-31 | NR | HSF59085.1 | 2838779 | g17403 | i0 | 86.4 | 1.95967741935484 | 81 | 11 | 98 | 0 | 4 | 246 | 144 | 224 | HSF59085.1 putative monovalent cation/H+ antiporter subunit A [Candidatus Binatia bacterium] | diamond | 486 | 126 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 20000162 | 20000162 | PRJNA897077_P_NODE_14896_length_255_cov_1.708791_g14769_i0 | PRJNA897077 | 14896 | 255 | 1.708791 | 4.35741705 | Bacteria | 2 | Bacteria | Bacteria | 175 | 7.21e-50 | NR | MBI2203486.1 | 2053607 | g14769 | i0 | 89.3 | 7.90588235294118 | 84 | 9 | 98.8 | 0 | 2 | 253 | 80 | 163 | MBI2203486.1 CocE/NonD family hydrolase [Candidatus Rokuibacteriota bacterium] | diamond | 2016 | 175 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 27435201 | 27435201 | PRJNA897077_P_NODE_18703_length_245_cov_0.906977_g18576_i0 | PRJNA897077 | 18703 | 245 | 0.906977 | 2.22209365 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 102 | 4.789999999999999e-23 | NR | HEY7141765.1 | 2072417 | g18576 | i0 | 88.1 | 1.43265306122449 | 59 | 7 | 72.2 | 0 | 243 | 67 | 522 | 580 | HEY7141765.1 M28 family peptidase [Candidatus Methylomirabilota bacterium] | diamond | 351 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27845260 | 27845260 | PRJNA897077_P_NODE_18224_length_246_cov_0.901734_g18097_i0 | PRJNA897077 | 18224 | 246 | 0.901734 | 2.21826564 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 137 | 3.37e-36 | NR | MBD3238847.1 | 2045217 | g18097 | i0 | 79 | 1.97560975609756 | 81 | 17 | 98.8 | 0 | 244 | 2 | 297 | 377 | MBD3238847.1 glycine--tRNA ligase [Candidatus Moraniibacteriota bacterium] | diamond | 486 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 28097940 | 28097940 | PRJNA897077_P_NODE_16925_length_249_cov_0.886364_g16798_i0 | PRJNA897077 | 16925 | 249 | 0.886364 | 2.20704636 | Candidatus Berkelbacteria bacterium | 2053521 | Bacteria | Bacteria | 43.1 | 0.0289 | NR | MCX6810978.1 | 2053521 | g16798 | i0 | 36.1 | 0.867469879518072 | 72 | 41 | 85.5 | 2 | 218 | 6 | 122 | 189 | MCX6810978.1 UvrD-helicase domain-containing protein [Candidatus Berkelbacteria bacterium] | diamond | 216 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Berkelbacteria | Candidatus Berkelbacteria bacterium | ||||||
| 28161355 | 28161355 | PRJNA897077_P_NODE_19165_length_244_cov_0.883041_g19038_i0 | PRJNA897077 | 19165 | 244 | 0.883041 | 2.15462004 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 107 | 1.07e-27 | NR | MBI2593975.1 | 2053542 | g19038 | i0 | 78.8 | 0.811475409836066 | 66 | 14 | 81.1 | 0 | 242 | 45 | 83 | 148 | MBI2593975.1 KH domain-containing protein [Candidatus Daviesbacteria bacterium] | diamond | 198 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 28823937 | 28823937 | PRJNA897077_P_NODE_18248_length_246_cov_0.901734_g18121_i0 | PRJNA897077 | 18248 | 246 | 0.901734 | 2.21826564 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 46.2 | 3.58e-4 | NR | HRN86952.1 | 2099670 | g18121 | i0 | 53.7 | 0.5 | 41 | 19 | 50 | 0 | 3 | 125 | 53 | 93 | HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] | diamond | 123 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 30213538 | 30213538 | PRJNA897077_P_NODE_18972_length_244_cov_0.912281_g18845_i0 | PRJNA897077 | 18972 | 244 | 0.912281 | 2.22596564 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 131 | 3.21e-36 | NR | HEX9662780.1 | 2838779 | g18845 | i0 | 97 | 0.811475409836066 | 66 | 2 | 81.1 | 0 | 45 | 242 | 1 | 66 | HEX9662780.1 ferritin-like domain-containing protein [Candidatus Binatia bacterium] | diamond | 198 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30498102 | 30498102 | PRJNA897077_P_NODE_18313_length_246_cov_0.901734_g18186_i0 | PRJNA897077 | 18313 | 246 | 0.901734 | 2.21826564 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 150 | 6.24e-40 | NR | MEK7533065.1 | 2052139 | g18186 | i0 | 88.8 | 0.975609756097561 | 80 | 9 | 97.6 | 0 | 2 | 241 | 596 | 675 | MEK7533065.1 transglycosylase domain-containing protein [Patescibacteria group bacterium] | diamond | 240 | 150 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31066980 | 31066980 | PRJNA897077_P_NODE_18095_length_246_cov_0.901734_g17968_i0 | PRJNA897077 | 18095 | 246 | 0.901734 | 2.21826564 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 164 | 3e-48 | NR | HEY7559357.1 | 2838779 | g17968 | i0 | 92.6 | 0.98780487804878 | 81 | 6 | 98.8 | 0 | 2 | 244 | 52 | 132 | HEY7559357.1 polysaccharide deacetylase family protein [Candidatus Binatia bacterium] | diamond | 243 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31635885 | 31635885 | PRJNA897077_P_NODE_15676_length_252_cov_0.871508_g15549_i0 | PRJNA897077 | 15676 | 252 | 0.871508 | 2.19620016 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 107 | 4.57e-25 | NR | HEY2389091.1 | 2838779 | g15549 | i0 | 66.7 | 2 | 84 | 26 | 100 | 1 | 1 | 252 | 353 | 434 | HEY2389091.1 sigma-54 dependent transcriptional regulator [Candidatus Binatia bacterium] | diamond | 504 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31730730 | 31730730 | PRJNA897077_P_NODE_16597_length_250_cov_0.881356_g16470_i0 | PRJNA897077 | 16597 | 250 | 0.881356 | 2.20339 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 134 | 1.39e-34 | NR | MEK7650636.1 | 2052139 | g16470 | i0 | 77.1 | 0.996 | 83 | 19 | 99.6 | 0 | 250 | 2 | 403 | 485 | MEK7650636.1 NAD-dependent DNA ligase LigA [Patescibacteria group bacterium] | diamond | 249 | 134 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32490387 | 32490387 | PRJNA897077_P_NODE_17339_length_248_cov_0.891429_g17212_i0 | PRJNA897077 | 17339 | 248 | 0.891429 | 2.21074392 | Candidatus Anderseniibacteriota bacterium | 2053502 | Bacteria | Bacteria | 76.6 | 4.54e-14 | NR | MEX2055195.1 | 2053502 | g17212 | i0 | 65.5 | 1.43951612903226 | 55 | 19 | 66.5 | 0 | 196 | 32 | 208 | 262 | MEX2055195.1 hypothetical protein [Candidatus Andersenbacteria bacterium] | diamond | 357 | 76.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Anderseniibacteriota | Candidatus Anderseniibacteriota 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);;