contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB65329" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2269142 | 2269142 | PRJEB65329_S_NODE_6722_length_288_cov_4.528958_g6560_i0 | PRJEB65329 | 6722 | 288 | 4.528958 | 13.04339904 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.027 | NTclustered | gi|1758257202|ref|XM_031120922.1| | 148305 | g6560 | i0 | 100 | 0.208333333333333 | 28 | 0 | 10 | 0 | 105 | 132 | 1237 | 1264 | Pyricularia grisea uncharacterized protein (PgNI_00845), partial mRNA | blastn | 60 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia grisea | |
| 3544429 | 3544429 | PRJEB65329_S_NODE_13703_length_179_cov_1.960000_g13541_i0 | PRJEB65329 | 13703 | 179 | 1.96 | 3.5084 | Blastomyces | 229219 | Fungi | Fungi | 152 | 1.45e-32 | NTclustered | gi|2163354133|ref|XM_045423294.1| | 559297 | g13541 | i0 | 82.022 | 42.0670391061453 | 178 | 32 | 99 | 0 | 2 | 179 | 418 | 595 | Blastomyces dermatitidis ER-3 50S ribosomal protein L40e (BDCG_07509), partial mRNA | blastn | 7530 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Blastomyces | Blastomyces dermatitidis | |
| 4821963 | 4821963 | PRJEB65329_S_NODE_18444_length_150_cov_3.867769_g18282_i0 | PRJEB65329 | 18444 | 150 | 3.867769 | 5.8016535 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.85e-70 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g18282 | i0 | 100 | 100 | 150 | 0 | 100 | 0 | 1 | 150 | 666 | 815 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 15000 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 5232587 | 5232587 | PRJEB65329_S_NODE_15245_length_167_cov_3.797101_g15083_i0 | PRJEB65329 | 15245 | 167 | 3.797101 | 6.34115867 | Lichtheimia ornata | 688661 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|2553564953|ref|XM_058483918.1| | 688661 | g15083 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 1 | 28 | 990 | 1017 | Lichtheimia ornata uncharacterized protein (O0I10_003852), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 5232603 | 5232603 | PRJEB65329_S_NODE_16565_length_160_cov_1.755725_g16403_i0 | PRJEB65329 | 16565 | 160 | 1.755725 | 2.80916 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 128 | 2.14e-25 | NTclustered | gi|2323742940|ref|XM_051563864.1| | 64574 | g16403 | i0 | 82.979 | 9.15625 | 141 | 24 | 88 | 0 | 16 | 156 | 328 | 188 | Radiomyces spectabilis 60S ribosomal protein L11 (BYT42DRAFT_48830), mRNA | blastn | 1465 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 9057542 | 9057542 | PRJEB65329_S_NODE_8428_length_245_cov_3.662037_g8266_i0 | PRJEB65329 | 8428 | 245 | 3.662037 | 8.97199065 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2724881403|ref|XM_064835180.1| | 574656 | g8266 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 27 | 55 | 1808 | 1780 | Recurvomyces mirabilis mitogen-activated protein kinase kinase kinase (BCK1), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 11197229 | 11197229 | PRJEB65329_S_NODE_12669_length_187_cov_4.373418_g12507_i0 | PRJEB65329 | 12669 | 187 | 4.373418 | 8.17829166 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 3.44e-4 | NTclustered | gi|2325054217|ref|XM_051746181.1| | 936130 | g12507 | i0 | 100 | 2.58288770053476 | 31 | 0 | 17 | 0 | 157 | 187 | 842 | 812 | Pisolithus orientalis uncharacterized protein (F5J12DRAFT_842939), mRNA | blastn | 483 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus orientalis | |
| 11608599 | 11608599 | PRJEB65329_S_NODE_17330_length_156_cov_1.677165_g17168_i0 | PRJEB65329 | 17330 | 156 | 1.677165 | 2.6163774 | Aspergillus melleus | 138277 | Fungi | Fungi | 132 | 1.6e-26 | NTclustered | gi|2185263466|ref|XM_046087683.1| | 138277 | g17168 | i0 | 83.942 | 4.56410256410256 | 137 | 22 | 88 | 0 | 15 | 151 | 622 | 758 | Aspergillus melleus RuvB ATP-dependent DNA helicase pontin (RVB1), partial mRNA | blastn | 712 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus melleus | |
| 12472853 | 12472853 | PRJEB65329_S_NODE_12830_length_186_cov_2.350318_g12668_i0 | PRJEB65329 | 12830 | 186 | 2.350318 | 4.37159148 | Eukaryota | 2759 | Fungi | Fungi | 344 | 2.34e-90 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12668 | i0 | 100 | 97.8817204301075 | 186 | 0 | 100 | 0 | 1 | 186 | 1652 | 1467 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 18206 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17571770 | 17571770 | PRJEB65329_S_NODE_13014_length_184_cov_2.954839_g12852_i0 | PRJEB65329 | 13014 | 184 | 2.954839 | 5.43690376 | Opisthokonta | 33154 | Fungi | Fungi | 340 | 2.99e-89 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g12852 | i0 | 100 | 100 | 184 | 0 | 100 | 0 | 1 | 184 | 228 | 411 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 18400 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18845548 | 18845548 | PRJEB65329_S_NODE_15075_length_168_cov_4.446043_g14913_i0 | PRJEB65329 | 15075 | 168 | 4.446043 | 7.46935224 | Sordariomycetes | 147550 | Fungi | Fungi | 60.2 | 8.43e-5 | NTclustered | gi|2897698624|ref|XM_071023815.1| | 591952 | g14913 | i0 | 94.737 | 1.42261904761905 | 38 | 2 | 23 | 0 | 130 | 167 | 337 | 300 | Sodiomyces alcalophilus JCM 7366 uncharacterized protein (ACRALDRAFT_212015), partial mRNA | blastn | 239 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Sodiomyces | Sodiomyces alcalophilus | |
| 20530972 | 20530972 | PRJEB65329_S_NODE_11717_length_197_cov_2.660714_g11555_i0 | PRJEB65329 | 11717 | 197 | 2.660714 | 5.24160658 | Lipomyces japonicus | 56871 | Fungi | Fungi | 137 | 4.58e-28 | NTclustered | gi|2781531505|ref|XM_066929761.1| | 56871 | g11555 | i0 | 86.4 | 1.79695431472081 | 125 | 17 | 63 | 0 | 62 | 186 | 369 | 493 | Lipomyces japonicus 60S ribosomal eL21 domain-containing protein (V1514DRAFT_363258), mRNA | blastn | 354 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 21396049 | 21396049 | PRJEB65329_S_NODE_16657_length_159_cov_2.700000_g16495_i0 | PRJEB65329 | 16657 | 159 | 2.7 | 4.293 | Malassezia | 55193 | Fungi | Fungi | 294 | 1.98e-75 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g16495 | i0 | 100 | 98.7169811320755 | 159 | 0 | 100 | 0 | 1 | 159 | 178 | 20 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 15696 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24355817 | 24355817 | PRJEB65329_S_NODE_11400_length_200_cov_3.467836_g11238_i0 | PRJEB65329 | 11400 | 200 | 3.467836 | 6.935672 | Magnusiomyces paraingens | 2606893 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|1800258659|ref|XM_031999881.1| | 2606893 | g11238 | i0 | 100 | 0.145 | 29 | 0 | 15 | 0 | 24 | 52 | 518 | 546 | Magnusiomyces paraingens uncharacterized protein (SAPINGB_P005166), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Magnusiomyces | Magnusiomyces paraingens | |
| 24355875 | 24355875 | PRJEB65329_S_NODE_15260_length_167_cov_3.289855_g15098_i0 | PRJEB65329 | 15260 | 167 | 3.289855 | 5.49405785 | uncultured fungus | 175245 | Fungi | Fungi | 303 | 3.5e-78 | NTclustered | gi|507143256|gb|KC674849.1| | 175245 | g15098 | i0 | 99.401 | 100 | 167 | 1 | 100 | 0 | 1 | 167 | 262 | 96 | Uncultured fungus clone nco89e02c1 18S ribosomal RNA gene, partial sequence | blastn | 16700 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 24355878 | 24355878 | PRJEB65329_S_NODE_15420_length_166_cov_3.204380_g15258_i0 | PRJEB65329 | 15420 | 166 | 3.20438 | 5.3192708 | Durotheca rogersii | 419775 | Fungi | Fungi | 110 | 8.13e-20 | NTclustered | gi|2324015613|ref|XM_051514482.1| | 419775 | g15258 | i0 | 79.012 | 2.42771084337349 | 162 | 32 | 97 | 2 | 6 | 166 | 254 | 414 | Durotheca rogersii ras family protein (GGS23DRAFT_502017), mRNA | blastn | 403 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Durotheca | Durotheca rogersii | |
| 24356060 | 24356060 | PRJEB65329_S_NODE_7280_length_272_cov_4.427984_g7118_i0 | PRJEB65329 | 7280 | 272 | 4.427984 | 12.04411648 | Rhodonia placenta | 104341 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1372285726|ref|XM_024482125.1| | 670580 | g7118 | i0 | 94.444 | 0.338235294117647 | 36 | 2 | 13 | 0 | 1 | 36 | 916 | 881 | Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1066951), mRNA | blastn | 92 | 56.5 | 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);;