contig_metadata
17 rows where bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8017601 | 8017601 | PRJNA168635_P_NODE_10827_length_250_cov_4.393035_g10412_i0 | PRJNA168635 | 10827 | 250 | 4.393035 | 10.9825875 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 374 | 4.2499999999999986e-99 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g10412 | i0 | 94.262 | 62.556 | 244 | 14 | 98 | 0 | 4 | 247 | 1250259 | 1250502 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 15639 | 374 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 8017782 | 8017782 | PRJNA168635_P_NODE_2007_length_571_cov_11.099617_g1641_i0 | PRJNA168635 | 2007 | 571 | 11.099617 | 63.37881307 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 593 | 7.459999999999998e-165 | NTclustered | gi|2621785933|emb|OY782391.1| | 2044595 | g1641 | i0 | 85.664 | 134.234676007005 | 572 | 72 | 99 | 10 | 3 | 571 | 138840 | 139404 | MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1 | blastn | 76648 | 593 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 8706939 | 8706939 | PRJNA168635_P_NODE_1567_length_636_cov_7.419080_g1219_i0 | PRJNA168635 | 1567 | 636 | 7.41908 | 47.1853488 | Bacteria | 2 | Bacteria | Bacteria | 551 | 5.1099999999999984e-152 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g1219 | i0 | 82.759 | 384.506289308176 | 638 | 91 | 99 | 12 | 2 | 636 | 1250751 | 1251372 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 244546 | 556 | 0.991007194244604 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 9292410 | 9292410 | PRJNA168635_P_NODE_1408_length_664_cov_16.905691_g1079_i0 | PRJNA168635 | 1408 | 664 | 16.905691 | 112.25378824 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 713 | 0 | NTclustered | gi|2621785933|emb|OY782391.1| | 2044595 | g1079 | i0 | 86.398 | 220.899096385542 | 669 | 71 | 99 | 16 | 3 | 664 | 138850 | 138195 | MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1 | blastn | 146677 | 713 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 10568652 | 10568652 | PRJNA168635_P_NODE_30369_length_163_cov_5.070175_g29953_i0 | PRJNA168635 | 30369 | 163 | 5.070175 | 8.26438525 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 154 | 3.62e-33 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g29953 | i0 | 86.301 | 4.41717791411043 | 146 | 14 | 87 | 5 | 17 | 157 | 1250525 | 1250381 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 720 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 13807672 | 13807672 | PRJNA168635_P_NODE_27891_length_166_cov_1.076923_g27475_i0 | PRJNA168635 | 27891 | 166 | 1.076923 | 1.78769218 | Bacteria | 2 | Bacteria | Bacteria | 231 | 1.6599999999999998e-56 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g27475 | i0 | 92.073 | 63.5060240963855 | 164 | 13 | 99 | 0 | 3 | 166 | 890440 | 890603 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 10542 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 14393556 | 14393556 | PRJNA168635_P_NODE_20172_length_182_cov_0.962406_g19756_i0 | PRJNA168635 | 20172 | 182 | 0.962406 | 1.75157892 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 228 | 2.4e-55 | NTclustered | gi|2621785413|emb|OY781871.1| | 2044595 | g19756 | i0 | 89.189 | 188.527472527473 | 185 | 16 | 99 | 2 | 2 | 182 | 376033 | 376217 | MAG: Candidatus Gracilibacteria bacterium isolate aa87c5ac-7a06-4bd6-af26-82c4354fe085 genome assembly, chromosome: 1 | blastn | 34312 | 228 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 15667603 | 15667603 | PRJNA168635_P_NODE_7973_length_299_cov_3.244000_g7559_i0 | PRJNA168635 | 7973 | 299 | 3.244 | 9.69956 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 99 | 3.52e-16 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g7559 | i0 | 81.897 | 2.74247491638796 | 116 | 21 | 39 | 0 | 184 | 299 | 1250696 | 1250811 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 820 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 16941876 | 16941876 | PRJNA168635_P_NODE_33254_length_158_cov_5.082569_g32838_i0 | PRJNA168635 | 33254 | 158 | 5.082569 | 8.03045902 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 108 | 2.75e-19 | NTclustered | gi|2621704339|emb|OY760935.1| | 2044595 | g32838 | i0 | 84.071 | 1.40506329113924 | 113 | 17 | 71 | 1 | 39 | 150 | 1136363 | 1136251 | MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1 | blastn | 222 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 16941937 | 16941937 | PRJNA168635_P_NODE_4134_length_412_cov_4.060606_g3733_i0 | PRJNA168635 | 4134 | 412 | 4.060606 | 16.72969672 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 331 | 4.5400000000000004e-86 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g3733 | i0 | 82.398 | 223.385922330097 | 392 | 58 | 94 | 8 | 1 | 389 | 1251029 | 1250646 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 92035 | 331 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 23316605 | 23316605 | PRJNA168635_P_NODE_23919_length_171_cov_13.614754_g23503_i0 | PRJNA168635 | 23919 | 171 | 13.614754 | 23.28122934 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 254 | 3.66e-63 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g23503 | i0 | 94.512 | 346.450292397661 | 164 | 9 | 96 | 0 | 2 | 165 | 892376 | 892213 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 59243 | 254 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 23316834 | 23316834 | PRJNA168635_P_NODE_6119_length_342_cov_3.501706_g5709_i0 | PRJNA168635 | 6119 | 342 | 3.501706 | 11.97583452 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 139 | 2.41e-28 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g5709 | i0 | 91.919 | 45.4824561403509 | 99 | 8 | 29 | 0 | 48 | 146 | 1251999 | 1251901 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 15555 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 24006376 | 24006376 | PRJNA168635_P_NODE_9719_length_267_cov_2.353211_g9304_i0 | PRJNA168635 | 9719 | 267 | 2.353211 | 6.28307337 | Bacteria | 2 | Bacteria | Bacteria | 307 | 4.7200000000000006e-79 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g9304 | i0 | 87.454 | 486.247191011236 | 271 | 28 | 100 | 5 | 1 | 267 | 1251033 | 1251301 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 129828 | 307 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 24590901 | 24590901 | PRJNA168635_P_NODE_33820_length_156_cov_6.757009_g33404_i0 | PRJNA168635 | 33820 | 156 | 6.757009 | 10.54093404 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 148 | 1.5899999999999998e-31 | NTclustered | gi|2621785933|emb|OY782391.1| | 2044595 | g33404 | i0 | 83.974 | 143.423076923077 | 156 | 23 | 99 | 2 | 1 | 155 | 136630 | 136784 | MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1 | blastn | 22374 | 148 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27168518 | 27168518 | PRJNA168635_P_NODE_22542_length_175_cov_1.563492_g22126_i0 | PRJNA168635 | 22542 | 175 | 1.563492 | 2.736111 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 42 | 0.0288 | NR | MBC7498779.1 | 2044595 | g22126 | i0 | 100 | 0.342857142857143 | 20 | 0 | 34.3 | 0 | 174 | 115 | 339 | 358 | MBC7498779.1 bifunctional (p)ppGpp synthetase/guanosine-3',5'-bis(diphosphate) 3'-pyrophosphohydrolase [Candidatus Altimarinota bacterium] | diamond | 60 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30010880 | 30010880 | PRJNA168635_P_NODE_25011_length_169_cov_1.725000_g24595_i0 | PRJNA168635 | 25011 | 169 | 1.725 | 2.91525 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 95.5 | 8.13e-22 | NR | MFA6080076.1 | 2044595 | g24595 | i0 | 75 | 2.98224852071006 | 56 | 14 | 99.4 | 0 | 168 | 1 | 128 | 183 | MFA6080076.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Altimarinota bacterium] | diamond | 504 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32413571 | 32413571 | PRJNA168635_P_NODE_28319_length_166_cov_0.888889_g27903_i0 | PRJNA168635 | 28319 | 166 | 0.888889 | 1.47555574 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 79.7 | 6.77e-17 | NR | MBP7822784.1 | 2044595 | g27903 | i0 | 72.5 | 1.87951807228916 | 51 | 14 | 92.2 | 0 | 156 | 4 | 62 | 112 | MBP7822784.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 312 | 79.7 | 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);;