contig_metadata
13 rows where bioproject = "PRJNA1144090", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6665642 | 6665642 | PRJNA1144090_P_NODE_82486_length_277_cov_1.911765_g81951_i0 | PRJNA1144090 | 82486 | 277 | 1.911765 | 5.29558905 | Candidatus Saccharibacteria bacterium oral taxon 955 | 2572087 | Bacteria | Bacteria | 468 | 2.14e-127 | NTclustered | gi|1663049602|gb|CP040008.1| | 2572087 | g81951 | i0 | 97.112 | 348.451263537906 | 277 | 8 | 100 | 0 | 1 | 277 | 138975 | 138699 | Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome | blastn | 96521 | 468 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 955 | ||||||
| 15060668 | 15060668 | PRJNA1144090_P_NODE_121732_length_198_cov_4.088000_g121197_i0 | PRJNA1144090 | 121732 | 198 | 4.088 | 8.09424 | Candidatus Nanosynbacteraceae | 2093822 | Bacteria | Bacteria | 320 | 4.26e-83 | NTclustered | gi|2306607015|emb|OX335598.1| | 2026720 | g121197 | i0 | 95.939 | 140.641414141414 | 197 | 8 | 99 | 0 | 2 | 198 | 79814 | 79618 | Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001 | blastn | 27847 | 320 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 15590417 | 15590417 | PRJNA1144090_P_NODE_62793_length_320_cov_1.829960_g62258_i0 | PRJNA1144090 | 62793 | 320 | 1.82996 | 5.855872 | Candidatus Saccharibacteria bacterium RAAC3_TM7_1 | 1394711 | Bacteria | Bacteria | 436 | 7.089999999999999e-118 | NTclustered | gi|563353835|gb|CP006915.1| | 1394711 | g62258 | i0 | 91.304 | 68.91875 | 322 | 24 | 100 | 4 | 1 | 320 | 451999 | 451680 | Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome | blastn | 22054 | 436 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RAAC3_TM7_1 | ||||||
| 19413682 | 19413682 | PRJNA1144090_P_NODE_75756_length_290_cov_1.654378_g75221_i0 | PRJNA1144090 | 75756 | 290 | 1.654378 | 4.7976962 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 457 | 4.8699999999999985e-124 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g75221 | i0 | 95.189 | 261.355172413793 | 291 | 11 | 99 | 3 | 1 | 289 | 220710 | 220421 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 75793 | 457 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 21434997 | 21434997 | PRJNA1144090_P_NODE_98957_length_251_cov_1.702247_g98422_i0 | PRJNA1144090 | 98957 | 251 | 1.702247 | 4.27263997 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|1842054184|gb|CP039999.1| | 713059 | g98422 | i0 | 100 | 238.338645418327 | 251 | 0 | 100 | 0 | 1 | 251 | 142472 | 142222 | Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome | blastn | 59823 | 464 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 21963580 | 21963580 | PRJNA1144090_P_NODE_100618_length_250_cov_1.542373_g100083_i0 | PRJNA1144090 | 100618 | 250 | 1.542373 | 3.8559325 | Candidatus Nanogingivalaceae bacterium | 2725942 | Bacteria | Bacteria | 451 | 1.91e-122 | NTclustered | gi|2070571752|gb|CP072208.2| | 2725942 | g100083 | i0 | 99.2 | 72.612 | 250 | 2 | 100 | 0 | 1 | 250 | 111595 | 111346 | MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome | blastn | 18153 | 451 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Nanosyncoccalia | Candidatus Nanogingivales | Candidatus Nanogingivalaceae | Candidatus Nanogingivalaceae bacterium | |||
| 26806267 | 26806267 | PRJNA1144090_P_NODE_39701_length_409_cov_16.708333_g39166_i0 | PRJNA1144090 | 39701 | 409 | 16.708333 | 68.33708197 | Bacteria | 2 | Bacteria | Bacteria | 104 | 4.5e-26 | NR | MDB5169429.1 | 2026720 | g39166 | i0 | 55.4 | 6.62347188264059 | 83 | 37 | 60.9 | 0 | 291 | 43 | 5 | 87 | MDB5169429.1 rbpA [Candidatus Saccharibacteria bacterium] | diamond | 2709 | 105 | 0.990476190476191 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27291800 | 27291800 | PRJNA1144090_P_NODE_44423_length_385_cov_1.769231_g43888_i0 | PRJNA1144090 | 44423 | 385 | 1.769231 | 6.81153935 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 64.7 | 1.02e-9 | NR | HUD82748.1 | 2973664 | g43888 | i0 | 36.2 | 1.01298701298701 | 130 | 65 | 99.7 | 2 | 2 | 385 | 32 | 145 | HUD82748.1 WD40 repeat domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 390 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28775778 | 28775778 | PRJNA1144090_P_NODE_72147_length_297_cov_3.897321_g71612_i0 | PRJNA1144090 | 72147 | 297 | 3.897321 | 11.57504337 | Candidatus Nanosynbacter sp. HMT-352 | 2899133 | Bacteria | Bacteria | 62.8 | 6.62e-9 | NR | WP_243777738.1 | 2899133 | g71612 | i0 | 43.3 | 0.909090909090909 | 90 | 46 | 88.9 | 3 | 270 | 7 | 340 | 426 | WP_243777738.1 RCC1 domain-containing protein [Candidatus Nanosynbacter sp. HMT-352] | diamond | 270 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-352 | ||
| 29375731 | 29375731 | PRJNA1144090_P_NODE_71369_length_299_cov_2.070796_g70834_i0 | PRJNA1144090 | 71369 | 299 | 2.070796 | 6.19168004 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 80.1 | 5.47e-15 | NR | HEY1085289.1 | 2973664 | g70834 | i0 | 41.9 | 0.862876254180602 | 86 | 46 | 82.3 | 2 | 21 | 266 | 504 | 589 | HEY1085289.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 258 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29533606 | 29533606 | PRJNA1144090_P_NODE_49570_length_362_cov_4.494810_g49035_i0 | PRJNA1144090 | 49570 | 362 | 4.49481 | 16.2712122 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 89.4 | 5.28e-18 | NR | HVS79003.1 | 2973664 | g49035 | i0 | 38.8 | 2.85082872928177 | 116 | 62 | 96.1 | 2 | 349 | 2 | 257 | 363 | HVS79003.1 glycine--tRNA ligase [Candidatus Saccharimonadales bacterium] | diamond | 1032 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30702416 | 30702416 | PRJNA1144090_P_NODE_85954_length_271_cov_2.272727_g85419_i0 | PRJNA1144090 | 85954 | 271 | 2.272727 | 6.15909017 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 44.3 | 0.00907 | NR | MBQ2638843.1 | 2026720 | g85419 | i0 | 35.3 | 0.940959409594096 | 85 | 43 | 93 | 4 | 257 | 6 | 85 | 158 | MBQ2638843.1 RsmD family RNA methyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 255 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31840309 | 31840309 | PRJNA1144090_P_NODE_112937_length_243_cov_0.905882_g112402_i0 | PRJNA1144090 | 112937 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 171 | 1.11e-50 | NR | MBB1562781.1 | 2026720 | g112402 | i0 | 98.8 | 2 | 81 | 1 | 100 | 0 | 1 | 243 | 67 | 147 | MBB1562781.1 glycine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 486 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;