contig_metadata
10 rows where bioproject = "PRJNA766854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2481399 | 2481399 | PRJNA766854_P_NODE_18802_length_165_cov_20.000000_g18675_i0 | PRJNA766854 | 18802 | 165 | 20 | 33 | Itersonilia | 84741 | Fungi | Fungi | 272 | 9.73e-69 | NTclustered | gi|19744160|dbj|AB072228.1| | 84742 | g18675 | i0 | 96.914 | 98.4666666666667 | 162 | 5 | 98 | 0 | 4 | 165 | 930 | 1091 | Itersonilia perplexans gene for 18S rRNA, partial sequence | blastn | 16247 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans | |
| 4573270 | 4573270 | PRJNA766854_P_NODE_1824_length_310_cov_1.882562_g1699_i0 | PRJNA766854 | 1824 | 310 | 1.882562 | 5.8359422 | Amylostereum laevigatum | 112237 | Fungi | Fungi | 91.6 | 6.14e-14 | NTclustered | gi|1859735543|gb|MT644861.1| | 112237 | g1699 | i0 | 96.364 | 32.0193548387097 | 55 | 2 | 18 | 0 | 194 | 248 | 3827 | 3881 | Amylostereum laevigatum isolate DM1181 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 | 9926 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum laevigatum | |
| 8398158 | 8398158 | PRJNA766854_P_NODE_18667_length_198_cov_15.852071_g18540_i0 | PRJNA766854 | 18667 | 198 | 15.852071 | 31.38710058 | Tomentella asperula | 2712017 | Fungi | Fungi | 113 | 7.76e-21 | NTclustered | gi|2118808643|gb|OK559556.1| | 2712017 | g18540 | i0 | 84.483 | 8.72727272727273 | 116 | 17 | 59 | 1 | 10 | 125 | 144 | 258 | Tomentella asperula voucher SSvantesson392 large subunit ribosomal RNA gene, partial sequence | blastn | 1728 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Tomentella | Tomentella asperula | |
| 17783563 | 17783563 | PRJNA766854_P_NODE_2254_length_285_cov_11.722656_g2128_i0 | PRJNA766854 | 2254 | 285 | 11.722656 | 33.4095696 | Itersonilia | 84741 | Fungi | Fungi | 257 | 5.2e-64 | NTclustered | gi|19744160|dbj|AB072228.1| | 84742 | g2128 | i0 | 97.351 | 64.740350877193 | 151 | 4 | 70 | 0 | 135 | 285 | 941 | 1091 | Itersonilia perplexans gene for 18S rRNA, partial sequence | blastn | 18451 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans | |
| 20332369 | 20332369 | PRJNA766854_P_NODE_18716_length_186_cov_17.974522_g18589_i0 | PRJNA766854 | 18716 | 186 | 17.974522 | 33.43261092 | Itersonilia | 84741 | Fungi | Fungi | 305 | 1.11e-78 | NTclustered | gi|19744160|dbj|AB072228.1| | 84742 | g18589 | i0 | 96.721 | 98.3870967741936 | 183 | 6 | 98 | 0 | 1 | 183 | 1123 | 941 | Itersonilia perplexans gene for 18S rRNA, partial sequence | blastn | 18300 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans | |
| 21608108 | 21608108 | PRJNA766854_P_NODE_18717_length_186_cov_17.458599_g18590_i0 | PRJNA766854 | 18717 | 186 | 17.458599 | 32.47299414 | Itersonilia | 84741 | Fungi | Fungi | 292 | 8.61e-75 | NTclustered | gi|19744160|dbj|AB072228.1| | 84742 | g18590 | i0 | 96.089 | 97.6720430107527 | 179 | 7 | 96 | 0 | 4 | 182 | 941 | 1119 | Itersonilia perplexans gene for 18S rRNA, partial sequence | blastn | 18167 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans | |
| 22883675 | 22883675 | PRJNA766854_P_NODE_18558_length_228_cov_3.944724_g18431_i0 | PRJNA766854 | 18558 | 228 | 3.944724 | 8.99397072 | Opisthokonta | 33154 | Fungi | Fungi | 278 | 3.0800000000000004e-70 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g18431 | i0 | 96.988 | 22.8377192982456 | 166 | 4 | 99 | 1 | 4 | 169 | 1701 | 1865 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 5207 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24157620 | 24157620 | PRJNA766854_P_NODE_1319_length_363_cov_2.281437_g1194_i0 | PRJNA766854 | 1319 | 363 | 2.281437 | 8.28161631 | Agaricomycetes | 155619 | Fungi | Fungi | 167 | 1.1800000000000001e-36 | NTclustered | gi|1859735590|gb|MT644908.1| | 5322 | g1194 | i0 | 98.925 | 25.9449035812672 | 93 | 1 | 26 | 0 | 74 | 166 | 5359 | 5451 | Pleurotus ostreatus isolate DM1049 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 | 9418 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 24157635 | 24157635 | PRJNA766854_P_NODE_18839_length_157_cov_9.820312_g18712_i0 | PRJNA766854 | 18839 | 157 | 9.820312 | 15.41788984 | Mrakiaceae | 1851551 | Fungi | Fungi | 254 | 3.31e-63 | NTclustered | gi|1268830682|gb|MG241162.1| | 84742 | g18712 | i0 | 100 | 87.2611464968153 | 137 | 0 | 87 | 0 | 1 | 137 | 17 | 153 | Itersonilia perplexans isolate IP38 large subunit ribosomal RNA gene, partial sequence | blastn | 13700 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans | |
| 25432607 | 25432607 | PRJNA766854_P_NODE_3240_length_256_cov_15.237885_g3114_i0 | PRJNA766854 | 3240 | 256 | 15.237885 | 39.0089856 | Itersonilia | 84741 | Fungi | Fungi | 257 | 4.6e-64 | NTclustered | gi|19744160|dbj|AB072228.1| | 84742 | g3114 | i0 | 97.351 | 82.796875 | 151 | 4 | 98 | 0 | 1 | 151 | 1091 | 941 | Itersonilia perplexans gene for 18S rRNA, partial sequence | blastn | 21196 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Itersonilia | Itersonilia perplexans |
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);;