contig_metadata
6 rows where bioproject = "PRJNA825466", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3371311 | 3371311 | PRJNA825466_P_NODE_8083_length_306_cov_2.725322_g7982_i0 | PRJNA825466 | 8083 | 306 | 2.725322 | 8.33948532 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 132 | 3.56e-26 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g7982 | i0 | 75.333 | 42.6601307189542 | 300 | 60 | 96 | 12 | 2 | 294 | 273058 | 273350 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 13054 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 14848492 | 14848492 | PRJNA825466_P_NODE_21432_length_247_cov_0.885057_g21331_i0 | PRJNA825466 | 21432 | 247 | 0.885057 | 2.18609079 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 257 | 4.41e-64 | NTclustered | gi|148566298|gb|CP000686.1| | 357808 | g21331 | i0 | 85.657 | 133.259109311741 | 251 | 29 | 100 | 7 | 1 | 247 | 2807546 | 2807299 | Roseiflexus sp. RS-1, complete genome | blastn | 32915 | 257 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 25454728 | 25454728 | PRJNA825466_P_NODE_11360_length_279_cov_1.121359_g11259_i0 | PRJNA825466 | 11360 | 279 | 1.121359 | 3.12859161 | Roseiflexus | 120961 | Bacteria | Bacteria | 220 | 6.66e-53 | NTclustered | gi|470482403|ref|NR_076530.1| | 120962 | g11259 | i0 | 85.321 | 4.20430107526882 | 218 | 27 | 77 | 5 | 50 | 265 | 1442 | 1228 | Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence | blastn | 1173 | 220 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus castenholzii | ||
| 27275787 | 27275787 | PRJNA825466_P_NODE_12163_length_274_cov_1.502488_g12062_i0 | PRJNA825466 | 12163 | 274 | 1.502488 | 4.11681712 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.2 | 0.0295 | NR | MCH7739436.1 | 2026724 | g12062 | i0 | 39.2 | 0.81021897810219 | 74 | 33 | 75.5 | 4 | 62 | 268 | 6 | 72 | MCH7739436.1 hypothetical protein [Chloroflexota bacterium] | diamond | 222 | 41.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27979077 | 27979077 | PRJNA825466_P_NODE_16585_length_251_cov_0.865169_g16484_i0 | PRJNA825466 | 16585 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 2.07e-4 | NR | MCL0090175.1 | 2026734 | g16484 | i0 | 37.5 | 4.43426294820717 | 72 | 42 | 82.5 | 2 | 239 | 33 | 1448 | 1519 | MCL0090175.1 carboxypeptidase regulatory-like domain-containing protein [Dehalococcoidia bacterium] | diamond | 1113 | 49.7 | 0.991951710261569 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30212275 | 30212275 | PRJNA825466_P_NODE_23272_length_245_cov_1.732558_g23171_i0 | PRJNA825466 | 23272 | 245 | 1.732558 | 4.2447671 | Thermanaerothrix daxensis | 869279 | Bacteria | Bacteria | 42.7 | 0.0311 | NR | WP_054520173.1 | 869279 | g23171 | i0 | 36.8 | 0.83265306122449 | 68 | 39 | 83.3 | 2 | 30 | 233 | 33 | 96 | WP_054520173.1 hypothetical protein [Thermanaerothrix daxensis] | diamond | 204 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Thermanaerothrix | Thermanaerothrix daxensis |
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);;