contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA793147" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4606213 | 4606213 | PRJNA793147_P_NODE_39324_length_268_cov_1.904523_g39058_i0 | PRJNA793147 | 39324 | 268 | 1.904523 | 5.10412164 | Flavobacterium sp. MFBS3-15 | 2989816 | Bacteria | Bacteria | 161 | 1.7699999999999996e-47 | NR | WP_265174263.1 | 2989816 | g39058 | i0 | 90.6 | 0.951492537313433 | 85 | 8 | 95.1 | 0 | 2 | 256 | 160 | 244 | WP_265174263.1 lysophospholipid acyltransferase family protein [Flavobacterium sp. MFBS3-15] | diamond | 255 | 161 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. MFBS3-15 | |
| 22454669 | 22454669 | PRJNA793147_P_NODE_13418_length_467_cov_1.447236_g13152_i0 | PRJNA793147 | 13418 | 467 | 1.447236 | 6.75859212 | Chitinophaga | 79328 | Bacteria | Bacteria | 144 | 6.04e-40 | NR | PSL48164.1 | 536980 | g13152 | i0 | 58.2 | 5.4603854389721604 | 122 | 50 | 78.4 | 1 | 373 | 8 | 62 | 182 | PSL48164.1 peptide-methionine (S)-S-oxide reductase [Chitinophaga niastensis] | diamond | 2550 | 145 | 0.993103448275862 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophaga | Chitinophaga niastensis | |
| 26990265 | 26990265 | PRJNA793147_P_NODE_52842_length_233_cov_1.756098_g52576_i0 | PRJNA793147 | 52842 | 233 | 1.756098 | 4.09170834 | Fibrella sp. WM1 | 3242485 | Bacteria | Bacteria | 89 | 1.74e-18 | NR | WP_370701424.1 | 3242485 | g52576 | i0 | 50.6 | 1.01716738197425 | 79 | 37 | 99.1 | 1 | 231 | 1 | 308 | 386 | WP_370701424.1 hypothetical protein [Fibrella sp. WM1] | diamond | 237 | 89 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Fibrella | Fibrella musci | |
| 27370160 | 27370160 | PRJNA793147_P_NODE_1763_length_1443_cov_8.368268_g1658_i0 | PRJNA793147 | 1763 | 1443 | 8.368268 | 120.75410724 | Emticicia sp. 17c | 3127704 | Bacteria | Bacteria | 417 | 2.75e-134 | NR | WP_337045214.1 | 3127704 | g1658 | i0 | 59.1 | 3.61746361746362 | 350 | 135 | 71.5 | 4 | 64 | 1095 | 32 | 379 | WP_337045214.1 hypothetical protein [Emticicia sp. 17c] | diamond | 5220 | 417 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia sp. 17c | |
| 28033092 | 28033092 | PRJNA793147_P_NODE_6185_length_724_cov_2.621374_g5936_i0 | PRJNA793147 | 6185 | 724 | 2.621374 | 18.97874776 | Chryseobacterium gambrini | 373672 | Bacteria | Bacteria | 57.8 | 1.38e-5 | NR | WP_084196507.1 | 373672 | g5936 | i0 | 36.5 | 0.658839779005525 | 159 | 92 | 63.4 | 5 | 667 | 209 | 274 | 429 | WP_084196507.1 endonuclease [Chryseobacterium gambrini] | diamond | 477 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium gambrini | |
| 28042173 | 28042173 | PRJNA793147_P_NODE_60765_length_227_cov_0.911392_g60499_i0 | PRJNA793147 | 60765 | 227 | 0.911392 | 2.06885984 | FCB group | 1783270 | Bacteria | Bacteria | 55.5 | 9.21e-7 | NR | MBT5289878.1 | 239 | g60499 | i0 | 77.4 | 13.7973568281938 | 31 | 7 | 41 | 0 | 93 | 1 | 2 | 32 | MBT5289878.1 UDP-glucose 4-epimerase GalE [Flavobacterium sp.] | diamond | 3132 | 55.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 28253896 | 28253896 | PRJNA793147_P_NODE_40166_length_266_cov_1.096447_g39900_i0 | PRJNA793147 | 40166 | 266 | 1.096447 | 2.91654902 | Elizabethkingia miricola | 172045 | Bacteria | Bacteria | 180 | 2.47e-52 | NR | WP_249489705.1 | 172045 | g39900 | i0 | 100 | 0.992481203007519 | 88 | 0 | 99.2 | 0 | 1 | 264 | 146 | 233 | WP_249489705.1 SGNH/GDSL hydrolase family protein [Elizabethkingia miricola] | diamond | 264 | 180 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Elizabethkingia | Elizabethkingia miricola | |
| 28569626 | 28569626 | PRJNA793147_P_NODE_10087_length_547_cov_109.619247_g9825_i0 | PRJNA793147 | 10087 | 547 | 109.619247 | 599.61728109 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 54.3 | 6.5e-5 | NR | PIE50853.1 | 2021391 | g9825 | i0 | 38.7 | 0.926873857404022 | 75 | 42 | 38.9 | 1 | 361 | 149 | 293 | 367 | PIE50853.1 MAG: endonuclease I [Flavobacteriales bacterium] | diamond | 507 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 28601358 | 28601358 | PRJNA793147_P_NODE_44947_length_251_cov_1.582418_g44681_i0 | PRJNA793147 | 44947 | 251 | 1.582418 | 3.97186918 | Emticicia sp. 17c | 3127704 | Bacteria | Bacteria | 99.4 | 5.01e-22 | NR | WP_337045214.1 | 3127704 | g44681 | i0 | 57.7 | 2.54581673306773 | 71 | 30 | 84.9 | 0 | 215 | 3 | 27 | 97 | WP_337045214.1 hypothetical protein [Emticicia sp. 17c] | diamond | 639 | 99.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia sp. 17c | |
| 28664481 | 28664481 | PRJNA793147_P_NODE_53767_length_233_cov_0.878049_g53501_i0 | PRJNA793147 | 53767 | 233 | 0.878049 | 2.04585417 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 95.9 | 7.209999999999999e-24 | NR | MBE6233119.1 | 2030927 | g53501 | i0 | 97.8 | 0.579399141630901 | 45 | 1 | 57.9 | 0 | 135 | 1 | 1 | 45 | MBE6233119.1 membrane protein insertion efficiency factor YidD [Bacteroidales bacterium] | diamond | 135 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28736745 | 28736745 | PRJNA793147_P_NODE_42447_length_259_cov_1.136842_g42181_i0 | PRJNA793147 | 42447 | 259 | 1.136842 | 2.94442078 | FCB group | 1783270 | Bacteria | Bacteria | 63.9 | 5.66e-10 | NR | MBP3440266.1 | 1929085 | g42181 | i0 | 49.2 | 5.06177606177606 | 61 | 31 | 70.7 | 0 | 184 | 2 | 5 | 65 | MBP3440266.1 uracil-DNA glycosylase [Tidjanibacter sp.] | diamond | 1311 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Rikenellaceae | Tidjanibacter | Tidjanibacter sp. | |
| 28916775 | 28916775 | PRJNA793147_P_NODE_37688_length_274_cov_1.243902_g37422_i0 | PRJNA793147 | 37688 | 274 | 1.243902 | 3.40829148 | Bacteroidetes bacterium GWF2_41_31 | 1797348 | Bacteria | Bacteria | 54.7 | 3.34e-6 | NR | OFY51433.1 | 1797348 | g37422 | i0 | 49.1 | 1.04014598540146 | 55 | 28 | 60.2 | 0 | 14 | 178 | 245 | 299 | OFY51433.1 MAG: hypothetical protein A2W85_09850 [Bacteroidetes bacterium GWF2_41_31] | diamond | 285 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidetes bacterium GWF2_41_31 | |||||
| 30496265 | 30496265 | PRJNA793147_P_NODE_59313_length_228_cov_0.905660_g59047_i0 | PRJNA793147 | 59313 | 228 | 0.90566 | 2.0649048 | Elizabethkingia | 308865 | Bacteria | Bacteria | 123 | 3.4e-32 | NR | WP_059156542.1 | 308865 | g59047 | i0 | 100 | 0.776315789473684 | 59 | 0 | 77.6 | 0 | 226 | 50 | 250 | 308 | WP_059156542.1 MULTISPECIES: glycosyltransferase [Elizabethkingia] | diamond | 177 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Elizabethkingia | ||
| 30590843 | 30590843 | PRJNA793147_P_NODE_8153_length_618_cov_1.497268_g7895_i0 | PRJNA793147 | 8153 | 618 | 1.497268 | 9.25311624 | Thermonemataceae bacterium | 2952977 | Bacteria | Bacteria | 50.8 | 0.00162 | NR | MDX1904699.1 | 2952977 | g7895 | i0 | 26 | 0.820388349514563 | 169 | 110 | 80.1 | 7 | 570 | 76 | 409 | 566 | MDX1904699.1 M60 family metallopeptidase [Thermonemataceae bacterium] | diamond | 507 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Thermonemataceae | Thermonemataceae bacterium | ||
| 30780473 | 30780473 | PRJNA793147_P_NODE_54014_length_232_cov_1.766871_g53748_i0 | PRJNA793147 | 54014 | 232 | 1.766871 | 4.09914072 | Sediminibacterium sp. | 1917865 | Bacteria | Bacteria | 150 | 5.739999999999999e-40 | NR | MBR2648733.1 | 1917865 | g53748 | i0 | 100 | 1.96551724137931 | 76 | 0 | 98.3 | 0 | 3 | 230 | 92 | 167 | MBR2648733.1 hypothetical protein [Sediminibacterium sp.] | diamond | 456 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Sediminibacterium | Sediminibacterium sp. | |
| 31326854 | 31326854 | PRJNA793147_P_NODE_4135_length_917_cov_2.713443_g3932_i0 | PRJNA793147 | 4135 | 917 | 2.713443 | 24.88227231 | Bacteroidota | 976 | Bacteria | Bacteria | 211 | 2.44e-63 | NR | RYG06432.1 | 1869212 | g3932 | i0 | 40.8 | 9.93565976008724 | 284 | 152 | 92.9 | 5 | 19 | 870 | 3 | 270 | RYG06432.1 MAG: purine-nucleoside phosphorylase [Chitinophagaceae bacterium] | diamond | 9111 | 211 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 31507700 | 31507700 | PRJNA793147_P_NODE_59816_length_228_cov_0.905660_g59550_i0 | PRJNA793147 | 59816 | 228 | 0.90566 | 2.0649048 | Mucilaginibacter ginsenosidivorans | 398053 | Bacteria | Bacteria | 90.5 | 8.17e-20 | NR | WP_147031243.1 | 398053 | g59550 | i0 | 55.3 | 2 | 76 | 34 | 100 | 0 | 228 | 1 | 59 | 134 | WP_147031243.1 class I SAM-dependent methyltransferase [Mucilaginibacter ginsenosidivorans] | diamond | 456 | 90.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Mucilaginibacter | Mucilaginibacter ginsenosidivorans | |
| 31823667 | 31823667 | PRJNA793147_P_NODE_17377_length_403_cov_2.071856_g17111_i0 | PRJNA793147 | 17377 | 403 | 2.071856 | 8.34957968 | Vicingus serpentipes | 1926625 | Bacteria | Bacteria | 175 | 2.89e-49 | NR | WP_147099270.1 | 1926625 | g17111 | i0 | 64 | 1.03473945409429 | 139 | 45 | 99.8 | 2 | 402 | 1 | 105 | 243 | WP_147099270.1 T9SS type A sorting domain-containing protein [Vicingus serpentipes] | diamond | 417 | 175 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Vicingaceae | Vicingus | Vicingus serpentipes | |
| 31855361 | 31855361 | PRJNA793147_P_NODE_39777_length_267_cov_1.414141_g39511_i0 | PRJNA793147 | 39777 | 267 | 1.414141 | 3.77575647 | Segetibacter sp. | 2231182 | Bacteria | Bacteria | 42.4 | 0.0173 | NR | MDB5193873.1 | 2231182 | g39511 | i0 | 34.8 | 0.51685393258427 | 46 | 30 | 51.7 | 0 | 56 | 193 | 2 | 47 | MDB5193873.1 hypothetical protein [Segetibacter sp.] | diamond | 138 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Segetibacter | Segetibacter sp. | |
| 31896197 | 31896197 | PRJNA793147_P_NODE_41617_length_261_cov_2.020833_g41351_i0 | PRJNA793147 | 41617 | 261 | 2.020833 | 5.27437413 | Bacteroidota | 976 | Bacteria | Bacteria | 45.1 | 0.0066 | NR | WP_177761665.1 | 2748319 | g41351 | i0 | 37.7 | 1.58620689655172 | 61 | 37 | 70.1 | 1 | 194 | 12 | 253 | 312 | WP_177761665.1 acetylornithine carbamoyltransferase [Flavobacterium sp. I3-2] | diamond | 414 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. I3-2 | |
| 32803418 | 32803418 | PRJNA793147_P_NODE_1740_length_1453_cov_3.151012_g1637_i0 | PRJNA793147 | 1740 | 1453 | 3.151012 | 45.78420436 | Flavobacterium collinsii | 1114861 | Bacteria | Bacteria | 52.4 | 0.0025 | NR | WP_395341608.1 | 1114861 | g1637 | i0 | 26.7 | 0.594631796283551 | 288 | 156 | 53.3 | 14 | 481 | 1254 | 47 | 309 | WP_395341608.1 hypothetical protein [Flavobacterium collinsii] | diamond | 864 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium collinsii | |
| 32897789 | 32897789 | PRJNA793147_P_NODE_1360_length_1625_cov_5.061054_g1271_i0 | PRJNA793147 | 1360 | 1625 | 5.061054 | 82.2421275 | Emticicia sp. 17c | 3127704 | Bacteria | Bacteria | 389 | 2.11e-122 | NR | WP_337045214.1 | 3127704 | g1271 | i0 | 53.8 | 0.655384615384615 | 355 | 156 | 64.4 | 4 | 1595 | 549 | 27 | 379 | WP_337045214.1 hypothetical protein [Emticicia sp. 17c] | diamond | 1065 | 389 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia sp. 17c | |
| 32897795 | 32897795 | PRJNA793147_P_NODE_33960_length_288_cov_1.611872_g33694_i0 | PRJNA793147 | 33960 | 288 | 1.611872 | 4.64219136 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 42.4 | 0.0455 | NR | MBU0696299.1 | 1898104 | g33694 | i0 | 38.3 | 0.625 | 60 | 37 | 62.5 | 0 | 98 | 277 | 72 | 131 | MBU0696299.1 hypothetical protein [Bacteroidota bacterium] | diamond | 180 | 42.4 | 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);;