contig_metadata
8 rows where bioproject = "PRJNA1068830", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9110776 | 9110776 | PRJNA1068830_P_NODE_60168_length_280_cov_2.212560_g59465_i0 | PRJNA1068830 | 60168 | 280 | 2.21256 | 6.195168 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 374 | 4.849999999999998e-99 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g59465 | i0 | 90.845 | 112.260714285714 | 284 | 18 | 100 | 6 | 1 | 280 | 3042596 | 3042317 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 31433 | 374 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 11661753 | 11661753 | PRJNA1068830_P_NODE_59150_length_283_cov_1.390476_g58447_i0 | PRJNA1068830 | 59150 | 283 | 1.390476 | 3.93504708 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 204 | 6.809999999999998e-48 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g58447 | i0 | 85.096 | 29.4840989399293 | 208 | 21 | 73 | 9 | 37 | 242 | 954188 | 953989 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 8344 | 204 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 15486266 | 15486266 | PRJNA1068830_P_NODE_74753_length_251_cov_1.775281_g74050_i0 | PRJNA1068830 | 74753 | 251 | 1.775281 | 4.45595531 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 294 | 3.4200000000000003e-75 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g74050 | i0 | 89.54 | 0.952191235059761 | 239 | 15 | 95 | 7 | 1 | 239 | 673526 | 673298 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 239 | 294 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26750439 | 26750439 | PRJNA1068830_P_NODE_85461_length_244_cov_0.912281_g84758_i0 | PRJNA1068830 | 85461 | 244 | 0.912281 | 2.22596564 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 57 | 1.78e-7 | NR | MFB3112079.1 | 2448054 | g84758 | i0 | 50.8 | 3.20901639344262 | 63 | 29 | 77.5 | 1 | 51 | 239 | 128 | 188 | MFB3112079.1 CAP domain-containing protein [Gemmatimonadales bacterium] | diamond | 783 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27003909 | 27003909 | PRJNA1068830_P_NODE_60722_length_279_cov_1.514563_g60019_i0 | PRJNA1068830 | 60722 | 279 | 1.514563 | 4.22563077 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 52.4 | 2.36e-5 | NR | HEV8362459.1 | 2026741 | g60019 | i0 | 45.2 | 1 | 93 | 48 | 100 | 2 | 1 | 279 | 156 | 245 | HEV8362459.1 glycosyltransferase family 39 protein [Gemmatimonadaceae bacterium] | diamond | 279 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27415276 | 27415276 | PRJNA1068830_P_NODE_83363_length_245_cov_1.360465_g82660_i0 | PRJNA1068830 | 83363 | 245 | 1.360465 | 3.33313925 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 50.8 | 3.62e-5 | NR | NNE08328.1 | 2026742 | g82660 | i0 | 36.3 | 0.979591836734694 | 80 | 37 | 98 | 2 | 242 | 3 | 45 | 110 | NNE08328.1 iron-sulfur cluster repair di-iron protein [Gemmatimonadota bacterium] | diamond | 240 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29435446 | 29435446 | PRJNA1068830_P_NODE_90770_length_227_cov_2.331169_g90067_i0 | PRJNA1068830 | 90770 | 227 | 2.331169 | 5.29175363 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 50.4 | 5.83e-5 | NR | HEV7993743.1 | 2026741 | g90067 | i0 | 37.9 | 1.71806167400881 | 66 | 40 | 87.2 | 1 | 24 | 221 | 554 | 618 | HEV7993743.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] | diamond | 390 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29877908 | 29877908 | PRJNA1068830_P_NODE_63691_length_272_cov_1.306533_g62988_i0 | PRJNA1068830 | 63691 | 272 | 1.306533 | 3.5537697600000002 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 82.8 | 4.18e-16 | NR | HEY6061030.1 | 2448054 | g62988 | i0 | 47.2 | 2.94485294117647 | 89 | 43 | 98.2 | 1 | 270 | 4 | 296 | 380 | HEY6061030.1 Ig-like domain-containing protein [Gemmatimonadales bacterium] | diamond | 801 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales 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);;