contig_metadata
23 rows where bioproject = "PRJNA280983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4198748 | 4198748 | PRJNA280983_P_NODE_11064_length_162_cov_0.902655_g10949_i0 | PRJNA280983 | 11064 | 162 | 0.902655 | 1.4623011 | Mucilaginibacter jinjuensis | 1176721 | Bacteria | Bacteria | 176 | 7.67e-40 | NTclustered | gi|2442599841|gb|CP117167.1| | 1176721 | g10949 | i0 | 86.792 | 1.21604938271605 | 159 | 19 | 98 | 2 | 5 | 162 | 589833 | 589676 | Mucilaginibacter jinjuensis strain KACC 16571 chromosome, complete genome | blastn | 197 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter jinjuensis | |
| 13125489 | 13125489 | PRJNA280983_P_NODE_11571_length_151_cov_3.068627_g11456_i0 | PRJNA280983 | 11571 | 151 | 3.068627 | 4.63362677 | Myroides sp. JBRI-B21084 | 3119977 | Bacteria | Bacteria | 152 | 1.18e-32 | NTclustered | gi|2552842630|gb|CP120653.1| | 3119977 | g11456 | i0 | 84.768 | 13.0662251655629 | 151 | 23 | 100 | 0 | 1 | 151 | 1059468 | 1059318 | Myroides sp. JBRI-B21084 chromosome, complete genome | blastn | 1973 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Myroides | Myroides sp. JBRI-B21084 | |
| 16361466 | 16361466 | PRJNA280983_P_NODE_6573_length_233_cov_1.663043_g6458_i0 | PRJNA280983 | 6573 | 233 | 1.663043 | 3.87489019 | Flavobacterium | 237 | Bacteria | Bacteria | 226 | 1.1599999999999999e-54 | NTclustered | gi|1712897335|gb|CP042170.1| | 1179672 | g6458 | i0 | 84.188 | 10.3519313304721 | 234 | 36 | 100 | 1 | 1 | 233 | 560686 | 560919 | Flavobacterium sp. KBS0721 chromosome, complete genome | blastn | 2412 | 226 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. KBS0721 | |
| 16949014 | 16949014 | PRJNA280983_P_NODE_11094_length_162_cov_0.902655_g10979_i0 | PRJNA280983 | 11094 | 162 | 0.902655 | 1.4623011 | Mucilaginibacter sabulilitoris | 1173583 | Bacteria | Bacteria | 158 | 2.78e-34 | NTclustered | gi|2632603506|gb|CP139558.1| | 1173583 | g10979 | i0 | 84.81 | 2.34567901234568 | 158 | 22 | 97 | 2 | 6 | 162 | 2687748 | 2687904 | Mucilaginibacter sabulilitoris strain SNA2 chromosome, complete genome | blastn | 380 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter sabulilitoris | |
| 18223344 | 18223344 | PRJNA280983_P_NODE_9815_length_167_cov_0.864407_g9700_i0 | PRJNA280983 | 9815 | 167 | 0.864407 | 1.44355969 | Chitinophaga oryzae | 2725414 | Bacteria | Bacteria | 132 | 1.7500000000000002e-26 | NTclustered | gi|1832568489|gb|CP051205.1| | 2725414 | g9700 | i0 | 81.707 | 10.2215568862275 | 164 | 24 | 96 | 5 | 1 | 161 | 7688130 | 7687970 | Chitinophaga oryzae strain 1310 chromosome, complete genome | blastn | 1707 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophaga | Chitinophaga oryzae | |
| 19497574 | 19497574 | PRJNA280983_P_NODE_1896_length_533_cov_1.685950_g1783_i0 | PRJNA280983 | 1896 | 533 | 1.68595 | 8.9861135 | Flavobacterium | 237 | Bacteria | Bacteria | 214 | 6.45e-66 | NR | WP_024980831.1 | 237 | g1783 | i0 | 100 | 1.18198874296435 | 105 | 0 | 59.1 | 0 | 217 | 531 | 1 | 105 | WP_024980831.1 MULTISPECIES: bifunctional metallophosphatase/5'-nucleotidase [Flavobacterium] | diamond | 630 | 214 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | ||
| 24597758 | 24597758 | PRJNA280983_P_NODE_1720_length_560_cov_2.471624_g1610_i0 | PRJNA280983 | 1720 | 560 | 2.471624 | 13.8410944 | Seonamhaeicola sp. ML3 | 2937786 | Bacteria | Bacteria | 73.1 | 4.24e-8 | NTclustered | gi|2235330891|gb|CP096884.1| | 2937786 | g1610 | i0 | 82.558 | 0.741071428571429 | 86 | 12 | 15 | 2 | 391 | 473 | 1586387 | 1586302 | Seonamhaeicola sp. ML3 chromosome, complete genome | blastn | 415 | 73.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Seonamhaeicola | Seonamhaeicola sp. ML3 | |
| 26598963 | 26598963 | PRJNA280983_P_NODE_11061_length_162_cov_0.902655_g10946_i0 | PRJNA280983 | 11061 | 162 | 0.902655 | 1.4623011 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 115 | 4.01e-28 | NR | MCA6438644.1 | 1869212 | g10946 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 3 | 161 | 386 | 438 | MCA6438644.1 DNA helicase RecQ [Chitinophagaceae bacterium] | diamond | 159 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27863702 | 27863702 | PRJNA280983_P_NODE_10585_length_164_cov_0.886957_g10470_i0 | PRJNA280983 | 10585 | 164 | 0.886957 | 1.45460948 | Hydrobacter penzbergensis | 1235997 | Bacteria | Bacteria | 63.9 | 3.19e-10 | NR | WP_092725676.1 | 1235997 | g10470 | i0 | 100 | 0.49390243902439 | 27 | 0 | 49.4 | 0 | 82 | 2 | 1 | 27 | WP_092725676.1 cyclase family protein [Hydrobacter penzbergensis] | diamond | 81 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Hydrobacter | Hydrobacter penzbergensis | |
| 28084731 | 28084731 | PRJNA280983_P_NODE_11125_length_162_cov_0.902655_g11010_i0 | PRJNA280983 | 11125 | 162 | 0.902655 | 1.4623011 | Segatella maculosa OT 289 | 999422 | Bacteria | Bacteria | 76.6 | 5.41e-16 | NR | EHO68678.1 | 999422 | g11010 | i0 | 87.8 | 0.907407407407407 | 49 | 6 | 90.7 | 0 | 148 | 2 | 1 | 49 | EHO68678.1 hypothetical protein HMPREF9944_01932 [Segatella maculosa OT 289] | diamond | 147 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Segatella | Segatella maculosa | |
| 28305813 | 28305813 | PRJNA280983_P_NODE_9386_length_173_cov_1.645161_g9271_i0 | PRJNA280983 | 9386 | 173 | 1.645161 | 2.84612853 | Asinibacterium sp. OR53 | 925409 | Bacteria | Bacteria | 114 | 8.98e-28 | NR | WP_026769053.1 | 925409 | g9271 | i0 | 100 | 0.988439306358382 | 57 | 0 | 98.8 | 0 | 173 | 3 | 817 | 873 | WP_026769053.1 response regulator [Asinibacterium sp. OR53] | diamond | 171 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Asinibacterium | Asinibacterium sp. OR53 | |
| 28463847 | 28463847 | PRJNA280983_P_NODE_11006_length_162_cov_1.327434_g10891_i0 | PRJNA280983 | 11006 | 162 | 1.327434 | 2.15044308 | Flavobacterium sp. LM5 | 1938610 | Bacteria | Bacteria | 107 | 4.37e-27 | NR | WP_078213082.1 | 1938610 | g10891 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 3 | 161 | 143 | 195 | WP_078213082.1 5'-nucleotidase C-terminal domain-containing protein [Flavobacterium sp. LM5] | diamond | 159 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. LM5 | |
| 29221667 | 29221667 | PRJNA280983_P_NODE_10329_length_165_cov_0.879310_g10214_i0 | PRJNA280983 | 10329 | 165 | 0.87931 | 1.4508615 | Puia sp. | 2045100 | Bacteria | Bacteria | 89 | 4.42e-19 | NR | HVS98766.1 | 2045100 | g10214 | i0 | 72.7 | 3 | 55 | 15 | 100 | 0 | 165 | 1 | 184 | 238 | HVS98766.1 M20 family metallo-hydrolase [Puia sp.] | diamond | 495 | 89 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Puia | Puia sp. | |
| 29284431 | 29284431 | PRJNA280983_P_NODE_10889_length_163_cov_0.894737_g10774_i0 | PRJNA280983 | 10889 | 163 | 0.894737 | 1.45842131 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 67.4 | 2.51e-11 | NR | MES2133622.1 | 1898104 | g10774 | i0 | 58.5 | 2.92638036809816 | 53 | 22 | 97.5 | 0 | 4 | 162 | 113 | 165 | MES2133622.1 hypothetical protein [Bacteroidota bacterium] | diamond | 477 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29302309 | 29302309 | PRJNA280983_P_NODE_10629_length_164_cov_0.886957_g10514_i0 | PRJNA280983 | 10629 | 164 | 0.886957 | 1.45460948 | Bacteria | 2 | Bacteria | Bacteria | 90.9 | 1.39e-19 | NR | MBS1637510.1 | 1898104 | g10514 | i0 | 79.6 | 2.96341463414634 | 54 | 11 | 98.8 | 0 | 3 | 164 | 393 | 446 | MBS1637510.1 LPS-assembly protein LptD [Bacteroidota bacterium] | diamond | 486 | 90.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 29537181 | 29537181 | PRJNA280983_P_NODE_3410_length_368_cov_10.746082_g3295_i0 | PRJNA280983 | 3410 | 368 | 10.746082 | 39.54558176 | Ancylomarina sp. 16SWW S1-1 | 1970196 | Bacteria | Bacteria | 85.1 | 2.41e-16 | NR | WP_154200590.1 | 2499681 | g3295 | i0 | 47.4 | 1.36141304347826 | 78 | 40 | 63.6 | 1 | 353 | 120 | 3094 | 3170 | WP_154200590.1 tandem-95 repeat protein [Ancylomarina sp. 16SWW S1-10-2] | diamond | 501 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Marinifilaceae | Ancylomarina | Ancylomarina sp. 16SWW S1-10-2 | |
| 29870644 | 29870644 | PRJNA280983_P_NODE_10131_length_166_cov_0.871795_g10016_i0 | PRJNA280983 | 10131 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 117 | 8.95e-30 | NR | MES2514625.1 | 1898104 | g10016 | i0 | 98.1 | 18.5421686746988 | 54 | 1 | 97.6 | 0 | 164 | 3 | 52 | 105 | MES2514625.1 MBOAT family O-acyltransferase [Bacteroidota bacterium] | diamond | 3078 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30105592 | 30105592 | PRJNA280983_P_NODE_8532_length_188_cov_1.100719_g8417_i0 | PRJNA280983 | 8532 | 188 | 1.100719 | 2.06935172 | Flavobacterium polysaccharolyticum | 3133148 | Bacteria | Bacteria | 110 | 2.76e-29 | NR | WP_342691484.1 | 3133148 | g8417 | i0 | 88.7 | 0.98936170212766 | 62 | 7 | 98.9 | 0 | 1 | 186 | 49 | 110 | WP_342691484.1 DUF4870 domain-containing protein [Flavobacterium polysaccharolyticum] | diamond | 186 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium polysaccharolyticum | |
| 30548003 | 30548003 | PRJNA280983_P_NODE_10093_length_166_cov_0.871795_g9978_i0 | PRJNA280983 | 10093 | 166 | 0.871795 | 1.4471797 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 77 | 1.09e-14 | NR | MBS1636303.1 | 1898104 | g9978 | i0 | 60 | 0.993975903614458 | 55 | 22 | 99.4 | 0 | 165 | 1 | 56 | 110 | MBS1636303.1 hypothetical protein [Bacteroidota bacterium] | diamond | 165 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30786884 | 30786884 | PRJNA280983_P_NODE_10294_length_165_cov_0.879310_g10179_i0 | PRJNA280983 | 10294 | 165 | 0.87931 | 1.4508615 | Bacteroidota | 976 | Bacteria | Bacteria | 48.9 | 5.33e-5 | NR | WP_372770452.1 | 1925666 | g10179 | i0 | 49.1 | 8.4727272727272709 | 53 | 22 | 87.3 | 1 | 149 | 6 | 14 | 66 | WP_372770452.1 RNA polymerase sigma factor [Lutibacter sp.] | diamond | 1398 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Lutibacter | Lutibacter sp. | |
| 31211068 | 31211068 | PRJNA280983_P_NODE_10815_length_163_cov_0.894737_g10700_i0 | PRJNA280983 | 10815 | 163 | 0.894737 | 1.45842131 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 79.7 | 3.75e-16 | NR | MBS1636614.1 | 1898104 | g10700 | i0 | 66.7 | 0.993865030674847 | 54 | 17 | 97.5 | 1 | 162 | 4 | 7 | 60 | MBS1636614.1 hypothetical protein [Bacteroidota bacterium] | diamond | 162 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 31514173 | 31514173 | PRJNA280983_P_NODE_9816_length_167_cov_0.864407_g9701_i0 | PRJNA280983 | 9816 | 167 | 0.864407 | 1.44355969 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 3.21e-15 | NR | NBQ48564.1 | 2035813 | g9701 | i0 | 74 | 3.44910179640719 | 50 | 9 | 89.8 | 1 | 18 | 167 | 33 | 78 | NBQ48564.1 hypothetical protein [Sphingobacteriia bacterium] | diamond | 576 | 73.6 | 0.994565217391304 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriia bacterium | ||||
| 32508868 | 32508868 | PRJNA280983_P_NODE_10859_length_163_cov_0.894737_g10744_i0 | PRJNA280983 | 10859 | 163 | 0.894737 | 1.45842131 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 97.1 | 3.27e-22 | NR | MEN9599820.1 | 1898104 | g10744 | i0 | 86.8 | 1.95092024539877 | 53 | 7 | 97.5 | 0 | 161 | 3 | 77 | 129 | MEN9599820.1 hypothetical protein [Bacteroidota bacterium] | diamond | 318 | 97.1 | 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);;