contig_metadata
12 rows where bioproject = "PRJNA977246", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2227238 | 2227238 | PRJNA977246_S_NODE_9262_length_506_cov_7.582809_g8364_i0 | PRJNA977246 | 9262 | 506 | 7.582809 | 38.36901354 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 119 | 5.6399999999999995e-30 | NR | OJU87881.1 | 1895829 | g8364 | i0 | 80.6 | 3.41501976284585 | 72 | 14 | 42.7 | 0 | 283 | 498 | 1 | 72 | OJU87881.1 MAG: DNA repair protein RecO [Candidatus Saccharibacteria bacterium 49-20] | diamond | 1728 | 120 | 0.991666666666667 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 4780035 | 4780035 | PRJNA977246_S_NODE_7304_length_582_cov_6767.213382_g6500_i0 | PRJNA977246 | 7304 | 582 | 6767.213382 | 39385.18188324 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 77.4 | 6.14e-13 | NR | MBR3138001.1 | 2026720 | g6500 | i0 | 42.9 | 0.469072164948454 | 91 | 48 | 44.8 | 1 | 499 | 239 | 201 | 291 | MBR3138001.1 adenine-specific methyltransferase EcoRI family protein [Candidatus Saccharibacteria bacterium] | diamond | 273 | 77.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 6372800 | 6372800 | PRJNA977246_S_NODE_16665_length_350_cov_5931.077882_g15673_i0 | PRJNA977246 | 16665 | 350 | 5931.077882 | 20758.772587 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 77 | 4.42e-16 | NR | HCH34397.1 | 2026720 | g15673 | i0 | 67.2 | 0.497142857142857 | 58 | 19 | 49.7 | 0 | 30 | 203 | 1 | 58 | HCH34397.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 174 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 9879216 | 9879216 | PRJNA977246_S_NODE_23248_length_277_cov_11.588710_g22256_i0 | PRJNA977246 | 23248 | 277 | 11.58871 | 32.1007267 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 379 | 1.03e-100 | NTclustered | gi|1799615131|gb|CP045921.1| | 2665156 | g22256 | i0 | 91.697 | 74 | 277 | 18 | 99 | 3 | 5 | 277 | 217527 | 217252 | Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome | blastn | 20498 | 379 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 23903296 | 23903296 | PRJNA977246_S_NODE_10139_length_480_cov_392.396896_g9214_i0 | PRJNA977246 | 10139 | 480 | 392.396896 | 1883.5051008 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 228 | 6.180000000000001e-70 | NR | HSX81222.1 | 2890869 | g9214 | i0 | 77.9 | 0.93125 | 149 | 33 | 93.1 | 0 | 478 | 32 | 135 | 283 | HSX81222.1 IS110 family transposase [Candidatus Saccharimonadia bacterium] | diamond | 447 | 228 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 26614389 | 26614389 | PRJNA977246_S_NODE_14701_length_383_cov_3.677966_g13712_i0 | PRJNA977246 | 14701 | 383 | 3.677966 | 14.08660978 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 164 | 1.49e-49 | NR | OYX53575.1 | 1970481 | g13712 | i0 | 88 | 0.720626631853786 | 92 | 11 | 72.1 | 0 | 17 | 292 | 50 | 141 | OYX53575.1 MAG: 50S ribosomal protein L11 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 276 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 27689967 | 27689967 | PRJNA977246_S_NODE_17424_length_340_cov_3.051447_g16432_i0 | PRJNA977246 | 17424 | 340 | 3.051447 | 10.3749198 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 69.7 | 5.03e-12 | NR | OYX53791.1 | 1970481 | g16432 | i0 | 39.1 | 0.767647058823529 | 87 | 52 | 75.9 | 1 | 338 | 81 | 69 | 155 | OYX53791.1 MAG: hypothetical protein B7Y92_01730 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 261 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 29394624 | 29394624 | PRJNA977246_S_NODE_24629_length_265_cov_4.800847_g23637_i0 | PRJNA977246 | 24629 | 265 | 4.800847 | 12.72224455 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 156 | 2.1099999999999998e-43 | NR | HSX81222.1 | 2890869 | g23637 | i0 | 82.1 | 0.950943396226415 | 84 | 15 | 95.1 | 0 | 253 | 2 | 57 | 140 | HSX81222.1 IS110 family transposase [Candidatus Saccharimonadia bacterium] | diamond | 252 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 29615264 | 29615264 | PRJNA977246_S_NODE_33350_length_209_cov_2.438889_g32358_i0 | PRJNA977246 | 33350 | 209 | 2.438889 | 5.09727801 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 104 | 4.56e-25 | NR | OYX53762.1 | 1970481 | g32358 | i0 | 89.5 | 0.818181818181818 | 57 | 6 | 81.8 | 0 | 5 | 175 | 267 | 323 | OYX53762.1 MAG: hypothetical protein B7Y92_01580 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 171 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 30026288 | 30026288 | PRJNA977246_S_NODE_44311_length_168_cov_2.294964_g43319_i0 | PRJNA977246 | 44311 | 168 | 2.294964 | 3.85553952 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 61.2 | 1.04e-9 | NR | HEY0965628.1 | 2973664 | g43319 | i0 | 60 | 0.803571428571429 | 45 | 18 | 80.4 | 0 | 137 | 3 | 16 | 60 | HEY0965628.1 GNAT family N-acetyltransferase [Candidatus Saccharimonadales bacterium] | diamond | 135 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30152266 | 30152266 | PRJNA977246_S_NODE_44212_length_168_cov_3.172662_g43220_i0 | PRJNA977246 | 44212 | 168 | 3.172662 | 5.33007216 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 48.5 | 1.17e-4 | NR | QQS17319.1 | 2026720 | g43220 | i0 | 91.7 | 0.428571428571429 | 24 | 2 | 42.9 | 0 | 74 | 3 | 4 | 27 | QQS17319.1 MAG: thymidylate synthase [Candidatus Saccharibacteria bacterium] | diamond | 72 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31422723 | 31422723 | PRJNA977246_S_NODE_46116_length_163_cov_2.798507_g45124_i0 | PRJNA977246 | 46116 | 163 | 2.798507 | 4.56156641 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 4.14e-20 | NR | OYX53696.1 | 1970481 | g45124 | i0 | 90.2 | 1.87730061349693 | 51 | 5 | 93.9 | 0 | 162 | 10 | 79 | 129 | OYX53696.1 MAG: hypothetical protein B7Y92_02015 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 306 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 |
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);;