contig_metadata
6 rows where bioproject = "PRJNA909412", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9818577 | 9818577 | PRJNA909412_P_NODE_3728_length_272_cov_2.287554_g3587_i0 | PRJNA909412 | 3728 | 272 | 2.287554 | 6.22214688 | Candidatus Chlorohelix allophototropha | 3003348 | Bacteria | Bacteria | 235 | 2.31e-57 | NTclustered | gi|2530750984|gb|CP128400.1| | 3003348 | g3587 | i0 | 95.862 | 324.654411764706 | 145 | 6 | 53 | 0 | 61 | 205 | 319752 | 319896 | Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence | blastn | 88306 | 235 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Chloroheliales | Candidatus Chloroheliaceae | Candidatus Chlorohelix | Candidatus Chlorohelix allophototropha | ||
| 13644363 | 13644363 | PRJNA909412_P_NODE_9251_length_176_cov_2.693431_g9110_i0 | PRJNA909412 | 9251 | 176 | 2.693431 | 4.74043856 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 185 | 1.4e-42 | NTclustered | gi|2874253706|emb|OY969433.1| | 1672391 | g9110 | i0 | 91.241 | 227.556818181818 | 137 | 10 | 77 | 2 | 41 | 176 | 1066057 | 1066192 | MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1 | blastn | 40050 | 185 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 14918686 | 14918686 | PRJNA909412_P_NODE_4812_length_238_cov_2.065327_g4671_i0 | PRJNA909412 | 4812 | 238 | 2.065327 | 4.91547826 | Ktedonosporobacter rubrisoli | 2509675 | Bacteria | Bacteria | 211 | 3.33e-50 | NTclustered | gi|1574824432|gb|CP035758.1| | 2509675 | g4671 | i0 | 82.988 | 9.22689075630252 | 241 | 34 | 100 | 6 | 1 | 238 | 4663220 | 4663456 | Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome | blastn | 2196 | 211 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter rubrisoli | ||
| 23842944 | 23842944 | PRJNA909412_P_NODE_3899_length_266_cov_2.797357_g3758_i0 | PRJNA909412 | 3899 | 266 | 2.797357 | 7.44096962 | Thermosporothrix sp. COM3 | 2490863 | Bacteria | Bacteria | 263 | 1.03e-65 | NTclustered | gi|1606557374|dbj|AP019376.1| | 2490863 | g3758 | i0 | 83.212 | 368.575187969925 | 274 | 38 | 100 | 2 | 1 | 266 | 5335167 | 5334894 | Thermosporothrix sp. COM3 DNA, nearly complete genome | blastn | 98041 | 263 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Thermosporotrichaceae | Thermosporothrix | Thermosporothrix sp. COM3 | ||
| 27663878 | 27663878 | PRJNA909412_P_NODE_1464_length_455_cov_3.367788_g1325_i0 | PRJNA909412 | 1464 | 455 | 3.367788 | 15.3234354 | Bacillati | 1783272 | Bacteria | Bacteria | 77.4 | 1.94e-14 | NR | MFO8037463.1 | 2073117 | g1325 | i0 | 50 | 5.98681318681319 | 78 | 39 | 51.4 | 0 | 46 | 279 | 105 | 182 | MFO8037463.1 hypothetical protein [Anaerolineales bacterium] | diamond | 2724 | 77.8 | 0.994858611825193 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32332642 | 32332642 | PRJNA909412_P_NODE_5319_length_226_cov_2.090909_g5178_i0 | PRJNA909412 | 5319 | 226 | 2.090909 | 4.72545434 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 72 | 1.4e-12 | NR | MCC7365802.1 | 2026734 | g5178 | i0 | 47.4 | 4.00884955752212 | 76 | 39 | 99.6 | 1 | 2 | 226 | 324 | 399 | MCC7365802.1 aminopeptidase P family protein [Dehalococcoidia bacterium] | diamond | 906 | 72 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia 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);;