contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB12982" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3847184 | 3847184 | PRJEB12982_P_NODE_19264_length_164_cov_0.886957_g19101_i0 | PRJEB12982 | 19264 | 164 | 0.886957 | 1.45460948 | Malassezia globosa | 76773 | Fungi | Fungi | 292 | 7.41e-75 | NTclustered | gi|164656396|ref|XM_001729274.1| | 425265 | g19101 | i0 | 98.78 | 1 | 164 | 2 | 100 | 0 | 1 | 164 | 1127 | 964 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3361), partial mRNA | blastn | 164 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7673286 | 7673286 | PRJEB12982_P_NODE_9167_length_235_cov_1.198925_g9004_i0 | PRJEB12982 | 9167 | 235 | 1.198925 | 2.81747375 | Rhodotorula graminis | 29898 | Fungi | Fungi | 86.1 | 2.08e-12 | NTclustered | gi|1069928810|ref|XM_018412327.1| | 578459 | g9004 | i0 | 79.675 | 0.523404255319149 | 123 | 21 | 51 | 4 | 115 | 235 | 326 | 206 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_16612), partial mRNA | blastn | 123 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 8947847 | 8947847 | PRJEB12982_P_NODE_13068_length_194_cov_1.041379_g12905_i0 | PRJEB12982 | 13068 | 194 | 1.041379 | 2.02027526 | Cystobasidium minutum | 29899 | Fungi | Fungi | 139 | 1.25e-28 | NTclustered | gi|2781599917|ref|XM_066965340.1| | 1397322 | g12905 | i0 | 80 | 33.0824742268041 | 195 | 33 | 99 | 6 | 1 | 192 | 610 | 419 | Cystobasidium minutum MCA 4210 40S ribosomal protein uS17 (P389DRAFT_169178), mRNA | blastn | 6418 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 8947949 | 8947949 | PRJEB12982_P_NODE_19568_length_163_cov_0.894737_g19405_i0 | PRJEB12982 | 19568 | 163 | 0.894737 | 1.45842131 | Malassezia globosa | 76773 | Fungi | Fungi | 296 | 5.68e-76 | NTclustered | gi|164659983|ref|XM_001731064.1| | 425265 | g19405 | i0 | 99.387 | 1 | 163 | 1 | 100 | 0 | 1 | 163 | 39 | 201 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2115), partial mRNA | blastn | 163 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 8947950 | 8947950 | PRJEB12982_P_NODE_19628_length_163_cov_0.894737_g19465_i0 | PRJEB12982 | 19628 | 163 | 0.894737 | 1.45842131 | Puccinia striiformis | 27350 | Fungi | Fungi | 89.8 | 1.04e-13 | NTclustered | gi|2234886149|ref|XM_047944131.1| | 168172 | g19465 | i0 | 82.407 | 8.38036809815951 | 108 | 13 | 64 | 3 | 50 | 154 | 1065 | 961 | Puccinia striiformis f. sp. tritici uncharacterized protein (Pst134EA_007722), mRNA | blastn | 1366 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 10223737 | 10223737 | PRJEB12982_P_NODE_20209_length_162_cov_0.902655_g20046_i0 | PRJEB12982 | 20209 | 162 | 0.902655 | 1.4623011 | Kwoniella dendrophila | 4975 | Fungi | Fungi | 119 | 1.31e-22 | NTclustered | gi|2752974703|ref|XM_066215994.1| | 1295534 | g20046 | i0 | 90.909 | 18.0185185185185 | 88 | 8 | 54 | 0 | 71 | 158 | 321 | 408 | Kwoniella dendrophila CBS 6074 peptidyl-prolyl cis-trans isomerase (L201_000191), partial mRNA | blastn | 2919 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dendrophila | |
| 15323180 | 15323180 | PRJEB12982_P_NODE_2993_length_444_cov_3.225316_g2832_i0 | PRJEB12982 | 2993 | 444 | 3.225316 | 14.32040304 | Rhodotorula graminis | 29898 | Fungi | Fungi | 329 | 1.77e-85 | NTclustered | gi|1069924879|ref|XM_018414273.1| | 578459 | g2832 | i0 | 82.632 | 40.8828828828829 | 380 | 58 | 85 | 7 | 1 | 376 | 412 | 37 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_43715), partial mRNA | blastn | 18152 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 16288373 | 16288373 | PRJEB12982_P_NODE_14873_length_180_cov_1.145038_g14710_i0 | PRJEB12982 | 14873 | 180 | 1.145038 | 2.0610684 | Fungi | 4751 | Fungi | Fungi | 298 | 1.78e-76 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g14710 | i0 | 98.235 | 92.2333333333333 | 170 | 3 | 94 | 0 | 1 | 170 | 3177 | 3008 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 16602 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16597775 | 16597775 | PRJEB12982_P_NODE_18474_length_165_cov_0.879310_g18311_i0 | PRJEB12982 | 18474 | 165 | 0.87931 | 1.4508615 | Meira miltonrushii | 1280837 | Fungi | Fungi | 239 | 9.87e-59 | NTclustered | gi|1418864365|ref|XM_025498433.1| | 1280837 | g18311 | i0 | 95.333 | 1.18787878787879 | 150 | 7 | 91 | 0 | 1 | 150 | 719 | 868 | Meira miltonrushii uncharacterized protein (FA14DRAFT_159882), mRNA | blastn | 196 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 16597788 | 16597788 | PRJEB12982_P_NODE_19134_length_164_cov_0.886957_g18971_i0 | PRJEB12982 | 19134 | 164 | 0.886957 | 1.45460948 | Meira miltonrushii | 1280837 | Fungi | Fungi | 243 | 7.57e-60 | NTclustered | gi|1418867743|ref|XM_025497293.1| | 1280837 | g18971 | i0 | 94.34 | 8.01829268292683 | 159 | 8 | 97 | 1 | 1 | 159 | 250 | 93 | Meira miltonrushii putative heat shock 70 kd protein 2 (FA14DRAFT_145849), mRNA | blastn | 1315 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 16597796 | 16597796 | PRJEB12982_P_NODE_19654_length_163_cov_0.894737_g19491_i0 | PRJEB12982 | 19654 | 163 | 0.894737 | 1.45842131 | Meira miltonrushii | 1280837 | Fungi | Fungi | 246 | 5.8099999999999995e-61 | NTclustered | gi|1418867021|ref|XM_025502324.1| | 1280837 | g19491 | i0 | 93.865 | 1 | 163 | 10 | 100 | 0 | 1 | 163 | 1766 | 1604 | Meira miltonrushii putative PMA1-H+-transporting P-type ATPase (FA14DRAFT_42254), mRNA | blastn | 163 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 17872571 | 17872571 | PRJEB12982_P_NODE_18155_length_165_cov_0.879310_g17992_i0 | PRJEB12982 | 18155 | 165 | 0.87931 | 1.4508615 | Malassezia restricta | 76775 | Fungi | Fungi | 281 | 1.62e-71 | NTclustered | gi|1546636681|ref|XM_027629983.1| | 76775 | g17992 | i0 | 97.561 | 0.993939393939394 | 164 | 4 | 99 | 0 | 1 | 164 | 1521 | 1684 | Malassezia restricta phospholipase C (MRET_3356), partial mRNA | blastn | 164 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19146464 | 19146464 | PRJEB12982_P_NODE_19136_length_164_cov_0.886957_g18973_i0 | PRJEB12982 | 19136 | 164 | 0.886957 | 1.45460948 | Apiotrichum porosum | 105984 | Fungi | Fungi | 93.5 | 8.07e-15 | NTclustered | gi|1607551799|ref|XM_028620856.1| | 105984 | g18973 | i0 | 84.946 | 8.15853658536585 | 93 | 12 | 56 | 2 | 2 | 93 | 338 | 429 | Apiotrichum porosum 40S ribosomal protein S23 (RPS23), partial mRNA | blastn | 1338 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 20421576 | 20421576 | PRJEB12982_P_NODE_16597_length_168_cov_1.285714_g16434_i0 | PRJEB12982 | 16597 | 168 | 1.285714 | 2.15999952 | Cryptococcus wingfieldii | 5619 | Fungi | Fungi | 139 | 1.05e-28 | NTclustered | gi|1102233851|ref|XM_019178392.1| | 1295528 | g16434 | i0 | 82.803 | 30.7559523809524 | 157 | 25 | 93 | 2 | 13 | 168 | 947 | 792 | Tsuchiyaea wingfieldii CBS 7118 S-adenosylmethionine synthase (L198_06326), partial mRNA | blastn | 5167 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus wingfieldii | |
| 20421583 | 20421583 | PRJEB12982_P_NODE_16837_length_167_cov_0.864407_g16674_i0 | PRJEB12982 | 16837 | 167 | 0.864407 | 1.44355969 | Malassezia globosa | 76773 | Fungi | Fungi | 300 | 4.53e-77 | NTclustered | gi|164657803|ref|XM_001729976.1| | 425265 | g16674 | i0 | 100 | 1.77245508982036 | 162 | 0 | 97 | 0 | 5 | 166 | 2496 | 2335 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3014), partial mRNA | blastn | 296 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24246757 | 24246757 | PRJEB12982_P_NODE_18980_length_164_cov_0.886957_g18817_i0 | PRJEB12982 | 18980 | 164 | 0.886957 | 1.45460948 | Puccinia graminis | 5297 | Fungi | Fungi | 165 | 1.69e-36 | NTclustered | gi|403159047|ref|XM_003319663.2| | 418459 | g18817 | i0 | 84.756 | 1 | 164 | 25 | 100 | 0 | 1 | 164 | 2252 | 2415 | Puccinia graminis f. sp. tritici CRL 75-36-700-3 uncharacterized protein (PGTG_01885), partial mRNA | blastn | 164 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis |
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);;