contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4266101 | 4266101 | PRJNA450343_P_NODE_744_length_661_cov_6.875817_g684_i0 | PRJNA450343 | 744 | 661 | 6.875817 | 45.44915037 | Chaetothyriales sp. MP-2014 | 1541146 | Fungi | Fungi | 1044 | 0 | NTclustered | gi|676232686|gb|KF614892.1| | 1541146 | g684 | i0 | 95.166 | 100.096822995461 | 662 | 31 | 100 | 1 | 1 | 661 | 2297 | 2958 | Chaetothyriales sp. MP-2014 isolate T221_Tm15 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 | 66164 | 1044 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Chaetothyriales sp. MP-2014 | |||
| 4266103 | 4266103 | PRJNA450343_P_NODE_7724_length_194_cov_1.606897_g7656_i0 | PRJNA450343 | 7724 | 194 | 1.606897 | 3.11738018 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 1.65e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g7656 | i0 | 88 | 2.27319587628866 | 75 | 6 | 39 | 1 | 81 | 155 | 2198 | 2269 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 441 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 9366979 | 9366979 | PRJNA450343_P_NODE_4408_length_253_cov_1.862745_g4340_i0 | PRJNA450343 | 4408 | 253 | 1.862745 | 4.71274485 | Dothideales sp. | 1769355 | Fungi | Fungi | 444 | 3.24e-120 | NTclustered | gi|2463204176|gb|OQ673103.1| | 1769355 | g4340 | i0 | 98.413 | 99.3359683794466 | 252 | 4 | 99 | 0 | 1 | 252 | 1971 | 2222 | Dothideales sp. voucher G.M. 2015-09-15.11 #1528 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 | 25132 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothideales sp. | |||
| 10020718 | 10020718 | PRJNA450343_P_NODE_2308_length_357_cov_8.493506_g2240_i0 | PRJNA450343 | 2308 | 357 | 8.493506 | 30.32181642 | Ascomycota | 4890 | Fungi | Fungi | 643 | 4.379999999999998e-180 | NTclustered | gi|15865224|emb|AJ232953.1| | 82109 | g2240 | i0 | 99.16 | 100 | 357 | 3 | 100 | 0 | 1 | 357 | 1250 | 1606 | Cladophialophora sp. CBS 985.96 nuclear 18S rRNA gene, partial | blastn | 35700 | 649 | 0.99075500770416 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora sp. CBS 985.96 | |
| 10020723 | 10020723 | PRJNA450343_P_NODE_6868_length_205_cov_0.948718_g6800_i0 | PRJNA450343 | 6868 | 205 | 0.948718 | 1.9448719 | Eukaryota | 2759 | Fungi | Fungi | 363 | 7.279999999999998e-96 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g6800 | i0 | 98.537 | 100.063414634146 | 205 | 3 | 100 | 0 | 1 | 205 | 3764 | 3968 | Cladosporium cladosporioides strain DSM 104381 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 | 20513 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 13192595 | 13192595 | PRJNA450343_P_NODE_12531_length_164_cov_0.886957_g12463_i0 | PRJNA450343 | 12531 | 164 | 0.886957 | 1.45460948 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1338080039|ref|XM_023766772.1| | 112498 | g12463 | i0 | 100 | 0.176829268292683 | 29 | 0 | 18 | 0 | 39 | 67 | 1567 | 1539 | Ramularia collo-cygni probable glucokinase GLK1 (RCC_12031), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 14467715 | 14467715 | PRJNA450343_P_NODE_7472_length_197_cov_2.067568_g7404_i0 | PRJNA450343 | 7472 | 197 | 2.067568 | 4.07310896 | Ophidiomyces ophidiicola | 1387563 | Fungi | Fungi | 104 | 4.64e-18 | NTclustered | gi|2272097000|ref|XM_049252907.1| | 1387563 | g7404 | i0 | 86.598 | 4.42639593908629 | 97 | 10 | 49 | 3 | 29 | 124 | 143 | 49 | Ophidiomyces ophidiicola 40S ribosomal protein S28 (RPS28A), partial mRNA | blastn | 872 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenaceae | Ophidiomyces | Ophidiomyces ophidiicola | |
| 15120302 | 15120302 | PRJNA450343_P_NODE_3412_length_290_cov_0.842324_g3344_i0 | PRJNA450343 | 3412 | 290 | 0.842324 | 2.4427396 | Ascomycota | 4890 | Fungi | Fungi | 84.2 | 9.52e-12 | NTclustered | gi|2459765993|ref|XM_054260814.1| | 37727 | g3344 | i0 | 94.444 | 2.71034482758621 | 54 | 3 | 19 | 0 | 24 | 77 | 195 | 142 | Talaromyces marneffei uncharacterized protein (EYB26_001504), partial mRNA | blastn | 786 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 15741720 | 15741720 | PRJNA450343_P_NODE_7273_length_200_cov_0.900662_g7205_i0 | PRJNA450343 | 7273 | 200 | 0.900662 | 1.801324 | Exophiala xenobiotica | 348802 | Fungi | Fungi | 67.6 | 6.21e-7 | NTclustered | gi|915144019|ref|XR_001230708.1| | 348802 | g7205 | i0 | 95.238 | 0.21 | 42 | 2 | 21 | 0 | 159 | 200 | 4692 | 4651 | Exophiala xenobiotica 28S ribosomal RNA (PV05_12071), rRNA | blastn | 42 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala xenobiotica | |
| 16395128 | 16395128 | PRJNA450343_P_NODE_5773_length_222_cov_1.531792_g5705_i0 | PRJNA450343 | 5773 | 222 | 1.531792 | 3.40057824 | Aspergillus | 5052 | Fungi | Fungi | 405 | 1.31e-108 | NTclustered | gi|1938233191|gb|MW299241.1| | 5065 | g5705 | i0 | 99.552 | 100.216216216216 | 223 | 0 | 100 | 1 | 1 | 222 | 717 | 495 | Aspergillus sp. isolate 880334-27--08 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22248 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sp. | |
| 17016407 | 17016407 | PRJNA450343_P_NODE_9674_length_175_cov_1.611111_g9606_i0 | PRJNA450343 | 9674 | 175 | 1.611111 | 2.81944425 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 226 | 8.209999999999999e-55 | NTclustered | gi|2028517218|ref|XM_041026929.1| | 1043003 | g9606 | i0 | 90.173 | 0.988571428571429 | 173 | 17 | 99 | 0 | 3 | 175 | 3373 | 3545 | Aureobasidium melanogenum CBS 110374 protein kinase WD40 (M437DRAFT_78036), partial mRNA | blastn | 173 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 18290714 | 18290714 | PRJNA450343_P_NODE_4675_length_245_cov_1.897959_g4607_i0 | PRJNA450343 | 4675 | 245 | 1.897959 | 4.64999955 | Cladophialophora immunda | 569365 | Fungi | Fungi | 176 | 1.26e-39 | NTclustered | gi|1022864818|ref|XM_016388514.1| | 569365 | g4607 | i0 | 79.835 | 80.7428571428571 | 243 | 47 | 99 | 2 | 3 | 244 | 1475 | 1234 | Cladophialophora immunda elongation factor 1-alpha (PV07_01933), mRNA | blastn | 19782 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora immunda | |
| 21494356 | 21494356 | PRJNA450343_P_NODE_2877_length_317_cov_2.951493_g2809_i0 | PRJNA450343 | 2877 | 317 | 2.951493 | 9.35623281 | root | 1 | Root_unresolved | Root_unresolved | 558 | 1.44e-154 | NTclustered | gi|2043739121|gb|MZ267247.1| | 5059 | g2809 | i0 | 98.423 | 100.003154574132 | 317 | 5 | 100 | 0 | 1 | 317 | 345 | 29 | Aspergillus flavus strain 3 small subunit ribosomal RNA gene, partial sequence | blastn | 31701 | 558 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 24665264 | 24665264 | PRJNA450343_P_NODE_2360_length_354_cov_2.003279_g2292_i0 | PRJNA450343 | 2360 | 354 | 2.003279 | 7.09160766 | Metarhizium acridum | 92637 | Fungi | Fungi | 156 | 2.48e-33 | NTclustered | gi|2749701715|ref|XM_007813622.2| | 92637 | g2292 | i0 | 77.907 | 20.9350282485876 | 258 | 51 | 72 | 5 | 100 | 354 | 1157 | 1411 | Metarhizium acridum uncharacterized protein (J3458_002342), mRNA | blastn | 7411 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium acridum | |
| 25318721 | 25318721 | PRJNA450343_P_NODE_7120_length_202_cov_0.928105_g7052_i0 | PRJNA450343 | 7120 | 202 | 0.928105 | 1.8747721 | Coccidioides | 5500 | Fungi | Fungi | 124 | 3.669999999999999e-24 | NTclustered | gi|2120474931|ref|NC_058291.1| | 5501 | g7052 | i0 | 87.611 | 50.9653465346535 | 113 | 7 | 55 | 6 | 90 | 201 | 59066 | 58960 | Coccidioides immitis strain WA221 mitochondrion, complete genome | blastn | 10295 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenaceae | Coccidioides | Coccidioides immitis |
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);;