contig_metadata
17 rows where bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3539409 | 3539409 | PRJEB3181_S_NODE_1643_length_396_cov_191.354571_g1353_i0 | PRJEB3181 | 1643 | 396 | 191.354571 | 757.76410116 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 203 | 1.17e-62 | NR | MDP5038939.1 | 2044595 | g1353 | i0 | 84.7 | 0.893939393939394 | 118 | 18 | 89.4 | 0 | 2 | 355 | 104 | 221 | MDP5038939.1 FAD-dependent oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 354 | 203 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 8983130 | 8983130 | PRJEB3181_S_NODE_11088_length_192_cov_1122.541401_g10795_i0 | PRJEB3181 | 11088 | 192 | 1122.541401 | 2155.27948992 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 66.2 | 4.9e-12 | NR | MDD2745665.1 | 2044595 | g10795 | i0 | 63.8 | 0.734375 | 47 | 17 | 73.4 | 0 | 189 | 49 | 9 | 55 | MDD2745665.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 141 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26684994 | 26684994 | PRJEB3181_S_NODE_15281_length_166_cov_2.419847_g14988_i0 | PRJEB3181 | 15281 | 166 | 2.419847 | 4.01694602 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 67.8 | 1.94e-11 | NR | MDD3719737.1 | 2044595 | g14988 | i0 | 81.1 | 5.34939759036145 | 37 | 7 | 66.9 | 0 | 55 | 165 | 148 | 184 | MDD3719737.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Altimarinota bacterium] | diamond | 888 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26906763 | 26906763 | PRJEB3181_S_NODE_12102_length_185_cov_2.813333_g11809_i0 | PRJEB3181 | 12102 | 185 | 2.813333 | 5.20466605 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 104 | 1.2099999999999999e-24 | NR | MCT4617083.1 | 2044595 | g11809 | i0 | 85.2 | 0.989189189189189 | 61 | 9 | 98.9 | 0 | 184 | 2 | 244 | 304 | MCT4617083.1 GspE/PulE family protein [Candidatus Altimarinota bacterium] | diamond | 183 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27980956 | 27980956 | PRJEB3181_S_NODE_12365_length_183_cov_3.040541_g12072_i0 | PRJEB3181 | 12365 | 183 | 3.040541 | 5.56419003 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 51.6 | 1.27e-5 | NR | MBC7498541.1 | 2044595 | g12072 | i0 | 54.1 | 2.42622950819672 | 37 | 17 | 60.7 | 0 | 183 | 73 | 155 | 191 | MBC7498541.1 glucosaminidase domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 444 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28201702 | 28201702 | PRJEB3181_P_NODE_1286_length_549_cov_5.359073_g1133_i0 | PRJEB3181 | 1286 | 549 | 5.359073 | 29.42131077 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 123 | 4.05e-32 | NR | MDD2745281.1 | 2044595 | g1133 | i0 | 57.7 | 0.60655737704918 | 111 | 47 | 60.7 | 0 | 528 | 196 | 1 | 111 | MDD2745281.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 333 | 123 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28517739 | 28517739 | PRJEB3181_S_NODE_8087_length_221_cov_2.935484_g7794_i0 | PRJEB3181 | 8087 | 221 | 2.935484 | 6.48741964 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 94.4 | 1.37e-20 | NR | NVP18040.1 | 2044595 | g7794 | i0 | 67.1 | 1.98190045248869 | 73 | 24 | 99.1 | 0 | 220 | 2 | 338 | 410 | NVP18040.1 aldehyde dehydrogenase family protein [Candidatus Altimarinota bacterium] | diamond | 438 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28549437 | 28549437 | PRJEB3181_S_NODE_14547_length_170_cov_1.140741_g14254_i0 | PRJEB3181 | 14547 | 170 | 1.140741 | 1.9392597 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 73.6 | 1.87e-13 | NR | MDD5769614.1 | 2044595 | g14254 | i0 | 80.5 | 0.723529411764706 | 41 | 8 | 72.4 | 0 | 39 | 161 | 474 | 514 | MDD5769614.1 DEAD/DEAH box helicase [Candidatus Altimarinota bacterium] | diamond | 123 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29496443 | 29496443 | PRJEB3181_S_NODE_7870_length_224_cov_2.000000_g7577_i0 | PRJEB3181 | 7870 | 224 | 2 | 4.48 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 48.9 | 5.17e-5 | NR | MDD3793229.1 | 2044595 | g7577 | i0 | 58.7 | 1.3125 | 46 | 13 | 53.6 | 1 | 224 | 105 | 84 | 129 | MDD3793229.1 large conductance mechanosensitive channel protein MscL [Candidatus Altimarinota bacterium] | diamond | 294 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29748745 | 29748745 | PRJEB3181_P_NODE_24511_length_163_cov_1.462121_g24246_i0 | PRJEB3181 | 24511 | 163 | 1.462121 | 2.38325723 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 75.5 | 2.33e-15 | NR | MDD2745084.1 | 2044595 | g24246 | i0 | 71.2 | 5.74233128834356 | 52 | 15 | 95.7 | 0 | 5 | 160 | 75 | 126 | MDD2745084.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 936 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30222809 | 30222809 | PRJEB3181_S_NODE_4472_length_282_cov_7.854251_g4179_i0 | PRJEB3181 | 4472 | 282 | 7.854251 | 22.14898782 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 100 | 1e-22 | NR | MCD5383053.1 | 2044595 | g4179 | i0 | 64.7 | 1.4468085106383 | 68 | 24 | 72.3 | 0 | 36 | 239 | 350 | 417 | MCD5383053.1 Glu/Leu/Phe/Val dehydrogenase [Candidatus Altimarinota bacterium] | diamond | 408 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30286490 | 30286490 | PRJEB3181_P_NODE_26652_length_155_cov_2.088710_g26387_i0 | PRJEB3181 | 26652 | 155 | 2.08871 | 3.2375005 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 61.2 | 3.31e-9 | NR | MDD2744996.1 | 2044595 | g26387 | i0 | 62.7 | 0.987096774193548 | 51 | 19 | 98.7 | 0 | 155 | 3 | 230 | 280 | MDD2744996.1 protein translocase subunit SecD [Candidatus Altimarinota bacterium] | diamond | 153 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30696700 | 30696700 | PRJEB3181_S_NODE_16734_length_159_cov_0.967742_g16441_i0 | PRJEB3181 | 16734 | 159 | 0.967742 | 1.53870978 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 68.9 | 1.6e-12 | NR | MDP5038906.1 | 2044595 | g16441 | i0 | 69.2 | 0.981132075471698 | 52 | 16 | 98.1 | 0 | 157 | 2 | 70 | 121 | MDP5038906.1 30S ribosomal protein S3 [Candidatus Altimarinota bacterium] | diamond | 156 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31803156 | 31803156 | PRJEB3181_P_NODE_26817_length_154_cov_8.292683_g26552_i0 | PRJEB3181 | 26817 | 154 | 8.292683 | 12.77073182 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 55.8 | 3.39e-8 | NR | MDD2745665.1 | 2044595 | g26552 | i0 | 63.2 | 3.52597402597403 | 38 | 14 | 74 | 0 | 2 | 115 | 3 | 40 | MDD2745665.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 543 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32056382 | 32056382 | PRJEB3181_S_NODE_6358_length_245_cov_5.771429_g6065_i0 | PRJEB3181 | 6358 | 245 | 5.771429 | 14.14000105 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 112 | 1.1000000000000002e-28 | NR | MDD5769335.1 | 2044595 | g6065 | i0 | 80.6 | 0.820408163265306 | 67 | 13 | 82 | 0 | 244 | 44 | 105 | 171 | MDD5769335.1 S24 family peptidase [Candidatus Altimarinota bacterium] | diamond | 201 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32372989 | 32372989 | PRJEB3181_S_NODE_5099_length_267_cov_1.603448_g4806_i0 | PRJEB3181 | 5099 | 267 | 1.603448 | 4.28120616 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 67.8 | 7.65e-11 | NR | MDA9129071.1 | 2044595 | g4806 | i0 | 54.7 | 1.47191011235955 | 64 | 28 | 71.9 | 1 | 204 | 13 | 75 | 137 | MDA9129071.1 ferredoxin [Candidatus Altimarinota bacterium] | diamond | 393 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32720160 | 32720160 | PRJEB3181_S_NODE_4880_length_272_cov_2.987342_g4587_i0 | PRJEB3181 | 4880 | 272 | 2.987342 | 8.12557024 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 99 | 1.27e-22 | NR | MDD3302104.1 | 2044595 | g4587 | i0 | 57.8 | 0.992647058823529 | 90 | 36 | 99.3 | 1 | 2 | 271 | 78 | 165 | MDD3302104.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 270 | 99 | 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);;