contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8422798 | 8422798 | PRJNA788929_P_NODE_49307_length_203_cov_4.546154_g48646_i0 | PRJNA788929 | 49307 | 203 | 4.546154 | 9.22869262 | Candidatus Saccharibacteria bacterium TM7i | 2980174 | Bacteria | Bacteria | 76.3 | 1.97e-14 | NR | UTX51373.1 | 2980174 | g48646 | i0 | 63.9 | 1.72906403940887 | 61 | 22 | 90.1 | 0 | 9 | 191 | 143 | 203 | UTX51373.1 membrane protein insertase YidC [Candidatus Saccharibacteria bacterium TM7i] | diamond | 351 | 76.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium TM7i | ||||||
| 18621172 | 18621172 | PRJNA788929_P_NODE_5755_length_813_cov_90.705405_g5156_i0 | PRJNA788929 | 5755 | 813 | 90.705405 | 737.43494265 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 216 | 1.2799999999999998e-66 | NR | MCA9770713.1 | 2030827 | g5156 | i0 | 52.8 | 1.54612546125461 | 212 | 97 | 77.1 | 2 | 749 | 123 | 1 | 212 | MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium] | diamond | 1257 | 216 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 18621176 | 18621176 | PRJNA788929_P_NODE_5855_length_803_cov_48.847945_g5253_i0 | PRJNA788929 | 5855 | 803 | 48.847945 | 392.24899835 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 218 | 1.43e-67 | NR | MCA9770713.1 | 2030827 | g5253 | i0 | 53.3 | 1.5653798256538 | 212 | 96 | 78.1 | 2 | 730 | 104 | 1 | 212 | MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium] | diamond | 1257 | 218 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 26768817 | 26768817 | PRJNA788929_P_NODE_10541_length_546_cov_120.788584_g9888_i0 | PRJNA788929 | 10541 | 546 | 120.788584 | 659.50566864 | Candidatus Kaiserbacteria bacterium CG1 | 2030810 | Bacteria | Bacteria | 70.5 | 1.06e-11 | NR | PIR82824.1 | 1974612 | g9888 | i0 | 53.8 | 0.357142857142857 | 65 | 26 | 34.1 | 3 | 132 | 317 | 90 | 153 | PIR82824.1 MAG: hypothetical protein COU20_00140 [Candidatus Kaiserbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_59_10] | diamond | 195 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_59_10 | ||||||
| 28253811 | 28253811 | PRJNA788929_P_NODE_16146_length_416_cov_33.090379_g15487_i0 | PRJNA788929 | 16146 | 416 | 33.090379 | 137.65597664 | Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13 | 1801652 | Bacteria | Bacteria | 75.1 | 1.8e-14 | NR | OGI32801.1 | 1801652 | g15487 | i0 | 38.6 | 2.31490384615385 | 88 | 52 | 62 | 1 | 55 | 312 | 21 | 108 | OGI32801.1 MAG: hypothetical protein A2420_01235 [Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13] | diamond | 963 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moranbacteria bacterium RIFOXYC1_FULL_44_13 | ||||||
| 28421167 | 28421167 | PRJNA788929_P_NODE_23306_length_334_cov_13.325670_g22645_i0 | PRJNA788929 | 23306 | 334 | 13.32567 | 44.5077378 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 3.41e-18 | NR | HEY4522717.1 | 2053589 | g22645 | i0 | 70 | 1.96706586826347 | 50 | 15 | 44.9 | 0 | 185 | 334 | 166 | 215 | HEY4522717.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 657 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29043383 | 29043383 | PRJNA788929_P_NODE_24528_length_324_cov_3.581673_g23867_i0 | PRJNA788929 | 24528 | 324 | 3.581673 | 11.60462052 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 111 | 2.13e-29 | NR | MDP5038850.1 | 2044595 | g23867 | i0 | 78.9 | 1.40740740740741 | 76 | 16 | 70.4 | 0 | 230 | 3 | 1 | 76 | MDP5038850.1 30S ribosomal protein S20 [Candidatus Altimarinota bacterium] | diamond | 456 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29264032 | 29264032 | PRJNA788929_P_NODE_18809_length_379_cov_39.810458_g18149_i0 | PRJNA788929 | 18809 | 379 | 39.810458 | 150.88163582 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 110 | 2.55e-28 | NR | MEK7571582.1 | 2052139 | g18149 | i0 | 56.7 | 0.767810026385224 | 97 | 40 | 75.2 | 1 | 1 | 285 | 44 | 140 | MEK7571582.1 DUF1761 domain-containing protein [Patescibacteria group bacterium] | diamond | 291 | 110 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30275142 | 30275142 | PRJNA788929_P_NODE_26812_length_307_cov_19.482906_g26151_i0 | PRJNA788929 | 26812 | 307 | 19.482906 | 59.81252142 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 49.3 | 1.61e-5 | NR | MBX6334419.1 | 2026720 | g26151 | i0 | 60.5 | 0.371335504885993 | 38 | 15 | 37.1 | 0 | 266 | 153 | 10 | 47 | MBX6334419.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 114 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30338520 | 30338520 | PRJNA788929_P_NODE_38092_length_250_cov_11.937853_g37431_i0 | PRJNA788929 | 38092 | 250 | 11.937853 | 29.8446325 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 67 | 4.22e-11 | NR | MBW7954936.1 | 2044595 | g37431 | i0 | 53.7 | 0.804 | 67 | 30 | 79.2 | 1 | 50 | 247 | 1 | 67 | MBW7954936.1 16S rRNA (uracil(1498)-N(3))-methyltransferase [Candidatus Altimarinota bacterium] | diamond | 201 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32456706 | 32456706 | PRJNA788929_P_NODE_12499_length_489_cov_27.377404_g11842_i0 | PRJNA788929 | 12499 | 489 | 27.377404 | 133.87550556 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 112 | 5.13e-28 | NR | NQS90093.1 | 2052139 | g11842 | i0 | 56 | 1.86503067484663 | 100 | 37 | 61.3 | 2 | 312 | 13 | 18 | 110 | NQS90093.1 macro domain-containing protein [Patescibacteria group bacterium] | diamond | 912 | 112 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32645664 | 32645664 | PRJNA788929_P_NODE_34640_length_264_cov_14.010471_g33979_i0 | PRJNA788929 | 34640 | 264 | 14.010471 | 36.98764344 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 44.7 | 0.00966 | NR | MEC7869053.1 | 2026781 | g33979 | i0 | 41.9 | 1.40909090909091 | 62 | 33 | 70.5 | 1 | 68 | 253 | 276 | 334 | MEC7869053.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 372 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32866318 | 32866318 | PRJNA788929_P_NODE_38720_length_249_cov_1.312500_g38059_i0 | PRJNA788929 | 38720 | 249 | 1.3125 | 3.268125 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 48.5 | 1.95e-4 | NR | MEK7639282.1 | 2052139 | g38059 | i0 | 41.7 | 1.43373493975904 | 60 | 30 | 67.5 | 3 | 183 | 16 | 113 | 171 | MEK7639282.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 357 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;