contig_metadata
6 rows where bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18680985 | 18680985 | PRJNA839281_S_NODE_28235_length_166_cov_0.871795_g27966_i0 | PRJNA839281 | 28235 | 166 | 0.871795 | 1.4471797 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2621705867|emb|OY763929.1| | 2026734 | g27966 | i0 | 96.97 | 2.36144578313253 | 33 | 1 | 20 | 0 | 68 | 100 | 851680 | 851712 | MAG: Dehalococcoidia bacterium isolate b8c59f79-82fb-4549-ad1a-ab6c7f2c8c82 genome assembly, chromosome: 1 | blastn | 392 | 56.5 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 19956260 | 19956260 | PRJNA839281_S_NODE_35916_length_162_cov_0.902655_g35647_i0 | PRJNA839281 | 35916 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 87.4 | 2.2e-18 | NR | MBI5668246.1 | 2026724 | g35647 | i0 | 77.8 | 3 | 54 | 12 | 100 | 0 | 162 | 1 | 97 | 150 | MBI5668246.1 glutamine-hydrolyzing GMP synthase [Chloroflexota bacterium] | diamond | 486 | 87.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28286197 | 28286197 | PRJNA839281_S_NODE_28666_length_166_cov_0.871795_g28397_i0 | PRJNA839281 | 28666 | 166 | 0.871795 | 1.4471797 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.2 | 1.59e-8 | NR | MBP1705809.1 | 2026724 | g28397 | i0 | 84.4 | 1.68072289156627 | 32 | 5 | 57.8 | 0 | 61 | 156 | 78 | 109 | MBP1705809.1 indole acetimide hydrolase [Chloroflexota bacterium] | diamond | 279 | 58.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29044347 | 29044347 | PRJNA839281_S_NODE_37388_length_161_cov_0.910714_g37119_i0 | PRJNA839281 | 37388 | 161 | 0.910714 | 1.46624954 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 106 | 1.7700000000000002e-27 | NR | HQJ32977.1 | 2024896 | g37119 | i0 | 98.1 | 2.96273291925466 | 53 | 1 | 98.8 | 0 | 161 | 3 | 69 | 121 | HQJ32977.1 aspartate/glutamate racemase family protein [Anaerolineaceae bacterium] | diamond | 477 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 30157700 | 30157700 | PRJNA839281_S_NODE_21752_length_180_cov_1.167939_g21483_i0 | PRJNA839281 | 21752 | 180 | 1.167939 | 2.1022902 | Chloroflexota | 200795 | Bacteria | Bacteria | 67.8 | 2.27e-11 | NR | HKZ69802.1 | 2073117 | g21483 | i0 | 64 | 2.6 | 50 | 18 | 83.3 | 0 | 29 | 178 | 4 | 53 | HKZ69802.1 aspartate aminotransferase family protein [Anaerolineales bacterium] | diamond | 468 | 68.2 | 0.994134897360704 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31738084 | 31738084 | PRJNA839281_S_NODE_23717_length_174_cov_1.424000_g23448_i0 | PRJNA839281 | 23717 | 174 | 1.424 | 2.47776 | Bacteria | 2 | Bacteria | Bacteria | 98.6 | 1.99e-22 | NR | PWH12686.1 | 2052143 | g23448 | i0 | 76.4 | 4.79310344827586 | 55 | 13 | 94.8 | 0 | 3 | 167 | 253 | 307 | PWH12686.1 MAG: aspartate aminotransferase family protein [Anaerolineae bacterium] | diamond | 834 | 98.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae 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);;