contig_metadata
6 rows where bioproject = "PRJNA946307", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27183386 | 27183386 | PRJNA946307_P_NODE_99302_length_184_cov_3.281481_g98428_i0 | PRJNA946307 | 99302 | 184 | 3.281481 | 6.03792504 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42.4 | 0.0179 | NR | MBC8174534.1 | 2026760 | g98428 | i0 | 43.8 | 4.48369565217391 | 48 | 27 | 78.3 | 0 | 164 | 21 | 93 | 140 | MBC8174534.1 ribonuclease HI family protein [Fidelibacterota bacterium] | diamond | 825 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28636334 | 28636334 | PRJNA946307_P_NODE_49927_length_210_cov_3.478261_g49053_i0 | PRJNA946307 | 49927 | 210 | 3.478261 | 7.3043481 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 50.8 | 3.03e-6 | NR | MDP7025745.1 | 2026760 | g49053 | i0 | 83.9 | 0.885714285714286 | 31 | 5 | 44.3 | 0 | 209 | 117 | 16 | 46 | MDP7025745.1 ATP synthase F0 subunit C [Fidelibacterota bacterium] | diamond | 186 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30246883 | 30246883 | PRJNA946307_P_NODE_93732_length_187_cov_1.413043_g92858_i0 | PRJNA946307 | 93732 | 187 | 1.413043 | 2.64239041 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 42.4 | 0.0235 | NR | MEC9447821.1 | 2026760 | g92858 | i0 | 35.1 | 0.593582887700535 | 37 | 24 | 59.4 | 0 | 4 | 114 | 42 | 78 | MEC9447821.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 111 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31225972 | 31225972 | PRJNA946307_P_NODE_36035_length_220_cov_2.263158_g35161_i0 | PRJNA946307 | 36035 | 220 | 2.263158 | 4.9789476 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 48.9 | 3.32e-5 | NR | MBT5355787.1 | 2026760 | g35161 | i0 | 40.6 | 0.872727272727273 | 64 | 31 | 87.3 | 2 | 16 | 207 | 28 | 84 | MBT5355787.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 192 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31415881 | 31415881 | PRJNA946307_P_NODE_21856_length_274_cov_2.417778_g20983_i0 | PRJNA946307 | 21856 | 274 | 2.417778 | 6.62471172 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 60.8 | 2.22e-8 | NR | MDC0911287.1 | 2026760 | g20983 | i0 | 60 | 0.985401459854015 | 45 | 18 | 49.3 | 0 | 15 | 149 | 40 | 84 | MDC0911287.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 270 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32111891 | 32111891 | PRJNA946307_P_NODE_78498_length_195_cov_3.212329_g77624_i0 | PRJNA946307 | 78498 | 195 | 3.212329 | 6.26404155 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 52.8 | 5.42e-6 | NR | MEA3392338.1 | 2026760 | g77624 | i0 | 73.5 | 2.04615384615385 | 34 | 9 | 52.3 | 0 | 92 | 193 | 230 | 263 | MEA3392338.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Fidelibacterota bacterium] | diamond | 399 | 52.8 | 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);;