contig_metadata
11 rows where bioproject = "PRJNA929952", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909185 | 909185 | PRJNA929952_P_NODE_22521_length_174_cov_2.124138_g21227_i0 | PRJNA929952 | 22521 | 174 | 2.124138 | 3.69600012 | Parastagonospora avenae | 1351752 | Fungi | Fungi | 322 | 1.01e-83 | NTclustered | gi|1391724149|gb|MH379773.1| | 215456 | g21227 | i0 | 100 | 112.034482758621 | 174 | 0 | 100 | 0 | 1 | 174 | 71 | 244 | Parastagonospora avenae f. sp. avenae strain SF13 large subunit ribosomal RNA gene, partial sequence | blastn | 19494 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora avenae | |
| 4737519 | 4737519 | PRJNA929952_P_NODE_19944_length_211_cov_58.703297_g18650_i0 | PRJNA929952 | 19944 | 211 | 58.703297 | 123.86395667 | Crinitomyces ghanaensis | 135453 | Fungi | Fungi | 80.5 | 8.5e-11 | NTclustered | gi|1102642894|gb|KY106464.1| | 135453 | g18650 | i0 | 79.699 | 27.0710900473934 | 133 | 9 | 61 | 11 | 76 | 203 | 78 | 197 | Crinitomyces ghanaensis culture CBS:8798 large subunit ribosomal RNA gene, partial sequence | blastn | 5712 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Crinitomyces | Crinitomyces ghanaensis | |
| 8562091 | 8562091 | PRJNA929952_P_NODE_20127_length_208_cov_5.737430_g18833_i0 | PRJNA929952 | 20127 | 208 | 5.73743 | 11.9338544 | Phoma sp. 1 OB-2014 | 1573585 | Fungi | Fungi | 379 | 7.359999999999998e-101 | NTclustered | gi|724090723|gb|KM387394.1| | 1573585 | g18833 | i0 | 99.519 | 81.9423076923077 | 208 | 1 | 100 | 0 | 1 | 208 | 7263 | 7470 | Phoma sp. 1 OB-2014 28S-18S ribosomal RNA intergenic spacer, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17044 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma sp. 1 OB-2014 | |
| 8907618 | 8907618 | PRJNA929952_P_NODE_7507_length_443_cov_6.057971_g6285_i0 | PRJNA929952 | 7507 | 443 | 6.057971 | 26.83681153 | Dothideomycetes | 147541 | Fungi | Fungi | 819 | 0 | NTclustered | gi|1216872738|gb|KY742265.1| | 105696 | g6285 | i0 | 100 | 100 | 443 | 0 | 100 | 0 | 1 | 443 | 1 | 443 | Epicoccum nigrum voucher LC:8158 28S large subunit ribosomal RNA gene, partial sequence | blastn | 44300 | 819 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 11458542 | 11458542 | PRJNA929952_P_NODE_22369_length_175_cov_26.328767_g21075_i0 | PRJNA929952 | 22369 | 175 | 26.328767 | 46.07534225 | Eukaryota | 2759 | Fungi | Fungi | 324 | 2.83e-84 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g21075 | i0 | 100 | 66.3028571428571 | 175 | 0 | 100 | 0 | 1 | 175 | 242 | 68 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 11603 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 13662819 | 13662819 | PRJNA929952_P_NODE_8311_length_415_cov_6.106218_g7055_i0 | PRJNA929952 | 8311 | 415 | 6.106218 | 25.3408047 | Colletotrichum jinshuiense | 2283408 | Fungi | Fungi | 111 | 6.49e-20 | NTclustered | gi|2714474496|gb|CP150811.1| | 2283408 | g7055 | i0 | 78.333 | 3.56626506024096 | 180 | 33 | 43 | 6 | 207 | 383 | 4182452 | 4182628 | Colletotrichum jinshuiense isolate EsH8 chromosome 8 | blastn | 1480 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum jinshuiense | |
| 16557309 | 16557309 | PRJNA929952_P_NODE_11393_length_331_cov_6.572848_g10103_i0 | PRJNA929952 | 11393 | 331 | 6.572848 | 21.75612688 | Didymellaceae | 683158 | Fungi | Fungi | 540 | 5.46e-149 | NTclustered | gi|391883728|gb|JQ768399.1| | 749860 | g10103 | i0 | 96.084 | 119.66163141994 | 332 | 11 | 100 | 2 | 1 | 331 | 1768 | 1438 | Heterophoma verbasci-densiflori isolate 115 large subunit ribosomal RNA gene, partial sequence | blastn | 39608 | 540 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Heterophoma | Heterophoma verbasci-densiflori | |
| 17832358 | 17832358 | PRJNA929952_P_NODE_17574_length_238_cov_6.861244_g16280_i0 | PRJNA929952 | 17574 | 238 | 6.861244 | 16.32976072 | Cladosporium | 5498 | Fungi | Fungi | 392 | 1.11e-104 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g16280 | i0 | 97.807 | 29.9075630252101 | 228 | 3 | 95 | 1 | 13 | 238 | 3314 | 3087 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7118 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 21311277 | 21311277 | PRJNA929952_P_NODE_9937_length_368_cov_4.660767_g8656_i0 | PRJNA929952 | 9937 | 368 | 4.660767 | 17.15162256 | Polyblastidium squamulosum | 2294038 | Fungi | Fungi | 119 | 3.4000000000000003e-22 | NTclustered | gi|1476663660|gb|MG257770.1| | 2294038 | g8656 | i0 | 83.594 | 34.2798913043478 | 128 | 19 | 35 | 2 | 1 | 127 | 8312 | 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 | 12615 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Polyblastidium | Polyblastidium squamulosum | |
| 21657076 | 21657076 | PRJNA929952_P_NODE_20597_length_200_cov_4.040936_g19303_i0 | PRJNA929952 | 20597 | 200 | 4.040936 | 8.081872 | Citeromyces | 36908 | Fungi | Fungi | 158 | 3.58e-34 | NTclustered | gi|913748873|ref|NG_042645.1| | 36909 | g19303 | i0 | 81.34 | 104.47 | 209 | 25 | 100 | 13 | 1 | 200 | 1090 | 887 | Citeromyces matritensis NRRL Y-2407 28S rRNA, partial sequence; from TYPE material | blastn | 20894 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Citeromyces | Citeromyces matritensis | |
| 29867036 | 29867036 | PRJNA929952_P_NODE_21211_length_191_cov_6.456790_g19917_i0 | PRJNA929952 | 21211 | 191 | 6.45679 | 12.3324689 | Botrytis porri | 87229 | Fungi | Fungi | 42 | 0.0225 | NR | XP_038771599.1 | 87229 | g19917 | i0 | 42.1 | 0.596858638743455 | 38 | 22 | 59.7 | 0 | 61 | 174 | 93 | 130 | XP_038771599.1 uncharacterized protein EAF01_005258 [Botrytis porri] | diamond | 114 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis porri |
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);;