contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2998495 | 2998495 | PRJNA478247_P_NODE_2823_length_188_cov_3.238994_g2717_i0 | PRJNA478247 | 2823 | 188 | 3.238994 | 6.08930872 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 89.8 | 1.23e-13 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g2717 | i0 | 94.737 | 3.49468085106383 | 57 | 3 | 30 | 0 | 132 | 188 | 6129 | 6185 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 657 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 5551416 | 5551416 | PRJNA478247_P_NODE_2685_length_197_cov_1.988095_g2579_i0 | PRJNA478247 | 2685 | 197 | 1.988095 | 3.91654715 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 134 | 5.92e-27 | NTclustered | gi|2432051426|ref|XM_053072055.1| | 1396493 | g2579 | i0 | 79.275 | 7.21827411167513 | 193 | 38 | 97 | 2 | 6 | 197 | 392 | 583 | Fimicolochytrium jonesii ribosomal family S4e-domain-containing protein (EV422DRAFT_563332), partial mRNA | blastn | 1422 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 6825341 | 6825341 | PRJNA478247_P_NODE_2426_length_213_cov_2.119565_g2320_i0 | PRJNA478247 | 2426 | 213 | 2.119565 | 4.51467345 | Entophlyctis helioformis | 281842 | Fungi | Fungi | 257 | 3.7e-64 | NTclustered | gi|358030871|dbj|AB609169.1| | 281842 | g2320 | i0 | 88.732 | 97.5492957746479 | 213 | 21 | 99 | 3 | 2 | 213 | 1646 | 1436 | Entophlyctis helioformis EF2 gene for translation elongation factor 2, partial cds, isolate: AFTOL-ID 40 | blastn | 20778 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 11926411 | 11926411 | PRJNA478247_P_NODE_1910_length_254_cov_1.400000_g1804_i0 | PRJNA478247 | 1910 | 254 | 1.4 | 3.556 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 215 | 2.78e-51 | NTclustered | gi|2432158512|ref|XM_053111712.1| | 110093 | g1804 | i0 | 82.101 | 77.5433070866142 | 257 | 40 | 100 | 6 | 1 | 254 | 317 | 570 | Polychytrium aggregatum 40S ribosomal protein S13 (BJ171DRAFT_513016), mRNA | blastn | 19696 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13201393 | 13201393 | PRJNA478247_P_NODE_1951_length_251_cov_1.490991_g1845_i0 | PRJNA478247 | 1951 | 251 | 1.490991 | 3.74238741 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 150 | 7.84e-32 | NTclustered | gi|2432070021|ref|XM_053067041.1| | 1396493 | g1845 | i0 | 87.597 | 46.9681274900398 | 129 | 16 | 51 | 0 | 117 | 245 | 179 | 307 | Fimicolochytrium jonesii 60S ribosomal protein L21-A (EV422DRAFT_411829), mRNA | blastn | 11789 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 13201394 | 13201394 | PRJNA478247_P_NODE_2571_length_204_cov_2.040000_g2465_i0 | PRJNA478247 | 2571 | 204 | 2.04 | 4.1616 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 154 | 4.74e-33 | NTclustered | gi|2432097059|ref|XM_053068802.1| | 1396493 | g2465 | i0 | 81 | 64.3333333333333 | 200 | 33 | 96 | 3 | 8 | 203 | 192 | 390 | Fimicolochytrium jonesii ribosomal S3Ae family-domain-containing protein (EV422DRAFT_508972), partial mRNA | blastn | 13124 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 16399725 | 16399725 | PRJNA478247_P_NODE_1893_length_255_cov_2.907080_g1787_i0 | PRJNA478247 | 1893 | 255 | 2.90708 | 7.413054 | Opisthokonta | 33154 | Fungi | Fungi | 187 | 6.089999999999998e-43 | NTclustered | gi|82398309|gb|DQ273787.1| | 64517 | g1787 | i0 | 95.69 | 49.7411764705882 | 116 | 5 | 45 | 0 | 1 | 116 | 2269 | 2154 | Rhizophlyctis rosea isolate AFTOL-ID 43 28S ribosomal RNA gene, partial sequence | blastn | 12684 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;