contig_metadata
20 rows where bioproject = "PRJNA1174770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1040984 | 1040984 | PRJNA1174770_P_NODE_2041_length_336_cov_1.432056_g1952_i0 | PRJNA1174770 | 2041 | 336 | 1.432056 | 4.81170816 | Ceratocystidaceae | 1028423 | Fungi | Fungi | 610 | 4.17e-170 | NTclustered | gi|940789774|gb|KR673893.1| | 5158 | g1952 | i0 | 99.405 | 98.5208333333333 | 336 | 2 | 100 | 0 | 1 | 336 | 357 | 22 | Ceratocystis fimbriata 18S small subunit ribosomal RNA gene, partial sequence | blastn | 33103 | 610 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Ceratocystis | Ceratocystis fimbriata | |
| 3591494 | 3591494 | PRJNA1174770_P_NODE_8363_length_168_cov_0.873950_g8274_i0 | PRJNA1174770 | 8363 | 168 | 0.87395 | 1.468236 | Penicillium | 5073 | Fungi | Fungi | 185 | 1.33e-42 | NTclustered | gi|2513219667|ref|XM_056706224.1| | 5076 | g8274 | i0 | 100 | 4.43452380952381 | 100 | 0 | 60 | 0 | 69 | 168 | 579 | 480 | Penicillium chrysogenum uncharacterized protein (N7489_000469), partial mRNA | blastn | 745 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 6694248 | 6694248 | PRJNA1174770_P_NODE_8526_length_168_cov_0.865546_g8437_i0 | PRJNA1174770 | 8526 | 168 | 0.865546 | 1.45411728 | Pleosporaceae | 28556 | Fungi | Fungi | 79.3 | 1.28e-15 | NR | XP_065965936.1 | 45151 | g8437 | i0 | 92.5 | 4.96428571428571 | 40 | 3 | 71.4 | 0 | 2 | 121 | 7 | 46 | XP_065965936.1 hypothetical protein PtrM4_026720 [Pyrenophora tritici-repentis] | diamond | 834 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Pyrenophora | Pyrenophora tritici-repentis | |
| 8693969 | 8693969 | PRJNA1174770_P_NODE_5287_length_202_cov_0.947712_g5198_i0 | PRJNA1174770 | 5287 | 202 | 0.947712 | 1.91437824 | Ascomycota | 4890 | Fungi | Fungi | 364 | 1.99e-96 | NTclustered | gi|61676522|gb|AY856933.1| | 43218 | g5198 | i0 | 99.5 | 99.019801980198 | 200 | 1 | 99 | 0 | 3 | 202 | 304 | 105 | Tubeufia helicomyces strain CBS 271.52 18S ribosomal RNA gene, partial sequence | blastn | 20002 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Tubeufiales | Tubeufiaceae | Tubeufia | Tubeufia helicomyces | |
| 8693978 | 8693978 | PRJNA1174770_P_NODE_6607_length_182_cov_2.436090_g6518_i0 | PRJNA1174770 | 6607 | 182 | 2.43609 | 4.4336838 | Leotiomycetes | 147548 | Fungi | Fungi | 315 | 1.79e-81 | NTclustered | gi|1706880638|gb|MK357465.1| | 52586 | g6518 | i0 | 97.814 | 100.478021978022 | 183 | 3 | 100 | 1 | 1 | 182 | 58 | 240 | Erysiphe necator isolate PTM3 small subunit ribosomal RNA gene, partial sequence | blastn | 18287 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe necator | |
| 8693982 | 8693982 | PRJNA1174770_P_NODE_7407_length_173_cov_2.701613_g7318_i0 | PRJNA1174770 | 7407 | 173 | 2.701613 | 4.67379049 | Eukaryota | 2759 | Fungi | Fungi | 320 | 3.61e-83 | NTclustered | gi|1859418681|gb|MT640259.1| | 157594 | g7318 | i0 | 100 | 99.9942196531792 | 173 | 0 | 100 | 0 | 1 | 173 | 951 | 1123 | Erysiphe alphitoides isolate DM1081 large subunit ribosomal RNA gene, partial sequence | blastn | 17299 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe alphitoides | |
| 10519925 | 10519925 | PRJNA1174770_P_NODE_5569_length_197_cov_1.263514_g5480_i0 | PRJNA1174770 | 5569 | 197 | 1.263514 | 2.48912258 | Sordaria macrospora | 5147 | Fungi | Fungi | 281 | 2e-71 | NTclustered | gi|2749645277|ref|XR_010715268.1| | 5147 | g5480 | i0 | 92.424 | 104.329949238579 | 198 | 13 | 100 | 2 | 1 | 197 | 1859 | 2055 | Sordaria macrospora 28S ribosomal RNA (SMAC4_13380), rRNA | blastn | 20553 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Sordaria | Sordaria macrospora | |
| 10519930 | 10519930 | PRJNA1174770_P_NODE_6349_length_186_cov_1.357664_g6260_i0 | PRJNA1174770 | 6349 | 186 | 1.357664 | 2.52525504 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 75.9 | 2.58e-14 | NR | XP_069227632.1 | 1052096 | g6260 | i0 | 68.3 | 0.967741935483871 | 60 | 19 | 96.8 | 0 | 185 | 6 | 148 | 207 | XP_069227632.1 uncharacterized protein WHR41_07081 [Cladosporium halotolerans] | diamond | 180 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 11244321 | 11244321 | PRJNA1174770_P_NODE_7869_length_169_cov_1.250000_g7780_i0 | PRJNA1174770 | 7869 | 169 | 1.25 | 2.1125 | Erysiphaceae | 34371 | Fungi | Fungi | 313 | 5.859999999999999e-81 | NTclustered | gi|1152264121|gb|KY692193.1| | 52586 | g7780 | i0 | 100 | 99.9881656804734 | 169 | 0 | 100 | 0 | 1 | 169 | 383 | 215 | Erysiphe necator strain OID105 large subunit ribosomal RNA gene, partial sequence | blastn | 16898 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe necator | |
| 15068660 | 15068660 | PRJNA1174770_P_NODE_11212_length_163_cov_0.912281_g11123_i0 | PRJNA1174770 | 11212 | 163 | 0.912281 | 1.48701803 | Gnomoniaceae | 218102 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|13540012|gb|AF277111.1|AF277111 | 148325 | g11123 | i0 | 100 | 99.9141104294479 | 163 | 0 | 100 | 0 | 1 | 163 | 795 | 633 | Apioplagiostoma aceriferum small subunit ribosomal RNA gene, partial sequence | blastn | 16286 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Gnomoniaceae | Apioplagiostoma | Apioplagiostoma aceriferum | |
| 16893354 | 16893354 | PRJNA1174770_P_NODE_2974_length_272_cov_2.049327_g2885_i0 | PRJNA1174770 | 2974 | 272 | 2.049327 | 5.57416944 | Coniochaeta hoffmannii | 91930 | Fungi | Fungi | 387 | 6.02e-103 | NTclustered | gi|1333183594|gb|MG491499.1| | 91930 | g2885 | i0 | 92.308 | 118.242647058824 | 273 | 19 | 100 | 2 | 1 | 272 | 5342 | 5613 | Coniochaeta hoffmannii strain CBS 245.38 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence | blastn | 32162 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta hoffmannii | |
| 19442327 | 19442327 | PRJNA1174770_P_NODE_8256_length_168_cov_0.873950_g8167_i0 | PRJNA1174770 | 8256 | 168 | 0.87395 | 1.468236 | Penicillium solitum | 60172 | Fungi | Fungi | 289 | 9.879999999999999e-74 | NTclustered | gi|2741398310|ref|XM_040952556.2| | 60172 | g8167 | i0 | 97.619 | 12.5119047619048 | 168 | 4 | 100 | 0 | 1 | 168 | 1011 | 844 | Penicillium solitum uncharacterized protein (N7455_012413), partial mRNA | blastn | 2102 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium solitum | |
| 26629014 | 26629014 | PRJNA1174770_P_NODE_10921_length_164_cov_0.895652_g10832_i0 | PRJNA1174770 | 10921 | 164 | 0.895652 | 1.46886928 | Exophiala spinifera | 91928 | Fungi | Fungi | 42 | 0.0244 | NR | XP_016230830.1 | 91928 | g10832 | i0 | 45.5 | 0.804878048780488 | 44 | 24 | 80.5 | 0 | 154 | 23 | 1038 | 1081 | XP_016230830.1 uncharacterized protein PV08_11578 [Exophiala spinifera] | diamond | 132 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala spinifera | |
| 27754983 | 27754983 | PRJNA1174770_P_NODE_12204_length_162_cov_0.911504_g12115_i0 | PRJNA1174770 | 12204 | 162 | 0.911504 | 1.47663648 | Hypocreales | 5125 | Fungi | Fungi | 58.2 | 4.44e-8 | NR | XP_018178140.2 | 33203 | g12115 | i0 | 60.4 | 6.14814814814815 | 53 | 20 | 98.1 | 1 | 161 | 3 | 218 | 269 | XP_018178140.2 uncharacterized protein PLICBS_003176 [Purpureocillium lilacinum] | diamond | 996 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 29144290 | 29144290 | PRJNA1174770_P_NODE_11569_length_163_cov_0.903509_g11480_i0 | PRJNA1174770 | 11569 | 163 | 0.903509 | 1.47271967 | Didymosphaeriaceae | 221678 | Fungi | Fungi | 99 | 1.92e-22 | NR | KAF2451586.1 | 1392251 | g11480 | i0 | 92.5 | 13.6564417177914 | 53 | 4 | 97.5 | 0 | 3 | 161 | 790 | 842 | KAF2451586.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Karstenula rhodostoma CBS 690.94] | diamond | 2226 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Karstenula | Karstenula rhodostoma | |
| 30135058 | 30135058 | PRJNA1174770_P_NODE_12352_length_162_cov_0.902655_g12263_i0 | PRJNA1174770 | 12352 | 162 | 0.902655 | 1.4623011 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 89 | 6.6e-19 | NR | XP_069231601.1 | 1052096 | g12263 | i0 | 81.1 | 0.981481481481482 | 53 | 10 | 98.1 | 0 | 162 | 4 | 118 | 170 | XP_069231601.1 uncharacterized protein WHR41_02876 [Cladosporium halotolerans] | diamond | 159 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 31589375 | 31589375 | PRJNA1174770_P_NODE_6696_length_181_cov_2.068182_g6607_i0 | PRJNA1174770 | 6696 | 181 | 2.068182 | 3.74340942 | Hypoxylon rubiginosum | 110542 | Fungi | Fungi | 109 | 4.29e-26 | NR | KAI4865926.1 | 110542 | g6607 | i0 | 93.3 | 0.994475138121547 | 60 | 4 | 99.4 | 0 | 181 | 2 | 863 | 922 | KAI4865926.1 nuclear protein 96-domain-containing protein [Hypoxylon rubiginosum] | diamond | 180 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon rubiginosum | |
| 31652255 | 31652255 | PRJNA1174770_P_NODE_5957_length_191_cov_1.387324_g5868_i0 | PRJNA1174770 | 5957 | 191 | 1.387324 | 2.64978884 | Xylariaceae sp. FL | 1881983 | Fungi | Fungi | 83.2 | 1.05e-16 | NR | KAI0483099.1 | 2663375 | g5868 | i0 | 65.4 | 3.47120418848168 | 52 | 18 | 81.7 | 0 | 190 | 35 | 789 | 840 | KAI0483099.1 canalicular multispecific organic anion transporter 1 [Xylariaceae sp. FL0804] | diamond | 663 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylariaceae sp. FL0804 | ||
| 31734702 | 31734702 | PRJNA1174770_P_NODE_7957_length_169_cov_0.866667_g7868_i0 | PRJNA1174770 | 7957 | 169 | 0.866667 | 1.46466723 | Hypocreales | 5125 | Fungi | Fungi | 90.9 | 1.52e-19 | NR | KAK4070240.1 | 33203 | g7868 | i0 | 83.9 | 1.98816568047337 | 56 | 9 | 99.4 | 0 | 1 | 168 | 409 | 464 | KAK4070240.1 hypothetical protein Purlil1_13536 [Purpureocillium lilacinum] | diamond | 336 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 31778876 | 31778876 | PRJNA1174770_P_NODE_9057_length_167_cov_0.872881_g8968_i0 | PRJNA1174770 | 9057 | 167 | 0.872881 | 1.45771127 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 86.3 | 5.91e-18 | NR | XP_069229693.1 | 1052096 | g8968 | i0 | 86.8 | 0.952095808383233 | 53 | 7 | 95.2 | 0 | 161 | 3 | 42 | 94 | XP_069229693.1 uncharacterized protein WHR41_05321 [Cladosporium halotolerans] | diamond | 159 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans |
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);;