contig_metadata
6 rows where bioproject = "PRJNA1218818" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7987204 | 7987204 | PRJNA1218818_P_NODE_26907_length_245_cov_0.895349_g26840_i0 | PRJNA1218818 | 26907 | 245 | 0.895349 | 2.19360505 | Flavobacterium sp. H122 | 2529860 | Bacteria | Bacteria | 145 | 3.93e-38 | NR | WP_136667232.1 | 2529860 | g26840 | i0 | 92.5 | 1.95918367346939 | 80 | 6 | 98 | 0 | 243 | 4 | 73 | 152 | WP_136667232.1 carboxypeptidase-like regulatory domain-containing protein [Flavobacterium sp. H122] | diamond | 480 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. H122 | |
| 9261638 | 9261638 | PRJNA1218818_P_NODE_1348_length_1001_cov_2.010776_g1302_i0 | PRJNA1218818 | 1348 | 1001 | 2.010776 | 20.12786776 | Flavobacterium oreochromis | 2906078 | Bacteria | Bacteria | 1633 | 0 | NTclustered | gi|2079163087|gb|CP067377.1| | 2906078 | g1302 | i0 | 96.104 | 555.716283716284 | 1001 | 39 | 100 | 0 | 1 | 1001 | 3066 | 4066 | Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome | blastn | 556272 | 1633 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium oreochromis | |
| 16910805 | 16910805 | PRJNA1218818_P_NODE_17954_length_294_cov_1.914027_g17887_i0 | PRJNA1218818 | 17954 | 294 | 1.914027 | 5.62723938 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 226 | 1.52e-54 | NTclustered | gi|2621786419|emb|OY782877.1| | 2030809 | g17887 | i0 | 80.612 | 26.4047619047619 | 294 | 56 | 100 | 1 | 1 | 294 | 2441891 | 2441599 | MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1 | blastn | 7763 | 226 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 25272502 | 25272502 | PRJNA1218818_P_NODE_20220_length_278_cov_0.995122_g20153_i0 | PRJNA1218818 | 20220 | 278 | 0.995122 | 2.76643916 | Emticicia | 312278 | Bacteria | Bacteria | 431 | 2.81e-116 | NTclustered | gi|470489174|ref|NR_076911.1| | 312279 | g20153 | i0 | 94.604 | 288.579136690647 | 278 | 15 | 100 | 0 | 1 | 278 | 308 | 31 | Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence | blastn | 80225 | 431 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia oligotrophica | |
| 28083332 | 28083332 | PRJNA1218818_P_NODE_24965_length_249_cov_0.875000_g24898_i0 | PRJNA1218818 | 24965 | 249 | 0.875 | 2.17875 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 112 | 7.53e-29 | NR | HEX5439172.1 | 2026741 | g24898 | i0 | 73.1 | 0.939759036144578 | 78 | 21 | 94 | 0 | 14 | 247 | 57 | 134 | HEX5439172.1 recombinase family protein [Gemmatimonadaceae bacterium] | diamond | 234 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29883346 | 29883346 | PRJNA1218818_P_NODE_29271_length_234_cov_3.826087_g29204_i0 | PRJNA1218818 | 29271 | 234 | 3.826087 | 8.95304358 | Phocaeicola vulgatus | 821 | Bacteria | Bacteria | 40 | 0.0398 | NR | WP_227238842.1 | 821 | g29204 | i0 | 40 | 1.02564102564103 | 40 | 22 | 48.7 | 1 | 133 | 20 | 11 | 50 | WP_227238842.1 hypothetical protein, partial [Phocaeicola vulgatus] | diamond | 240 | 40 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola vulgatus |
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);;