contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24042 | 24042 | PRJEB28062_P_NODE_133301_length_232_cov_2.113208_g130937_i0 | PRJEB28062 | 133301 | 232 | 2.113208 | 4.90264256 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 137 | 5.569999999999999e-28 | NTclustered | gi|2432156890|ref|XM_053107738.1| | 110093 | g130937 | i0 | 84.459 | 8.26724137931035 | 148 | 13 | 60 | 5 | 39 | 178 | 602 | 747 | Polychytrium aggregatum 60S ribosomal protein L2 (BJ171DRAFT_425809), partial mRNA | blastn | 1918 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 987923 | 987923 | PRJEB28062_P_NODE_88781_length_349_cov_1.565217_g86419_i0 | PRJEB28062 | 88781 | 349 | 1.565217 | 5.46260733 | Fungi | 4751 | Fungi | Fungi | 503 | 7.57e-138 | NTclustered | gi|1866582755|gb|MT730930.1| | 64517 | g86419 | i0 | 93.529 | 97.1174785100286 | 340 | 18 | 97 | 4 | 12 | 349 | 4027 | 4364 | Rhizophlyctis rosea isolate KP18 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 | 33894 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 8951973 | 8951973 | PRJEB28062_P_NODE_51668_length_494_cov_22.992874_g49317_i0 | PRJEB28062 | 51668 | 494 | 22.992874 | 113.58479756 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 316 | 1.55e-81 | NTclustered | gi|1026947610|ref|XM_016748378.1| | 645134 | g49317 | i0 | 81.114 | 21.9676113360324 | 413 | 63 | 82 | 14 | 70 | 473 | 686 | 280 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S8 (SPPG_00042), mRNA | blastn | 10852 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 20426310 | 20426310 | PRJEB28062_P_NODE_84677_length_362_cov_2.394464_g82315_i0 | PRJEB28062 | 84677 | 362 | 2.394464 | 8.66795968 | Endochytrium sp. JEL 324 | 281852 | Fungi | Fungi | 198 | 4.1699999999999996e-46 | NTclustered | gi|82398552|gb|DQ273816.1| | 281852 | g82315 | i0 | 96.639 | 64.0303867403315 | 119 | 4 | 58 | 0 | 241 | 359 | 1959 | 2077 | Endochytrium sp. JEL324 isolate AFTOL-ID 631 28S ribosomal RNA gene, partial sequence | blastn | 23179 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Endochytriaceae | Endochytrium | Endochytrium sp. JEL 324 | |
| 22664829 | 22664829 | PRJEB28062_P_NODE_92038_length_338_cov_117.811321_g89676_i0 | PRJEB28062 | 92038 | 338 | 117.811321 | 398.20226498 | Powellomycetaceae | 1134080 | Fungi | Fungi | 549 | 9.279999999999997e-152 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g89676 | i0 | 98.095 | 92.792899408284 | 315 | 6 | 93 | 0 | 1 | 315 | 4538 | 4224 | Geranomyces variabilis isolate Barr350 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 | 31364 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis |
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);;