contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Harrisoniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17647714 | 17647714 | PRJNA340009_P_NODE_56234_length_174_cov_2.112000_g55927_i0 | PRJNA340009 | 56234 | 174 | 2.112 | 3.67488 | Candidatus Harrisonbacteria bacterium | 2528272 | Bacteria | Bacteria | 107 | 7.99e-26 | NR | MBI3046034.1 | 2528272 | g55927 | i0 | 94.4 | 2.79310344827586 | 54 | 3 | 93.1 | 0 | 163 | 2 | 368 | 421 | MBI3046034.1 exopolysaccharide biosynthesis polyprenyl glycosylphosphotransferase [Candidatus Harrisonbacteria bacterium] | diamond | 486 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium | ||||||
| 27408247 | 27408247 | PRJNA340009_P_NODE_77883_length_160_cov_2.324324_g77576_i0 | PRJNA340009 | 77883 | 160 | 2.324324 | 3.7189184 | Bacteria | 2 | Bacteria | Bacteria | 89.4 | 5.670000000000001e-21 | NR | OGY68208.1 | 1798410 | g77576 | i0 | 94.2 | 1.95 | 52 | 3 | 97.5 | 0 | 3 | 158 | 26 | 77 | OGY68208.1 MAG: transcription elongation factor GreA [Candidatus Harrisonbacteria bacterium RIFCSPLOWO2_02_FULL_45_10c] | diamond | 312 | 90.1 | 0.992230854605993 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium RIFCSPLOWO2_02_FULL_45_10c | ||||||
| 29442875 | 29442875 | PRJNA340009_P_NODE_68670_length_164_cov_1.173913_g68363_i0 | PRJNA340009 | 68670 | 164 | 1.173913 | 1.92521732 | Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_ | 2528272 | Bacteria | Bacteria | 99.8 | 6.749999999999999e-23 | NR | OGY64120.1 | 1798404 | g68363 | i0 | 90.6 | 0.969512195121951 | 53 | 5 | 97 | 0 | 161 | 3 | 152 | 204 | OGY64120.1 MAG: hypothetical protein A3B92_01065 [Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_02_FULL_42_16] | diamond | 159 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_02_FULL_42_16 | ||||||
| 30327981 | 30327981 | PRJNA340009_P_NODE_58312_length_171_cov_3.475410_g58005_i0 | PRJNA340009 | 58312 | 171 | 3.47541 | 5.9429511 | Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_ | 2528272 | Bacteria | Bacteria | 47 | 4.41e-4 | NR | OGY64901.1 | 1798403 | g58005 | i0 | 88 | 0.43859649122807 | 25 | 3 | 43.9 | 0 | 145 | 71 | 160 | 184 | OGY64901.1 MAG: replicative DNA helicase [Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_02_FULL_40_20] | diamond | 75 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium RIFCSPHIGHO2_02_FULL_40_20 | ||||||
| 31876260 | 31876260 | PRJNA340009_P_NODE_61257_length_167_cov_3.593220_g60950_i0 | PRJNA340009 | 61257 | 167 | 3.59322 | 6.0006774 | Candidatus Harrisonbacteria bacterium | 2528272 | Bacteria | Bacteria | 97.1 | 8.499999999999999e-24 | NR | MBI3046607.1 | 2528272 | g60950 | i0 | 85.5 | 0.988023952095808 | 55 | 8 | 98.8 | 0 | 165 | 1 | 36 | 90 | MBI3046607.1 50S ribosomal protein L22 [Candidatus Harrisonbacteria bacterium] | diamond | 165 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium | ||||||
| 32097799 | 32097799 | PRJNA340009_P_NODE_51438_length_181_cov_2.181818_g51131_i0 | PRJNA340009 | 51438 | 181 | 2.181818 | 3.94909058 | Candidatus Harrisonbacteria bacterium CG1 | 2528272 | Bacteria | Bacteria | 69.3 | 3.3e-12 | NR | PIT92581.1 | 1974584 | g51131 | i0 | 62.7 | 2.96685082872928 | 59 | 22 | 97.8 | 0 | 2 | 178 | 12 | 70 | PIT92581.1 MAG: metal ABC transporter permease [Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_17] | diamond | 537 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_17 |
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);;