contig_metadata
17 rows where bioproject = "PRJNA695273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9605977 | 9605977 | PRJNA695273_P_NODE_159288_length_241_cov_0.916667_g158530_i0 | PRJNA695273 | 159288 | 241 | 0.916667 | 2.20916747 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 211 | 3.38e-50 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g158530 | i0 | 82.645 | 25.6348547717842 | 242 | 38 | 99 | 4 | 1 | 240 | 3304828 | 3305067 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 6178 | 211 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 12155502 | 12155502 | PRJNA695273_P_NODE_108010_length_271_cov_1.161616_g107252_i0 | PRJNA695273 | 108010 | 271 | 1.161616 | 3.14797936 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 267 | 8.149999999999999e-67 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g107252 | i0 | 84.615 | 44.9335793357934 | 273 | 36 | 100 | 6 | 1 | 271 | 3042791 | 3042523 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 12177 | 267 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 12157515 | 12157515 | PRJNA695273_P_NODE_50650_length_382_cov_1.242718_g49892_i0 | PRJNA695273 | 50650 | 382 | 1.242718 | 4.74718276 | Pseudogemmatithrix | 3237678 | Bacteria | Bacteria | 129 | 7.63e-32 | NR | MBX9857145.1 | 2026741 | g49892 | i0 | 61.2 | 10.4371727748691 | 134 | 44 | 99.7 | 4 | 382 | 2 | 410 | 542 | MBX9857145.1 cation-translocating P-type ATPase [Gemmatimonadaceae bacterium] | diamond | 3987 | 130 | 0.992307692307692 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27272304 | 27272304 | PRJNA695273_P_NODE_128703_length_250_cov_0.870056_g127945_i0 | PRJNA695273 | 128703 | 250 | 0.870056 | 2.17514 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 112 | 3.41e-27 | NR | WP_329683072.1 | 2029185 | g127945 | i0 | 80.5 | 2.952 | 82 | 16 | 98.4 | 0 | 247 | 2 | 104 | 185 | WP_329683072.1 HEAT repeat domain-containing protein [Longimicrobium sp.] | diamond | 738 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 27883510 | 27883510 | PRJNA695273_P_NODE_79465_length_310_cov_1.299578_g78707_i0 | PRJNA695273 | 79465 | 310 | 1.299578 | 4.0286918 | Gemmatimonadota | 142182 | Bacteria | Bacteria | 78.6 | 1.43e-14 | NR | CAA9346451.1 | 246130 | g78707 | i0 | 43.5 | 11.2161290322581 | 92 | 52 | 89 | 0 | 25 | 300 | 123 | 214 | CAA9346451.1 MAG: Chemotaxis protein methyltransferase CheR, partial [uncultured Gemmatimonadaceae bacterium] | diamond | 3477 | 79 | 0.994936708860759 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 27998822 | 27998822 | PRJNA695273_P_NODE_151605_length_243_cov_1.776471_g150847_i0 | PRJNA695273 | 151605 | 243 | 1.776471 | 4.31682453 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 86.7 | 1.21e-17 | NR | HEY0037694.1 | 2029185 | g150847 | i0 | 57.5 | 0.987654320987654 | 80 | 33 | 97.5 | 1 | 238 | 2 | 297 | 376 | HEY0037694.1 hypothetical protein [Longimicrobium sp.] | diamond | 240 | 86.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28736120 | 28736120 | PRJNA695273_P_NODE_159367_length_241_cov_0.916667_g158609_i0 | PRJNA695273 | 159367 | 241 | 0.916667 | 2.20916747 | Roseisolibacter | 2093335 | Bacteria | Bacteria | 80.9 | 7.28e-16 | NR | WP_284352617.1 | 2014610 | g158609 | i0 | 60.8 | 1.95435684647303 | 79 | 30 | 98.3 | 1 | 5 | 241 | 21 | 98 | WP_284352617.1 HEAT repeat domain-containing protein [Roseisolibacter agri] | diamond | 471 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 28819237 | 28819237 | PRJNA695273_P_NODE_146028_length_245_cov_0.895349_g145270_i0 | PRJNA695273 | 146028 | 245 | 0.895349 | 2.19360505 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 106 | 3.2200000000000004e-27 | NR | HET7462406.1 | 2029185 | g145270 | i0 | 73.5 | 0.83265306122449 | 68 | 18 | 83.3 | 0 | 41 | 244 | 1 | 68 | HET7462406.1 hypothetical protein [Longimicrobium sp.] | diamond | 204 | 106 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29324670 | 29324670 | PRJNA695273_P_NODE_157289_length_242_cov_0.911243_g156531_i0 | PRJNA695273 | 157289 | 242 | 0.911243 | 2.20520806 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 108 | 1.1e-25 | NR | HEX5727049.1 | 3047548 | g156531 | i0 | 65 | 2.97520661157025 | 80 | 28 | 99.2 | 0 | 1 | 240 | 21 | 100 | HEX5727049.1 ABC transporter ATP-binding protein [Longimicrobiaceae bacterium] | diamond | 720 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 29671732 | 29671732 | PRJNA695273_P_NODE_100230_length_279_cov_1.980583_g99472_i0 | PRJNA695273 | 100230 | 279 | 1.980583 | 5.52582657 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 43.5 | 0.0127 | NR | HEX7240525.1 | 3047548 | g99472 | i0 | 40 | 0.537634408602151 | 50 | 28 | 53.8 | 1 | 95 | 244 | 57 | 104 | HEX7240525.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 150 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 30177402 | 30177402 | PRJNA695273_P_NODE_97592_length_282_cov_1.885167_g96834_i0 | PRJNA695273 | 97592 | 282 | 1.885167 | 5.31617094 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 152 | 3.0299999999999996e-42 | NR | HYW12242.1 | 2029185 | g96834 | i0 | 83.7 | 0.978723404255319 | 92 | 14 | 96.8 | 1 | 8 | 280 | 301 | 392 | HYW12242.1 tetratricopeptide repeat protein [Longimicrobium sp.] | diamond | 276 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30777822 | 30777822 | PRJNA695273_P_NODE_145014_length_245_cov_1.569767_g144256_i0 | PRJNA695273 | 145014 | 245 | 1.569767 | 3.84592915 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 47.8 | 3.21e-4 | NR | HEY0779335.1 | 2510638 | g144256 | i0 | 71.9 | 0.759183673469388 | 32 | 9 | 39.2 | 0 | 3 | 98 | 140 | 171 | HEY0779335.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Gemmatirosa sp.] | diamond | 186 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 30904243 | 30904243 | PRJNA695273_P_NODE_126094_length_251_cov_0.865169_g125336_i0 | PRJNA695273 | 126094 | 251 | 0.865169 | 2.17157419 | Gemmatimonas aurantiaca | 173480 | Bacteria | Bacteria | 44.3 | 0.012 | NR | WP_156799002.1 | 173480 | g125336 | i0 | 63.3 | 0.358565737051793 | 30 | 11 | 35.9 | 0 | 159 | 248 | 884 | 913 | WP_156799002.1 hypothetical protein [Gemmatimonas aurantiaca] | diamond | 90 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 31062409 | 31062409 | PRJNA695273_P_NODE_95175_length_285_cov_1.452830_g94417_i0 | PRJNA695273 | 95175 | 285 | 1.45283 | 4.1405655 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 46.2 | 0.00199 | NR | HUF76842.1 | 2910168 | g94417 | i0 | 36.8 | 0.91578947368421 | 87 | 51 | 91.6 | 3 | 284 | 24 | 61 | 143 | HUF76842.1 hypothetical protein [Longimicrobiales bacterium] | diamond | 261 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32117203 | 32117203 | PRJNA695273_P_NODE_96818_length_283_cov_1.466667_g96060_i0 | PRJNA695273 | 96818 | 283 | 1.466667 | 4.15066761 | Pseudogemmatithrix | 3237678 | Bacteria | Bacteria | 139 | 2.75e-36 | NR | HRQ77127.1 | 2026741 | g96060 | i0 | 75.6 | 11.6713780918728 | 90 | 22 | 95.4 | 0 | 283 | 14 | 319 | 408 | HRQ77127.1 mechanosensitive ion channel family protein [Gemmatimonadaceae bacterium] | diamond | 3303 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32549059 | 32549059 | PRJNA695273_P_NODE_99159_length_281_cov_1.062500_g98401_i0 | PRJNA695273 | 99159 | 281 | 1.0625 | 2.985625 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 48.1 | 7.2e-4 | NR | MEX2467906.1 | 2026742 | g98401 | i0 | 50 | 1.27046263345196 | 56 | 21 | 52.3 | 1 | 152 | 6 | 4 | 59 | MEX2467906.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Gemmatimonadota bacterium] | diamond | 357 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32643032 | 32643032 | PRJNA695273_P_NODE_153940_length_243_cov_0.905882_g153182_i0 | PRJNA695273 | 153940 | 243 | 0.905882 | 2.20129326 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 164 | 1.6e-48 | NR | HEY7568541.1 | 2026741 | g153182 | i0 | 93.8 | 0.987654320987654 | 80 | 5 | 98.8 | 0 | 3 | 242 | 81 | 160 | HEY7568541.1 glycosyltransferase [Gemmatimonadaceae bacterium] | diamond | 240 | 164 | 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);;