contig_metadata
4 rows where bioproject = "PRJNA631796", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8256542 | 8256542 | PRJNA631796_P_NODE_12967_length_202_cov_0.893617_g12689_i0 | PRJNA631796 | 12967 | 202 | 0.893617 | 1.80510634 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 261 | 2.68e-65 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g12689 | i0 | 90.099 | 331.306930693069 | 202 | 19 | 100 | 1 | 1 | 202 | 8175923 | 8176123 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 66924 | 261 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 9531962 | 9531962 | PRJNA631796_S_NODE_2488_length_402_cov_1.838710_g2321_i0 | PRJNA631796 | 2488 | 402 | 1.83871 | 7.3916142 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 473 | 6.939999999999999e-129 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g2321 | i0 | 88.06 | 64.81592039801 | 402 | 44 | 100 | 4 | 1 | 402 | 1903824 | 1903427 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 26056 | 473 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18455440 | 18455440 | PRJNA631796_P_NODE_12795_length_202_cov_1.418440_g12517_i0 | PRJNA631796 | 12795 | 202 | 1.41844 | 2.8652488 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 252 | 1.62e-62 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g12517 | i0 | 89.268 | 282.034653465347 | 205 | 16 | 100 | 6 | 1 | 202 | 1904528 | 1904729 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 56971 | 252 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 22829428 | 22829428 | PRJNA631796_P_NODE_10518_length_213_cov_1.684211_g10240_i0 | PRJNA631796 | 10518 | 213 | 1.684211 | 3.58736943 | Gemmatimonas | 173479 | Bacteria | Bacteria | 388 | 1.26e-103 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g10240 | i0 | 99.531 | 141.953051643192 | 213 | 1 | 100 | 0 | 1 | 213 | 1309 | 1097 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 30236 | 388 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca |
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);;