contig_metadata
15 rows where bioproject = "PRJNA758088", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1203543 | 1203543 | PRJNA758088_P_NODE_272881_length_255_cov_1.269231_g265910_i0 | PRJNA758088 | 272881 | 255 | 1.269231 | 3.23653905 | Candidatus Gastranaerophilales bacterium HUM_11 | 1916216 | Bacteria | Bacteria | 175 | 1.13e-50 | NR | DAA99000.1 | 1916216 | g265910 | i0 | 98.8 | 0.988235294117647 | 84 | 1 | 98.8 | 0 | 254 | 3 | 84 | 167 | DAA99000.1 MAG TPA: F0F1 ATP synthase subunit beta [Candidatus Gastranaerophilales bacterium HUM_11] | diamond | 252 | 175 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_11 | ||||
| 17314222 | 17314222 | PRJNA758088_P_NODE_236254_length_277_cov_1.132353_g229283_i0 | PRJNA758088 | 236254 | 277 | 1.132353 | 3.13661781 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 180 | 4.38e-51 | NR | DAA86874.1 | 1916218 | g229283 | i0 | 97.8 | 0.996389891696751 | 92 | 2 | 99.6 | 0 | 277 | 2 | 196 | 287 | DAA86874.1 MAG TPA: hypothetical protein CPT99_05950 [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 276 | 180 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 18586492 | 18586492 | PRJNA758088_P_NODE_143215_length_352_cov_0.989247_g136244_i0 | PRJNA758088 | 143215 | 352 | 0.989247 | 3.48214944 | Bacillati | 1783272 | Bacteria | Bacteria | 241 | 2.08e-78 | NR | DAA87679.1 | 1916214 | g136244 | i0 | 100 | 1.99431818181818 | 117 | 0 | 99.7 | 0 | 1 | 351 | 110 | 226 | DAA87679.1 MAG TPA: hypothetical protein CPT82_00080 [Candidatus Gastranaerophilales bacterium HUM_2] | diamond | 702 | 241 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_2 | ||||
| 19863716 | 19863716 | PRJNA758088_P_NODE_282536_length_251_cov_0.865169_g275565_i0 | PRJNA758088 | 282536 | 251 | 0.865169 | 2.17157419 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 267 | 7.459999999999999e-67 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g275565 | i0 | 88.688 | 309.804780876494 | 221 | 21 | 87 | 4 | 2 | 220 | 597324 | 597542 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 77761 | 267 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27306018 | 27306018 | PRJNA758088_P_NODE_347003_length_243_cov_0.905882_g340032_i0 | PRJNA758088 | 347003 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 157 | 5.11e-45 | NR | RAI14162.1 | 2052166 | g340032 | i0 | 98.8 | 0.987654320987654 | 80 | 1 | 98.8 | 0 | 242 | 3 | 96 | 175 | RAI14162.1 MAG: ribosome small subunit-dependent GTPase A [Candidatus Melainabacteria bacterium] | diamond | 240 | 157 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27748182 | 27748182 | PRJNA758088_P_NODE_193344_length_306_cov_0.991416_g186373_i0 | PRJNA758088 | 193344 | 306 | 0.991416 | 3.03373296 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 128 | 5.75e-36 | NR | DAA86880.1 | 1916218 | g186373 | i0 | 100 | 0.666666666666667 | 68 | 0 | 66.7 | 0 | 102 | 305 | 1 | 68 | DAA86880.1 MAG TPA: plasmid mobilization relaxosome protein MobC [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 204 | 128 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 27937531 | 27937531 | PRJNA758088_P_NODE_370005_length_226_cov_2.013072_g363034_i0 | PRJNA758088 | 370005 | 226 | 2.013072 | 4.54954272 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 55.1 | 6.44e-7 | NR | DAA86876.1 | 1916218 | g363034 | i0 | 84.8 | 0.438053097345133 | 33 | 5 | 43.8 | 0 | 223 | 125 | 169 | 201 | DAA86876.1 MAG TPA: hypothetical protein CPT99_05960 [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 99 | 55.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 28505749 | 28505749 | PRJNA758088_P_NODE_367627_length_241_cov_0.869048_g360656_i0 | PRJNA758088 | 367627 | 241 | 0.869048 | 2.09440568 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 84 | 8.44e-17 | NR | MCR5260934.1 | 2137880 | g360656 | i0 | 45 | 0.995850622406639 | 80 | 44 | 99.6 | 0 | 2 | 241 | 307 | 386 | MCR5260934.1 OprO/OprP family phosphate-selective porin [Candidatus Gastranaerophilales bacterium] | diamond | 240 | 84 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 28632270 | 28632270 | PRJNA758088_P_NODE_52107_length_614_cov_0.996303_g45360_i0 | PRJNA758088 | 52107 | 614 | 0.996303 | 6.11730042 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 380 | 1.16e-127 | NR | DAA86879.1 | 1916218 | g45360 | i0 | 98 | 0.996742671009772 | 204 | 4 | 99.7 | 0 | 1 | 612 | 280 | 483 | DAA86879.1 MAG TPA: hypothetical protein CPT99_05975 [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 612 | 380 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 28663697 | 28663697 | PRJNA758088_P_NODE_294287_length_250_cov_0.870056_g287316_i0 | PRJNA758088 | 294287 | 250 | 0.870056 | 2.17514 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 106 | 1.48e-24 | NR | DAA86879.1 | 1916218 | g287316 | i0 | 96.7 | 0.72 | 60 | 2 | 72 | 0 | 1 | 180 | 483 | 542 | DAA86879.1 MAG TPA: hypothetical protein CPT99_05975 [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 180 | 106 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 28758290 | 28758290 | PRJNA758088_P_NODE_357687_length_242_cov_0.911243_g350716_i0 | PRJNA758088 | 357687 | 242 | 0.911243 | 2.20520806 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 150 | 1.21e-41 | NR | RAI13371.1 | 2052166 | g350716 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 29 | 108 | RAI13371.1 MAG: hypothetical protein DK841_03730 [Candidatus Melainabacteria bacterium] | diamond | 240 | 150 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28821185 | 28821185 | PRJNA758088_P_NODE_357728_length_242_cov_0.911243_g350757_i0 | PRJNA758088 | 357728 | 242 | 0.911243 | 2.20520806 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 69.3 | 1.48e-11 | NR | MCR5260933.1 | 2137880 | g350757 | i0 | 51.4 | 0.867768595041322 | 70 | 34 | 86.8 | 0 | 212 | 3 | 129 | 198 | MCR5260933.1 OprO/OprP family phosphate-selective porin [Candidatus Gastranaerophilales bacterium] | diamond | 210 | 69.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 30590017 | 30590017 | PRJNA758088_P_NODE_263033_length_261_cov_1.180851_g256062_i0 | PRJNA758088 | 263033 | 261 | 1.180851 | 3.08202111 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 146 | 2.9099999999999998e-40 | NR | AOR38575.1 | 1899017 | g256062 | i0 | 86 | 0.988505747126437 | 86 | 12 | 98.9 | 0 | 2 | 259 | 207 | 292 | AOR38575.1 hypothetical protein BHV42_04860 [Candidatus Melainabacteria bacterium MEL.A1] | diamond | 258 | 146 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 30906260 | 30906260 | PRJNA758088_P_NODE_38614_length_745_cov_1.488095_g32324_i0 | PRJNA758088 | 38614 | 745 | 1.488095 | 11.08630775 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 460 | 1.88e-155 | NR | DAA86860.1 | 1916218 | g32324 | i0 | 100 | 0.934228187919463 | 232 | 0 | 93.4 | 0 | 697 | 2 | 1 | 232 | DAA86860.1 MAG TPA: conjugal transfer protein [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 696 | 460 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 | ||||
| 31348707 | 31348707 | PRJNA758088_P_NODE_49516_length_634_cov_1.283422_g42811_i0 | PRJNA758088 | 49516 | 634 | 1.283422 | 8.13689548 | Candidatus Gastranaerophilales bacterium HUM_4 | 1916218 | Bacteria | Bacteria | 149 | 5.51e-43 | NR | DAA86875.1 | 1916218 | g42811 | i0 | 98.7 | 0.369085173501577 | 78 | 1 | 36.9 | 0 | 52 | 285 | 1 | 78 | DAA86875.1 MAG TPA: hypothetical protein CPT99_05955 [Candidatus Gastranaerophilales bacterium HUM_4] | diamond | 234 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_4 |
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);;