contig_metadata
11 rows where bioproject = "PRJNA630877" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26859714 | 26859714 | PRJNA630877_S_NODE_123221_length_186_cov_1.213793_g104084_i0 | PRJNA630877 | 123221 | 186 | 1.213793 | 2.25765498 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42.7 | 0.0166 | NR | MCE2396221.1 | 2026781 | g104084 | i0 | 41.3 | 0.741935483870968 | 46 | 24 | 74.2 | 1 | 32 | 169 | 59 | 101 | MCE2396221.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 138 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 26985842 | 26985842 | PRJNA630877_S_NODE_134702_length_172_cov_1.725191_g115565_i0 | PRJNA630877 | 134702 | 172 | 1.725191 | 2.96732852 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 42.4 | 0.0202 | NR | MBM3206904.1 | 2053617 | g115565 | i0 | 56.7 | 0.523255813953488 | 30 | 13 | 52.3 | 0 | 2 | 91 | 657 | 686 | MBM3206904.1 reverse transcriptase family protein [Candidatus Staskawiczbacteria bacterium] | diamond | 90 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29039023 | 29039023 | PRJNA630877_S_NODE_140208_length_167_cov_1.047619_g121071_i0 | PRJNA630877 | 140208 | 167 | 1.047619 | 1.74952373 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 42.7 | 0.0135 | NR | MBM3206904.1 | 2053617 | g121071 | i0 | 45.7 | 1.65269461077844 | 46 | 25 | 82.6 | 0 | 140 | 3 | 546 | 591 | MBM3206904.1 reverse transcriptase family protein [Candidatus Staskawiczbacteria bacterium] | diamond | 276 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29070539 | 29070539 | PRJNA630877_S_NODE_55028_length_497_cov_3.429825_g36056_i0 | PRJNA630877 | 55028 | 497 | 3.429825 | 17.04623025 | Candidatus Schekmanbacteria bacterium | 2419984 | Bacteria | Bacteria | 46.6 | 0.0203 | NR | MBI2571269.1 | 2419984 | g36056 | i0 | 34.1 | 0.494969818913481 | 82 | 48 | 46.5 | 4 | 204 | 434 | 334 | 414 | MBI2571269.1 penicillin acylase family protein [Candidatus Schekmanbacteria bacterium] | diamond | 246 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium | ||||||
| 29417536 | 29417536 | PRJNA630877_S_NODE_120429_length_189_cov_2.844595_g101292_i0 | PRJNA630877 | 120429 | 189 | 2.844595 | 5.37628455 | Microgenomates group bacterium Gr | 2461418 | Bacteria | Bacteria | 40.8 | 0.0473 | NR | TSC86700.1 | 2017209 | g101292 | i0 | 45.5 | 0.523809523809524 | 33 | 18 | 52.4 | 0 | 61 | 159 | 43 | 75 | TSC86700.1 MAG: hypothetical protein G01um10147_781 [Microgenomates group bacterium Gr01-1014_7] | diamond | 99 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Microgenomates group bacterium Gr01-1014_7 | |||||||
| 30017773 | 30017773 | PRJNA630877_S_NODE_11111_length_2081_cov_3.575980_g6049_i0 | PRJNA630877 | 11111 | 2081 | 3.57598 | 74.4161438 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 452 | 2.26e-146 | NR | MBM3206904.1 | 2053617 | g6049 | i0 | 45.9 | 2.03123498318116 | 481 | 258 | 69.1 | 2 | 2052 | 616 | 205 | 685 | MBM3206904.1 reverse transcriptase family protein [Candidatus Staskawiczbacteria bacterium] | diamond | 4227 | 452 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 30365628 | 30365628 | PRJNA630877_S_NODE_88552_length_260_cov_1.990868_g69415_i0 | PRJNA630877 | 88552 | 260 | 1.990868 | 5.1762568 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 42.7 | 0.0471 | NR | HDQ99135.1 | 2052148 | g69415 | i0 | 34.4 | 0.703846153846154 | 61 | 32 | 61.2 | 2 | 169 | 11 | 1075 | 1135 | HDQ99135.1 hypothetical protein [candidate division WOR-3 bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 30397293 | 30397293 | PRJNA630877_S_NODE_31793_length_989_cov_7.138186_g17784_i0 | PRJNA630877 | 31793 | 989 | 7.138186 | 70.59665954 | Candidatus Peregrinibacteria bacterium CG_4_1 | 2030811 | Bacteria | Bacteria | 45.4 | 0.0348 | NR | PIZ71564.1 | 1974776 | g17784 | i0 | 35.7 | 0.127401415571284 | 42 | 27 | 12.7 | 0 | 516 | 641 | 40 | 81 | PIZ71564.1 MAG: hypothetical protein COY07_04700, partial [Candidatus Peregrinibacteria bacterium CG_4_10_14_0_2_um_filter_43_11] | diamond | 126 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium CG_4_10_14_0_2_um_filter_43_11 | ||||||
| 31882430 | 31882430 | PRJNA630877_S_NODE_105537_length_215_cov_1.511494_g86400_i0 | PRJNA630877 | 105537 | 215 | 1.511494 | 3.2497121 | Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_ | 2750077 | Bacteria | Bacteria | 42.7 | 0.0252 | NR | OGZ12613.1 | 1798663 | g86400 | i0 | 39.3 | 0.851162790697674 | 61 | 31 | 83.7 | 2 | 29 | 208 | 239 | 294 | OGZ12613.1 MAG: hypothetical protein A3D67_04380 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22] | diamond | 183 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Lloydiibacteriota | Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_51_22 | ||||||
| 32325875 | 32325875 | PRJNA630877_S_NODE_108799_length_208_cov_2.838323_g89662_i0 | PRJNA630877 | 108799 | 208 | 2.838323 | 5.90371184 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 42 | 0.0452 | NR | MCX5922327.1 | 2030827 | g89662 | i0 | 50 | 0.519230769230769 | 36 | 18 | 51.9 | 0 | 148 | 41 | 472 | 507 | MCX5922327.1 hypothetical protein [Candidatus Dependentiae bacterium] | diamond | 108 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 32452343 | 32452343 | PRJNA630877_S_NODE_85699_length_270_cov_2.126638_g66562_i0 | PRJNA630877 | 85699 | 270 | 2.126638 | 5.7419226 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 92 | 2.34e-19 | NR | MBM3206904.1 | 2053617 | g66562 | i0 | 48.2 | 0.944444444444444 | 85 | 44 | 94.4 | 0 | 257 | 3 | 401 | 485 | MBM3206904.1 reverse transcriptase family protein [Candidatus Staskawiczbacteria bacterium] | diamond | 255 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria 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);;