contig_metadata
17 rows where bioproject = "PRJNA724011", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17288983 | 17288983 | PRJNA724011_P_NODE_92294_length_253_cov_1.700000_g91271_i0 | PRJNA724011 | 92294 | 253 | 1.7 | 4.301 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g91271 | i0 | 100 | 0.221343873517787 | 28 | 0 | 11 | 0 | 55 | 82 | 4339352 | 4339325 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26745625 | 26745625 | PRJNA724011_P_NODE_103261_length_245_cov_0.895349_g102238_i0 | PRJNA724011 | 103261 | 245 | 0.895349 | 2.19360505 | Myxococcota | 2818505 | Bacteria | Bacteria | 111 | 2.36e-27 | NR | WP_141200447.1 | 2292766 | g102238 | i0 | 67.9 | 3.93061224489796 | 81 | 24 | 99.2 | 1 | 3 | 245 | 25 | 103 | WP_141200447.1 fumarylacetoacetate hydrolase family protein [Persicimonas caeni] | diamond | 963 | 111 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 26767333 | 26767333 | PRJNA724011_P_NODE_74901_length_288_cov_3.083721_g73878_i0 | PRJNA724011 | 74901 | 288 | 3.083721 | 8.88111648 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 48.1 | 7.64e-4 | NR | OGQ48417.1 | 1797880 | g73878 | i0 | 36.1 | 0.75 | 72 | 46 | 75 | 0 | 67 | 282 | 139 | 210 | OGQ48417.1 MAG: hypothetical protein A3I09_04960 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_47_10] | diamond | 216 | 48.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_47_10 | ||||||
| 27020559 | 27020559 | PRJNA724011_P_NODE_75962_length_286_cov_1.652582_g74939_i0 | PRJNA724011 | 75962 | 286 | 1.652582 | 4.72638452 | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026735 | Bacteria | Bacteria | 86.7 | 5.1e-19 | NR | PIR19918.1 | 1973975 | g74939 | i0 | 63.1 | 2.74825174825175 | 65 | 23 | 68.2 | 1 | 15 | 209 | 102 | 165 | PIR19918.1 MAG: hypothetical protein COV45_08025 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16] | diamond | 786 | 86.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16 | ||||||
| 27020591 | 27020591 | PRJNA724011_P_NODE_94342_length_251_cov_0.865169_g93319_i0 | PRJNA724011 | 94342 | 251 | 0.865169 | 2.17157419 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 86.3 | 2.85e-18 | NR | WP_141199462.1 | 2292766 | g93319 | i0 | 50.6 | 1.93625498007968 | 81 | 40 | 96.8 | 0 | 251 | 9 | 15 | 95 | WP_141199462.1 lysophospholipid acyltransferase family protein [Persicimonas caeni] | diamond | 486 | 86.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 28252265 | 28252265 | PRJNA724011_P_NODE_82026_length_273_cov_1.530000_g81003_i0 | PRJNA724011 | 82026 | 273 | 1.53 | 4.1769 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 53.1 | 1.17e-5 | NR | MBF0277046.1 | 2024889 | g81003 | i0 | 37.1 | 1.52747252747253 | 70 | 42 | 75.8 | 2 | 254 | 48 | 392 | 460 | MBF0277046.1 pentapeptide repeat-containing protein [SAR324 cluster bacterium] | diamond | 417 | 53.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28283638 | 28283638 | PRJNA724011_P_NODE_47666_length_377_cov_1.766447_g46643_i0 | PRJNA724011 | 47666 | 377 | 1.766447 | 6.65950519 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 105 | 4.68e-24 | NR | MBN1947766.1 | 2099667 | g46643 | i0 | 45.6 | 0.907161803713528 | 114 | 62 | 90.7 | 0 | 351 | 10 | 80 | 193 | MBN1947766.1 CDP-alcohol phosphatidyltransferase family protein [Bradymonadales bacterium] | diamond | 342 | 105 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 28599800 | 28599800 | PRJNA724011_P_NODE_49107_length_371_cov_0.899329_g48084_i0 | PRJNA724011 | 49107 | 371 | 0.899329 | 3.33651059 | Deltaproteobacteria bacterium GWA2_38_16 | 1797802 | Bacteria | Bacteria | 53.5 | 2.64e-5 | NR | OGP06100.1 | 1797802 | g48084 | i0 | 33 | 0.83288409703504 | 103 | 65 | 80.1 | 2 | 367 | 71 | 494 | 596 | OGP06100.1 MAG: hypothetical protein A2Z91_05935 [Deltaproteobacteria bacterium GWA2_38_16] | diamond | 309 | 53.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWA2_38_16 | ||||||
| 28662947 | 28662947 | PRJNA724011_P_NODE_887_length_2675_cov_21.204458_g740_i0 | PRJNA724011 | 887 | 2675 | 21.204458 | 567.2192515 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 55.8 | 9.27e-5 | NR | WP_146958514.1 | 2600177 | g740 | i0 | 25.7 | 0.36785046728972 | 187 | 123 | 20.6 | 5 | 2641 | 2090 | 3 | 176 | WP_146958514.1 lipocalin family protein [Microvenator marinus] | diamond | 984 | 55.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 29451809 | 29451809 | PRJNA724011_P_NODE_59170_length_332_cov_1.189189_g58147_i0 | PRJNA724011 | 59170 | 332 | 1.189189 | 3.94810748 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 104 | 1.8899999999999994e-23 | NR | MBN1944337.1 | 2099667 | g58147 | i0 | 50 | 1.01204819277108 | 112 | 54 | 99.4 | 1 | 332 | 3 | 106 | 217 | MBN1944337.1 NAD-dependent dihydropyrimidine dehydrogenase subunit PreA [Bradymonadales bacterium] | diamond | 336 | 104 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 29641291 | 29641291 | PRJNA724011_P_NODE_94070_length_251_cov_0.865169_g93047_i0 | PRJNA724011 | 94070 | 251 | 0.865169 | 2.17157419 | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026735 | Bacteria | Bacteria | 97.8 | 1.73e-21 | NR | PIR21022.1 | 1973975 | g93047 | i0 | 57.3 | 8.8804780876494 | 82 | 35 | 98 | 0 | 4 | 249 | 569 | 650 | PIR21022.1 MAG: elongation factor G [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16] | diamond | 2229 | 97.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16 | ||||||
| 30494544 | 30494544 | PRJNA724011_P_NODE_13553_length_836_cov_1.212320_g12631_i0 | PRJNA724011 | 13553 | 836 | 1.21232 | 10.1349952 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 362 | 9.4e-116 | NR | MBN1944337.1 | 2099667 | g12631 | i0 | 63.7 | 0.997607655502392 | 278 | 101 | 99.8 | 0 | 2 | 835 | 525 | 802 | MBN1944337.1 NAD-dependent dihydropyrimidine dehydrogenase subunit PreA [Bradymonadales bacterium] | diamond | 834 | 362 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 32233768 | 32233768 | PRJNA724011_P_NODE_44478_length_393_cov_3.859375_g43455_i0 | PRJNA724011 | 44478 | 393 | 3.859375 | 15.16734375 | delta proteobacterium ML8_F1 | 1775671 | Bacteria | Bacteria | 82.8 | 1.81e-16 | NR | OPL09393.1 | 1775671 | g43455 | i0 | 47.2 | 0.824427480916031 | 108 | 32 | 82.4 | 1 | 347 | 24 | 57 | 139 | OPL09393.1 MAG: 2-deoxyribose-5-phosphate aldolase [delta proteobacterium ML8_F1] | diamond | 324 | 82.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | delta proteobacterium ML8_F1 | ||||||
| 32423368 | 32423368 | PRJNA724011_P_NODE_5099_length_1388_cov_3.598479_g4570_i0 | PRJNA724011 | 5099 | 1388 | 3.598479 | 49.94688852 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 151 | 6.32e-37 | NR | PKN55183.1 | 2013741 | g4570 | i0 | 37.3 | 0.585734870317003 | 271 | 134 | 52.5 | 7 | 1035 | 307 | 170 | 432 | PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 813 | 151 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 32623220 | 32623220 | PRJNA724011_P_NODE_56160_length_342_cov_1.713755_g55137_i0 | PRJNA724011 | 56160 | 342 | 1.713755 | 5.8610421 | Bacteria | 2 | Bacteria | Bacteria | 50.4 | 3.24e-5 | NR | PKN77812.1 | 2013736 | g55137 | i0 | 34 | 1.79824561403509 | 94 | 45 | 79.8 | 3 | 20 | 292 | 18 | 97 | PKN77812.1 MAG: thioredoxin [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1] | diamond | 615 | 50.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1 | ||||||
| 32780586 | 32780586 | PRJNA724011_P_NODE_88140_length_261_cov_1.446809_g87117_i0 | PRJNA724011 | 88140 | 261 | 1.446809 | 3.77617149 | Bacteria | 2 | Bacteria | Bacteria | 95.5 | 1.19e-20 | NR | OGP70449.1 | 1797833 | g87117 | i0 | 50.6 | 7.54022988505747 | 79 | 39 | 90.8 | 0 | 261 | 25 | 437 | 515 | OGP70449.1 MAG: NAD-dependent malic enzyme [Deltaproteobacteria bacterium RBG_13_60_28] | diamond | 1968 | 95.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_60_28 | ||||||
| 32906551 | 32906551 | PRJNA724011_P_NODE_105100_length_244_cov_0.900585_g104077_i0 | PRJNA724011 | 105100 | 244 | 0.900585 | 2.1974274 | Myxococcota | 2818505 | Bacteria | Bacteria | 100 | 1.83e-22 | NR | OGP57184.1 | 1797827 | g104077 | i0 | 62.5 | 6.77459016393443 | 80 | 29 | 98.4 | 1 | 4 | 243 | 194 | 272 | OGP57184.1 MAG: hypothetical protein A2V65_03520 [Deltaproteobacteria bacterium RBG_13_49_15] | diamond | 1653 | 100 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_49_15 |
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);;