contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554668 | 554668 | PRJNA565584_P_NODE_125241_length_278_cov_2.214634_g124089_i0 | PRJNA565584 | 125241 | 278 | 2.214634 | 6.15668252 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 113 | 3.95e-27 | NR | MBT4132015.1 | 2026760 | g124089 | i0 | 80.9 | 0.733812949640288 | 68 | 13 | 73.4 | 0 | 205 | 2 | 1 | 68 | MBT4132015.1 DUF3696 domain-containing protein [Fidelibacterota bacterium] | diamond | 204 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 18407886 | 18407886 | PRJNA565584_P_NODE_188855_length_247_cov_0.879310_g187703_i0 | PRJNA565584 | 188855 | 247 | 0.87931 | 2.1718957 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 105 | 3.96e-25 | NR | MAP67408.1 | 2026760 | g187703 | i0 | 62.3 | 0.935222672064777 | 77 | 27 | 93.5 | 1 | 2 | 232 | 252 | 326 | MAP67408.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 231 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28469230 | 28469230 | PRJNA565584_P_NODE_60886_length_381_cov_0.996753_g59735_i0 | PRJNA565584 | 60886 | 381 | 0.996753 | 3.79762893 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.9 | 0.0273 | NR | MBI89257.1 | 2026760 | g59735 | i0 | 41.1 | 0.440944881889764 | 56 | 30 | 44.1 | 1 | 168 | 1 | 24 | 76 | MBI89257.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 168 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28532287 | 28532287 | PRJNA565584_P_NODE_185767_length_247_cov_1.327586_g184615_i0 | PRJNA565584 | 185767 | 247 | 1.327586 | 3.27913742 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 115 | 4.99e-29 | NR | MBC8344958.1 | 2026760 | g184615 | i0 | 74.6 | 5.17408906882591 | 71 | 18 | 86.2 | 0 | 213 | 1 | 2 | 72 | MBC8344958.1 pyridoxal-phosphate dependent enzyme [Fidelibacterota bacterium] | diamond | 1278 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28879399 | 28879399 | PRJNA565584_P_NODE_64508_length_370_cov_1.037037_g63357_i0 | PRJNA565584 | 64508 | 370 | 1.037037 | 3.8370369 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 65.9 | 4.57e-10 | NR | NQV42819.1 | 2026760 | g63357 | i0 | 43.2 | 1.32972972972973 | 81 | 37 | 61.6 | 3 | 268 | 41 | 15 | 91 | NQV42819.1 DUF1295 domain-containing protein [Fidelibacterota bacterium] | diamond | 492 | 65.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29289929 | 29289929 | PRJNA565584_P_NODE_82529_length_327_cov_1.818898_g81377_i0 | PRJNA565584 | 82529 | 327 | 1.818898 | 5.94779646 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 73.6 | 1.45e-12 | NR | MBN2280069.1 | 2026760 | g81377 | i0 | 41.7 | 4.95412844036697 | 108 | 48 | 99.1 | 3 | 326 | 3 | 230 | 322 | MBN2280069.1 C69 family dipeptidase [Fidelibacterota bacterium] | diamond | 1620 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30187781 | 30187781 | PRJNA565584_P_NODE_204592_length_243_cov_0.905882_g203440_i0 | PRJNA565584 | 204592 | 243 | 0.905882 | 2.20129326 | FCB group | 1783270 | Bacteria | Bacteria | 108 | 1.23e-26 | NR | MBC8175626.1 | 2026760 | g203440 | i0 | 66.2 | 8.51851851851852 | 74 | 25 | 91.4 | 0 | 22 | 243 | 84 | 157 | MBC8175626.1 prenyltransferase [Fidelibacterota bacterium] | diamond | 2070 | 109 | 0.990825688073395 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31153216 | 31153216 | PRJNA565584_P_NODE_146195_length_265_cov_0.864583_g145043_i0 | PRJNA565584 | 146195 | 265 | 0.864583 | 2.29114495 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 43.5 | 0.0126 | NR | MFL3052411.1 | 2026760 | g145043 | i0 | 36.5 | 0.837735849056604 | 74 | 40 | 83.8 | 2 | 225 | 4 | 2 | 68 | MFL3052411.1 GAF domain-containing protein [Fidelibacterota bacterium] | diamond | 222 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31912699 | 31912699 | PRJNA565584_P_NODE_196037_length_245_cov_0.895349_g194885_i0 | PRJNA565584 | 196037 | 245 | 0.895349 | 2.19360505 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 47.4 | 8.67e-4 | NR | MBO8131782.1 | 2026760 | g194885 | i0 | 39.6 | 3.56326530612245 | 53 | 32 | 64.9 | 0 | 2 | 160 | 49 | 101 | MBO8131782.1 tetratricopeptide repeat protein [Fidelibacterota bacterium] | diamond | 873 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31926311 | 31926311 | PRJNA565584_P_NODE_146017_length_265_cov_1.203125_g144865_i0 | PRJNA565584 | 146017 | 265 | 1.203125 | 3.18828125 | Bacteria | 2 | Bacteria | Bacteria | 111 | 8.33e-28 | NR | MBT3228773.1 | 2026760 | g144865 | i0 | 63.1 | 5.71698113207547 | 84 | 31 | 95.1 | 0 | 264 | 13 | 119 | 202 | MBT3228773.1 SDR family NAD(P)-dependent oxidoreductase [Fidelibacterota bacterium] | diamond | 1515 | 112 | 0.991071428571429 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32464453 | 32464453 | PRJNA565584_P_NODE_73179_length_347_cov_2.211679_g72028_i0 | PRJNA565584 | 73179 | 347 | 2.211679 | 7.67452613 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 49.3 | 6.13e-4 | NR | MEC7855513.1 | 2026760 | g72028 | i0 | 52.7 | 2.23054755043228 | 55 | 20 | 45.8 | 3 | 4 | 162 | 13 | 63 | MEC7855513.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 774 | 49.7 | 0.991951710261569 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32482296 | 32482296 | PRJNA565584_P_NODE_106519_length_290_cov_1.852535_g105367_i0 | PRJNA565584 | 106519 | 290 | 1.852535 | 5.3723515 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 51.6 | 3.98e-6 | NR | MBT4129683.1 | 2026760 | g105367 | i0 | 49 | 0.506896551724138 | 49 | 24 | 49.7 | 1 | 110 | 253 | 19 | 67 | MBT4129683.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 147 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32829123 | 32829123 | PRJNA565584_P_NODE_203220_length_243_cov_1.805882_g202068_i0 | PRJNA565584 | 203220 | 243 | 1.805882 | 4.38829326 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 61.6 | 8e-9 | NR | MBT7685138.1 | 2026760 | g202068 | i0 | 80 | 0.432098765432099 | 35 | 7 | 43.2 | 0 | 2 | 106 | 412 | 446 | MBT7685138.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 105 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32860403 | 32860403 | PRJNA565584_P_NODE_145560_length_265_cov_1.604167_g144408_i0 | PRJNA565584 | 145560 | 265 | 1.604167 | 4.25104255 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 53.9 | 5.44e-6 | NR | MDP7715475.1 | 2026760 | g144408 | i0 | 63.2 | 5.72830188679245 | 38 | 14 | 43 | 0 | 3 | 116 | 556 | 593 | MDP7715475.1 AMP-dependent synthetase/ligase [Fidelibacterota bacterium] | diamond | 1518 | 53.9 | 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);;