contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA763718" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 744205 | 744205 | PRJNA763718_S_NODE_8661_length_151_cov_1.271930_g8453_i0 | PRJNA763718 | 8661 | 151 | 1.27193 | 1.9206143 | Emericellopsis brunneiguttula | 3003015 | Fungi | Fungi | 180 | 5.42e-41 | NTclustered | gi|2552405995|gb|OQ470838.1| | 3003015 | g8453 | i0 | 90.441 | 90.2119205298013 | 136 | 13 | 90 | 0 | 1 | 136 | 372 | 507 | Emericellopsis brunneiguttula isolate CBS111360 translation elongation factor 1-alpha (tef1) gene, partial cds | blastn | 13622 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis brunneiguttula | |
| 4572532 | 4572532 | PRJNA763718_S_NODE_6604_length_170_cov_2.428571_g6396_i0 | PRJNA763718 | 6604 | 170 | 2.428571 | 4.1285707 | [Candida] orba | 115786 | Fungi | Fungi | 128 | 2.3e-25 | NTclustered | gi|156099467|gb|EF552489.1| | 115786 | g6396 | i0 | 81.879 | 15.6647058823529 | 149 | 23 | 86 | 3 | 14 | 160 | 984 | 838 | [Candida] orba strain NRRL Y-27336 translation elongation factor 1-alpha gene, partial cds | blastn | 2663 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Phaffomyces | [Candida] orba | |
| 10948308 | 10948308 | PRJNA763718_S_NODE_1629_length_381_cov_37.517442_g1421_i0 | PRJNA763718 | 1629 | 381 | 37.517442 | 142.94145402 | Phymatotrichopsis omnivora | 231936 | Fungi | Fungi | 115 | 4.57e-21 | NTclustered | gi|129560402|gb|EF441992.1| | 231936 | g1421 | i0 | 86.111 | 19.9291338582677 | 108 | 13 | 28 | 2 | 62 | 169 | 1 | 106 | Phymatotrichopsis omnivora strain ATCC 28960 18S ribosomal RNA gene, partial sequence | blastn | 7593 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Rhizinaceae | Phymatotrichopsis | Phymatotrichopsis omnivora | |
| 11409216 | 11409216 | PRJNA763718_S_NODE_1129_length_489_cov_3.110619_g924_i0 | PRJNA763718 | 1129 | 489 | 3.110619 | 15.21092691 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.048 | NTclustered | gi|2781297495|ref|XM_066836870.1| | 335848 | g924 | i0 | 100 | 0.286298568507157 | 28 | 0 | 6 | 0 | 225 | 252 | 820 | 793 | Apiospora aurea mitochondrial 54S ribosomal protein bL27m (PG986_000648), partial mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora aurea | |
| 12223891 | 12223891 | PRJNA763718_S_NODE_5630_length_184_cov_2.353741_g5422_i0 | PRJNA763718 | 5630 | 184 | 2.353741 | 4.33088344 | Botrytis byssoidea | 139641 | Fungi | Fungi | 95.3 | 2.57e-15 | NTclustered | gi|1955296959|ref|XM_038871110.1| | 139641 | g5422 | i0 | 91.304 | 21.9673913043478 | 69 | 6 | 38 | 0 | 115 | 183 | 641 | 573 | Botrytis byssoidea uncharacterized protein (EAE97_000600), partial mRNA | blastn | 4042 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis byssoidea | |
| 12223897 | 12223897 | PRJNA763718_S_NODE_6690_length_169_cov_2.939394_g6482_i0 | PRJNA763718 | 6690 | 169 | 2.939394 | 4.96757586 | Botrytis porri | 87229 | Fungi | Fungi | 163 | 6.25e-36 | NTclustered | gi|1955486658|ref|XM_038912274.1| | 87229 | g6482 | i0 | 85.443 | 68.4437869822485 | 158 | 21 | 93 | 1 | 2 | 159 | 1146 | 1301 | Botrytis porri translation elongation factor EF-1 alpha (EAF01_004020), mRNA | blastn | 11567 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis porri | |
| 12685107 | 12685107 | PRJNA763718_S_NODE_8790_length_150_cov_1.026549_g8582_i0 | PRJNA763718 | 8790 | 150 | 1.026549 | 1.5398235 | Hypocreales | 5125 | Fungi | Fungi | 132 | 1.53e-26 | NTclustered | gi|109628478|gb|DQ522342.1| | 93589 | g8582 | i0 | 92.391 | 58.6333333333333 | 92 | 7 | 61 | 0 | 59 | 150 | 900 | 991 | Haptocillium balanoides strain CBS 250.82 translation elongation factor 1-alpha (EF1-alpha) gene, partial cds | blastn | 8795 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Drechmeria | Drechmeria balanoides | |
| 13497945 | 13497945 | PRJNA763718_S_NODE_3591_length_234_cov_4.289340_g3383_i0 | PRJNA763718 | 3591 | 234 | 4.28934 | 10.0370556 | Clavispora lusitaniae | 36911 | Fungi | Fungi | 163 | 9.28e-36 | NTclustered | gi|2749661533|ref|XM_002614449.2| | 36911 | g3383 | i0 | 86.897 | 56.991452991453 | 145 | 19 | 67 | 0 | 15 | 159 | 997 | 1141 | Clavispora lusitaniae Ubiquitin (UBI4), partial mRNA | blastn | 13336 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 16046824 | 16046824 | PRJNA763718_S_NODE_6933_length_166_cov_3.077519_g6725_i0 | PRJNA763718 | 6933 | 166 | 3.077519 | 5.10868154 | [Candida] sp. NRRL Y-27127 | 461311 | Fungi | Fungi | 161 | 2.21e-35 | NTclustered | gi|156099523|gb|EF552517.1| | 461311 | g6725 | i0 | 86.806 | 91.3132530120482 | 144 | 17 | 86 | 2 | 24 | 166 | 561 | 419 | [Candida] sp. NRRL Y-27127 translation elongation factor 1-alpha gene, partial cds | blastn | 15158 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | [Candida] sp. NRRL Y-27127 | |||
| 16508282 | 16508282 | PRJNA763718_S_NODE_2433_length_292_cov_4.101961_g2225_i0 | PRJNA763718 | 2433 | 292 | 4.101961 | 11.97772612 | Middelhovenomyces | 1540074 | Fungi | Fungi | 150 | 9.329999999999999e-32 | NTclustered | gi|90811436|gb|DQ442703.1| | 45576 | g2225 | i0 | 88.618 | 51.6027397260274 | 123 | 14 | 42 | 0 | 45 | 167 | 1786 | 1908 | Candida petrohuensis 26S ribosomal RNA gene, partial sequence | blastn | 15068 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Middelhovenomyces | Middelhovenomyces petrohuensis | |
| 17322500 | 17322500 | PRJNA763718_S_NODE_3094_length_255_cov_3.385321_g2886_i0 | PRJNA763718 | 3094 | 255 | 3.385321 | 8.63256855 | Wickerhamiella azyma | 5488 | Fungi | Fungi | 108 | 4.87e-19 | NTclustered | gi|1209454344|ref|NG_055326.1| | 5488 | g2886 | i0 | 79.618 | 18.1176470588235 | 157 | 27 | 60 | 5 | 57 | 210 | 3041 | 2887 | Wickerhamiella azyma NRRL Y-17067 28S rRNA, partial sequence; from TYPE material | blastn | 4620 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella azyma | |
| 17322516 | 17322516 | PRJNA763718_S_NODE_8034_length_156_cov_0.974790_g7826_i0 | PRJNA763718 | 8034 | 156 | 0.97479 | 1.5206724 | Colletotrichum fructicola | 690256 | Fungi | Fungi | 60.2 | 7.68e-5 | NTclustered | gi|1799842923|ref|XM_032024521.1| | 1213859 | g7826 | i0 | 100 | 0.397435897435897 | 32 | 0 | 21 | 0 | 23 | 54 | 220 | 189 | Colletotrichum fructicola Nara gc5 putative glutamine--tRNA ligase (qrs1), partial mRNA | blastn | 62 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum fructicola | |
| 17783032 | 17783032 | PRJNA763718_S_NODE_4474_length_207_cov_3.988235_g4266_i0 | PRJNA763718 | 4474 | 207 | 3.988235 | 8.25564645 | Lipomycetaceae | 29827 | Fungi | Fungi | 267 | 5.94e-67 | NTclustered | gi|1208596473|ref|NG_055185.1| | 54097 | g4266 | i0 | 89.952 | 108.207729468599 | 209 | 17 | 100 | 4 | 1 | 207 | 2555 | 2349 | Myxozyma lipomycoides NRRL Y-17253 28S rRNA, partial sequence; from TYPE material | blastn | 22399 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Myxozyma | Myxozyma lipomycoides |
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);;