contig_metadata
24 rows where bioproject = "PRJNA1143173", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2837060 | 2837060 | PRJNA1143173_P_NODE_29063_length_260_cov_5.941176_g29037_i0 | PRJNA1143173 | 29063 | 260 | 5.941176 | 15.4470576 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 265 | 2.8e-66 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g29037 | i0 | 85.171 | 2.14615384615385 | 263 | 34 | 100 | 5 | 1 | 260 | 1785640 | 1785380 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 558 | 265 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 7939104 | 7939104 | PRJNA1143173_P_NODE_17847_length_293_cov_4.690909_g17821_i0 | PRJNA1143173 | 17847 | 293 | 4.690909 | 13.74436337 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 7.819999999999998e-24 | NR | HEX2638185.1 | 2448054 | g17821 | i0 | 83.9 | 2.53924914675768 | 62 | 9 | 62.5 | 1 | 110 | 292 | 1 | 62 | HEX2638185.1 LLM class flavin-dependent oxidoreductase [Gemmatimonadales bacterium] | diamond | 744 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 7939320 | 7939320 | PRJNA1143173_P_NODE_26987_length_266_cov_6.284974_g26961_i0 | PRJNA1143173 | 26987 | 266 | 6.284974 | 16.71803084 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 151 | 1.44e-40 | NR | HEX7978289.1 | 2026741 | g26961 | i0 | 85.2 | 1.98496240601504 | 88 | 13 | 99.2 | 0 | 3 | 266 | 23 | 110 | HEX7978289.1 Clp protease N-terminal domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 528 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 13039675 | 13039675 | PRJNA1143173_P_NODE_13291_length_299_cov_7.623894_g13265_i0 | PRJNA1143173 | 13291 | 299 | 7.623894 | 22.79544306 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 106 | 2.1e-18 | NTclustered | gi|575462059|gb|CP007130.1| | 861299 | g13265 | i0 | 85.577 | 2.00334448160535 | 104 | 11 | 34 | 4 | 192 | 293 | 66618 | 66517 | Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence | blastn | 599 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 15589206 | 15589206 | PRJNA1143173_P_NODE_28513_length_262_cov_2.756614_g28487_i0 | PRJNA1143173 | 28513 | 262 | 2.756614 | 7.22232868 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 484 | 1.99e-132 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g28487 | i0 | 100 | 2 | 262 | 0 | 100 | 0 | 1 | 262 | 2511352 | 2511613 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 524 | 484 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 16863033 | 16863033 | PRJNA1143173_P_NODE_12994_length_299_cov_10.681416_g12968_i0 | PRJNA1143173 | 12994 | 299 | 10.681416 | 31.93743384 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 103 | 1.06e-23 | NR | WP_331123564.1 | 2029185 | g12968 | i0 | 98 | 0.501672240802676 | 50 | 1 | 50.2 | 0 | 151 | 2 | 37 | 86 | WP_331123564.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Longimicrobium sp.] | diamond | 150 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 16863368 | 16863368 | PRJNA1143173_P_NODE_27834_length_264_cov_2.753927_g27808_i0 | PRJNA1143173 | 27834 | 264 | 2.753927 | 7.27036728 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 278 | 3.65e-70 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g27808 | i0 | 86.747 | 81.3674242424242 | 249 | 33 | 94 | 0 | 1 | 249 | 1306947 | 1306699 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 21481 | 278 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 23238398 | 23238398 | PRJNA1143173_P_NODE_16879_length_296_cov_2.524664_g16853_i0 | PRJNA1143173 | 16879 | 296 | 2.524664 | 7.47300544 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 158 | 5.66e-34 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g16853 | i0 | 76.825 | 3.19256756756757 | 315 | 51 | 99 | 17 | 2 | 296 | 72321 | 72633 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 945 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 27038766 | 27038766 | PRJNA1143173_P_NODE_33062_length_249_cov_3.017045_g33036_i0 | PRJNA1143173 | 33062 | 249 | 3.017045 | 7.51244205 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 50.4 | 7.26e-5 | NR | HKG91865.1 | 2026741 | g33036 | i0 | 49.1 | 0.686746987951807 | 57 | 22 | 68.7 | 1 | 77 | 247 | 153 | 202 | HKG91865.1 histidine kinase [Gemmatimonadaceae bacterium] | diamond | 171 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27375860 | 27375860 | PRJNA1143173_P_NODE_43243_length_207_cov_4.634328_g43217_i0 | PRJNA1143173 | 43243 | 207 | 4.634328 | 9.59305896 | FCB group | 1783270 | Bacteria | Bacteria | 58.2 | 8.49e-8 | NR | MEX2282481.1 | 2026742 | g43217 | i0 | 45.6 | 2.97101449275362 | 68 | 37 | 98.6 | 0 | 205 | 2 | 1711 | 1778 | MEX2282481.1 fibronectin type III domain-containing protein [Gemmatimonadota bacterium] | diamond | 615 | 58.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27481207 | 27481207 | PRJNA1143173_P_NODE_19423_length_289_cov_1.013889_g19397_i0 | PRJNA1143173 | 19423 | 289 | 1.013889 | 2.93013921 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 85.9 | 4.58e-17 | NR | HSJ32505.1 | 2910168 | g19397 | i0 | 42.1 | 0.986159169550173 | 95 | 46 | 98.6 | 1 | 2 | 286 | 751 | 836 | HSJ32505.1 BTAD domain-containing putative transcriptional regulator [Longimicrobiales bacterium] | diamond | 285 | 85.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 27544405 | 27544405 | PRJNA1143173_P_NODE_30064_length_257_cov_7.945652_g30038_i0 | PRJNA1143173 | 30064 | 257 | 7.945652 | 20.42032564 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 77.4 | 2.79e-14 | NR | HEX9165666.1 | 2448054 | g30038 | i0 | 58.1 | 0.863813229571984 | 74 | 31 | 86.4 | 0 | 12 | 233 | 544 | 617 | HEX9165666.1 TonB-dependent receptor [Gemmatimonadales bacterium] | diamond | 222 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28112570 | 28112570 | PRJNA1143173_P_NODE_12145_length_309_cov_7.639831_g12119_i0 | PRJNA1143173 | 12145 | 309 | 7.639831 | 23.60707779 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 53.1 | 1.54e-5 | NR | HVZ47848.1 | 2026741 | g12119 | i0 | 51.1 | 0.456310679611651 | 47 | 21 | 45.6 | 1 | 168 | 308 | 75 | 119 | HVZ47848.1 amidohydrolase family protein [Gemmatimonadaceae bacterium] | diamond | 141 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28175681 | 28175681 | PRJNA1143173_P_NODE_36566_length_238_cov_8.442424_g36540_i0 | PRJNA1143173 | 36566 | 238 | 8.442424 | 20.09296912 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 57.8 | 1.09e-8 | NR | MBE85155.1 | 2026742 | g36540 | i0 | 41.5 | 3 | 82 | 40 | 97.1 | 2 | 3 | 233 | 13 | 91 | MBE85155.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 714 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28207232 | 28207232 | PRJNA1143173_P_NODE_13166_length_299_cov_8.601770_g13140_i0 | PRJNA1143173 | 13166 | 299 | 8.60177 | 25.7192923 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 56.6 | 8.5e-7 | NR | HUO52139.1 | 2026741 | g13140 | i0 | 30.5 | 1.51505016722408 | 151 | 49 | 96.3 | 3 | 289 | 2 | 43 | 192 | HUO52139.1 metallophosphoesterase [Gemmatimonadaceae bacterium] | diamond | 453 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28428549 | 28428549 | PRJNA1143173_P_NODE_35386_length_242_cov_5.153846_g35360_i0 | PRJNA1143173 | 35386 | 242 | 5.153846 | 12.47230732 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 153 | 1.79e-45 | NR | HAC08013.1 | 2026742 | g35360 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 1 | 240 | 74 | 153 | HAC08013.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 240 | 153 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28744184 | 28744184 | PRJNA1143173_P_NODE_12447_length_308_cov_2.587234_g12421_i0 | PRJNA1143173 | 12447 | 308 | 2.587234 | 7.96868072 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 70.9 | 7.16e-12 | NR | MBY0491284.1 | 2026741 | g12421 | i0 | 72 | 1.94805194805195 | 50 | 14 | 48.7 | 0 | 150 | 1 | 28 | 77 | MBY0491284.1 sodium-dependent bicarbonate transport family permease [Gemmatimonadaceae bacterium] | diamond | 600 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28870395 | 28870395 | PRJNA1143173_P_NODE_27228_length_265_cov_11.223958_g27202_i0 | PRJNA1143173 | 27228 | 265 | 11.223958 | 29.7434887 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 65.5 | 1.56e-10 | NR | MBK8006411.1 | 2026742 | g27202 | i0 | 35.6 | 0.984905660377358 | 87 | 56 | 98.5 | 0 | 262 | 2 | 6 | 92 | MBK8006411.1 SdpI family protein [Gemmatimonadota bacterium] | diamond | 261 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29881057 | 29881057 | PRJNA1143173_P_NODE_27431_length_265_cov_4.114583_g27405_i0 | PRJNA1143173 | 27431 | 265 | 4.114583 | 10.90364495 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 67.8 | 7e-11 | NR | HEX9895641.1 | 2448054 | g27405 | i0 | 37.5 | 2.89811320754717 | 88 | 53 | 97.4 | 2 | 263 | 6 | 204 | 291 | HEX9895641.1 serine hydrolase domain-containing protein [Gemmatimonadales bacterium] | diamond | 768 | 67.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30070313 | 30070313 | PRJNA1143173_P_NODE_19232_length_289_cov_4.180556_g19206_i0 | PRJNA1143173 | 19232 | 289 | 4.180556 | 12.08180684 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 42.4 | 0.0203 | NR | HEU4700701.1 | 2448054 | g19206 | i0 | 44.8 | 0.602076124567474 | 58 | 30 | 58.1 | 2 | 284 | 117 | 10 | 67 | HEU4700701.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 174 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30292003 | 30292003 | PRJNA1143173_P_NODE_31952_length_252_cov_3.932961_g31926_i0 | PRJNA1143173 | 31952 | 252 | 3.932961 | 9.91106172 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 145 | 3.12e-40 | NR | WP_331021089.1 | 2029185 | g31926 | i0 | 73.8 | 2.97619047619048 | 84 | 22 | 100 | 0 | 1 | 252 | 90 | 173 | WP_331021089.1 amidohydrolase family protein [Longimicrobium sp.] | diamond | 750 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31650483 | 31650483 | PRJNA1143173_P_NODE_44617_length_197_cov_10.120968_g44591_i0 | PRJNA1143173 | 44617 | 197 | 10.120968 | 19.93830696 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 126 | 1.99e-33 | NR | HTG49533.1 | 2448054 | g44591 | i0 | 100 | 11.8781725888325 | 65 | 0 | 99 | 0 | 2 | 196 | 118 | 182 | HTG49533.1 deoxyhypusine synthase [Gemmatimonadales bacterium] | diamond | 2340 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31903653 | 31903653 | PRJNA1143173_P_NODE_39657_length_227_cov_5.558442_g39631_i0 | PRJNA1143173 | 39657 | 227 | 5.558442 | 12.61766334 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 93.6 | 2.8200000000000003e-22 | NR | HEY0154086.1 | 2029185 | g39631 | i0 | 64.2 | 1.87665198237885 | 67 | 24 | 88.5 | 0 | 4 | 204 | 35 | 101 | HEY0154086.1 NUDIX domain-containing protein [Longimicrobium sp.] | diamond | 426 | 93.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31998650 | 31998650 | PRJNA1143173_P_NODE_29018_length_260_cov_7.411765_g28992_i0 | PRJNA1143173 | 29018 | 260 | 7.411765 | 19.270589 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 87.8 | 2.4e-18 | NR | MEI6739213.1 | 2026741 | g28992 | i0 | 84.3 | 0.588461538461538 | 51 | 8 | 58.8 | 0 | 3 | 155 | 281 | 331 | MEI6739213.1 sodium-dependent bicarbonate transport family permease [Gemmatimonadaceae bacterium] | diamond | 153 | 87.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;