contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA938397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1255970 | 1255970 | PRJNA938397_S_NODE_21921_length_236_cov_4.055276_g21680_i0 | PRJNA938397 | 21921 | 236 | 4.055276 | 9.57045136 | Penicillium | 5073 | Fungi | Fungi | 89.8 | 1.61e-13 | NTclustered | gi|2517659489|ref|XM_057143745.1| | 1167516 | g21680 | i0 | 96.296 | 0.889830508474576 | 54 | 2 | 23 | 0 | 174 | 227 | 216 | 163 | Penicillium odoratum uncharacterized protein (N7520_009811), partial mRNA | blastn | 210 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium odoratum | |
| 6016180 | 6016180 | PRJNA938397_S_NODE_27245_length_211_cov_12.551724_g27004_i0 | PRJNA938397 | 27245 | 211 | 12.551724 | 26.48413764 | Kazachstania africana | 432096 | Fungi | Fungi | 300 | 5.99e-77 | NTclustered | gi|1199862363|ref|XR_002430158.1| | 1071382 | g27004 | i0 | 94.792 | 101.24644549763 | 192 | 10 | 91 | 0 | 15 | 206 | 3201 | 3392 | Kazachstania africana CBS 2517 25S ribosomal RNA (Kafr_RDN25-1), rRNA | blastn | 21363 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kazachstania | Kazachstania africana | |
| 6016445 | 6016445 | PRJNA938397_S_NODE_33805_length_189_cov_9.526316_g33564_i0 | PRJNA938397 | 33805 | 189 | 9.526316 | 18.00473724 | Cyberlindnera jadinii | 4903 | Fungi | Fungi | 296 | 6.79e-76 | NTclustered | gi|1821108737|gb|MT192755.1| | 4903 | g33564 | i0 | 99.387 | 86.1428571428571 | 163 | 1 | 86 | 0 | 2 | 164 | 107 | 269 | Cyberlindnera jadinii isolate 2Y50 large subunit ribosomal RNA gene, partial sequence | blastn | 16281 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 7290850 | 7290850 | PRJNA938397_S_NODE_21006_length_241_cov_6.450980_g20765_i0 | PRJNA938397 | 21006 | 241 | 6.45098 | 15.5468618 | Cercospora beticola | 122368 | Fungi | Fungi | 60.2 | 1.3e-4 | NTclustered | gi|2741420349|ref|XM_023604034.2| | 122368 | g20765 | i0 | 94.872 | 12.5726141078838 | 39 | 1 | 16 | 1 | 2 | 39 | 3090 | 3128 | Cercospora beticola uncharacterized protein (RHO25_012735), partial mRNA | blastn | 3030 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora beticola | |
| 9841105 | 9841105 | PRJNA938397_S_NODE_30508_length_200_cov_1.159509_g30267_i0 | PRJNA938397 | 30508 | 200 | 1.159509 | 2.319018 | Lipomyces tetrasporus | 54092 | Fungi | Fungi | 52.8 | 0.017 | NTclustered | gi|2507625475|ref|XM_056187432.1| | 54092 | g30267 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 73 | 100 | 1178 | 1151 | Lipomyces tetrasporus uncharacterized protein (POJ06DRAFT_251706), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces tetrasporus | |
| 13667310 | 13667310 | PRJNA938397_S_NODE_44691_length_164_cov_3.118110_g44450_i0 | PRJNA938397 | 44691 | 164 | 3.11811 | 5.1137004 | Asterina chrysophylli | 1651222 | Fungi | Fungi | 80.5 | 6.28e-11 | NTclustered | gi|827195252|gb|KP143738.1| | 1651222 | g44450 | i0 | 79.487 | 29.9451219512195 | 117 | 20 | 70 | 3 | 2 | 116 | 217 | 103 | Asterina chrysophylli strain VIC 42823 28S ribosomal RNA gene, partial sequence | blastn | 4911 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Asterinales | Asterinaceae | Asterina | Asterina chrysophylli | |
| 15283911 | 15283911 | PRJNA938397_S_NODE_20392_length_244_cov_30.212560_g20151_i0 | PRJNA938397 | 20392 | 244 | 30.21256 | 73.7186464 | Fungi | 4751 | Fungi | Fungi | 387 | 5.31e-103 | NTclustered | gi|451991414|gb|JX134665.1| | 42149 | g20151 | i0 | 99.531 | 87.2950819672131 | 213 | 0 | 87 | 1 | 33 | 244 | 929 | 717 | Pseudohalonectria lignicola strain M95 18S ribosomal RNA gene, partial sequence | blastn | 21300 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Ophioceraceae | Pseudohalonectria | Pseudohalonectria lignicola | |
| 16558522 | 16558522 | PRJNA938397_S_NODE_7633_length_370_cov_69.231231_g7392_i0 | PRJNA938397 | 7633 | 370 | 69.231231 | 256.1555547 | Cylindrium | 318858 | Fungi | Fungi | 676 | 0 | NTclustered | gi|313483127|gb|HQ433132.1| | 175243 | g7392 | i0 | 100 | 98.2486486486487 | 366 | 0 | 99 | 0 | 1 | 366 | 713 | 348 | Uncultured Ascomycota clone asc07195 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36352 | 676 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 17491253 | 17491253 | PRJNA938397_S_NODE_27614_length_210_cov_4.514451_g27373_i0 | PRJNA938397 | 27614 | 210 | 4.514451 | 9.4803471 | Ocellularia praestans | 1232515 | Fungi | Fungi | 78.7 | 3.04e-10 | NTclustered | gi|406858566|gb|JX421583.1| | 1232515 | g27373 | i0 | 95.833 | 19.5047619047619 | 48 | 2 | 23 | 0 | 163 | 210 | 340 | 293 | Ocellularia praestans voucher Luecking 32236 28S ribosomal RNA gene, partial sequence | blastn | 4096 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Ocellularia | Ocellularia praestans | |
| 17491379 | 17491379 | PRJNA938397_S_NODE_30834_length_199_cov_1.382716_g30593_i0 | PRJNA938397 | 30834 | 199 | 1.382716 | 2.75160484 | Cyberlindnera jadinii | 4903 | Fungi | Fungi | 302 | 1.55e-77 | NTclustered | gi|1147433434|ref|XM_020217210.1| | 983966 | g30593 | i0 | 100 | 0.819095477386935 | 163 | 0 | 82 | 0 | 37 | 199 | 359 | 197 | Cyberlindnera jadinii NRRL Y-1542 60S ribosomal protein eL39 (CYBJADRAFT_186340), partial mRNA | blastn | 163 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 17491391 | 17491391 | PRJNA938397_S_NODE_31174_length_197_cov_12.843750_g30933_i0 | PRJNA938397 | 31174 | 197 | 12.84375 | 25.3021875 | Wickerhamomyces anomalus | 4927 | Fungi | Fungi | 128 | 2.76e-25 | NTclustered | gi|1102229961|ref|XM_019184630.1| | 683960 | g30933 | i0 | 89.899 | 7.46192893401015 | 99 | 10 | 50 | 0 | 22 | 120 | 1221 | 1319 | Wickerhamomyces anomalus NRRL Y-366-8 alpha-tubulin TUB1 (WICANDRAFT_77894), partial mRNA | blastn | 1470 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces anomalus | |
| 19107377 | 19107377 | PRJNA938397_S_NODE_41435_length_170_cov_10.721805_g41194_i0 | PRJNA938397 | 41435 | 170 | 10.721805 | 18.2270685 | Sordariomycetes | 147550 | Fungi | Fungi | 285 | 1.29e-72 | NTclustered | gi|63169502|gb|AY969207.1| | 175243 | g41194 | i0 | 100 | 90.5823529411765 | 154 | 0 | 91 | 0 | 1 | 154 | 528 | 375 | Uncultured ascomycete isolate dfmo4344.094 18S ribosomal RNA gene, partial sequence | blastn | 15399 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 19107379 | 19107379 | PRJNA938397_S_NODE_42075_length_169_cov_4.696970_g41834_i0 | PRJNA938397 | 42075 | 169 | 4.69697 | 7.9378793 | Ascomycota | 4890 | Fungi | Fungi | 239 | 1.01e-58 | NTclustered | gi|1473255798|gb|MH868742.1| | 5074 | g41834 | i0 | 97.826 | 81.6568047337278 | 138 | 3 | 82 | 0 | 32 | 169 | 309 | 172 | Penicillium brevicompactum culture CBS:287.53 strain CBS 287.53 large subunit ribosomal RNA gene, partial sequence | blastn | 13800 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 21658255 | 21658255 | PRJNA938397_S_NODE_28197_length_208_cov_1.748538_g27956_i0 | PRJNA938397 | 28197 | 208 | 1.748538 | 3.63695904 | Trichomeriaceae | 1233474 | Fungi | Fungi | 333 | 5.809999999999999e-87 | NTclustered | gi|794346446|gb|KP174920.1| | 1628654 | g27956 | i0 | 100 | 86.375 | 180 | 0 | 87 | 0 | 3 | 182 | 48 | 227 | Bradymyces sp. LS-2015b culture-collection CGMCC:3.17223 28S ribosomal RNA gene, partial sequence | blastn | 17966 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Bradymyces | Bradymyces sp. LS-2015b | |
| 22589922 | 22589922 | PRJNA938397_S_NODE_25998_length_216_cov_12.715084_g25757_i0 | PRJNA938397 | 25998 | 216 | 12.715084 | 27.46458144 | Neoarthrinium moseri | 1658444 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|2272141558|ref|XM_049314591.1| | 1658444 | g25757 | i0 | 100 | 0.263888888888889 | 29 | 0 | 13 | 0 | 82 | 110 | 1522 | 1494 | Wardomyces moseri uncharacterized protein (JN550_003212), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Neoarthrinium | Neoarthrinium moseri |
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);;