contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA904835" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 883016 | 883016 | PRJNA904835_P_NODE_32681_length_341_cov_0.850746_g32425_i0 | PRJNA904835 | 32681 | 341 | 0.850746 | 2.90104386 | Flavobacterium sp. | 239 | Bacteria | Bacteria | 213 | 3.7499999999999996e-68 | NR | MPT35378.1 | 239 | g32425 | i0 | 100 | 1.77712609970674 | 101 | 0 | 88.9 | 0 | 339 | 37 | 100 | 200 | MPT35378.1 asparagine synthetase B [Flavobacterium sp.] | diamond | 606 | 213 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 14911474 | 14911474 | PRJNA904835_P_NODE_51052_length_251_cov_0.865169_g50796_i0 | PRJNA904835 | 51052 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 121 | 2.51e-30 | NR | MCY7420976.1 | 1869212 | g50796 | i0 | 67.9 | 5.80876494023904 | 81 | 26 | 96.8 | 0 | 244 | 2 | 402 | 482 | MCY7420976.1 NAD-dependent succinate-semialdehyde dehydrogenase [Chitinophagaceae bacterium] | diamond | 1458 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27221227 | 27221227 | PRJNA904835_P_NODE_52982_length_248_cov_1.137143_g52726_i0 | PRJNA904835 | 52982 | 248 | 1.137143 | 2.82011464 | Mucilaginibacter | 423349 | Bacteria | Bacteria | 86.3 | 1.9e-17 | NR | HEY2583270.1 | 1882438 | g52726 | i0 | 52.4 | 2.98790322580645 | 82 | 35 | 94.4 | 1 | 236 | 3 | 424 | 505 | HEY2583270.1 glycosyl hydrolase family 28-related protein [Mucilaginibacter sp.] | diamond | 741 | 86.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. | |
| 27372278 | 27372278 | PRJNA904835_P_NODE_35243_length_325_cov_1.912698_g34987_i0 | PRJNA904835 | 35243 | 325 | 1.912698 | 6.2162685 | unclassified Dysgonomonas | 2630389 | Bacteria | Bacteria | 43.9 | 0.0343 | NR | WP_280644237.1 | 2630389 | g34987 | i0 | 36.5 | 0.581538461538462 | 63 | 36 | 54.5 | 1 | 179 | 3 | 58 | 120 | WP_280644237.1 MULTISPECIES: M24 family metallopeptidase [unclassified Dysgonomonas] | diamond | 189 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Dysgonomonadaceae | Dysgonomonas | ||
| 27751094 | 27751094 | PRJNA904835_P_NODE_38624_length_307_cov_0.974359_g38368_i0 | PRJNA904835 | 38624 | 307 | 0.974359 | 2.99128213 | Chitinophagales bacterium | 2448779 | Bacteria | Bacteria | 43.5 | 0.0422 | NR | MBC8047264.1 | 2448779 | g38368 | i0 | 33.8 | 0.693811074918567 | 71 | 45 | 67.4 | 1 | 15 | 221 | 287 | 357 | MBC8047264.1 hypothetical protein [Chitinophagales bacterium] | diamond | 213 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagales bacterium | |||
| 28358166 | 28358166 | PRJNA904835_P_NODE_26686_length_383_cov_1.712903_g26430_i0 | PRJNA904835 | 26686 | 383 | 1.712903 | 6.56041849 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 115 | 1.3100000000000002e-27 | NR | PKP39489.1 | 2013683 | g26430 | i0 | 54 | 8.10704960835509 | 113 | 51 | 87.7 | 1 | 374 | 39 | 19 | 131 | PKP39489.1 MAG: deoxyguanosinetriphosphate triphosphohydrolase [Bacteroidetes bacterium HGW-Bacteroidetes-15] | diamond | 3105 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidetes bacterium HGW-Bacteroidetes-15 | |||||
| 28445622 | 28445622 | PRJNA904835_P_NODE_31706_length_347_cov_1.124088_g31450_i0 | PRJNA904835 | 31706 | 347 | 1.124088 | 3.90058536 | Cellulophaga sp. BC115SP | 2683263 | Bacteria | Bacteria | 242 | 2.3e-76 | NR | WP_166551284.1 | 2683263 | g31450 | i0 | 100 | 0.994236311239193 | 115 | 0 | 99.4 | 0 | 346 | 2 | 133 | 247 | WP_166551284.1 vanadium-dependent haloperoxidase [Cellulophaga sp. BC115SP] | diamond | 345 | 242 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Cellulophaga | Cellulophaga sp. BC115SP | |
| 28698276 | 28698276 | PRJNA904835_P_NODE_37867_length_311_cov_1.235294_g37611_i0 | PRJNA904835 | 37867 | 311 | 1.235294 | 3.84176434 | Flectobacillus sp. BAB-3569 | 1509483 | Bacteria | Bacteria | 201 | 2.7400000000000003e-64 | NR | WP_095163503.1 | 1509483 | g37611 | i0 | 98.1 | 0.993569131832797 | 103 | 2 | 99.4 | 0 | 3 | 311 | 29 | 131 | WP_095163503.1 hypothetical protein [Flectobacillus sp. BAB-3569] | diamond | 309 | 201 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | Flectobacillus sp. BAB-3569 | |
| 28918922 | 28918922 | PRJNA904835_P_NODE_55048_length_246_cov_0.890173_g54792_i0 | PRJNA904835 | 55048 | 246 | 0.890173 | 2.18982558 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 42 | 0.0484 | NR | MEX2511452.1 | 2099675 | g54792 | i0 | 35.4 | 0.585365853658537 | 48 | 31 | 58.5 | 0 | 166 | 23 | 110 | 157 | MEX2511452.1 shikimate kinase [Cyclobacteriaceae bacterium] | diamond | 144 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 29077122 | 29077122 | PRJNA904835_P_NODE_49008_length_257_cov_1.673913_g48752_i0 | PRJNA904835 | 49008 | 257 | 1.673913 | 4.30195641 | uncultured Algibacter sp. | 298659 | Bacteria | Bacteria | 43.9 | 0.0175 | NR | WP_298556281.1 | 298659 | g48752 | i0 | 31.3 | 0.968871595330739 | 83 | 54 | 96.9 | 1 | 255 | 7 | 81 | 160 | WP_298556281.1 exopolysaccharide transport family protein [uncultured Algibacter sp.] | diamond | 249 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Algibacter | uncultured Algibacter sp. | |
| 29866368 | 29866368 | PRJNA904835_P_NODE_29311_length_363_cov_3.062069_g29055_i0 | PRJNA904835 | 29311 | 363 | 3.062069 | 11.11531047 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 45.1 | 0.0222 | NR | MFM7684286.1 | 1898104 | g29055 | i0 | 32.9 | 1.46280991735537 | 82 | 50 | 65.3 | 3 | 358 | 122 | 580 | 659 | MFM7684286.1 DUF4116 domain-containing protein [Bacteroidota bacterium] | diamond | 531 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30087415 | 30087415 | PRJNA904835_P_NODE_58972_length_241_cov_0.916667_g58716_i0 | PRJNA904835 | 58972 | 241 | 0.916667 | 2.20916747 | Flectobacillus longus | 2984207 | Bacteria | Bacteria | 147 | 1.85e-40 | NR | WP_283329611.1 | 2984207 | g58716 | i0 | 94.9 | 0.983402489626556 | 79 | 4 | 98.3 | 0 | 3 | 239 | 11 | 89 | WP_283329611.1 MFS transporter [Flectobacillus longus] | diamond | 237 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | Flectobacillus longus | |
| 30656123 | 30656123 | PRJNA904835_P_NODE_14753_length_541_cov_1.576923_g14501_i0 | PRJNA904835 | 14753 | 541 | 1.576923 | 8.53115343 | Thermoflexibacter sp. | 1938004 | Bacteria | Bacteria | 187 | 2.4499999999999997e-57 | NR | MCU0392935.1 | 1938004 | g14501 | i0 | 56.2 | 0.898336414048059 | 162 | 59 | 89.3 | 4 | 22 | 504 | 2 | 152 | MCU0392935.1 GNAT family N-acetyltransferase [Thermoflexibacter sp.] | diamond | 486 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Thermoflexibacteraceae | Thermoflexibacter | Thermoflexibacter sp. | |
| 30972279 | 30972279 | PRJNA904835_P_NODE_57174_length_243_cov_0.905882_g56918_i0 | PRJNA904835 | 57174 | 243 | 0.905882 | 2.20129326 | Flectobacillus | 101 | Bacteria | Bacteria | 162 | 6.26e-49 | NR | WP_310586454.1 | 101 | g56918 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 242 | 3 | 49 | 128 | WP_310586454.1 MULTISPECIES: RNA polymerase sigma factor [Flectobacillus] | diamond | 240 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | ||
| 31636069 | 31636069 | PRJNA904835_P_NODE_46256_length_270_cov_1.563452_g46000_i0 | PRJNA904835 | 46256 | 270 | 1.563452 | 4.2213204 | Bacteroidota | 976 | Bacteria | Bacteria | 175 | 5.93e-53 | NR | WP_166553253.1 | 976 | g46000 | i0 | 100 | 0.944444444444444 | 85 | 0 | 94.4 | 0 | 256 | 2 | 83 | 167 | WP_166553253.1 MULTISPECIES: tetratricopeptide repeat protein [Bacteroidota] | diamond | 255 | 175 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | ||||||
| 31699417 | 31699417 | PRJNA904835_P_NODE_31997_length_345_cov_1.132353_g31741_i0 | PRJNA904835 | 31997 | 345 | 1.132353 | 3.90661785 | Chitinophagia bacterium | 2448778 | Bacteria | Bacteria | 46.2 | 0.00733 | NR | MEI6190480.1 | 2448778 | g31741 | i0 | 35.2 | 0.91304347826087 | 105 | 62 | 91.3 | 2 | 1 | 315 | 80 | 178 | MEI6190480.1 NHL repeat-containing protein [Chitinophagia bacterium] | diamond | 315 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagia bacterium | ||||
| 32300859 | 32300859 | PRJNA904835_P_NODE_41579_length_292_cov_1.050228_g41323_i0 | PRJNA904835 | 41579 | 292 | 1.050228 | 3.06666576 | Flavobacterium supellecticarium | 2565924 | Bacteria | Bacteria | 193 | 2.21e-58 | NR | WP_136401850.1 | 2565924 | g41323 | i0 | 99 | 0.996575342465753 | 97 | 1 | 99.7 | 0 | 292 | 2 | 95 | 191 | WP_136401850.1 radical SAM protein [Flavobacterium supellecticarium] | diamond | 291 | 193 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium supellecticarium | |
| 32427112 | 32427112 | PRJNA904835_P_NODE_55319_length_245_cov_1.691860_g55063_i0 | PRJNA904835 | 55319 | 245 | 1.69186 | 4.145057 | Runella limosa | 370978 | Bacteria | Bacteria | 129 | 1.88e-34 | NR | WP_028525191.1 | 370978 | g55063 | i0 | 73.8 | 0.979591836734694 | 80 | 21 | 98 | 0 | 6 | 245 | 145 | 224 | WP_028525191.1 nucleotide kinase domain-containing protein [Runella limosa] | diamond | 240 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Runella | Runella limosa | |
| 32679376 | 32679376 | PRJNA904835_P_NODE_56280_length_244_cov_1.198830_g56024_i0 | PRJNA904835 | 56280 | 244 | 1.19883 | 2.9251452 | Ornithobacterium rhinotracheale | 28251 | Bacteria | Bacteria | 43.1 | 0.0275 | NR | WP_243910104.1 | 28251 | g56024 | i0 | 41.4 | 1.38934426229508 | 58 | 33 | 71.3 | 1 | 221 | 48 | 974 | 1030 | WP_243910104.1 fibronectin type III domain-containing protein [Ornithobacterium rhinotracheale] | diamond | 339 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Ornithobacterium | Ornithobacterium rhinotracheale |
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);;