contig_metadata
15 rows where bioproject = "PRJNA695140" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3227080 | 3227080 | PRJNA695140_S_NODE_4103_length_258_cov_2.687783_g3922_i0 | PRJNA695140 | 4103 | 258 | 2.687783 | 6.93448014 | uncultured fungus | 175245 | Fungi | Fungi | 182 | 2.87e-41 | NTclustered | gi|2159203179|emb|OU941607.1| | 175245 | g3922 | i0 | 79.845 | 32.4496124031008 | 258 | 45 | 99 | 4 | 3 | 258 | 613 | 865 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02900 | blastn | 8372 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 5779612 | 5779612 | PRJNA695140_S_NODE_4705_length_242_cov_1.287805_g4524_i0 | PRJNA695140 | 4705 | 242 | 1.287805 | 3.1164881 | uncultured fungus | 175245 | Fungi | Fungi | 250 | 7.2e-62 | NTclustered | gi|2159201594|emb|OU940628.1| | 175245 | g4524 | i0 | 85.772 | 2.02892561983471 | 246 | 24 | 100 | 8 | 1 | 242 | 674 | 912 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01921 | blastn | 491 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7054687 | 7054687 | PRJNA695140_S_NODE_2026_length_369_cov_15.246988_g1845_i0 | PRJNA695140 | 2026 | 369 | 15.246988 | 56.26138572 | uncultured fungus | 175245 | Fungi | Fungi | 638 | 2.1199999999999997e-178 | NTclustered | gi|2159203857|emb|OU942259.1| | 175245 | g1845 | i0 | 99.153 | 74.5040650406504 | 354 | 3 | 96 | 0 | 15 | 368 | 653 | 1006 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03553 | blastn | 27492 | 638 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7054715 | 7054715 | PRJNA695140_S_NODE_4346_length_251_cov_3.981308_g4165_i0 | PRJNA695140 | 4346 | 251 | 3.981308 | 9.99308308 | uncultured fungus | 175245 | Fungi | Fungi | 383 | 7.099999999999999e-102 | NTclustered | gi|2159204267|emb|OU942669.1| | 175245 | g4165 | i0 | 94.779 | 91.5856573705179 | 249 | 8 | 99 | 3 | 1 | 249 | 1237 | 1480 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03962 | blastn | 22988 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7559452 | 7559452 | PRJNA695140_S_NODE_5386_length_226_cov_3.814815_g5205_i0 | PRJNA695140 | 5386 | 226 | 3.814815 | 8.6214819 | Eukaryota | 2759 | Fungi | Fungi | 268 | 1.83e-67 | NTclustered | gi|511488219|gb|JX898639.1| | 175245 | g5205 | i0 | 88.991 | 41.5884955752212 | 218 | 22 | 96 | 1 | 1 | 218 | 274 | 489 | Uncultured fungus clone BME_D02-15 28S ribosomal RNA gene, partial sequence | blastn | 9399 | 270 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 9604563 | 9604563 | PRJNA695140_S_NODE_2668_length_319_cov_25.539007_g2487_i0 | PRJNA695140 | 2668 | 319 | 25.539007 | 81.46943233 | uncultured fungus | 175245 | Fungi | Fungi | 200 | 1.0099999999999999e-46 | NTclustered | gi|2159200592|emb|OU939208.1| | 175245 | g2487 | i0 | 87.222 | 54.2727272727273 | 180 | 18 | 56 | 5 | 141 | 319 | 721 | 896 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus00502 | blastn | 17313 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 12660915 | 12660915 | PRJNA695140_S_NODE_13250_length_150_cov_1.380531_g13069_i0 | PRJNA695140 | 13250 | 150 | 1.380531 | 2.0707965 | Malassezia | 55193 | Fungi | Fungi | 63.9 | 5.64e-6 | NTclustered | gi|2105650794|gb|MW683313.1| | 55194 | g13069 | i0 | 97.297 | 24.4133333333333 | 37 | 1 | 25 | 0 | 40 | 76 | 911 | 875 | Malassezia furfur strain CBS 9365 mitochondrion, complete genome | blastn | 3662 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 13935513 | 13935513 | PRJNA695140_S_NODE_3131_length_296_cov_2.189189_g2950_i0 | PRJNA695140 | 3131 | 296 | 2.189189 | 6.47999944 | Opisthokonta | 33154 | Fungi | Fungi | 65.8 | 3.53e-6 | NTclustered | gi|1546630317|ref|XM_027626819.1| | 76775 | g2950 | i0 | 97.368 | 1.38513513513514 | 38 | 1 | 13 | 0 | 12 | 49 | 1378 | 1341 | Malassezia restricta alpha 1,2-mannosyltransferase (MRET_0192), partial mRNA | blastn | 410 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14705081 | 14705081 | PRJNA695140_S_NODE_3432_length_282_cov_1.510204_g3251_i0 | PRJNA695140 | 3432 | 282 | 1.510204 | 4.25877528 | Vittaforma corneae | 42399 | Fungi | Fungi | 115 | 3.27e-21 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g3251 | i0 | 79.762 | 3.21276595744681 | 168 | 26 | 58 | 7 | 38 | 200 | 1512 | 1348 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 906 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 14705137 | 14705137 | PRJNA695140_S_NODE_9892_length_169_cov_2.356061_g9711_i0 | PRJNA695140 | 9892 | 169 | 2.356061 | 3.98174309 | uncultured fungus | 175245 | Fungi | Fungi | 128 | 2.28e-25 | NTclustered | gi|480554577|gb|KC558144.1| | 175245 | g9711 | i0 | 80.702 | 1.97633136094675 | 171 | 27 | 100 | 5 | 1 | 169 | 192 | 26 | Uncultured fungus clone NTS_28S_051A_1_a6 28S ribosomal RNA gene, partial sequence | blastn | 334 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 17253912 | 17253912 | PRJNA695140_S_NODE_1754_length_398_cov_28.096953_g1573_i0 | PRJNA695140 | 1754 | 398 | 28.096953 | 111.82587294 | Neurospora crassa | 5141 | Fungi | Fungi | 56.5 | 0.003 | NTclustered | gi|18376239|emb|AL670009.1| | 5141 | g1573 | i0 | 100 | 0.0753768844221105 | 30 | 0 | 8 | 0 | 14 | 43 | 68475 | 68504 | Neurospora crassa DNA linkage group V cosmid contig 123A4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Neurospora | Neurospora crassa | |
| 19033364 | 19033364 | PRJNA695140_S_NODE_8195_length_184_cov_19.823129_g8014_i0 | PRJNA695140 | 8195 | 184 | 19.823129 | 36.47455736 | Siepmannia | 595254 | Fungi | Fungi | 82.4 | 2e-11 | NTclustered | gi|570963359|gb|KF617961.1| | 175245 | g8014 | i0 | 87.324 | 0.771739130434783 | 71 | 9 | 39 | 0 | 112 | 182 | 297 | 227 | Uncultured fungus clone 3182H8 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 | 142 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 21583790 | 21583790 | PRJNA695140_S_NODE_1877_length_386_cov_8.954155_g1696_i0 | PRJNA695140 | 1877 | 386 | 8.954155 | 34.5630383 | Opisthokonta | 33154 | Fungi | Fungi | 527 | 5.019999999999998e-145 | NTclustered | gi|2159203857|emb|OU942259.1| | 175245 | g1696 | i0 | 91.237 | 97.2668393782383 | 388 | 32 | 100 | 1 | 1 | 386 | 1009 | 1396 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03553 | blastn | 37545 | 527 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 24902366 | 24902366 | PRJNA695140_S_NODE_11740_length_157_cov_3.383333_g11559_i0 | PRJNA695140 | 11740 | 157 | 3.383333 | 5.31183281 | Endoreticulatus sp. CHW-2004 Taiwan | 262393 | Fungi | Fungi | 134 | 4.5e-27 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g11559 | i0 | 97.436 | 8.89808917197452 | 78 | 2 | 50 | 0 | 67 | 144 | 285 | 208 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 1397 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 32580581 | 32580581 | PRJNA695140_S_NODE_4599_length_244_cov_7.024155_g4418_i0 | PRJNA695140 | 4599 | 244 | 7.024155 | 17.1389382 | Valsa sordida | 252740 | Fungi | Fungi | 44.3 | 0.0111 | NR | ROV94177.1 | 252740 | g4418 | i0 | 36.6 | 0.872950819672131 | 71 | 37 | 77.5 | 1 | 205 | 17 | 560 | 630 | ROV94177.1 hypothetical protein VSDG_05709 [Cytospora chrysosperma] | diamond | 213 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora chrysosperma |
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);;