contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA940501" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 918210 | 918210 | PRJNA940501_S_NODE_15461_length_395_cov_1.622159_g14647_i0 | PRJNA940501 | 15461 | 395 | 1.622159 | 6.40752805 | Synchytrium sp. | 1971732 | Fungi | Fungi | 93.5 | 2.23e-14 | NTclustered | gi|1168020523|gb|KY800404.1| | 1971732 | g14647 | i0 | 83.168 | 0.255696202531646 | 101 | 17 | 26 | 0 | 54 | 154 | 1006 | 906 | Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence | blastn | 101 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium sp. | |
| 1258417 | 1258417 | PRJNA940501_S_NODE_76681_length_255_cov_3.419811_g75863_i0 | PRJNA940501 | 76681 | 255 | 3.419811 | 8.72051805 | Gaertneriomyces | 109896 | Fungi | Fungi | 472 | 1.5e-128 | NTclustered | gi|1866582441|gb|MT730616.1| | 109897 | g75863 | i0 | 100 | 97.7058823529412 | 255 | 0 | 100 | 0 | 1 | 255 | 2771 | 2517 | Gaertneriomyces semiglobifer isolate ARG094 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24915 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 3471473 | 3471473 | PRJNA940501_S_NODE_328803_length_161_cov_2.228814_g327985_i0 | PRJNA940501 | 328803 | 161 | 2.228814 | 3.58839054 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 121 | 3.62e-23 | NTclustered | gi|1026990807|ref|XM_016753365.1| | 645134 | g327985 | i0 | 94.805 | 40.7701863354037 | 77 | 4 | 48 | 0 | 1 | 77 | 1402 | 1478 | Spizellomyces punctatus DAOM BR117 tubulin alpha chain (SPPG_05136), mRNA | blastn | 6564 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 4749034 | 4749034 | PRJNA940501_S_NODE_32784_length_317_cov_1.916058_g31966_i0 | PRJNA940501 | 32784 | 317 | 1.916058 | 6.07390386 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 60.2 | 1.77e-4 | NTclustered | gi|1026975669|ref|XM_016751979.1| | 645134 | g31966 | i0 | 100 | 0.100946372239748 | 32 | 0 | 10 | 0 | 27 | 58 | 812 | 843 | Spizellomyces punctatus DAOM BR117 uncharacterized protein (SPPG_03729), mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 12401220 | 12401220 | PRJNA940501_S_NODE_80670_length_252_cov_1.803828_g79852_i0 | PRJNA940501 | 80670 | 252 | 1.803828 | 4.54564656 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 106 | 1.73e-18 | NTclustered | gi|1026981961|ref|XM_016752543.1| | 645134 | g79852 | i0 | 94.203 | 0.273809523809524 | 69 | 4 | 27 | 0 | 61 | 129 | 81 | 149 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S30 (SPPG_04300), mRNA | blastn | 69 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 15285891 | 15285891 | PRJNA940501_S_NODE_293412_length_168_cov_6.072000_g292594_i0 | PRJNA940501 | 293412 | 168 | 6.072 | 10.20096 | Eukaryota | 2759 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|82398658|gb|DQ273838.1| | 109929 | g292594 | i0 | 75 | 1.73809523809524 | 128 | 29 | 75 | 3 | 43 | 168 | 3057 | 3183 | Podochytrium dentatum isolate AFTOL-ID 1539 28S ribosomal RNA gene, partial sequence | blastn | 292 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Podochytrium | Podochytrium dentatum | |
| 21319987 | 21319987 | PRJNA940501_S_NODE_128457_length_221_cov_5.106742_g127639_i0 | PRJNA940501 | 128457 | 221 | 5.106742 | 11.28589982 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 143 | 1.13e-29 | NTclustered | gi|2432095815|ref|XM_053071167.1| | 1396493 | g127639 | i0 | 78.605 | 3.03619909502262 | 215 | 46 | 97 | 0 | 1 | 215 | 352 | 566 | Fimicolochytrium jonesii putative 40S ribosomal protein RPS14 (EV422DRAFT_540950), mRNA | blastn | 671 | 143 | 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);;