contig_metadata
13 rows where bioproject = "PRJNA1145574" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2308567 | 2308567 | PRJNA1145574_P_NODE_10782_length_255_cov_1.593407_g10598_i0 | PRJNA1145574 | 10782 | 255 | 1.593407 | 4.06318785 | Ascomycota | 4890 | Fungi | Fungi | 472 | 1.5e-128 | NTclustered | gi|1134949146|gb|KX237674.1| | 4909 | g10598 | i0 | 100 | 105 | 255 | 0 | 100 | 0 | 1 | 255 | 44 | 298 | Pichia kudriavzevii isolate YNCA9005 large subunit ribosomal RNA gene, partial sequence | blastn | 26775 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 2308584 | 2308584 | PRJNA1145574_P_NODE_13362_length_246_cov_1.352601_g13178_i0 | PRJNA1145574 | 13362 | 246 | 1.352601 | 3.32739846 | Opisthokonta | 33154 | Fungi | Fungi | 449 | 6.74e-122 | NTclustered | gi|325484983|gb|HQ407432.1| | 5061 | g13178 | i0 | 99.593 | 77.6422764227642 | 246 | 1 | 100 | 0 | 1 | 246 | 690 | 445 | Aspergillus niger strain B1.Eg mitochondrial citrate synthase precursor, gene, partial cds; nuclear gene for mitochondrial product | blastn | 19100 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 6136125 | 6136125 | PRJNA1145574_P_NODE_13545_length_246_cov_0.901734_g13361_i0 | PRJNA1145574 | 13545 | 246 | 0.901734 | 2.21826564 | Saccharomyces | 4930 | Fungi | Fungi | 449 | 6.74e-122 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g13361 | i0 | 99.593 | 9.00406504065041 | 246 | 1 | 100 | 0 | 1 | 246 | 4182884 | 4183129 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 2215 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 6666632 | 6666632 | PRJNA1145574_P_NODE_9606_length_276_cov_1.206897_g9422_i0 | PRJNA1145574 | 9606 | 276 | 1.206897 | 3.33103572 | Penicillium citrinum | 5077 | Fungi | Fungi | 355 | 1.73e-93 | NTclustered | gi|2513223681|ref|XM_056640085.1| | 5077 | g9422 | i0 | 98.507 | 1.18840579710145 | 201 | 3 | 73 | 0 | 1 | 201 | 201 | 1 | Penicillium citrinum uncharacterized protein (N7469_001165), partial mRNA | blastn | 328 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium citrinum | |
| 7941682 | 7941682 | PRJNA1145574_P_NODE_12107_length_250_cov_0.881356_g11923_i0 | PRJNA1145574 | 12107 | 250 | 0.881356 | 2.20339 | Komagataella phaffii | 460519 | Fungi | Fungi | 455 | 1.48e-123 | NTclustered | gi|254566768|ref|XM_002490450.1| | 644223 | g11923 | i0 | 100 | 0.984 | 246 | 0 | 98 | 0 | 1 | 246 | 246 | 1 | Komagataella phaffii GS115 uncharacterized protein (PAS_chr1-4_0674), partial mRNA | blastn | 246 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella phaffii | |
| 11236553 | 11236553 | PRJNA1145574_P_NODE_13429_length_246_cov_0.901734_g13245_i0 | PRJNA1145574 | 13429 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g13245 | i0 | 100 | 10 | 246 | 0 | 100 | 0 | 1 | 246 | 8118069 | 8117824 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 2460 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 11767302 | 11767302 | PRJNA1145574_P_NODE_14550_length_243_cov_0.917647_g14366_i0 | PRJNA1145574 | 14550 | 243 | 0.917647 | 2.22988221 | Saccharomyces cerevisiae | 4932 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g14366 | i0 | 100 | 6.5843621399177 | 243 | 0 | 100 | 0 | 1 | 243 | 3300735 | 3300493 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 1600 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 11767303 | 11767303 | PRJNA1145574_P_NODE_14610_length_243_cov_0.917647_g14426_i0 | PRJNA1145574 | 14610 | 243 | 0.917647 | 2.22988221 | Parastagonospora nodorum | 13684 | Fungi | Fungi | 316 | 7.03e-82 | NTclustered | gi|1759050537|gb|CP039675.1| | 13684 | g14426 | i0 | 90.612 | 6.01234567901235 | 245 | 13 | 99 | 7 | 4 | 243 | 1292256 | 1292017 | Parastagonospora nodorum strain Sn79 chromosome 6 | blastn | 1461 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 18140376 | 18140376 | PRJNA1145574_P_NODE_14535_length_243_cov_0.917647_g14351_i0 | PRJNA1145574 | 14535 | 243 | 0.917647 | 2.22988221 | Teratosphaeriaceae sp. CCFEE 6253 | 2901253 | Fungi | Fungi | 129 | 5.01e-34 | NR | KAK3116487.1 | 2901253 | g14351 | i0 | 86.1 | 1.96296296296296 | 79 | 11 | 97.5 | 0 | 238 | 2 | 267 | 345 | KAK3116487.1 hypothetical protein LTR53_003091 [Teratosphaeriaceae sp. CCFEE 6253] | diamond | 477 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Teratosphaeriaceae sp. CCFEE 6253 | ||
| 19414706 | 19414706 | PRJNA1145574_P_NODE_13196_length_247_cov_0.896552_g13012_i0 | PRJNA1145574 | 13196 | 247 | 0.896552 | 2.21448344 | Penicillium citrinum | 5077 | Fungi | Fungi | 451 | 1.88e-122 | NTclustered | gi|2513218659|ref|XM_056639239.1| | 5077 | g13012 | i0 | 99.595 | 7.19838056680162 | 247 | 1 | 100 | 0 | 1 | 247 | 1575 | 1821 | Penicillium citrinum Serine/threonine-protein kinase sid2 (N7469_000319), partial mRNA | blastn | 1778 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium citrinum | |
| 29470207 | 29470207 | PRJNA1145574_P_NODE_12030_length_250_cov_0.881356_g11846_i0 | PRJNA1145574 | 12030 | 250 | 0.881356 | 2.20339 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 62.4 | 5.1e-9 | NR | XP_069229049.1 | 1052096 | g11846 | i0 | 73.2 | 0.492 | 41 | 11 | 49.2 | 0 | 127 | 249 | 1267 | 1307 | XP_069229049.1 uncharacterized protein WHR41_04738 [Cladosporium halotolerans] | diamond | 123 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30090894 | 30090894 | PRJNA1145574_P_NODE_13912_length_245_cov_0.906977_g13728_i0 | PRJNA1145574 | 13912 | 245 | 0.906977 | 2.22209365 | Pleosporales | 92860 | Fungi | Fungi | 81.6 | 7.12e-16 | NR | KAH7083079.1 | 798071 | g13728 | i0 | 48.6 | 1.81224489795918 | 74 | 36 | 88.2 | 2 | 243 | 28 | 119 | 192 | KAH7083079.1 heterokaryon incompatibility protein-domain-containing protein, partial [Paraphoma chrysanthemicola] | diamond | 444 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Paraphoma | Paraphoma chrysanthemicola | |
| 32145920 | 32145920 | PRJNA1145574_P_NODE_12838_length_248_cov_0.891429_g12654_i0 | PRJNA1145574 | 12838 | 248 | 0.891429 | 2.21074392 | Debaryomycetaceae | 766764 | Fungi | Fungi | 67.4 | 8.06e-11 | NR | XP_051619817.1 | 497108 | g12654 | i0 | 40 | 6.15725806451613 | 75 | 41 | 90.7 | 1 | 2 | 226 | 384 | 454 | XP_051619817.1 DPL1 [Candida jiufengensis] | diamond | 1527 | 67.8 | 0.994100294985251 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida jiufengensis |
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);;