contig_metadata
17 rows where bioproject = "PRJNA556992", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_kingdom = "Pseudomonadati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1807530 | 1807530 | PRJNA556992_P_NODE_698802_length_251_cov_1.943820_g696613_i0 | PRJNA556992 | 698802 | 251 | 1.94382 | 4.8789882 | uncultured Candidatus Entotheonella sp. | 312019 | Bacteria | Bacteria | 115 | 2.86e-21 | NTclustered | gi|2531976037|emb|OY282375.1| | 312019 | g696613 | i0 | 75.294 | 11.4143426294821 | 255 | 55 | 100 | 8 | 1 | 251 | 301766 | 301516 | MAG: uncultured Candidatus Entotheonella sp. genome assembly, chromosome: 1 | blastn | 2865 | 115 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | uncultured Candidatus Entotheonella sp. | |
| 8178377 | 8178377 | PRJNA556992_P_NODE_214727_length_319_cov_3.093496_g212539_i0 | PRJNA556992 | 214727 | 319 | 3.093496 | 9.86825224 | uncultured Candidatus Entotheonella sp. | 312019 | Bacteria | Bacteria | 329 | 1.23e-85 | NTclustered | gi|2518596677|emb|OX639990.1| | 312019 | g212539 | i0 | 85.266 | 7.86520376175549 | 319 | 47 | 100 | 0 | 1 | 319 | 2629193 | 2628875 | MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1 | blastn | 2509 | 329 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | uncultured Candidatus Entotheonella sp. | |
| 9454186 | 9454186 | PRJNA556992_P_NODE_227628_length_313_cov_1.475000_g225440_i0 | PRJNA556992 | 227628 | 313 | 1.475 | 4.61675 | uncultured Candidatus Entotheonella sp. | 312019 | Bacteria | Bacteria | 267 | 9.6e-67 | NTclustered | gi|2518596677|emb|OX639990.1| | 312019 | g225440 | i0 | 82.886 | 849.041533546326 | 298 | 49 | 95 | 2 | 14 | 310 | 2630193 | 2630489 | MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1 | blastn | 265750 | 267 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | uncultured Candidatus Entotheonella sp. | |
| 12003654 | 12003654 | PRJNA556992_P_NODE_16290_length_833_cov_4.218421_g14490_i0 | PRJNA556992 | 16290 | 833 | 4.218421 | 35.13944693 | uncultured Candidatus Entotheonella sp. | 312019 | Bacteria | Bacteria | 900 | 0 | NTclustered | gi|2518596677|emb|OX639990.1| | 312019 | g14490 | i0 | 86.364 | 226.891956782713 | 836 | 100 | 99 | 12 | 2 | 833 | 2629205 | 2630030 | MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1 | blastn | 189001 | 900 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | uncultured Candidatus Entotheonella sp. | |
| 20934678 | 20934678 | PRJNA556992_P_NODE_757637_length_248_cov_1.760000_g755448_i0 | PRJNA556992 | 757637 | 248 | 1.76 | 4.3648 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 151 | 4.85e-42 | NR | HXH82408.1 | 2528274 | g755448 | i0 | 91.4 | 0.979838709677419 | 81 | 7 | 98 | 0 | 248 | 6 | 176 | 256 | HXH82408.1 TRAP transporter large permease [Candidatus Tectimicrobiota bacterium] | diamond | 243 | 151 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 26888665 | 26888665 | PRJNA556992_P_NODE_1033001_length_227_cov_2.922078_g1030811_i0 | PRJNA556992 | 1033001 | 227 | 2.922078 | 6.63311706 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 57 | 2.98e-8 | NR | MBI3793351.1 | 2026769 | g1030811 | i0 | 65 | 2.15418502202643 | 40 | 14 | 52.9 | 0 | 223 | 104 | 78 | 117 | MBI3793351.1 50S ribosomal protein L17 [Nitrospinota bacterium] | diamond | 489 | 57 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 28057791 | 28057791 | PRJNA556992_P_NODE_871025_length_242_cov_2.195266_g868835_i0 | PRJNA556992 | 871025 | 242 | 2.195266 | 5.31254372 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 41.2 | 0.0469 | NR | MBE17820.1 | 2026769 | g868835 | i0 | 29.5 | 0.966942148760331 | 78 | 52 | 94.2 | 2 | 1 | 228 | 12 | 88 | MBE17820.1 HNH endonuclease [Nitrospinota bacterium] | diamond | 234 | 41.2 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 28720894 | 28720894 | PRJNA556992_P_NODE_612647_length_258_cov_1.448649_g610458_i0 | PRJNA556992 | 612647 | 258 | 1.448649 | 3.73751442 | Nitrospina sp. | 2024844 | Bacteria | Bacteria | 41.6 | 0.0458 | NR | MBT5551450.1 | 2024844 | g610458 | i0 | 38.1 | 0.732558139534884 | 63 | 37 | 73.3 | 1 | 70 | 258 | 8 | 68 | MBT5551450.1 tetratricopeptide repeat protein [Nitrospina sp.] | diamond | 189 | 41.6 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospina | Nitrospina sp. | |
| 28720930 | 28720930 | PRJNA556992_P_NODE_697727_length_251_cov_2.179775_g695538_i0 | PRJNA556992 | 697727 | 251 | 2.179775 | 5.47123525 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 160 | 5.11e-45 | NR | HSF34303.1 | 2528274 | g695538 | i0 | 90.2 | 0.9800796812749 | 82 | 8 | 98 | 0 | 250 | 5 | 271 | 352 | HSF34303.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] | diamond | 246 | 160 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 29573108 | 29573108 | PRJNA556992_P_NODE_574490_length_261_cov_1.590426_g572301_i0 | PRJNA556992 | 574490 | 261 | 1.590426 | 4.15101186 | Candidatus Entotheonella gemina | 1429439 | Bacteria | Bacteria | 162 | 2.4499999999999998e-48 | NR | ETX08796.1 | 1429439 | g572301 | i0 | 94.2 | 0.988505747126437 | 86 | 5 | 98.9 | 0 | 2 | 259 | 100 | 185 | ETX08796.1 MAG: hypothetical protein ETSY2_03280 [Candidatus Entotheonella gemina] | diamond | 258 | 162 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | Candidatus Entotheonella gemina | |
| 30078155 | 30078155 | PRJNA556992_P_NODE_1056572_length_223_cov_5.013333_g1054382_i0 | PRJNA556992 | 1056572 | 223 | 5.013333 | 11.17973259 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 149 | 2.72e-41 | NR | MDQ3829216.1 | 2528274 | g1054382 | i0 | 100 | 1.96412556053812 | 73 | 0 | 98.2 | 0 | 221 | 3 | 14 | 86 | MDQ3829216.1 prenyltransferase [Candidatus Tectimicrobiota bacterium] | diamond | 438 | 149 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 30520946 | 30520946 | PRJNA556992_P_NODE_637973_length_256_cov_1.398907_g635784_i0 | PRJNA556992 | 637973 | 256 | 1.398907 | 3.58120192 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 145 | 1.83e-39 | NR | MBM3222209.1 | 2528274 | g635784 | i0 | 77.4 | 1.96875 | 84 | 19 | 98.4 | 0 | 3 | 254 | 119 | 202 | MBM3222209.1 radical SAM protein [Candidatus Tectimicrobiota bacterium] | diamond | 504 | 145 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31026241 | 31026241 | PRJNA556992_P_NODE_1017395_length_228_cov_7.574194_g1015205_i0 | PRJNA556992 | 1017395 | 228 | 7.574194 | 17.26916232 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 124 | 2.0899999999999998e-32 | NR | HEY7494745.1 | 2528274 | g1015205 | i0 | 80 | 1.94736842105263 | 75 | 15 | 98.7 | 0 | 2 | 226 | 11 | 85 | HEY7494745.1 alpha-E domain-containing protein [Candidatus Tectimicrobiota bacterium] | diamond | 444 | 124 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 31230112 | 31230112 | PRJNA556992_P_NODE_1095335_length_214_cov_4.113475_g1093144_i0 | PRJNA556992 | 1095335 | 214 | 4.113475 | 8.8028365 | Bacteria | 2 | Bacteria | Bacteria | 54.3 | 1.87e-7 | NR | WP_089937444.1 | 93172 | g1093144 | i0 | 47.8 | 8.3411214953271 | 46 | 24 | 64.5 | 0 | 139 | 2 | 30 | 75 | WP_089937444.1 helix-turn-helix domain-containing protein [Candidatus Entotheonella palauensis] | diamond | 1785 | 54.7 | 0.992687385740402 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | Candidatus Entotheonella palauensis | |
| 31975351 | 31975351 | PRJNA556992_P_NODE_898178_length_241_cov_0.916667_g895988_i0 | PRJNA556992 | 898178 | 241 | 0.916667 | 2.20916747 | Candidatus Tectimicrobiota bacterium | 2528274 | Bacteria | Bacteria | 43.1 | 0.0252 | NR | MDH3603864.1 | 2528274 | g895988 | i0 | 32.3 | 0.809128630705394 | 65 | 37 | 80.9 | 1 | 7 | 201 | 68 | 125 | MDH3603864.1 NAD(P)-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium] | diamond | 195 | 43.1 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Tectimicrobiota bacterium | |||||
| 32481700 | 32481700 | PRJNA556992_P_NODE_766259_length_248_cov_0.880000_g764070_i0 | PRJNA556992 | 766259 | 248 | 0.88 | 2.1824 | Candidatus Entotheonella serta | 1652106 | Bacteria | Bacteria | 139 | 6.61e-38 | NR | PON19135.1 | 1652106 | g764070 | i0 | 81.7 | 0.991935483870968 | 82 | 15 | 99.2 | 0 | 247 | 2 | 184 | 265 | PON19135.1 hypothetical protein C2W62_04255 [Candidatus Entotheonella serta] | diamond | 246 | 139 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | Candidatus Entotheonella serta | |
| 32842303 | 32842303 | PRJNA556992_P_NODE_1093060_length_214_cov_5.950355_g1090869_i0 | PRJNA556992 | 1093060 | 214 | 5.950355 | 12.7337597 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 3.76e-19 | NR | ETX03665.1 | 1429438 | g1090869 | i0 | 60 | 5.80373831775701 | 70 | 28 | 98.1 | 0 | 3 | 212 | 335 | 404 | ETX03665.1 MAG: malonyl CoA-ACP transacylase [Candidatus Entotheonella factor] | diamond | 1242 | 91.3 | 0.991237677984666 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Candidatus Tectimicrobiota | Candidatus Entotheonellia | Candidatus Entotheonellales | Candidatus Entotheonellaceae | Candidatus Entotheonella | Candidatus Entotheonella factor |
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);;