contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24954733 | 24954733 | PRJNA752278_P_NODE_80020_length_250_cov_1.536723_g79817_i0 | PRJNA752278 | 80020 | 250 | 1.536723 | 3.8418075 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 62 | 6.4e-9 | NR | MBT5758053.1 | 2026760 | g79817 | i0 | 58.2 | 0.66 | 55 | 22 | 66 | 1 | 84 | 248 | 578 | 631 | MBT5758053.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 165 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 26926246 | 26926246 | PRJNA752278_P_NODE_402_length_1520_cov_4.543193_g307_i0 | PRJNA752278 | 402 | 1520 | 4.543193 | 69.0565336 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 343 | 8.299999999999999e-107 | NR | MBC8256583.1 | 2026760 | g307 | i0 | 50.4 | 6.47368421052632 | 363 | 159 | 70.7 | 11 | 1147 | 74 | 100 | 446 | MBC8256583.1 DUF2817 domain-containing protein [Fidelibacterota bacterium] | diamond | 9840 | 343 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30337653 | 30337653 | PRJNA752278_P_NODE_70872_length_257_cov_2.038043_g70669_i0 | PRJNA752278 | 70872 | 257 | 2.038043 | 5.23777051 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 54.3 | 3.9e-6 | NR | MBC8256768.1 | 2026760 | g70669 | i0 | 84.6 | 0.303501945525292 | 26 | 4 | 30.4 | 0 | 2 | 79 | 1130 | 1155 | MBC8256768.1 tandem-95 repeat protein [Fidelibacterota bacterium] | diamond | 78 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30495306 | 30495306 | PRJNA752278_P_NODE_71533_length_257_cov_0.836957_g71330_i0 | PRJNA752278 | 71533 | 257 | 0.836957 | 2.15097949 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 45.1 | 0.00579 | NR | MAR29744.1 | 2026760 | g71330 | i0 | 52.4 | 1.49416342412451 | 42 | 19 | 47.9 | 1 | 124 | 2 | 53 | 94 | MAR29744.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 384 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30599708 | 30599708 | PRJNA752278_P_NODE_22213_length_342_cov_4.695167_g22010_i0 | PRJNA752278 | 22213 | 342 | 4.695167 | 16.05747114 | Bacteria | 2 | Bacteria | Bacteria | 70.5 | 1.17e-11 | NR | MFQ6610072.1 | 2026760 | g22010 | i0 | 51.6 | 1.64035087719298 | 62 | 30 | 54.4 | 0 | 5 | 190 | 225 | 286 | MFQ6610072.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 561 | 70.5 | 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);;