contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA588137" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4392304 | 4392304 | PRJNA588137_S_NODE_9524_length_244_cov_0.900585_g9491_i0 | PRJNA588137 | 9524 | 244 | 0.900585 | 2.1974274 | Botrytis cinerea | 40559 | Fungi | Fungi | 353 | 5.389999999999998e-93 | NTclustered | gi|1377705291|ref|XM_024692006.1| | 332648 | g9491 | i0 | 98.507 | 1.50819672131148 | 201 | 2 | 82 | 1 | 1 | 200 | 2954 | 3154 | Botrytis cinerea B05.10 hypothetical protein (BCIN_03g05200), mRNA | blastn | 368 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 4392305 | 4392305 | PRJNA588137_S_NODE_9564_length_244_cov_0.900585_g9531_i0 | PRJNA588137 | 9564 | 244 | 0.900585 | 2.1974274 | Botrytis cinerea | 40559 | Fungi | Fungi | 418 | 1.8799999999999994e-112 | NTclustered | gi|1377708426|ref|XM_024693075.1| | 332648 | g9531 | i0 | 97.541 | 1 | 244 | 6 | 100 | 0 | 1 | 244 | 2199 | 2442 | Botrytis cinerea B05.10 hypothetical protein (BCIN_05g05390), mRNA | blastn | 244 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 5668523 | 5668523 | PRJNA588137_S_NODE_8565_length_246_cov_0.890173_g8532_i0 | PRJNA588137 | 8565 | 246 | 0.890173 | 2.18982558 | Aspergillus candidus | 41067 | Fungi | Fungi | 209 | 1.25e-49 | NTclustered | gi|1383787775|ref|XM_024811585.1| | 41067 | g8532 | i0 | 84.434 | 3.41056910569106 | 212 | 33 | 86 | 0 | 35 | 246 | 4605 | 4394 | Aspergillus candidus putative patatin-like serine hydrolase (BDW47DRAFT_101052), mRNA | blastn | 839 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus candidus | |
| 8217916 | 8217916 | PRJNA588137_S_NODE_11527_length_229_cov_2.641026_g11494_i0 | PRJNA588137 | 11527 | 229 | 2.641026 | 6.04794954 | Ascoidea rubescens | 54195 | Fungi | Fungi | 287 | 5.14e-73 | NTclustered | gi|1147179545|ref|XM_020191367.1| | 1344418 | g11494 | i0 | 90.698 | 94.9650655021834 | 215 | 20 | 94 | 0 | 15 | 229 | 321 | 107 | Ascoidea rubescens DSM 1968 translational elongation factor EF-1 alpha (ASCRUDRAFT_6616), partial mRNA | blastn | 21747 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Ascoideales | Ascoideaceae | Ascoidea | Ascoidea rubescens | |
| 10769044 | 10769044 | PRJNA588137_S_NODE_5029_length_273_cov_1.355000_g4996_i0 | PRJNA588137 | 5029 | 273 | 1.355 | 3.69915 | Neurospora crassa | 5141 | Fungi | Fungi | 128 | 4.05e-25 | NTclustered | gi|759001027|ref|XR_898084.1| | 367110 | g4996 | i0 | 77.489 | 0.846153846153846 | 231 | 41 | 83 | 10 | 3 | 229 | 1257 | 1480 | Neurospora crassa OR74A 18S ribosomal RNA (NCU15773), rRNA | blastn | 231 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Neurospora | Neurospora crassa | |
| 12043849 | 12043849 | PRJNA588137_S_NODE_10650_length_242_cov_0.911243_g10617_i0 | PRJNA588137 | 10650 | 242 | 0.911243 | 2.20520806 | Fusarium coffeatum | 231269 | Fungi | Fungi | 350 | 6.9e-92 | NTclustered | gi|1759111739|ref|XM_031163710.1| | 231269 | g10617 | i0 | 92.623 | 1.00826446280992 | 244 | 16 | 100 | 2 | 1 | 242 | 1498 | 1741 | Fusarium coffeatum uncharacterized protein (FIESC28_09574), partial mRNA | blastn | 244 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium coffeatum | |
| 18416589 | 18416589 | PRJNA588137_S_NODE_2475_length_341_cov_1.149254_g2442_i0 | PRJNA588137 | 2475 | 341 | 1.149254 | 3.91895614 | Aspergillus thermomutatus | 41047 | Fungi | Fungi | 198 | 3.909999999999999e-46 | NTclustered | gi|1489413645|ref|XM_026754928.1| | 41047 | g2442 | i0 | 81.557 | 0.715542521994135 | 244 | 41 | 71 | 4 | 77 | 318 | 1031 | 790 | Aspergillus thermomutatus uncharacterized protein (CDV56_101309), partial mRNA | blastn | 244 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus thermomutatus | |
| 18416638 | 18416638 | PRJNA588137_S_NODE_6975_length_250_cov_0.870056_g6942_i0 | PRJNA588137 | 6975 | 250 | 0.870056 | 2.17514 | Clavispora lusitaniae | 36911 | Fungi | Fungi | 76.8 | 1.34e-9 | NTclustered | gi|2442245161|gb|ON464689.1| | 36911 | g6942 | i0 | 100 | 5.56 | 41 | 0 | 16 | 0 | 112 | 152 | 184 | 144 | Clavispora lusitaniae strain ATCC 42720 hypothetical protein (CLUG_00403) gene, complete cds | blastn | 1390 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 18416642 | 18416642 | PRJNA588137_S_NODE_7215_length_249_cov_0.875000_g7182_i0 | PRJNA588137 | 7215 | 249 | 0.875 | 2.17875 | Fusarium flagelliforme | 2675880 | Fungi | Fungi | 287 | 5.670000000000001e-73 | NTclustered | gi|2185441988|ref|XM_046134269.1| | 2675880 | g7182 | i0 | 91.429 | 0.843373493975904 | 210 | 16 | 84 | 1 | 40 | 249 | 1 | 208 | Fusarium flagelliforme acyl carrier protein-like protein (B0J16DRAFT_67402), mRNA | blastn | 210 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium flagelliforme | |
| 22241828 | 22241828 | PRJNA588137_S_NODE_10398_length_242_cov_0.911243_g10365_i0 | PRJNA588137 | 10398 | 242 | 0.911243 | 2.20520806 | Botrytis cinerea | 40559 | Fungi | Fungi | 228 | 3.3699999999999986e-55 | NTclustered | gi|1377720079|ref|XM_024697086.1| | 332648 | g10365 | i0 | 98.45 | 1.49173553719008 | 129 | 2 | 53 | 0 | 1 | 129 | 5023 | 5151 | Botrytis cinerea B05.10 hypothetical protein (BCIN_14g02290), mRNA | blastn | 361 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 24090306 | 24090306 | PRJNA588137_S_NODE_10759_length_242_cov_0.911243_g10726_i0 | PRJNA588137 | 10759 | 242 | 0.911243 | 2.20520806 | Aspergillus | 5052 | Fungi | Fungi | 130 | 9.79e-26 | NTclustered | gi|70991009|ref|XM_745261.1| | 330879 | g10726 | i0 | 84.615 | 1.07438016528926 | 130 | 20 | 54 | 0 | 109 | 238 | 1235 | 1364 | Aspergillus fumigatus Af293 sterol o-acyltransferase (APE2), putaitve (AFUA_1G06040), partial mRNA | blastn | 260 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus |
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);;