contig_metadata
17 rows where bioproject = "PRJNA315314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27028612 | 27028612 | PRJNA315314_S_NODE_8162_length_283_cov_2.417323_g7841_i0 | PRJNA315314 | 8162 | 283 | 2.417323 | 6.84102409 | Bacteria | 2 | Bacteria | Bacteria | 170 | 4.33e-50 | NR | PJC56712.1 | 1974578 | g7841 | i0 | 88.3 | 1.99293286219081 | 94 | 11 | 99.6 | 0 | 2 | 283 | 197 | 290 | PJC56712.1 MAG: DNA-directed RNA polymerase subunit alpha, partial [Candidatus Gracilibacteria bacterium CG_4_9_14_0_2_um_filter_38_7] | diamond | 564 | 170 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG_4_9_14_0_2_um_filter_38_7 | ||||||
| 27832410 | 27832410 | PRJNA315314_S_NODE_21824_length_178_cov_1.234899_g21503_i0 | PRJNA315314 | 21824 | 178 | 1.234899 | 2.19812022 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 61.6 | 6.68e-10 | NR | MDD2745058.1 | 2044595 | g21503 | i0 | 55.4 | 0.943820224719101 | 56 | 25 | 94.4 | 0 | 169 | 2 | 91 | 146 | MDD2745058.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 168 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28165752 | 28165752 | PRJNA315314_S_NODE_14245_length_216_cov_5.502674_g13924_i0 | PRJNA315314 | 14245 | 216 | 5.502674 | 11.88577584 | Bacteria | 2 | Bacteria | Bacteria | 96.7 | 2.7e-21 | NR | NRH20577.1 | 2044595 | g13924 | i0 | 70.4 | 1.97222222222222 | 71 | 21 | 98.6 | 0 | 3 | 215 | 17 | 87 | NRH20577.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 426 | 97.4 | 0.992813141683778 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28211148 | 28211148 | PRJNA315314_S_NODE_13526_length_222_cov_1.538860_g13205_i0 | PRJNA315314 | 13526 | 222 | 1.53886 | 3.4162692 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 119 | 1.4999999999999995e-32 | NR | MDD2745391.1 | 2044595 | g13205 | i0 | 76.7 | 0.986486486486487 | 73 | 17 | 98.6 | 0 | 221 | 3 | 19 | 91 | MDD2745391.1 single-stranded DNA-binding protein [Candidatus Altimarinota bacterium] | diamond | 219 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28211177 | 28211177 | PRJNA315314_S_NODE_6386_length_319_cov_7.417241_g6065_i0 | PRJNA315314 | 6386 | 319 | 7.417241 | 23.66099879 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 122 | 9.7e-30 | NR | NRH20577.1 | 2044595 | g6065 | i0 | 62.6 | 1.99373040752351 | 107 | 36 | 98.7 | 2 | 317 | 3 | 146 | 250 | NRH20577.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 636 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28495662 | 28495662 | PRJNA315314_S_NODE_32527_length_150_cov_1.719008_g32206_i0 | PRJNA315314 | 32527 | 150 | 1.719008 | 2.578512 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 47.8 | 4.9e-5 | NR | MBP8016826.1 | 2044595 | g32206 | i0 | 60 | 2.22 | 40 | 12 | 72 | 2 | 112 | 5 | 3 | 42 | MBP8016826.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 333 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28527305 | 28527305 | PRJNA315314_S_NODE_31007_length_153_cov_1.653226_g30686_i0 | PRJNA315314 | 31007 | 153 | 1.653226 | 2.52943578 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 61.2 | 2.52e-10 | NR | MDD2745665.1 | 2044595 | g30686 | i0 | 67.5 | 0.784313725490196 | 40 | 13 | 78.4 | 0 | 33 | 152 | 42 | 81 | MDD2745665.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 120 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29821359 | 29821359 | PRJNA315314_S_NODE_21911_length_177_cov_4.087838_g21590_i0 | PRJNA315314 | 21911 | 177 | 4.087838 | 7.23547326 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 43.5 | 0.00823 | NR | PID84389.1 | 2044595 | g21590 | i0 | 50.8 | 1 | 59 | 24 | 98.3 | 2 | 3 | 176 | 516 | 570 | PID84389.1 MAG: hypothetical protein CSB09_01090 [Candidatus Altimarinota bacterium] | diamond | 177 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30105829 | 30105829 | PRJNA315314_S_NODE_22652_length_175_cov_1.575342_g22331_i0 | PRJNA315314 | 22652 | 175 | 1.575342 | 2.7568485 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 65.1 | 4.02e-12 | NR | MDD2745601.1 | 2044595 | g22331 | i0 | 70.7 | 0.702857142857143 | 41 | 12 | 70.3 | 0 | 131 | 9 | 1 | 41 | MDD2745601.1 cold shock domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 123 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30264254 | 30264254 | PRJNA315314_S_NODE_8812_length_273_cov_2.635246_g8491_i0 | PRJNA315314 | 8812 | 273 | 2.635246 | 7.19422158 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 145 | 6.37e-43 | NR | MDD2744967.1 | 2044595 | g8491 | i0 | 80.5 | 0.956043956043956 | 87 | 17 | 95.6 | 0 | 3 | 263 | 30 | 116 | MDD2744967.1 STAS domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 261 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30660555 | 30660555 | PRJNA315314_S_NODE_22653_length_175_cov_1.568493_g22332_i0 | PRJNA315314 | 22653 | 175 | 1.568493 | 2.74486275 | Bacteria | 2 | Bacteria | Bacteria | 83.6 | 6.14e-17 | NR | OIP53253.1 | 1805211 | g22332 | i0 | 69 | 1.97142857142857 | 58 | 18 | 99.4 | 0 | 175 | 2 | 44 | 101 | OIP53253.1 MAG: hypothetical protein AUK10_02565 [Candidatus Gracilibacteria bacterium CG2_30_37_12] | diamond | 345 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG2_30_37_12 | ||||||
| 30706141 | 30706141 | PRJNA315314_S_NODE_31794_length_151_cov_3.319672_g31473_i0 | PRJNA315314 | 31794 | 151 | 3.319672 | 5.01270472 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 50.4 | 7.65e-6 | NR | NDK08128.1 | 2044595 | g31473 | i0 | 54.2 | 3.73509933774834 | 48 | 22 | 95.4 | 0 | 3 | 146 | 25 | 72 | NDK08128.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 564 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31275015 | 31275015 | PRJNA315314_S_NODE_5835_length_334_cov_1.934426_g5514_i0 | PRJNA315314 | 5835 | 334 | 1.934426 | 6.46098284 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 74.7 | 1.04e-13 | NR | MBP8016921.1 | 2044595 | g5514 | i0 | 51.9 | 2.29041916167665 | 79 | 36 | 69.2 | 1 | 35 | 265 | 81 | 159 | MBP8016921.1 type II secretion system protein [Candidatus Altimarinota bacterium] | diamond | 765 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31306606 | 31306606 | PRJNA315314_S_NODE_19775_length_186_cov_1.757962_g19454_i0 | PRJNA315314 | 19775 | 186 | 1.757962 | 3.26980932 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 42 | 0.0288 | NR | MDD2745385.1 | 2044595 | g19454 | i0 | 41.5 | 0.854838709677419 | 53 | 27 | 79 | 1 | 2 | 148 | 63 | 115 | MDD2745385.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 159 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31907642 | 31907642 | PRJNA315314_S_NODE_29557_length_156_cov_1.614173_g29236_i0 | PRJNA315314 | 29557 | 156 | 1.614173 | 2.51810988 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 79 | 1.9e-15 | NR | MDD2745354.1 | 2044595 | g29236 | i0 | 68.6 | 0.980769230769231 | 51 | 16 | 98.1 | 0 | 3 | 155 | 452 | 502 | MDD2745354.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 153 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32209970 | 32209970 | PRJNA315314_S_NODE_9798_length_259_cov_2.052174_g9477_i0 | PRJNA315314 | 9798 | 259 | 2.052174 | 5.31513066 | Bacteria | 2 | Bacteria | Bacteria | 85.5 | 3.66e-17 | NR | MDD2487635.1 | 2044595 | g9477 | i0 | 42.2 | 1.92277992277992 | 83 | 48 | 96.1 | 0 | 3 | 251 | 212 | 294 | MDD2487635.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 498 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32855366 | 32855366 | PRJNA315314_S_NODE_25680_length_165_cov_6.441176_g25359_i0 | PRJNA315314 | 25680 | 165 | 6.441176 | 10.6279404 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 102 | 7.71e-27 | NR | MDD2693917.1 | 2044595 | g25359 | i0 | 92.6 | 0.981818181818182 | 54 | 4 | 98.2 | 0 | 163 | 2 | 36 | 89 | MDD2693917.1 HU family DNA-binding protein [Candidatus Altimarinota bacterium] | diamond | 162 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;