contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873689 | 873689 | PRJNA897077_P_NODE_19801_length_242_cov_0.923077_g19674_i0 | PRJNA897077 | 19801 | 242 | 0.923077 | 2.23384634 | Cryptococcus neoformans | 5207 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|2491063187|gb|CP122427.1| | 5207 | g19674 | i0 | 100 | 5.78099173553719 | 242 | 0 | 100 | 0 | 1 | 242 | 1323679 | 1323920 | Cryptococcus neoformans isolate IUM96-2828 | blastn | 1399 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 3796078 | 3796078 | PRJNA897077_P_NODE_18203_length_246_cov_0.901734_g18076_i0 | PRJNA897077 | 18203 | 246 | 0.901734 | 2.21826564 | Cryptococcus | 5206 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|2491063213|gb|CP122433.1| | 5207 | g18076 | i0 | 100 | 7.95934959349593 | 246 | 0 | 100 | 0 | 1 | 246 | 252723 | 252968 | Cryptococcus neoformans isolate IUM96-2828 | blastn | 1958 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 4702181 | 4702181 | PRJNA897077_P_NODE_16844_length_249_cov_0.886364_g16717_i0 | PRJNA897077 | 16844 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 1.47e-123 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g16717 | i0 | 99.598 | 72.1566265060241 | 249 | 1 | 100 | 0 | 1 | 249 | 3034 | 3282 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17967 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7622173 | 7622173 | PRJNA897077_P_NODE_17986_length_246_cov_1.803468_g17859_i0 | PRJNA897077 | 17986 | 246 | 1.803468 | 4.43653128 | Cystobasidium | 203525 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|1708295083|gb|MN218620.1| | 106018 | g17859 | i0 | 100 | 99.4674796747967 | 246 | 0 | 100 | 0 | 1 | 246 | 587 | 342 | Cystobasidium slooffiae clone Y6_NL1 large subunit ribosomal RNA gene, partial sequence | blastn | 24469 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium slooffiae | |
| 8526313 | 8526313 | PRJNA897077_P_NODE_11767_length_288_cov_17.809302_g11640_i0 | PRJNA897077 | 11767 | 288 | 17.809302 | 51.29078976 | Pleurotus ostreatus | 5322 | Fungi | Fungi | 532 | 7.8e-147 | NTclustered | gi|1859735590|gb|MT644908.1| | 5322 | g11640 | i0 | 100 | 106.604166666667 | 288 | 0 | 100 | 0 | 1 | 288 | 5331 | 5618 | Pleurotus ostreatus isolate DM1049 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 | 30702 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 8526426 | 8526426 | PRJNA897077_P_NODE_17427_length_248_cov_0.891429_g17300_i0 | PRJNA897077 | 17427 | 248 | 0.891429 | 2.21074392 | Auricularia villosula | 1579976 | Fungi | Fungi | 387 | 5.409999999999998e-103 | NTclustered | gi|2258688624|ref|NC_064342.1| | 1579976 | g17300 | i0 | 95.455 | 1.84677419354839 | 242 | 11 | 98 | 0 | 7 | 248 | 192551 | 192310 | Auricularia villosula mitochondrion, complete genome | blastn | 458 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia villosula | |
| 9801484 | 9801484 | PRJNA897077_P_NODE_18268_length_246_cov_0.901734_g18141_i0 | PRJNA897077 | 18268 | 246 | 0.901734 | 2.21826564 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 62.1 | 3.69e-5 | NTclustered | gi|1418631245|ref|XM_025492137.1| | 1684307 | g18141 | i0 | 89.796 | 1.51219512195122 | 49 | 4 | 20 | 1 | 96 | 143 | 1668 | 1620 | Pseudomicrostroma glucosiphilum hypothetical protein (BCV69DRAFT_281849), mRNA | blastn | 372 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum | ||
| 12723731 | 12723731 | PRJNA897077_P_NODE_7730_length_351_cov_6.032374_g7603_i0 | PRJNA897077 | 7730 | 351 | 6.032374 | 21.17363274 | Agaricomycetes | 155619 | Fungi | Fungi | 643 | 4.3e-180 | NTclustered | gi|2914276321|gb|PV130381.1| | 5322 | g7603 | i0 | 99.715 | 99.968660968661 | 351 | 1 | 100 | 0 | 1 | 351 | 607 | 957 | Pleurotus ostreatus culture VKM:F 3588 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 | 35089 | 643 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 14901633 | 14901633 | PRJNA897077_P_NODE_19572_length_243_cov_0.917647_g19445_i0 | PRJNA897077 | 19572 | 243 | 0.917647 | 2.22988221 | Cutaneotrichosporon oleaginosum | 879819 | Fungi | Fungi | 337 | 5.399999999999998e-88 | NTclustered | gi|2741446400|ref|XM_018426414.2| | 879819 | g19445 | i0 | 91.736 | 1.97530864197531 | 242 | 20 | 99 | 0 | 2 | 243 | 428 | 187 | Cutaneotrichosporon oleaginosum uncharacterized protein (COLE_02343), partial mRNA | blastn | 480 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon oleaginosum | |
| 14901709 | 14901709 | PRJNA897077_P_NODE_5152_length_428_cov_1.532394_g5025_i0 | PRJNA897077 | 5152 | 428 | 1.532394 | 6.55864632 | Rhodonia placenta | 104341 | Fungi | Fungi | 54.7 | 0.011 | NTclustered | gi|1372293348|ref|XM_024487651.1| | 670580 | g5025 | i0 | 100 | 0.0677570093457944 | 29 | 0 | 7 | 0 | 389 | 417 | 122 | 150 | Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1161136), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Adustoporiaceae | Rhodonia | Rhodonia placenta | |
| 18725074 | 18725074 | PRJNA897077_P_NODE_17175_length_248_cov_1.548571_g17048_i0 | PRJNA897077 | 17175 | 248 | 1.548571 | 3.84045608 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 270 | 5.69e-68 | NTclustered | gi|2669730516|ref|XM_062769006.1| | 143232 | g17048 | i0 | 86.29 | 1 | 248 | 34 | 100 | 0 | 1 | 248 | 345 | 592 | Vanrija pseudolonga uncharacterized protein (LOC62_02G002496), partial mRNA | blastn | 248 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 23825834 | 23825834 | PRJNA897077_P_NODE_2619_length_593_cov_2.901923_g2492_i0 | PRJNA897077 | 2619 | 593 | 2.901923 | 17.20840339 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 348 | 6.68e-91 | NTclustered | gi|1423587035|ref|XM_025743209.1| | 58919 | g2492 | i0 | 80.388 | 25.2360876897133 | 464 | 85 | 78 | 6 | 119 | 579 | 55 | 515 | Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA | blastn | 14965 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 25099653 | 25099653 | PRJNA897077_P_NODE_19980_length_242_cov_0.923077_g19853_i0 | PRJNA897077 | 19980 | 242 | 0.923077 | 2.23384634 | Malassezia restricta | 76775 | Fungi | Fungi | 401 | 1.8799999999999994e-107 | NTclustered | gi|1546635378|ref|XM_027629348.1| | 76775 | g19853 | i0 | 98.673 | 0.933884297520661 | 226 | 3 | 93 | 0 | 1 | 226 | 226 | 1 | Malassezia restricta enoyl-CoA hydratase/isomerase family (MRET_2721), partial mRNA | blastn | 226 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;