contig_metadata
7 rows where bioproject = "PRJNA630877", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8256274 | 8256274 | PRJNA630877_S_NODE_153687_length_155_cov_1.491228_g134550_i0 | PRJNA630877 | 153687 | 155 | 1.491228 | 2.3114034 | Gemmatimonas groenlandica | 2732249 | Bacteria | Bacteria | 204 | 3.32e-48 | NTclustered | gi|1839994010|gb|CP053085.1| | 2732249 | g134550 | i0 | 98.276 | 181.374193548387 | 116 | 2 | 75 | 0 | 23 | 138 | 1103221 | 1103106 | Gemmatimonas groenlandica strain TET16 chromosome, complete genome | blastn | 28113 | 204 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas groenlandica | |
| 18455174 | 18455174 | PRJNA630877_S_NODE_105415_length_215_cov_1.954023_g86278_i0 | PRJNA630877 | 105415 | 215 | 1.954023 | 4.20114945 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 329 | 7.82e-86 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g86278 | i0 | 96.04 | 180.125581395349 | 202 | 8 | 94 | 0 | 1 | 202 | 3043469 | 3043268 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 38727 | 329 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 28028527 | 28028527 | PRJNA630877_S_NODE_99585_length_228_cov_1.941176_g80448_i0 | PRJNA630877 | 99585 | 228 | 1.941176 | 4.42588128 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 45.1 | 0.00478 | NR | HEX8212631.1 | 2029185 | g80448 | i0 | 36.9 | 0.855263157894737 | 65 | 36 | 78.9 | 2 | 4 | 183 | 80 | 144 | HEX8212631.1 IS1634 family transposase [Longimicrobium sp.] | diamond | 195 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28059928 | 28059928 | PRJNA630877_S_NODE_41785_length_726_cov_10.655474_g24665_i0 | PRJNA630877 | 41785 | 726 | 10.655474 | 77.35874124 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 46.6 | 0.0134 | NR | CAA9353806.1 | 246130 | g24665 | i0 | 38.8 | 0.479338842975207 | 116 | 63 | 44.6 | 2 | 452 | 129 | 21 | 136 | CAA9353806.1 MAG: Transcriptional regulator, HxlR family, partial [uncultured Gemmatimonadaceae bacterium] | diamond | 348 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 28217574 | 28217574 | PRJNA630877_S_NODE_146366_length_161_cov_1.591667_g127229_i0 | PRJNA630877 | 146366 | 161 | 1.591667 | 2.56258387 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 41.2 | 0.043 | NR | MBT5056333.1 | 2026742 | g127229 | i0 | 60 | 0.559006211180124 | 30 | 8 | 48.4 | 1 | 66 | 143 | 168 | 197 | MBT5056333.1 glycoside hydrolase family 3 protein [Gemmatimonadota bacterium] | diamond | 90 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31060599 | 31060599 | PRJNA630877_S_NODE_119875_length_190_cov_2.026846_g100738_i0 | PRJNA630877 | 119875 | 190 | 2.026846 | 3.8510074 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 40.8 | 0.0495 | NR | MFN5600415.1 | 1962908 | g100738 | i0 | 36.5 | 0.821052631578947 | 52 | 33 | 82.1 | 0 | 17 | 172 | 15 | 66 | MFN5600415.1 ferredoxin [Gemmatimonas sp.] | diamond | 156 | 40.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 32452344 | 32452344 | PRJNA630877_S_NODE_86319_length_268_cov_1.859031_g67182_i0 | PRJNA630877 | 86319 | 268 | 1.859031 | 4.98220308 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 43.5 | 0.0266 | NR | HSM05919.1 | 2910168 | g67182 | i0 | 35.2 | 0.604477611940298 | 54 | 31 | 60.4 | 1 | 253 | 92 | 212 | 261 | HSM05919.1 FAD-binding oxidoreductase [Longimicrobiales bacterium] | diamond | 162 | 43.5 | 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);;