contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15269160 | 15269160 | PRJNA884104_S_NODE_39212_length_330_cov_1.198444_g38469_i0 | PRJNA884104 | 39212 | 330 | 1.198444 | 3.9548652 | Bacteria | 2 | Bacteria | Bacteria | 152 | 7.85e-42 | NR | MBM4187711.1 | 2026742 | g38469 | i0 | 82 | 22.6090909090909 | 89 | 15 | 80.9 | 1 | 1 | 267 | 320 | 407 | MBM4187711.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadota bacterium] | diamond | 7461 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26738457 | 26738457 | PRJNA884104_S_NODE_44241_length_313_cov_1.079167_g43498_i0 | PRJNA884104 | 44241 | 313 | 1.079167 | 3.37779271 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 92.4 | 4.36e-20 | NR | HUG27709.1 | 2448054 | g43498 | i0 | 47.6 | 0.987220447284345 | 103 | 54 | 98.7 | 0 | 310 | 2 | 148 | 250 | HUG27709.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadales bacterium] | diamond | 309 | 92.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26897356 | 26897356 | PRJNA884104_S_NODE_48581_length_300_cov_1.171806_g47838_i0 | PRJNA884104 | 48581 | 300 | 1.171806 | 3.515418 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 46.2 | 0.0045 | NR | MBY0489199.1 | 2026741 | g47838 | i0 | 38.7 | 1.43 | 62 | 35 | 59 | 1 | 198 | 22 | 460 | 521 | MBY0489199.1 response regulator [Gemmatimonadaceae bacterium] | diamond | 429 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 26936701 | 26936701 | PRJNA884104_S_NODE_76322_length_247_cov_0.885057_g75579_i0 | PRJNA884104 | 76322 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0289 | NR | MEO7086209.1 | 2026741 | g75579 | i0 | 33.8 | 3.49797570850202 | 74 | 49 | 89.9 | 0 | 234 | 13 | 515 | 588 | MEO7086209.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] | diamond | 864 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27213290 | 27213290 | PRJNA884104_S_NODE_63242_length_262_cov_1.455026_g62499_i0 | PRJNA884104 | 63242 | 262 | 1.455026 | 3.81216812 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 106 | 7.45e-27 | NR | MDH3455568.1 | 2026742 | g62499 | i0 | 62.8 | 0.984732824427481 | 86 | 32 | 98.5 | 0 | 262 | 5 | 51 | 136 | MDH3455568.1 hypoxanthine phosphoribosyltransferase [Gemmatimonadota bacterium] | diamond | 258 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28161058 | 28161058 | PRJNA884104_S_NODE_57785_length_275_cov_1.524752_g57042_i0 | PRJNA884104 | 57785 | 275 | 1.524752 | 4.193068 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 57.4 | 1.94e-7 | NR | MBE0594856.1 | 2448054 | g57042 | i0 | 63.2 | 0.414545454545455 | 38 | 14 | 41.5 | 0 | 10 | 123 | 183 | 220 | MBE0594856.1 aconitate hydratase [Gemmatimonadales bacterium] | diamond | 114 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29147937 | 29147937 | PRJNA884104_S_NODE_87429_length_233_cov_2.081250_g86686_i0 | PRJNA884104 | 87429 | 233 | 2.08125 | 4.8493125 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 67.8 | 4.32e-11 | NR | HEY7503545.1 | 2448054 | g86686 | i0 | 52.5 | 8.18884120171674 | 61 | 28 | 78.5 | 1 | 231 | 49 | 253 | 312 | HEY7503545.1 serine hydrolase domain-containing protein [Gemmatimonadales bacterium] | diamond | 1908 | 67.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29202982 | 29202982 | PRJNA884104_S_NODE_82589_length_243_cov_0.905882_g81846_i0 | PRJNA884104 | 82589 | 243 | 0.905882 | 2.20129326 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 78.6 | 8.07e-15 | NR | MFI5232859.1 | 2448054 | g81846 | i0 | 56.3 | 2.41975308641975 | 64 | 27 | 79 | 1 | 225 | 34 | 354 | 416 | MFI5232859.1 ectonucleotide pyrophosphatase/phosphodiesterase [Gemmatimonadales bacterium] | diamond | 588 | 78.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29518481 | 29518481 | PRJNA884104_S_NODE_80690_length_244_cov_0.900585_g79947_i0 | PRJNA884104 | 80690 | 244 | 0.900585 | 2.1974274 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 54.7 | 2.16e-6 | NR | MDH3205933.1 | 2026742 | g79947 | i0 | 58.3 | 1.24180327868852 | 48 | 20 | 59 | 0 | 93 | 236 | 6 | 53 | MDH3205933.1 acyl-CoA dehydrogenase [Gemmatimonadota bacterium] | diamond | 303 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30094765 | 30094765 | PRJNA884104_S_NODE_40572_length_325_cov_1.305556_g39829_i0 | PRJNA884104 | 40572 | 325 | 1.305556 | 4.243057 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 3.04e-22 | NR | RMH16708.1 | 2026742 | g39829 | i0 | 50 | 3.17538461538462 | 86 | 43 | 79.4 | 0 | 322 | 65 | 75 | 160 | RMH16708.1 MAG: class A beta-lactamase-related serine hydrolase [Gemmatimonadota bacterium] | diamond | 1032 | 101 | 0.99009900990099 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30537263 | 30537263 | PRJNA884104_S_NODE_33273_length_355_cov_1.904255_g32530_i0 | PRJNA884104 | 33273 | 355 | 1.904255 | 6.76010525 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.8 | 1.97e-4 | NR | MBB30379.1 | 2026742 | g32530 | i0 | 33.3 | 2.39154929577465 | 96 | 53 | 79.4 | 4 | 27 | 308 | 1406 | 1492 | MBB30379.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 849 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30813640 | 30813640 | PRJNA884104_S_NODE_16074_length_501_cov_2.869159_g15336_i0 | PRJNA884104 | 16074 | 501 | 2.869159 | 14.37448659 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 198 | 9.54e-62 | NR | MDH3455568.1 | 2026742 | g15336 | i0 | 59.1 | 0.952095808383233 | 159 | 65 | 95.2 | 0 | 7 | 483 | 13 | 171 | MDH3455568.1 hypoxanthine phosphoribosyltransferase [Gemmatimonadota bacterium] | diamond | 477 | 198 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30916596 | 30916596 | PRJNA884104_S_NODE_55814_length_280_cov_1.115942_g55071_i0 | PRJNA884104 | 55814 | 280 | 1.115942 | 3.1246376 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.1 | 6.98e-4 | NR | HJX86367.1 | 2448054 | g55071 | i0 | 35.8 | 2.59285714285714 | 81 | 46 | 82.5 | 4 | 258 | 28 | 256 | 334 | HJX86367.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 726 | 48.5 | 0.991752577319588 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31011156 | 31011156 | PRJNA884104_S_NODE_72194_length_249_cov_0.875000_g71451_i0 | PRJNA884104 | 72194 | 249 | 0.875 | 2.17875 | FCB group | 1783270 | Bacteria | Bacteria | 108 | 1.9e-25 | NR | MCC6771645.1 | 2026741 | g71451 | i0 | 66.7 | 15.9759036144578 | 78 | 26 | 94 | 0 | 248 | 15 | 66 | 143 | MCC6771645.1 B12-binding domain-containing radical SAM protein [Gemmatimonadaceae bacterium] | diamond | 3978 | 109 | 0.990825688073395 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31129290 | 31129290 | PRJNA884104_S_NODE_20995_length_441_cov_0.847826_g20252_i0 | PRJNA884104 | 20995 | 441 | 0.847826 | 3.73891266 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 90.9 | 3.99e-18 | NR | MBT5328897.1 | 2026742 | g20252 | i0 | 42.2 | 4.51020408163265 | 135 | 70 | 86.4 | 4 | 384 | 4 | 42 | 176 | MBT5328897.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 1989 | 90.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31192478 | 31192478 | PRJNA884104_S_NODE_48235_length_301_cov_1.135965_g47492_i0 | PRJNA884104 | 48235 | 301 | 1.135965 | 3.41925465 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 43.5 | 0.0388 | NR | HEU4699358.1 | 2448054 | g47492 | i0 | 49 | 0.508305647840532 | 51 | 25 | 49.8 | 1 | 152 | 3 | 623 | 673 | HEU4699358.1 ATP-binding protein [Gemmatimonadales bacterium] | diamond | 153 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31422166 | 31422166 | PRJNA884104_S_NODE_82416_length_243_cov_0.905882_g81673_i0 | PRJNA884104 | 82416 | 243 | 0.905882 | 2.20129326 | FCB group | 1783270 | Bacteria | Bacteria | 109 | 1.61e-28 | NR | HWA55626.1 | 2448054 | g81673 | i0 | 62.8 | 16.8888888888889 | 78 | 29 | 96.3 | 0 | 234 | 1 | 32 | 109 | HWA55626.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 4104 | 110 | 0.990909090909091 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31453925 | 31453925 | PRJNA884104_S_NODE_65276_length_258_cov_0.870270_g64533_i0 | PRJNA884104 | 65276 | 258 | 0.87027 | 2.2452966 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.3 | 1.15e-15 | NR | HEX2451855.1 | 2448054 | g64533 | i0 | 52.1 | 3.36046511627907 | 73 | 34 | 84.9 | 1 | 2 | 220 | 240 | 311 | HEX2451855.1 M20 family peptidase [Gemmatimonadales bacterium] | diamond | 867 | 81.6 | 0.996323529411765 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32110193 | 32110193 | PRJNA884104_S_NODE_27318_length_389_cov_1.218354_g26575_i0 | PRJNA884104 | 27318 | 389 | 1.218354 | 4.73939706 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 171 | 3.54e-48 | NR | HEV2148171.1 | 3047548 | g26575 | i0 | 66.1 | 9.76349614395887 | 127 | 43 | 97.9 | 0 | 383 | 3 | 59 | 185 | HEV2148171.1 M28 family metallopeptidase [Longimicrobiaceae bacterium] | diamond | 3798 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 32268578 | 32268578 | PRJNA884104_S_NODE_57438_length_276_cov_1.137931_g56695_i0 | PRJNA884104 | 57438 | 276 | 1.137931 | 3.14068956 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 75.1 | 2.28e-13 | NR | MCH7475869.1 | 2026742 | g56695 | i0 | 46 | 4.72826086956522 | 87 | 46 | 94.6 | 1 | 2 | 262 | 482 | 567 | MCH7475869.1 acyl-CoA dehydrogenase family protein [Gemmatimonadota bacterium] | diamond | 1305 | 75.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32458386 | 32458386 | PRJNA884104_S_NODE_44119_length_313_cov_1.508333_g43376_i0 | PRJNA884104 | 44119 | 313 | 1.508333 | 4.72108229 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 110 | 4.47e-26 | NR | MCY3773322.1 | 2026742 | g43376 | i0 | 46.4 | 5.36741214057508 | 112 | 52 | 99.7 | 2 | 312 | 1 | 214 | 325 | MCY3773322.1 dipeptidase [Gemmatimonadota bacterium] | diamond | 1680 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32647320 | 32647320 | PRJNA884104_S_NODE_18680_length_466_cov_2.183206_g17937_i0 | PRJNA884104 | 18680 | 466 | 2.183206 | 10.17373996 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 156 | 2.76e-41 | NR | NNE08319.1 | 2026742 | g17937 | i0 | 51.9 | 0.869098712446352 | 135 | 58 | 86.9 | 2 | 464 | 60 | 199 | 326 | NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] | diamond | 405 | 156 | 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);;