contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA454154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6196472 | 6196472 | PRJNA454154_S_NODE_445_length_176_cov_9.712230_g442_i0 | PRJNA454154 | 445 | 176 | 9.71223 | 17.0935248 | Eukaryota | 2759 | Fungi | Fungi | 213 | 6.44e-51 | NTclustered | gi|311235598|ref|NG_027613.1| | 110093 | g442 | i0 | 91.558 | 101.534090909091 | 154 | 13 | 88 | 0 | 4 | 157 | 2694 | 2847 | Polychytrium aggregatum JEL 109 28S rRNA gene, partial sequence; from reference material | blastn | 17870 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6819641 | 6819641 | PRJNA454154_S_NODE_106_length_279_cov_10.454545_g103_i0 | PRJNA454154 | 106 | 279 | 10.454545 | 29.16818055 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 183 | 8.73e-42 | NTclustered | gi|82398216|gb|DQ273778.1| | 109897 | g103 | i0 | 94.872 | 42.2903225806452 | 117 | 6 | 42 | 0 | 163 | 279 | 2165 | 2281 | Gaertneriomyces semiglobiferus isolate AFTOL-ID 34 28S ribosomal RNA gene, partial sequence | blastn | 11799 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 15744565 | 15744565 | PRJNA454154_S_NODE_513_length_166_cov_14.643411_g510_i0 | PRJNA454154 | 513 | 166 | 14.643411 | 24.30806226 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 97.1 | 6.33e-16 | NTclustered | gi|2468791005|gb|OQ702918.1| | 2058121 | g510 | i0 | 93.846 | 27.7951807228916 | 65 | 3 | 39 | 1 | 102 | 165 | 3925 | 3989 | Lobulomycetales sp. isolate PSC233 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 | 4614 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 15744567 | 15744567 | PRJNA454154_S_NODE_93_length_289_cov_31.694444_g90_i0 | PRJNA454154 | 93 | 289 | 31.694444 | 91.59694316 | Synchytrium sp. | 1971732 | Fungi | Fungi | 93.5 | 1.58e-14 | NTclustered | gi|1168020523|gb|KY800404.1| | 1971732 | g90 | i0 | 83.168 | 0.349480968858132 | 101 | 17 | 35 | 0 | 45 | 145 | 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. | |
| 16396025 | 16396025 | PRJNA454154_S_NODE_33_length_396_cov_28.097493_g30_i0 | PRJNA454154 | 33 | 396 | 28.097493 | 111.26607228 | Staurastromyces | 2006669 | Fungi | Fungi | 108 | 7.98e-19 | NTclustered | gi|2465121858|gb|OQ687259.1| | 687209 | g30 | i0 | 81.618 | 35.0505050505051 | 136 | 20 | 34 | 4 | 263 | 396 | 405 | 537 | Uncultured Rhizophydiales isolate UMPB-1297 small subunit ribosomal RNA gene, partial sequence | blastn | 13880 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | uncultured Rhizophydiales | |||
| 18944918 | 18944918 | PRJNA454154_S_NODE_15_length_467_cov_48.109302_g12_i0 | PRJNA454154 | 15 | 467 | 48.109302 | 224.67044034 | Nowakowskiella | 109880 | Fungi | Fungi | 154 | 1.2099999999999999e-32 | NTclustered | gi|194241380|gb|EU828507.1| | 546781 | g12 | i0 | 96.774 | 18.7194860813704 | 93 | 2 | 20 | 1 | 374 | 466 | 308 | 217 | Nowakowskiella sp. JH FR 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8742 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JH FR |
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);;