contig_metadata
8 rows where bioproject = "PRJNA756891", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008074 | 2008074 | PRJNA756891_P_NODE_9122_length_288_cov_1.432558_g9053_i0 | PRJNA756891 | 9122 | 288 | 1.432558 | 4.12576704 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 107 | 8.72e-25 | NR | MBC8256583.1 | 2026760 | g9053 | i0 | 56.3 | 2 | 96 | 39 | 100 | 1 | 1 | 288 | 208 | 300 | MBC8256583.1 DUF2817 domain-containing protein [Fidelibacterota bacterium] | diamond | 576 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 26609517 | 26609517 | PRJNA756891_P_NODE_1021_length_790_cov_3.075314_g961_i0 | PRJNA756891 | 1021 | 790 | 3.075314 | 24.2949806 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 270 | 2.69e-87 | NR | MCF7796703.1 | 2026760 | g961 | i0 | 55.1 | 6.78227848101266 | 256 | 112 | 96.8 | 3 | 776 | 12 | 4 | 257 | MCF7796703.1 SDR family NAD(P)-dependent oxidoreductase [Fidelibacterota bacterium] | diamond | 5358 | 270 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27653335 | 27653335 | PRJNA756891_P_NODE_11164_length_262_cov_1.613757_g11095_i0 | PRJNA756891 | 11164 | 262 | 1.613757 | 4.22804334 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 101 | 8.5e-25 | NR | MDP6966819.1 | 2026760 | g11095 | i0 | 62.1 | 1.99236641221374 | 87 | 33 | 99.6 | 0 | 262 | 2 | 24 | 110 | MDP6966819.1 adenine phosphoribosyltransferase [Fidelibacterota bacterium] | diamond | 522 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29421137 | 29421137 | PRJNA756891_P_NODE_2789_length_502_cov_3.055944_g2721_i0 | PRJNA756891 | 2789 | 502 | 3.055944 | 15.34083888 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 50.1 | 0.00129 | NR | MFL2982758.1 | 2026760 | g2721 | i0 | 31.6 | 0.681274900398406 | 114 | 69 | 65.7 | 4 | 345 | 16 | 249 | 357 | MFL2982758.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 342 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30495412 | 30495412 | PRJNA756891_P_NODE_12753_length_250_cov_0.870056_g12684_i0 | PRJNA756891 | 12753 | 250 | 0.870056 | 2.17514 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 114 | 2.53e-27 | NR | HIN20157.1 | 2026760 | g12684 | i0 | 62.8 | 2.016 | 86 | 29 | 99.6 | 1 | 2 | 250 | 185 | 270 | HIN20157.1 DUF2817 domain-containing protein [Fidelibacterota bacterium] | diamond | 504 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30937749 | 30937749 | PRJNA756891_P_NODE_5934_length_350_cov_0.953069_g5865_i0 | PRJNA756891 | 5934 | 350 | 0.953069 | 3.3357415 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 149 | 2.66e-40 | NR | HIM73637.1 | 2026760 | g5865 | i0 | 58.8 | 3.92571428571429 | 114 | 47 | 97.7 | 0 | 343 | 2 | 239 | 352 | HIM73637.1 peptidase M28 family protein [Fidelibacterota bacterium] | diamond | 1374 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31917862 | 31917862 | PRJNA756891_P_NODE_7677_length_312_cov_1.757322_g7608_i0 | PRJNA756891 | 7677 | 312 | 1.757322 | 5.48284464 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 54.7 | 1.05e-6 | NR | MBT3676754.1 | 2026760 | g7608 | i0 | 55.1 | 0.471153846153846 | 49 | 22 | 47.1 | 0 | 292 | 146 | 81 | 129 | MBT3676754.1 Hsp20/alpha crystallin family protein [Fidelibacterota bacterium] | diamond | 147 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32676501 | 32676501 | PRJNA756891_P_NODE_10920_length_265_cov_1.604167_g10851_i0 | PRJNA756891 | 10920 | 265 | 1.604167 | 4.25104255 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 64.7 | 8.81e-10 | NR | MDP6499941.1 | 2026760 | g10851 | i0 | 43.3 | 5.43396226415094 | 67 | 38 | 75.8 | 0 | 29 | 229 | 8 | 74 | MDP6499941.1 M28 family metallopeptidase [Fidelibacterota bacterium] | diamond | 1440 | 64.7 | 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);;