contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Parcubacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26954088 | 26954088 | PRJNA630162_P_NODE_91062_length_191_cov_1.626761_g89539_i0 | PRJNA630162 | 91062 | 191 | 1.626761 | 3.10711351 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 59.7 | 5.83e-10 | NR | MEY2671689.1 | 2762014 | g89539 | i0 | 55 | 0.942408376963351 | 60 | 27 | 94.2 | 0 | 11 | 190 | 4 | 63 | MEY2671689.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 180 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27346444 | 27346444 | PRJNA630162_P_NODE_112383_length_178_cov_2.341085_g110860_i0 | PRJNA630162 | 112383 | 178 | 2.341085 | 4.1671313 | Bacteria | 2 | Bacteria | Bacteria | 85.5 | 2.71e-18 | NR | KND50186.1 | 1659197 | g110860 | i0 | 69.6 | 1.8876404494382 | 56 | 17 | 94.4 | 0 | 173 | 6 | 28 | 83 | KND50186.1 MAG: hypothetical protein AB198_01875 [Parcubacteria bacterium C7867-003] | diamond | 336 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-003 | ||||||
| 27460203 | 27460203 | PRJNA630162_P_NODE_86563_length_194_cov_3.000000_g85040_i0 | PRJNA630162 | 86563 | 194 | 3 | 5.82 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 90.9 | 1.37e-19 | NR | MBW3537939.1 | 2762014 | g85040 | i0 | 69 | 0.896907216494845 | 58 | 18 | 89.7 | 0 | 5 | 178 | 356 | 413 | MBW3537939.1 cell division protein FtsA [Candidatus Parcubacteria bacterium] | diamond | 174 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27775988 | 27775988 | PRJNA630162_P_NODE_86504_length_194_cov_3.420690_g84981_i0 | PRJNA630162 | 86504 | 194 | 3.42069 | 6.6361386 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 47.4 | 2.95e-4 | NR | MEN9412989.1 | 2762014 | g84981 | i0 | 53.8 | 0.603092783505155 | 39 | 18 | 60.3 | 0 | 120 | 4 | 5 | 43 | MEN9412989.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 117 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 27807425 | 27807425 | PRJNA630162_P_NODE_131364_length_169_cov_1.216667_g129841_i0 | PRJNA630162 | 131364 | 169 | 1.216667 | 2.05616723 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 52.4 | 3.77e-7 | NR | MEY2671690.1 | 2762014 | g129841 | i0 | 73 | 0.656804733727811 | 37 | 10 | 65.7 | 0 | 164 | 54 | 25 | 61 | MEY2671690.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 111 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28059676 | 28059676 | PRJNA630162_P_NODE_105645_length_182_cov_1.812030_g104122_i0 | PRJNA630162 | 105645 | 182 | 1.81203 | 3.2978946 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 83.6 | 3.74e-18 | NR | MEN9412989.1 | 2762014 | g104122 | i0 | 73.7 | 0.93956043956044 | 57 | 15 | 94 | 0 | 176 | 6 | 87 | 143 | MEN9412989.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 171 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28122952 | 28122952 | PRJNA630162_P_NODE_125325_length_171_cov_5.057377_g123802_i0 | PRJNA630162 | 125325 | 171 | 5.057377 | 8.64811467 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 41.2 | 0.0381 | NR | RME60816.1 | 2762014 | g123802 | i0 | 48.4 | 0.543859649122807 | 31 | 16 | 54.4 | 0 | 116 | 24 | 91 | 121 | RME60816.1 MAG: hypothetical protein D6779_01410 [Candidatus Parcubacteria bacterium] | diamond | 93 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28343925 | 28343925 | PRJNA630162_P_NODE_125146_length_172_cov_1.162602_g123623_i0 | PRJNA630162 | 125146 | 172 | 1.162602 | 1.99967544 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 47 | 4.76e-5 | NR | MEY2671689.1 | 2762014 | g123623 | i0 | 51 | 0.88953488372093 | 51 | 25 | 89 | 0 | 7 | 159 | 6 | 56 | MEY2671689.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 153 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28388215 | 28388215 | PRJNA630162_P_NODE_133586_length_168_cov_2.647059_g132063_i0 | PRJNA630162 | 133586 | 168 | 2.647059 | 4.44705912 | Bacteria | 2 | Bacteria | Bacteria | 72.8 | 3.29e-13 | NR | KND47610.1 | 1659200 | g132063 | i0 | 63 | 1.92857142857143 | 54 | 20 | 96.4 | 0 | 167 | 6 | 137 | 190 | KND47610.1 MAG: hypothetical protein AB201_01605 [Parcubacteria bacterium C7867-006] | diamond | 324 | 73.2 | 0.994535519125683 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-006 | ||||||
| 28596668 | 28596668 | PRJNA630162_P_NODE_115847_length_176_cov_3.196850_g114324_i0 | PRJNA630162 | 115847 | 176 | 3.19685 | 5.626456 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 51.2 | 2.03e-6 | NR | GIW67773.1 | 2762014 | g114324 | i0 | 47.4 | 0.971590909090909 | 57 | 29 | 95.5 | 1 | 174 | 7 | 1 | 57 | GIW67773.1 MAG: hypothetical protein KatS3mg096_641 [Candidatus Parcubacteria bacterium] | diamond | 171 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28944233 | 28944233 | PRJNA630162_P_NODE_164688_length_159_cov_3.209091_g163165_i0 | PRJNA630162 | 164688 | 159 | 3.209091 | 5.10245469 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 40 | 0.0156 | NR | MEY4602323.1 | 2762014 | g163165 | i0 | 90 | 0.377358490566038 | 20 | 2 | 37.7 | 0 | 98 | 39 | 1 | 20 | MEY4602323.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 60 | 40 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29512055 | 29512055 | PRJNA630162_P_NODE_132490_length_169_cov_0.866667_g130967_i0 | PRJNA630162 | 132490 | 169 | 0.866667 | 1.46466723 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 81.3 | 1.21e-16 | NR | MEY3471005.1 | 2762014 | g130967 | i0 | 74.1 | 0.958579881656805 | 54 | 14 | 95.9 | 0 | 167 | 6 | 196 | 249 | MEY3471005.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 162 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30428764 | 30428764 | PRJNA630162_P_NODE_94773_length_189_cov_1.142857_g93250_i0 | PRJNA630162 | 94773 | 189 | 1.142857 | 2.15999973 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 74.7 | 5.96e-15 | NR | MFM2381326.1 | 2762014 | g93250 | i0 | 63.3 | 0.777777777777778 | 49 | 18 | 77.8 | 0 | 3 | 149 | 115 | 163 | MFM2381326.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 147 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 31692585 | 31692585 | PRJNA630162_P_NODE_172477_length_152_cov_2.320388_g170954_i0 | PRJNA630162 | 172477 | 152 | 2.320388 | 3.52698976 | Parcubacteria bacterium C7867- | 2762014 | Bacteria | Bacteria | 43.9 | 0.00108 | NR | KND51121.1 | 1659195 | g170954 | i0 | 44 | 0.986842105263158 | 50 | 28 | 98.7 | 0 | 150 | 1 | 51 | 100 | KND51121.1 MAG: hypothetical protein ABA06_02290 [Parcubacteria bacterium C7867-001] | diamond | 150 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-001 | ||||||
| 31787237 | 31787237 | PRJNA630162_P_NODE_111217_length_179_cov_1.515385_g109694_i0 | PRJNA630162 | 111217 | 179 | 1.515385 | 2.71253915 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 101 | 2.8000000000000003e-23 | NR | MEN9552019.1 | 2762014 | g109694 | i0 | 86 | 1.92737430167598 | 57 | 8 | 95.5 | 0 | 177 | 7 | 628 | 684 | MEN9552019.1 gyrase subunit gyrase subunit protein [Candidatus Parcubacteria bacterium] | diamond | 345 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 32452169 | 32452169 | PRJNA630162_P_NODE_157279_length_163_cov_0.912281_g155756_i0 | PRJNA630162 | 157279 | 163 | 0.912281 | 1.48701803 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 94.4 | 4.45e-21 | NR | MBC7766521.1 | 2762014 | g155756 | i0 | 84.6 | 0.957055214723926 | 52 | 8 | 95.7 | 0 | 2 | 157 | 207 | 258 | MBC7766521.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 156 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria 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);;