contig_metadata
14 rows where bioproject = "PRJNA453111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1092866 | 1092866 | PRJNA453111_P_NODE_521_length_1104_cov_6.753637_g471_i0 | PRJNA453111 | 521 | 1104 | 6.753637 | 74.56015248 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 0.002 | NTclustered | gi|366987818|ref|XM_003673628.1| | 27288 | g471 | i0 | 100 | 0.579710144927536 | 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 | |
| 2992043 | 2992043 | PRJNA453111_P_NODE_12143_length_244_cov_0.900585_g12051_i0 | PRJNA453111 | 12143 | 244 | 0.900585 | 2.1974274 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 207 | 4.44e-49 | NTclustered | gi|2725256856|ref|XM_064900217.1| | 1690604 | g12051 | i0 | 82.231 | 6.88114754098361 | 242 | 41 | 99 | 2 | 4 | 244 | 353 | 113 | Lithohypha guttulata ATP-binding cassette transporter CGR1 (PDH1), partial mRNA | blastn | 1679 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 8094536 | 8094536 | PRJNA453111_P_NODE_11667_length_246_cov_0.890173_g11575_i0 | PRJNA453111 | 11667 | 246 | 0.890173 | 2.18982558 | Exophiala viscosa | 2486360 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2669801563|ref|XM_062817184.1| | 2486360 | g11575 | i0 | 96.875 | 0.24390243902439 | 32 | 1 | 13 | 0 | 208 | 239 | 741 | 772 | Exophiala viscosa uncharacterized protein (EDD37DRAFT_639616), mRNA | blastn | 60 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala viscosa | |
| 8094539 | 8094539 | PRJNA453111_P_NODE_11807_length_245_cov_0.895349_g11715_i0 | PRJNA453111 | 11807 | 245 | 0.895349 | 2.19360505 | Alternaria ethzedia | 181014 | Fungi | Fungi | 86.1 | 2.18e-12 | NTclustered | gi|2272316876|ref|XM_049381578.1| | 181014 | g11715 | i0 | 93.103 | 0.608163265306122 | 58 | 4 | 24 | 0 | 145 | 202 | 316 | 259 | Alternaria ethzedia uncharacterized protein (J4E87_010004), partial mRNA | blastn | 149 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria ethzedia | |
| 9369382 | 9369382 | PRJNA453111_P_NODE_9968_length_251_cov_0.865169_g9876_i0 | PRJNA453111 | 9968 | 251 | 0.865169 | 2.17157419 | Alternaria alternata | 5599 | Fungi | Fungi | 464 | 2.47e-126 | NTclustered | gi|1070554631|ref|XM_018536381.1| | 5599 | g9876 | i0 | 100 | 22.7051792828685 | 251 | 0 | 100 | 0 | 1 | 251 | 518 | 768 | Alternaria alternata ribosomal protein S7 partial mRNA | blastn | 5699 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 15744110 | 15744110 | PRJNA453111_P_NODE_8153_length_284_cov_0.919431_g8061_i0 | PRJNA453111 | 8153 | 284 | 0.919431 | 2.61118404 | Cordyceps fumosorosea | 114497 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|1089717561|ref|XM_018844909.1| | 1081104 | g8061 | i0 | 100 | 0.0985915492957746 | 28 | 0 | 10 | 0 | 139 | 166 | 431 | 458 | Isaria fumosorosea ARSEF 2679 hypothetical protein (ISF_01302), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps fumosorosea | |
| 20843039 | 20843039 | PRJNA453111_P_NODE_11237_length_247_cov_0.885057_g11145_i0 | PRJNA453111 | 11237 | 247 | 0.885057 | 2.18609079 | Aspergillus lentulus | 293939 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1832821455|ref|XM_033557386.1| | 293939 | g11145 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 188 | 216 | 983 | 1011 | Aspergillus lentulus putative glycosidase crf1 (IFM58399_02959), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus lentulus | |
| 20843129 | 20843129 | PRJNA453111_P_NODE_7517_length_295_cov_1.373874_g7425_i0 | PRJNA453111 | 7517 | 295 | 1.373874 | 4.0529283 | Talaromyces atroroseus | 1441469 | Fungi | Fungi | 52.8 | 0.027 | NTclustered | gi|1147823063|ref|XM_020267415.1| | 1441469 | g7425 | i0 | 100 | 0.0949152542372881 | 28 | 0 | 9 | 0 | 134 | 161 | 2065 | 2038 | Talaromyces atroroseus hypothetical protein (UA08_05127), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces atroroseus | |
| 22117905 | 22117905 | PRJNA453111_P_NODE_11158_length_247_cov_1.431034_g11066_i0 | PRJNA453111 | 11158 | 247 | 1.431034 | 3.53465398 | Thermothielavioides terrestris | 2587410 | Fungi | Fungi | 165 | 2.75e-36 | NTclustered | gi|367054863|ref|XM_003657762.1| | 578455 | g11066 | i0 | 91.597 | 51.8582995951417 | 119 | 10 | 48 | 0 | 61 | 179 | 1039 | 1157 | Thermothielavioides terrestris NRRL 8126 uncharacterized protein (THITE_2123869), mRNA | blastn | 12809 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothielavioides | Thermothielavioides terrestris | |
| 24044693 | 24044693 | PRJNA453111_P_NODE_13159_length_241_cov_0.916667_g13067_i0 | PRJNA453111 | 13159 | 241 | 0.916667 | 2.20916747 | Colletotrichum | 5455 | Fungi | Fungi | 207 | 4.38e-49 | NTclustered | gi|1919372440|ref|XM_036637524.1| | 690259 | g13067 | i0 | 82.449 | 24.1327800829876 | 245 | 35 | 100 | 6 | 1 | 241 | 562 | 322 | Colletotrichum siamense uncharacterized protein (CGCS363_v005675), partial mRNA | blastn | 5816 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum siamense | |
| 28703047 | 28703047 | PRJNA453111_P_NODE_5967_length_331_cov_0.968992_g5875_i0 | PRJNA453111 | 5967 | 331 | 0.968992 | 3.20736352 | Fungi | 4751 | Fungi | Fungi | 85.1 | 2.63e-18 | NR | XP_018735866.1 | 796027 | g5875 | i0 | 69.4 | 2.94561933534743 | 62 | 19 | 56.2 | 0 | 85 | 270 | 89 | 150 | XP_018735866.1 Mbf1p [Sugiyamaella lignohabitans] | diamond | 975 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Sugiyamaella | Sugiyamaella lignohabitans | |
| 30755907 | 30755907 | PRJNA453111_P_NODE_8374_length_279_cov_1.495146_g8282_i0 | PRJNA453111 | 8374 | 279 | 1.495146 | 4.17145734 | Chaetomiaceae | 35718 | Fungi | Fungi | 136 | 2.73e-38 | NR | XP_003651487.1 | 578455 | g8282 | i0 | 66.7 | 50.247311827957 | 90 | 30 | 96.8 | 0 | 2 | 271 | 2 | 91 | XP_003651487.1 uncharacterized protein THITE_2111869 [Thermothielavioides terrestris NRRL 8126] | diamond | 14019 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothielavioides | Thermothielavioides terrestris | |
| 31403466 | 31403466 | PRJNA453111_P_NODE_11176_length_247_cov_1.321839_g11084_i0 | PRJNA453111 | 11176 | 247 | 1.321839 | 3.26494233 | Leptodontidium sp. MPI-SDFR-AT- | 1920929 | Fungi | Fungi | 42.7 | 0.0389 | NR | KAH6706202.1 | 2826080 | g11084 | i0 | 39.6 | 0.582995951417004 | 48 | 28 | 58.3 | 1 | 94 | 237 | 114 | 160 | KAH6706202.1 hypothetical protein BKA61DRAFT_697790 [Leptodontidium sp. MPI-SDFR-AT-0119] | diamond | 144 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Leptodontidiaceae | Leptodontidium | Leptodontidium sp. MPI-SDFR-AT-0119 | |
| 32668192 | 32668192 | PRJNA453111_P_NODE_4380_length_387_cov_1.305732_g4288_i0 | PRJNA453111 | 4380 | 387 | 1.305732 | 5.05318284 | Scytalidium sp. 3C | 2487125 | Fungi | Fungi | 101 | 4.500000000000001e-22 | NR | RQM05331.1 | 2487125 | g4288 | i0 | 51 | 2.26356589147287 | 96 | 47 | 74.4 | 0 | 2 | 289 | 819 | 914 | RQM05331.1 hypothetical protein DH86_00001859 [Scytalidium sp. 3C] | diamond | 876 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Scytalidium | Scytalidium sp. 3C |
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);;