contig_metadata
7 rows where bioproject = "PRJNA340009" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18244055 | 18244055 | PRJNA340009_P_NODE_67115_length_165_cov_0.879310_g66808_i0 | PRJNA340009 | 67115 | 165 | 0.87931 | 1.4508615 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 94 | 7.360000000000001e-21 | NR | MCD6336996.1 | 2026760 | g66808 | i0 | 78 | 1.81818181818182 | 50 | 11 | 90.9 | 0 | 11 | 160 | 264 | 313 | MCD6336996.1 phosphopyruvate hydratase [Fidelibacterota bacterium] | diamond | 300 | 94 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 26948052 | 26948052 | PRJNA340009_P_NODE_61302_length_167_cov_3.025424_g60995_i0 | PRJNA340009 | 61302 | 167 | 3.025424 | 5.05245808 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 103 | 4.47e-25 | NR | MCH7733298.1 | 2026760 | g60995 | i0 | 83.3 | 11.6407185628743 | 54 | 9 | 97 | 0 | 6 | 167 | 1 | 54 | MCH7733298.1 class II glutamine amidotransferase [Fidelibacterota bacterium] | diamond | 1944 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27200925 | 27200925 | PRJNA340009_P_NODE_14682_length_309_cov_0.903846_g14375_i0 | PRJNA340009 | 14682 | 309 | 0.903846 | 2.79288414 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 100 | 2.1599999999999998e-23 | NR | MCJ7802071.1 | 2026760 | g14375 | i0 | 50 | 0.951456310679612 | 98 | 47 | 93.2 | 2 | 1 | 288 | 154 | 251 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 294 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28734185 | 28734185 | PRJNA340009_P_NODE_45147_length_191_cov_1.718310_g44840_i0 | PRJNA340009 | 45147 | 191 | 1.71831 | 3.2819721 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 106 | 5.67e-26 | NR | MFB0515946.1 | 2026760 | g44840 | i0 | 85.7 | 2.96858638743455 | 63 | 9 | 99 | 0 | 191 | 3 | 40 | 102 | MFB0515946.1 pyridoxal-phosphate dependent enzyme [Fidelibacterota bacterium] | diamond | 567 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28748473 | 28748473 | PRJNA340009_P_NODE_7647_length_403_cov_2.302260_g7340_i0 | PRJNA340009 | 7647 | 403 | 2.30226 | 9.2781078 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 48.9 | 0.00148 | NR | MBT5268102.1 | 2026760 | g7340 | i0 | 36.1 | 0.722084367245658 | 97 | 53 | 71.5 | 3 | 383 | 96 | 980 | 1068 | MBT5268102.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 291 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29916954 | 29916954 | PRJNA340009_P_NODE_8611_length_385_cov_1.485119_g8304_i0 | PRJNA340009 | 8611 | 385 | 1.485119 | 5.71770815 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 65.9 | 1.56e-9 | NR | MBT5268102.1 | 2026760 | g8304 | i0 | 32.8 | 0.950649350649351 | 122 | 69 | 94.3 | 2 | 1 | 363 | 869 | 978 | MBT5268102.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 366 | 65.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32256459 | 32256459 | PRJNA340009_P_NODE_67818_length_165_cov_0.870690_g67511_i0 | PRJNA340009 | 67818 | 165 | 0.87069 | 1.4366385 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 83.6 | 5.41e-17 | NR | MDD5229691.1 | 2026760 | g67511 | i0 | 76.4 | 1 | 55 | 13 | 100 | 0 | 1 | 165 | 234 | 288 | MDD5229691.1 primase C-terminal domain-containing protein [Fidelibacterota bacterium] | diamond | 165 | 83.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;