contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB56027" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7776776 | 7776776 | PRJEB56027_P_NODE_90227_length_282_cov_1.842105_g87418_i0 | PRJEB56027 | 90227 | 282 | 1.842105 | 5.1947361 | Chitinophagaceae bacterium LWZ2-11 | 3369651 | Bacteria | Bacteria | 189 | 1.06e-57 | NR | MFL9484218.1 | 3369651 | g87418 | i0 | 100 | 0.98936170212766 | 93 | 0 | 98.9 | 0 | 3 | 281 | 170 | 262 | MFL9484218.1 quinone oxidoreductase family protein [Chitinophagaceae bacterium LWZ2-11] | diamond | 279 | 189 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium LWZ2-11 | ||
| 10325361 | 10325361 | PRJEB56027_P_NODE_114149_length_251_cov_0.865169_g111340_i0 | PRJEB56027 | 114149 | 251 | 0.865169 | 2.17157419 | Sphingobacterium sp. UT-1RO-CII-1 | 2995225 | Bacteria | Bacteria | 162 | 3.58e-46 | NR | WP_268230074.1 | 2995225 | g111340 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 251 | 3 | 272 | 354 | WP_268230074.1 MFS transporter [Sphingobacterium sp. UT-1RO-CII-1] | diamond | 249 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium sp. UT-1RO-CII-1 | |
| 12875600 | 12875600 | PRJEB56027_P_NODE_103531_length_264_cov_1.345550_g100722_i0 | PRJEB56027 | 103531 | 264 | 1.34555 | 3.552252 | Rhodocytophaga rosea | 2704465 | Bacteria | Bacteria | 171 | 1.36e-49 | NR | WP_162444647.1 | 2704465 | g100722 | i0 | 96.6 | 0.988636363636364 | 87 | 3 | 98.9 | 0 | 2 | 262 | 158 | 244 | WP_162444647.1 aminopeptidase P N-terminal domain-containing protein [Rhodocytophaga rosea] | diamond | 261 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Rhodocytophagaceae | Rhodocytophaga | Rhodocytophaga rosea | |
| 20523319 | 20523319 | PRJEB56027_P_NODE_117477_length_249_cov_1.477273_g114668_i0 | PRJEB56027 | 117477 | 249 | 1.477273 | 3.67840977 | Flavobacterium sp. | 239 | Bacteria | Bacteria | 135 | 8.71e-35 | NR | MDI1254958.1 | 239 | g114668 | i0 | 86.7 | 2.97590361445783 | 83 | 10 | 98.8 | 1 | 2 | 247 | 307 | 389 | MDI1254958.1 zinc-dependent metalloprotease family protein [Flavobacterium sp.] | diamond | 741 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 26685264 | 26685264 | PRJEB56027_P_NODE_119781_length_248_cov_0.880000_g116972_i0 | PRJEB56027 | 119781 | 248 | 0.88 | 2.1824 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 145 | 2e-40 | NR | MEN9570738.1 | 1898104 | g116972 | i0 | 86.6 | 2.9758064516129 | 82 | 11 | 99.2 | 0 | 246 | 1 | 3 | 84 | MEN9570738.1 hypothetical protein [Bacteroidota bacterium] | diamond | 738 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26875662 | 26875662 | PRJEB56027_P_NODE_114301_length_251_cov_0.865169_g111492_i0 | PRJEB56027 | 114301 | 251 | 0.865169 | 2.17157419 | Parabacteroides | 375288 | Bacteria | Bacteria | 96.3 | 7.879999999999999e-23 | NR | WP_122373075.1 | 375288 | g111492 | i0 | 85.4 | 1.14741035856574 | 48 | 7 | 57.4 | 0 | 249 | 106 | 132 | 179 | WP_122373075.1 MULTISPECIES: flavodoxin family protein [Parabacteroides] | diamond | 288 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Tannerellaceae | Parabacteroides | ||
| 27760476 | 27760476 | PRJEB56027_P_NODE_123144_length_246_cov_1.433526_g120335_i0 | PRJEB56027 | 123144 | 246 | 1.433526 | 3.52647396 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 56.2 | 6.69e-7 | NR | PYO90632.1 | 2026742 | g120335 | i0 | 44.4 | 0.98780487804878 | 81 | 42 | 95.1 | 2 | 246 | 13 | 152 | 232 | PYO90632.1 MAG: hypothetical protein DMD66_01990 [Gemmatimonadota bacterium] | diamond | 243 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27981230 | 27981230 | PRJEB56027_P_NODE_136485_length_231_cov_2.430380_g133676_i0 | PRJEB56027 | 136485 | 231 | 2.43038 | 5.6141778 | Riemerella sp. | 2382126 | Bacteria | Bacteria | 79.7 | 9.97e-17 | NR | RKW62188.1 | 2382126 | g133676 | i0 | 100 | 0.519480519480519 | 40 | 0 | 51.9 | 0 | 121 | 2 | 1 | 40 | RKW62188.1 MAG: transcriptional repressor [Riemerella sp.] | diamond | 120 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Riemerella | Riemerella sp. | |
| 28486393 | 28486393 | PRJEB56027_P_NODE_107907_length_258_cov_1.664865_g105098_i0 | PRJEB56027 | 107907 | 258 | 1.664865 | 4.2953517 | Flavobacteriaceae bacterium | 1871037 | Bacteria | Bacteria | 176 | 4.9700000000000003e-51 | NR | HCO20130.1 | 1871037 | g105098 | i0 | 100 | 0.988372093023256 | 85 | 0 | 98.8 | 0 | 256 | 2 | 66 | 150 | HCO20130.1 RagB/SusD family nutrient uptake outer membrane protein [Flavobacteriaceae bacterium] | diamond | 255 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacteriaceae bacterium | ||
| 28763702 | 28763702 | PRJEB56027_P_NODE_125927_length_245_cov_0.895349_g123118_i0 | PRJEB56027 | 125927 | 245 | 0.895349 | 2.19360505 | Odoribacteraceae | 1853231 | Bacteria | Bacteria | 149 | 1.09e-40 | NR | WP_013612163.1 | 28118 | g123118 | i0 | 87.7 | 4.93469387755102 | 81 | 10 | 99.2 | 0 | 243 | 1 | 6 | 86 | WP_013612163.1 aspartate ammonia-lyase [Odoribacter splanchnicus] | diamond | 1209 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Odoribacteraceae | Odoribacter | Odoribacter splanchnicus | |
| 28865202 | 28865202 | PRJEB56027_P_NODE_117328_length_249_cov_1.715909_g114519_i0 | PRJEB56027 | 117328 | 249 | 1.715909 | 4.27261341 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 42.7 | 0.0396 | NR | MBT3341496.1 | 2026742 | g114519 | i0 | 66.7 | 0.289156626506024 | 24 | 8 | 28.9 | 0 | 19 | 90 | 139 | 162 | MBT3341496.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 72 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29174381 | 29174381 | PRJEB56027_P_NODE_120729_length_247_cov_2.488506_g117920_i0 | PRJEB56027 | 120729 | 247 | 2.488506 | 6.14660982 | Porphyromonas | 836 | Bacteria | Bacteria | 115 | 3.28e-28 | NR | WP_289121340.1 | 159274 | g117920 | i0 | 98.3 | 1.4331983805668 | 59 | 1 | 71.7 | 0 | 2 | 178 | 391 | 449 | WP_289121340.1 YihY/virulence factor BrkB family protein [uncultured Porphyromonas sp.] | diamond | 354 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | uncultured Porphyromonas sp. | |
| 29363792 | 29363792 | PRJEB56027_P_NODE_103209_length_264_cov_2.026178_g100400_i0 | PRJEB56027 | 103209 | 264 | 2.026178 | 5.34910992 | Kaistella | 2782231 | Bacteria | Bacteria | 72.4 | 1.93e-13 | NR | WP_039350131.1 | 266749 | g100400 | i0 | 47 | 3.68181818181818 | 83 | 38 | 92 | 2 | 261 | 19 | 1 | 79 | WP_039350131.1 hypothetical protein [Kaistella jeonii] | diamond | 972 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Kaistella | Kaistella jeonii | |
| 29464757 | 29464757 | PRJEB56027_P_NODE_107170_length_259_cov_1.634409_g104361_i0 | PRJEB56027 | 107170 | 259 | 1.634409 | 4.23311931 | Cloacibacterium caeni | 2004710 | Bacteria | Bacteria | 159 | 2.24e-48 | NR | MFN3270937.1 | 2004710 | g104361 | i0 | 98.8 | 0.984555984555985 | 85 | 1 | 98.5 | 0 | 5 | 259 | 1 | 85 | MFN3270937.1 type II toxin-antitoxin system VapC family toxin [Cloacibacterium caeni] | diamond | 255 | 159 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Cloacibacterium | Cloacibacterium caeni | |
| 29615945 | 29615945 | PRJEB56027_P_NODE_112110_length_253_cov_1.477778_g109301_i0 | PRJEB56027 | 112110 | 253 | 1.477778 | 3.73877834 | root | 1 | Root_unresolved | Root_unresolved | 167 | 2.87e-46 | NR | WP_294627524.1 | 162156 | g109301 | i0 | 88.1 | 12.9486166007905 | 84 | 10 | 99.6 | 0 | 253 | 2 | 417 | 500 | WP_294627524.1 alpha-galactosidase [uncultured Bacteroides sp.] | diamond | 3276 | 168 | 0.994047619047619 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | uncultured Bacteroides sp. | |
| 29774014 | 29774014 | PRJEB56027_P_NODE_103591_length_264_cov_1.225131_g100782_i0 | PRJEB56027 | 103591 | 264 | 1.225131 | 3.23434584 | Roseisolibacter | 2093335 | Bacteria | Bacteria | 134 | 7.31e-36 | NR | WP_284351890.1 | 2014610 | g100782 | i0 | 71.3 | 3.95454545454545 | 87 | 25 | 98.9 | 0 | 3 | 263 | 251 | 337 | WP_284351890.1 radical SAM family heme chaperone HemW [Roseisolibacter agri] | diamond | 1044 | 135 | 0.992592592592593 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 30065054 | 30065054 | PRJEB56027_P_NODE_137612_length_227_cov_2.487013_g134803_i0 | PRJEB56027 | 137612 | 227 | 2.487013 | 5.64551951 | Porphyromonas sp. | 1924944 | Bacteria | Bacteria | 109 | 4.01e-28 | NR | MFC2630513.1 | 1924944 | g134803 | i0 | 100 | 1.40088105726872 | 53 | 0 | 70 | 0 | 2 | 160 | 72 | 124 | MFC2630513.1 transporter associated domain-containing protein [Porphyromonas sp.] | diamond | 318 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. | |
| 30350095 | 30350095 | PRJEB56027_P_NODE_89872_length_283_cov_1.276190_g87063_i0 | PRJEB56027 | 89872 | 283 | 1.27619 | 3.6116177 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 70.1 | 1.51e-11 | NR | RMG81238.1 | 1898104 | g87063 | i0 | 57.4 | 2.97879858657244 | 61 | 26 | 64.7 | 0 | 1 | 183 | 370 | 430 | RMG81238.1 MAG: choice-of-anchor D domain-containing protein, partial [Bacteroidota bacterium] | diamond | 843 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30690235 | 30690235 | PRJEB56027_P_NODE_128033_length_244_cov_0.900585_g125224_i0 | PRJEB56027 | 128033 | 244 | 0.900585 | 2.1974274 | Sphingobacterium | 28453 | Bacteria | Bacteria | 165 | 5.29e-47 | NR | WP_345068939.1 | 768534 | g125224 | i0 | 100 | 1.99180327868852 | 81 | 0 | 99.6 | 0 | 1 | 243 | 160 | 240 | WP_345068939.1 UDP-N-acetylmuramate--L-alanine ligase [Sphingobacterium thermophilum] | diamond | 486 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium thermophilum | |
| 30974819 | 30974819 | PRJEB56027_P_NODE_112694_length_252_cov_1.804469_g109885_i0 | PRJEB56027 | 112694 | 252 | 1.804469 | 4.54726188 | Chitinophagaceae | 563835 | Bacteria | Bacteria | 96.7 | 3.36e-21 | NR | HXS37735.1 | 2307286 | g109885 | i0 | 92 | 2.97619047619048 | 50 | 4 | 59.5 | 0 | 252 | 103 | 421 | 470 | HXS37735.1 RNA polymerase factor sigma-54 [Flavipsychrobacter sp.] | diamond | 750 | 97.4 | 0.992813141683778 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Flavipsychrobacter | Flavipsychrobacter sp. | |
| 31170782 | 31170782 | PRJEB56027_P_NODE_118155_length_249_cov_0.875000_g115346_i0 | PRJEB56027 | 118155 | 249 | 0.875 | 2.17875 | Bacteroides sp. | 29523 | Bacteria | Bacteria | 138 | 7.44e-38 | NR | MCI1647371.1 | 29523 | g115346 | i0 | 73.5 | 3 | 83 | 22 | 100 | 0 | 1 | 249 | 47 | 129 | MCI1647371.1 endonuclease/exonuclease/phosphatase family protein [Bacteroides sp.] | diamond | 747 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides sp. | |
| 32088313 | 32088313 | PRJEB56027_P_NODE_92178_length_279_cov_2.932039_g89369_i0 | PRJEB56027 | 92178 | 279 | 2.932039 | 8.18038881 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 102 | 1.6500000000000002e-26 | NR | HEX8904273.1 | 3047548 | g89369 | i0 | 76.9 | 0.698924731182796 | 65 | 15 | 69.9 | 0 | 3 | 197 | 10 | 74 | HEX8904273.1 LysR substrate-binding domain-containing protein [Longimicrobiaceae bacterium] | diamond | 195 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 32088314 | 32088314 | PRJEB56027_P_NODE_92618_length_279_cov_1.349515_g89809_i0 | PRJEB56027 | 92618 | 279 | 1.349515 | 3.76514685 | Segetibacter sp. 3557_3 | 2547429 | Bacteria | Bacteria | 43.9 | 0.0182 | NR | WP_133267458.1 | 2547429 | g89809 | i0 | 38.3 | 0.645161290322581 | 60 | 35 | 63.4 | 2 | 247 | 71 | 47 | 105 | WP_133267458.1 sulfite exporter TauE/SafE family protein [Segetibacter sp. 3557_3] | diamond | 180 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Segetibacter | Segetibacter sp. 3557_3 | |
| 32468290 | 32468290 | PRJEB56027_P_NODE_114599_length_251_cov_0.865169_g111790_i0 | PRJEB56027 | 114599 | 251 | 0.865169 | 2.17157419 | Sphingobacterium cavernae | 2592657 | Bacteria | Bacteria | 47.8 | 4.6e-5 | NR | WP_149912844.1 | 2592657 | g111790 | i0 | 100 | 0.274900398406374 | 23 | 0 | 27.5 | 0 | 182 | 250 | 1 | 23 | WP_149912844.1 hypothetical protein [Sphingobacterium cavernae] | diamond | 69 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium cavernae | |
| 32468291 | 32468291 | PRJEB56027_P_NODE_128419_length_243_cov_1.811765_g125610_i0 | PRJEB56027 | 128419 | 243 | 1.811765 | 4.40258895 | Ginsengibacter sp. | 2806034 | Bacteria | Bacteria | 46.6 | 0.00113 | NR | MEO7121255.1 | 2806034 | g125610 | i0 | 34.6 | 0.962962962962963 | 78 | 50 | 95.1 | 1 | 235 | 5 | 42 | 119 | MEO7121255.1 hypothetical protein [Ginsengibacter sp.] | diamond | 234 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ginsengibacter | Ginsengibacter sp. | |
| 32499873 | 32499873 | PRJEB56027_P_NODE_122659_length_246_cov_2.260116_g119850_i0 | PRJEB56027 | 122659 | 246 | 2.260116 | 5.55988536 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 82.4 | 4.37e-16 | NR | MBL7743379.1 | 1869212 | g119850 | i0 | 56 | 1.02439024390244 | 84 | 34 | 98.8 | 2 | 243 | 1 | 1067 | 1150 | MBL7743379.1 heparin lyase I family protein [Chitinophagaceae bacterium] | diamond | 252 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae 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);;