contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21312729 | 21312729 | PRJNA934332_P_NODE_9017_length_247_cov_0.885057_g8930_i0 | PRJNA934332 | 9017 | 247 | 0.885057 | 2.18609079 | Fungi | 4751 | Fungi | Fungi | 129 | 1.04e-32 | NR | XP_066826734.1 | 1397322 | g8930 | i0 | 70.4 | 5.8663967611336 | 81 | 24 | 98.4 | 0 | 243 | 1 | 159 | 239 | XP_066826734.1 Calreticulin-domain-containing protein [Cystobasidium minutum MCA 4210] | diamond | 1449 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 27253163 | 27253163 | PRJNA934332_P_NODE_3523_length_343_cov_6.181481_g3436_i0 | PRJNA934332 | 3523 | 343 | 6.181481 | 21.20247983 | root | 1 | Root_unresolved | Root_unresolved | 119 | 3.5099999999999997e-32 | NR | XP_025373164.1 | 1522189 | g3436 | i0 | 52.6 | 4.98542274052478 | 114 | 54 | 99.7 | 0 | 2 | 343 | 2 | 115 | XP_025373164.1 Profilin/allergen [Ceraceosorus guamensis] | diamond | 1710 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 27348271 | 27348271 | PRJNA934332_P_NODE_8283_length_249_cov_0.875000_g8196_i0 | PRJNA934332 | 8283 | 249 | 0.875 | 2.17875 | Agaricales | 5338 | Fungi | Fungi | 119 | 2.9499999999999993e-31 | NR | XP_007329369.1 | 597362 | g8196 | i0 | 79.7 | 2.68674698795181 | 74 | 15 | 89.2 | 0 | 224 | 3 | 66 | 139 | XP_007329369.1 uncharacterized protein AGABI1DRAFT_113337 [Agaricus bisporus var. burnettii JB137-S8] | diamond | 669 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 27853239 | 27853239 | PRJNA934332_P_NODE_11484_length_230_cov_2.076433_g11397_i0 | PRJNA934332 | 11484 | 230 | 2.076433 | 4.7757959 | Opisthokonta | 33154 | Fungi | Fungi | 126 | 4.44e-35 | NR | XP_007764802.1 | 741705 | g11397 | i0 | 75 | 7.9304347826087 | 76 | 19 | 99.1 | 0 | 1 | 228 | 15 | 90 | XP_007764802.1 nucleoside diphosphate kinase [Coniophora puteana RWD-64-598 SS2] | diamond | 1824 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Coniophoraceae | Coniophora | Coniophora puteana | |
| 27916278 | 27916278 | PRJNA934332_P_NODE_8365_length_249_cov_0.875000_g8278_i0 | PRJNA934332 | 8365 | 249 | 0.875 | 2.17875 | Malassezia | 55193 | Fungi | Fungi | 102 | 4.77e-23 | NR | WFD26891.1 | 180528 | g8278 | i0 | 63.8 | 1.96385542168675 | 80 | 24 | 96.4 | 1 | 246 | 7 | 21 | 95 | WFD26891.1 phosphatidylserine decarboxylase [Malassezia nana] | diamond | 489 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 28674280 | 28674280 | PRJNA934332_P_NODE_5547_length_285_cov_1.216981_g5460_i0 | PRJNA934332 | 5547 | 285 | 1.216981 | 3.46839585 | Mycena | 41247 | Fungi | Fungi | 47.4 | 9.53e-4 | NR | KAJ7453284.1 | 71905 | g5460 | i0 | 50 | 1.53684210526316 | 44 | 22 | 46.3 | 0 | 257 | 126 | 18 | 61 | KAJ7453284.1 hypothetical protein B0H11DRAFT_2326539 [Mycena galericulata] | diamond | 438 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galericulata | |
| 28856464 | 28856464 | PRJNA934332_P_NODE_11388_length_241_cov_0.916667_g11301_i0 | PRJNA934332 | 11388 | 241 | 0.916667 | 2.20916747 | Suillus paluster | 48578 | Fungi | Fungi | 101 | 8.36e-25 | NR | XP_041182667.1 | 48578 | g11301 | i0 | 60.8 | 0.983402489626556 | 79 | 31 | 98.3 | 0 | 3 | 239 | 71 | 149 | XP_041182667.1 ADP-ribosylation factor [Suillus paluster] | diamond | 237 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus paluster | |
| 28888127 | 28888127 | PRJNA934332_P_NODE_2528_length_392_cov_1.241379_g2441_i0 | PRJNA934332 | 2528 | 392 | 1.241379 | 4.86620568 | Puccinia sorghi | 27349 | Fungi | Fungi | 137 | 1.58e-36 | NR | KNZ45269.1 | 27349 | g2441 | i0 | 53.9 | 3.89540816326531 | 128 | 58 | 97.2 | 1 | 12 | 392 | 38 | 165 | KNZ45269.1 ribosomal protein S5 [Puccinia sorghi] | diamond | 1527 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 29361870 | 29361870 | PRJNA934332_P_NODE_9289_length_246_cov_0.890173_g9202_i0 | PRJNA934332 | 9289 | 246 | 0.890173 | 2.18982558 | Filobasidium floriforme | 5210 | Fungi | Fungi | 53.1 | 8.18e-6 | NR | XP_046035848.1 | 5210 | g9202 | i0 | 67.7 | 0.378048780487805 | 31 | 10 | 37.8 | 0 | 145 | 53 | 319 | 349 | XP_046035848.1 uncharacterized protein HD553DRAFT_313613 [Filobasidium floriforme] | diamond | 93 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 29487934 | 29487934 | PRJNA934332_P_NODE_6650_length_266_cov_1.357513_g6563_i0 | PRJNA934332 | 6650 | 266 | 1.357513 | 3.6109845800000002 | Ceratobasidium sp. 423 | 2600206 | Fungi | Fungi | 78.2 | 5.87e-15 | NR | KAG8688034.1 | 2600206 | g6563 | i0 | 41 | 0.93609022556391 | 83 | 45 | 92.5 | 2 | 262 | 17 | 4 | 83 | KAG8688034.1 U3 small nucleolar RNA-associated protein 13, partial [Ceratobasidium sp. 423] | diamond | 249 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 423 | |
| 29968812 | 29968812 | PRJNA934332_P_NODE_6291_length_272_cov_1.492462_g6204_i0 | PRJNA934332 | 6291 | 272 | 1.492462 | 4.05949664 | Eukaryota | 2759 | Fungi | Fungi | 117 | 7.169999999999999e-31 | NR | POW07119.1 | 27350 | g6204 | i0 | 73.7 | 28.7867647058824 | 76 | 19 | 83.8 | 1 | 271 | 44 | 117 | 191 | POW07119.1 hypothetical protein PSTT_08493 [Puccinia striiformis] | diamond | 7830 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 30379944 | 30379944 | PRJNA934332_P_NODE_832_length_655_cov_2.048110_g752_i0 | PRJNA934332 | 832 | 655 | 2.04811 | 13.4151205 | Eukaryota | 2759 | Fungi | Fungi | 190 | 5.99e-56 | NR | XP_021872123.1 | 4999 | g752 | i0 | 53.3 | 5.12977099236641 | 182 | 85 | 83.4 | 0 | 2 | 547 | 93 | 274 | XP_021872123.1 putative 60S acidic ribosomal protein [Kockovaella imperatae] | diamond | 3360 | 191 | 0.994764397905759 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 30814821 | 30814821 | PRJNA934332_P_NODE_5774_length_281_cov_1.139423_g5687_i0 | PRJNA934332 | 5774 | 281 | 1.139423 | 3.20177863 | Puccinia striiformis | 27350 | Fungi | Fungi | 58.9 | 1.13e-7 | NR | POW20931.1 | 27350 | g5687 | i0 | 41.3 | 2.5729537366548 | 80 | 45 | 83.3 | 1 | 17 | 250 | 114 | 193 | POW20931.1 hypothetical protein PSHT_02954 [Puccinia striiformis] | diamond | 723 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 30941443 | 30941443 | PRJNA934332_P_NODE_9594_length_246_cov_0.890173_g9507_i0 | PRJNA934332 | 9594 | 246 | 0.890173 | 2.18982558 | Amanita muscaria Koide BX | 41956 | Fungi | Fungi | 97.8 | 1.3099999999999999e-23 | NR | KIL68019.1 | 946122 | g9507 | i0 | 61.1 | 0.878048780487805 | 72 | 28 | 87.8 | 0 | 2 | 217 | 95 | 166 | KIL68019.1 hypothetical protein M378DRAFT_72303 [Amanita muscaria Koide BX008] | diamond | 216 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita muscaria | |
| 32403226 | 32403226 | PRJNA934332_P_NODE_2819_length_376_cov_0.966997_g2732_i0 | PRJNA934332 | 2819 | 376 | 0.966997 | 3.63590872 | Polyporales | 5303 | Fungi | Fungi | 141 | 5.309999999999999e-38 | NR | VWO94854.1 | 34458 | g2732 | i0 | 54.1 | 7.75531914893617 | 122 | 56 | 97.3 | 0 | 369 | 4 | 111 | 232 | VWO94854.1 Substrate of the Dot/Icm system [Ganoderma boninense] | diamond | 2916 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 32617360 | 32617360 | PRJNA934332_P_NODE_8660_length_248_cov_0.880000_g8573_i0 | PRJNA934332 | 8660 | 248 | 0.88 | 2.1824 | Mycena crocata | 220801 | Fungi | Fungi | 44.3 | 0.0112 | NR | KAJ7113284.1 | 220801 | g8573 | i0 | 34.4 | 0.737903225806452 | 61 | 39 | 72.6 | 1 | 248 | 69 | 511 | 571 | KAJ7113284.1 hypothetical protein C8R43DRAFT_961653 [Mycena crocata] | diamond | 183 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena crocata | |
| 32781621 | 32781621 | PRJNA934332_P_NODE_9760_length_245_cov_0.895349_g9673_i0 | PRJNA934332 | 9760 | 245 | 0.895349 | 2.19360505 | Ustilaginomycetes | 5257 | Fungi | Fungi | 76.6 | 4.48e-14 | NR | XP_012186853.1 | 1305764 | g9673 | i0 | 63.6 | 1.59183673469388 | 66 | 24 | 80.8 | 0 | 33 | 230 | 685 | 750 | XP_012186853.1 likely protein kinase [Pseudozyma hubeiensis SY62] | diamond | 390 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis |
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);;