contig_metadata
13 rows where bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19496091 | 19496091 | PRJNA270367_P_NODE_41616_length_167_cov_0.881356_g41411_i0 | PRJNA270367 | 41616 | 167 | 0.881356 | 1.47186452 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 187 | 3.68e-43 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g41411 | i0 | 88.387 | 0.92814371257485 | 155 | 18 | 93 | 0 | 7 | 161 | 3780447 | 3780293 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 155 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 27200256 | 27200256 | PRJNA270367_P_NODE_31842_length_196_cov_1.047619_g31637_i0 | PRJNA270367 | 31842 | 196 | 1.047619 | 2.05333324 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 98.2 | 2.37e-22 | NR | HEU6453690.1 | 2026741 | g31637 | i0 | 59.4 | 6.76530612244898 | 64 | 26 | 98 | 0 | 3 | 194 | 315 | 378 | HEU6453690.1 multicopper oxidase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 1326 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27579512 | 27579512 | PRJNA270367_P_NODE_43424_length_165_cov_0.896552_g43219_i0 | PRJNA270367 | 43424 | 165 | 0.896552 | 1.4793108 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 47 | 3.52e-4 | NR | MBT6147915.1 | 2026742 | g43219 | i0 | 53.8 | 0.709090909090909 | 39 | 18 | 70.9 | 0 | 144 | 28 | 60 | 98 | MBT6147915.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 117 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27642901 | 27642901 | PRJNA270367_P_NODE_25004_length_230_cov_1.149171_g24799_i0 | PRJNA270367 | 25004 | 230 | 1.149171 | 2.6430933 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 74.3 | 2.33e-13 | NR | MEO7999787.1 | 2026741 | g24799 | i0 | 57.4 | 1.65652173913043 | 61 | 26 | 79.6 | 0 | 185 | 3 | 290 | 350 | MEO7999787.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 381 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28400498 | 28400498 | PRJNA270367_P_NODE_33586_length_189_cov_1.264286_g33381_i0 | PRJNA270367 | 33586 | 189 | 1.264286 | 2.38950054 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 71.6 | 9.35e-13 | NR | HKV75498.1 | 2448054 | g33381 | i0 | 47.5 | 4.68253968253968 | 59 | 31 | 93.7 | 0 | 188 | 12 | 47 | 105 | HKV75498.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadales bacterium] | diamond | 885 | 71.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29568665 | 29568665 | PRJNA270367_P_NODE_46410_length_162_cov_0.920354_g46205_i0 | PRJNA270367 | 46410 | 162 | 0.920354 | 1.49097348 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 46.2 | 7.56e-4 | NR | HEV2180266.1 | 2026741 | g46205 | i0 | 72.4 | 0.537037037037037 | 29 | 8 | 53.7 | 0 | 162 | 76 | 33 | 61 | HEV2180266.1 multicopper oxidase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 87 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29916268 | 29916268 | PRJNA270367_P_NODE_43531_length_165_cov_0.896552_g43326_i0 | PRJNA270367 | 43531 | 165 | 0.896552 | 1.4793108 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 50.8 | 1.81e-5 | NR | RMH69234.1 | 2026742 | g43326 | i0 | 53.7 | 0.745454545454545 | 41 | 17 | 70.9 | 1 | 117 | 1 | 42 | 82 | RMH69234.1 MAG: lipase [Gemmatimonadota bacterium] | diamond | 123 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30611051 | 30611051 | PRJNA270367_P_NODE_8933_length_448_cov_1.887218_g8734_i0 | PRJNA270367 | 8933 | 448 | 1.887218 | 8.45473664 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 63.5 | 1.84e-8 | NR | MBM3956824.1 | 2026742 | g8734 | i0 | 32.7 | 1.00446428571429 | 150 | 75 | 99.1 | 6 | 1 | 444 | 87 | 212 | MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium] | diamond | 450 | 63.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32115051 | 32115051 | PRJNA270367_P_NODE_3378_length_750_cov_2.092725_g3199_i0 | PRJNA270367 | 3378 | 750 | 2.092725 | 15.6954375 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 218 | 3.98e-63 | NR | NNE08319.1 | 2026742 | g3199 | i0 | 42.7 | 2.84 | 239 | 126 | 95.2 | 5 | 2 | 715 | 103 | 331 | NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] | diamond | 2130 | 219 | 0.995433789954338 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32223856 | 32223856 | PRJNA270367_P_NODE_44718_length_164_cov_0.904348_g44513_i0 | PRJNA270367 | 44718 | 164 | 0.904348 | 1.48313072 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 76.6 | 2.6e-15 | NR | HWP37596.1 | 2448054 | g44513 | i0 | 67.4 | 5.26829268292683 | 46 | 15 | 84.1 | 0 | 27 | 164 | 154 | 199 | HWP37596.1 peptidylprolyl isomerase [Gemmatimonadales bacterium] | diamond | 864 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32287365 | 32287365 | PRJNA270367_P_NODE_36679_length_178_cov_1.209302_g36474_i0 | PRJNA270367 | 36679 | 178 | 1.209302 | 2.15255756 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 43.1 | 0.0112 | NR | HUC42016.1 | 2448054 | g36474 | i0 | 40 | 1.01123595505618 | 60 | 31 | 97.8 | 2 | 176 | 3 | 208 | 264 | HUC42016.1 serine/threonine-protein kinase [Gemmatimonadales bacterium] | diamond | 180 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32318991 | 32318991 | PRJNA270367_P_NODE_22699_length_246_cov_1.421320_g22494_i0 | PRJNA270367 | 22699 | 246 | 1.42132 | 3.4964472 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 52 | 2.07e-5 | NR | MBA2292746.1 | 2448054 | g22494 | i0 | 56.4 | 0.670731707317073 | 55 | 23 | 67.1 | 1 | 9 | 173 | 516 | 569 | MBA2292746.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadales bacterium] | diamond | 165 | 52 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32350513 | 32350513 | PRJNA270367_P_NODE_12819_length_366_cov_1.536278_g12617_i0 | PRJNA270367 | 12819 | 366 | 1.536278 | 5.62277748 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 182 | 5.16e-52 | NR | MCC6317049.1 | 2026741 | g12617 | i0 | 68 | 18 | 122 | 39 | 100 | 0 | 366 | 1 | 240 | 361 | MCC6317049.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadaceae bacterium] | diamond | 6588 | 182 | 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);;