contig_metadata
15 rows where bioproject = "PRJNA950981" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26645472 | 26645472 | PRJNA950981_P_NODE_3221_length_535_cov_1.181818_g3047_i0 | PRJNA950981 | 3221 | 535 | 1.181818 | 6.3227263 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 114 | 1.37e-25 | NR | MEZ0208986.1 | 2053589 | g3047 | i0 | 36.4 | 0.986915887850467 | 176 | 109 | 98.7 | 1 | 534 | 7 | 1313 | 1485 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 528 | 114 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26962113 | 26962113 | PRJNA950981_P_NODE_17122_length_252_cov_0.871508_g16946_i0 | PRJNA950981 | 17122 | 252 | 0.871508 | 2.19620016 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.7 | 2.41e-8 | NR | MEZ0208896.1 | 2053589 | g16946 | i0 | 43.9 | 0.976190476190476 | 82 | 43 | 97.6 | 2 | 250 | 5 | 131 | 209 | MEZ0208896.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 246 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27404993 | 27404993 | PRJNA950981_P_NODE_20003_length_245_cov_1.813953_g19827_i0 | PRJNA950981 | 20003 | 245 | 1.813953 | 4.44418485 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 63.2 | 1.56e-10 | NR | MCL4419283.1 | 2052139 | g19827 | i0 | 44.4 | 0.991836734693878 | 81 | 25 | 79.6 | 2 | 241 | 47 | 13 | 89 | MCL4419283.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 243 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27941681 | 27941681 | PRJNA950981_P_NODE_9065_length_335_cov_1.190840_g8889_i0 | PRJNA950981 | 9065 | 335 | 1.19084 | 3.989314 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 78.6 | 3.06e-14 | NR | MEZ0208986.1 | 2053589 | g8889 | i0 | 39.6 | 0.904477611940299 | 101 | 60 | 90.4 | 1 | 318 | 16 | 800 | 899 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 303 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28193977 | 28193977 | PRJNA950981_P_NODE_5286_length_423_cov_1.777143_g5110_i0 | PRJNA950981 | 5286 | 423 | 1.777143 | 7.51731489 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 90.9 | 4.25e-18 | NR | MEZ0208986.1 | 2053589 | g5110 | i0 | 40 | 0.815602836879433 | 115 | 69 | 81.6 | 0 | 418 | 74 | 1377 | 1491 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 345 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28257174 | 28257174 | PRJNA950981_P_NODE_18886_length_248_cov_0.891429_g18710_i0 | PRJNA950981 | 18886 | 248 | 0.891429 | 2.21074392 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 48.5 | 3.35e-4 | NR | HUS79346.1 | 2052139 | g18710 | i0 | 56.8 | 0.532258064516129 | 44 | 19 | 53.2 | 0 | 245 | 114 | 228 | 271 | HUS79346.1 DNA-directed RNA polymerase subunit D [Patescibacteria group bacterium] | diamond | 132 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28667939 | 28667939 | PRJNA950981_P_NODE_20287_length_245_cov_0.906977_g20111_i0 | PRJNA950981 | 20287 | 245 | 0.906977 | 2.22209365 | Candidatus Doudnabacteria bacterium | 2052150 | Bacteria | Bacteria | 63.9 | 1.33e-9 | NR | MEJ0021442.1 | 2052150 | g20111 | i0 | 60.9 | 1.22448979591837 | 46 | 18 | 56.3 | 0 | 228 | 91 | 1116 | 1161 | MEJ0021442.1 6-bladed beta-propeller [Candidatus Doudnabacteria bacterium] | diamond | 300 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Doudnaibacteriota | Candidatus Doudnabacteria bacterium | ||||||
| 28762417 | 28762417 | PRJNA950981_P_NODE_20407_length_245_cov_0.877907_g20231_i0 | PRJNA950981 | 20407 | 245 | 0.877907 | 2.15087215 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 53.1 | 8.38e-6 | NR | MEZ0208986.1 | 2053589 | g20231 | i0 | 40 | 0.979591836734694 | 80 | 48 | 98 | 0 | 244 | 5 | 1243 | 1322 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 240 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28920200 | 28920200 | PRJNA950981_P_NODE_15568_length_261_cov_1.234043_g15392_i0 | PRJNA950981 | 15568 | 261 | 1.234043 | 3.22085223 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 54.3 | 3.98e-6 | NR | MEZ0208986.1 | 2053589 | g15392 | i0 | 43.3 | 1.03448275862069 | 90 | 41 | 97.7 | 3 | 260 | 6 | 1240 | 1324 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 270 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29425352 | 29425352 | PRJNA950981_P_NODE_19949_length_246_cov_0.901734_g19773_i0 | PRJNA950981 | 19949 | 246 | 0.901734 | 2.21826564 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67.8 | 5.86e-11 | NR | MEZ0208986.1 | 2053589 | g19773 | i0 | 45.6 | 0.963414634146341 | 79 | 42 | 96.3 | 1 | 2 | 238 | 1097 | 1174 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 237 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29684403 | 29684403 | PRJNA950981_P_NODE_15310_length_263_cov_1.557895_g15134_i0 | PRJNA950981 | 15310 | 263 | 1.557895 | 4.09726385 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.2 | 8.44e-7 | NR | MBR2766801.1 | 2026720 | g15134 | i0 | 58.8 | 2.24714828897338 | 51 | 20 | 57 | 1 | 263 | 114 | 593 | 643 | MBR2766801.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 591 | 56.6 | 0.992932862190813 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30183518 | 30183518 | PRJNA950981_P_NODE_11992_length_296_cov_2.098655_g11816_i0 | PRJNA950981 | 11992 | 296 | 2.098655 | 6.2120188 | Candidatus Firestoneibacteriota bacterium | 2715505 | Bacteria | Bacteria | 47 | 0.00217 | NR | MEI6845620.1 | 2715505 | g11816 | i0 | 42 | 0.699324324324324 | 69 | 40 | 69.9 | 0 | 6 | 212 | 123 | 191 | MEI6845620.1 HD domain-containing protein [Candidatus Firestonebacteria bacterium] | diamond | 207 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Firestoneibacteriota | Candidatus Firestoneibacteriota bacterium | ||||||
| 30657428 | 30657428 | PRJNA950981_P_NODE_10793_length_311_cov_0.983193_g10617_i0 | PRJNA950981 | 10793 | 311 | 0.983193 | 3.05773023 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 70.1 | 2.15e-11 | NR | PYM21373.1 | 2053607 | g10617 | i0 | 35.2 | 3.30868167202572 | 122 | 51 | 94.5 | 4 | 16 | 309 | 184 | 301 | PYM21373.1 MAG: hypothetical protein DMD78_18235 [Candidatus Rokuibacteriota bacterium] | diamond | 1029 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31131146 | 31131146 | PRJNA950981_P_NODE_7975_length_353_cov_1.114286_g7799_i0 | PRJNA950981 | 7975 | 353 | 1.114286 | 3.93342958 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 111 | 1.3e-25 | NR | MEZ0208986.1 | 2053589 | g7799 | i0 | 56 | 0.926345609065156 | 109 | 44 | 90.9 | 2 | 32 | 352 | 1273 | 1379 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 327 | 111 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32460119 | 32460119 | PRJNA950981_P_NODE_20919_length_243_cov_1.835294_g20743_i0 | PRJNA950981 | 20919 | 243 | 1.835294 | 4.45976442 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62.4 | 4.63e-9 | NR | MEZ0208986.1 | 2053589 | g20743 | i0 | 35.1 | 0.950617283950617 | 77 | 50 | 95.1 | 0 | 240 | 10 | 950 | 1026 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 231 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;