contig_metadata
19 rows where bioproject = "PRJNA356682", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4225134 | 4225134 | PRJNA356682_P_NODE_44084_length_242_cov_0.911243_g43393_i0 | PRJNA356682 | 44084 | 242 | 0.911243 | 2.20520806 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 158 | 1.26e-44 | NR | MBK8645673.1 | 2026742 | g43393 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 2 | 241 | 278 | 357 | MBK8645673.1 GAF domain-containing protein [Gemmatimonadota bacterium] | diamond | 240 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 6774799 | 6774799 | PRJNA356682_P_NODE_11626_length_411_cov_3.878698_g10936_i0 | PRJNA356682 | 11626 | 411 | 3.878698 | 15.94144878 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 101 | 3.56e-22 | NR | HEU5042096.1 | 2448054 | g10936 | i0 | 57.3 | 1.08029197080292 | 96 | 41 | 70.1 | 0 | 379 | 92 | 296 | 391 | HEU5042096.1 HD domain-containing protein [Gemmatimonadales bacterium] | diamond | 444 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 11876339 | 11876339 | PRJNA356682_P_NODE_33930_length_257_cov_1.673913_g33239_i0 | PRJNA356682 | 33930 | 257 | 1.673913 | 4.30195641 | FCB group | 1783270 | Bacteria | Bacteria | 156 | 5.78e-44 | NR | MDH4347931.1 | 2026742 | g33239 | i0 | 88.2 | 39.6536964980545 | 85 | 10 | 99.2 | 0 | 1 | 255 | 316 | 400 | MDH4347931.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadota bacterium] | diamond | 10191 | 157 | 0.993630573248408 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 20198252 | 20198252 | PRJNA356682_P_NODE_2116_length_1046_cov_4.805755_g1575_i0 | PRJNA356682 | 2116 | 1046 | 4.8057550000000004 | 50.2681973 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 281 | 8.819999999999999e-89 | NR | MBK7714774.1 | 2026742 | g1575 | i0 | 50.2 | 0.926386233269598 | 323 | 123 | 92.6 | 5 | 970 | 2 | 1 | 285 | MBK7714774.1 50S ribosomal protein L1 [Gemmatimonadota bacterium] | diamond | 969 | 281 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 22074325 | 22074325 | PRJNA356682_P_NODE_37278_length_249_cov_3.051136_g36587_i0 | PRJNA356682 | 37278 | 249 | 3.051136 | 7.59732864 | Gemmatimonas aurantiaca | 173480 | Bacteria | Bacteria | 361 | 3.3e-95 | NTclustered | gi|226088597|dbj|AP009153.1| | 379066 | g36587 | i0 | 93.089 | 6.93574297188755 | 246 | 17 | 99 | 0 | 1 | 246 | 2062050 | 2062295 | Gemmatimonas aurantiaca T-27 DNA, complete genome | blastn | 1727 | 361 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 23349998 | 23349998 | PRJNA356682_P_NODE_799_length_1825_cov_34.620434_g486_i0 | PRJNA356682 | 799 | 1825 | 34.620434 | 631.8229205 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 2743 | 0 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g486 | i0 | 93.829 | 216.384109589041 | 1831 | 100 | 100 | 13 | 1 | 1825 | 2076527 | 2074704 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 394901 | 2743 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 26821834 | 26821834 | PRJNA356682_P_NODE_38021_length_249_cov_0.875000_g37330_i0 | PRJNA356682 | 38021 | 249 | 0.875 | 2.17875 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 119 | 4.2e-31 | NR | HEX6670529.1 | 2448054 | g37330 | i0 | 88.6 | 2.53012048192771 | 70 | 8 | 84.3 | 0 | 249 | 40 | 197 | 266 | HEX6670529.1 tetratricopeptide repeat protein [Gemmatimonadales bacterium] | diamond | 630 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26853559 | 26853559 | PRJNA356682_P_NODE_44521_length_241_cov_0.916667_g43830_i0 | PRJNA356682 | 44521 | 241 | 0.916667 | 2.20916747 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 137 | 8.259999999999999e-37 | NR | HOX20604.1 | 2448054 | g43830 | i0 | 94.8 | 1.92946058091286 | 77 | 4 | 95.9 | 0 | 11 | 241 | 264 | 340 | HOX20604.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadales bacterium] | diamond | 465 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27391093 | 27391093 | PRJNA356682_P_NODE_17403_length_342_cov_4.327138_g16712_i0 | PRJNA356682 | 17403 | 342 | 4.327138 | 14.79881196 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 154 | 1.4499999999999998e-42 | NR | HEU5042096.1 | 2448054 | g16712 | i0 | 84.5 | 0.850877192982456 | 97 | 13 | 83.3 | 2 | 18 | 302 | 319 | 415 | HEU5042096.1 HD domain-containing protein [Gemmatimonadales bacterium] | diamond | 291 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27454263 | 27454263 | PRJNA356682_P_NODE_15683_length_358_cov_5.596491_g14993_i0 | PRJNA356682 | 15683 | 358 | 5.596491 | 20.03543778 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 74.7 | 3.16e-15 | NR | HZB28403.1 | 2448054 | g14993 | i0 | 72.3 | 0.393854748603352 | 47 | 13 | 39.4 | 0 | 99 | 239 | 4 | 50 | HZB28403.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 141 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28306569 | 28306569 | PRJNA356682_P_NODE_26846_length_284_cov_5.497630_g26155_i0 | PRJNA356682 | 26846 | 284 | 5.49763 | 15.6132692 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 74.3 | 1.93e-15 | NR | HZB28403.1 | 2448054 | g26155 | i0 | 70.8 | 0.507042253521127 | 48 | 14 | 50.7 | 0 | 93 | 236 | 2 | 49 | HZB28403.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 144 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28338187 | 28338187 | PRJNA356682_P_NODE_37166_length_250_cov_0.870056_g36475_i0 | PRJNA356682 | 37166 | 250 | 0.870056 | 2.17514 | Gemmatimonas sp. UBA7669 | 1946568 | Bacteria | Bacteria | 150 | 1.8e-41 | NR | WP_343125840.1 | 1946568 | g36475 | i0 | 96.4 | 0.996 | 83 | 3 | 99.6 | 0 | 1 | 249 | 302 | 384 | WP_343125840.1 RNA polymerase sigma factor [Gemmatimonas sp. UBA7669] | diamond | 249 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. UBA7669 | |
| 28969659 | 28969659 | PRJNA356682_P_NODE_30128_length_271_cov_1.191919_g29437_i0 | PRJNA356682 | 30128 | 271 | 1.191919 | 3.23010049 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 170 | 9.65e-47 | NR | HEX5075855.1 | 2026741 | g29437 | i0 | 89.9 | 2.95571955719557 | 89 | 9 | 98.5 | 0 | 268 | 2 | 414 | 502 | HEX5075855.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadaceae bacterium] | diamond | 801 | 170 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29159250 | 29159250 | PRJNA356682_P_NODE_40189_length_246_cov_0.890173_g39498_i0 | PRJNA356682 | 40189 | 246 | 0.890173 | 2.18982558 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 131 | 5.879999999999999e-35 | NR | MEX2582494.1 | 2026742 | g39498 | i0 | 79.3 | 1.97560975609756 | 82 | 17 | 100 | 0 | 1 | 246 | 218 | 299 | MEX2582494.1 N-acetyl-gamma-glutamyl-phosphate reductase [Gemmatimonadota bacterium] | diamond | 486 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30313673 | 30313673 | PRJNA356682_P_NODE_9692_length_449_cov_1.114362_g9002_i0 | PRJNA356682 | 9692 | 449 | 1.114362 | 5.00348538 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 90.9 | 5.99e-18 | NR | HUL02172.1 | 2448054 | g9002 | i0 | 45.5 | 2.73273942093541 | 123 | 58 | 82.2 | 3 | 385 | 17 | 1771 | 1884 | HUL02172.1 calcium-binding protein [Gemmatimonadales bacterium] | diamond | 1227 | 90.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31243851 | 31243851 | PRJNA356682_P_NODE_40475_length_246_cov_0.890173_g39784_i0 | PRJNA356682 | 40475 | 246 | 0.890173 | 2.18982558 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 169 | 1.67e-49 | NR | MBX9855000.1 | 2026741 | g39784 | i0 | 100 | 1 | 82 | 0 | 100 | 0 | 1 | 246 | 60 | 141 | MBX9855000.1 diguanylate cyclase [Gemmatimonadaceae bacterium] | diamond | 246 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32097927 | 32097927 | PRJNA356682_P_NODE_23638_length_300_cov_2.035242_g22947_i0 | PRJNA356682 | 23638 | 300 | 2.035242 | 6.105726 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 91.3 | 4.67e-22 | NR | HZB28403.1 | 2448054 | g22947 | i0 | 79.6 | 0.49 | 49 | 10 | 49 | 0 | 214 | 68 | 4 | 52 | HZB28403.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 147 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32446269 | 32446269 | PRJNA356682_P_NODE_19579_length_325_cov_3.849206_g18888_i0 | PRJNA356682 | 19579 | 325 | 3.849206 | 12.5099195 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 96.3 | 6.859999999999999e-24 | NR | HZB28403.1 | 2448054 | g18888 | i0 | 78.8 | 0.48 | 52 | 11 | 48 | 0 | 270 | 115 | 2 | 53 | HZB28403.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 156 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32509611 | 32509611 | PRJNA356682_P_NODE_39739_length_247_cov_0.885057_g39048_i0 | PRJNA356682 | 39739 | 247 | 0.885057 | 2.18609079 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 46.6 | 0.00174 | NR | MDB4951000.1 | 2026742 | g39048 | i0 | 26.7 | 0.910931174089069 | 75 | 48 | 91.1 | 1 | 4 | 228 | 473 | 540 | MDB4951000.1 proton-translocating NADH-quinone oxidoreductase, chain [Gemmatimonadota bacterium] | diamond | 225 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;