contig_metadata
11 rows where bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14373658 | 14373658 | PRJNA1237347_P_NODE_517732_length_245_cov_1.790698_g511159_i0 | PRJNA1237347 | 517732 | 245 | 1.790698 | 4.3872101 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 159 | 1.27e-34 | NTclustered | gi|1958035545|gb|CP064978.1| | 2030811 | g511159 | i0 | 80.269 | 8.50204081632653 | 223 | 34 | 90 | 8 | 1 | 221 | 440601 | 440815 | MAG: Candidatus Peregrinibacteria bacterium isolate Fred_18-Q3-R57-64_BAT3C.1_cln chromosome, complete genome | blastn | 2083 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 19469662 | 19469662 | PRJNA1237347_P_NODE_458016_length_256_cov_1.426230_g451443_i0 | PRJNA1237347 | 458016 | 256 | 1.42623 | 3.6511488 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 217 | 7.8e-52 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g451443 | i0 | 86.139 | 1.56640625 | 202 | 27 | 79 | 1 | 20 | 221 | 1016334 | 1016134 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 401 | 217 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27357444 | 27357444 | PRJNA1237347_P_NODE_125043_length_590_cov_1.206963_g118523_i0 | PRJNA1237347 | 125043 | 590 | 1.206963 | 7.1210817 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 52.8 | 2e-4 | NR | MBP9773481.1 | 2735830 | g118523 | i0 | 30.5 | 1.67796610169492 | 118 | 48 | 60 | 2 | 432 | 79 | 24 | 107 | MBP9773481.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Candidatus Peribacteraceae bacterium] | diamond | 990 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27389615 | 27389615 | PRJNA1237347_P_NODE_555123_length_241_cov_0.916667_g548550_i0 | PRJNA1237347 | 555123 | 241 | 0.916667 | 2.20916747 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 72 | 1.78e-12 | NR | MDD5074616.1 | 2735830 | g548550 | i0 | 53.4 | 1.65560165975104 | 73 | 28 | 88.4 | 4 | 214 | 2 | 46 | 114 | MDD5074616.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 399 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27578396 | 27578396 | PRJNA1237347_P_NODE_199144_length_435_cov_1.174033_g192572_i0 | PRJNA1237347 | 199144 | 435 | 1.174033 | 5.10704355 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 49.7 | 0.00104 | NR | MDD5623404.1 | 2735830 | g192572 | i0 | 33.9 | 0.813793103448276 | 118 | 65 | 81.4 | 5 | 13 | 366 | 311 | 415 | MDD5623404.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 354 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27957666 | 27957666 | PRJNA1237347_P_NODE_461345_length_255_cov_1.263736_g454772_i0 | PRJNA1237347 | 461345 | 255 | 1.263736 | 3.2225268 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 73.2 | 1.14e-14 | NR | MDR1945524.1 | 2053688 | g454772 | i0 | 64.5 | 1.47058823529412 | 62 | 22 | 72.9 | 0 | 194 | 9 | 30 | 91 | MDR1945524.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 375 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 28999631 | 28999631 | PRJNA1237347_P_NODE_218328_length_409_cov_2.062500_g211756_i0 | PRJNA1237347 | 218328 | 409 | 2.0625 | 8.435625 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 98.2 | 9.63e-21 | NR | MBI2638869.1 | 2030811 | g211756 | i0 | 42.4 | 3.440097799511 | 118 | 68 | 86.6 | 0 | 390 | 37 | 515 | 632 | MBI2638869.1 CAP domain-containing protein [Candidatus Peregrinibacteria bacterium] | diamond | 1407 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 30041726 | 30041726 | PRJNA1237347_P_NODE_545891_length_242_cov_0.911243_g539318_i0 | PRJNA1237347 | 545891 | 242 | 0.911243 | 2.20520806 | Candidatus Peribacteria bacterium RIFCSPHIGHO2_ | 2053688 | Bacteria | Bacteria | 77 | 3.06e-14 | NR | OGJ56394.1 | 1801914 | g539318 | i0 | 65.5 | 1.38842975206612 | 55 | 19 | 68.2 | 0 | 44 | 208 | 4 | 58 | OGJ56394.1 MAG: hypothetical protein A2706_04150 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35] | diamond | 336 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium RIFCSPHIGHO2_01_FULL_51_35 | |||||
| 30135938 | 30135938 | PRJNA1237347_P_NODE_356972_length_299_cov_2.367257_g350399_i0 | PRJNA1237347 | 356972 | 299 | 2.367257 | 7.07809843 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 80.9 | 2.91e-15 | NR | MBD3330993.1 | 2030811 | g350399 | i0 | 40.4 | 4.88628762541806 | 99 | 59 | 99.3 | 0 | 298 | 2 | 579 | 677 | MBD3330993.1 hypothetical protein [Candidatus Peregrinibacteria bacterium] | diamond | 1461 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 30294749 | 30294749 | PRJNA1237347_P_NODE_410032_length_275_cov_1.905941_g403459_i0 | PRJNA1237347 | 410032 | 275 | 1.905941 | 5.24133775 | Candidatus Peregrinibacteria bacterium GW2 | 2030811 | Bacteria | Bacteria | 62.8 | 3.78e-9 | NR | KKU79456.1 | 1619058 | g403459 | i0 | 53.4 | 0.632727272727273 | 58 | 27 | 63.3 | 0 | 49 | 222 | 1 | 58 | KKU79456.1 MAG: SCP-like protein extracellular, partial [Candidatus Peregrinibacteria bacterium GW2011_GWA2_47_7] | diamond | 174 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium GW2011_GWA2_47_7 | ||||||
| 30578525 | 30578525 | PRJNA1237347_P_NODE_466313_length_253_cov_1.283333_g459740_i0 | PRJNA1237347 | 466313 | 253 | 1.283333 | 3.24683249 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 72 | 3.59e-14 | NR | MDR2411467.1 | 2053688 | g459740 | i0 | 44 | 1.89723320158103 | 84 | 47 | 99.6 | 0 | 2 | 253 | 13 | 96 | MDR2411467.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 480 | 72 | 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);;