contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5624396 | 5624396 | PRJNA551951_S_NODE_17205_length_154_cov_1.605042_g17087_i0 | PRJNA551951 | 17205 | 154 | 1.605042 | 2.47176468 | Hymenobacter actinosclerus | 82805 | Bacteria | Bacteria | 103 | 3.24e-25 | NR | WP_177189699.1 | 82805 | g17087 | i0 | 94.1 | 0.993506493506494 | 51 | 3 | 99.4 | 0 | 2 | 154 | 44 | 94 | WP_177189699.1 phosphatase PAP2 family protein [Hymenobacter actinosclerus] | diamond | 153 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter actinosclerus | |
| 6898473 | 6898473 | PRJNA551951_S_NODE_16126_length_161_cov_1.587302_g16008_i0 | PRJNA551951 | 16126 | 161 | 1.587302 | 2.55555622 | Hydrotalea sp. | 2881279 | Bacteria | Bacteria | 107 | 8.310000000000001e-26 | NR | WP_288097092.1 | 2881279 | g16008 | i0 | 100 | 2.96273291925466 | 53 | 0 | 98.8 | 0 | 160 | 2 | 34 | 86 | WP_288097092.1 tRNA (N6-isopentenyl adenosine(37)-C2)-methylthiotransferase MiaB [Hydrotalea sp.] | diamond | 477 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Hydrotalea | Hydrotalea sp. | |
| 29650207 | 29650207 | PRJNA551951_S_NODE_15070_length_169_cov_3.373134_g14952_i0 | PRJNA551951 | 15070 | 169 | 3.373134 | 5.70059646 | FCB group | 1783270 | Bacteria | Bacteria | 50.8 | 6.88e-6 | NR | WP_141850568.1 | 96345 | g14952 | i0 | 54.1 | 3.10650887573965 | 37 | 17 | 65.7 | 0 | 43 | 153 | 72 | 108 | WP_141850568.1 hypothetical protein [Flavobacterium psychrophilum] | diamond | 525 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium psychrophilum | |
| 30426229 | 30426229 | PRJNA551951_S_NODE_5893_length_355_cov_2.093750_g5775_i0 | PRJNA551951 | 5893 | 355 | 2.09375 | 7.4328125 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 162 | 7.91e-46 | NR | MCA6440853.1 | 1869212 | g5775 | i0 | 98.8 | 0.684507042253521 | 81 | 1 | 68.5 | 0 | 3 | 245 | 27 | 107 | MCA6440853.1 aspartate aminotransferase family protein [Chitinophagaceae bacterium] | diamond | 243 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 30678369 | 30678369 | PRJNA551951_S_NODE_9233_length_253_cov_1.848624_g9115_i0 | PRJNA551951 | 9233 | 253 | 1.848624 | 4.67701872 | Flavobacterium humi | 2562683 | Bacteria | Bacteria | 178 | 8.479999999999999e-53 | NR | WP_135524882.1 | 2562683 | g9115 | i0 | 94 | 7.96837944664032 | 84 | 5 | 99.6 | 0 | 253 | 2 | 271 | 354 | WP_135524882.1 cupin domain-containing protein [Flavobacterium humi] | diamond | 2016 | 178 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium humi | |
| 31247268 | 31247268 | PRJNA551951_S_NODE_8015_length_282_cov_1.246964_g7897_i0 | PRJNA551951 | 8015 | 282 | 1.246964 | 3.51643848 | Phocaeicola plebeius | 310297 | Bacteria | Bacteria | 220 | 2.9599999999999994e-67 | NR | WP_022052406.1 | 310297 | g7897 | i0 | 100 | 1 | 94 | 0 | 100 | 0 | 282 | 1 | 64 | 157 | WP_022052406.1 alpha-L-fucosidase [Phocaeicola plebeius] | diamond | 282 | 220 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Phocaeicola | Phocaeicola plebeius | |
| 32417882 | 32417882 | PRJNA551951_S_NODE_6079_length_346_cov_2.990354_g5961_i0 | PRJNA551951 | 6079 | 346 | 2.990354 | 10.34662484 | Chryseobacterium | 59732 | Bacteria | Bacteria | 219 | 9.18e-71 | NR | WP_246958600.1 | 59732 | g5961 | i0 | 99.1 | 0.953757225433526 | 110 | 1 | 95.4 | 0 | 3 | 332 | 38 | 147 | WP_246958600.1 MULTISPECIES: TetR/AcrR family transcriptional regulator [Chryseobacterium] | diamond | 330 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | ||
| 32638611 | 32638611 | PRJNA551951_S_NODE_5040_length_393_cov_17.698324_g4923_i0 | PRJNA551951 | 5040 | 393 | 17.698324 | 69.55441332 | Hanamia sp. | 2930256 | Bacteria | Bacteria | 45.8 | 0.0147 | NR | HXS54988.1 | 2930256 | g4923 | i0 | 55.8 | 0.32824427480916 | 43 | 19 | 32.8 | 0 | 155 | 27 | 1 | 43 | HXS54988.1 alpha-L-fucosidase [Hanamia sp.] | diamond | 129 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Hanamia | Hanamia sp. | |
| 32764784 | 32764784 | PRJNA551951_S_NODE_15640_length_165_cov_1.230769_g15522_i0 | PRJNA551951 | 15640 | 165 | 1.230769 | 2.03076885 | Porphyromonas sp. oral taxon 278 | 712437 | Bacteria | Bacteria | 113 | 1.4900000000000002e-27 | NR | WP_021666217.1 | 712437 | g15522 | i0 | 100 | 1 | 55 | 0 | 100 | 0 | 1 | 165 | 569 | 623 | WP_021666217.1 RecQ family ATP-dependent DNA helicase [Porphyromonas sp. oral taxon 278] | diamond | 165 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 278 |
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);;