contig_metadata
14 rows where bioproject = "PRJNA397733" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1686959 | 1686959 | PRJNA397733_S_NODE_10262_length_188_cov_3.050314_g10174_i0 | PRJNA397733 | 10262 | 188 | 3.050314 | 5.73459032 | uncultured Saccharomycetes | 212404 | Fungi | Fungi | 326 | 8.6e-85 | NTclustered | gi|294861105|gb|GU370918.1| | 212404 | g10174 | i0 | 99.441 | 97.2712765957447 | 179 | 1 | 95 | 0 | 10 | 188 | 1 | 179 | Uncultured Saccharomycetes isolate DGGE gel band 12 26S ribosomal RNA gene, partial sequence | blastn | 18287 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | uncultured Saccharomycetes | ||||
| 2355313 | 2355313 | PRJNA397733_S_NODE_11682_length_177_cov_4.702703_g11594_i0 | PRJNA397733 | 11682 | 177 | 4.702703 | 8.32378431 | Dothideomycetes | 147541 | Fungi | Fungi | 315 | 1.73e-81 | NTclustered | gi|2811941437|gb|PQ403666.1| | 92990 | g11594 | i0 | 98.87 | 100 | 177 | 1 | 100 | 1 | 1 | 177 | 27 | 202 | Trimmatostroma salinum strain EXF-295 small subunit ribosomal RNA gene, partial sequence | blastn | 17700 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Trimmatostroma | Trimmatostroma salinum | |
| 6182975 | 6182975 | PRJNA397733_S_NODE_6185_length_242_cov_5.450704_g6097_i0 | PRJNA397733 | 6185 | 242 | 5.450704 | 13.19070368 | Eukaryota | 2759 | Fungi | Fungi | 442 | 1.1099999999999995e-119 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g6097 | i0 | 99.587 | 99.9380165289256 | 242 | 1 | 100 | 0 | 1 | 242 | 3676 | 3917 | Cladosporium cladosporioides strain DSM 104381 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24185 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 10007987 | 10007987 | PRJNA397733_S_NODE_15368_length_157_cov_2.273438_g15280_i0 | PRJNA397733 | 15368 | 157 | 2.273438 | 3.56929766 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.52e-74 | NTclustered | gi|18147565|dbj|AB054675.1| | 4911 | g15280 | i0 | 100 | 107 | 157 | 0 | 100 | 0 | 1 | 157 | 285 | 129 | Kluyveromyces marxianus gene for 18S rRNA, partial sequence | blastn | 16799 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces marxianus | |
| 12558630 | 12558630 | PRJNA397733_S_NODE_8410_length_207_cov_3.668539_g8322_i0 | PRJNA397733 | 8410 | 207 | 3.668539 | 7.59387573 | root | 1 | Root_unresolved | Root_unresolved | 383 | 5.65e-102 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g8322 | i0 | 100 | 117.12077294686 | 207 | 0 | 100 | 0 | 1 | 207 | 3880389 | 3880595 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 24244 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 13833398 | 13833398 | PRJNA397733_S_NODE_5351_length_262_cov_3.476395_g5263_i0 | PRJNA397733 | 5351 | 262 | 3.476395 | 9.1081549 | root | 1 | Root_unresolved | Root_unresolved | 484 | 1.99e-132 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g5263 | i0 | 100 | 113.908396946565 | 262 | 0 | 100 | 0 | 1 | 262 | 3882256 | 3881995 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 29844 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 21481601 | 21481601 | PRJNA397733_S_NODE_7497_length_220_cov_9.293194_g7409_i0 | PRJNA397733 | 7497 | 220 | 9.293194 | 20.4450268 | Fungi | 4751 | Fungi | Fungi | 407 | 3.61e-109 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g7409 | i0 | 100 | 100 | 220 | 0 | 100 | 0 | 1 | 220 | 234 | 15 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 22000 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 22756861 | 22756861 | PRJNA397733_S_NODE_7318_length_223_cov_5.943299_g7230_i0 | PRJNA397733 | 7318 | 223 | 5.943299 | 13.25355677 | Parastagonospora | 1351751 | Fungi | Fungi | 407 | 3.67e-109 | NTclustered | gi|154563031|gb|EF590321.2| | 215456 | g7230 | i0 | 99.552 | 118.085201793722 | 223 | 1 | 100 | 0 | 1 | 223 | 1637 | 1415 | Phaeosphaeria avenaria f. sp. avenaria strain ATCC 12277 large subunit ribosomal RNA gene, partial sequence | blastn | 26333 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora avenae | |
| 24031663 | 24031663 | PRJNA397733_S_NODE_7199_length_225_cov_7.464286_g7111_i0 | PRJNA397733 | 7199 | 225 | 7.464286 | 16.7946435 | Opisthokonta | 33154 | Fungi | Fungi | 388 | 1.34e-103 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g7111 | i0 | 98.198 | 98.3822222222222 | 222 | 4 | 99 | 0 | 4 | 225 | 2580 | 2359 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22136 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 24031664 | 24031664 | PRJNA397733_S_NODE_8079_length_211_cov_10.483516_g7991_i0 | PRJNA397733 | 8079 | 211 | 10.483516 | 22.12021876 | root | 1 | Root_unresolved | Root_unresolved | 363 | 7.539999999999999e-96 | NTclustered | gi|1354561844|gb|MH023283.1| | 4932 | g7991 | i0 | 97.63 | 106 | 211 | 5 | 100 | 0 | 1 | 211 | 947 | 737 | Saccharomyces cerevisiae strain GITA551 small subunit ribosomal RNA gene, partial sequence | blastn | 22366 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 25306053 | 25306053 | PRJNA397733_S_NODE_1560_length_517_cov_6.290984_g1084_i1 | PRJNA397733 | 1560 | 517 | 6.290984 | 32.52438728 | Ascomycota | 4890 | Fungi | Fungi | 939 | 0 | NTclustered | gi|1846443776|gb|MT536090.1| | 5061 | g1084 | i1 | 99.42 | 100 | 517 | 3 | 100 | 0 | 1 | 517 | 554 | 38 | Aspergillus niger isolate PUD large subunit ribosomal RNA gene, partial sequence | blastn | 51700 | 939 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 26632221 | 26632221 | PRJNA397733_S_NODE_7661_length_218_cov_2.899471_g7573_i0 | PRJNA397733 | 7661 | 218 | 2.899471 | 6.32084678 | Daldinia caldariorum | 326644 | Fungi | Fungi | 42.7 | 0.0274 | NR | XP_047793239.1 | 326644 | g7573 | i0 | 52.8 | 0.495412844036697 | 36 | 17 | 49.5 | 0 | 201 | 94 | 14 | 49 | XP_047793239.1 uncharacterized protein F4812DRAFT_419477 [Daldinia caldariorum] | diamond | 108 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Daldinia | Daldinia caldariorum | |
| 31023268 | 31023268 | PRJNA397733_S_NODE_13155_length_168_cov_2.625899_g13067_i0 | PRJNA397733 | 13155 | 168 | 2.625899 | 4.41151032 | Aspergillus alliaceus | 209559 | Fungi | Fungi | 39.3 | 0.0483 | NR | XP_031897224.1 | 209559 | g13067 | i0 | 36.7 | 0.535714285714286 | 30 | 19 | 53.6 | 0 | 154 | 65 | 8 | 37 | XP_031897224.1 uncharacterized protein BDW43DRAFT_166882 [Aspergillus alliaceus] | diamond | 90 | 39.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus alliaceus | |
| 31908692 | 31908692 | PRJNA397733_S_NODE_14617_length_160_cov_3.488550_g14529_i0 | PRJNA397733 | 14617 | 160 | 3.48855 | 5.58168 | Cadophora malorum | 108018 | Fungi | Fungi | 53.1 | 2.19e-6 | NR | KAG4414689.1 | 108018 | g14529 | i0 | 65.5 | 6.88125 | 29 | 10 | 54.4 | 0 | 3 | 89 | 6 | 34 | KAG4414689.1 hypothetical protein IFR04_012171 [Cadophora malorum] | diamond | 1101 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Cadophora | Cadophora malorum |
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);;