contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA508758" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1760149 | 1760149 | PRJNA508758_P_NODE_862_length_2498_cov_71.421856_g636_i1 | PRJNA508758 | 862 | 2498 | 71.421856 | 1784.11796288 | Pseudocercospora fijiensis | 1873960 | Fungi | Fungi | 60.2 | 0.002 | NTclustered | gi|631388285|ref|XM_007930332.1| | 383855 | g636 | i1 | 94.737 | 0.0152121697357886 | 38 | 2 | 2 | 0 | 1000 | 1037 | 629 | 592 | Pseudocercospora fijiensis CIRAD86 uncharacterized protein (MYCFIDRAFT_166063), mRNA | blastn | 38 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fijiensis | |
| 3035865 | 3035865 | PRJNA508758_P_NODE_66583_length_265_cov_1.036458_g65535_i0 | PRJNA508758 | 66583 | 265 | 1.036458 | 2.7466137 | Trichoderma virens | 29875 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|927416957|ref|XM_014098835.1| | 413071 | g65535 | i0 | 97.059 | 0.237735849056604 | 34 | 0 | 13 | 1 | 13 | 46 | 619 | 651 | Trichoderma virens Gv29-8 uncharacterized protein (TRIVIDRAFT_89958), mRNA | blastn | 63 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma virens | |
| 3036007 | 3036007 | PRJNA508758_P_NODE_83643_length_244_cov_0.900585_g82595_i0 | PRJNA508758 | 83643 | 244 | 0.900585 | 2.1974274 | Colletotrichum aenigma | 1215731 | Fungi | Fungi | 394 | 3.17e-105 | NTclustered | gi|1929701955|ref|XM_037317191.1| | 1215731 | g82595 | i0 | 96.624 | 7.68032786885246 | 237 | 8 | 97 | 0 | 1 | 237 | 444 | 208 | Colletotrichum aenigma NADH dehydrogenase (ubiquinone) complex I, assembly factor 6 (Ndufaf6), partial mRNA | blastn | 1874 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum aenigma | |
| 4938903 | 4938903 | PRJNA508758_P_NODE_4784_length_1116_cov_10.446788_g4194_i0 | PRJNA508758 | 4784 | 1116 | 10.446788 | 116.58615408 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 0.002 | NTclustered | gi|366987818|ref|XM_003673628.1| | 27288 | g4194 | i0 | 100 | 0.573476702508961 | 31 | 0 | 3 | 0 | 290 | 320 | 1229 | 1199 | Naumovozyma castellii uncharacterized protein (NCAS0A07370), partial mRNA | blastn | 640 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Naumovozyma | Naumovozyma castellii | |
| 7488783 | 7488783 | PRJNA508758_P_NODE_88506_length_241_cov_0.916667_g87458_i0 | PRJNA508758 | 88506 | 241 | 0.916667 | 2.20916747 | Ascomycota | 4890 | Fungi | Fungi | 99 | 2.75e-16 | NTclustered | gi|1089700199|ref|XM_018840862.1| | 1367422 | g87458 | i0 | 91.549 | 129.448132780083 | 71 | 6 | 31 | 0 | 112 | 182 | 2398 | 2468 | Fonsecaea erecta hypothetical protein (AYL99_09355), partial mRNA | blastn | 31197 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Fonsecaea | Fonsecaea erecta | |
| 8137595 | 8137595 | PRJNA508758_P_NODE_29087_length_375_cov_3.178808_g28039_i0 | PRJNA508758 | 29087 | 375 | 3.178808 | 11.92053 | Talaromyces atroroseus | 1441469 | Fungi | Fungi | 52.8 | 0.036 | NTclustered | gi|1147823063|ref|XM_020267415.1| | 1441469 | g28039 | i0 | 100 | 0.0746666666666667 | 28 | 0 | 7 | 0 | 219 | 246 | 2038 | 2065 | Talaromyces atroroseus hypothetical protein (UA08_05127), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces atroroseus | |
| 11963276 | 11963276 | PRJNA508758_P_NODE_32390_length_359_cov_1.076923_g31342_i0 | PRJNA508758 | 32390 | 359 | 1.076923 | 3.86615357 | Diplodia seriata | 420778 | Fungi | Fungi | 206 | 2.4699999999999994e-48 | NTclustered | gi|2781257889|ref|XM_066776532.1| | 420778 | g31342 | i0 | 84.434 | 64.4484679665738 | 212 | 29 | 58 | 4 | 61 | 270 | 433 | 642 | Diplodia seriata 40S ribosomal protein uS7 (RPS5), partial mRNA | blastn | 23137 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Diplodia | Diplodia seriata | |
| 11963639 | 11963639 | PRJNA508758_P_NODE_81210_length_246_cov_0.890173_g80162_i0 | PRJNA508758 | 81210 | 246 | 0.890173 | 2.18982558 | Aspergillus ruber | 396024 | Fungi | Fungi | 204 | 5.799999999999998e-48 | NTclustered | gi|2028008697|ref|XM_040780910.1| | 1388766 | g80162 | i0 | 83.193 | 2.21138211382114 | 238 | 25 | 93 | 12 | 3 | 230 | 60 | 292 | Aspergillus ruber CBS 135680 polysaccharide deacetylase family protein (EURHEDRAFT_408767), mRNA | blastn | 544 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ruber | |
| 14513837 | 14513837 | PRJNA508758_P_NODE_82652_length_245_cov_0.895349_g81604_i0 | PRJNA508758 | 82652 | 245 | 0.895349 | 2.19360505 | Scytalidium sp. | 1715249 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|1694465194|gb|MK111108.1| | 1715249 | g81604 | i0 | 96.774 | 0.126530612244898 | 31 | 1 | 13 | 0 | 148 | 178 | 5425 | 5455 | Scytalidium sp. mitochondrion, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Scytalidium | Scytalidium sp. | |||
| 17688545 | 17688545 | PRJNA508758_P_NODE_78954_length_247_cov_2.040230_g77906_i0 | PRJNA508758 | 78954 | 247 | 2.04023 | 5.0393681 | Lembosiniella | 2610783 | Fungi | Fungi | 448 | 2.4399999999999993e-121 | NTclustered | gi|2787448680|ref|NG_243010.1| | 2610792 | g77906 | i0 | 99.592 | 99.1902834008097 | 245 | 1 | 99 | 0 | 1 | 245 | 905 | 661 | Lembosiniella eucalyptorum CBS 144603 18S rRNA gene, partial sequence; from TYPE material | blastn | 24500 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Lembosiniella | Lembosiniella eucalyptorum | |||
| 18962314 | 18962314 | PRJNA508758_P_NODE_79955_length_247_cov_0.885057_g78907_i0 | PRJNA508758 | 79955 | 247 | 0.885057 | 2.18609079 | Fusarium | 5506 | Fungi | Fungi | 375 | 1.1699999999999999e-99 | NTclustered | gi|1092971708|ref|XM_018890130.1| | 334819 | g78907 | i0 | 93.976 | 9.12145748987854 | 249 | 13 | 100 | 2 | 1 | 247 | 2045 | 1797 | Fusarium verticillioides 7600 delta-aminolevulinic acid dehydratase (FVEG_02693), mRNA | blastn | 2253 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 22161252 | 22161252 | PRJNA508758_P_NODE_30098_length_370_cov_1.767677_g29050_i0 | PRJNA508758 | 30098 | 370 | 1.767677 | 6.5404049 | Cryphonectria parasitica | 5116 | Fungi | Fungi | 62.1 | 5.84e-5 | NTclustered | gi|2027910992|ref|XM_040916883.1| | 660469 | g29050 | i0 | 87.5 | 1.10810810810811 | 56 | 4 | 15 | 3 | 102 | 155 | 66 | 120 | Cryphonectria parasitica EP155 uncharacterized protein (M406DRAFT_253163), partial mRNA | blastn | 410 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cryphonectriaceae | Cryphonectria | Cryphonectria parasitica | |
| 22161699 | 22161699 | PRJNA508758_P_NODE_84778_length_243_cov_1.688235_g83730_i0 | PRJNA508758 | 84778 | 243 | 1.688235 | 4.10241105 | Pyricularia grisea | 148305 | Fungi | Fungi | 62.1 | 3.64e-5 | NTclustered | gi|1758259134|ref|XM_031120988.1| | 148305 | g83730 | i0 | 100 | 0.481481481481481 | 33 | 0 | 14 | 0 | 66 | 98 | 711 | 679 | Pyricularia grisea uncharacterized protein (PgNI_00911), mRNA | blastn | 117 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia grisea | |
| 24710684 | 24710684 | PRJNA508758_P_NODE_56680_length_284_cov_24.113744_g55632_i0 | PRJNA508758 | 56680 | 284 | 24.113744 | 68.48303296 | Ogataea angusta | 870730 | Fungi | Fungi | 163 | 1.16e-35 | NTclustered | gi|2085311048|ref|XM_043204434.1| | 870730 | g55632 | i0 | 81.407 | 81.2676056338028 | 199 | 37 | 70 | 0 | 17 | 215 | 23 | 221 | Ogataea angusta uncharacterized protein (KL928_003806), partial mRNA | blastn | 23080 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | Ogataea angusta | |
| 24710797 | 24710797 | PRJNA508758_P_NODE_70980_length_256_cov_1.535519_g69932_i0 | PRJNA508758 | 70980 | 256 | 1.535519 | 3.93092864 | Penicillium canescens | 5083 | Fungi | Fungi | 58.4 | 5e-4 | NTclustered | gi|2554121583|ref|XM_058513669.1| | 5083 | g69932 | i0 | 100 | 0.12109375 | 31 | 0 | 12 | 0 | 178 | 208 | 855 | 825 | Penicillium canescens uncharacterized protein (N7446_004921), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium canescens | |
| 25337025 | 25337025 | PRJNA508758_P_NODE_11620_length_619_cov_4.879121_g10625_i0 | PRJNA508758 | 11620 | 619 | 4.879121 | 30.20175899 | Opisthokonta | 33154 | Fungi | Fungi | 65.8 | 7.88e-6 | NTclustered | gi|2749654076|ref|XM_066089938.1| | 5147 | g10625 | i0 | 91.667 | 6.8546042003231 | 48 | 2 | 8 | 2 | 534 | 580 | 2987 | 2941 | Sordaria macrospora uncharacterized protein (SMAC4_03408), mRNA | blastn | 4243 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Sordaria | Sordaria macrospora |
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);;