contig_metadata
17 rows where bioproject = "PRJNA782235" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 763328 | 763328 | PRJNA782235_P_NODE_21641_length_247_cov_0.885057_g21452_i0 | PRJNA782235 | 21641 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 149 | 1.37e-39 | NR | MBC7546307.1 | 2026720 | g21452 | i0 | 95.1 | 14.9392712550607 | 82 | 4 | 99.6 | 0 | 1 | 246 | 530 | 611 | MBC7546307.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 3690 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 763426 | 763426 | PRJNA782235_P_NODE_27821_length_241_cov_0.916667_g27632_i0 | PRJNA782235 | 27821 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 318 | 1.94e-82 | NTclustered | gi|2890901196|gb|CP128407.1| | 713059 | g27632 | i0 | 90.456 | 8.99585062240664 | 241 | 23 | 100 | 0 | 1 | 241 | 795017 | 795257 | Candidatus Saccharibacteria bacterium oral taxon 488 strain 106.1.1 chromosome, complete genome | blastn | 2168 | 318 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 3314594 | 3314594 | PRJNA782235_P_NODE_19363_length_249_cov_0.875000_g19174_i0 | PRJNA782235 | 19363 | 249 | 0.875 | 2.17875 | Candidatus Nanosynbacter sp. HMT-352 | 2899133 | Bacteria | Bacteria | 412 | 8.97e-111 | NTclustered | gi|2218410560|gb|CP089288.1| | 2899133 | g19174 | i0 | 96.761 | 6.79919678714859 | 247 | 8 | 99 | 0 | 3 | 249 | 502868 | 503114 | Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome | blastn | 1693 | 412 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-352 | ||
| 7141918 | 7141918 | PRJNA782235_P_NODE_26526_length_242_cov_0.911243_g26337_i0 | PRJNA782235 | 26526 | 242 | 0.911243 | 2.20520806 | Candidatus Sumerlaea chitinivorans | 2250252 | Bacteria | Bacteria | 259 | 1.2e-64 | NTclustered | gi|1419285073|gb|CP030759.1| | 2250252 | g26337 | i0 | 86.364 | 246.181818181818 | 242 | 27 | 99 | 5 | 1 | 239 | 161006 | 161244 | Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome | blastn | 59576 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeales | Candidatus Sumerlaeaceae | Candidatus Sumerlaea | Candidatus Sumerlaea chitinivorans | ||
| 7141922 | 7141922 | PRJNA782235_P_NODE_26686_length_242_cov_0.911243_g26497_i0 | PRJNA782235 | 26686 | 242 | 0.911243 | 2.20520806 | Candidatus Nanosynbacter sp. TM7-074 | 3158573 | Bacteria | Bacteria | 209 | 1.22e-49 | NTclustered | gi|2781952016|gb|CP158487.1| | 3158573 | g26497 | i0 | 82.231 | 1 | 242 | 43 | 100 | 0 | 1 | 242 | 597821 | 598062 | Candidatus Nanosynbacter sp. TM7-074 chromosome, complete genome | blastn | 242 | 209 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. TM7-074 | ||
| 10967571 | 10967571 | PRJNA782235_P_NODE_28369_length_241_cov_0.916667_g28180_i0 | PRJNA782235 | 28369 | 241 | 0.916667 | 2.20916747 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 390 | 4.05e-104 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g28180 | i0 | 95.851 | 2 | 241 | 10 | 100 | 0 | 1 | 241 | 291599 | 291839 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 482 | 390 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 13517188 | 13517188 | PRJNA782235_P_NODE_24531_length_244_cov_0.900585_g24342_i0 | PRJNA782235 | 24531 | 244 | 0.900585 | 2.1974274 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 379 | 8.889999999999998e-101 | NTclustered | gi|2070586293|gb|CP076101.2| | 1917697 | g24342 | i0 | 94.672 | 1 | 244 | 13 | 100 | 0 | 1 | 244 | 89294 | 89051 | MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome | blastn | 244 | 379 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 14791984 | 14791984 | PRJNA782235_P_NODE_24132_length_244_cov_1.801170_g23943_i0 | PRJNA782235 | 24132 | 244 | 1.80117 | 4.3948548 | Candidatus Nanosynbacter sp. BB002 | 3393757 | Bacteria | Bacteria | 368 | 1.92e-97 | NTclustered | gi|2692798772|gb|CP146064.1| | 3393757 | g23943 | i0 | 93.852 | 2 | 244 | 15 | 100 | 0 | 1 | 244 | 546849 | 546606 | Candidatus Nanosynbacter sp. BB002 chromosome, complete genome | blastn | 488 | 368 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. BB002 | ||
| 16065729 | 16065729 | PRJNA782235_P_NODE_16213_length_251_cov_0.865169_g16024_i0 | PRJNA782235 | 16213 | 251 | 0.865169 | 2.17157419 | Candidatus Southlakia epibionticum | 3043284 | Bacteria | Bacteria | 457 | 4.13e-124 | NTclustered | gi|2516687873|gb|CP124550.1| | 3043284 | g16024 | i0 | 99.602 | 1 | 251 | 0 | 100 | 1 | 1 | 251 | 792660 | 792909 | Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome | blastn | 251 | 457 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Southlakia | Candidatus Southlakia epibionticum | ||
| 16065890 | 16065890 | PRJNA782235_P_NODE_28073_length_241_cov_0.916667_g27884_i0 | PRJNA782235 | 28073 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 144 | 1.13e-38 | NR | OJU88065.1 | 1895829 | g27884 | i0 | 88.6 | 2.95020746887967 | 79 | 9 | 98.3 | 0 | 241 | 5 | 171 | 249 | OJU88065.1 MAG: hypothetical protein BGO17_03765 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 711 | 145 | 0.993103448275862 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 17341512 | 17341512 | PRJNA782235_P_NODE_17934_length_250_cov_0.870056_g17745_i0 | PRJNA782235 | 17934 | 250 | 0.870056 | 2.17514 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 361 | 3.31e-95 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g17745 | i0 | 93.089 | 4.116 | 246 | 17 | 98 | 0 | 5 | 250 | 53600 | 53845 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 1029 | 361 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 21165923 | 21165923 | PRJNA782235_P_NODE_21297_length_247_cov_0.885057_g21108_i0 | PRJNA782235 | 21297 | 247 | 0.885057 | 2.18609079 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g21108 | i0 | 100 | 1.9919028340081 | 247 | 0 | 100 | 0 | 1 | 247 | 329001 | 328755 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 492 | 457 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 28569433 | 28569433 | PRJNA782235_P_NODE_22707_length_246_cov_0.890173_g22518_i0 | PRJNA782235 | 22707 | 246 | 0.890173 | 2.18982558 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 110 | 2.8e-26 | NR | PID31564.1 | 2026720 | g22518 | i0 | 58.5 | 2.95121951219512 | 82 | 34 | 100 | 0 | 246 | 1 | 79 | 160 | PID31564.1 MAG: hypothetical protein CR983_00585 [Candidatus Saccharibacteria bacterium] | diamond | 726 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28853464 | 28853464 | PRJNA782235_P_NODE_10088_length_289_cov_1.236111_g9899_i0 | PRJNA782235 | 10088 | 289 | 1.236111 | 3.57236079 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 55.8 | 1.5e-6 | NR | MEO5949122.1 | 1917697 | g9899 | i0 | 44.2 | 1.55709342560554 | 77 | 39 | 76.8 | 3 | 287 | 66 | 365 | 440 | MEO5949122.1 DUF11 domain-containing protein [Candidatus Saccharimonas sp.] | diamond | 450 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 32076751 | 32076751 | PRJNA782235_P_NODE_12578_length_273_cov_1.290000_g12389_i0 | PRJNA782235 | 12578 | 273 | 1.29 | 3.5217 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 76.6 | 6.53e-14 | NR | MFC1713662.1 | 2026781 | g12389 | i0 | 48.9 | 1.95604395604396 | 90 | 44 | 98.9 | 1 | 3 | 272 | 866 | 953 | MFC1713662.1 C10 family peptidase [Candidatus Poribacteria bacterium] | diamond | 534 | 76.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32488229 | 32488229 | PRJNA782235_P_NODE_19639_length_248_cov_0.880000_g19450_i0 | PRJNA782235 | 19639 | 248 | 0.88 | 2.1824 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 46.2 | 0.00215 | NR | HMI09658.1 | 2973664 | g19450 | i0 | 50.9 | 0.641129032258065 | 53 | 22 | 64.1 | 2 | 161 | 3 | 3 | 51 | HMI09658.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 159 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 32834737 | 32834737 | PRJNA782235_P_NODE_20880_length_247_cov_0.885057_g20691_i0 | PRJNA782235 | 20880 | 247 | 0.885057 | 2.18609079 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 50.8 | 4.24e-6 | NR | HTK39651.1 | 2052139 | g20691 | i0 | 56.1 | 0.497975708502024 | 41 | 18 | 49.8 | 0 | 29 | 151 | 38 | 78 | HTK39651.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 123 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;