contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA879067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9783211 | 9783211 | PRJNA879067_P_NODE_51888_length_509_cov_5.133028_g48404_i0 | PRJNA879067 | 51888 | 509 | 5.133028 | 26.12711252 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 284 | 2.89e-89 | NR | MCE2942190.1 | 2026742 | g48404 | i0 | 87.5 | 2.9705304518664 | 168 | 21 | 99 | 0 | 6 | 509 | 199 | 366 | MCE2942190.1 Ig-like domain-containing protein [Gemmatimonadota bacterium] | diamond | 1512 | 284 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 9783603 | 9783603 | PRJNA879067_P_NODE_65788_length_412_cov_2.061947_g62303_i0 | PRJNA879067 | 65788 | 412 | 2.061947 | 8.49522164 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 267 | 1.14e-80 | NR | MEE8596102.1 | 2026742 | g62303 | i0 | 100 | 0.990291262135922 | 136 | 0 | 99 | 0 | 412 | 5 | 966 | 1101 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 408 | 267 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28421532 | 28421532 | PRJNA879067_P_NODE_103826_length_250_cov_1.271186_g100340_i0 | PRJNA879067 | 103826 | 250 | 1.271186 | 3.177965 | FCB group | 1783270 | Bacteria | Bacteria | 100 | 2.02e-22 | NR | WP_331126789.1 | 2029185 | g100340 | i0 | 56.6 | 5.88 | 83 | 36 | 99.6 | 0 | 2 | 250 | 3100 | 3182 | WP_331126789.1 methylaspartate mutase subunit E [Longimicrobium sp.] | diamond | 1470 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28950303 | 28950303 | PRJNA879067_P_NODE_82828_length_327_cov_2.094488_g79342_i0 | PRJNA879067 | 82828 | 327 | 2.094488 | 6.84897576 | Roseisolibacter agri | 2014610 | Bacteria | Bacteria | 162 | 8.51e-44 | NR | WP_284351566.1 | 2014610 | g79342 | i0 | 85.3 | 0.935779816513762 | 102 | 15 | 93.6 | 0 | 22 | 327 | 94 | 195 | WP_284351566.1 TonB-dependent receptor [Roseisolibacter agri] | diamond | 306 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 29171204 | 29171204 | PRJNA879067_P_NODE_54669_length_487_cov_8.584541_g51184_i0 | PRJNA879067 | 54669 | 487 | 8.584541 | 41.80671467 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.1 | 0.0346 | NR | MCU0633675.1 | 2026741 | g51184 | i0 | 34.7 | 0.4435318275154 | 72 | 37 | 44.4 | 2 | 137 | 352 | 100 | 161 | MCU0633675.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 216 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32236987 | 32236987 | PRJNA879067_P_NODE_50718_length_519_cov_1.715247_g47236_i0 | PRJNA879067 | 50718 | 519 | 1.715247 | 8.90213193 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 282 | 1.1999999999999998e-88 | NR | MFN0099248.1 | 2026741 | g47236 | i0 | 91.9 | 0.930635838150289 | 161 | 13 | 93.1 | 0 | 6 | 488 | 233 | 393 | MFN0099248.1 protein kinase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 483 | 282 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32489901 | 32489901 | PRJNA879067_P_NODE_109239_length_243_cov_0.905882_g105753_i0 | PRJNA879067 | 109239 | 243 | 0.905882 | 2.20129326 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 115 | 1.71e-28 | NR | HYW13966.1 | 2029185 | g105753 | i0 | 70 | 3.95061728395062 | 80 | 24 | 98.8 | 0 | 241 | 2 | 263 | 342 | HYW13966.1 hypothetical protein [Longimicrobium sp.] | diamond | 960 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. |
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);;