contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1859473 | 1859473 | PRJNA606583_P_NODE_29162_length_198_cov_1.453416_g28733_i0 | PRJNA606583 | 29162 | 198 | 1.453416 | 2.87776368 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 209 | 9.63e-50 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g28733 | i0 | 87.5 | 6.03030303030303 | 184 | 19 | 92 | 4 | 15 | 196 | 274329 | 274510 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 1194 | 209 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5687299 | 5687299 | PRJNA606583_P_NODE_31445_length_187_cov_1.086667_g31016_i0 | PRJNA606583 | 31445 | 187 | 1.086667 | 2.03206729 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 237 | 4.12e-58 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g31016 | i0 | 93.671 | 110.005347593583 | 158 | 10 | 84 | 0 | 1 | 158 | 1857619 | 1857776 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 20571 | 237 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10787812 | 10787812 | PRJNA606583_P_NODE_19849_length_269_cov_1.978448_g19420_i0 | PRJNA606583 | 19849 | 269 | 1.978448 | 5.32202512 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 193 | 1.39e-44 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g19420 | i0 | 80.297 | 6.55018587360595 | 269 | 41 | 97 | 9 | 3 | 264 | 273068 | 273331 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 1762 | 193 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 13337804 | 13337804 | PRJNA606583_P_NODE_5971_length_555_cov_3.395753_g5567_i0 | PRJNA606583 | 5971 | 555 | 3.395753 | 18.84642915 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 202 | 5.129999999999999e-47 | NTclustered | gi|2621701384|emb|OY760104.1| | 2026734 | g5567 | i0 | 77.062 | 44.9189189189189 | 388 | 65 | 68 | 21 | 179 | 555 | 3255281 | 3254907 | MAG: Dehalococcoidia bacterium isolate 85321599-0a94-4039-bbde-d148f9b3e6b5 genome assembly, chromosome: 1 | blastn | 24930 | 202 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 18435622 | 18435622 | PRJNA606583_P_NODE_19015_length_278_cov_1.294606_g18586_i0 | PRJNA606583 | 19015 | 278 | 1.294606 | 3.59900468 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 241 | 5.09e-59 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g18586 | i0 | 82.5 | 119.032374100719 | 280 | 44 | 100 | 4 | 1 | 278 | 274974 | 274698 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 33091 | 241 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20985857 | 20985857 | PRJNA606583_P_NODE_17097_length_300_cov_2.049430_g16668_i0 | PRJNA606583 | 17097 | 300 | 2.04943 | 6.14829 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 274 | 5.47e-69 | NTclustered | gi|2874253766|emb|OY969711.1| | 1672391 | g16668 | i0 | 83.66 | 134.64 | 306 | 34 | 99 | 15 | 1 | 299 | 239575 | 239871 | MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1 | blastn | 40392 | 274 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia 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);;