contig_metadata
8 rows where bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5673360 | 5673360 | PRJNA597223_P_NODE_84045_length_153_cov_2.830508_g82199_i0 | PRJNA597223 | 84045 | 153 | 2.830508 | 4.33067724 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 187 | 3.2899999999999992e-43 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g82199 | i0 | 89.262 | 35.281045751634 | 149 | 16 | 97 | 0 | 5 | 153 | 173667 | 173519 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 5398 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 6947324 | 6947324 | PRJNA597223_P_NODE_41046_length_222_cov_4.229947_g39200_i0 | PRJNA597223 | 41046 | 222 | 4.229947 | 9.39048234 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 298 | 2.29e-76 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g39200 | i0 | 90.991 | 42.1396396396396 | 222 | 18 | 99 | 2 | 1 | 221 | 3042839 | 3043059 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 9355 | 298 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 20971346 | 20971346 | PRJNA597223_P_NODE_40537_length_224_cov_2.671958_g38691_i0 | PRJNA597223 | 40537 | 224 | 2.671958 | 5.98518592 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 292 | 1.08e-74 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g38691 | i0 | 89.916 | 136.040178571429 | 238 | 8 | 99 | 4 | 1 | 222 | 1903937 | 1903700 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 30473 | 292 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 24795748 | 24795748 | PRJNA597223_P_NODE_8980_length_581_cov_3.164835_g7405_i0 | PRJNA597223 | 8980 | 581 | 3.164835 | 18.38769135 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 809 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g7405 | i0 | 91.91 | 47.6746987951807 | 581 | 44 | 99 | 3 | 2 | 581 | 3043261 | 3043839 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 27699 | 809 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 29713789 | 29713789 | PRJNA597223_P_NODE_87930_length_150_cov_2.973913_g86084_i0 | PRJNA597223 | 87930 | 150 | 2.973913 | 4.4608695 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 47.4 | 2.49e-4 | NR | HEY0779105.1 | 2510638 | g86084 | i0 | 84 | 2 | 25 | 4 | 50 | 0 | 75 | 1 | 274 | 298 | HEY0779105.1 Fe-S cluster assembly protein SufD [Gemmatirosa sp.] | diamond | 300 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 29890465 | 29890465 | PRJNA597223_P_NODE_80011_length_158_cov_0.943089_g78165_i0 | PRJNA597223 | 80011 | 158 | 0.943089 | 1.49008062 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 82.8 | 7.18e-19 | NR | HWP38410.1 | 2448054 | g78165 | i0 | 87.5 | 0.759493670886076 | 40 | 5 | 75.9 | 0 | 120 | 1 | 1 | 40 | HWP38410.1 2,3-bisphosphoglycerate-dependent phosphoglycerate mutase [Gemmatimonadales bacterium] | diamond | 120 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31881360 | 31881360 | PRJNA597223_P_NODE_29557_length_278_cov_3.168724_g27711_i0 | PRJNA597223 | 29557 | 278 | 3.168724 | 8.80905272 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 81.3 | 4.07e-18 | NR | HVD33131.1 | 2448054 | g27711 | i0 | 81.8 | 0.474820143884892 | 44 | 8 | 47.5 | 0 | 173 | 42 | 11 | 54 | HVD33131.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 132 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32860919 | 32860919 | PRJNA597223_P_NODE_74720_length_164_cov_1.689922_g72874_i0 | PRJNA597223 | 74720 | 164 | 1.689922 | 2.77147208 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 45.4 | 0.00142 | NR | HUF12398.1 | 2910168 | g72874 | i0 | 43.6 | 0.713414634146341 | 39 | 22 | 71.3 | 0 | 47 | 163 | 322 | 360 | HUF12398.1 hypothetical protein [Longimicrobiales bacterium] | diamond | 117 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales 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);;