contig_metadata
15 rows where bioproject = "PRJNA833575", tax_clade = "Opisthokonta" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 824410 | 824410 | PRJNA833575_P_NODE_35381_length_248_cov_0.932961_g35244_i0 | PRJNA833575 | 35381 | 248 | 0.932961 | 2.31374328 | Agaricales | 5338 | Fungi | Fungi | 135 | 1.12e-35 | NR | KAF5370051.1 | 182062 | g35244 | i0 | 81.7 | 27.7741935483871 | 82 | 15 | 99.2 | 0 | 3 | 248 | 102 | 183 | KAF5370051.1 hypothetical protein D9758_001127 [Tetrapyrgos nigripes] | diamond | 6888 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Tetrapyrgos | Tetrapyrgos nigripes | |
| 5057095 | 5057095 | PRJNA833575_P_NODE_44244_length_228_cov_1.704403_g44107_i0 | PRJNA833575 | 44244 | 228 | 1.704403 | 3.88603884 | Fungi | 4751 | Fungi | Fungi | 116 | 6.56e-29 | NR | TFK74285.1 | 181527 | g44107 | i0 | 68.9 | 18.5 | 74 | 23 | 97.4 | 0 | 225 | 4 | 267 | 340 | TFK74285.1 phosphoglycerate kinase [Pluteus cervinus] | diamond | 4218 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Pluteus | Pluteus cervinus | |
| 5927395 | 5927395 | PRJNA833575_P_NODE_26065_length_292_cov_0.914798_g25928_i0 | PRJNA833575 | 26065 | 292 | 0.914798 | 2.6712101599999998 | Gloeophyllum sepiarium | 40444 | Fungi | Fungi | 339 | 1.86e-88 | NTclustered | gi|34915795|emb|AJ583432.1| | 40444 | g25928 | i0 | 87.713 | 92.8835616438356 | 293 | 32 | 100 | 4 | 1 | 292 | 3235 | 2946 | Gloeophyllum sepiarium 28S rRNA gene, isolate P198 | blastn | 27122 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Gloeophyllum | Gloeophyllum sepiarium | |
| 7202293 | 7202293 | PRJNA833575_P_NODE_12926_length_404_cov_1.719403_g12789_i0 | PRJNA833575 | 12926 | 404 | 1.719403 | 6.94638812 | Kwoniella shandongensis | 1734106 | Fungi | Fungi | 189 | 2.8299999999999998e-43 | NTclustered | gi|1799713775|ref|XM_032003036.1| | 1734106 | g12789 | i0 | 83.495 | 41.6683168316832 | 206 | 30 | 50 | 4 | 18 | 221 | 24 | 227 | Kwoniella shandongensis 60S ribosomal protein uL15 (CI109_100300), partial mRNA | blastn | 16834 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 7607179 | 7607179 | PRJNA833575_P_NODE_7846_length_509_cov_2.045455_g7709_i0 | PRJNA833575 | 7846 | 509 | 2.045455 | 10.41136595 | Rhizoctonia solani | 456999 | Fungi | Fungi | 252 | 3.32e-81 | NR | KAJ1304824.1 | 456999 | g7709 | i0 | 77.5 | 4.36738703339882 | 169 | 30 | 99.6 | 1 | 3 | 509 | 46 | 206 | KAJ1304824.1 hypothetical protein OPQ81_005959 [Rhizoctonia solani] | diamond | 2223 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 8477217 | 8477217 | PRJNA833575_P_NODE_32747_length_259_cov_1.468421_g32610_i0 | PRJNA833575 | 32747 | 259 | 1.468421 | 3.80321039 | Rhodotorula graminis | 29898 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|1069917442|ref|XM_018413066.1| | 578459 | g32610 | i0 | 91.892 | 0.142857142857143 | 37 | 3 | 14 | 0 | 2 | 38 | 639 | 675 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_32945), partial mRNA | blastn | 37 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 12303583 | 12303583 | PRJNA833575_P_NODE_34030_length_253_cov_1.826087_g33893_i0 | PRJNA833575 | 34030 | 253 | 1.826087 | 4.62000011 | Epithele typhae | 378194 | Fungi | Fungi | 122 | 1.73e-23 | NTclustered | gi|2234710531|ref|XM_048018404.1| | 378194 | g33893 | i0 | 81.879 | 12.9209486166008 | 149 | 23 | 58 | 4 | 20 | 166 | 192 | 46 | Epithele typhae mitochondrial carrier (BXZ73DRAFT_39567), partial mRNA | blastn | 3269 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 14852513 | 14852513 | PRJNA833575_P_NODE_41632_length_231_cov_1.333333_g41495_i0 | PRJNA833575 | 41632 | 231 | 1.333333 | 3.07999923 | Fungi | 4751 | Fungi | Fungi | 138 | 3.28e-38 | NR | GHJ90305.1 | 104408 | g41495 | i0 | 81.6 | 37.4805194805195 | 76 | 14 | 98.7 | 0 | 3 | 230 | 152 | 227 | GHJ90305.1 hypothetical protein NliqN6_6707 [Naganishia liquefaciens] | diamond | 8658 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 17806320 | 17806320 | PRJNA833575_P_NODE_20854_length_324_cov_1.125490_g20717_i0 | PRJNA833575 | 20854 | 324 | 1.12549 | 3.6465876 | Basidiomycota | 5204 | Fungi | Fungi | 156 | 9.93e-46 | NR | XP_018996939.1 | 1295533 | g20717 | i0 | 68.2 | 21.787037037037 | 107 | 34 | 99.1 | 0 | 323 | 3 | 55 | 161 | XP_018996939.1 40S ribosomal protein S4-A, variant 1 [Cryptococcus amylolentus CBS 6039] | diamond | 7059 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus amylolentus | |
| 22501063 | 22501063 | PRJNA833575_P_NODE_27558_length_283_cov_3.261682_g27421_i0 | PRJNA833575 | 27558 | 283 | 3.261682 | 9.23056006 | Agaricomycetes | 155619 | Fungi | Fungi | 153 | 1.16e-45 | NR | KAG2039897.1 | 48561 | g27421 | i0 | 78.2 | 10.1660777385159 | 87 | 19 | 92.2 | 0 | 282 | 22 | 56 | 142 | KAG2039897.1 ribosomal L37ae protein family-domain-containing protein [Suillus americanus] | diamond | 2877 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus americanus | |
| 27718437 | 27718437 | PRJNA833575_P_NODE_35404_length_247_cov_2.101124_g35267_i0 | PRJNA833575 | 35404 | 247 | 2.101124 | 5.18977628 | Puccinia sorghi | 27349 | Fungi | Fungi | 134 | 1.22e-35 | NR | KNZ59519.1 | 27349 | g35267 | i0 | 94.6 | 0.898785425101215 | 74 | 4 | 89.9 | 0 | 3 | 224 | 345 | 418 | KNZ59519.1 hypothetical protein VP01_1711g2 [Puccinia sorghi] | diamond | 222 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 28286128 | 28286128 | PRJNA833575_P_NODE_24186_length_302_cov_1.824034_g24049_i0 | PRJNA833575 | 24186 | 302 | 1.824034 | 5.50858268 | Suillus lakei | 48574 | Fungi | Fungi | 98.2 | 2.4300000000000003e-21 | NR | KAG1757558.1 | 48574 | g24049 | i0 | 43 | 0.993377483443709 | 100 | 57 | 99.3 | 0 | 300 | 1 | 383 | 482 | KAG1757558.1 ARM repeat-containing protein [Suillus lakei] | diamond | 300 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus lakei | |
| 28791398 | 28791398 | PRJNA833575_P_NODE_36067_length_244_cov_1.811429_g35930_i0 | PRJNA833575 | 36067 | 244 | 1.811429 | 4.41988676 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 45.4 | 0.00418 | NR | KAG0665845.1 | 5537 | g35930 | i0 | 51.3 | 0.479508196721311 | 39 | 19 | 48 | 0 | 126 | 242 | 598 | 636 | KAG0665845.1 H(+)-transporting V1 sector ATPase subunit A [Rhodotorula mucilaginosa] | diamond | 117 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 30054443 | 30054443 | PRJNA833575_P_NODE_46371_length_226_cov_0.917197_g46234_i0 | PRJNA833575 | 46371 | 226 | 0.917197 | 2.07286522 | Puccinia graminis f. sp. tritici | 56615 | Fungi | Fungi | 157 | 2.13e-46 | NR | KAA1132188.1 | 56615 | g46234 | i0 | 97.3 | 2.94690265486726 | 74 | 2 | 98.2 | 0 | 224 | 3 | 59 | 132 | KAA1132188.1 hypothetical protein PGTUg99_002480 [Puccinia graminis f. sp. tritici] | diamond | 666 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 32678110 | 32678110 | PRJNA833575_P_NODE_43580_length_229_cov_0.900000_g43443_i0 | PRJNA833575 | 43580 | 229 | 0.9 | 2.061 | Cristinia sonorae | 1940300 | Fungi | Fungi | 95.5 | 4.13e-21 | NR | KAH8104671.1 | 1940300 | g43443 | i0 | 64.5 | 2.38427947598253 | 62 | 22 | 81.2 | 0 | 186 | 1 | 5 | 66 | KAH8104671.1 fragmin60 [Cristinia sonorae] | diamond | 546 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Stephanosporaceae | Cristinia | Cristinia sonorae |
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);;