contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA767802" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26873277 | 26873277 | PRJNA767802_P_NODE_5281_length_355_cov_1.444444_g5208_i0 | PRJNA767802 | 5281 | 355 | 1.444444 | 5.1277762 | Bacteria | 2 | Bacteria | Bacteria | 100 | 8.859999999999998e-24 | NR | TSC68476.1 | 2017190 | g5208 | i0 | 50 | 3.46478873239437 | 102 | 51 | 86.2 | 0 | 342 | 37 | 3 | 104 | TSC68476.1 MAG: hypothetical protein G01um101456_631 [Parcubacteria group bacterium Gr01-1014_56] | diamond | 1230 | 100 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium Gr01-1014_56 | |||||||
| 27021618 | 27021618 | PRJNA767802_P_NODE_4522_length_397_cov_6.307471_g4449_i0 | PRJNA767802 | 4522 | 397 | 6.307471 | 25.04065987 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 73.9 | 4.19e-14 | NR | MES2201120.1 | 2052330 | g4449 | i0 | 44.3 | 0.596977329974811 | 79 | 43 | 58.9 | 1 | 257 | 24 | 1 | 79 | MES2201120.1 hypothetical protein [candidate division FCPU426 bacterium] | diamond | 237 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 27663220 | 27663220 | PRJNA767802_P_NODE_2524_length_567_cov_4.868726_g2457_i0 | PRJNA767802 | 2524 | 567 | 4.868726 | 27.605676420000002 | Bacteria | 2 | Bacteria | Bacteria | 87.4 | 4.64e-18 | NR | MES3031420.1 | 2052139 | g2457 | i0 | 69.2 | 1.61375661375661 | 65 | 20 | 34.4 | 0 | 370 | 564 | 1 | 65 | MES3031420.1 ribonuclease HI [Patescibacteria group bacterium] | diamond | 915 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28316594 | 28316594 | PRJNA767802_P_NODE_7346_length_282_cov_1.854077_g7273_i0 | PRJNA767802 | 7346 | 282 | 1.854077 | 5.22849714 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 64.7 | 1.19e-9 | NR | MDO8335677.1 | 2026720 | g7273 | i0 | 43.6 | 1 | 94 | 53 | 100 | 0 | 1 | 282 | 678 | 771 | MDO8335677.1 kelch repeat-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 282 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28379659 | 28379659 | PRJNA767802_P_NODE_11926_length_202_cov_2.529412_g11853_i0 | PRJNA767802 | 11926 | 202 | 2.529412 | 5.10941224 | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_ | 2053634 | Bacteria | Bacteria | 46.6 | 9.13e-4 | NR | OGL72941.1 | 1802392 | g11853 | i0 | 38.1 | 0.935643564356436 | 63 | 35 | 89.1 | 2 | 198 | 19 | 179 | 240 | OGL72941.1 MAG: hypothetical protein A3C96_01675 [Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_02_FULL_60_10] | diamond | 189 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium RIFCSPHIGHO2_02_FULL_60_10 | ||||||
| 28411365 | 28411365 | PRJNA767802_P_NODE_4886_length_375_cov_2.322086_g4813_i0 | PRJNA767802 | 4886 | 375 | 2.322086 | 8.7078225 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 98.2 | 5.64e-21 | NR | MBP9837014.1 | 2053589 | g4813 | i0 | 43.2 | 2.992 | 125 | 65 | 98.4 | 4 | 5 | 373 | 249 | 369 | MBP9837014.1 FAD-binding oxidoreductase [Candidatus Paceibacterota bacterium] | diamond | 1122 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28632499 | 28632499 | PRJNA767802_P_NODE_7387_length_281_cov_1.685345_g7314_i0 | PRJNA767802 | 7387 | 281 | 1.685345 | 4.73581945 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 168 | 1.63e-46 | NR | HEY0220878.1 | 2053589 | g7314 | i0 | 86 | 2.97864768683274 | 93 | 13 | 99.3 | 0 | 279 | 1 | 501 | 593 | HEY0220878.1 type I DNA topoisomerase [Candidatus Paceibacterota bacterium] | diamond | 837 | 168 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28695599 | 28695599 | PRJNA767802_P_NODE_2167_length_616_cov_3.419753_g2104_i0 | PRJNA767802 | 2167 | 616 | 3.419753 | 21.06567848 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 229 | 5.72e-72 | NR | MCC7436845.1 | 2052152 | g2104 | i0 | 69.7 | 0.803571428571429 | 165 | 48 | 80.4 | 1 | 609 | 115 | 97 | 259 | MCC7436845.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 495 | 229 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 28705125 | 28705125 | PRJNA767802_P_NODE_4587_length_392_cov_2.288630_g4514_i0 | PRJNA767802 | 4587 | 392 | 2.28863 | 8.9714296 | Bacteria | 2 | Bacteria | Bacteria | 181 | 7.6e-51 | NR | MBI1813146.1 | 2030811 | g4514 | i0 | 70.5 | 2.80102040816327 | 122 | 36 | 93.4 | 0 | 386 | 21 | 194 | 315 | MBI1813146.1 glycoside hydrolase family 15 protein [Candidatus Peregrinibacteria bacterium] | diamond | 1098 | 181 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 29042911 | 29042911 | PRJNA767802_P_NODE_7828_length_270_cov_1.230769_g7755_i0 | PRJNA767802 | 7828 | 270 | 1.230769 | 3.3230763 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 54.3 | 4.48e-6 | NR | MDE2098732.1 | 2052139 | g7755 | i0 | 49.1 | 0.588888888888889 | 53 | 27 | 58.9 | 0 | 195 | 37 | 346 | 398 | MDE2098732.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 159 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29579239 | 29579239 | PRJNA767802_P_NODE_7570_length_276_cov_2.466960_g7497_i0 | PRJNA767802 | 7570 | 276 | 2.46696 | 6.8088096 | Candidatus Sungiibacteriota bacterium | 2750080 | Bacteria | Bacteria | 54.7 | 7.59e-7 | NR | MBI2122395.1 | 2750080 | g7497 | i0 | 88.5 | 0.282608695652174 | 26 | 3 | 28.3 | 0 | 57 | 134 | 8 | 33 | MBI2122395.1 hypothetical protein [Candidatus Sungiibacteriota bacterium] | diamond | 78 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sungiibacteriota | Candidatus Sungiibacteriota bacterium | ||||||
| 29737102 | 29737102 | PRJNA767802_P_NODE_15310_length_171_cov_1.672131_g15237_i0 | PRJNA767802 | 15310 | 171 | 1.672131 | 2.85934401 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 86.3 | 6.18e-18 | NR | MFM2331180.1 | 2762014 | g15237 | i0 | 73.7 | 2 | 57 | 15 | 100 | 0 | 1 | 171 | 92 | 148 | MFM2331180.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 342 | 86.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29768833 | 29768833 | PRJNA767802_P_NODE_4271_length_412_cov_2.853994_g4198_i0 | PRJNA767802 | 4271 | 412 | 2.853994 | 11.75845528 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 126 | 1.2799999999999999e-31 | NR | MCS7245191.1 | 2052148 | g4198 | i0 | 50.4 | 0.910194174757282 | 125 | 56 | 91 | 2 | 407 | 33 | 279 | 397 | MCS7245191.1 ornithine--oxo-acid transaminase [candidate division WOR-3 bacterium] | diamond | 375 | 126 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 30116288 | 30116288 | PRJNA767802_P_NODE_15792_length_168_cov_1.067227_g15719_i0 | PRJNA767802 | 15792 | 168 | 1.067227 | 1.79294136 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 105 | 9.49e-25 | NR | MDO8270093.1 | 2052151 | g15719 | i0 | 89.3 | 1 | 56 | 6 | 100 | 0 | 1 | 168 | 478 | 533 | MDO8270093.1 ATPase, T2SS/T4P/T4SS family [Candidatus Levyibacteriota bacterium] | diamond | 168 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 30179460 | 30179460 | PRJNA767802_P_NODE_15912_length_167_cov_1.296610_g15839_i0 | PRJNA767802 | 15912 | 167 | 1.29661 | 2.1653387 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 43.9 | 0.00449 | NR | MEY2665536.1 | 2762014 | g15839 | i0 | 70 | 0.538922155688623 | 30 | 7 | 50.3 | 1 | 85 | 2 | 7 | 36 | MEY2665536.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 90 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 32139704 | 32139704 | PRJNA767802_P_NODE_3478_length_471_cov_2.459716_g3406_i0 | PRJNA767802 | 3478 | 471 | 2.459716 | 11.58526236 | Parcubacteria group bacterium GW2 | 2026774 | Bacteria | Bacteria | 125 | 4.0699999999999995e-30 | NR | KKU10204.1 | 1618958 | g3406 | i0 | 66.7 | 0.573248407643312 | 90 | 29 | 56.7 | 1 | 203 | 469 | 1 | 90 | KKU10204.1 MAG: hypothetical protein UX14_C0023G0011 [Parcubacteria group bacterium GW2011_GWF1_45_5] | diamond | 270 | 125 | 1 | Bacteria | Bacteria candidate phyla | Parcubacteria group bacterium GW2011_GWF1_45_5 | |||||||
| 32329812 | 32329812 | PRJNA767802_P_NODE_9159_length_241_cov_1.552083_g9086_i0 | PRJNA767802 | 9159 | 241 | 1.552083 | 3.74052003 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 141 | 1.55e-39 | NR | MBP6891501.1 | 2053613 | g9086 | i0 | 94.8 | 0.95850622406639 | 77 | 4 | 95.9 | 0 | 1 | 231 | 31 | 107 | MBP6891501.1 protein translocase subunit SecF [Candidatus Shapirobacteria bacterium] | diamond | 231 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 32424432 | 32424432 | PRJNA767802_P_NODE_1499_length_746_cov_7.479197_g1446_i0 | PRJNA767802 | 1499 | 746 | 7.479197 | 55.79480962 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 363 | 6.43e-120 | NR | MDB5204128.1 | 2052153 | g1446 | i0 | 81.4 | 0.884718498659517 | 220 | 41 | 88.5 | 0 | 742 | 83 | 243 | 462 | MDB5204128.1 hypothetical protein [Candidatus Taylorbacteria bacterium] | diamond | 660 | 363 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota 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);;