contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26835850 | 26835850 | PRJNA951412_P_NODE_3981_length_253_cov_2.577778_g3896_i0 | PRJNA951412 | 3981 | 253 | 2.577778 | 6.52177834 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 58.2 | 7.01e-9 | NR | MCK9417194.1 | 2099670 | g3896 | i0 | 46.6 | 0.687747035573123 | 58 | 31 | 68.8 | 0 | 253 | 80 | 16 | 73 | MCK9417194.1 hypothetical protein [Candidatus Dojkabacteria bacterium] | diamond | 174 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 29330825 | 29330825 | PRJNA951412_P_NODE_7109_length_244_cov_0.906433_g7024_i0 | PRJNA951412 | 7109 | 244 | 0.906433 | 2.21169652 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 75.5 | 1.12e-13 | NR | HRN96292.1 | 2052151 | g7024 | i0 | 53.6 | 1.0327868852459 | 84 | 36 | 99.6 | 1 | 243 | 1 | 491 | 574 | HRN96292.1 O-antigen ligase family protein [Candidatus Levyibacteriota bacterium] | diamond | 252 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 31763955 | 31763955 | PRJNA951412_P_NODE_6457_length_246_cov_0.890173_g6372_i0 | PRJNA951412 | 6457 | 246 | 0.890173 | 2.18982558 | Candidatus Wallbacteria bacterium | 2053640 | Bacteria | Bacteria | 75.1 | 1.61e-13 | NR | MEZ7892459.1 | 2053640 | g6372 | i0 | 43.2 | 1.92682926829268 | 81 | 46 | 98.8 | 0 | 243 | 1 | 874 | 954 | MEZ7892459.1 NAD-glutamate dehydrogenase [Candidatus Wallbacteria bacterium] | diamond | 474 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Walliibacteriota | Candidatus Wallbacteria bacterium | ||||||
| 32112012 | 32112012 | PRJNA951412_P_NODE_6758_length_245_cov_0.901163_g6673_i0 | PRJNA951412 | 6758 | 245 | 0.901163 | 2.20784935 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 86.7 | 1.33e-17 | NR | MEA2056621.1 | 2052139 | g6673 | i0 | 53.7 | 1.00408163265306 | 82 | 33 | 94.3 | 3 | 235 | 5 | 585 | 666 | MEA2056621.1 ribonucleoside-diphosphate reductase [Patescibacteria group bacterium] | diamond | 246 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32901233 | 32901233 | PRJNA951412_P_NODE_6620_length_245_cov_0.906977_g6535_i0 | PRJNA951412 | 6620 | 245 | 0.906977 | 2.22209365 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 66.2 | 2e-10 | NR | MBA3751283.1 | 2030827 | g6535 | i0 | 43.1 | 0.881632653061225 | 72 | 41 | 88.2 | 0 | 5 | 220 | 57 | 128 | MBA3751283.1 BatD family protein [Candidatus Dependentiae bacterium] | diamond | 216 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota 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);;