contig_metadata
19 rows where bioproject = "PRJNA1022392" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7814709 | 7814709 | PRJNA1022392_P_NODE_40307_length_196_cov_3.308725_g39638_i0 | PRJNA1022392 | 40307 | 196 | 3.308725 | 6.485101 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 69.4 | 1.68e-7 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g39638 | i0 | 80 | 0.510204081632653 | 100 | 14 | 49 | 4 | 1 | 96 | 752806 | 752709 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 100 | 69.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 15465154 | 15465154 | PRJNA1022392_P_NODE_60273_length_177_cov_1.330769_g59604_i0 | PRJNA1022392 | 60273 | 177 | 1.330769 | 2.35546113 | Candidatus Nanosynbacter lyticus | 2093824 | Bacteria | Bacteria | 202 | 1.4e-47 | NTclustered | gi|2869833183|gb|CP175706.1| | 2093824 | g59604 | i0 | 87.861 | 1.73446327683616 | 173 | 19 | 97 | 2 | 6 | 177 | 15474 | 15303 | Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome | blastn | 307 | 202 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter lyticus | ||
| 27287819 | 27287819 | PRJNA1022392_P_NODE_28563_length_206_cov_4.320755_g27894_i0 | PRJNA1022392 | 28563 | 206 | 4.320755 | 8.9007553 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 50.4 | 4.32e-5 | NR | HEY1835475.1 | 2973664 | g27894 | i0 | 75.9 | 0.87378640776699 | 29 | 7 | 42.2 | 0 | 118 | 204 | 1 | 29 | HEY1835475.1 excinuclease ABC subunit UvrC [Candidatus Saccharimonadales bacterium] | diamond | 180 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28014368 | 28014368 | PRJNA1022392_P_NODE_59245_length_178_cov_2.076336_g58576_i0 | PRJNA1022392 | 59245 | 178 | 2.076336 | 3.69587808 | Candidatus Bipolaricaulota bacterium | 2306012 | Bacteria | Bacteria | 124 | 3.939999999999999e-31 | NR | MCF7875455.1 | 2306012 | g58576 | i0 | 98.3 | 1.95505617977528 | 58 | 1 | 97.8 | 0 | 3 | 176 | 78 | 135 | MCF7875455.1 isoleucine--tRNA ligase [Candidatus Bipolaricaulota bacterium] | diamond | 348 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Bipolaricaulota bacterium | ||||||
| 28929823 | 28929823 | PRJNA1022392_P_NODE_28508_length_206_cov_4.352201_g27839_i0 | PRJNA1022392 | 28508 | 206 | 4.352201 | 8.96553406 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 43.9 | 0.00903 | NR | MCC6349450.1 | 2212470 | g27839 | i0 | 40.4 | 0.830097087378641 | 57 | 30 | 83 | 2 | 2 | 172 | 233 | 285 | MCC6349450.1 response regulator [Candidatus Eiseniibacteriota bacterium] | diamond | 171 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 28929833 | 28929833 | PRJNA1022392_P_NODE_65728_length_170_cov_1.528455_g65059_i0 | PRJNA1022392 | 65728 | 170 | 1.528455 | 2.5983735 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 88.6 | 9.8e-19 | NR | MEX0848717.1 | 2030827 | g65059 | i0 | 80.4 | 0.988235294117647 | 56 | 11 | 98.8 | 0 | 2 | 169 | 176 | 231 | MEX0848717.1 primosomal protein N' [Candidatus Dependentiae bacterium] | diamond | 168 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29119488 | 29119488 | PRJNA1022392_P_NODE_37729_length_203_cov_5.974359_g37060_i0 | PRJNA1022392 | 37729 | 203 | 5.974359 | 12.12794877 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 42.7 | 0.022 | NR | HEY7250727.1 | 2072417 | g37060 | i0 | 49 | 0.724137931034483 | 49 | 23 | 72.4 | 2 | 168 | 22 | 97 | 143 | HEY7250727.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 147 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29434688 | 29434688 | PRJNA1022392_P_NODE_57410_length_180_cov_4.954887_g56741_i0 | PRJNA1022392 | 57410 | 180 | 4.954887 | 8.9187966 | Candidatus Nealsonbacteria bacterium CG_4_9_14_ | 2093793 | Bacteria | Bacteria | 64.3 | 4e-10 | NR | PJB99410.1 | 1974692 | g56741 | i0 | 63.6 | 1.91666666666667 | 55 | 20 | 91.7 | 0 | 180 | 16 | 538 | 592 | PJB99410.1 MAG: DNA primase [Candidatus Nealsonbacteria bacterium CG_4_9_14_0_8_um_filter_35_12] | diamond | 345 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nealsoniibacteriota | Candidatus Nealsonbacteria bacterium CG_4_9_14_0_8_um_filter_35_12 | ||||||
| 29623936 | 29623936 | PRJNA1022392_P_NODE_75190_length_161_cov_1.087719_g74521_i0 | PRJNA1022392 | 75190 | 161 | 1.087719 | 1.75122759 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 56.6 | 1.54e-7 | NR | MBX6334645.1 | 2026720 | g74521 | i0 | 50.9 | 0.987577639751553 | 53 | 26 | 98.8 | 0 | 2 | 160 | 382 | 434 | MBX6334645.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 159 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29900893 | 29900893 | PRJNA1022392_P_NODE_46971_length_193_cov_3.842466_g46302_i0 | PRJNA1022392 | 46971 | 193 | 3.842466 | 7.41595938 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.5 | 5.26e-7 | NR | MCK5059189.1 | 2052149 | g46302 | i0 | 75 | 3.18652849740933 | 32 | 8 | 49.7 | 0 | 189 | 94 | 1 | 32 | MCK5059189.1 MBL fold metallo-hydrolase [Candidatus Aminicenantes bacterium] | diamond | 615 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30351492 | 30351492 | PRJNA1022392_P_NODE_28212_length_206_cov_4.566038_g27543_i0 | PRJNA1022392 | 28212 | 206 | 4.566038 | 9.40603828 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 61.6 | 4.89e-9 | NR | MBI1856882.1 | 2026720 | g27543 | i0 | 93.8 | 2.79611650485437 | 32 | 2 | 46.6 | 0 | 111 | 206 | 266 | 297 | MBI1856882.1 cell division protein FtsZ [Candidatus Saccharibacteria bacterium] | diamond | 576 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30477471 | 30477471 | PRJNA1022392_P_NODE_51873_length_187_cov_7.571429_g51204_i0 | PRJNA1022392 | 51873 | 187 | 7.571429 | 14.15857223 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 86.7 | 6.03e-18 | NR | MBI2593068.1 | 2053542 | g51204 | i0 | 49.5 | 6.75401069518717 | 105 | 10 | 99.5 | 1 | 2 | 187 | 180 | 284 | MBI2593068.1 elongation factor G [Candidatus Daviesbacteria bacterium] | diamond | 1263 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 30666892 | 30666892 | PRJNA1022392_P_NODE_43013_length_195_cov_3.209459_g42344_i0 | PRJNA1022392 | 43013 | 195 | 3.209459 | 6.25844505 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 68.2 | 1.42e-11 | NR | MBH2007910.1 | 2026720 | g42344 | i0 | 100 | 0.492307692307692 | 32 | 0 | 49.2 | 0 | 3 | 98 | 121 | 152 | MBH2007910.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 96 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30848642 | 30848642 | PRJNA1022392_P_NODE_71194_length_164_cov_1.461538_g70525_i0 | PRJNA1022392 | 71194 | 164 | 1.461538 | 2.39692232 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99.8 | 1.8899999999999994e-23 | NR | HJM04459.1 | 2830836 | g70525 | i0 | 79.6 | 2.96341463414634 | 54 | 11 | 98.8 | 0 | 163 | 2 | 255 | 308 | HJM04459.1 peptidoglycan bridge formation glycyltransferase FemA/FemB family protein [Candidatus Saccharimonadaceae bacterium] | diamond | 486 | 100 | 0.998 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonadaceae bacterium | |||
| 30888109 | 30888109 | PRJNA1022392_P_NODE_81174_length_156_cov_3.770642_g80505_i0 | PRJNA1022392 | 81174 | 156 | 3.770642 | 5.88220152 | Candidatus Aminicenantes bacterium ADurb.Bin5 | 2052149 | Bacteria | Bacteria | 52.8 | 2.81e-6 | NR | OPZ58375.1 | 1852832 | g80505 | i0 | 58.5 | 0.788461538461538 | 41 | 17 | 78.8 | 0 | 152 | 30 | 93 | 133 | OPZ58375.1 MAG: hypothetical protein BWY86_01512 [Candidatus Aminicenantes bacterium ADurb.Bin508] | diamond | 123 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium ADurb.Bin508 | ||||||
| 30943532 | 30943532 | PRJNA1022392_P_NODE_51534_length_188_cov_2.418440_g50865_i0 | PRJNA1022392 | 51534 | 188 | 2.41844 | 4.5466672 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 2.52e-5 | NR | KKU73195.1 | 1618361 | g50865 | i0 | 43.7 | 2.26595744680851 | 71 | 31 | 98.9 | 1 | 2 | 187 | 999 | 1069 | KKU73195.1 MAG: Hemagluttinin family protein [Candidatus Amesbacteria bacterium GW2011_GWB1_47_26] | diamond | 426 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Amesiibacteriota | Candidatus Amesbacteria bacterium GW2011_GWB1_47_26 | ||||||
| 30951464 | 30951464 | PRJNA1022392_P_NODE_46074_length_194_cov_2.945578_g45405_i0 | PRJNA1022392 | 46074 | 194 | 2.945578 | 5.71442132 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 40.8 | 0.037 | NR | HVN90302.1 | 2785449 | g45405 | i0 | 43.1 | 0.788659793814433 | 51 | 29 | 78.9 | 0 | 5 | 157 | 60 | 110 | HVN90302.1 DUF4870 domain-containing protein [Candidatus Binataceae bacterium] | diamond | 153 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32248270 | 32248270 | PRJNA1022392_P_NODE_56458_length_182_cov_1.318519_g55789_i0 | PRJNA1022392 | 56458 | 182 | 1.318519 | 2.39970458 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 47.4 | 3.61e-4 | NR | MBY0352741.1 | 2803731 | g55789 | i0 | 100 | 0.346153846153846 | 21 | 0 | 34.6 | 0 | 181 | 119 | 259 | 279 | MBY0352741.1 ankyrin repeat domain-containing protein [Candidatus Babeliales bacterium] | diamond | 63 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 32406231 | 32406231 | PRJNA1022392_P_NODE_65339_length_170_cov_3.113821_g64670_i0 | PRJNA1022392 | 65339 | 170 | 3.113821 | 5.2934957 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 86.7 | 4.65e-18 | NR | MCA9323566.1 | 2026720 | g64670 | i0 | 80.4 | 1.97647058823529 | 56 | 11 | 98.8 | 0 | 1 | 168 | 82 | 137 | MCA9323566.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saccharibacteria bacterium] | diamond | 336 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;