contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2301090 | 2301090 | PRJNA1120060_P_NODE_1771882_length_282_cov_1.516746_g1753871_i0 | PRJNA1120060 | 1771882 | 282 | 1.516746 | 4.27722372 | Batrachochytrium | 100474 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|2897832943|gb|CP161923.1| | 109871 | g1753871 | i0 | 100 | 0.198581560283688 | 28 | 0 | 10 | 0 | 170 | 197 | 684764 | 684737 | Batrachochytrium dendrobatidis strain JEL423 chromosome 1 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 2302608 | 2302608 | PRJNA1120060_P_NODE_721342_length_330_cov_4.700389_g703507_i0 | PRJNA1120060 | 721342 | 330 | 4.700389 | 15.5112837 | Opisthokonta | 33154 | Fungi | Fungi | 52.8 | 0.031 | NTclustered | gi|30315032|gb|AF500785.1| | 73868 | g703507 | i0 | 100 | 0.16969696969697 | 28 | 0 | 8 | 0 | 187 | 214 | 727 | 700 | Piromyces sp. E2 clone lambda11 beta-glucosidase Cel1D gene, partial cds | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. E2 | |
| 15053534 | 15053534 | PRJNA1120060_P_NODE_2014232_length_272_cov_2.035176_g1996199_i0 | PRJNA1120060 | 2014232 | 272 | 2.035176 | 5.53567872 | Spizellomyces | 4815 | Fungi | Fungi | 213 | 1.08e-50 | NTclustered | gi|15147293|ref|NC_003052.1| | 109760 | g1996199 | i0 | 91.083 | 28.8860294117647 | 157 | 14 | 58 | 0 | 5 | 161 | 2048 | 1892 | Spizellomyces punctatus mitochondrion chromosome 1, complete sequence | blastn | 7857 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 20644240 | 20644240 | PRJNA1120060_P_NODE_1805877_length_280_cov_4.270531_g1787863_i0 | PRJNA1120060 | 1805877 | 280 | 4.270531 | 11.9574868 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|2897835648|gb|CP161925.1| | 109871 | g1787863 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 46 | 73 | 614888 | 614915 | Batrachochytrium dendrobatidis strain JEL423 chromosome 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 20652598 | 20652598 | PRJNA1120060_P_NODE_2429217_length_256_cov_2.989071_g2411148_i0 | PRJNA1120060 | 2429217 | 256 | 2.989071 | 7.65202176 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2432113532|ref|XM_053073129.1| | 1396493 | g2411148 | i0 | 100 | 0.11328125 | 29 | 0 | 11 | 0 | 36 | 64 | 414 | 386 | Fimicolochytrium jonesii uncharacterized protein (EV422DRAFT_572470), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;