contig_metadata
13 rows where bioproject = "PRJNA283169" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27737846 | 27737846 | PRJNA283169_S_NODE_1184_length_248_cov_0.185930_g1170_i0 | PRJNA283169 | 1184 | 248 | 0.18593 | 0.4611064 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 60.8 | 1.58e-8 | NR | MCA9346965.1 | 2026720 | g1170 | i0 | 42.9 | 0.846774193548387 | 70 | 37 | 83.5 | 2 | 11 | 217 | 324 | 391 | MCA9346965.1 GTPase ObgE [Candidatus Saccharibacteria bacterium] | diamond | 210 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27769330 | 27769330 | PRJNA283169_P_NODE_3944_length_211_cov_1.228395_g3881_i0 | PRJNA283169 | 3944 | 211 | 1.228395 | 2.59191345 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 73.9 | 4.08e-14 | NR | HSX08222.1 | 2973664 | g3881 | i0 | 56.4 | 1.56398104265403 | 55 | 24 | 78.2 | 0 | 47 | 211 | 114 | 168 | HSX08222.1 Type 1 glutamine amidotransferase-like domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 330 | 73.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28007933 | 28007933 | PRJNA283169_P_NODE_5345_length_185_cov_1.117647_g5282_i0 | PRJNA283169 | 5345 | 185 | 1.117647 | 2.06764695 | Bacteria | 2 | Bacteria | Bacteria | 64.7 | 1.93e-10 | NR | OYX53643.1 | 1970481 | g5282 | i0 | 50.8 | 3.81081081081081 | 61 | 28 | 95.7 | 1 | 185 | 9 | 214 | 274 | OYX53643.1 MAG: hypothetical protein B7Y92_02235 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 705 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 28116292 | 28116292 | PRJNA283169_P_NODE_1905_length_295_cov_1.459350_g1843_i0 | PRJNA283169 | 1905 | 295 | 1.45935 | 4.3050825 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 59.3 | 8.23e-9 | NR | MFO0920052.1 | 2973664 | g1843 | i0 | 42.9 | 0.711864406779661 | 70 | 40 | 71.2 | 0 | 215 | 6 | 1 | 70 | MFO0920052.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 210 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29032295 | 29032295 | PRJNA283169_P_NODE_8128_length_162_cov_0.902655_g8065_i0 | PRJNA283169 | 8128 | 162 | 0.902655 | 1.4623011 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 59.3 | 6.44e-9 | NR | HSX15287.1 | 2973664 | g8065 | i0 | 69.2 | 0.722222222222222 | 39 | 12 | 72.2 | 0 | 2 | 118 | 152 | 190 | HSX15287.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 117 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29063746 | 29063746 | PRJNA283169_P_NODE_5128_length_189_cov_0.992857_g5065_i0 | PRJNA283169 | 5128 | 189 | 0.992857 | 1.87649973 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 113 | 9.309999999999999e-28 | NR | HEY5268251.1 | 2973664 | g5065 | i0 | 81 | 1 | 63 | 12 | 100 | 0 | 1 | 189 | 179 | 241 | HEY5268251.1 DnaB-like helicase C-terminal domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 189 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29095326 | 29095326 | PRJNA283169_P_NODE_5888_length_176_cov_2.015748_g5825_i0 | PRJNA283169 | 5888 | 176 | 2.015748 | 3.54771648 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 45.1 | 0.00212 | NR | RTK94023.1 | 2026720 | g5825 | i0 | 61.5 | 0.886363636363636 | 26 | 10 | 44.3 | 0 | 78 | 1 | 1 | 26 | RTK94023.1 MAG: FkbM family methyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 156 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30579401 | 30579401 | PRJNA283169_S_NODE_1453_length_226_cov_0.096045_g1439_i0 | PRJNA283169 | 1453 | 226 | 0.096045 | 0.2170617 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 103 | 3e-24 | NR | HSX29423.1 | 2973664 | g1439 | i0 | 72.6 | 1.64601769911504 | 62 | 17 | 82.3 | 0 | 218 | 33 | 292 | 353 | HSX29423.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 372 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30611111 | 30611111 | PRJNA283169_S_NODE_1473_length_225_cov_0.136364_g1459_i0 | PRJNA283169 | 1473 | 225 | 0.136364 | 0.306819 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 60.1 | 5.86e-9 | NR | HMT18554.1 | 2026720 | g1459 | i0 | 52.8 | 0.706666666666667 | 53 | 25 | 70.7 | 0 | 221 | 63 | 127 | 179 | HMT18554.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 159 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31527960 | 31527960 | PRJNA283169_P_NODE_5696_length_179_cov_1.584615_g5633_i0 | PRJNA283169 | 5696 | 179 | 1.584615 | 2.83646085 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 53.5 | 2.42e-6 | NR | HSX10037.1 | 2973664 | g5633 | i0 | 42.9 | 1.92737430167598 | 56 | 32 | 93.9 | 0 | 178 | 11 | 116 | 171 | HSX10037.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 345 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31812513 | 31812513 | PRJNA283169_P_NODE_1317_length_347_cov_1.365772_g1255_i0 | PRJNA283169 | 1317 | 347 | 1.365772 | 4.73922884 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 87.8 | 2.28e-20 | NR | NCU38814.1 | 2026720 | g1255 | i0 | 69.5 | 0.510086455331412 | 59 | 18 | 51 | 0 | 272 | 96 | 1 | 59 | NCU38814.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 177 | 87.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31812514 | 31812514 | PRJNA283169_P_NODE_1817_length_303_cov_1.417323_g1755_i0 | PRJNA283169 | 1817 | 303 | 1.4173230000000001 | 4.29448869 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 67.8 | 7.69e-12 | NR | RTK93579.1 | 2026720 | g1755 | i0 | 60.4 | 0.475247524752475 | 48 | 19 | 47.5 | 0 | 298 | 155 | 91 | 138 | RTK93579.1 MAG: hypothetical protein EKI60_05680 [Candidatus Saccharibacteria bacterium] | diamond | 144 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32508889 | 32508889 | PRJNA283169_S_NODE_799_length_290_cov_0.120332_g785_i0 | PRJNA283169 | 799 | 290 | 0.120332 | 0.3489628 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 130 | 1.3399999999999998e-32 | NR | HXS14588.1 | 2973664 | g785 | i0 | 64.9 | 0.972413793103448 | 94 | 33 | 97.2 | 0 | 286 | 5 | 557 | 650 | HXS14588.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 282 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;