contig_metadata
18 rows where bioproject = "PRJNA1248424" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 352890 | 352890 | PRJNA1248424_P_NODE_62841_length_268_cov_1.184615_g56772_i0 | PRJNA1248424 | 62841 | 268 | 1.184615 | 3.1747682 | uncultured Planctomycetaceae bacterium | 100233 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2874254106|emb|OY970189.1| | 100233 | g56772 | i0 | 100 | 0.104477611940299 | 28 | 0 | 10 | 0 | 189 | 216 | 1418115 | 1418088 | MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | uncultured Planctomycetaceae bacterium | ||
| 9281393 | 9281393 | PRJNA1248424_P_NODE_69068_length_251_cov_0.865169_g62999_i0 | PRJNA1248424 | 69068 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 147 | 2.7399999999999993e-40 | NR | MEI8371296.1 | 2026780 | g62999 | i0 | 86.7 | 16.8645418326693 | 83 | 11 | 99.2 | 0 | 2 | 250 | 199 | 281 | MEI8371296.1 BREX system ATP-binding protein BrxD [Planctomycetota bacterium] | diamond | 4233 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 10556911 | 10556911 | PRJNA1248424_P_NODE_49109_length_314_cov_3.385892_g43041_i0 | PRJNA1248424 | 49109 | 314 | 3.385892 | 10.63170088 | uncultured Phycisphaerae bacterium | 904963 | Bacteria | Bacteria | 85.1 | 8.57e-17 | NR | CAA9415099.1 | 904963 | g43041 | i0 | 82.6 | 0.439490445859873 | 46 | 8 | 43.9 | 0 | 139 | 2 | 303 | 348 | CAA9415099.1 MAG: hypothetical protein AVDCRST_MAG64-2550, partial [uncultured Phycisphaerae bacterium] | diamond | 138 | 85.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | uncultured Phycisphaerae bacterium | ||||
| 16354323 | 16354323 | PRJNA1248424_P_NODE_51933_length_299_cov_2.530973_g45865_i0 | PRJNA1248424 | 51933 | 299 | 2.530973 | 7.56760927 | Gemmataceae | 1914233 | Bacteria | Bacteria | 206 | 2.02e-48 | NTclustered | gi|1712585314|gb|CP036273.1| | 2528023 | g45865 | i0 | 91.391 | 49.2608695652174 | 151 | 11 | 50 | 2 | 150 | 299 | 2755806 | 2755657 | Urbifossiella limnaea strain ETA_A1 chromosome, complete genome | blastn | 14729 | 206 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella limnaea | |
| 27010218 | 27010218 | PRJNA1248424_P_NODE_49182_length_314_cov_1.448133_g43114_i0 | PRJNA1248424 | 49182 | 314 | 1.448133 | 4.54713762 | Candidatus Scalindua sp. | 2268189 | Bacteria | Bacteria | 47.4 | 0.00178 | NR | MCP4254340.1 | 2268189 | g43114 | i0 | 45.1 | 0.487261146496815 | 51 | 28 | 48.7 | 0 | 160 | 312 | 81 | 131 | MCP4254340.1 hypothetical protein [Candidatus Scalindua sp.] | diamond | 153 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Scalinduaceae | Candidatus Scalindua | Candidatus Scalindua sp. | |
| 27042032 | 27042032 | PRJNA1248424_P_NODE_80062_length_241_cov_0.916667_g73993_i0 | PRJNA1248424 | 80062 | 241 | 0.916667 | 2.20916747 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 58.2 | 1.3e-7 | NR | HEY7330165.1 | 2052164 | g73993 | i0 | 59.7 | 0.771784232365145 | 62 | 23 | 74.7 | 2 | 48 | 227 | 213 | 274 | HEY7330165.1 S53 family peptidase [Gemmataceae bacterium] | diamond | 186 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 27199803 | 27199803 | PRJNA1248424_P_NODE_62522_length_269_cov_1.020408_g56453_i0 | PRJNA1248424 | 62522 | 269 | 1.020408 | 2.74489752 | Blastopirellula marina | 124 | Bacteria | Bacteria | 43.1 | 0.0299 | NR | WP_146118743.1 | 124 | g56453 | i0 | 34 | 0.524163568773234 | 47 | 31 | 52.4 | 0 | 59 | 199 | 80 | 126 | WP_146118743.1 hypothetical protein [Blastopirellula marina] | diamond | 141 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Blastopirellula | Blastopirellula marina | |
| 27326533 | 27326533 | PRJNA1248424_P_NODE_75703_length_245_cov_0.895349_g69634_i0 | PRJNA1248424 | 75703 | 245 | 0.895349 | 2.19360505 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 65.5 | 8.98e-11 | NR | RMG14392.1 | 2026780 | g69634 | i0 | 47.5 | 3.93061224489796 | 80 | 41 | 98 | 1 | 242 | 3 | 90 | 168 | RMG14392.1 MAG: ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Planctomycetota bacterium] | diamond | 963 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28968477 | 28968477 | PRJNA1248424_P_NODE_76908_length_244_cov_0.900585_g70839_i0 | PRJNA1248424 | 76908 | 244 | 0.900585 | 2.1974274 | Thermoguttaceae bacterium | 2691551 | Bacteria | Bacteria | 160 | 1.19e-45 | NR | MBS7338267.1 | 2691551 | g70839 | i0 | 93.8 | 0.983606557377049 | 80 | 5 | 98.4 | 0 | 3 | 242 | 185 | 264 | MBS7338267.1 glycosyltransferase family 4 protein [Thermoguttaceae bacterium] | diamond | 240 | 160 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermoguttaceae bacterium | ||
| 29049729 | 29049729 | PRJNA1248424_P_NODE_53488_length_292_cov_3.762557_g47420_i0 | PRJNA1248424 | 53488 | 292 | 3.762557 | 10.98666644 | Humisphaera | 2807511 | Bacteria | Bacteria | 65.1 | 2.84e-11 | NR | HEX8914895.1 | 2807514 | g47420 | i0 | 68.9 | 2.42465753424658 | 45 | 14 | 46.2 | 0 | 135 | 1 | 3 | 47 | HEX8914895.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Humisphaera sp.] | diamond | 708 | 65.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Humisphaera | Humisphaera sp. | |
| 29347372 | 29347372 | PRJNA1248424_P_NODE_63869_length_265_cov_1.276042_g57800_i0 | PRJNA1248424 | 63869 | 265 | 1.276042 | 3.3815113 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 41.2 | 0.0213 | NR | MCG8405468.1 | 2052180 | g57800 | i0 | 34.6 | 0.588679245283019 | 52 | 34 | 58.9 | 0 | 62 | 217 | 8 | 59 | MCG8405468.1 hypothetical protein [Phycisphaerales bacterium] | diamond | 156 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29820675 | 29820675 | PRJNA1248424_P_NODE_51831_length_299_cov_6.606195_g45763_i0 | PRJNA1248424 | 51831 | 299 | 6.606195 | 19.75252305 | Tepidisphaeraceae bacterium | 2876886 | Bacteria | Bacteria | 80.5 | 3.99e-15 | NR | HZN67648.1 | 2876886 | g45763 | i0 | 67.9 | 0.561872909698997 | 56 | 18 | 56.2 | 0 | 299 | 132 | 364 | 419 | HZN67648.1 lamin tail domain-containing protein [Tepidisphaeraceae bacterium] | diamond | 168 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Tepidisphaerales | Tepidisphaeraceae | Tepidisphaeraceae bacterium | ||
| 31053354 | 31053354 | PRJNA1248424_P_NODE_50255_length_308_cov_1.297872_g44187_i0 | PRJNA1248424 | 50255 | 308 | 1.297872 | 3.99744576 | Candidatus Uabimicrobium amorphum | 2596890 | Bacteria | Bacteria | 62 | 4.31e-9 | NR | WP_151970811.1 | 2596890 | g44187 | i0 | 42.6 | 2.12337662337662 | 68 | 38 | 66.2 | 1 | 304 | 101 | 128 | 194 | WP_151970811.1 ATP-dependent Clp protease proteolytic subunit [Candidatus Uabimicrobium amorphum] | diamond | 654 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Uabimicrobiia | Candidatus Uabimicrobiales | Candidatus Uabimicrobiaceae | Candidatus Uabimicrobium | Candidatus Uabimicrobium amorphum | |
| 31071278 | 31071278 | PRJNA1248424_P_NODE_63155_length_267_cov_1.237113_g57086_i0 | PRJNA1248424 | 63155 | 267 | 1.237113 | 3.30309171 | Bacteria | 2 | Bacteria | Bacteria | 43.1 | 0.0363 | NR | MBC7818314.1 | 2026779 | g57086 | i0 | 33.3 | 2.42696629213483 | 72 | 42 | 74.2 | 2 | 70 | 267 | 155 | 226 | MBC7818314.1 DUF1501 domain-containing protein [Planctomycetaceae bacterium] | diamond | 648 | 43.5 | 0.990804597701149 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 31703558 | 31703558 | PRJNA1248424_P_NODE_74777_length_246_cov_0.890173_g68708_i0 | PRJNA1248424 | 74777 | 246 | 0.890173 | 2.18982558 | Planctomycetia | 203683 | Bacteria | Bacteria | 95.5 | 2.16e-21 | NR | WP_213495257.1 | 1123043 | g68708 | i0 | 73.8 | 3.19512195121951 | 65 | 17 | 79.3 | 0 | 195 | 1 | 234 | 298 | WP_213495257.1 aminotransferase class IV [Telmatocola sphagniphila] | diamond | 786 | 95.9 | 0.995828988529718 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Telmatocola | Telmatocola sphagniphila | |
| 31843505 | 31843505 | PRJNA1248424_P_NODE_71977_length_248_cov_1.994286_g65908_i0 | PRJNA1248424 | 71977 | 248 | 1.994286 | 4.94582928 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 147 | 6.949999999999998e-42 | NR | MCA1685320.1 | 2052181 | g65908 | i0 | 82.9 | 0.991935483870968 | 82 | 14 | 99.2 | 0 | 2 | 247 | 92 | 173 | MCA1685320.1 prolyl oligopeptidase family serine peptidase [Planctomycetia bacterium] | diamond | 246 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 32160223 | 32160223 | PRJNA1248424_P_NODE_66738_length_257_cov_1.434783_g60669_i0 | PRJNA1248424 | 66738 | 257 | 1.434783 | 3.68739231 | Thermoguttaceae bacterium | 2691551 | Bacteria | Bacteria | 55.8 | 4.4e-7 | NR | MBR0236662.1 | 2691551 | g60669 | i0 | 42 | 3.78210116731517 | 81 | 46 | 94.6 | 1 | 255 | 13 | 104 | 183 | MBR0236662.1 ATP-dependent Clp protease proteolytic subunit [Thermoguttaceae bacterium] | diamond | 972 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Thermoguttaceae | Thermoguttaceae bacterium | ||
| 32255330 | 32255330 | PRJNA1248424_P_NODE_66378_length_258_cov_1.432432_g60309_i0 | PRJNA1248424 | 66378 | 258 | 1.432432 | 3.69567456 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 134 | 2.86e-35 | NR | HJT75664.1 | 2052164 | g60309 | i0 | 76.5 | 1.97674418604651 | 85 | 20 | 98.8 | 0 | 257 | 3 | 34 | 118 | HJT75664.1 hypothetical protein [Gemmataceae bacterium] | diamond | 510 | 134 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae 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);;