contig_metadata
19 rows where bioproject = "PRJNA404067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10618830 | 10618830 | PRJNA404067_P_NODE_6229_length_506_cov_4.800000_g5854_i0 | PRJNA404067 | 6229 | 506 | 4.8 | 24.288 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 294 | 7.45e-75 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g5854 | i0 | 78.395 | 64.998023715415 | 486 | 81 | 93 | 18 | 33 | 502 | 3680916 | 3681393 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 32889 | 294 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 26695470 | 26695470 | PRJNA404067_P_NODE_12301_length_300_cov_2.602510_g11915_i0 | PRJNA404067 | 12301 | 300 | 2.60251 | 7.80753 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 155 | 1.7299999999999996e-41 | NR | MBX9570039.1 | 2364082 | g11915 | i0 | 94.8 | 0.77 | 77 | 4 | 77 | 0 | 69 | 299 | 599 | 675 | MBX9570039.1 HDIG domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 231 | 155 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 26965534 | 26965534 | PRJNA404067_P_NODE_17142_length_251_cov_2.757895_g16755_i0 | PRJNA404067 | 17142 | 251 | 2.757895 | 6.92231645 | Bacillati | 1783272 | Bacteria | Bacteria | 142 | 3.69e-37 | NR | RTL39330.1 | 2052166 | g16755 | i0 | 89.2 | 3.94422310756972 | 83 | 9 | 99.2 | 0 | 251 | 3 | 293 | 375 | RTL39330.1 MAG: K(+)-transporting ATPase subunit B [Candidatus Melainabacteria bacterium] | diamond | 990 | 142 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27012105 | 27012105 | PRJNA404067_P_NODE_21862_length_231_cov_1.582353_g21475_i0 | PRJNA404067 | 21862 | 231 | 1.582353 | 3.65523543 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 134 | 1.58e-38 | NR | MBX3137685.1 | 2364082 | g21475 | i0 | 100 | 0.909090909090909 | 70 | 0 | 90.9 | 0 | 210 | 1 | 1 | 70 | MBX3137685.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 210 | 134 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28117578 | 28117578 | PRJNA404067_P_NODE_23305_length_227_cov_1.945783_g22918_i0 | PRJNA404067 | 23305 | 227 | 1.945783 | 4.4169274100000004 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 154 | 3.65e-44 | NR | HNB22795.1 | 2052166 | g22918 | i0 | 100 | 0.991189427312775 | 75 | 0 | 99.1 | 0 | 226 | 2 | 24 | 98 | HNB22795.1 SpoIID/LytB domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 225 | 154 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28812021 | 28812021 | PRJNA404067_P_NODE_34508_length_205_cov_1.208333_g34121_i0 | PRJNA404067 | 34508 | 205 | 1.208333 | 2.47708265 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 120 | 9.579999999999999e-30 | NR | MBN9394845.1 | 2052166 | g34121 | i0 | 91 | 0.980487804878049 | 67 | 6 | 98 | 0 | 3 | 203 | 1215 | 1281 | MBN9394845.1 HAMP domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 201 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29002205 | 29002205 | PRJNA404067_P_NODE_16848_length_253_cov_3.531250_g16461_i0 | PRJNA404067 | 16848 | 253 | 3.53125 | 8.9340625 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 109 | 1.2799999999999999e-28 | NR | MBK9774683.1 | 2711154 | g16461 | i0 | 91.5 | 0.699604743083004 | 59 | 5 | 70 | 0 | 252 | 76 | 78 | 136 | MBK9774683.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 177 | 109 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29002216 | 29002216 | PRJNA404067_P_NODE_28528_length_214_cov_2.143791_g28141_i0 | PRJNA404067 | 28528 | 214 | 2.143791 | 4.58771274 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 144 | 3.81e-41 | NR | MBX9878677.1 | 2364082 | g28141 | i0 | 100 | 0.995327102803738 | 71 | 0 | 99.5 | 0 | 213 | 1 | 88 | 158 | MBX9878677.1 ATP-dependent Clp protease proteolytic subunit [Candidatus Obscuribacterales bacterium] | diamond | 213 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29159847 | 29159847 | PRJNA404067_P_NODE_35589_length_204_cov_0.895105_g35202_i0 | PRJNA404067 | 35589 | 204 | 0.895105 | 1.8260142 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 134 | 9.23e-37 | NR | MBX9674559.1 | 2364082 | g35202 | i0 | 100 | 1 | 68 | 0 | 100 | 0 | 204 | 1 | 39 | 106 | MBX9674559.1 peptidylprolyl isomerase [Candidatus Obscuribacterales bacterium] | diamond | 204 | 134 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29380661 | 29380661 | PRJNA404067_P_NODE_35529_length_204_cov_0.895105_g35142_i0 | PRJNA404067 | 35529 | 204 | 0.895105 | 1.8260142 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 82 | 2.64e-16 | NR | MBI3589887.1 | 2052166 | g35142 | i0 | 87.8 | 0.720588235294118 | 49 | 6 | 72.1 | 0 | 9 | 155 | 379 | 427 | MBI3589887.1 glutamate dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 147 | 82 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30201571 | 30201571 | PRJNA404067_P_NODE_38572_length_201_cov_1.050000_g38185_i0 | PRJNA404067 | 38572 | 201 | 1.05 | 2.1105 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 80.9 | 2.19e-17 | NR | MBI2996169.1 | 2052166 | g38185 | i0 | 60.6 | 1.97014925373134 | 66 | 26 | 98.5 | 0 | 200 | 3 | 3 | 68 | MBI2996169.1 PIN domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 396 | 80.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30360256 | 30360256 | PRJNA404067_P_NODE_11912_length_306_cov_2.122449_g11526_i0 | PRJNA404067 | 11912 | 306 | 2.122449 | 6.49469394 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 202 | 2.35e-58 | NR | MBN9394209.1 | 2052166 | g11526 | i0 | 97.1 | 1 | 102 | 3 | 100 | 0 | 306 | 1 | 456 | 557 | MBN9394209.1 polynucleotide kinase-phosphatase [Candidatus Melainabacteria bacterium] | diamond | 306 | 202 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30517780 | 30517780 | PRJNA404067_P_NODE_8533_length_382_cov_5.959502_g8150_i0 | PRJNA404067 | 8533 | 382 | 5.959502 | 22.76529764 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 96.3 | 2.3000000000000003e-22 | NR | MBX9689059.1 | 2364082 | g8150 | i0 | 74.2 | 0.486910994764398 | 62 | 16 | 48.7 | 0 | 152 | 337 | 1 | 62 | MBX9689059.1 cupin domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 186 | 96.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30833716 | 30833716 | PRJNA404067_P_NODE_23674_length_226_cov_2.103030_g23287_i0 | PRJNA404067 | 23674 | 226 | 2.10303 | 4.7528478 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 86.3 | 1.43e-17 | NR | PZM77752.1 | 2052166 | g23287 | i0 | 100 | 1.0353982300885 | 39 | 0 | 51.8 | 0 | 109 | 225 | 109 | 147 | PZM77752.1 MAG: transaldolase [Candidatus Melainabacteria bacterium] | diamond | 234 | 86.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30850373 | 30850373 | PRJNA404067_P_NODE_36514_length_203_cov_0.901408_g36127_i0 | PRJNA404067 | 36514 | 203 | 0.901408 | 1.82985824 | Bacillati | 1783272 | Bacteria | Bacteria | 89.4 | 7.35e-19 | NR | MBK9144660.1 | 2052166 | g36127 | i0 | 55.2 | 2.97044334975369 | 67 | 30 | 99 | 0 | 3 | 203 | 392 | 458 | MBK9144660.1 MBOAT family protein [Candidatus Melainabacteria bacterium] | diamond | 603 | 89.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31497709 | 31497709 | PRJNA404067_P_NODE_28136_length_215_cov_2.214286_g27749_i0 | PRJNA404067 | 28136 | 215 | 2.214286 | 4.7607149 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 61.2 | 7.31e-9 | NR | MBX9688526.1 | 2364082 | g27749 | i0 | 78.4 | 0.516279069767442 | 37 | 8 | 51.6 | 0 | 200 | 90 | 165 | 201 | MBX9688526.1 UDP-N-acetylglucosamine 2-epimerase (non-hydrolyzing) [Candidatus Obscuribacterales bacterium] | diamond | 111 | 61.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31655515 | 31655515 | PRJNA404067_P_NODE_5917_length_533_cov_2.866525_g5547_i0 | PRJNA404067 | 5917 | 533 | 2.866525 | 15.27857825 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 200 | 7.399999999999999e-56 | NR | MCC7527392.1 | 2052166 | g5547 | i0 | 54.7 | 1.08067542213884 | 192 | 71 | 99.1 | 2 | 532 | 5 | 584 | 775 | MCC7527392.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Candidatus Melainabacteria bacterium] | diamond | 576 | 200 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31718957 | 31718957 | PRJNA404067_P_NODE_12337_length_299_cov_5.310924_g11951_i0 | PRJNA404067 | 12337 | 299 | 5.310924 | 15.87966276 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 68.2 | 3.41e-11 | NR | MBN9394277.1 | 2052166 | g11951 | i0 | 85.7 | 0.421404682274247 | 42 | 6 | 42.1 | 0 | 157 | 282 | 1 | 42 | MBN9394277.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 126 | 68.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31845352 | 31845352 | PRJNA404067_P_NODE_43957_length_174_cov_2.398230_g43570_i0 | PRJNA404067 | 43957 | 174 | 2.39823 | 4.1729202 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 60.1 | 1.52e-9 | NR | MBK9774681.1 | 2711154 | g43570 | i0 | 80.6 | 0.620689655172414 | 36 | 7 | 62.1 | 0 | 174 | 67 | 26 | 61 | MBK9774681.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 108 | 60.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. |
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);;