contig_metadata
12 rows where bioproject = "PRJNA715461", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1192200 | 1192200 | PRJNA715461_S_NODE_1301_length_222_cov_12644.416107_g1227_i0 | PRJNA715461 | 1301 | 222 | 12644.416107 | 28070.60375754 | Blumeria | 34372 | Fungi | Fungi | 267 | 6.46e-67 | NTclustered | gi|1859735560|gb|MT644878.1| | 34373 | g1227 | i0 | 100 | 64.8603603603604 | 144 | 0 | 65 | 0 | 79 | 222 | 649 | 506 | Blumeria graminis isolate DM1150 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 | 14399 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 5808779 | 5808779 | PRJNA715461_S_NODE_405_length_429_cov_6585.294944_g331_i0 | PRJNA715461 | 405 | 429 | 6585.294944 | 28250.91530976 | Phialophora verrucosa | 39412 | Fungi | Fungi | 340 | 7.89e-89 | NTclustered | gi|336088197|dbj|AB550776.1| | 39412 | g331 | i0 | 86.154 | 72.0745920745921 | 325 | 34 | 75 | 9 | 106 | 425 | 4293 | 3975 | Phialophora verrucosa genes for ITS1, 5.8S rRNA, ITS2 and large subunit rRNA, partial and complete sequence, strain: IFM 5089 | blastn | 30920 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Phialophora | Phialophora verrucosa | |
| 10120769 | 10120769 | PRJNA715461_S_NODE_1528_length_211_cov_4.246377_g1454_i0 | PRJNA715461 | 1528 | 211 | 4.246377 | 8.95985547 | Eurotiomycetes | 147545 | Fungi | Fungi | 285 | 1.68e-72 | NTclustered | gi|1002923410|gb|KU561781.1| | 5501 | g1454 | i0 | 91.429 | 98.9241706161137 | 210 | 14 | 99 | 4 | 1 | 208 | 215 | 8 | Coccidioides immitis strain B11019 28S ribosomal RNA gene, partial sequence | blastn | 20873 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Onygenaceae | Coccidioides | Coccidioides immitis | |
| 11395792 | 11395792 | PRJNA715461_S_NODE_1969_length_197_cov_10.072581_g1895_i0 | PRJNA715461 | 1969 | 197 | 10.072581 | 19.84298457 | Yarrowia | 4951 | Fungi | Fungi | 291 | 3.32e-74 | NTclustered | gi|2497522110|gb|OQ878644.1| | 444778 | g1895 | i0 | 100 | 78.989847715736 | 157 | 0 | 80 | 0 | 38 | 194 | 203 | 47 | Yarrowia phangngaensis isolate T378 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 15561 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia phangngaensis | ||
| 13946063 | 13946063 | PRJNA715461_S_NODE_251_length_551_cov_7.945607_g195_i0 | PRJNA715461 | 251 | 551 | 7.945607 | 43.78029457 | Herpotrichiellaceae | 43219 | Fungi | Fungi | 917 | 0 | NTclustered | gi|4206352|gb|AF050276.1|AF050276 | 40355 | g195 | i0 | 96.898 | 99.0889292196007 | 548 | 15 | 99 | 2 | 1 | 548 | 1110 | 565 | Fonsecaea pedrosoi 18S ribosomal RNA partial sequence, internal transcribed spacer 1, 5.8S ribosomal RNA, internal transcribed spacer 2 complete sequence and 28S ribosomal RNA partial sequence | blastn | 54598 | 922 | 0.994577006507592 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Fonsecaea | Fonsecaea pedrosoi | |
| 16007725 | 16007725 | PRJNA715461_S_NODE_633_length_331_cov_2.019380_g559_i0 | PRJNA715461 | 633 | 331 | 2.01938 | 6.6841478 | Polyblastidium squamulosum | 2294038 | Fungi | Fungi | 130 | 1.4e-25 | NTclustered | gi|1476663660|gb|MG257770.1| | 2294038 | g559 | i0 | 83.942 | 40.7945619335347 | 137 | 20 | 41 | 2 | 24 | 159 | 8303 | 8438 | Heterodermia squamulosa voucher 48701 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 13503 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Polyblastidium | Polyblastidium squamulosum | |
| 17769909 | 17769909 | PRJNA715461_S_NODE_1134_length_235_cov_2.339506_g1060_i0 | PRJNA715461 | 1134 | 235 | 2.339506 | 5.4978391 | Blumeria | 34372 | Fungi | Fungi | 379 | 8.509999999999998e-101 | NTclustered | gi|153902086|dbj|AB273546.1| | 34373 | g1060 | i0 | 99.519 | 82.6085106382979 | 208 | 1 | 89 | 0 | 4 | 211 | 548 | 755 | Blumeria graminis genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, isolate: MUMH1711 | blastn | 19413 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Blumeria | Blumeria graminis | |
| 17769914 | 17769914 | PRJNA715461_S_NODE_334_length_475_cov_128.037313_g267_i0 | PRJNA715461 | 334 | 475 | 128.037313 | 608.17723675 | Ascomycota | 4890 | Fungi | Fungi | 669 | 0 | NTclustered | gi|1840379205|gb|MT453271.1| | 5599 | g267 | i0 | 99.726 | 76.8589473684211 | 365 | 1 | 77 | 0 | 107 | 471 | 915 | 551 | Alternaria alternata isolate DSM100286_DF09_RLCS10 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 | 36508 | 673 | 0.99405646359584 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 19043978 | 19043978 | PRJNA715461_S_NODE_1295_length_222_cov_31801.677852_g1221_i0 | PRJNA715461 | 1295 | 222 | 31801.677852 | 70599.72483144 | Sarocladiaceae | 2502719 | Fungi | Fungi | 267 | 6.46e-67 | NTclustered | gi|157366947|gb|EU119045.1| | 175243 | g1221 | i0 | 100 | 64.8648648648649 | 144 | 0 | 65 | 0 | 79 | 222 | 197 | 54 | Uncultured ascomycete clone Biofilm3-16 small subunit ribosomal RNA gene, partial sequence | blastn | 14400 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 19043980 | 19043980 | PRJNA715461_S_NODE_1735_length_205_cov_17.272727_g1661_i0 | PRJNA715461 | 1735 | 205 | 17.272727 | 35.40909035 | Ascomycota | 4890 | Fungi | Fungi | 374 | 3.3599999999999997e-99 | NTclustered | gi|148357034|dbj|AB304771.1| | 444778 | g1661 | i0 | 100 | 99.2292682926829 | 202 | 0 | 99 | 0 | 1 | 202 | 257 | 56 | Candida phangngensis gene for 26S rRNA, partial sequence, strain: TM2-16 | blastn | 20342 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia phangngaensis | ||
| 22382709 | 22382709 | PRJNA715461_S_NODE_998_length_249_cov_1.528409_g924_i0 | PRJNA715461 | 998 | 249 | 1.528409 | 3.80573841 | Capnodiales sp. 22MS03 | 1254183 | Fungi | Fungi | 344 | 3.32e-90 | NTclustered | gi|411030840|gb|JX270306.1| | 1254183 | g924 | i0 | 96.602 | 15.2128514056225 | 206 | 7 | 83 | 0 | 42 | 247 | 224 | 19 | Capnodiales sp. 22MS03 28S-18S ribosomal RNA intergenic spacer, partial sequence | blastn | 3788 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Capnodiales | Capnodiales sp. 22MS03 | |||
| 25418742 | 25418742 | PRJNA715461_S_NODE_640_length_329_cov_9483.503906_g566_i0 | PRJNA715461 | 640 | 329 | 9483.503906 | 31200.72785074 | Fungi | 4751 | Fungi | Fungi | 134 | 1.07e-26 | NTclustered | gi|1376792008|gb|MG372377.1| | 47023 | g566 | i0 | 96.341 | 26.1641337386018 | 82 | 2 | 25 | 1 | 168 | 249 | 2880 | 2960 | Orbilia vinosa voucher G.M. 2016-05-04-1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 8608 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia vinosa |
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);;