contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14536356 | 14536356 | PRJNA534016_P_NODE_19092_length_228_cov_2.296774_g19002_i0 | PRJNA534016 | 19092 | 228 | 2.296774 | 5.23664472 | Chryseolinea sp. | 2059303 | Bacteria | Bacteria | 149 | 1.79e-42 | NR | HTE31778.1 | 2059303 | g19002 | i0 | 92.1 | 4 | 76 | 6 | 100 | 0 | 228 | 1 | 88 | 163 | HTE31778.1 ketol-acid reductoisomerase [Chryseolinea sp.] | diamond | 912 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Fulvivirgaceae | Chryseolinea | Chryseolinea sp. | |
| 26776429 | 26776429 | PRJNA534016_P_NODE_18861_length_233_cov_2.168750_g18771_i0 | PRJNA534016 | 18861 | 233 | 2.16875 | 5.0531875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 5.04e-6 | NR | MFA8450429.1 | 2030927 | g18771 | i0 | 56.1 | 0.965665236051502 | 41 | 16 | 52.8 | 1 | 125 | 3 | 421 | 459 | MFA8450429.1 hypothetical protein [Bacteroidales bacterium] | diamond | 225 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 26966144 | 26966144 | PRJNA534016_P_NODE_8502_length_291_cov_2.678899_g8412_i0 | PRJNA534016 | 8502 | 291 | 2.678899 | 7.79559609 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 9.73e-5 | NR | MES2332513.1 | 1898104 | g8412 | i0 | 42.7 | 1.61855670103093 | 82 | 41 | 78.4 | 2 | 12 | 239 | 1123 | 1204 | MES2332513.1 HYR domain-containing protein [Bacteroidota bacterium] | diamond | 471 | 51.2 | 0.9921875 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27172409 | 27172409 | PRJNA534016_P_NODE_18302_length_241_cov_0.916667_g18212_i0 | PRJNA534016 | 18302 | 241 | 0.916667 | 2.20916747 | Draconibacterium orientale | 1168034 | Bacteria | Bacteria | 77.4 | 2.29e-14 | NR | WP_139178298.1 | 1168034 | g18212 | i0 | 48.1 | 2.9253112033195 | 79 | 39 | 95.9 | 1 | 1 | 231 | 1007 | 1085 | WP_139178298.1 hypothetical protein, partial [Draconibacterium orientale] | diamond | 705 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Prolixibacteraceae | Draconibacterium | Draconibacterium orientale | |
| 27425681 | 27425681 | PRJNA534016_P_NODE_11143_length_270_cov_1.467005_g11053_i0 | PRJNA534016 | 11143 | 270 | 1.467005 | 3.9609135 | Maribacter sp. 23 | 1897614 | Bacteria | Bacteria | 43.1 | 0.036 | NR | WP_413978024.1 | 3386274 | g11053 | i0 | 33.3 | 0.733333333333333 | 66 | 42 | 73.3 | 1 | 23 | 220 | 194 | 257 | WP_413978024.1 oligosaccharide flippase family protein [Maribacter sp. 2307UL18-2] | diamond | 198 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Maribacter | Maribacter sp. 2307UL18-2 | |
| 28751534 | 28751534 | PRJNA534016_P_NODE_18487_length_241_cov_0.857143_g18397_i0 | PRJNA534016 | 18487 | 241 | 0.857143 | 2.06571463 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 43.1 | 0.0242 | NR | MEQ9437565.1 | 2099675 | g18397 | i0 | 36.2 | 0.858921161825726 | 69 | 39 | 82.2 | 2 | 233 | 36 | 163 | 229 | MEQ9437565.1 sterol desaturase family protein [Cyclobacteriaceae bacterium] | diamond | 207 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 29004580 | 29004580 | PRJNA534016_P_NODE_10588_length_274_cov_2.079602_g10498_i0 | PRJNA534016 | 10588 | 274 | 2.079602 | 5.69810948 | Chryseobacterium lactis | 1241981 | Bacteria | Bacteria | 46.6 | 0.00205 | NR | WP_185287878.1 | 1241981 | g10498 | i0 | 37.3 | 0.733576642335766 | 67 | 41 | 72.3 | 1 | 263 | 66 | 18 | 84 | WP_185287878.1 FRG domain-containing protein [Chryseobacterium lactis] | diamond | 201 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium lactis | |
| 29130603 | 29130603 | PRJNA534016_P_NODE_4089_length_407_cov_2.104790_g3999_i0 | PRJNA534016 | 4089 | 407 | 2.10479 | 8.5664953 | Mangrovibacterium sp. | 1961364 | Bacteria | Bacteria | 79.3 | 3.53e-14 | NR | MDD4191831.1 | 1961364 | g3999 | i0 | 38.1 | 1.54791154791155 | 105 | 60 | 75.9 | 3 | 98 | 406 | 138 | 239 | MDD4191831.1 helicase associated domain-containing protein [Mangrovibacterium sp.] | diamond | 630 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Prolixibacteraceae | Mangrovibacterium | Mangrovibacterium sp. | |
| 29145695 | 29145695 | PRJNA534016_P_NODE_6749_length_324_cov_3.318725_g6659_i0 | PRJNA534016 | 6749 | 324 | 3.318725 | 10.752669 | Candidatus Brachybacter | 2981994 | Bacteria | Bacteria | 44.7 | 0.02 | NR | MBP7541559.1 | 2202734 | g6659 | i0 | 39.3 | 2.25925925925926 | 61 | 20 | 53.7 | 3 | 93 | 266 | 162 | 208 | MBP7541559.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium] | diamond | 732 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 29319833 | 29319833 | PRJNA534016_P_NODE_9069_length_286_cov_2.098592_g8979_i0 | PRJNA534016 | 9069 | 286 | 2.098592 | 6.00197312 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 152 | 2.15e-41 | NR | MEL6802172.1 | 1898104 | g8979 | i0 | 79.6 | 0.975524475524476 | 93 | 19 | 97.6 | 0 | 3 | 281 | 329 | 421 | MEL6802172.1 reverse transcriptase domain-containing protein [Bacteroidota bacterium] | diamond | 279 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30503533 | 30503533 | PRJNA534016_P_NODE_193_length_1626_cov_12.252415_g171_i0 | PRJNA534016 | 193 | 1626 | 12.252415 | 199.2242679 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 5.78e-18 | NR | NQX80861.1 | 1871037 | g171 | i0 | 31.5 | 1.67527675276753 | 197 | 100 | 31.5 | 6 | 1091 | 579 | 316 | 503 | NQX80861.1 hypothetical protein [Flavobacteriaceae bacterium] | diamond | 2724 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 31151640 | 31151640 | PRJNA534016_P_NODE_2055_length_571_cov_2.224900_g1967_i0 | PRJNA534016 | 2055 | 571 | 2.2249 | 12.704179 | unclassified Tenacibaculum | 2635139 | Bacteria | Bacteria | 69.7 | 2.97e-10 | NR | WP_235272807.1 | 2635139 | g1967 | i0 | 45.1 | 0.430823117338003 | 82 | 43 | 42.6 | 2 | 570 | 328 | 214 | 294 | WP_235272807.1 MULTISPECIES: hypothetical protein [unclassified Tenacibaculum] | diamond | 246 | 69.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Tenacibaculum | ||
| 31563425 | 31563425 | PRJNA534016_P_NODE_12456_length_260_cov_1.304813_g12366_i0 | PRJNA534016 | 12456 | 260 | 1.304813 | 3.3925138 | Flavobacterium | 237 | Bacteria | Bacteria | 114 | 3.0800000000000004e-27 | NR | WP_024981211.1 | 237 | g12366 | i0 | 96.6 | 0.680769230769231 | 59 | 2 | 68.1 | 0 | 179 | 3 | 1 | 59 | WP_024981211.1 MULTISPECIES: SusC/RagA family TonB-linked outer membrane protein [Flavobacterium] | diamond | 177 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 31626348 | 31626348 | PRJNA534016_P_NODE_12296_length_261_cov_1.622340_g12206_i0 | PRJNA534016 | 12296 | 261 | 1.62234 | 4.2343074 | Flavobacterium | 237 | Bacteria | Bacteria | 47.8 | 7.42e-4 | NR | WP_024980429.1 | 237 | g12206 | i0 | 83.3 | 0.620689655172414 | 54 | 9 | 62.1 | 0 | 259 | 98 | 292 | 345 | WP_024980429.1 MULTISPECIES: OmpH family outer membrane protein [Flavobacterium] | diamond | 162 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 31879286 | 31879286 | PRJNA534016_P_NODE_5577_length_353_cov_1.435714_g5487_i0 | PRJNA534016 | 5577 | 353 | 1.435714 | 5.06807042 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 68.2 | 1.6e-10 | NR | MBX7201664.1 | 2044936 | g5487 | i0 | 41.3 | 1.55524079320113 | 92 | 51 | 77.3 | 3 | 312 | 40 | 60 | 149 | MBX7201664.1 choice-of-anchor L domain-containing protein [Bacteroidia bacterium] | diamond | 549 | 68.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 32259475 | 32259475 | PRJNA534016_P_NODE_11218_length_269_cov_1.989796_g11128_i0 | PRJNA534016 | 11218 | 269 | 1.989796 | 5.35255124 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 164 | 6.16e-47 | NR | HEY0730840.1 | 1869212 | g11128 | i0 | 83.1 | 9.89219330855019 | 89 | 15 | 99.3 | 0 | 1 | 267 | 176 | 264 | HEY0730840.1 NAD-dependent formate dehydrogenase [Chitinophagaceae bacterium] | diamond | 2661 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 32322771 | 32322771 | PRJNA534016_P_NODE_17899_length_242_cov_0.911243_g17809_i0 | PRJNA534016 | 17899 | 242 | 0.911243 | 2.20520806 | Flavobacterium | 237 | Bacteria | Bacteria | 168 | 2.18e-46 | NR | WP_024982432.1 | 237 | g17809 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 1 | 240 | 465 | 544 | WP_024982432.1 MULTISPECIES: SusC/RagA family TonB-linked outer membrane protein [Flavobacterium] | diamond | 240 | 168 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 32354377 | 32354377 | PRJNA534016_P_NODE_19199_length_226_cov_2.013072_g19109_i0 | PRJNA534016 | 19199 | 226 | 2.013072 | 4.54954272 | Pedobacter cryoconitis | 188932 | Bacteria | Bacteria | 147 | 4.6e-39 | NR | WP_317617741.1 | 188932 | g19109 | i0 | 100 | 0.982300884955752 | 74 | 0 | 98.2 | 0 | 224 | 3 | 533 | 606 | WP_317617741.1 translocation/assembly module TamB domain-containing protein [Pedobacter cryoconitis] | diamond | 222 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter cryoconitis | |
| 32527517 | 32527517 | PRJNA534016_P_NODE_10159_length_278_cov_1.190244_g10069_i0 | PRJNA534016 | 10159 | 278 | 1.190244 | 3.30887832 | FCB group | 1783270 | Bacteria | Bacteria | 136 | 1.64e-37 | NR | MFK7844943.1 | 2306054 | g10069 | i0 | 72.8 | 9.96043165467626 | 92 | 25 | 99.3 | 0 | 277 | 2 | 114 | 205 | MFK7844943.1 3-hydroxyacyl-CoA dehydrogenase [Rhodothermales bacterium] | diamond | 2769 | 136 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 32575748 | 32575748 | PRJNA534016_P_NODE_3999_length_411_cov_3.275148_g3909_i0 | PRJNA534016 | 3999 | 411 | 3.275148 | 13.46085828 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 106 | 1.5199999999999995e-23 | NR | MEL6561794.1 | 1898104 | g3909 | i0 | 48.2 | 1 | 137 | 71 | 100 | 0 | 411 | 1 | 606 | 742 | MEL6561794.1 reverse transcriptase domain-containing protein [Bacteroidota bacterium] | diamond | 411 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota 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);;