contig_metadata
21 rows where bioproject = "PRJNA315399", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18235158 | 18235158 | PRJNA315399_P_NODE_483235_length_153_cov_1.224138_g482787_i0 | PRJNA315399 | 483235 | 153 | 1.224138 | 1.87293114 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 261 | 1.91e-65 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g482787 | i0 | 99.306 | 0.941176470588235 | 144 | 1 | 94 | 0 | 3 | 146 | 1165923 | 1166066 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 144 | 261 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 26599279 | 26599279 | PRJNA315399_P_NODE_436821_length_157_cov_11.000000_g436373_i0 | PRJNA315399 | 436821 | 157 | 11 | 17.27 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 90.1 | 1.5700000000000001e-19 | NR | MDP5038930.1 | 2044595 | g436373 | i0 | 87 | 1.75796178343949 | 46 | 6 | 87.9 | 0 | 18 | 155 | 332 | 377 | MDP5038930.1 serine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 276 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26725898 | 26725898 | PRJNA315399_S_NODE_84381_length_186_cov_11.865772_g84180_i0 | PRJNA315399 | 84381 | 186 | 11.865772 | 22.07033592 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 41.6 | 0.0457 | NR | NJM06269.1 | 2044595 | g84180 | i0 | 79.2 | 0.387096774193548 | 24 | 5 | 38.7 | 0 | 81 | 10 | 6 | 29 | NJM06269.1 M20 family metallopeptidase [Candidatus Altimarinota bacterium] | diamond | 72 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26870701 | 26870701 | PRJNA315399_P_NODE_413661_length_160_cov_3.723577_g413213_i0 | PRJNA315399 | 413661 | 160 | 3.723577 | 5.9577232 | Bacteria | 2 | Bacteria | Bacteria | 41.6 | 0.0302 | NR | MCH8519030.1 | 2044595 | g413213 | i0 | 70 | 1.0125 | 30 | 9 | 56.3 | 0 | 3 | 92 | 84 | 113 | MCH8519030.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 162 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27295637 | 27295637 | PRJNA315399_P_NODE_250883_length_182_cov_1.531034_g250435_i0 | PRJNA315399 | 250883 | 182 | 1.531034 | 2.78648188 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 53.1 | 3.51e-6 | NR | MDX9971227.1 | 2044595 | g250435 | i0 | 52 | 0.824175824175824 | 50 | 24 | 82.4 | 0 | 9 | 158 | 307 | 356 | MDX9971227.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 150 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27516763 | 27516763 | PRJNA315399_P_NODE_159903_length_188_cov_2.543046_g159455_i0 | PRJNA315399 | 159903 | 188 | 2.543046 | 4.78092648 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 43.5 | 0.00955 | NR | MDD5770059.1 | 2044595 | g159455 | i0 | 81 | 0.654255319148936 | 21 | 4 | 33.5 | 0 | 180 | 118 | 6 | 26 | MDD5770059.1 O-antigen ligase family protein [Candidatus Altimarinota bacterium] | diamond | 123 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27818602 | 27818602 | PRJNA315399_P_NODE_272764_length_180_cov_4.286713_g272316_i0 | PRJNA315399 | 272764 | 180 | 4.286713 | 7.7160834 | Bacteria | 2 | Bacteria | Bacteria | 105 | 1.72e-24 | NR | RKW24403.1 | 2044595 | g272316 | i0 | 100 | 1.9 | 57 | 0 | 95 | 0 | 172 | 2 | 345 | 401 | RKW24403.1 MAG: hypothetical protein D8B45_02275 [Candidatus Altimarinota bacterium] | diamond | 342 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27927227 | 27927227 | PRJNA315399_P_NODE_166025_length_187_cov_5.233333_g165577_i0 | PRJNA315399 | 166025 | 187 | 5.233333 | 9.78633271 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 44.3 | 0.00494 | NR | MDD5769614.1 | 2044595 | g165577 | i0 | 95 | 0.320855614973262 | 20 | 1 | 32.1 | 0 | 33 | 92 | 307 | 326 | MDD5769614.1 DEAD/DEAH box helicase [Candidatus Altimarinota bacterium] | diamond | 60 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28211261 | 28211261 | PRJNA315399_P_NODE_99486_length_201_cov_9.902439_g99038_i0 | PRJNA315399 | 99486 | 201 | 9.902439 | 19.90390239 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 52 | 1.1e-5 | NR | MFA4890871.1 | 2044595 | g99038 | i0 | 40.4 | 0.850746268656716 | 57 | 34 | 85.1 | 0 | 199 | 29 | 75 | 131 | MFA4890871.1 ketopantoate reductase C-terminal domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 171 | 52 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28274465 | 28274465 | PRJNA315399_P_NODE_513666_length_150_cov_2.371681_g513218_i0 | PRJNA315399 | 513666 | 150 | 2.371681 | 3.5575215 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 47.8 | 2e-5 | NR | MCF7812114.1 | 2044595 | g513218 | i0 | 60 | 0.8 | 40 | 16 | 80 | 0 | 124 | 5 | 29 | 68 | MCF7812114.1 50S ribosomal protein L29 [Candidatus Altimarinota bacterium] | diamond | 120 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28558868 | 28558868 | PRJNA315399_P_NODE_168507_length_187_cov_3.820000_g168059_i0 | PRJNA315399 | 168507 | 187 | 3.82 | 7.1434 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 43.1 | 0.008 | NR | MDD3720057.1 | 2044595 | g168059 | i0 | 83.3 | 1.70053475935829 | 24 | 4 | 38.5 | 0 | 169 | 98 | 65 | 88 | MDD3720057.1 peptide deformylase [Candidatus Altimarinota bacterium] | diamond | 318 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29411149 | 29411149 | PRJNA315399_P_NODE_76869_length_213_cov_4.022727_g76421_i0 | PRJNA315399 | 76869 | 213 | 4.022727 | 8.56840851 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 50.1 | 6.52e-5 | NR | MBB1554590.1 | 2044595 | g76421 | i0 | 100 | 0.309859154929577 | 22 | 0 | 31 | 0 | 54 | 119 | 652 | 673 | MBB1554590.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 66 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29428419 | 29428419 | PRJNA315399_P_NODE_422489_length_159_cov_4.065574_g422041_i0 | PRJNA315399 | 422489 | 159 | 4.065574 | 6.46426266 | Bacteria | 2 | Bacteria | Bacteria | 59.3 | 1.01e-8 | NR | RKW25159.1 | 2044595 | g422041 | i0 | 42.2 | 4.69811320754717 | 83 | 3 | 71.7 | 1 | 11 | 124 | 161 | 243 | RKW25159.1 MAG: hypothetical protein D8B45_01165, partial [Candidatus Altimarinota bacterium] | diamond | 747 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29505850 | 29505850 | PRJNA315399_P_NODE_310150_length_178_cov_3.475177_g309702_i0 | PRJNA315399 | 310150 | 178 | 3.475177 | 6.18581506 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 50.8 | 7.65e-6 | NR | MBB1554006.1 | 2044595 | g309702 | i0 | 51.9 | 1.28089887640449 | 52 | 25 | 87.6 | 0 | 168 | 13 | 94 | 145 | MBB1554006.1 Hsp20/alpha crystallin family protein [Candidatus Altimarinota bacterium] | diamond | 228 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29537497 | 29537497 | PRJNA315399_S_NODE_133930_length_165_cov_8.085938_g133729_i0 | PRJNA315399 | 133930 | 165 | 8.085938 | 13.3417977 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 74.3 | 3.85e-15 | NR | MBP6921330.1 | 2044595 | g133729 | i0 | 69.4 | 0.890909090909091 | 49 | 15 | 89.1 | 0 | 17 | 163 | 86 | 134 | MBP6921330.1 DUF1761 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 147 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30327697 | 30327697 | PRJNA315399_P_NODE_479172_length_153_cov_3.560345_g478724_i0 | PRJNA315399 | 479172 | 153 | 3.560345 | 5.44732785 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 45.1 | 0.00163 | NR | MBP7773562.1 | 2044595 | g478724 | i0 | 49.1 | 1.03921568627451 | 53 | 21 | 92.2 | 1 | 8 | 148 | 238 | 290 | MBP7773562.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 159 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31275094 | 31275094 | PRJNA315399_P_NODE_92395_length_205_cov_1.994048_g91947_i0 | PRJNA315399 | 92395 | 205 | 1.994048 | 4.0877984 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 93.6 | 1.04e-21 | NR | RKW22920.1 | 2044595 | g91947 | i0 | 73.8 | 0.892682926829268 | 61 | 5 | 73.2 | 1 | 164 | 15 | 142 | 202 | RKW22920.1 MAG: phosphatase PAP2 family protein [Candidatus Altimarinota bacterium] | diamond | 183 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31577330 | 31577330 | PRJNA315399_P_NODE_148556_length_189_cov_3.559211_g148108_i0 | PRJNA315399 | 148556 | 189 | 3.559211 | 6.72690879 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00165 | NR | MFA5854971.1 | 2044595 | g148108 | i0 | 70.8 | 2.66666666666667 | 24 | 7 | 38.1 | 0 | 16 | 87 | 31 | 54 | MFA5854971.1 dihydrofolate reductase [Candidatus Altimarinota bacterium] | diamond | 504 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31798425 | 31798425 | PRJNA315399_P_NODE_501877_length_151_cov_3.061404_g501429_i0 | PRJNA315399 | 501877 | 151 | 3.061404 | 4.62272004 | Bacteria | 2 | Bacteria | Bacteria | 62 | 5.51e-10 | NR | RKW23230.1 | 2044595 | g501429 | i0 | 96.7 | 1.19205298013245 | 30 | 1 | 59.6 | 0 | 141 | 52 | 92 | 121 | RKW23230.1 MAG: hypothetical protein D8B45_03720 [Candidatus Altimarinota bacterium] | diamond | 180 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32319406 | 32319406 | PRJNA315399_S_NODE_148759_length_161_cov_3.540323_g148558_i0 | PRJNA315399 | 148759 | 161 | 3.540323 | 5.69992003 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 85.1 | 1.43e-17 | NR | HRY90744.1 | 2044595 | g148558 | i0 | 97.6 | 0.763975155279503 | 41 | 1 | 76.4 | 0 | 123 | 1 | 1 | 41 | HRY90744.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 123 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32540765 | 32540765 | PRJNA315399_P_NODE_37679_length_256_cov_4.835616_g37232_i0 | PRJNA315399 | 37679 | 256 | 4.835616 | 12.37917696 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 53.5 | 5.11e-6 | NR | ATU04884.1 | 1540872 | g37232 | i0 | 59 | 0.45703125 | 39 | 16 | 45.7 | 0 | 5 | 121 | 50 | 88 | ATU04884.1 hypothetical protein BKN14_00300 [Candidatus Gracilibacteria bacterium HOT-871] | diamond | 117 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 |
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);;