contig_metadata
13 rows where bioproject = "PRJNA473824", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11925719 | 11925719 | PRJNA473824_P_NODE_51330_length_174_cov_1.065693_g50692_i0 | PRJNA473824 | 51330 | 174 | 1.065693 | 1.85430582 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 126 | 8.5e-25 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g50692 | i0 | 86.726 | 92.5747126436782 | 113 | 15 | 65 | 0 | 5 | 117 | 3680970 | 3681082 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 16108 | 126 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28039987 | 28039987 | PRJNA473824_P_NODE_93405_length_173_cov_2.919118_g92767_i0 | PRJNA473824 | 93405 | 173 | 2.919118 | 5.05007414 | Bacillati | 1783272 | Bacteria | Bacteria | 44.3 | 0.00117 | NR | MBP6595610.1 | 2711154 | g92767 | i0 | 44.3 | 2.98265895953757 | 61 | 17 | 76.3 | 1 | 42 | 173 | 37 | 97 | MBP6595610.1 glutathionylspermidine synthase family protein [Candidatus Obscuribacter sp.] | diamond | 516 | 44.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28402705 | 28402705 | PRJNA473824_P_NODE_65566_length_173_cov_4.250000_g64928_i0 | PRJNA473824 | 65566 | 173 | 4.25 | 7.3525 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 50.4 | 2.72e-5 | NR | MBX9722032.1 | 2364082 | g64928 | i0 | 100 | 2.60115606936416 | 25 | 0 | 43.4 | 0 | 173 | 99 | 187 | 211 | MBX9722032.1 hybrid sensor histidine kinase/response regulator [Candidatus Obscuribacterales bacterium] | diamond | 450 | 50.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28560690 | 28560690 | PRJNA473824_P_NODE_97647_length_173_cov_2.816176_g97009_i0 | PRJNA473824 | 97647 | 173 | 2.816176 | 4.87198448 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 55.1 | 6.41e-7 | NR | MBX9674823.1 | 2364082 | g97009 | i0 | 100 | 0.433526011560694 | 25 | 0 | 43.4 | 0 | 99 | 173 | 207 | 231 | MBX9674823.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 75 | 55.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28812793 | 28812793 | PRJNA473824_P_NODE_165748_length_150_cov_4.327434_g165110_i0 | PRJNA473824 | 165748 | 150 | 4.327434 | 6.491151 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 43.5 | 0.00541 | NR | MBX9571458.1 | 2364082 | g165110 | i0 | 66.7 | 1.54 | 27 | 9 | 54 | 0 | 82 | 2 | 83 | 109 | MBX9571458.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 231 | 43.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28971038 | 28971038 | PRJNA473824_P_NODE_139068_length_151_cov_6.166667_g138430_i0 | PRJNA473824 | 139068 | 151 | 6.166667 | 9.31166717 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 75.1 | 1.35e-14 | NR | MBX9573477.1 | 2364082 | g138430 | i0 | 58.9 | 1.45033112582781 | 73 | 6 | 97.4 | 1 | 149 | 3 | 120 | 192 | MBX9573477.1 phenylacetate-CoA oxygenase subunit PaaI [Candidatus Obscuribacterales bacterium] | diamond | 219 | 75.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29254939 | 29254939 | PRJNA473824_P_NODE_77089_length_173_cov_3.544118_g76451_i0 | PRJNA473824 | 77089 | 173 | 3.544118 | 6.13132414 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 55.1 | 6.41e-7 | NR | RTL35277.1 | 2052166 | g76451 | i0 | 100 | 0.398843930635838 | 23 | 0 | 39.9 | 0 | 103 | 171 | 186 | 208 | RTL35277.1 MAG: FMN-binding glutamate synthase family protein [Candidatus Melainabacteria bacterium] | diamond | 69 | 55.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29712948 | 29712948 | PRJNA473824_P_NODE_112570_length_173_cov_2.433824_g111932_i0 | PRJNA473824 | 112570 | 173 | 2.433824 | 4.21051552 | Candidatus Obscuribacter | 1906156 | Bacteria | Bacteria | 90.5 | 2.16e-19 | NR | MBI5174969.1 | 2052166 | g111932 | i0 | 74.6 | 5.46242774566474 | 63 | 10 | 98.8 | 1 | 1 | 171 | 119 | 181 | MBI5174969.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 945 | 90.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30644768 | 30644768 | PRJNA473824_P_NODE_161513_length_150_cov_10.123894_g160875_i0 | PRJNA473824 | 161513 | 150 | 10.123894 | 15.185841 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 43.1 | 0.00757 | NR | MDP3507551.1 | 2052166 | g160875 | i0 | 76 | 0.5 | 25 | 6 | 50 | 0 | 149 | 75 | 270 | 294 | MDP3507551.1 serine protease [Candidatus Melainabacteria bacterium] | diamond | 75 | 43.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30882190 | 30882190 | PRJNA473824_P_NODE_115894_length_172_cov_6.970370_g115256_i0 | PRJNA473824 | 115894 | 172 | 6.97037 | 11.9890364 | Bacillati | 1783272 | Bacteria | Bacteria | 49.7 | 4.91e-5 | NR | MCA0316358.1 | 2052166 | g115256 | i0 | 95.8 | 3.76744186046512 | 24 | 1 | 41.9 | 0 | 170 | 99 | 225 | 248 | MCA0316358.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 648 | 49.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31735699 | 31735699 | PRJNA473824_P_NODE_110117_length_173_cov_2.551471_g109479_i0 | PRJNA473824 | 110117 | 173 | 2.551471 | 4.41404483 | Candidatus Obscuribacter | 1906156 | Bacteria | Bacteria | 50.8 | 2.02e-5 | NR | MBI5171476.1 | 2052166 | g109479 | i0 | 96 | 1.30057803468208 | 25 | 1 | 43.4 | 0 | 98 | 172 | 480 | 504 | MBI5171476.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium] | diamond | 225 | 50.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32020647 | 32020647 | PRJNA473824_P_NODE_145218_length_151_cov_4.359649_g144580_i0 | PRJNA473824 | 145218 | 151 | 4.359649 | 6.58306999 | Bacillati | 1783272 | Bacteria | Bacteria | 54.7 | 6.15e-7 | NR | RTL45337.1 | 2052166 | g144580 | i0 | 95.8 | 1.9271523178807899 | 24 | 1 | 47.7 | 0 | 2 | 73 | 296 | 319 | RTL45337.1 MAG: response regulator transcription factor [Candidatus Melainabacteria bacterium] | diamond | 291 | 54.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32368895 | 32368895 | PRJNA473824_P_NODE_79739_length_173_cov_3.397059_g79101_i0 | PRJNA473824 | 79739 | 173 | 3.397059 | 5.87691207 | Bacillati | 1783272 | Bacteria | Bacteria | 49.3 | 1.02e-5 | NR | MBN9396858.1 | 2052166 | g79101 | i0 | 95.8 | 10.8208092485549 | 24 | 1 | 41.6 | 0 | 3 | 74 | 1 | 24 | MBN9396858.1 RNA-binding S4 domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 1872 | 49.3 | 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);;