contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 393500 | 393500 | PRJNA345071_P_NODE_821_length_572_cov_3.070140_g781_i0 | PRJNA345071 | 821 | 572 | 3.07014 | 17.5612008 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 182 | 6.9e-41 | NTclustered | gi|1022848639|ref|XM_016414822.1| | 1130832 | g781 | i0 | 82.381 | 17.9947552447552 | 210 | 35 | 37 | 2 | 273 | 481 | 710 | 502 | Rhodotorula toruloides NP11 protein of 14-3-3 protein family (RHTO_01139), partial mRNA | blastn | 10293 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 1070371 | 1070371 | PRJNA345071_P_NODE_3621_length_324_cov_1.223108_g3581_i0 | PRJNA345071 | 3621 | 324 | 1.223108 | 3.96286992 | Ustilaginaceae | 5268 | Fungi | Fungi | 438 | 2e-118 | NTclustered | gi|955492899|ref|XM_014801655.1| | 84753 | g3581 | i0 | 91.049 | 95.8302469135803 | 324 | 29 | 100 | 0 | 1 | 324 | 1636 | 1313 | Moesziomyces antarcticus ATP synthase F1 beta subunit (PAN0_006c3013), partial mRNA | blastn | 31049 | 440 | 0.995454545454545 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 2944117 | 2944117 | PRJNA345071_P_NODE_9423_length_246_cov_2.069364_g9383_i0 | PRJNA345071 | 9423 | 246 | 2.069364 | 5.09063544 | Cintractia axicola | 63370 | Fungi | Fungi | 339 | 1.5199999999999998e-88 | NTclustered | gi|108885434|gb|DQ631910.1| | 63370 | g9383 | i0 | 91.463 | 98.9390243902439 | 246 | 21 | 100 | 0 | 1 | 246 | 691 | 936 | Cintractia axicola translation elongation factor 1-alpha (tef1) gene, partial cds | blastn | 24339 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Cintractia | Cintractia axicola | |
| 5497020 | 5497020 | PRJNA345071_P_NODE_5965_length_274_cov_2.203980_g5925_i0 | PRJNA345071 | 5965 | 274 | 2.20398 | 6.0389052 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 224 | 5.04e-54 | NTclustered | gi|630970389|ref|XM_007883412.1| | 1277687 | g5925 | i0 | 91.411 | 7.44890510948905 | 163 | 14 | 59 | 0 | 112 | 274 | 429 | 267 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_05876), partial mRNA | blastn | 2041 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 6770870 | 6770870 | PRJNA345071_P_NODE_10306_length_244_cov_0.865497_g10266_i0 | PRJNA345071 | 10306 | 244 | 0.865497 | 2.11181268 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 111 | 3.58e-20 | NTclustered | gi|2669730650|ref|XM_062769030.1| | 143232 | g10266 | i0 | 91.358 | 0.836065573770492 | 81 | 7 | 33 | 0 | 164 | 244 | 2001 | 1921 | Vanrija pseudolonga Dynamin-related protein DNM1 (DNM1), mRNA | blastn | 204 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 8046729 | 8046729 | PRJNA345071_P_NODE_9067_length_248_cov_0.891429_g9027_i0 | PRJNA345071 | 9067 | 248 | 0.891429 | 2.21074392 | Malassezia japonica | 223818 | Fungi | Fungi | 292 | 1.21e-74 | NTclustered | gi|2594593033|ref|XM_060267470.1| | 223818 | g9027 | i0 | 87.952 | 43.6411290322581 | 249 | 28 | 100 | 2 | 1 | 248 | 1993 | 1746 | Malassezia japonica uncharacterized protein (MJAP1_003542), partial mRNA | blastn | 10823 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 10597112 | 10597112 | PRJNA345071_P_NODE_5689_length_279_cov_1.514563_g5649_i0 | PRJNA345071 | 5689 | 279 | 1.514563 | 4.22563077 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 405 | 1.71e-108 | NTclustered | gi|630967047|ref|XM_007881741.1| | 1277687 | g5649 | i0 | 92.832 | 41.1827956989247 | 279 | 20 | 100 | 0 | 1 | 279 | 340 | 62 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_04218), partial mRNA | blastn | 11490 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 11872041 | 11872041 | PRJNA345071_P_NODE_7390_length_255_cov_1.648352_g7350_i0 | PRJNA345071 | 7390 | 255 | 1.648352 | 4.2032976 | Kwoniella heveanensis | 89924 | Fungi | Fungi | 62.1 | 3.85e-5 | NTclustered | gi|2678478526|gb|CP144517.1| | 1296119 | g7350 | i0 | 93.023 | 0.168627450980392 | 43 | 2 | 17 | 1 | 73 | 115 | 689920 | 689879 | Kwoniella heveanensis CBS 569 chromosome 4 | blastn | 43 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 11872067 | 11872067 | PRJNA345071_P_NODE_8890_length_248_cov_1.702857_g8850_i0 | PRJNA345071 | 8890 | 248 | 1.702857 | 4.22308536 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 244 | 3.45e-60 | NTclustered | gi|630959923|ref|XM_007878179.1| | 1277687 | g8850 | i0 | 89.583 | 28.9395161290323 | 192 | 20 | 77 | 0 | 10 | 201 | 192 | 1 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_06834), partial mRNA | blastn | 7177 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 15696093 | 15696093 | PRJNA345071_P_NODE_8653_length_249_cov_0.886364_g8613_i0 | PRJNA345071 | 8653 | 249 | 0.886364 | 2.20704636 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 254 | 5.76e-63 | NTclustered | gi|630970465|ref|XM_007883450.1| | 1277687 | g8613 | i0 | 85.774 | 4.27309236947791 | 239 | 34 | 96 | 0 | 11 | 249 | 642 | 404 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_05915), partial mRNA | blastn | 1064 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 15696104 | 15696104 | PRJNA345071_P_NODE_9393_length_247_cov_0.879310_g9353_i0 | PRJNA345071 | 9393 | 247 | 0.87931 | 2.1718957 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 320 | 5.54e-83 | NTclustered | gi|630960997|ref|XM_007878716.1| | 1277687 | g9353 | i0 | 90.496 | 96.4615384615385 | 242 | 23 | 98 | 0 | 1 | 242 | 43 | 284 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_01213), partial mRNA | blastn | 23826 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 16970616 | 16970616 | PRJNA345071_P_NODE_10434_length_243_cov_0.917647_g10394_i0 | PRJNA345071 | 10434 | 243 | 0.917647 | 2.22988221 | Malassezia globosa | 76773 | Fungi | Fungi | 422 | 1.45e-113 | NTclustered | gi|164663104|ref|XM_001732622.1| | 425265 | g10394 | i0 | 97.942 | 1 | 243 | 5 | 100 | 0 | 1 | 243 | 2410 | 2168 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0449), partial mRNA | blastn | 243 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16970739 | 16970739 | PRJNA345071_P_NODE_5134_length_288_cov_1.958140_g5094_i0 | PRJNA345071 | 5134 | 288 | 1.95814 | 5.6394432 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 346 | 1.09e-90 | NTclustered | gi|808375450|ref|XM_012337222.1| | 1305764 | g5094 | i0 | 88.732 | 81.6493055555556 | 284 | 30 | 98 | 2 | 6 | 288 | 1 | 283 | Pseudozyma hubeiensis SY62 hypothetical protein partial mRNA | blastn | 23515 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 20794716 | 20794716 | PRJNA345071_P_NODE_3037_length_344_cov_1.151292_g2997_i0 | PRJNA345071 | 3037 | 344 | 1.151292 | 3.96044448 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 375 | 1.7e-99 | NTclustered | gi|630970273|ref|XM_007883354.1| | 1277687 | g2997 | i0 | 86.455 | 5.78488372093023 | 347 | 41 | 100 | 5 | 1 | 344 | 1503 | 1160 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_05816), partial mRNA | blastn | 1990 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 20794742 | 20794742 | PRJNA345071_P_NODE_4357_length_304_cov_0.978355_g4317_i0 | PRJNA345071 | 4357 | 304 | 0.978355 | 2.9741992 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 407 | 5.25e-109 | NTclustered | gi|630959635|ref|XM_007878035.1| | 1277687 | g4317 | i0 | 90.789 | 78.8092105263158 | 304 | 28 | 100 | 0 | 1 | 304 | 441 | 138 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_00541), partial mRNA | blastn | 23958 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 20794773 | 20794773 | PRJNA345071_P_NODE_5597_length_281_cov_1.105769_g5557_i0 | PRJNA345071 | 5597 | 281 | 1.105769 | 3.10721089 | Jaminaea rosea | 1569628 | Fungi | Fungi | 215 | 3.12e-51 | NTclustered | gi|1418908460|ref|XM_025504106.1| | 1569628 | g5557 | i0 | 85.577 | 6.87544483985765 | 208 | 26 | 73 | 4 | 49 | 254 | 233 | 28 | Jaminaea rosea 60s ribosomal protein l34-b (BDZ90DRAFT_211350), partial mRNA | blastn | 1932 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea | ||
| 20794864 | 20794864 | PRJNA345071_P_NODE_9657_length_246_cov_0.901734_g9617_i0 | PRJNA345071 | 9657 | 246 | 0.901734 | 2.21826564 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 222 | 1.5999999999999996e-53 | NTclustered | gi|955498713|ref|XM_014803333.1| | 84753 | g9617 | i0 | 83.544 | 2.73577235772358 | 237 | 39 | 96 | 0 | 1 | 237 | 942 | 706 | Moesziomyces antarcticus 5'-3' exoribonuclease (PAN0_002d1166), partial mRNA | blastn | 673 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 22747331 | 22747331 | PRJNA345071_P_NODE_9178_length_247_cov_1.620690_g9138_i0 | PRJNA345071 | 9178 | 247 | 1.62069 | 4.0031043 | Ustilaginaceae | 5268 | Fungi | Fungi | 250 | 7.38e-62 | NTclustered | gi|955490276|ref|XM_014800859.1| | 84753 | g9138 | i0 | 85.417 | 24.7165991902834 | 240 | 35 | 97 | 0 | 6 | 245 | 1992 | 1753 | Moesziomyces antarcticus bifunctional enzyme with catalase and broad-spectrum peroxidase activity (PAN0_009d3900), partial mRNA | blastn | 6105 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 23345371 | 23345371 | PRJNA345071_P_NODE_8799_length_249_cov_0.886364_g8759_i0 | PRJNA345071 | 8799 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 1.47e-123 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g8759 | i0 | 99.598 | 82.9236947791165 | 249 | 1 | 100 | 0 | 1 | 249 | 3068 | 3316 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 20648 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24619609 | 24619609 | PRJNA345071_P_NODE_7960_length_252_cov_0.871508_g7920_i0 | PRJNA345071 | 7960 | 252 | 0.871508 | 2.19620016 | Mycosarcoma maydis | 5270 | Fungi | Fungi | 147 | 1.02e-30 | NTclustered | gi|758979010|ref|XM_011391253.1| | 5270 | g7920 | i0 | 90.179 | 35.1269841269841 | 112 | 11 | 44 | 0 | 141 | 252 | 162 | 51 | Mycosarcoma maydis 40S ribosomal protein uS14 (UMAG_11499), partial mRNA | blastn | 8852 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis |
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);;