contig_metadata
19 rows where bioproject = "PRJNA168635" and tax_phylum = "Candidatus Peregrinibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4191365 | 4191365 | PRJNA168635_P_NODE_10884_length_249_cov_9.060000_g10469_i0 | PRJNA168635 | 10884 | 249 | 9.06 | 22.5594 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 294 | 3.39e-75 | NTclustered | gi|2258829869|gb|CP060224.1| | 2053688 | g10469 | i0 | 90.541 | 164.265060240964 | 222 | 21 | 89 | 0 | 1 | 222 | 787375 | 787596 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-8 chromosome | blastn | 40902 | 294 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 6742491 | 6742491 | PRJNA168635_P_NODE_9706_length_267_cov_5.834862_g9291_i0 | PRJNA168635 | 9706 | 267 | 5.834862 | 15.57908154 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 141 | 5.070000000000001e-29 | NTclustered | gi|2258832001|gb|CP060225.1| | 2053688 | g9291 | i0 | 77.872 | 1.29962546816479 | 235 | 46 | 86 | 4 | 39 | 267 | 626721 | 626487 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome | blastn | 347 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 15667638 | 15667638 | PRJNA168635_P_NODE_9533_length_270_cov_2.018100_g9118_i0 | PRJNA168635 | 9533 | 270 | 2.0181 | 5.44887 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 377 | 3.59e-100 | NTclustered | gi|2874254110|emb|OY970195.1| | 2030811 | g9118 | i0 | 94.309 | 117.962962962963 | 246 | 14 | 91 | 0 | 16 | 261 | 379528 | 379283 | MAG: Candidatus Peregrinibacteria bacterium isolate MFD02416.bin.c.20 genome assembly, chromosome: 1 | blastn | 31850 | 377 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 16941848 | 16941848 | PRJNA168635_P_NODE_31714_length_162_cov_1.725664_g31298_i0 | PRJNA168635 | 31714 | 162 | 1.725664 | 2.79557568 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 117 | 4.71e-22 | NTclustered | gi|2258832001|gb|CP060225.1| | 2053688 | g31298 | i0 | 80.12 | 1.02469135802469 | 166 | 26 | 98 | 4 | 4 | 162 | 626669 | 626504 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome | blastn | 166 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 18216156 | 18216156 | PRJNA168635_P_NODE_19435_length_184_cov_1.970370_g19019_i0 | PRJNA168635 | 19435 | 184 | 1.97037 | 3.6254808 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 193 | 8.86e-45 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g19019 | i0 | 90.541 | 5.55434782608696 | 148 | 11 | 80 | 3 | 1 | 147 | 1195581 | 1195436 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 1022 | 193 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 19490604 | 19490604 | PRJNA168635_P_NODE_34536_length_154_cov_3.828571_g34120_i0 | PRJNA168635 | 34536 | 154 | 3.828571 | 5.89599934 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 154 | 3.37e-33 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g34120 | i0 | 85.065 | 94.7792207792208 | 154 | 19 | 99 | 4 | 1 | 152 | 813268 | 813419 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 14596 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 22041178 | 22041178 | PRJNA168635_P_NODE_28438_length_165_cov_4.422414_g28022_i0 | PRJNA168635 | 28438 | 165 | 4.422414 | 7.2969831 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 71.3 | 3.81e-8 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g28022 | i0 | 100 | 1.71515151515152 | 38 | 0 | 23 | 0 | 127 | 164 | 1195651 | 1195614 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 283 | 71.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 24590680 | 24590680 | PRJNA168635_P_NODE_19200_length_185_cov_1.676471_g18784_i0 | PRJNA168635 | 19200 | 185 | 1.676471 | 3.10147135 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 278 | 2.39e-70 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g18784 | i0 | 96.429 | 10.5027027027027 | 168 | 6 | 91 | 0 | 6 | 173 | 813112 | 812945 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 1943 | 278 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 24590822 | 24590822 | PRJNA168635_P_NODE_28460_length_165_cov_3.801724_g28044_i0 | PRJNA168635 | 28460 | 165 | 3.801724 | 6.2728446 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 185 | 1.3e-42 | NTclustered | gi|1958006436|gb|CP064962.1| | 2030811 | g28044 | i0 | 93.548 | 404.545454545455 | 124 | 8 | 75 | 0 | 42 | 165 | 212180 | 212303 | MAG: Candidatus Peregrinibacteria bacterium isolate Aved_18-Q3-R54-62_BAT3C.344 chromosome, complete genome | blastn | 66750 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 24590883 | 24590883 | PRJNA168635_P_NODE_32760_length_160_cov_3.675676_g32344_i0 | PRJNA168635 | 32760 | 160 | 3.675676 | 5.8810816 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 204 | 3.459999999999999e-48 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g32344 | i0 | 90.385 | 15.9875 | 156 | 14 | 98 | 1 | 5 | 160 | 814142 | 814296 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 2558 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 26725307 | 26725307 | PRJNA168635_P_NODE_11381_length_243_cov_1.257732_g10965_i0 | PRJNA168635 | 11381 | 243 | 1.257732 | 3.05628876 | Candidatus Peregrinibacteria bacterium GW2 | 2030811 | Bacteria | Bacteria | 47 | 5.26e-4 | NR | KKW40451.1 | 1619059 | g10965 | i0 | 55.8 | 0.530864197530864 | 43 | 19 | 53.1 | 0 | 224 | 96 | 6 | 48 | KKW40451.1 MAG: hypothetical protein UY90_C0081G0010 [Candidatus Peregrinibacteria bacterium GW2011_GWA2_54_9] | diamond | 129 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium GW2011_GWA2_54_9 | ||||||
| 26775408 | 26775408 | PRJNA168635_P_NODE_28221_length_166_cov_0.888889_g27805_i0 | PRJNA168635 | 28221 | 166 | 0.888889 | 1.47555574 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 2.89e-17 | NR | MFH0769777.1 | 2030811 | g27805 | i0 | 75.5 | 2.87349397590361 | 53 | 13 | 95.8 | 0 | 166 | 8 | 374 | 426 | MFH0769777.1 aspartate--tRNA ligase [Candidatus Peregrinibacteria bacterium] | diamond | 477 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 26852657 | 26852657 | PRJNA168635_P_NODE_19461_length_184_cov_1.533333_g19045_i0 | PRJNA168635 | 19461 | 184 | 1.533333 | 2.82133272 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 63.9 | 3.55e-10 | NR | NOS67372.1 | 2735830 | g19045 | i0 | 54.2 | 0.782608695652174 | 48 | 22 | 78.3 | 0 | 146 | 3 | 134 | 181 | NOS67372.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 144 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 29158322 | 29158322 | PRJNA168635_P_NODE_27649_length_166_cov_2.760684_g27233_i0 | PRJNA168635 | 27649 | 166 | 2.760684 | 4.58273544 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 59.7 | 5.75e-9 | NR | MBI5156003.1 | 2030811 | g27233 | i0 | 67.3 | 0.885542168674699 | 49 | 16 | 88.6 | 0 | 2 | 148 | 131 | 179 | MBI5156003.1 30S ribosomal protein S5 [Candidatus Peregrinibacteria bacterium] | diamond | 147 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 29442030 | 29442030 | PRJNA168635_P_NODE_27670_length_166_cov_2.478632_g27254_i0 | PRJNA168635 | 27670 | 166 | 2.478632 | 4.11452912 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 51.2 | 1.17e-5 | NR | MCK5019173.1 | 2735830 | g27254 | i0 | 47.3 | 0.993975903614458 | 55 | 28 | 99.4 | 1 | 166 | 2 | 51 | 104 | MCK5019173.1 ATP-grasp domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 165 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 30358756 | 30358756 | PRJNA168635_P_NODE_30172_length_164_cov_0.904348_g29756_i0 | PRJNA168635 | 30172 | 164 | 0.904348 | 1.48313072 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 72 | 6e-13 | NR | MCK5017875.1 | 2735830 | g29756 | i0 | 59.3 | 0.98780487804878 | 54 | 22 | 98.8 | 0 | 1 | 162 | 441 | 494 | MCK5017875.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 162 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 30674114 | 30674114 | PRJNA168635_P_NODE_24813_length_169_cov_4.166667_g24397_i0 | PRJNA168635 | 24813 | 169 | 4.166667 | 7.04166723 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 85.5 | 3.29e-20 | NR | MCB9807114.1 | 2053688 | g24397 | i0 | 80 | 1.97041420118343 | 55 | 10 | 95.9 | 1 | 164 | 3 | 1 | 55 | MCB9807114.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 333 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 32160524 | 32160524 | PRJNA168635_P_NODE_32878_length_160_cov_2.423423_g32462_i0 | PRJNA168635 | 32878 | 160 | 2.423423 | 3.8774768 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 61.6 | 2.65e-9 | NR | MEQ1848962.1 | 2735830 | g32462 | i0 | 49.1 | 0.99375 | 53 | 27 | 99.4 | 0 | 1 | 159 | 47 | 99 | MEQ1848962.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 159 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 32540265 | 32540265 | PRJNA168635_P_NODE_24919_length_169_cov_2.533333_g24503_i0 | PRJNA168635 | 24919 | 169 | 2.533333 | 4.28133277 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 60.1 | 6.44e-9 | NR | MSR67662.1 | 2053688 | g24503 | i0 | 55.1 | 0.869822485207101 | 49 | 22 | 87 | 0 | 150 | 4 | 195 | 243 | MSR67662.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 147 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria 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);;