contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA177642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3605535 | 3605535 | PRJNA177642_P_NODE_12923_length_289_cov_2.653846_g11698_i0 | PRJNA177642 | 12923 | 289 | 2.653846 | 7.66961494 | Eurotiales | 5042 | Fungi | Fungi | 252 | 2.46e-62 | NTclustered | gi|2582615798|ref|XR_009468002.1| | 5061 | g11698 | i0 | 98.592 | 87.5432525951557 | 142 | 2 | 93 | 0 | 1 | 142 | 1701 | 1842 | Aspergillus niger 28S ribosomal RNA (28S rRNA), partial rRNA | blastn | 25300 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 4192581 | 4192581 | PRJNA177642_P_NODE_16584_length_171_cov_1.323944_g15359_i0 | PRJNA177642 | 16584 | 171 | 1.323944 | 2.26394424 | Lachancea lanzarotensis | 1245769 | Fungi | Fungi | 67.6 | 5.11e-7 | NTclustered | gi|1252320999|ref|XM_022772948.1| | 1245769 | g15359 | i0 | 90.385 | 0.304093567251462 | 52 | 3 | 30 | 2 | 100 | 150 | 120 | 70 | Lachancea lanzarotensis LALA0S04e08548g1_1 (LALA0_S04e08548g), partial mRNA | blastn | 52 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Lachancea | Lachancea lanzarotensis | |
| 6157892 | 6157892 | PRJNA177642_P_NODE_5665_length_594_cov_4.438938_g4576_i0 | PRJNA177642 | 5665 | 594 | 4.438938 | 26.36729172 | Ascomycota | 4890 | Fungi | Fungi | 881 | 0 | NTclustered | gi|169894415|gb|EU343558.1| | 29918 | g4576 | i0 | 97.159 | 88.8737373737374 | 528 | 3 | 87 | 1 | 1 | 516 | 26 | 553 | Davidiella tassiana clone k104-5 large subunit ribosomal RNA gene, partial sequence | blastn | 52791 | 887 | 0.993235625704622 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 6743099 | 6743099 | PRJNA177642_P_NODE_13766_length_235_cov_2.310680_g12541_i0 | PRJNA177642 | 13766 | 235 | 2.31068 | 5.430098 | Australozyma saopauloensis | 291208 | Fungi | Fungi | 204 | 5.489999999999999e-48 | NTclustered | gi|2675365576|ref|XM_063022690.1| | 291208 | g12541 | i0 | 84.211 | 36.736170212766 | 209 | 33 | 89 | 0 | 27 | 235 | 860 | 652 | [Candida] saopauloensis uncharacterized protein (PUMCH_003732), partial mRNA | blastn | 8633 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Australozyma | Australozyma saopauloensis | |
| 6743103 | 6743103 | PRJNA177642_P_NODE_13966_length_226_cov_3.639594_g12741_i0 | PRJNA177642 | 13966 | 226 | 3.639594 | 8.22548244 | uncultured Ascomycota | 175243 | Fungi | Fungi | 401 | 1.7299999999999993e-107 | NTclustered | gi|157101975|gb|EU123361.1| | 175243 | g12741 | i0 | 98.673 | 100 | 226 | 3 | 100 | 0 | 1 | 226 | 65 | 290 | Uncultured ascomycete clone 242 18S ribosomal RNA gene, partial sequence | blastn | 22600 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 8707839 | 8707839 | PRJNA177642_P_NODE_15627_length_183_cov_2.798701_g14402_i0 | PRJNA177642 | 15627 | 183 | 2.798701 | 5.12162283 | Dothideomycetes | 147541 | Fungi | Fungi | 320 | 3.87e-83 | NTclustered | gi|283827932|gb|FJ493209.2| | 630509 | g14402 | i0 | 98.361 | 99.9453551912568 | 183 | 2 | 100 | 1 | 1 | 183 | 1975 | 2156 | Phaeophleospora eugeniicola strain CPC 2558 28S large subunit ribosomal RNA gene, partial sequence | blastn | 18290 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Phaeophleospora | Phaeophleospora eugeniicola | |
| 10569555 | 10569555 | PRJNA177642_P_NODE_17409_length_167_cov_1.028986_g16184_i0 | PRJNA177642 | 17409 | 167 | 1.028986 | 1.71840662 | Diaporthe nobilis | 1303587 | Fungi | Fungi | 73.1 | 1.08e-8 | NTclustered | gi|2026153258|ref|NC_054216.1| | 1303587 | g16184 | i0 | 92.308 | 18.4011976047904 | 52 | 2 | 31 | 2 | 2 | 53 | 43376 | 43327 | Diaporthe nobilis mitochondrion, complete genome | blastn | 3073 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe nobilis | |
| 14394596 | 14394596 | PRJNA177642_P_NODE_17072_length_168_cov_2.827338_g15847_i0 | PRJNA177642 | 17072 | 168 | 2.827338 | 4.74992784 | Drechmeria coniospora | 98403 | Fungi | Fungi | 174 | 2.89e-39 | NTclustered | gi|2028064454|ref|XM_040798084.1| | 98403 | g15847 | i0 | 89.706 | 9.58333333333333 | 136 | 14 | 81 | 0 | 9 | 144 | 2508 | 2643 | Drechmeria coniospora fatty acid synthase subunit alpha (DCS_00748), partial mRNA | blastn | 1610 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Drechmeria | Drechmeria coniospora | |
| 18217211 | 18217211 | PRJNA177642_P_NODE_18175_length_164_cov_1.037037_g16950_i0 | PRJNA177642 | 18175 | 164 | 1.037037 | 1.70074068 | Fusarium oxysporum | 5507 | Fungi | Fungi | 130 | 6.15e-26 | NTclustered | gi|1070358298|ref|XM_018394538.1| | 426428 | g16950 | i0 | 91.667 | 0.585365853658537 | 96 | 5 | 57 | 1 | 2 | 94 | 100 | 5 | Fusarium oxysporum f. sp. lycopersici 4287 uncharacterized protein (FOXG_14485), mRNA | blastn | 96 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 21456888 | 21456888 | PRJNA177642_P_NODE_16217_length_173_cov_4.493056_g14992_i0 | PRJNA177642 | 16217 | 173 | 4.493056 | 7.77298688 | Eukaryota | 2759 | Fungi | Fungi | 318 | 1.3e-82 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g14992 | i0 | 100 | 94.4104046242775 | 172 | 0 | 99 | 0 | 1 | 172 | 3002 | 3173 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16333 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 23317585 | 23317585 | PRJNA177642_P_NODE_16879_length_169_cov_2.007143_g15654_i0 | PRJNA177642 | 16879 | 169 | 2.007143 | 3.39207167 | Coniochaeta sp. 169 OA-2013 | 1321866 | Fungi | Fungi | 193 | 7.97e-45 | NTclustered | gi|480327111|gb|JX535134.1| | 1321866 | g15654 | i0 | 92.593 | 91.2662721893491 | 135 | 9 | 79 | 1 | 2 | 135 | 1753 | 1619 | Coniochaeta sp. 169 OA-2013 large subunit ribosomal RNA gene, partial sequence | blastn | 15424 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta sp. 169 OA-2013 | |
| 23317630 | 23317630 | PRJNA177642_P_NODE_18999_length_155_cov_2.055556_g17774_i0 | PRJNA177642 | 18999 | 155 | 2.055556 | 3.1861118 | Parastagonospora nodorum | 13684 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1759050521|gb|CP039671.1| | 13684 | g17774 | i0 | 100 | 0.187096774193548 | 29 | 0 | 19 | 0 | 94 | 122 | 1342365 | 1342393 | Parastagonospora nodorum strain Sn79 chromosome 3 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 24591714 | 24591714 | PRJNA177642_P_NODE_15120_length_194_cov_2.442424_g13895_i0 | PRJNA177642 | 15120 | 194 | 2.442424 | 4.73830256 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 187 | 4.4e-43 | NTclustered | gi|2725234569|ref|XM_064897648.1| | 1690604 | g13895 | i0 | 100 | 1.04123711340206 | 101 | 0 | 100 | 0 | 1 | 101 | 3216 | 3116 | Lithohypha guttulata Carbamoyl-phosphate synthase (URA2), partial mRNA | blastn | 202 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata |
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);;