contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA857143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3395160 | 3395160 | PRJNA857143_S_NODE_85823_length_330_cov_7.077821_g84730_i0 | PRJNA857143 | 85823 | 330 | 7.077821 | 23.3568093 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 106 | 2.35e-18 | NTclustered | gi|1026981961|ref|XM_016752543.1| | 645134 | g84730 | i0 | 94.203 | 0.812121212121212 | 69 | 4 | 21 | 0 | 89 | 157 | 81 | 149 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S30 (SPPG_04300), mRNA | blastn | 268 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 8496021 | 8496021 | PRJNA857143_S_NODE_130207_length_283_cov_1.380952_g129114_i0 | PRJNA857143 | 130207 | 283 | 1.380952 | 3.90809416 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 4.19e-30 | NTclustered | gi|2432156332|ref|XM_053115009.1| | 110093 | g129114 | i0 | 80.402 | 14.1872791519435 | 199 | 32 | 70 | 6 | 85 | 281 | 723 | 530 | Polychytrium aggregatum Manganese/iron superoxide dismutase (BJ171DRAFT_600410), mRNA | blastn | 4015 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13596718 | 13596718 | PRJNA857143_S_NODE_114211_length_298_cov_1.386667_g113118_i0 | PRJNA857143 | 114211 | 298 | 1.386667 | 4.13226766 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 119 | 2.69e-22 | NTclustered | gi|1759156770|ref|XM_031170121.1| | 1806994 | g113118 | i0 | 83.594 | 5.31879194630872 | 128 | 19 | 43 | 2 | 5 | 131 | 2898 | 3024 | Synchytrium microbalum uncharacterized protein (SmJEL517_g04193), partial mRNA | blastn | 1585 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 19970282 | 19970282 | PRJNA857143_S_NODE_186716_length_245_cov_1.784884_g185623_i0 | PRJNA857143 | 186716 | 245 | 1.784884 | 4.3729658 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 3.5499999999999996e-30 | NTclustered | gi|2432131389|ref|XM_053109302.1| | 110093 | g185623 | i0 | 79.091 | 9.15510204081633 | 220 | 38 | 88 | 7 | 20 | 235 | 508 | 723 | Polychytrium aggregatum ribosomal protein S3Ae (BJ171DRAFT_487525), mRNA | blastn | 2243 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19970380 | 19970380 | PRJNA857143_S_NODE_195836_length_241_cov_2.321429_g194743_i0 | PRJNA857143 | 195836 | 241 | 2.321429 | 5.59464389 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 187 | 5.699999999999998e-43 | NTclustered | gi|1759155512|ref|XM_031169934.1| | 1806994 | g194743 | i0 | 84.656 | 18.7385892116183 | 189 | 27 | 78 | 2 | 1 | 188 | 785 | 972 | Synchytrium microbalum uncharacterized protein (SmJEL517_g04006), partial mRNA | blastn | 4516 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 22521059 | 22521059 | PRJNA857143_S_NODE_70098_length_354_cov_3.402135_g69005_i0 | PRJNA857143 | 70098 | 354 | 3.402135 | 12.0435579 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 89.8 | 2.55e-13 | NTclustered | gi|2432164996|ref|XM_053112147.1| | 110093 | g69005 | i0 | 80.315 | 14.9632768361582 | 127 | 17 | 34 | 4 | 166 | 285 | 282 | 407 | Polychytrium aggregatum 60S acidic ribosomal protein P2 (BJ171DRAFT_517561), mRNA | blastn | 5297 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23796731 | 23796731 | PRJNA857143_S_NODE_91439_length_323_cov_2.708000_g90346_i0 | PRJNA857143 | 91439 | 323 | 2.708 | 8.74684 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 86.1 | 2.99e-12 | NTclustered | gi|2432129762|ref|XM_053108984.1| | 110093 | g90346 | i0 | 78.082 | 0.452012383900929 | 146 | 24 | 44 | 7 | 1 | 142 | 193 | 334 | Polychytrium aggregatum 60S ribosomal protein L37 (BJ171DRAFT_484391), mRNA | blastn | 146 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 25069808 | 25069808 | PRJNA857143_S_NODE_188460_length_244_cov_20.912281_g187367_i0 | PRJNA857143 | 188460 | 244 | 20.912281 | 51.02596564 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 195 | 3.46e-45 | NTclustered | gi|2432064921|ref|XM_053069781.1| | 1396493 | g187367 | i0 | 93.182 | 55.9918032786885 | 132 | 9 | 54 | 0 | 1 | 132 | 1450 | 1581 | Fimicolochytrium jonesii tubulin, alpha, ubiquitous (EV422DRAFT_521958), mRNA | blastn | 13662 | 195 | 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);;