contig_metadata
18 rows where bioproject = "PRJNA498309", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11960245 | 11960245 | PRJNA498309_P_NODE_88190_length_225_cov_2.250000_g86041_i0 | PRJNA498309 | 88190 | 225 | 2.25 | 5.0625 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 411 | 2.869999999999999e-110 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g86041 | i0 | 99.556 | 110.631111111111 | 225 | 1 | 100 | 0 | 1 | 225 | 511928 | 511704 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 24892 | 411 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 15137149 | 15137149 | PRJNA498309_P_NODE_74392_length_270_cov_1.313305_g72243_i0 | PRJNA498309 | 74392 | 270 | 1.313305 | 3.5459235 | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | 1801609 | Bacteria | Bacteria | 140 | 1.74e-36 | NR | OGI09116.1 | 1801609 | g72243 | i0 | 77.3 | 0.977777777777778 | 88 | 20 | 97.8 | 0 | 264 | 1 | 611 | 698 | OGI09116.1 MAG: alanine--tRNA ligase [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11] | diamond | 264 | 140 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | |||||
| 23433607 | 23433607 | PRJNA498309_P_NODE_66039_length_301_cov_3.337121_g63891_i0 | PRJNA498309 | 66039 | 301 | 3.337121 | 10.04473421 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 100 | 1.0300000000000001e-22 | NR | MBI3309481.1 | 2052166 | g63891 | i0 | 73.8 | 1.75415282392027 | 61 | 16 | 60.8 | 0 | 9 | 191 | 135 | 195 | MBI3309481.1 DUF4325 domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 528 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 26824020 | 26824020 | PRJNA498309_P_NODE_58721_length_333_cov_4.557432_g56573_i0 | PRJNA498309 | 58721 | 333 | 4.557432 | 15.17624856 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 43.5 | 0.0283 | NR | NLF84027.1 | 2137880 | g56573 | i0 | 32.9 | 0.738738738738739 | 82 | 48 | 73 | 3 | 24 | 266 | 78 | 153 | NLF84027.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] | diamond | 246 | 43.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 27361719 | 27361719 | PRJNA498309_P_NODE_102563_length_188_cov_1.794702_g100414_i0 | PRJNA498309 | 102563 | 188 | 1.794702 | 3.37403976 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 72.4 | 6.19e-13 | NR | MDD3436402.1 | 2137880 | g100414 | i0 | 64.4 | 2.23404255319149 | 45 | 16 | 71.8 | 0 | 187 | 53 | 71 | 115 | MDD3436402.1 MlaA family lipoprotein [Candidatus Gastranaerophilales bacterium] | diamond | 420 | 72.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 27550799 | 27550799 | PRJNA498309_P_NODE_116884_length_160_cov_1.585366_g114735_i0 | PRJNA498309 | 116884 | 160 | 1.585366 | 2.5365856 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 78.2 | 4.9e-16 | NR | MBI3591179.1 | 2052166 | g114735 | i0 | 76.9 | 3.9 | 52 | 12 | 97.5 | 0 | 158 | 3 | 94 | 145 | MBI3591179.1 Holliday junction branch migration protein RuvA [Candidatus Melainabacteria bacterium] | diamond | 624 | 78.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27582477 | 27582477 | PRJNA498309_P_NODE_58124_length_336_cov_2.357860_g55976_i0 | PRJNA498309 | 58124 | 336 | 2.35786 | 7.9224096 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 55.8 | 1.33e-7 | NR | MBI2995778.1 | 2052166 | g55976 | i0 | 60.5 | 0.339285714285714 | 38 | 15 | 33.9 | 0 | 216 | 329 | 1 | 38 | MBI2995778.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 114 | 55.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27898127 | 27898127 | PRJNA498309_P_NODE_34865_length_476_cov_1.974943_g32820_i0 | PRJNA498309 | 34865 | 476 | 1.974943 | 9.40072868 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 47.4 | 0.0101 | NR | MBK9143592.1 | 2052166 | g32820 | i0 | 48.6 | 0.233193277310924 | 37 | 19 | 23.3 | 0 | 471 | 361 | 1701 | 1737 | MBK9143592.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 111 | 47.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28687903 | 28687903 | PRJNA498309_P_NODE_44987_length_405_cov_3.807065_g42855_i0 | PRJNA498309 | 44987 | 405 | 3.807065 | 15.41861325 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 171 | 2.24e-46 | NR | MBN9396554.1 | 2052166 | g42855 | i0 | 62.6 | 0.911111111111111 | 123 | 46 | 91.1 | 0 | 23 | 391 | 220 | 342 | MBN9396554.1 PAS domain S-box protein [Candidatus Melainabacteria bacterium] | diamond | 369 | 171 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29602954 | 29602954 | PRJNA498309_S_NODE_12110_length_696_cov_2.897126_g10244_i0 | PRJNA498309 | 12110 | 696 | 2.897126 | 20.16399696 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 150 | 1.4899999999999998e-37 | NR | MBK8223127.1 | 2711154 | g10244 | i0 | 43.3 | 3.74137931034483 | 217 | 114 | 92.2 | 5 | 642 | 1 | 293 | 503 | MBK8223127.1 serine/threonine protein kinase [Candidatus Obscuribacter sp.] | diamond | 2604 | 150 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29761047 | 29761047 | PRJNA498309_P_NODE_97731_length_199_cov_6.833333_g95582_i0 | PRJNA498309 | 97731 | 199 | 6.833333 | 13.59833267 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 100 | 9.18e-23 | NR | OGI19960.1 | 1801607 | g95582 | i0 | 84.2 | 0.85929648241206 | 57 | 8 | 85.9 | 1 | 27 | 197 | 326 | 381 | OGI19960.1 MAG: hypothetical protein A3B68_00245 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 171 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12 | |||||
| 30993355 | 30993355 | PRJNA498309_P_NODE_19634_length_657_cov_1.624194_g17839_i0 | PRJNA498309 | 19634 | 657 | 1.624194 | 10.67095458 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 215 | 1.8e-61 | NR | MBK8223127.1 | 2711154 | g17839 | i0 | 54.9 | 3.95433789954338 | 215 | 91 | 96.8 | 4 | 17 | 652 | 354 | 565 | MBK8223127.1 serine/threonine protein kinase [Candidatus Obscuribacter sp.] | diamond | 2598 | 215 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31277673 | 31277673 | PRJNA498309_P_NODE_98215_length_198_cov_3.503106_g96066_i0 | PRJNA498309 | 98215 | 198 | 3.503106 | 6.93614988 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 59.7 | 1.42e-8 | NR | OGI20854.1 | 1801607 | g96066 | i0 | 76.9 | 0.590909090909091 | 39 | 7 | 56.1 | 1 | 197 | 87 | 164 | 202 | OGI20854.1 MAG: hypothetical protein A3B68_10010 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 117 | 59.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12 | |||||
| 31435837 | 31435837 | PRJNA498309_P_NODE_9716_length_974_cov_3.414088_g8307_i0 | PRJNA498309 | 9716 | 974 | 3.414088 | 33.25321712 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 328 | 2.8099999999999997e-103 | NR | MBL8084832.1 | 2711154 | g8307 | i0 | 98.2 | 1.05338809034908 | 171 | 3 | 52.7 | 0 | 446 | 958 | 1 | 171 | MBL8084832.1 protein kinase [Candidatus Obscuribacter sp.] | diamond | 1026 | 328 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31530975 | 31530975 | PRJNA498309_P_NODE_14276_length_784_cov_4.199465_g12663_i0 | PRJNA498309 | 14276 | 784 | 4.199465 | 32.9238056 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 155 | 2.7799999999999993e-42 | NR | OGI19019.1 | 1801607 | g12663 | i0 | 77.9 | 0.363520408163265 | 95 | 21 | 36.4 | 0 | 250 | 534 | 182 | 276 | OGI19019.1 MAG: hypothetical protein A3B68_07385 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 285 | 155 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12 | |||||
| 32100156 | 32100156 | PRJNA498309_P_NODE_45838_length_400_cov_3.865014_g43704_i0 | PRJNA498309 | 45838 | 400 | 3.865014 | 15.460056 | Candidatus Melainabacteria bacterium RIFCSPLOWO2_ | 2052166 | Bacteria | Bacteria | 123 | 4.11e-30 | NR | OGI13440.1 | 1801608 | g43704 | i0 | 66.7 | 0.72 | 96 | 32 | 72 | 0 | 396 | 109 | 405 | 500 | OGI13440.1 MAG: hypothetical protein A3I68_00750 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_02_FULL_35_15] | diamond | 288 | 123 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPLOWO2_02_FULL_35_15 | |||||
| 32321982 | 32321982 | PRJNA498309_P_NODE_37459_length_455_cov_5.287081_g35392_i0 | PRJNA498309 | 37459 | 455 | 5.287081 | 24.05621855 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 244 | 1.96e-77 | NR | MBI3591354.1 | 2052166 | g35392 | i0 | 78.5 | 2.84835164835165 | 144 | 31 | 94.9 | 0 | 434 | 3 | 47 | 190 | MBI3591354.1 radical SAM protein [Candidatus Melainabacteria bacterium] | diamond | 1296 | 244 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32480065 | 32480065 | PRJNA498309_P_NODE_51939_length_366_cov_7.386018_g49791_i0 | PRJNA498309 | 51939 | 366 | 7.386018 | 27.03282588 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 108 | 1.6899999999999999e-28 | NR | OGI18544.1 | 1801607 | g49791 | i0 | 96.6 | 0.483606557377049 | 59 | 2 | 48.4 | 0 | 177 | 353 | 1 | 59 | OGI18544.1 MAG: hypothetical protein A3B68_02110 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 177 | 108 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12 |
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);;