contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA591127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26934928 | 26934928 | PRJNA591127_P_NODE_17402_length_197_cov_2.500000_g17233_i0 | PRJNA591127 | 17402 | 197 | 2.5 | 4.925 | Bacteria | 2 | Bacteria | Bacteria | 46.6 | 1.99e-4 | NR | MBP7845841.1 | 2053589 | g17233 | i0 | 75 | 1.11167512690355 | 24 | 6 | 36.5 | 0 | 76 | 5 | 37 | 60 | MBP7845841.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 219 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27048128 | 27048128 | PRJNA591127_P_NODE_27882_length_154_cov_3.376068_g27713_i0 | PRJNA591127 | 27882 | 154 | 3.376068 | 5.19914472 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 96.3 | 1.1399999999999999e-23 | NR | MDR3570669.1 | 2053589 | g27713 | i0 | 90.2 | 0.993506493506494 | 51 | 5 | 99.4 | 0 | 154 | 2 | 57 | 107 | MDR3570669.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 153 | 96.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27079698 | 27079698 | PRJNA591127_P_NODE_22922_length_181_cov_7.243056_g22753_i0 | PRJNA591127 | 22922 | 181 | 7.243056 | 13.10993136 | Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_ | 2053593 | Bacteria | Bacteria | 42 | 0.0313 | NR | PIQ74711.1 | 1974818 | g22753 | i0 | 52.9 | 0.56353591160221 | 34 | 16 | 56.4 | 0 | 80 | 181 | 77 | 110 | PIQ74711.1 MAG: elongation factor 4 [Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_0_20_44_10] | diamond | 102 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG11_big_fil_rev_8_21_14_0_20_44_10 | ||||||
| 27616912 | 27616912 | PRJNA591127_P_NODE_29024_length_151_cov_4.736842_g28855_i0 | PRJNA591127 | 29024 | 151 | 4.736842 | 7.15263142 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 50.4 | 2.02e-5 | NR | MES2971515.1 | 2052139 | g28855 | i0 | 52.9 | 1.78807947019868 | 34 | 16 | 67.5 | 0 | 1 | 102 | 359 | 392 | MES2971515.1 S41 family peptidase [Patescibacteria group bacterium] | diamond | 270 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27995776 | 27995776 | PRJNA591127_P_NODE_20205_length_197_cov_1.775000_g20036_i0 | PRJNA591127 | 20205 | 197 | 1.775 | 3.49675 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 65.5 | 1.94e-10 | NR | MFA6198652.1 | 2052139 | g20036 | i0 | 58.5 | 0.989847715736041 | 65 | 23 | 99 | 1 | 3 | 197 | 347 | 407 | MFA6198652.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 195 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28469463 | 28469463 | PRJNA591127_P_NODE_18486_length_197_cov_2.206250_g18317_i0 | PRJNA591127 | 18486 | 197 | 2.20625 | 4.3463125 | candidate division WWE3 bacterium RIFCSPHIGHO2_ | 2053526 | Bacteria | Bacteria | 55.1 | 8.98e-7 | NR | OGC47839.1 | 1802614 | g18317 | i0 | 92 | 0.380710659898477 | 25 | 2 | 38.1 | 0 | 195 | 121 | 54 | 78 | OGC47839.1 MAG: hypothetical protein A2713_01270 [candidate division WWE3 bacterium RIFCSPHIGHO2_01_FULL_35_17] | diamond | 75 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium RIFCSPHIGHO2_01_FULL_35_17 | ||||||
| 28500952 | 28500952 | PRJNA591127_P_NODE_28607_length_151_cov_6.982456_g28438_i0 | PRJNA591127 | 28607 | 151 | 6.982456 | 10.54350856 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 49.7 | 4.53e-6 | NR | MDD3662973.1 | 2053589 | g28438 | i0 | 85.2 | 1.09271523178808 | 27 | 4 | 53.6 | 0 | 148 | 68 | 49 | 75 | MDD3662973.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29479349 | 29479349 | PRJNA591127_P_NODE_7550_length_268_cov_1.350649_g7382_i0 | PRJNA591127 | 7550 | 268 | 1.350649 | 3.61973932 | candidate division WWE3 bacterium CSP1-7 | 1576480 | Bacteria | Bacteria | 48.9 | 2.43e-5 | NR | KRT67739.1 | 1576480 | g7382 | i0 | 52.3 | 0.951492537313433 | 44 | 21 | 49.3 | 0 | 40 | 171 | 15 | 58 | KRT67739.1 MAG: Uncharacterized protein XU08_C0001G0148 [candidate division WWE3 bacterium CSP1-7] | diamond | 255 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium CSP1-7 | ||||||
| 30743192 | 30743192 | PRJNA591127_P_NODE_24214_length_173_cov_2.286765_g24045_i0 | PRJNA591127 | 24214 | 173 | 2.286765 | 3.95610345 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 47.8 | 1.43e-4 | NR | MEK7650155.1 | 2052139 | g24045 | i0 | 60.6 | 1.38728323699422 | 33 | 13 | 57.2 | 0 | 153 | 55 | 6 | 38 | MEK7650155.1 50S ribosomal protein L6 [Patescibacteria group bacterium] | diamond | 240 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32134603 | 32134603 | PRJNA591127_P_NODE_17458_length_197_cov_2.481250_g17289_i0 | PRJNA591127 | 17458 | 197 | 2.48125 | 4.8880625 | Candidatus Microsaccharimonas sossegonensis | 2506948 | Bacteria | Bacteria | 52.4 | 7.96e-6 | NR | RWZ78033.1 | 2506948 | g17289 | i0 | 100 | 0.380710659898477 | 25 | 0 | 38.1 | 0 | 76 | 2 | 119 | 143 | RWZ78033.1 MAG: ISL3 family transposase [Candidatus Microsaccharimonas sossegonensis] | diamond | 75 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Microsaccharimonas | Candidatus Microsaccharimonas sossegonensis | ||
| 32860759 | 32860759 | PRJNA591127_P_NODE_24000_length_174_cov_6.883212_g23831_i0 | PRJNA591127 | 24000 | 174 | 6.883212 | 11.97678888 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 41.6 | 0.0134 | NR | MDR3570671.1 | 2053589 | g23831 | i0 | 48.4 | 1.10344827586207 | 64 | 26 | 98.3 | 2 | 172 | 2 | 35 | 98 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 192 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;