contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22973242 | 22973242 | PRJEB14664_P_NODE_5639_length_352_cov_2.160883_g5509_i0 | PRJEB14664 | 5639 | 352 | 2.160883 | 7.60630816 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 175 | 7.22e-49 | NR | NIM89592.1 | 2052149 | g5509 | i0 | 75.2 | 53.8465909090909 | 117 | 29 | 99.7 | 0 | 2 | 352 | 169 | 285 | NIM89592.1 molecular chaperone DnaK [Candidatus Aminicenantes bacterium] | diamond | 18954 | 175 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27444206 | 27444206 | PRJEB14664_P_NODE_14323_length_189_cov_1.428571_g14193_i0 | PRJEB14664 | 14323 | 189 | 1.428571 | 2.69999919 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 60.5 | 9.99e-9 | NR | MFA6272077.1 | 2052139 | g14193 | i0 | 50 | 3.52380952380952 | 58 | 28 | 92.1 | 1 | 176 | 3 | 436 | 492 | MFA6272077.1 lamin tail domain-containing protein [Patescibacteria group bacterium] | diamond | 666 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28801411 | 28801411 | PRJEB14664_P_NODE_6188_length_332_cov_1.976431_g6058_i0 | PRJEB14664 | 6188 | 332 | 1.976431 | 6.56175092 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 54.7 | 6.72e-6 | NR | MFT4569778.1 | 2838779 | g6058 | i0 | 44.2 | 0.759036144578313 | 52 | 29 | 47 | 0 | 83 | 238 | 295 | 346 | MFT4569778.1 cysteine-rich repeat protein [Candidatus Binatia bacterium] | diamond | 252 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28889841 | 28889841 | PRJEB14664_P_NODE_12768_length_204_cov_1.366864_g12638_i0 | PRJEB14664 | 12768 | 204 | 1.366864 | 2.78840256 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.9 | 5.39e-12 | NR | MBI2444271.1 | 2026717 | g12638 | i0 | 58 | 4.41176470588235 | 50 | 20 | 72.1 | 1 | 157 | 11 | 76 | 125 | MBI2444271.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 900 | 69.3 | 0.994227994227994 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 28927863 | 28927863 | PRJEB14664_P_NODE_668_length_1108_cov_2.799627_g607_i0 | PRJEB14664 | 668 | 1108 | 2.799627 | 31.01986716 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 51.6 | 0.00251 | NR | TXG78573.1 | 2099670 | g607 | i0 | 37.8 | 0.200361010830325 | 74 | 46 | 20 | 0 | 852 | 631 | 1 | 74 | TXG78573.1 MAG: hypothetical protein E6Q11_00800 [Candidatus Dojkabacteria bacterium] | diamond | 222 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 29085900 | 29085900 | PRJEB14664_P_NODE_4568_length_405_cov_2.735135_g4439_i0 | PRJEB14664 | 4568 | 405 | 2.735135 | 11.07729675 | Candidatus Azambacteria bacterium RIFCSPHIGHO2_ | 2053511 | Bacteria | Bacteria | 75.1 | 1.15e-12 | NR | OGD25062.1 | 1797301 | g4439 | i0 | 46.4 | 1.25925925925926 | 69 | 36 | 50.4 | 1 | 225 | 22 | 71 | 139 | OGD25062.1 MAG: hypothetical protein A2819_01710 [Candidatus Azambacteria bacterium RIFCSPHIGHO2_01_FULL_40_24] | diamond | 510 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium RIFCSPHIGHO2_01_FULL_40_24 | ||||||
| 30096151 | 30096151 | PRJEB14664_P_NODE_9652_length_248_cov_1.122066_g9522_i0 | PRJEB14664 | 9652 | 248 | 1.122066 | 2.78272368 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 66.2 | 1.02e-10 | NR | HRN71286.1 | 2026804 | g9522 | i0 | 45.7 | 0.846774193548387 | 70 | 38 | 84.7 | 0 | 243 | 34 | 55 | 124 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 210 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 32814293 | 32814293 | PRJEB14664_P_NODE_15500_length_179_cov_1.388889_g15370_i0 | PRJEB14664 | 15500 | 179 | 1.388889 | 2.48611131 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 58.5 | 9.43e-9 | NR | MDE2099847.1 | 2052139 | g15370 | i0 | 47.5 | 0.988826815642458 | 59 | 31 | 98.9 | 0 | 1 | 177 | 19 | 77 | MDE2099847.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 177 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;