contig_metadata
23 rows where bioproject = "PRJNA966993", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 941952 | 941952 | PRJNA966993_P_NODE_22561_length_442_cov_3.311653_g22114_i0 | PRJNA966993 | 22561 | 442 | 3.311653 | 14.63750626 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 54.7 | 0.012 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g22114 | i0 | 100 | 0.0656108597285068 | 29 | 0 | 7 | 0 | 311 | 339 | 155165 | 155193 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 942012 | 942012 | PRJNA966993_P_NODE_28841_length_394_cov_2.320872_g28389_i0 | PRJNA966993 | 28841 | 394 | 2.320872 | 9.14423568 | FCB group | 1783270 | Bacteria | Bacteria | 208 | 2.78e-63 | NR | HEY9229717.1 | 2026741 | g28389 | i0 | 72.9 | 14.8629441624365 | 129 | 35 | 98.2 | 0 | 3 | 389 | 74 | 202 | HEY9229717.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadaceae bacterium] | diamond | 5856 | 208 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 3492801 | 3492801 | PRJNA966993_P_NODE_35983_length_357_cov_1.661972_g35531_i0 | PRJNA966993 | 35983 | 357 | 1.661972 | 5.93324004 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 125 | 1.68e-30 | NR | MBU8871279.1 | 2448054 | g35531 | i0 | 57 | 0.899159663865546 | 107 | 45 | 89.1 | 1 | 356 | 39 | 391 | 497 | MBU8871279.1 S8 family serine peptidase [Gemmatimonadales bacterium] | diamond | 321 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 11469444 | 11469444 | PRJNA966993_P_NODE_53849_length_295_cov_2.702703_g53397_i0 | PRJNA966993 | 53849 | 295 | 2.702703 | 7.97297385 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 59.7 | 6e-8 | NR | HUE77705.1 | 2910168 | g53397 | i0 | 58.8 | 0.51864406779661 | 51 | 19 | 49.8 | 1 | 284 | 138 | 112 | 162 | HUE77705.1 ABC transporter ATP-binding protein [Longimicrobiales bacterium] | diamond | 153 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 25168245 | 25168245 | PRJNA966993_P_NODE_35440_length_360_cov_1.073171_g34988_i0 | PRJNA966993 | 35440 | 360 | 1.073171 | 3.8634156 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 60.2 | 2.04e-4 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g34988 | i0 | 94.737 | 0.105555555555556 | 38 | 2 | 11 | 0 | 323 | 360 | 4317957 | 4317920 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 38 | 60.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 27437009 | 27437009 | PRJNA966993_P_NODE_90103_length_246_cov_2.965318_g89651_i0 | PRJNA966993 | 90103 | 246 | 2.965318 | 7.29468228 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 44.7 | 0.00776 | NR | HEX8903360.1 | 3047548 | g89651 | i0 | 38 | 2.68292682926829 | 71 | 43 | 86.6 | 1 | 235 | 23 | 256 | 325 | HEX8903360.1 pitrilysin family protein [Longimicrobiaceae bacterium] | diamond | 660 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 27979829 | 27979829 | PRJNA966993_P_NODE_89845_length_247_cov_0.885057_g89393_i0 | PRJNA966993 | 89845 | 247 | 0.885057 | 2.18609079 | Gemmatimonas | 173479 | Bacteria | Bacteria | 93.6 | 5.01e-20 | NR | HYW31584.1 | 1962908 | g89393 | i0 | 57.5 | 4.71255060728745 | 73 | 30 | 88.7 | 1 | 2 | 220 | 400 | 471 | HYW31584.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonas sp.] | diamond | 1164 | 94.4 | 0.991525423728813 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 28636751 | 28636751 | PRJNA966993_P_NODE_39927_length_340_cov_2.906367_g39475_i0 | PRJNA966993 | 39927 | 340 | 2.906367 | 9.8816478 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 101 | 2.3000000000000003e-22 | NR | PYP03818.1 | 2026742 | g39475 | i0 | 66.7 | 6.95294117647059 | 78 | 19 | 62.6 | 1 | 126 | 338 | 63 | 140 | PYP03818.1 MAG: citrate (Si)-synthase [Gemmatimonadota bacterium] | diamond | 2364 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28800541 | 28800541 | PRJNA966993_P_NODE_80047_length_254_cov_1.701657_g79595_i0 | PRJNA966993 | 80047 | 254 | 1.701657 | 4.32220878 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 6.46e-6 | NR | MEO8478319.1 | 2026742 | g79595 | i0 | 39.5 | 4.83070866141732 | 76 | 36 | 79.1 | 3 | 8 | 208 | 270 | 344 | MEO8478319.1 ectonucleotide pyrophosphatase/phosphodiesterase [Gemmatimonadota bacterium] | diamond | 1227 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29110225 | 29110225 | PRJNA966993_P_NODE_101368_length_227_cov_3.383117_g100916_i0 | PRJNA966993 | 101368 | 227 | 3.383117 | 7.67967559 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 42.4 | 0.0422 | NR | HEX2218471.1 | 2448054 | g100916 | i0 | 42.2 | 0.594713656387665 | 45 | 26 | 59.5 | 0 | 22 | 156 | 855 | 899 | HEX2218471.1 DUF5916 domain-containing protein [Gemmatimonadales bacterium] | diamond | 135 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30120561 | 30120561 | PRJNA966993_P_NODE_63192_length_280_cov_1.487923_g62740_i0 | PRJNA966993 | 63192 | 280 | 1.487923 | 4.1661844 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 44.7 | 0.0119 | NR | MCZ6915570.1 | 2026742 | g62740 | i0 | 41.4 | 1.85357142857143 | 58 | 30 | 58.9 | 3 | 261 | 97 | 100 | 156 | MCZ6915570.1 sodium:solute symporter family protein [Gemmatimonadota bacterium] | diamond | 519 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30190093 | 30190093 | PRJNA966993_P_NODE_2752_length_1208_cov_14.881057_g2508_i0 | PRJNA966993 | 2752 | 1208 | 14.881057 | 179.76316856 | Gemmatimonadota | 142182 | Bacteria | Bacteria | 177 | 5.33e-45 | NR | HEY2377597.1 | 2026741 | g2508 | i0 | 42.3 | 2.44619205298013 | 272 | 138 | 65.1 | 9 | 845 | 60 | 541 | 803 | HEY2377597.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 2955 | 178 | 0.99438202247191 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30499864 | 30499864 | PRJNA966993_P_NODE_50493_length_305_cov_1.435345_g50041_i0 | PRJNA966993 | 50493 | 305 | 1.435345 | 4.37780225 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 119 | 5.47e-31 | NR | MFN8579683.1 | 2026741 | g50041 | i0 | 60.4 | 4.95737704918033 | 101 | 39 | 99.3 | 1 | 2 | 304 | 103 | 202 | MFN8579683.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 1512 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30594475 | 30594475 | PRJNA966993_P_NODE_48693_length_310_cov_2.848101_g48241_i0 | PRJNA966993 | 48693 | 310 | 2.848101 | 8.8291131 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 44.3 | 0.0217 | NR | MDX1493820.1 | 2910168 | g48241 | i0 | 32.9 | 0.764516129032258 | 79 | 51 | 74.5 | 1 | 5 | 235 | 123 | 201 | MDX1493820.1 DUF2157 domain-containing protein [Longimicrobiales bacterium] | diamond | 237 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 30759002 | 30759002 | PRJNA966993_P_NODE_58014_length_287_cov_2.878505_g57562_i0 | PRJNA966993 | 58014 | 287 | 2.878505 | 8.26130935 | Gaopeijia | 3381669 | Bacteria | Bacteria | 52.8 | 1.9e-5 | NR | MEX2471136.1 | 2026742 | g57562 | i0 | 35.5 | 1.79790940766551 | 62 | 34 | 59.6 | 2 | 116 | 286 | 403 | 463 | MEX2471136.1 choice-of-anchor B family protein [Gemmatimonadota bacterium] | diamond | 516 | 53.1 | 0.994350282485876 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31005333 | 31005333 | PRJNA966993_P_NODE_100294_length_236_cov_2.588957_g99842_i0 | PRJNA966993 | 100294 | 236 | 2.588957 | 6.10993852 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 59.3 | 4.72e-8 | NR | HMG11711.1 | 2026741 | g99842 | i0 | 48 | 0.953389830508475 | 75 | 35 | 95.3 | 2 | 227 | 3 | 23 | 93 | HMG11711.1 serine hydrolase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 225 | 59.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31068721 | 31068721 | PRJNA966993_P_NODE_2775_length_1204_cov_8.121132_g2529_i0 | PRJNA966993 | 2775 | 1204 | 8.121132 | 97.77842928 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 181 | 4.75e-48 | NR | HEY9015267.1 | 2448054 | g2529 | i0 | 36.1 | 4.31063122923588 | 335 | 187 | 79.2 | 10 | 211 | 1164 | 165 | 489 | HEY9015267.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium] | diamond | 5190 | 181 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31169414 | 31169414 | PRJNA966993_P_NODE_53915_length_295_cov_1.756757_g53463_i0 | PRJNA966993 | 53915 | 295 | 1.756757 | 5.18243315 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 160 | 9.31e-46 | NR | MDZ4390681.1 | 2448054 | g53463 | i0 | 76.8 | 4.81016949152542 | 95 | 22 | 96.6 | 0 | 10 | 294 | 156 | 250 | MDZ4390681.1 polysaccharide biosynthesis protein [Gemmatimonadales bacterium] | diamond | 1419 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31200825 | 31200825 | PRJNA966993_P_NODE_91975_length_245_cov_1.790698_g91523_i0 | PRJNA966993 | 91975 | 245 | 1.790698 | 4.3872101 | Candidatus Benthicola | 3056652 | Bacteria | Bacteria | 57.4 | 2.55e-7 | NR | MBT8462304.1 | 2026742 | g91523 | i0 | 39.7 | 3.33061224489796 | 68 | 41 | 83.3 | 0 | 40 | 243 | 91 | 158 | MBT8462304.1 ATP-binding cassette domain-containing protein [Gemmatimonadota bacterium] | diamond | 816 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31701028 | 31701028 | PRJNA966993_P_NODE_93857_length_244_cov_0.900585_g93405_i0 | PRJNA966993 | 93857 | 244 | 0.900585 | 2.1974274 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 57.8 | 1.77e-7 | NR | MEX2526951.1 | 2026742 | g93405 | i0 | 56.4 | 0.676229508196721 | 55 | 21 | 67.6 | 2 | 194 | 30 | 56 | 107 | MEX2526951.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 165 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32523897 | 32523897 | PRJNA966993_P_NODE_739_length_2009_cov_2.610537_g656_i0 | PRJNA966993 | 739 | 2009 | 2.610537 | 52.44568833 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 116 | 9.99e-23 | NR | HKK92073.1 | 2910168 | g656 | i0 | 27.2 | 0.918367346938776 | 615 | 317 | 83.9 | 24 | 323 | 2008 | 645 | 1181 | HKK92073.1 IPT/TIG domain-containing protein [Longimicrobiales bacterium] | diamond | 1845 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32618243 | 32618243 | PRJNA966993_P_NODE_64480_length_278_cov_1.502439_g64028_i0 | PRJNA966993 | 64480 | 278 | 1.502439 | 4.17678042 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 101 | 5.249999999999999e-24 | NR | HET9066910.1 | 2448054 | g64028 | i0 | 60 | 0.863309352517986 | 80 | 32 | 86.3 | 0 | 28 | 267 | 84 | 163 | HET9066910.1 YiiX/YebB-like N1pC/P60 family cysteine hydrolase [Gemmatimonadales bacterium] | diamond | 240 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32750530 | 32750530 | PRJNA966993_P_NODE_65080_length_277_cov_1.941176_g64628_i0 | PRJNA966993 | 65080 | 277 | 1.941176 | 5.37705752 | Bacteria | 2 | Bacteria | Bacteria | 58.5 | 1.95e-8 | NR | MBL0179116.1 | 2026742 | g64628 | i0 | 36.4 | 2.87003610108303 | 88 | 56 | 95.3 | 0 | 6 | 269 | 14 | 101 | MBL0179116.1 aquaporin [Gemmatimonadota bacterium] | diamond | 795 | 58.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;