contig_metadata
11 rows where bioproject = "PRJNA1249042", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4181302 | 4181302 | PRJNA1249042_S_NODE_103424_length_159_cov_1.241379_g103210_i0 | PRJNA1249042 | 103424 | 159 | 1.241379 | 1.97379261 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 124 | 2.75e-24 | NTclustered | gi|2874254062|emb|OY970386.1| | 1672391 | g103210 | i0 | 82.979 | 95.9056603773585 | 141 | 21 | 87 | 3 | 1 | 139 | 1891727 | 1891866 | MAG: uncultured Chloroflexia bacterium isolate MFD03726.bin.c.14 genome assembly, chromosome: 1 | blastn | 15249 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 15657116 | 15657116 | PRJNA1249042_S_NODE_109833_length_154_cov_2.954955_g109619_i0 | PRJNA1249042 | 109833 | 154 | 2.954955 | 4.5506307 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 156 | 9.359999999999999e-34 | NTclustered | gi|2874254132|emb|OY970217.1| | 1672391 | g109619 | i0 | 88.976 | 116.331168831169 | 127 | 12 | 82 | 2 | 29 | 154 | 3522619 | 3522494 | MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1 | blastn | 17915 | 156 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 15657733 | 15657733 | PRJNA1249042_S_NODE_86273_length_172_cov_2.581395_g86059_i0 | PRJNA1249042 | 86273 | 172 | 2.581395 | 4.4399994 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 65.8 | 1.85e-6 | NTclustered | gi|2621704001|emb|OY762956.1| | 2026734 | g86059 | i0 | 95.238 | 0.488372093023256 | 42 | 1 | 24 | 1 | 132 | 172 | 1512772 | 1512731 | MAG: Dehalococcoidia bacterium isolate caf6cba7-c187-4a53-abc2-184ab5dfaca7 genome assembly, chromosome: 1 | blastn | 84 | 65.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 22031198 | 22031198 | PRJNA1249042_S_NODE_3838_length_445_cov_6.783582_g3626_i0 | PRJNA1249042 | 3838 | 445 | 6.783582 | 30.1869399 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 366 | 1.3499999999999996e-96 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g3626 | i0 | 82.529 | 139.955056179775 | 435 | 58 | 96 | 18 | 18 | 445 | 1281 | 858 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 62280 | 366 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 22031448 | 22031448 | PRJNA1249042_S_NODE_66018_length_191_cov_4.486486_g65804_i0 | PRJNA1249042 | 66018 | 191 | 4.486486 | 8.56918826 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 196 | 7.17e-46 | NTclustered | gi|2893356046|emb|OZ220469.1| | 3069543 | g65804 | i0 | 85.417 | 227.03664921466 | 192 | 25 | 100 | 3 | 1 | 191 | 2202982 | 2202793 | MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1 | blastn | 43364 | 196 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 24581033 | 24581033 | PRJNA1249042_S_NODE_6220_length_356_cov_2.469649_g6006_i0 | PRJNA1249042 | 6220 | 356 | 2.469649 | 8.79195044 | Candidatus Chlorohelix allophototropha | 3003348 | Bacteria | Bacteria | 388 | 2.26e-103 | NTclustered | gi|2530750984|gb|CP128400.1| | 3003348 | g6006 | i0 | 86.723 | 866.634831460674 | 354 | 41 | 100 | 5 | 4 | 356 | 320832 | 320484 | Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence | blastn | 308522 | 388 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Chloroheliales | Candidatus Chloroheliaceae | Candidatus Chlorohelix | Candidatus Chlorohelix allophototropha | ||
| 29410366 | 29410366 | PRJNA1249042_S_NODE_47549_length_213_cov_2.358824_g47335_i0 | PRJNA1249042 | 47549 | 213 | 2.358824 | 5.02429512 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.0249 | NR | MCE9645369.1 | 2026724 | g47335 | i0 | 44.4 | 0.507042253521127 | 36 | 20 | 50.7 | 0 | 32 | 139 | 351 | 386 | MCE9645369.1 M1 family metallopeptidase [Chloroflexota bacterium] | diamond | 108 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29694275 | 29694275 | PRJNA1249042_S_NODE_16830_length_275_cov_1.418103_g16616_i0 | PRJNA1249042 | 16830 | 275 | 1.418103 | 3.89978325 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.5 | 0.0298 | NR | MCC6191996.1 | 2073117 | g16616 | i0 | 50 | 0.610909090909091 | 56 | 26 | 60 | 2 | 170 | 6 | 727 | 781 | MCC6191996.1 GAF domain-containing protein [Anaerolineales bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31053391 | 31053391 | PRJNA1249042_S_NODE_106815_length_156_cov_2.955752_g106601_i0 | PRJNA1249042 | 106815 | 156 | 2.955752 | 4.61097312 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.2 | 0.0401 | NR | NLG28053.1 | 2026724 | g106601 | i0 | 41.5 | 0.788461538461538 | 41 | 24 | 78.8 | 0 | 130 | 8 | 297 | 337 | NLG28053.1 DNRLRE domain-containing protein [Chloroflexota bacterium] | diamond | 123 | 41.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32413329 | 32413329 | PRJNA1249042_S_NODE_105539_length_157_cov_2.473684_g105325_i0 | PRJNA1249042 | 105539 | 157 | 2.473684 | 3.88368388 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 80.9 | 2.89e-16 | NR | MBX7112445.1 | 2026734 | g105325 | i0 | 73.9 | 0.878980891719745 | 46 | 12 | 87.9 | 0 | 3 | 140 | 64 | 109 | MBX7112445.1 MaoC family dehydratase N-terminal domain-containing protein [Dehalococcoidia bacterium] | diamond | 138 | 80.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32571628 | 32571628 | PRJNA1249042_S_NODE_78759_length_179_cov_1.727941_g78545_i0 | PRJNA1249042 | 78759 | 179 | 1.727941 | 3.09301439 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 59.7 | 6.7e-9 | NR | MDD5702901.1 | 2026733 | g78545 | i0 | 63 | 0.770949720670391 | 46 | 17 | 77.1 | 0 | 178 | 41 | 120 | 165 | MDD5702901.1 DUF4125 family protein [Dehalococcoidales bacterium] | diamond | 138 | 59.7 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales 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);;