contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA385064" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2956073 | 2956073 | PRJNA385064_P_NODE_7783_length_162_cov_0.902655_g7658_i0 | PRJNA385064 | 7783 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 95.5 | 6.88e-22 | NR | MBS1638289.1 | 1898104 | g7658 | i0 | 77.8 | 2.96296296296296 | 54 | 12 | 100 | 0 | 162 | 1 | 55 | 108 | MBS1638289.1 cation transporter [Bacteroidota bacterium] | diamond | 480 | 95.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26807315 | 26807315 | PRJNA385064_P_NODE_7521_length_163_cov_0.894737_g7396_i0 | PRJNA385064 | 7521 | 163 | 0.894737 | 1.45842131 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 4.33e-13 | NR | MES2132048.1 | 1898104 | g7396 | i0 | 68.5 | 1.98773006134969 | 54 | 17 | 99.4 | 0 | 1 | 162 | 211 | 264 | MES2132048.1 hypothetical protein [Bacteroidota bacterium] | diamond | 324 | 72.8 | 0.994505494505495 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26916989 | 26916989 | PRJNA385064_P_NODE_6742_length_166_cov_1.102564_g6617_i0 | PRJNA385064 | 6742 | 166 | 1.102564 | 1.83025624 | Taibaiella helva | 2301235 | Bacteria | Bacteria | 94.4 | 7.199999999999999e-24 | NR | WP_157976816.1 | 2301235 | g6617 | i0 | 81.8 | 1.98795180722892 | 55 | 10 | 99.4 | 0 | 165 | 1 | 13 | 67 | WP_157976816.1 transposase, partial [Taibaiella helva] | diamond | 330 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Taibaiella | Taibaiella helva | |
| 27675682 | 27675682 | PRJNA385064_P_NODE_8204_length_161_cov_0.776786_g8079_i0 | PRJNA385064 | 8204 | 161 | 0.776786 | 1.25062546 | Chitinophaga pinensis | 79329 | Bacteria | Bacteria | 40 | 0.0364 | NR | WP_012792240.1 | 79329 | g8079 | i0 | 38.5 | 0.968944099378882 | 52 | 24 | 82 | 1 | 159 | 28 | 41 | 92 | WP_012792240.1 DUF805 domain-containing protein [Chitinophaga pinensis] | diamond | 156 | 40 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophaga | Chitinophaga pinensis | |
| 27833206 | 27833206 | PRJNA385064_P_NODE_7264_length_164_cov_0.886957_g7139_i0 | PRJNA385064 | 7264 | 164 | 0.886957 | 1.45460948 | Chitinophaga sp. | 1869181 | Bacteria | Bacteria | 102 | 1.6499999999999995e-23 | NR | MBA4198633.1 | 1869181 | g7139 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 162 | 1 | 70 | 123 | MBA4198633.1 peptide transporter [Chitinophaga sp.] | diamond | 162 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophaga | Chitinophaga sp. | |
| 28134510 | 28134510 | PRJNA385064_P_NODE_7505_length_163_cov_0.894737_g7380_i0 | PRJNA385064 | 7505 | 163 | 0.894737 | 1.45842131 | Weeksellaceae | 2762318 | Bacteria | Bacteria | 81.3 | 4.12e-18 | NR | WP_367174840.1 | 259322 | g7380 | i0 | 79.5 | 3.95705521472393 | 44 | 9 | 81 | 0 | 2 | 133 | 75 | 118 | WP_367174840.1 hypothetical protein [uncultured Chryseobacterium sp.] | diamond | 645 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | uncultured Chryseobacterium sp. | |
| 28211929 | 28211929 | PRJNA385064_P_NODE_7566_length_163_cov_0.894737_g7441_i0 | PRJNA385064 | 7566 | 163 | 0.894737 | 1.45842131 | Asinibacterium sp. OR53 | 925409 | Bacteria | Bacteria | 103 | 6.529999999999999e-24 | NR | WP_026768212.1 | 925409 | g7441 | i0 | 98.1 | 0.993865030674847 | 54 | 1 | 99.4 | 0 | 162 | 1 | 63 | 116 | WP_026768212.1 phosphoenolpyruvate carboxylase [Asinibacterium sp. OR53] | diamond | 162 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Asinibacterium | Asinibacterium sp. OR53 | |
| 28292059 | 28292059 | PRJNA385064_P_NODE_7606_length_163_cov_0.894737_g7481_i0 | PRJNA385064 | 7606 | 163 | 0.894737 | 1.45842131 | Bacteroidota | 976 | Bacteria | Bacteria | 77.8 | 1.52e-15 | NR | MCZ8217462.1 | 2099675 | g7481 | i0 | 65.4 | 7.73006134969325 | 52 | 18 | 95.7 | 0 | 163 | 8 | 106 | 157 | MCZ8217462.1 peptidoglycan editing factor PgeF [Cyclobacteriaceae bacterium] | diamond | 1260 | 77.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 29380415 | 29380415 | PRJNA385064_P_NODE_6529_length_167_cov_0.864407_g6404_i0 | PRJNA385064 | 6529 | 167 | 0.864407 | 1.44355969 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 108 | 8.73e-26 | NR | MBS1637485.1 | 1898104 | g6404 | i0 | 94.5 | 1.97604790419162 | 55 | 3 | 98.8 | 0 | 2 | 166 | 311 | 365 | MBS1637485.1 hypothetical protein [Bacteroidota bacterium] | diamond | 330 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29411899 | 29411899 | PRJNA385064_P_NODE_8169_length_161_cov_0.910714_g8044_i0 | PRJNA385064 | 8169 | 161 | 0.910714 | 1.46624954 | Sphingobacteriia bacterium | 2035813 | Bacteria | Bacteria | 114 | 3.34e-29 | NR | MBN8835986.1 | 2035813 | g8044 | i0 | 100 | 0.987577639751553 | 53 | 0 | 98.8 | 0 | 159 | 1 | 47 | 99 | MBN8835986.1 phosphoribosylaminoimidazolesuccinocarboxamide synthase [Sphingobacteriia bacterium] | diamond | 159 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriia bacterium | ||||
| 30043506 | 30043506 | PRJNA385064_P_NODE_7751_length_162_cov_0.902655_g7626_i0 | PRJNA385064 | 7751 | 162 | 0.902655 | 1.4623011 | Sphingobacteriales bacterium 5 | 2044944 | Bacteria | Bacteria | 50.4 | 2.29e-6 | NR | OJW53658.1 | 1895841 | g7626 | i0 | 100 | 0.444444444444444 | 24 | 0 | 44.4 | 0 | 161 | 90 | 62 | 85 | OJW53658.1 MAG: hypothetical protein BGO55_00830 [Sphingobacteriales bacterium 50-39] | diamond | 72 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriales bacterium 50-39 | |||
| 30328474 | 30328474 | PRJNA385064_P_NODE_7372_length_164_cov_0.886957_g7247_i0 | PRJNA385064 | 7372 | 164 | 0.886957 | 1.45460948 | Bacteroidia bacterium | 2044936 | Bacteria | Bacteria | 74.3 | 7.41e-14 | NR | HXB40048.1 | 2044936 | g7247 | i0 | 66.7 | 1.97560975609756 | 54 | 18 | 98.8 | 0 | 1 | 162 | 40 | 93 | HXB40048.1 efflux RND transporter periplasmic adaptor subunit [Bacteroidia bacterium] | diamond | 324 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 30565652 | 30565652 | PRJNA385064_P_NODE_7813_length_162_cov_0.902655_g7688_i0 | PRJNA385064 | 7813 | 162 | 0.902655 | 1.4623011 | Chitinophagaceae | 563835 | Bacteria | Bacteria | 96.7 | 1.24e-21 | NR | HEU4610052.1 | 1869212 | g7688 | i0 | 90.6 | 73.7962962962963 | 53 | 5 | 98.1 | 0 | 161 | 3 | 168 | 220 | HEU4610052.1 TonB-dependent receptor [Chitinophagaceae bacterium] | diamond | 11955 | 97.4 | 0.992813141683778 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 31023070 | 31023070 | PRJNA385064_P_NODE_8055_length_161_cov_0.910714_g7930_i0 | PRJNA385064 | 8055 | 161 | 0.910714 | 1.46624954 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 48.5 | 6.38e-5 | NR | MBA2611655.1 | 1898104 | g7930 | i0 | 80 | 1.11801242236025 | 30 | 6 | 55.9 | 0 | 161 | 72 | 141 | 170 | MBA2611655.1 hypothetical protein [Bacteroidota bacterium] | diamond | 180 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31497446 | 31497446 | PRJNA385064_P_NODE_4276_length_209_cov_0.956250_g4151_i0 | PRJNA385064 | 4276 | 209 | 0.95625 | 1.9985625 | Capnocytophaga granulosa | 45242 | Bacteria | Bacteria | 149 | 1.32e-41 | NR | WP_276727488.1 | 45242 | g4151 | i0 | 97.1 | 0.990430622009569 | 69 | 2 | 99 | 0 | 209 | 3 | 136 | 204 | WP_276727488.1 hypothetical protein [Capnocytophaga granulosa] | diamond | 207 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | Capnocytophaga granulosa | |
| 31655244 | 31655244 | PRJNA385064_P_NODE_7797_length_162_cov_0.902655_g7672_i0 | PRJNA385064 | 7797 | 162 | 0.902655 | 1.4623011 | Hydrobacter penzbergensis | 1235997 | Bacteria | Bacteria | 112 | 3.3200000000000005e-27 | NR | WP_092724037.1 | 1235997 | g7672 | i0 | 100 | 2 | 54 | 0 | 100 | 0 | 1 | 162 | 457 | 510 | WP_092724037.1 2-oxoacid:acceptor oxidoreductase subunit alpha [Hydrobacter penzbergensis] | diamond | 324 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Hydrobacter | Hydrobacter penzbergensis | |
| 31813569 | 31813569 | PRJNA385064_P_NODE_7617_length_163_cov_0.894737_g7492_i0 | PRJNA385064 | 7617 | 163 | 0.894737 | 1.45842131 | Paramuribaculum sp. | 2518501 | Bacteria | Bacteria | 39.7 | 0.04 | NR | MDE6049553.1 | 2518501 | g7492 | i0 | 34.3 | 0.644171779141104 | 35 | 23 | 64.4 | 0 | 151 | 47 | 40 | 74 | MDE6049553.1 hypothetical protein [Paramuribaculum sp.] | diamond | 105 | 39.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Muribaculaceae | Paramuribaculum | Paramuribaculum sp. | |
| 32066594 | 32066594 | PRJNA385064_P_NODE_7898_length_162_cov_0.902655_g7773_i0 | PRJNA385064 | 7898 | 162 | 0.902655 | 1.4623011 | Cloacibacterium sp. | 1913682 | Bacteria | Bacteria | 110 | 1.37e-27 | NR | WP_414984517.1 | 1913682 | g7773 | i0 | 96.3 | 2 | 54 | 2 | 100 | 0 | 1 | 162 | 166 | 219 | WP_414984517.1 cysteine synthase A [Cloacibacterium sp.] | diamond | 324 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Cloacibacterium | Cloacibacterium sp. | |
| 32256906 | 32256906 | PRJNA385064_P_NODE_7498_length_163_cov_0.894737_g7373_i0 | PRJNA385064 | 7498 | 163 | 0.894737 | 1.45842131 | Pseudobacter ginsenosidimutans | 661488 | Bacteria | Bacteria | 110 | 3.47e-27 | NR | WP_130541928.1 | 661488 | g7373 | i0 | 94.4 | 0.993865030674847 | 54 | 3 | 99.4 | 0 | 163 | 2 | 40 | 93 | WP_130541928.1 DUF1015 domain-containing protein [Pseudobacter ginsenosidimutans] | diamond | 162 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Pseudobacter | Pseudobacter ginsenosidimutans | |
| 32635635 | 32635635 | PRJNA385064_P_NODE_6840_length_166_cov_0.871795_g6715_i0 | PRJNA385064 | 6840 | 166 | 0.871795 | 1.4471797 | Riemerella sp. | 2382126 | Bacteria | Bacteria | 110 | 4.88e-28 | NR | RKW63781.1 | 2382126 | g6715 | i0 | 98.2 | 0.993975903614458 | 55 | 1 | 99.4 | 0 | 166 | 2 | 56 | 110 | RKW63781.1 MAG: isoprenyl transferase [Riemerella sp.] | diamond | 165 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Riemerella | Riemerella sp. | |
| 32652422 | 32652422 | PRJNA385064_P_NODE_8140_length_161_cov_0.910714_g8015_i0 | PRJNA385064 | 8140 | 161 | 0.910714 | 1.46624954 | Chitinophagaceae | 563835 | Bacteria | Bacteria | 113 | 1.9100000000000003e-27 | NR | MBN8720733.1 | 669455 | g8015 | i0 | 100 | 2.96273291925466 | 53 | 0 | 98.8 | 0 | 1 | 159 | 1034 | 1086 | MBN8720733.1 alpha-2-macroglobulin [Sediminibacterium magnilacihabitans] | diamond | 477 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Sediminibacterium | Sediminibacterium magnilacihabitans |
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);;