contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3055106 | 3055106 | PRJNA532380_P_NODE_33063_length_162_cov_0.920354_g32738_i0 | PRJNA532380 | 33063 | 162 | 0.920354 | 1.49097348 | Malassezia restricta | 76775 | Fungi | Fungi | 300 | 4.36e-77 | NTclustered | gi|1546634118|ref|XM_027628719.1| | 76775 | g32738 | i0 | 100 | 1 | 162 | 0 | 100 | 0 | 1 | 162 | 464 | 625 | Malassezia restricta peptidyl-prolyl isomerase D (MRET_2092), partial mRNA | blastn | 162 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4945608 | 4945608 | PRJNA532380_P_NODE_12904_length_253_cov_1.215686_g12579_i0 | PRJNA532380 | 12904 | 253 | 1.215686 | 3.07568558 | Agaricales | 5338 | Fungi | Fungi | 412 | 9.14e-111 | NTclustered | gi|544161290|gb|KF192813.1| | 39966 | g12579 | i0 | 97.143 | 97.4150197628458 | 245 | 6 | 97 | 1 | 3 | 247 | 933 | 1176 | Hypsizygus marmoreus strain 1-1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and intergenic spacer, partial sequence | blastn | 24646 | 416 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 6881271 | 6881271 | PRJNA532380_P_NODE_15686_length_228_cov_1.357542_g15361_i0 | PRJNA532380 | 15686 | 228 | 1.357542 | 3.09519576 | Lentinula edodes | 5353 | Fungi | Fungi | 350 | 6.44e-92 | NTclustered | gi|2723225103|dbj|LC813565.1| | 5353 | g15361 | i0 | 94.298 | 102.517543859649 | 228 | 13 | 100 | 0 | 1 | 228 | 724 | 951 | Lentinula edodes BCRC:MU30948 DNA, clone Type1 | blastn | 23374 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 8156971 | 8156971 | PRJNA532380_P_NODE_31647_length_164_cov_0.904348_g31322_i0 | PRJNA532380 | 31647 | 164 | 0.904348 | 1.48313072 | Malassezia restricta | 76775 | Fungi | Fungi | 298 | 1.59e-76 | NTclustered | gi|1546637741|ref|XM_027630512.1| | 76775 | g31322 | i0 | 99.39 | 1 | 164 | 1 | 100 | 0 | 1 | 164 | 1159 | 996 | Malassezia restricta CobW domain protein (MRET_3885), partial mRNA | blastn | 164 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10045944 | 10045944 | PRJNA532380_P_NODE_12288_length_260_cov_1.393365_g11963_i0 | PRJNA532380 | 12288 | 260 | 1.393365 | 3.622749 | Malassezia | 55193 | Fungi | Fungi | 418 | 2.0299999999999994e-112 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g11963 | i0 | 95.769 | 100.115384615385 | 260 | 10 | 100 | 1 | 1 | 260 | 683 | 425 | Malassezia globosa strain 123.1 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 | 26030 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 10708059 | 10708059 | PRJNA532380_P_NODE_30289_length_166_cov_0.888889_g29964_i0 | PRJNA532380 | 30289 | 166 | 0.888889 | 1.47555574 | Lentinula edodes | 5353 | Fungi | Fungi | 279 | 5.86e-71 | NTclustered | gi|2185501240|ref|XM_046228721.1| | 5353 | g29964 | i0 | 96.988 | 49.0240963855422 | 166 | 5 | 100 | 0 | 1 | 166 | 513 | 348 | Lentinula edodes uncharacterized protein (C8R40DRAFT_1119226), mRNA | blastn | 8138 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 11320549 | 11320549 | PRJNA532380_P_NODE_9669_length_300_cov_5.601594_g9344_i0 | PRJNA532380 | 9669 | 300 | 5.601594 | 16.804782 | Malassezia | 55193 | Fungi | Fungi | 555 | 1.7399999999999995e-153 | NTclustered | gi|1101565238|gb|KX808622.1| | 55194 | g9344 | i0 | 100 | 99.9933333333333 | 300 | 0 | 100 | 0 | 1 | 300 | 539 | 240 | Malassezia furfur isolate GDMUZJ2015046 26S ribosomal RNA gene, partial sequence | blastn | 29998 | 555 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 14532897 | 14532897 | PRJNA532380_P_NODE_29812_length_166_cov_0.888889_g29487_i0 | PRJNA532380 | 29812 | 166 | 0.888889 | 1.47555574 | Malassezia globosa | 76773 | Fungi | Fungi | 307 | 2.69e-79 | NTclustered | gi|164655756|ref|XM_001728955.1| | 425265 | g29487 | i0 | 100 | 1 | 166 | 0 | 100 | 0 | 1 | 166 | 1584 | 1419 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3795), partial mRNA | blastn | 166 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16420256 | 16420256 | PRJNA532380_P_NODE_27113_length_169_cov_2.116667_g26788_i0 | PRJNA532380 | 27113 | 169 | 2.116667 | 3.57716723 | Opisthokonta | 33154 | Fungi | Fungi | 313 | 5.859999999999999e-81 | NTclustered | gi|1859980207|gb|MT645548.1| | 76775 | g26788 | i0 | 100 | 99.9704142011834 | 169 | 0 | 100 | 0 | 1 | 169 | 307 | 475 | Malassezia restricta strain RM11 large subunit ribosomal RNA gene, partial sequence | blastn | 16895 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17081457 | 17081457 | PRJNA532380_P_NODE_32834_length_162_cov_1.840708_g32509_i0 | PRJNA532380 | 32834 | 162 | 1.840708 | 2.98194696 | Rhodocollybia asema | 298344 | Fungi | Fungi | 300 | 4.36e-77 | NTclustered | gi|66864424|gb|DQ071803.1| | 298344 | g32509 | i0 | 100 | 100.604938271605 | 162 | 0 | 100 | 0 | 1 | 162 | 471 | 632 | Rhodocollybia asema voucher GLM 46024 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16298 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Rhodocollybia | Rhodocollybia asema | |
| 18968980 | 18968980 | PRJNA532380_P_NODE_20295_length_199_cov_2.266667_g19970_i0 | PRJNA532380 | 20295 | 199 | 2.266667 | 4.51066733 | Rhodocollybia | 71917 | Fungi | Fungi | 357 | 3.2699999999999996e-94 | NTclustered | gi|284468613|gb|GU328560.1| | 175244 | g19970 | i0 | 98.995 | 100.05527638191 | 199 | 2 | 100 | 0 | 1 | 199 | 1130 | 932 | Uncultured Basidiomycota clone man41_soil_C11 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 | 19911 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | uncultured Basidiomycota | |||||
| 19630278 | 19630278 | PRJNA532380_P_NODE_7456_length_349_cov_4.750000_g7131_i0 | PRJNA532380 | 7456 | 349 | 4.75 | 16.5775 | Malassezia restricta | 76775 | Fungi | Fungi | 477 | 4.589999999999999e-130 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g7131 | i0 | 92 | 89.5931232091691 | 350 | 13 | 100 | 11 | 1 | 349 | 3308 | 2973 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 31268 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20906109 | 20906109 | PRJNA532380_P_NODE_29177_length_167_cov_0.881356_g28852_i0 | PRJNA532380 | 29177 | 167 | 0.881356 | 1.47186452 | Malassezia globosa | 76773 | Fungi | Fungi | 303 | 3.5e-78 | NTclustered | gi|164661746|ref|XM_001731944.1| | 425265 | g28852 | i0 | 99.401 | 1.86826347305389 | 167 | 1 | 100 | 0 | 1 | 167 | 204 | 38 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_1264), partial mRNA | blastn | 312 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20906141 | 20906141 | PRJNA532380_P_NODE_30237_length_166_cov_0.888889_g29912_i0 | PRJNA532380 | 30237 | 166 | 0.888889 | 1.47555574 | Malassezia restricta | 76775 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|1546635592|ref|XR_003525361.1| | 76775 | g29912 | i0 | 96.774 | 0.186746987951807 | 31 | 1 | 19 | 0 | 95 | 125 | 88 | 58 | Malassezia restricta ribonuclease MRP RNA (MRET_nc0004), RNase_MRP_RNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22794695 | 22794695 | PRJNA532380_P_NODE_9238_length_308_cov_6.907336_g8913_i0 | PRJNA532380 | 9238 | 308 | 6.907336 | 21.27459488 | Malassezia | 55193 | Fungi | Fungi | 569 | 6.419999999999998e-158 | NTclustered | gi|724086716|gb|KM269140.1| | 76773 | g8913 | i0 | 100 | 99.3246753246753 | 308 | 0 | 100 | 0 | 1 | 308 | 1196 | 889 | Malassezia globosa strain 123.1 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 | 30592 | 569 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;