contig_metadata
15 rows where bioproject = "PRJNA1218818" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6149140 | 6149140 | PRJNA1218818_P_NODE_21065_length_272_cov_1.085427_g20998_i0 | PRJNA1218818 | 21065 | 272 | 1.085427 | 2.95236144 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 2.48e-7 | NTclustered | gi|1633817380|gb|MK333197.1| | 71600 | g20998 | i0 | 97.5 | 18.3492647058824 | 40 | 1 | 15 | 0 | 217 | 256 | 21316 | 21355 | Graphis scripta mitochondrion | blastn | 4991 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Graphis | Graphis scripta | |
| 6149157 | 6149157 | PRJNA1218818_P_NODE_6885_length_463_cov_1.997436_g6818_i0 | PRJNA1218818 | 6885 | 463 | 1.997436 | 9.24812868 | Lembosiniella | 2610783 | Fungi | Fungi | 747 | 0 | NTclustered | gi|2547073229|gb|OR286579.1| | 3061021 | g6818 | i0 | 96.078 | 98.1425485961123 | 459 | 16 | 99 | 2 | 7 | 463 | 459 | 1 | Lembosiniella sp. G18 large subunit ribosomal RNA gene, partial sequence | blastn | 45440 | 747 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Lembosiniella | Lembosiniella sp. G18 | |||
| 7424225 | 7424225 | PRJNA1218818_P_NODE_25706_length_248_cov_0.880000_g25639_i0 | PRJNA1218818 | 25706 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 459 | 1.13e-124 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g25639 | i0 | 100 | 97.2459677419355 | 248 | 0 | 100 | 0 | 1 | 248 | 707745 | 707498 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 24117 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 7987181 | 7987181 | PRJNA1218818_P_NODE_24727_length_250_cov_0.870056_g24660_i0 | PRJNA1218818 | 24727 | 250 | 0.870056 | 2.17514 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 462 | 8.83e-126 | NTclustered | gi|2801356676|ref|XM_503021.3| | 4952 | g24660 | i0 | 100 | 2 | 250 | 0 | 100 | 0 | 1 | 250 | 1374 | 1125 | Yarrowia lipolytica uncharacterized protein (YALI1_D24361g), partial mRNA | blastn | 500 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 7987266 | 7987266 | PRJNA1218818_P_NODE_6327_length_483_cov_1.163415_g6260_i0 | PRJNA1218818 | 6327 | 483 | 1.163415 | 5.61929445 | Hormonema carpetanum | 284138 | Fungi | Fungi | 564 | 4.89e-156 | NTclustered | gi|1407920319|gb|MF611880.1| | 284138 | g6260 | i0 | 91.484 | 91.3975155279503 | 411 | 33 | 85 | 1 | 75 | 483 | 2078 | 2488 | Hormonema carpetanum culture ATCC:74360 28S ribosomal RNA gene, complete sequence | blastn | 44145 | 564 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Hormonema | Hormonema carpetanum | |
| 7987288 | 7987288 | PRJNA1218818_P_NODE_8047_length_427_cov_2.228814_g7980_i0 | PRJNA1218818 | 8047 | 427 | 2.228814 | 9.51703578 | Dothideales sp. 80 OA-2013 | 1321868 | Fungi | Fungi | 750 | 0 | NTclustered | gi|480327068|gb|JX535091.1| | 1321868 | g7980 | i0 | 98.364 | 100.236533957845 | 428 | 6 | 100 | 1 | 1 | 427 | 1826 | 1399 | Dothideales sp. 80 OA-2013 large subunit ribosomal RNA gene, partial sequence | blastn | 42801 | 750 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothideales sp. 80 OA-2013 | |||
| 14362796 | 14362796 | PRJNA1218818_P_NODE_25452_length_248_cov_0.880000_g25385_i0 | PRJNA1218818 | 25452 | 248 | 0.88 | 2.1824 | Hirsutella rhossiliensis | 111463 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2124720235|ref|XM_044862571.1| | 111463 | g25385 | i0 | 100 | 0.120967741935484 | 30 | 0 | 12 | 0 | 71 | 100 | 776 | 747 | Hirsutella rhossiliensis trans-sialidase-like protein (HRG_04100), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Hirsutella | Hirsutella rhossiliensis | |
| 15636575 | 15636575 | PRJNA1218818_P_NODE_12833_length_343_cov_1.711111_g12766_i0 | PRJNA1218818 | 12833 | 343 | 1.711111 | 5.86911073 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 634 | 2.5299999999999996e-177 | NTclustered | gi|1209454411|ref|NG_055393.1| | 4952 | g12766 | i0 | 100 | 87.0204081632653 | 343 | 0 | 100 | 0 | 1 | 343 | 1692 | 1350 | Yarrowia lipolytica NRRL YB-423 28S rRNA, partial sequence; from TYPE material | blastn | 29848 | 634 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 19459815 | 19459815 | PRJNA1218818_P_NODE_27136_length_244_cov_2.701754_g27069_i0 | PRJNA1218818 | 27136 | 244 | 2.701754 | 6.59227976 | Aspergillus versicolor | 46472 | Fungi | Fungi | 187 | 5.7799999999999984e-43 | NTclustered | gi|2028144988|ref|XM_040812212.1| | 1036611 | g27069 | i0 | 80.658 | 13.4385245901639 | 243 | 45 | 99 | 2 | 3 | 244 | 220 | 461 | Aspergillus versicolor CBS 583.65 40S ribosomal protein uS19 (ASPVEDRAFT_40803), mRNA | blastn | 3279 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus versicolor | |
| 20735307 | 20735307 | PRJNA1218818_P_NODE_6817_length_466_cov_1.129771_g6750_i0 | PRJNA1218818 | 6817 | 466 | 1.129771 | 5.26473286 | Fonsecaea multimorphosa | 979981 | Fungi | Fungi | 353 | 1.11e-92 | NTclustered | gi|1027036282|ref|XM_016779232.1| | 1442371 | g6750 | i0 | 81.179 | 95.1845493562232 | 441 | 81 | 94 | 2 | 24 | 463 | 40 | 479 | Fonsecaea multimorphosa CBS 102226 ADP-ribosylation factor (Z520_08736), partial mRNA | blastn | 44356 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Fonsecaea | Fonsecaea multimorphosa | |
| 21448226 | 21448226 | PRJNA1218818_P_NODE_24197_length_251_cov_0.865169_g24130_i0 | PRJNA1218818 | 24197 | 251 | 0.865169 | 2.17157419 | Ascomycota | 4890 | Fungi | Fungi | 147 | 1.01e-30 | NTclustered | gi|2781542089|ref|XM_066932947.1| | 44089 | g24130 | i0 | 81.026 | 69.1713147410359 | 195 | 28 | 75 | 8 | 1 | 189 | 483 | 292 | Dipodascopsis tothii cyclophilin-like domain-containing protein (V1510DRAFT_411685), mRNA | blastn | 17362 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis tothii | |
| 23286027 | 23286027 | PRJNA1218818_P_NODE_25679_length_248_cov_0.880000_g25612_i0 | PRJNA1218818 | 25679 | 248 | 0.88 | 2.1824 | Hypoxylon fragiforme | 63214 | Fungi | Fungi | 425 | 1.15e-114 | NTclustered | gi|1859735575|gb|MT644893.1| | 63214 | g25612 | i0 | 97.581 | 103.032258064516 | 248 | 6 | 100 | 0 | 1 | 248 | 3779 | 4026 | Hypoxylon fragiforme isolate DM1087 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 | 25552 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon fragiforme | |
| 24560002 | 24560002 | PRJNA1218818_P_NODE_28500_length_242_cov_0.911243_g28433_i0 | PRJNA1218818 | 28500 | 242 | 0.911243 | 2.20520806 | Truncatella angustata | 152316 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|2154482998|gb|OL604502.1| | 152316 | g28433 | i0 | 100 | 99.9876033057851 | 242 | 0 | 100 | 0 | 1 | 242 | 3729 | 3970 | Truncatella angustata strain S358 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 | 24197 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Sporocadaceae | Truncatella | Truncatella angustata | |
| 28746467 | 28746467 | PRJNA1218818_P_NODE_25567_length_248_cov_0.880000_g25500_i0 | PRJNA1218818 | 25567 | 248 | 0.88 | 2.1824 | Schizothecium vesticola | 314040 | Fungi | Fungi | 43.5 | 0.0215 | NR | KAK0745823.1 | 314040 | g25500 | i0 | 32.3 | 0.75 | 62 | 42 | 75 | 0 | 195 | 10 | 529 | 590 | KAK0745823.1 hypothetical protein B0T18DRAFT_428900 [Schizothecium vesticola] | diamond | 186 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Schizotheciaceae | Schizothecium | Schizothecium vesticola | |
| 29819766 | 29819766 | PRJNA1218818_P_NODE_28411_length_242_cov_0.911243_g28344_i0 | PRJNA1218818 | 28411 | 242 | 0.911243 | 2.20520806 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 122 | 4.8e-30 | NR | XP_069234311.1 | 1052096 | g28344 | i0 | 75 | 0.991735537190083 | 80 | 16 | 95.5 | 2 | 1 | 231 | 1250 | 1328 | XP_069234311.1 uncharacterized protein WHR41_00337 [Cladosporium halotolerans] | diamond | 240 | 122 | 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);;