contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1050291" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10379213 | 10379213 | PRJNA1050291_P_NODE_15909_length_275_cov_1.207921_g15018_i0 | PRJNA1050291 | 15909 | 275 | 1.207921 | 3.32178275 | Emticicia sp. BO119 | 2757768 | Bacteria | Bacteria | 166 | 3.21e-50 | NR | WP_181843672.1 | 2757768 | g15018 | i0 | 92.7 | 0.894545454545455 | 82 | 6 | 89.5 | 0 | 248 | 3 | 1 | 82 | WP_181843672.1 dihydrofolate reductase family protein [Emticicia sp. BO119] | diamond | 246 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia sp. BO119 | |
| 15038746 | 15038746 | PRJNA1050291_P_NODE_3012_length_1233_cov_4.907759_g2170_i0 | PRJNA1050291 | 3012 | 1233 | 4.907759 | 60.51266847 | root | 1 | Root_unresolved | Root_unresolved | 575 | 1.0899999999999998e-202 | NR | WP_027000370.1 | 997 | g2170 | i0 | 71.2 | 48.0389294403893 | 393 | 112 | 95.6 | 1 | 1228 | 50 | 15 | 406 | WP_027000370.1 ornithine--oxo-acid transaminase [Eisenibacter elegans] | diamond | 59232 | 580 | 0.991379310344828 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Microscillaceae | Eisenibacter | Eisenibacter elegans | |
| 27319887 | 27319887 | PRJNA1050291_P_NODE_17543_length_258_cov_1.637838_g16652_i0 | PRJNA1050291 | 17543 | 258 | 1.637838 | 4.22562204 | Cytophagaceae bacterium | 2026729 | Bacteria | Bacteria | 110 | 2.4799999999999998e-28 | NR | RYF44830.1 | 2026729 | g16652 | i0 | 67.1 | 0.988372093023256 | 85 | 28 | 98.8 | 0 | 3 | 257 | 14 | 98 | RYF44830.1 MAG: methyl-accepting chemotaxis protein, partial [Cytophagaceae bacterium] | diamond | 255 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Cytophagaceae bacterium | ||
| 27319889 | 27319889 | PRJNA1050291_P_NODE_20863_length_243_cov_0.917647_g19972_i0 | PRJNA1050291 | 20863 | 243 | 0.917647 | 2.22988221 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 78.2 | 1.23e-14 | NR | HMQ50214.1 | 2202734 | g19972 | i0 | 87 | 1.14814814814815 | 46 | 6 | 56.8 | 0 | 241 | 104 | 246 | 291 | HMQ50214.1 SusC/RagA family TonB-linked outer membrane protein [Saprospiraceae bacterium] | diamond | 279 | 78.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 28195653 | 28195653 | PRJNA1050291_P_NODE_4306_length_801_cov_2.627747_g3425_i0 | PRJNA1050291 | 4306 | 801 | 2.627747 | 21.04825347 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.3 | 7.75e-16 | NR | RYF44830.1 | 2026729 | g3425 | i0 | 60.3 | 0.546816479400749 | 73 | 29 | 27.3 | 0 | 219 | 1 | 1 | 73 | RYF44830.1 MAG: methyl-accepting chemotaxis protein, partial [Cytophagaceae bacterium] | diamond | 438 | 84.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagaceae | Cytophagaceae bacterium | ||
| 29592779 | 29592779 | PRJNA1050291_P_NODE_18850_length_250_cov_0.881356_g17959_i0 | PRJNA1050291 | 18850 | 250 | 0.881356 | 2.20339 | uncultured Porphyromonas sp. | 159274 | Bacteria | Bacteria | 68.6 | 3.34e-11 | NR | WP_297129322.1 | 159274 | g17959 | i0 | 45.1 | 0.984 | 82 | 45 | 98.4 | 0 | 250 | 5 | 5 | 86 | WP_297129322.1 leucine-rich repeat domain-containing protein [uncultured Porphyromonas sp.] | diamond | 246 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | uncultured Porphyromonas sp. | |
| 31109418 | 31109418 | PRJNA1050291_P_NODE_10515_length_370_cov_2.902357_g9624_i0 | PRJNA1050291 | 10515 | 370 | 2.902357 | 10.7387209 | Chitinophaga skermanii | 331697 | Bacteria | Bacteria | 45.4 | 0.0168 | NR | WP_111600250.1 | 331697 | g9624 | i0 | 29.9 | 0.867567567567568 | 107 | 70 | 85.1 | 2 | 53 | 367 | 27 | 130 | WP_111600250.1 tetratricopeptide repeat protein [Chitinophaga skermanii] | diamond | 321 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophaga | Chitinophaga skermanii | |
| 31203906 | 31203906 | PRJNA1050291_P_NODE_7095_length_513_cov_1.595455_g6204_i0 | PRJNA1050291 | 7095 | 513 | 1.595455 | 8.18468415 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 67.4 | 1.69e-9 | NR | MBS1536928.1 | 1898104 | g6204 | i0 | 61.1 | 0.315789473684211 | 54 | 21 | 31.6 | 0 | 255 | 94 | 710 | 763 | MBS1536928.1 hypothetical protein [Bacteroidota bacterium] | diamond | 162 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31892102 | 31892102 | PRJNA1050291_P_NODE_18857_length_250_cov_0.881356_g17966_i0 | PRJNA1050291 | 18857 | 250 | 0.881356 | 2.20339 | Mucilaginibacter | 423349 | Bacteria | Bacteria | 110 | 2.12e-28 | NR | MDB5134478.1 | 1882438 | g17966 | i0 | 88.7 | 1.488 | 62 | 7 | 74.4 | 0 | 248 | 63 | 135 | 196 | MDB5134478.1 LemA family protein [Mucilaginibacter sp.] | diamond | 372 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. |
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);;