contig_metadata
15 rows where bioproject = "PRJNA915212", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16198038 | 16198038 | PRJNA915212_P_NODE_2953_length_372_cov_1.510836_g2917_i0 | PRJNA915212 | 2953 | 372 | 1.510836 | 5.62030992 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 196 | 8.64e-59 | NR | MCL4419852.1 | 2052139 | g2917 | i0 | 79.7 | 0.991935483870968 | 123 | 25 | 99.2 | 0 | 2 | 370 | 169 | 291 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 369 | 196 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28105686 | 28105686 | PRJNA915212_P_NODE_10765_length_175_cov_1.214286_g10727_i0 | PRJNA915212 | 10765 | 175 | 1.214286 | 2.1250005 | Bacteria | 2 | Bacteria | Bacteria | 40.8 | 0.0312 | NR | MCD6193003.1 | 2052149 | g10727 | i0 | 38.9 | 2.67428571428571 | 54 | 33 | 92.6 | 0 | 169 | 8 | 25 | 78 | MCD6193003.1 Hpt domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 468 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 28224557 | 28224557 | PRJNA915212_P_NODE_14946_length_161_cov_0.910714_g14908_i0 | PRJNA915212 | 14946 | 161 | 0.910714 | 1.46624954 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 48.9 | 8.12e-5 | NR | MDD2807858.1 | 2052139 | g14908 | i0 | 49.1 | 1.97515527950311 | 53 | 23 | 98.8 | 1 | 2 | 160 | 388 | 436 | MDD2807858.1 glycoside hydrolase family 3 protein [Patescibacteria group bacterium] | diamond | 318 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28729995 | 28729995 | PRJNA915212_P_NODE_10587_length_177_cov_1.195312_g10549_i0 | PRJNA915212 | 10587 | 177 | 1.195312 | 2.11570224 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 46.6 | 1.6e-4 | NR | MDR3570671.1 | 2053589 | g10549 | i0 | 52.4 | 1.06779661016949 | 63 | 24 | 96.6 | 1 | 2 | 172 | 34 | 96 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 189 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28856094 | 28856094 | PRJNA915212_P_NODE_2448_length_418_cov_1.924119_g2412_i0 | PRJNA915212 | 2448 | 418 | 1.924119 | 8.04281742 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 48.5 | 0.00212 | NR | MDG2306814.1 | 2838779 | g2412 | i0 | 38 | 2.55502392344498 | 108 | 49 | 71.1 | 5 | 416 | 120 | 341 | 439 | MDG2306814.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1068 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29045798 | 29045798 | PRJNA915212_P_NODE_14468_length_162_cov_0.902655_g14430_i0 | PRJNA915212 | 14468 | 162 | 0.902655 | 1.4623011 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 52.4 | 3.92e-6 | NR | MBM3297791.1 | 2052149 | g14430 | i0 | 87 | 0.425925925925926 | 23 | 3 | 42.6 | 0 | 88 | 20 | 4 | 26 | MBM3297791.1 phosphoserine transaminase [Candidatus Aminicenantes bacterium] | diamond | 69 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29779199 | 29779199 | PRJNA915212_P_NODE_2771_length_386_cov_1.059347_g2735_i0 | PRJNA915212 | 2771 | 386 | 1.059347 | 4.08907942 | Bacillati | 1783272 | Bacteria | Bacteria | 59.3 | 2.64e-7 | NR | MCJ7563989.1 | 2052149 | g2735 | i0 | 63.3 | 1.14248704663212 | 49 | 17 | 38.1 | 1 | 374 | 228 | 69 | 116 | MCJ7563989.1 6-bladed beta-propeller [Candidatus Aminicenantes bacterium] | diamond | 441 | 59.7 | 0.993299832495812 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30087712 | 30087712 | PRJNA915212_P_NODE_6192_length_236_cov_1.090909_g6154_i0 | PRJNA915212 | 6192 | 236 | 1.090909 | 2.57454524 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 136 | 2e-35 | NR | MCL4419431.1 | 2052139 | g6154 | i0 | 86.7 | 0.953389830508475 | 75 | 9 | 94.1 | 1 | 233 | 12 | 513 | 587 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 225 | 136 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30182509 | 30182509 | PRJNA915212_P_NODE_7632_length_211_cov_1.574074_g7594_i0 | PRJNA915212 | 7632 | 211 | 1.574074 | 3.32129614 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 125 | 1.79e-35 | NR | MDR3570670.1 | 2053589 | g7594 | i0 | 81.7 | 1.00947867298578 | 71 | 11 | 98.1 | 1 | 4 | 210 | 5 | 75 | MDR3570670.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 213 | 125 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31098687 | 31098687 | PRJNA915212_P_NODE_5255_length_260_cov_1.208531_g5217_i0 | PRJNA915212 | 5255 | 260 | 1.208531 | 3.1421806 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 51.2 | 4.27e-5 | NR | MCX6578907.1 | 2052149 | g5217 | i0 | 42.4 | 0.761538461538461 | 66 | 35 | 76.2 | 1 | 198 | 1 | 153 | 215 | MCX6578907.1 hypothetical protein [Candidatus Aminicenantes bacterium] | diamond | 198 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31446693 | 31446693 | PRJNA915212_P_NODE_9616_length_187_cov_1.478261_g9578_i0 | PRJNA915212 | 9616 | 187 | 1.478261 | 2.76434807 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 44.7 | 0.00371 | NR | MDZ4343907.1 | 2838779 | g9578 | i0 | 53.4 | 0.93048128342246 | 58 | 26 | 91.4 | 1 | 172 | 2 | 247 | 304 | MDZ4343907.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 174 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31485838 | 31485838 | PRJNA915212_P_NODE_10316_length_180_cov_1.167939_g10278_i0 | PRJNA915212 | 10316 | 180 | 1.167939 | 2.1022902 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 2.69e-4 | NR | MEK7191921.1 | 2052139 | g10278 | i0 | 91.3 | 83.95 | 23 | 2 | 38.3 | 0 | 178 | 110 | 582 | 604 | MEK7191921.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Patescibacteria group bacterium] | diamond | 15111 | 48.1 | 0.993762993762994 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31794349 | 31794349 | PRJNA915212_P_NODE_3217_length_353_cov_1.509868_g3180_i0 | PRJNA915212 | 3217 | 353 | 1.509868 | 5.32983404 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 49.7 | 2.51e-4 | NR | OJU87784.1 | 1895829 | g3180 | i0 | 39.1 | 1.3257790368272 | 69 | 42 | 58.6 | 0 | 218 | 12 | 9 | 77 | OJU87784.1 MAG: hypothetical protein BGO17_02250 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 468 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 31952670 | 31952670 | PRJNA915212_P_NODE_5117_length_264_cov_1.311628_g5079_i0 | PRJNA915212 | 5117 | 264 | 1.311628 | 3.46269792 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 77.8 | 1.75e-16 | NR | MCX8092577.1 | 2725315 | g5079 | i0 | 50.6 | 0.920454545454545 | 81 | 37 | 92 | 1 | 1 | 243 | 12 | 89 | MCX8092577.1 stage V sporulation protein S [Candidatus Goldiibacteriota bacterium] | diamond | 243 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 32648119 | 32648119 | PRJNA915212_P_NODE_5300_length_259_cov_0.971429_g5262_i0 | PRJNA915212 | 5300 | 259 | 0.971429 | 2.51600111 | Candidatus Harrisonbacteria bacterium CG1 | 2528272 | Bacteria | Bacteria | 50.8 | 6.31e-5 | NR | PIT92124.1 | 1974584 | g5262 | i0 | 38.5 | 0.752895752895753 | 65 | 39 | 74.1 | 1 | 214 | 23 | 219 | 283 | PIT92124.1 MAG: hypothetical protein COU08_04230 [Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_17] | diamond | 195 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_17 |
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);;