contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022384 | 2022384 | PRJNA770361_P_NODE_17942_length_244_cov_0.912281_g17847_i0 | PRJNA770361 | 17942 | 244 | 0.912281 | 2.22596564 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 257 | 4.35e-64 | NTclustered | gi|1423584520|ref|XM_025742987.1| | 58919 | g17847 | i0 | 85.714 | 99.7991803278689 | 245 | 33 | 100 | 2 | 1 | 244 | 1189 | 946 | Tilletiopsis washingtonensis putative TIF2-translation initiation factor eIF4A (FA09DRAFT_331349), mRNA | blastn | 24351 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 3297484 | 3297484 | PRJNA770361_P_NODE_12643_length_263_cov_1.642105_g12548_i0 | PRJNA770361 | 12643 | 263 | 1.642105 | 4.31873615 | Stereum hirsutum | 40492 | Fungi | Fungi | 87.9 | 6.58e-13 | NTclustered | gi|618805548|ref|XM_007305472.1| | 721885 | g12548 | i0 | 93.22 | 17.1901140684411 | 59 | 4 | 22 | 0 | 84 | 142 | 130 | 72 | Stereum hirsutum FP-91666 SS1 ribosomal protein S25 (STEHIDRAFT_122398), mRNA | blastn | 4521 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 7584452 | 7584452 | PRJNA770361_P_NODE_8506_length_323_cov_0.908000_g8411_i0 | PRJNA770361 | 8506 | 323 | 0.908 | 2.93284 | Physalacriaceae | 862241 | Fungi | Fungi | 558 | 1.47e-154 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g8411 | i0 | 97.833 | 99.8297213622291 | 323 | 7 | 100 | 0 | 1 | 323 | 958 | 636 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 32245 | 558 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 9674705 | 9674705 | PRJNA770361_P_NODE_12428_length_266_cov_1.367876_g12333_i0 | PRJNA770361 | 12428 | 266 | 1.367876 | 3.63855016 | Stereum hirsutum | 40492 | Fungi | Fungi | 165 | 2.99e-36 | NTclustered | gi|597905899|ref|XM_007300187.1| | 721885 | g12333 | i0 | 85.897 | 43.6203007518797 | 156 | 20 | 58 | 2 | 11 | 165 | 363 | 209 | Stereum hirsutum FP-91666 SS1 uncharacterized protein (STEHIDRAFT_91708), mRNA | blastn | 11603 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 9674725 | 9674725 | PRJNA770361_P_NODE_13648_length_253_cov_0.866667_g13553_i0 | PRJNA770361 | 13648 | 253 | 0.866667 | 2.19266751 | Meripilus lineatus | 2056292 | Fungi | Fungi | 444 | 3.24e-120 | NTclustered | gi|2872142164|gb|PQ541132.1| | 2056292 | g13553 | i0 | 98.419 | 97.1462450592885 | 253 | 3 | 100 | 1 | 1 | 253 | 55195 | 55446 | Physisporinus lineatus voucher FGRC-2022.00.29-Physiline chloroplast, complete genome | blastn | 24578 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meripilaceae | Meripilus | Meripilus lineatus | |
| 10950295 | 10950295 | PRJNA770361_P_NODE_10089_length_297_cov_1.044643_g9994_i0 | PRJNA770361 | 10089 | 297 | 1.044643 | 3.10258971 | Trichosporon asahii | 82508 | Fungi | Fungi | 137 | 7.4e-28 | NTclustered | gi|930413864|ref|XM_014325730.1| | 1186058 | g9994 | i0 | 91.919 | 29.3131313131313 | 99 | 6 | 33 | 2 | 162 | 259 | 729 | 632 | Trichosporon asahii var. asahii CBS 2479 L-malate dehydrogenase (A1Q1_00830), partial mRNA | blastn | 8706 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 12226114 | 12226114 | PRJNA770361_P_NODE_2790_length_567_cov_1.578947_g2696_i0 | PRJNA770361 | 2790 | 567 | 1.578947 | 8.95262949 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 348 | 6.370000000000001e-91 | NTclustered | gi|1023187593|ref|XM_016439311.1| | 1365824 | g2696 | i0 | 79.917 | 70.1552028218695 | 483 | 89 | 84 | 8 | 79 | 557 | 13 | 491 | Kalmanozyma brasiliensis GHG001 Heat shock protein Hsp90 family (PSEUBRA_005931), partial mRNA | blastn | 39778 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 13500209 | 13500209 | PRJNA770361_P_NODE_5971_length_384_cov_1.504823_g5876_i0 | PRJNA770361 | 5971 | 384 | 1.504823 | 5.77852032 | Coniophora puteana | 80637 | Fungi | Fungi | 195 | 5.75e-45 | NTclustered | gi|628844737|ref|XM_007773228.1| | 741705 | g5876 | i0 | 80.385 | 21.609375 | 260 | 47 | 67 | 4 | 112 | 369 | 387 | 130 | Coniophora puteana RWD-64-598 SS2 uncharacterized protein (CONPUDRAFT_108225), mRNA | blastn | 8298 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Coniophoraceae | Coniophora | Coniophora puteana | |
| 14775274 | 14775274 | PRJNA770361_P_NODE_17892_length_244_cov_0.912281_g17797_i0 | PRJNA770361 | 17892 | 244 | 0.912281 | 2.22596564 | Laetiporus sulphureus | 5630 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2028120268|ref|XM_040913704.1| | 1314785 | g17797 | i0 | 100 | 0.241803278688525 | 30 | 0 | 12 | 0 | 101 | 130 | 155 | 126 | Laetiporus sulphureus 93-53 uncharacterized protein (LAESUDRAFT_765516), partial mRNA | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Laetiporaceae | Laetiporus | Laetiporus sulphureus | |
| 16509278 | 16509278 | PRJNA770361_P_NODE_14873_length_250_cov_1.655367_g14778_i0 | PRJNA770361 | 14873 | 250 | 1.655367 | 4.1384175 | Opisthokonta | 33154 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|1372283070|ref|XM_024480964.1| | 670580 | g14778 | i0 | 100 | 0.448 | 28 | 0 | 11 | 0 | 72 | 99 | 2092 | 2065 | Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1057860), partial mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Adustoporiaceae | Rhodonia | Rhodonia placenta |
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);;