contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA562549" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545753 | 545753 | PRJNA562549_P_NODE_32541_length_209_cov_0.878378_g32308_i0 | PRJNA562549 | 32541 | 209 | 0.878378 | 1.83581002 | Bacteria | 2 | Bacteria | Bacteria | 97.1 | 6.160000000000001e-22 | NR | WP_092016699.1 | 1079859 | g32308 | i0 | 67.2 | 46.3492822966507 | 67 | 22 | 96.2 | 0 | 201 | 1 | 27 | 93 | WP_092016699.1 redox-regulated ATPase YchF [Pseudarcicella hirudinis] | diamond | 9687 | 97.8 | 0.992842535787321 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Pseudarcicella | Pseudarcicella hirudinis | |
| 27173750 | 27173750 | PRJNA562549_P_NODE_16902_length_281_cov_1.181818_g16669_i0 | PRJNA562549 | 16902 | 281 | 1.181818 | 3.32090858 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 114 | 1.4700000000000002e-27 | NR | MEL6804374.1 | 1898104 | g16669 | i0 | 65.9 | 0.97153024911032 | 91 | 31 | 97.2 | 0 | 3 | 275 | 45 | 135 | MEL6804374.1 sodium/proton-translocating pyrophosphatase [Bacteroidota bacterium] | diamond | 273 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27205350 | 27205350 | PRJNA562549_P_NODE_36462_length_202_cov_0.921986_g36229_i0 | PRJNA562549 | 36462 | 202 | 0.921986 | 1.86241172 | Bacteroides acidifaciens | 85831 | Bacteria | Bacteria | 53.5 | 3.38e-6 | NR | WP_135037569.1 | 85831 | g36229 | i0 | 48.9 | 0.698019801980198 | 47 | 24 | 69.8 | 0 | 10 | 150 | 69 | 115 | WP_135037569.1 tetratricopeptide repeat protein [Bacteroides acidifaciens] | diamond | 141 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides acidifaciens | |
| 27504017 | 27504017 | PRJNA562549_P_NODE_20183_length_259_cov_1.616162_g19950_i0 | PRJNA562549 | 20183 | 259 | 1.616162 | 4.18585958 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 111 | 3.06e-28 | NR | MCO4818468.1 | 1898104 | g19950 | i0 | 64.9 | 9.41698841698842 | 74 | 26 | 85.7 | 0 | 35 | 256 | 39 | 112 | MCO4818468.1 peptide-methionine (S)-S-oxide reductase MsrA [Bacteroidota bacterium] | diamond | 2439 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27584583 | 27584583 | PRJNA562549_P_NODE_11764_length_334_cov_1.794872_g11531_i0 | PRJNA562549 | 11764 | 334 | 1.794872 | 5.99487248 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 184 | 1.16e-51 | NR | MCA6491779.1 | 1869212 | g11531 | i0 | 79.3 | 0.997005988023952 | 111 | 23 | 99.7 | 0 | 333 | 1 | 444 | 554 | MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] | diamond | 333 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27647931 | 27647931 | PRJNA562549_P_NODE_11804_length_333_cov_2.551471_g11571_i0 | PRJNA562549 | 11804 | 333 | 2.551471 | 8.49639843 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 48.5 | 0.00107 | NR | MBL7816022.1 | 2202734 | g11571 | i0 | 48.5 | 0.594594594594595 | 66 | 34 | 59.5 | 0 | 31 | 228 | 2680 | 2745 | MBL7816022.1 gliding motility-associated C-terminal domain-containing protein [Saprospiraceae bacterium] | diamond | 198 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 27868713 | 27868713 | PRJNA562549_P_NODE_7625_length_416_cov_1.414085_g7392_i0 | PRJNA562549 | 7625 | 416 | 1.414085 | 5.8825936 | Flammeovirgaceae bacterium | 2026740 | Bacteria | Bacteria | 185 | 2.91e-57 | NR | MFM7856568.1 | 2026740 | g7392 | i0 | 70.6 | 0.858173076923077 | 119 | 35 | 85.8 | 0 | 357 | 1 | 1 | 119 | MFM7856568.1 hypothetical protein [Flammeovirgaceae bacterium] | diamond | 357 | 185 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flammeovirgaceae | Flammeovirgaceae bacterium | ||
| 27900182 | 27900182 | PRJNA562549_P_NODE_13405_length_314_cov_1.027668_g13172_i0 | PRJNA562549 | 13405 | 314 | 1.027668 | 3.22687752 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 77.4 | 5.3e-14 | NR | HKJ30596.1 | 2497613 | g13172 | i0 | 40.4 | 0.945859872611465 | 99 | 50 | 86.9 | 4 | 8 | 280 | 66 | 163 | HKJ30596.1 phosphatidylinositol-specific phospholipase C domain-containing protein [Balneolales bacterium] | diamond | 297 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 27963524 | 27963524 | PRJNA562549_P_NODE_16145_length_287_cov_1.725664_g15912_i0 | PRJNA562549 | 16145 | 287 | 1.725664 | 4.95265568 | Mucilaginibacter sp. X5P1 | 2723088 | Bacteria | Bacteria | 60.5 | 1.48e-8 | NR | WP_183572067.1 | 2723088 | g15912 | i0 | 40.5 | 0.825783972125436 | 79 | 44 | 81.5 | 2 | 21 | 254 | 2 | 78 | WP_183572067.1 NAD(P)-dependent oxidoreductase [Mucilaginibacter sp. X5P1] | diamond | 237 | 60.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sp. X5P1 | |
| 28279095 | 28279095 | PRJNA562549_P_NODE_31546_length_211_cov_0.866667_g31313_i0 | PRJNA562549 | 31546 | 211 | 0.866667 | 1.82866737 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 62 | 3.81e-9 | NR | MEC8739552.1 | 1898104 | g31313 | i0 | 66 | 2.04739336492891 | 47 | 16 | 66.8 | 0 | 180 | 40 | 3 | 49 | MEC8739552.1 acetyl-CoA C-acyltransferase [Bacteroidota bacterium] | diamond | 432 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28437267 | 28437267 | PRJNA562549_P_NODE_12986_length_318_cov_2.879377_g12753_i0 | PRJNA562549 | 12986 | 318 | 2.879377 | 9.15641886 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 52.8 | 2.02e-5 | NR | MBR0123451.1 | 2030927 | g12753 | i0 | 64.9 | 1.60377358490566 | 37 | 13 | 34.9 | 0 | 1 | 111 | 15 | 51 | MBR0123451.1 SEL1-like repeat protein [Bacteroidales bacterium] | diamond | 510 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28721414 | 28721414 | PRJNA562549_P_NODE_28427_length_221_cov_1.625000_g28194_i0 | PRJNA562549 | 28427 | 221 | 1.625 | 3.59125 | Gelidibacter sp. F2691 | 2926852 | Bacteria | Bacteria | 61.2 | 8.59e-9 | NR | MCK0124720.1 | 2926852 | g28194 | i0 | 46.6 | 0.990950226244344 | 73 | 31 | 99.1 | 2 | 219 | 1 | 1466 | 1530 | MCK0124720.1 gliding motility-associated C-terminal domain-containing protein [Gelidibacter sp. F2691] | diamond | 219 | 61.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Gelidibacter | Gelidibacter sp. F2691 | |
| 29082614 | 29082614 | PRJNA562549_P_NODE_36488_length_202_cov_0.921986_g36255_i0 | PRJNA562549 | 36488 | 202 | 0.921986 | 1.86241172 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.8 | 2.55e-4 | NR | HXB13268.1 | 2044936 | g36255 | i0 | 44.3 | 3.63861386138614 | 61 | 31 | 90.6 | 1 | 200 | 18 | 91 | 148 | HXB13268.1 hypothetical protein [Bacteroidia bacterium] | diamond | 735 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidia bacterium | ||||
| 29321176 | 29321176 | PRJNA562549_P_NODE_26689_length_228_cov_1.305389_g26456_i0 | PRJNA562549 | 26689 | 228 | 1.305389 | 2.97628692 | Lentimicrobium sp. | 2034841 | Bacteria | Bacteria | 72.4 | 3.27e-14 | NR | HLO89802.1 | 2034841 | g26456 | i0 | 61.4 | 0.75 | 57 | 22 | 75 | 0 | 173 | 3 | 1 | 57 | HLO89802.1 hypothetical protein [Lentimicrobium sp.] | diamond | 171 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Lentimicrobiaceae | Lentimicrobium | Lentimicrobium sp. | |
| 30141951 | 30141951 | PRJNA562549_P_NODE_33832_length_207_cov_0.890411_g33599_i0 | PRJNA562549 | 33832 | 207 | 0.890411 | 1.84315077 | Flectobacillus roseus | 502259 | Bacteria | Bacteria | 127 | 2.63e-32 | NR | WP_283345504.1 | 502259 | g33599 | i0 | 97.1 | 0.985507246376812 | 68 | 2 | 98.6 | 0 | 206 | 3 | 230 | 297 | WP_283345504.1 M1 family metallopeptidase [Flectobacillus roseus] | diamond | 204 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | Flectobacillus roseus | |
| 30963972 | 30963972 | PRJNA562549_P_NODE_27234_length_226_cov_1.181818_g27001_i0 | PRJNA562549 | 27234 | 226 | 1.181818 | 2.67090868 | Hanstruepera ponticola | 2042995 | Bacteria | Bacteria | 60.8 | 1.28e-8 | NR | WP_104735919.1 | 2042995 | g27001 | i0 | 52.2 | 6.30530973451327 | 67 | 29 | 87.6 | 2 | 22 | 219 | 1163 | 1227 | WP_104735919.1 gliding motility-associated C-terminal domain-containing protein [Hanstruepera ponticola] | diamond | 1425 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Hanstruepera | Hanstruepera ponticola | |
| 31103940 | 31103940 | PRJNA562549_P_NODE_32135_length_210_cov_0.872483_g31902_i0 | PRJNA562549 | 32135 | 210 | 0.872483 | 1.8322143 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.1 | 5.44e-12 | NR | HWG53971.1 | 2026741 | g31902 | i0 | 50 | 11 | 70 | 32 | 95.7 | 1 | 202 | 2 | 125 | 194 | HWG53971.1 insulinase family protein [Gemmatimonadaceae bacterium] | diamond | 2310 | 70.5 | 0.994326241134752 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31121445 | 31121445 | PRJNA562549_P_NODE_32155_length_210_cov_0.872483_g31922_i0 | PRJNA562549 | 32155 | 210 | 0.872483 | 1.8322143 | Tenacibaculum sp. M341 | 2530339 | Bacteria | Bacteria | 41.6 | 0.00766 | NR | WP_132721297.1 | 2530339 | g31922 | i0 | 42.6 | 0.771428571428571 | 54 | 29 | 74.3 | 1 | 45 | 200 | 5 | 58 | WP_132721297.1 hypothetical protein [Tenacibaculum sp. M341] | diamond | 162 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Tenacibaculum | Tenacibaculum sp. M341 | |
| 31754272 | 31754272 | PRJNA562549_P_NODE_32137_length_210_cov_0.872483_g31904_i0 | PRJNA562549 | 32137 | 210 | 0.872483 | 1.8322143 | Paludibacteraceae bacterium | 2748031 | Bacteria | Bacteria | 54.7 | 1.46e-6 | NR | MBR5854391.1 | 2748031 | g31904 | i0 | 51.4 | 0.528571428571429 | 37 | 18 | 52.9 | 0 | 208 | 98 | 627 | 663 | MBR5854391.1 SEL1-like repeat protein [Paludibacteraceae bacterium] | diamond | 111 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Paludibacteraceae | Paludibacteraceae bacterium | ||
| 31754274 | 31754274 | PRJNA562549_P_NODE_34337_length_206_cov_0.896552_g34104_i0 | PRJNA562549 | 34337 | 206 | 0.896552 | 1.84689712 | Lishizhenia tianjinensis | 477690 | Bacteria | Bacteria | 58.5 | 6.16e-8 | NR | WP_139230422.1 | 477690 | g34104 | i0 | 50.8 | 0.946601941747573 | 65 | 30 | 93.2 | 2 | 195 | 4 | 496 | 559 | WP_139230422.1 HYR domain-containing protein, partial [Lishizhenia tianjinensis] | diamond | 195 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Crocinitomicaceae | Lishizhenia | Lishizhenia tianjinensis | |
| 31799636 | 31799636 | PRJNA562549_P_NODE_8797_length_387_cov_3.288344_g8564_i0 | PRJNA562549 | 8797 | 387 | 3.288344 | 12.72589128 | Bacteroidota | 976 | Bacteria | Bacteria | 115 | 2.17e-29 | NR | PHR93869.1 | 1977054 | g8564 | i0 | 57.1 | 9.14728682170543 | 91 | 39 | 70.5 | 0 | 84 | 356 | 36 | 126 | PHR93869.1 MAG: alkene reductase, partial [Leeuwenhoekiella sp.] | diamond | 3540 | 116 | 0.991379310344828 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Leeuwenhoekiella | Leeuwenhoekiella sp. | |
| 31849127 | 31849127 | PRJNA562549_P_NODE_21097_length_254_cov_1.124352_g20864_i0 | PRJNA562549 | 21097 | 254 | 1.124352 | 2.85585408 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 42.7 | 0.0434 | NR | MFN5323516.1 | 1898104 | g20864 | i0 | 32.5 | 0.94488188976378 | 80 | 50 | 89.8 | 1 | 253 | 26 | 600 | 679 | MFN5323516.1 M1 family metallopeptidase [Bacteroidota bacterium] | diamond | 240 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 32084525 | 32084525 | PRJNA562549_P_NODE_23458_length_242_cov_1.077348_g23225_i0 | PRJNA562549 | 23458 | 242 | 1.077348 | 2.60718216 | Bacteria | 2 | Bacteria | Bacteria | 76.3 | 5.65e-14 | NR | MAV15626.1 | 2026760 | g23225 | i0 | 47 | 5.56611570247934 | 66 | 35 | 81.8 | 0 | 201 | 4 | 192 | 257 | MAV15626.1 FAD-dependent oxidoreductase [Fidelibacterota bacterium] | diamond | 1347 | 77 | 0.990909090909091 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32260815 | 32260815 | PRJNA562549_P_NODE_33678_length_207_cov_0.890411_g33445_i0 | PRJNA562549 | 33678 | 207 | 0.890411 | 1.84315077 | Cytophagales bacterium | 2053541 | Bacteria | Bacteria | 48.1 | 2.12e-4 | NR | MCR9066865.1 | 2053541 | g33445 | i0 | 33.8 | 1.02898550724638 | 71 | 45 | 100 | 1 | 207 | 1 | 57 | 127 | MCR9066865.1 hypothetical protein [Cytophagales bacterium] | diamond | 213 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cytophagales 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);;