contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1037671 | 1037671 | PRJNA1158727_P_NODE_51701_length_485_cov_2.444175_g44244_i0 | PRJNA1158727 | 51701 | 485 | 2.444175 | 11.85424875 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 297 | 5.999999999999999e-101 | NR | MBX9724270.1 | 2364082 | g44244 | i0 | 89.4 | 0.989690721649485 | 160 | 17 | 99 | 0 | 1 | 480 | 7 | 166 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 480 | 297 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 21981033 | 21981033 | PRJNA1158727_P_NODE_153958_length_244_cov_0.900585_g146496_i0 | PRJNA1158727 | 153958 | 244 | 0.900585 | 2.1974274 | Bacillati | 1783272 | Bacteria | Bacteria | 120 | 1.87e-32 | NR | MBX2861300.1 | 2717857 | g146496 | i0 | 68.4 | 11.7540983606557 | 79 | 25 | 97.1 | 0 | 6 | 242 | 20 | 98 | MBX2861300.1 nucleoside-diphosphate kinase [Vampirovibrio sp.] | diamond | 2868 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio sp. | ||
| 23255678 | 23255678 | PRJNA1158727_P_NODE_116839_length_271_cov_1.393939_g109378_i0 | PRJNA1158727 | 116839 | 271 | 1.393939 | 3.77757469 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 86.7 | 1.79e-17 | NR | MDZ4837454.1 | 2052166 | g109378 | i0 | 69 | 0.929889298892989 | 84 | 20 | 87.5 | 3 | 237 | 1 | 1 | 83 | MDZ4837454.1 S8/S53 family peptidase [Candidatus Melainabacteria bacterium] | diamond | 252 | 86.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27040373 | 27040373 | PRJNA1158727_P_NODE_146202_length_247_cov_0.885057_g138740_i0 | PRJNA1158727 | 146202 | 247 | 0.885057 | 2.18609079 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 147 | 1.02e-40 | NR | MBX3152067.1 | 2364082 | g138740 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 2 | 247 | 99 | 180 | MBX3152067.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 246 | 147 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27324854 | 27324854 | PRJNA1158727_P_NODE_124703_length_262_cov_1.365079_g117242_i0 | PRJNA1158727 | 124703 | 262 | 1.365079 | 3.57650698 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 176 | 2.34e-50 | NR | MBX9672434.1 | 2364082 | g117242 | i0 | 100 | 0.99618320610687 | 87 | 0 | 99.6 | 0 | 261 | 1 | 467 | 553 | MBX9672434.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 261 | 176 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28461747 | 28461747 | PRJNA1158727_P_NODE_123386_length_263_cov_2.073684_g115925_i0 | PRJNA1158727 | 123386 | 263 | 2.073684 | 5.45378892 | Candidatus Obscuribacter phosphatis | 1906157 | Bacteria | Bacteria | 96.7 | 4.3700000000000005e-21 | NR | MBN8662705.1 | 1906157 | g115925 | i0 | 56 | 0.958174904942966 | 84 | 37 | 95.8 | 0 | 261 | 10 | 297 | 380 | MBN8662705.1 tetratricopeptide repeat protein [Candidatus Obscuribacter phosphatis] | diamond | 252 | 96.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter phosphatis | ||
| 29996686 | 29996686 | PRJNA1158727_P_NODE_165391_length_235_cov_2.697531_g157929_i0 | PRJNA1158727 | 165391 | 235 | 2.697531 | 6.33919785 | Bacteria | 2 | Bacteria | Bacteria | 146 | 2.31e-41 | NR | MDZ4838004.1 | 2052166 | g157929 | i0 | 90.9 | 1.96595744680851 | 77 | 7 | 98.3 | 0 | 235 | 5 | 27 | 103 | MDZ4838004.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 462 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30356814 | 30356814 | PRJNA1158727_P_NODE_134592_length_251_cov_1.595506_g127130_i0 | PRJNA1158727 | 134592 | 251 | 1.595506 | 4.00472006 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 54.7 | 8.26e-7 | NR | MBX9570187.1 | 2364082 | g127130 | i0 | 64.9 | 1.30278884462151 | 37 | 13 | 44.2 | 0 | 251 | 141 | 135 | 171 | MBX9570187.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 327 | 54.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30925248 | 30925248 | PRJNA1158727_P_NODE_149934_length_246_cov_0.890173_g142472_i0 | PRJNA1158727 | 149934 | 246 | 0.890173 | 2.18982558 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 145 | 4.66e-41 | NR | MBN9393606.1 | 2052166 | g142472 | i0 | 92.6 | 0.98780487804878 | 81 | 6 | 98.8 | 0 | 3 | 245 | 38 | 118 | MBN9393606.1 nickel pincer cofactor biosynthesis protein LarB [Candidatus Melainabacteria bacterium] | diamond | 243 | 145 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31177497 | 31177497 | PRJNA1158727_P_NODE_136075_length_251_cov_0.865169_g128613_i0 | PRJNA1158727 | 136075 | 251 | 0.865169 | 2.17157419 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 146 | 4.51e-39 | NR | MBY0547976.1 | 2364082 | g128613 | i0 | 86.7 | 0.99203187250996006 | 83 | 11 | 99.2 | 0 | 251 | 3 | 10 | 92 | MBY0547976.1 AMP-binding protein [Candidatus Obscuribacterales bacterium] | diamond | 249 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31177515 | 31177515 | PRJNA1158727_P_NODE_159155_length_242_cov_1.455621_g151693_i0 | PRJNA1158727 | 159155 | 242 | 1.455621 | 3.52260282 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 112 | 1.02e-27 | NR | MDP3508660.1 | 2052166 | g151693 | i0 | 61.3 | 1.98347107438017 | 80 | 31 | 99.2 | 0 | 3 | 242 | 254 | 333 | MDP3508660.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 480 | 112 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31873561 | 31873561 | PRJNA1158727_P_NODE_156817_length_243_cov_0.905882_g149355_i0 | PRJNA1158727 | 156817 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 73.9 | 1.49e-14 | NR | MBC8000228.1 | 2052166 | g149355 | i0 | 80.5 | 0.506172839506173 | 41 | 8 | 50.6 | 0 | 3 | 125 | 101 | 141 | MBC8000228.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 123 | 73.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32695524 | 32695524 | PRJNA1158727_P_NODE_157400_length_243_cov_0.905882_g149938_i0 | PRJNA1158727 | 157400 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 170 | 1.18e-49 | NR | MBN9396708.1 | 2052166 | g149938 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 242 | 3 | 259 | 338 | MBN9396708.1 beta-lactamase family protein [Candidatus Melainabacteria bacterium] | diamond | 240 | 170 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;