contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5773285 | 5773285 | PRJNA690124_P_NODE_53485_length_244_cov_0.912281_g53119_i0 | PRJNA690124 | 53485 | 244 | 0.912281 | 2.22596564 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 191 | 4.47e-44 | NTclustered | gi|2893358407|emb|OZ220698.1| | 2026734 | g53119 | i0 | 87.574 | 39.2049180327869 | 169 | 16 | 68 | 5 | 79 | 244 | 1183172 | 1183338 | MAG: Dehalococcoidia bacterium isolate 1c31877f-31fb-4be5-889e-2983ccd84c47 genome assembly, chromosome: 1 | blastn | 9566 | 191 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 8322613 | 8322613 | PRJNA690124_P_NODE_43647_length_253_cov_0.866667_g43281_i0 | PRJNA690124 | 43647 | 253 | 0.866667 | 2.19266751 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 265 | 2.71e-66 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g43281 | i0 | 86.92 | 2.78656126482213 | 237 | 29 | 93 | 2 | 15 | 250 | 3354730 | 3354965 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 705 | 265 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10873747 | 10873747 | PRJNA690124_P_NODE_53789_length_244_cov_0.912281_g53423_i0 | PRJNA690124 | 53789 | 244 | 0.912281 | 2.22596564 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 178 | 3.48e-40 | NTclustered | gi|2874253698|emb|OY969424.1| | 1672391 | g53423 | i0 | 80.328 | 35.4877049180328 | 244 | 41 | 99 | 6 | 1 | 242 | 1768096 | 1767858 | MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1 | blastn | 8659 | 178 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 16481418 | 16481418 | PRJNA690124_P_NODE_42973_length_253_cov_1.316667_g42607_i0 | PRJNA690124 | 42973 | 253 | 1.316667 | 3.33116751 | Chloroflexota | 200795 | Bacteria | Bacteria | 315 | 2.65e-81 | NTclustered | gi|470475646|ref|NR_076292.1| | 167964 | g42607 | i0 | 89.6 | 144.0395256917 | 250 | 22 | 98 | 4 | 2 | 250 | 2695 | 2941 | Anaerolinea thermophila strain UNI-1 23S ribosomal RNA gene, complete sequence | blastn | 36442 | 318 | 0.990566037735849 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea thermophila | ||
| 21072000 | 21072000 | PRJNA690124_P_NODE_46937_length_250_cov_0.881356_g46571_i0 | PRJNA690124 | 46937 | 250 | 0.881356 | 2.20339 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 193 | 1.28e-44 | NTclustered | gi|2893358456|emb|OZ220748.1| | 2026734 | g46571 | i0 | 82.791 | 0.86 | 215 | 37 | 86 | 0 | 36 | 250 | 2872523 | 2872309 | MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1 | blastn | 215 | 193 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 21072021 | 21072021 | PRJNA690124_P_NODE_47877_length_249_cov_0.886364_g47511_i0 | PRJNA690124 | 47877 | 249 | 0.886364 | 2.20704636 | Tepidiformaceae bacterium | 3022862 | Bacteria | Bacteria | 152 | 2.1599999999999998e-32 | NTclustered | gi|2531948656|emb|OY282446.1| | 3022862 | g47511 | i0 | 84.277 | 0.63855421686747 | 159 | 21 | 63 | 4 | 25 | 181 | 727472 | 727628 | MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1 | blastn | 159 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiformaceae 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);;