contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3835165 | 3835165 | PRJDB3785_S_NODE_8564_length_257_cov_3.485577_g8411_i0 | PRJDB3785 | 8564 | 257 | 3.485577 | 8.95793289 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 150 | 8.06e-32 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g8411 | i0 | 80.303 | 52.408560311284 | 198 | 39 | 77 | 0 | 55 | 252 | 696 | 499 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 13469 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 8935845 | 8935845 | PRJDB3785_S_NODE_28268_length_152_cov_2.446602_g28115_i0 | PRJDB3785 | 28268 | 152 | 2.446602 | 3.71883504 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 137 | 3.34e-28 | NTclustered | gi|1027028346|ref|XM_016756817.1| | 645134 | g28115 | i0 | 83.007 | 4.90131578947368 | 153 | 24 | 100 | 2 | 1 | 152 | 1683 | 1532 | Spizellomyces punctatus DAOM BR117 ADP,ATP carrier protein 1, mitochondrial, variant (SPPG_08669), partial mRNA | blastn | 745 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 14036824 | 14036824 | PRJDB3785_S_NODE_17892_length_186_cov_1.489051_g17739_i0 | PRJDB3785 | 17892 | 186 | 1.489051 | 2.76963486 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 130 | 7.14e-26 | NTclustered | gi|2432164628|ref|XM_053113621.1| | 110093 | g17739 | i0 | 89.32 | 11.2688172043011 | 103 | 11 | 55 | 0 | 33 | 135 | 1219 | 1117 | Polychytrium aggregatum Adenosylhomocysteinase (BJ171DRAFT_570225), mRNA | blastn | 2096 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22960876 | 22960876 | PRJDB3785_S_NODE_5719_length_315_cov_2.203008_g5566_i0 | PRJDB3785 | 5719 | 315 | 2.203008 | 6.9394752 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 243 | 1.6300000000000004e-59 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g5566 | i0 | 80.952 | 29.3619047619048 | 315 | 53 | 98 | 5 | 1 | 310 | 642 | 954 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 9249 | 243 | 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);;