contig_metadata
19 rows where bioproject = "PRJNA879314", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2133190 | 2133190 | PRJNA879314_P_NODE_2662_length_298_cov_1.040000_g2612_i0 | PRJNA879314 | 2662 | 298 | 1.04 | 3.0992 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 405 | 1.85e-108 | NTclustered | gi|2086738050|ref|XM_043280376.1| | 182096 | g2612 | i0 | 91.497 | 97.6845637583893 | 294 | 25 | 99 | 0 | 3 | 296 | 294 | 1 | Aspergillus chevalieri superoxide dismutase [Cu-Zn] (SOD1), partial mRNA | blastn | 29110 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 2133263 | 2133263 | PRJNA879314_P_NODE_8762_length_246_cov_0.901734_g8712_i0 | PRJNA879314 | 8762 | 246 | 0.901734 | 2.21826564 | Fusarium oxysporum | 5507 | Fungi | Fungi | 418 | 1.9e-112 | NTclustered | gi|1070327743|ref|XM_018386495.1| | 426428 | g8712 | i0 | 97.541 | 51.1707317073171 | 244 | 6 | 99 | 0 | 1 | 244 | 1233 | 990 | Fusarium oxysporum f. sp. lycopersici 4287 formate dehydrogenase (FOXG_07841), mRNA | blastn | 12588 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 7618438 | 7618438 | PRJNA879314_P_NODE_9806_length_244_cov_0.912281_g9756_i0 | PRJNA879314 | 9806 | 244 | 0.912281 | 2.22596564 | Colletotrichum | 5455 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2273247506|ref|XM_049288510.1| | 145971 | g9756 | i0 | 100 | 0.590163934426229 | 29 | 0 | 12 | 0 | 108 | 136 | 140 | 168 | Colletotrichum lupini uncharacterized protein (CLUP02_09532), partial mRNA | blastn | 144 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum lupini | |
| 9785740 | 9785740 | PRJNA879314_P_NODE_7088_length_249_cov_0.886364_g7038_i0 | PRJNA879314 | 7088 | 249 | 0.886364 | 2.20704636 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 215 | 2.72e-51 | NTclustered | gi|2725232518|ref|XM_064897432.1| | 1690604 | g7038 | i0 | 85.784 | 11.4899598393574 | 204 | 28 | 82 | 1 | 5 | 208 | 485 | 283 | Lithohypha guttulata Cytochrome b-c1 complex subunit Rieske, mitochondrial (RIP1), partial mRNA | blastn | 2861 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 15268318 | 15268318 | PRJNA879314_P_NODE_4512_length_253_cov_0.866667_g4462_i0 | PRJNA879314 | 4512 | 253 | 0.866667 | 2.19266751 | Fusarium | 5506 | Fungi | Fungi | 414 | 2.54e-111 | NTclustered | gi|2046453108|ref|XM_041821332.1| | 192010 | g4462 | i0 | 96.774 | 16.7628458498024 | 248 | 8 | 98 | 0 | 4 | 251 | 722 | 475 | Fusarium mangiferae uncharacterized protein (FMAN_07921), partial mRNA | blastn | 4241 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium mangiferae | |
| 16160496 | 16160496 | PRJNA879314_P_NODE_1533_length_361_cov_1.354167_g1483_i0 | PRJNA879314 | 1533 | 361 | 1.354167 | 4.88854287 | Boeremia exigua | 749465 | Fungi | Fungi | 224 | 6.85e-54 | NTclustered | gi|2185367847|ref|XM_046143062.1| | 749465 | g1483 | i0 | 79.743 | 55.1745152354571 | 311 | 61 | 86 | 2 | 1 | 310 | 431 | 122 | Boeremia exigua 60S ribosomal protein L11 (C7974DRAFT_405605), mRNA | blastn | 19918 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 17436015 | 17436015 | PRJNA879314_P_NODE_2234_length_317_cov_0.938525_g2184_i0 | PRJNA879314 | 2234 | 317 | 0.938525 | 2.97512425 | Mycothermus thermophilus | 85995 | Fungi | Fungi | 207 | 5.99e-49 | NTclustered | gi|2837786413|ref|XM_069367991.1| | 85995 | g2184 | i0 | 83.482 | 38.7728706624606 | 224 | 35 | 70 | 2 | 83 | 305 | 202 | 424 | Mycothermus thermophilus 40S ribosomal protein uS7 (VTJ04DRAFT_9443), partial mRNA | blastn | 12291 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Mycothermus | Mycothermus thermophilus | |
| 18709238 | 18709238 | PRJNA879314_P_NODE_4635_length_253_cov_0.866667_g4585_i0 | PRJNA879314 | 4635 | 253 | 0.866667 | 2.19266751 | Aspergillus pseudoglaucus | 1405805 | Fungi | Fungi | 453 | 5.39e-123 | NTclustered | gi|1610617687|ref|NC_041427.1| | 1405805 | g4585 | i0 | 99.203 | 97.5691699604743 | 251 | 2 | 99 | 0 | 3 | 253 | 22564 | 22814 | Aspergillus pseudoglaucus mitochondrion, complete genome | blastn | 24685 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus pseudoglaucus | |
| 18709284 | 18709284 | PRJNA879314_P_NODE_7615_length_248_cov_0.891429_g7565_i0 | PRJNA879314 | 7615 | 248 | 0.891429 | 2.21074392 | Pichia kudriavzevii | 4909 | Fungi | Fungi | 453 | 5.2600000000000005e-123 | NTclustered | gi|1679363616|ref|XM_029463131.1| | 4909 | g7565 | i0 | 99.597 | 3 | 248 | 1 | 100 | 0 | 1 | 248 | 438 | 685 | Pichia kudriavzevii uncharacterized protein (C5L36_0A01200), partial mRNA | blastn | 744 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 19984500 | 19984500 | PRJNA879314_P_NODE_10296_length_243_cov_1.376471_g10246_i0 | PRJNA879314 | 10296 | 243 | 1.376471 | 3.34482453 | Pichia kudriavzevii | 4909 | Fungi | Fungi | 438 | 1.4399999999999996e-118 | NTclustered | gi|2210890466|gb|CP093512.1| | 4909 | g10246 | i0 | 99.177 | 27.5267489711934 | 243 | 2 | 100 | 0 | 1 | 243 | 2278 | 2520 | Pichia kudriavzevii strain GS1-1 chromosome 7 | blastn | 6689 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 22534584 | 22534584 | PRJNA879314_P_NODE_6838_length_249_cov_0.886364_g6788_i0 | PRJNA879314 | 6838 | 249 | 0.886364 | 2.20704636 | Kluyveromyces marxianus | 4911 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|1720289152|gb|CP009305.2| | 4911 | g6788 | i0 | 96.774 | 0.124497991967871 | 31 | 1 | 12 | 0 | 23 | 53 | 601524 | 601494 | Kluyveromyces marxianus strain CCT 7735 (UFV-3) chromosome 3 sequence | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces marxianus | |
| 27086996 | 27086996 | PRJNA879314_P_NODE_522_length_573_cov_2.888000_g473_i0 | PRJNA879314 | 522 | 573 | 2.888 | 16.54824 | Corynascus sepedonium | 190048 | Fungi | Fungi | 45.8 | 0.0146 | NR | KAL2138697.1 | 190048 | g473 | i0 | 35.7 | 0.513089005235602 | 98 | 59 | 49.2 | 2 | 388 | 107 | 8 | 105 | KAL2138697.1 hypothetical protein VTI28DRAFT_6370 [Corynascus sepedonium] | diamond | 294 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Corynascus | Corynascus sepedonium | |
| 27411234 | 27411234 | PRJNA879314_P_NODE_3983_length_261_cov_2.398936_g3933_i0 | PRJNA879314 | 3983 | 261 | 2.398936 | 6.26122296 | Aspergillus | 5052 | Fungi | Fungi | 54.7 | 1.71e-7 | NR | XP_045942712.1 | 138277 | g3933 | i0 | 83.9 | 1.4367816091954 | 31 | 5 | 35.6 | 0 | 13 | 105 | 1 | 31 | XP_045942712.1 conidiation-specific expression protein [Aspergillus melleus] | diamond | 375 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus melleus | |
| 28792061 | 28792061 | PRJNA879314_P_NODE_9067_length_246_cov_0.861272_g9017_i0 | PRJNA879314 | 9067 | 246 | 0.861272 | 2.11872912 | Maudiozyma humilis | 51915 | Fungi | Fungi | 165 | 7.25e-46 | NR | GMM56649.1 | 51915 | g9017 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 467 | 547 | GMM56649.1 amino acid transporter [Maudiozyma humilis] | diamond | 243 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Maudiozyma | Maudiozyma humilis | |
| 29865753 | 29865753 | PRJNA879314_P_NODE_5731_length_251_cov_0.876404_g5681_i0 | PRJNA879314 | 5731 | 251 | 0.876404 | 2.19977404 | Maudiozyma humilis | 51915 | Fungi | Fungi | 169 | 2.6199999999999996e-47 | NR | GMM53668.1 | 51915 | g5681 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 533 | 615 | GMM53668.1 branched-chain-2-oxoacid decarboxylase [Maudiozyma humilis] | diamond | 249 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Maudiozyma | Maudiozyma humilis | |
| 30023888 | 30023888 | PRJNA879314_P_NODE_5391_length_252_cov_0.871508_g5341_i0 | PRJNA879314 | 5391 | 252 | 0.871508 | 2.19620016 | Aspergillus nanangensis | 2582783 | Fungi | Fungi | 77.4 | 5.04e-15 | NR | KAF9894748.1 | 2582783 | g5341 | i0 | 93.2 | 5.92857142857143 | 44 | 3 | 52.4 | 0 | 144 | 13 | 52 | 95 | KAF9894748.1 hypothetical protein FE257_006638 [Aspergillus nanangensis] | diamond | 1494 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nanangensis | |
| 30118378 | 30118378 | PRJNA879314_P_NODE_7592_length_248_cov_0.891429_g7542_i0 | PRJNA879314 | 7592 | 248 | 0.891429 | 2.21074392 | Decorospora gaudefroyi | 184978 | Fungi | Fungi | 86.3 | 1.89e-17 | NR | KAF1828035.1 | 184978 | g7542 | i0 | 58 | 1.95967741935484 | 81 | 34 | 98 | 0 | 246 | 4 | 612 | 692 | KAF1828035.1 hypothetical protein BDW02DRAFT_584775, partial [Decorospora gaudefroyi] | diamond | 486 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Decorospora | Decorospora gaudefroyi | |
| 32054739 | 32054739 | PRJNA879314_P_NODE_7218_length_248_cov_1.365714_g7168_i0 | PRJNA879314 | 7218 | 248 | 1.365714 | 3.38697072 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0158 | NR | KAF2237746.1 | 1048519 | g7168 | i0 | 32.8 | 2.05645161290323 | 64 | 43 | 77.4 | 0 | 19 | 210 | 566 | 629 | KAF2237746.1 heavy metal translocatin [Viridothelium virens] | diamond | 510 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Viridothelium | Viridothelium virens | |
| 32086437 | 32086437 | PRJNA879314_P_NODE_9158_length_245_cov_0.906977_g9108_i0 | PRJNA879314 | 9158 | 245 | 0.906977 | 2.22209365 | Aspergillus | 5052 | Fungi | Fungi | 87 | 3.73e-20 | NR | XP_026614347.1 | 41047 | g9108 | i0 | 70.3 | 1.81224489795918 | 74 | 16 | 90.6 | 3 | 223 | 2 | 1 | 68 | XP_026614347.1 uncharacterized protein CDV56_106194 [Aspergillus thermomutatus] | diamond | 444 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus thermomutatus |
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);;