contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27247035 | 27247035 | PRJNA951810_P_NODE_93743_length_296_cov_3.502242_g93399_i0 | PRJNA951810 | 93743 | 296 | 3.502242 | 10.36663632 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 191 | 7.35e-60 | NR | MDO4874256.1 | 2044595 | g93399 | i0 | 100 | 0.993243243243243 | 98 | 0 | 99.3 | 0 | 296 | 3 | 45 | 142 | MDO4874256.1 ribosome recycling factor [Candidatus Altimarinota bacterium] | diamond | 294 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27594583 | 27594583 | PRJNA951810_P_NODE_57104_length_310_cov_4.037975_g56761_i0 | PRJNA951810 | 57104 | 310 | 4.037975 | 12.5177225 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 65.5 | 8.42e-10 | NR | NDK07627.1 | 2044595 | g56761 | i0 | 57.1 | 0.474193548387097 | 49 | 21 | 47.4 | 0 | 148 | 2 | 18 | 66 | NDK07627.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 147 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29267571 | 29267571 | PRJNA951810_P_NODE_147309_length_260_cov_3.021390_g146964_i0 | PRJNA951810 | 147309 | 260 | 3.02139 | 7.855614 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 44.3 | 0.0112 | NR | MBP9779826.1 | 2044595 | g146964 | i0 | 41.8 | 1.32692307692308 | 55 | 26 | 56.5 | 2 | 255 | 109 | 187 | 241 | MBP9779826.1 SIMPL domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 345 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29652849 | 29652849 | PRJNA951810_P_NODE_193950_length_206_cov_9.902256_g193605_i0 | PRJNA951810 | 193950 | 206 | 9.902256 | 20.39864736 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 4.75e-10 | NR | MBS9784038.1 | 2044595 | g193605 | i0 | 41.2 | 4.57281553398058 | 68 | 40 | 99 | 0 | 206 | 3 | 124 | 191 | MBS9784038.1 30S ribosomal protein S5 [Candidatus Altimarinota bacterium] | diamond | 942 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29994303 | 29994303 | PRJNA951810_P_NODE_45871_length_310_cov_6.928270_g45528_i0 | PRJNA951810 | 45871 | 310 | 6.92827 | 21.477637 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 101 | 1.5100000000000001e-22 | NR | MBB1553987.1 | 2044595 | g45528 | i0 | 95.9 | 0.474193548387097 | 49 | 2 | 47.4 | 0 | 309 | 163 | 283 | 331 | MBB1553987.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 147 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30878678 | 30878678 | PRJNA951810_P_NODE_140234_length_265_cov_5.703125_g139889_i0 | PRJNA951810 | 140234 | 265 | 5.703125 | 15.11328125 | Candidatus Gracilibacteria bacterium GN | 2044595 | Bacteria | Bacteria | 171 | 2.8399999999999994e-52 | NR | RAL56426.1 | 1914866 | g139889 | i0 | 95.5 | 0.99622641509434 | 88 | 4 | 99.6 | 0 | 2 | 265 | 15 | 102 | RAL56426.1 dTMP kinase [Candidatus Gracilibacteria bacterium GN02-873] | diamond | 264 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-873 | ||||||
| 31011607 | 31011607 | PRJNA951810_P_NODE_94994_length_295_cov_6.040541_g94650_i0 | PRJNA951810 | 94994 | 295 | 6.040541 | 17.81959595 | Bacteria | 2 | Bacteria | Bacteria | 112 | 3.18e-26 | NR | RKW23813.1 | 2044595 | g94650 | i0 | 81.8 | 1.34237288135593 | 66 | 12 | 67.1 | 0 | 2 | 199 | 688 | 753 | RKW23813.1 MAG: hypothetical protein D8B45_02995 [Candidatus Altimarinota bacterium] | diamond | 396 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32838388 | 32838388 | PRJNA951810_P_NODE_177440_length_235_cov_2.598765_g177095_i0 | PRJNA951810 | 177440 | 235 | 2.598765 | 6.10709775 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 107 | 5.41e-25 | NR | MDO4873983.1 | 2044595 | g177095 | i0 | 98.2 | 0.714893617021277 | 56 | 1 | 71.5 | 0 | 1 | 168 | 551 | 606 | MDO4873983.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Altimarinota bacterium] | diamond | 168 | 107 | 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);;