contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15437750 | 15437750 | PRJEB7366_P_NODE_24293_length_152_cov_1.367521_g23859_i0 | PRJEB7366 | 24293 | 152 | 1.367521 | 2.07863192 | Sanghuangporus baumii | 108892 | Fungi | Fungi | 67.4 | 2.13e-11 | NR | OCB91642.1 | 108892 | g23859 | i0 | 78 | 2.96052631578947 | 50 | 9 | 98.7 | 1 | 3 | 152 | 4 | 51 | OCB91642.1 hypothetical protein A7U60_g1103 [Sanghuangporus baumii] | diamond | 450 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Sanghuangporus | Sanghuangporus baumii | |
| 18847239 | 18847239 | PRJEB7366_P_NODE_17475_length_184_cov_1.610738_g17041_i0 | PRJEB7366 | 17475 | 184 | 1.610738 | 2.96375792 | Agaricomycetes | 155619 | Fungi | Fungi | 109 | 4.13e-26 | NR | KAH9981224.1 | 71967 | g17041 | i0 | 90 | 7.82608695652174 | 60 | 6 | 97.8 | 0 | 182 | 3 | 225 | 284 | KAH9981224.1 heat shock protein 70 family [Lactifluus volemus] | diamond | 1440 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactifluus | Lactifluus volemus | |
| 26939039 | 26939039 | PRJEB7366_P_NODE_18502_length_178_cov_1.370629_g18068_i0 | PRJEB7366 | 18502 | 178 | 1.370629 | 2.43971962 | Cyathus striatus | 68777 | Fungi | Fungi | 59.3 | 3.69e-9 | NR | KAF9011316.1 | 68777 | g18068 | i0 | 56 | 2.71348314606742 | 50 | 22 | 84.3 | 0 | 165 | 16 | 4 | 53 | KAF9011316.1 ribosomal L28e/Mak16 [Cyathus striatus] | diamond | 483 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Cyathus | Cyathus striatus | |
| 26963449 | 26963449 | PRJEB7366_P_NODE_19082_length_175_cov_1.135714_g18648_i0 | PRJEB7366 | 19082 | 175 | 1.135714 | 1.9874995 | Agaricaceae | 5339 | Fungi | Fungi | 108 | 9.97e-26 | NR | KAF5352387.1 | 201217 | g18648 | i0 | 82.8 | 11.9314285714286 | 58 | 10 | 99.4 | 0 | 1 | 174 | 634 | 691 | KAF5352387.1 hypothetical protein D9756_005805 [Leucoagaricus leucothites] | diamond | 2088 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucocoprinus | Leucocoprinus leucothites | |
| 27286982 | 27286982 | PRJEB7366_P_NODE_10003_length_262_cov_1.762115_g9569_i0 | PRJEB7366 | 10003 | 262 | 1.762115 | 4.6167413 | Amanita brunnescens Koide BX | 87326 | Fungi | Fungi | 103 | 1.36e-24 | NR | KAF8707308.1 | 1457509 | g9569 | i0 | 62.7 | 1.8206106870229 | 83 | 30 | 95 | 1 | 3 | 251 | 228 | 309 | KAF8707308.1 hypothetical protein AX14_013648 [Amanita brunnescens Koide BX004] | diamond | 477 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita brunnescens | |
| 27287000 | 27287000 | PRJEB7366_P_NODE_8663_length_288_cov_1.233202_g8229_i0 | PRJEB7366 | 8663 | 288 | 1.233202 | 3.55162176 | Serendipita vermifera MAFF 3 | 109899 | Fungi | Fungi | 65.1 | 5.9e-10 | NR | KIM19935.1 | 933852 | g8229 | i0 | 31 | 0.90625 | 87 | 60 | 90.6 | 0 | 288 | 28 | 22 | 108 | KIM19935.1 hypothetical protein M408DRAFT_18669 [Serendipita vermifera MAFF 305830] | diamond | 261 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita vermifera | |
| 27918474 | 27918474 | PRJEB7366_P_NODE_10545_length_254_cov_1.095890_g10111_i0 | PRJEB7366 | 10545 | 254 | 1.09589 | 2.7835606 | Auriculariales sp. MPI-PUGE-AT- | 1916346 | Fungi | Fungi | 62.8 | 2.65e-9 | NR | KAH7100026.1 | 2829486 | g10111 | i0 | 48.9 | 0.55511811023622 | 47 | 24 | 55.5 | 0 | 252 | 112 | 185 | 231 | KAH7100026.1 RlpA-like double-psi beta-barrel-protein domain-containing protein-containing protein [Auriculariales sp. MPI-PUGE-AT-0066] | diamond | 141 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariales sp. MPI-PUGE-AT-0066 | |||
| 28708078 | 28708078 | PRJEB7366_P_NODE_13347_length_218_cov_1.306011_g12913_i0 | PRJEB7366 | 13347 | 218 | 1.306011 | 2.84710398 | Abortiporus biennis | 137743 | Fungi | Fungi | 55.5 | 8.64e-7 | NR | KAI0786235.1 | 137743 | g12913 | i0 | 48 | 0.688073394495413 | 50 | 26 | 68.8 | 0 | 16 | 165 | 392 | 441 | KAI0786235.1 serine carboxypeptidase [Abortiporus biennis] | diamond | 150 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Podoscyphaceae | Abortiporus | Abortiporus biennis | |
| 28890074 | 28890074 | PRJEB7366_P_NODE_3728_length_487_cov_3.095133_g3307_i0 | PRJEB7366 | 3728 | 487 | 3.095133 | 15.07329771 | Basidiomycota | 5204 | Fungi | Fungi | 165 | 6.38e-49 | NR | KAI0035996.1 | 1314806 | g3307 | i0 | 53.4 | 9.90554414784394 | 161 | 73 | 99.2 | 2 | 3 | 485 | 7 | 165 | KAI0035996.1 translationally controlled tumor-associated [Vararia minispora EC-137] | diamond | 4824 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Lachnocladiaceae | Vararia | Vararia minispora | |
| 28928965 | 28928965 | PRJEB7366_P_NODE_24568_length_151_cov_1.379310_g24134_i0 | PRJEB7366 | 24568 | 151 | 1.37931 | 2.0827581 | Tricholoma furcatifolium | 2724999 | Fungi | Fungi | 67.4 | 2.12e-11 | NR | KAG6827489.1 | 2724999 | g24134 | i0 | 66 | 4.96688741721854 | 50 | 17 | 99.3 | 0 | 150 | 1 | 325 | 374 | KAG6827489.1 hypothetical protein H0H92_011565 [Tricholoma furcatifolium] | diamond | 750 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Tricholoma | Tricholoma furcatifolium | |
| 29055405 | 29055405 | PRJEB7366_P_NODE_6608_length_342_cov_1.996743_g6174_i0 | PRJEB7366 | 6608 | 342 | 1.996743 | 6.82886106 | Sporobolomyces phaffii | 183961 | Fungi | Fungi | 137 | 2.89e-35 | NR | GAA6004758.1 | 183961 | g6174 | i0 | 64.5 | 6.64912280701754 | 107 | 37 | 93.9 | 1 | 21 | 341 | 13 | 118 | GAA6004758.1 hypothetical protein JCM11491_002219 [Sporobolomyces phaffii] | diamond | 2274 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 29174492 | 29174492 | PRJEB7366_P_NODE_2109_length_670_cov_2.725984_g1749_i0 | PRJEB7366 | 2109 | 670 | 2.725984 | 18.2640928 | Polyporales | 5303 | Fungi | Fungi | 171 | 8.24e-45 | NR | KAI0785115.1 | 137743 | g1749 | i0 | 49.7 | 7.2 | 161 | 78 | 71.2 | 2 | 668 | 192 | 888 | 1047 | KAI0785115.1 NAD-specific glutamate dehydrogenase [Abortiporus biennis] | diamond | 4824 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Podoscyphaceae | Abortiporus | Abortiporus biennis | |
| 29616044 | 29616044 | PRJEB7366_P_NODE_14170_length_210_cov_1.142857_g13736_i0 | PRJEB7366 | 14170 | 210 | 1.142857 | 2.3999997 | Fungi | 4751 | Fungi | Fungi | 80.5 | 1.19e-15 | NR | XP_018738965.1 | 1230383 | g13736 | i0 | 52.9 | 3.88571428571429 | 68 | 32 | 97.1 | 0 | 3 | 206 | 360 | 427 | XP_018738965.1 uncharacterized protein MSY001_0325 [Malassezia sympodialis ATCC 42132] | diamond | 816 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 29686400 | 29686400 | PRJEB7366_P_NODE_15130_length_201_cov_1.831325_g14696_i0 | PRJEB7366 | 15130 | 201 | 1.831325 | 3.68096325 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 44.3 | 0.00603 | NR | VDB92379.1 | 718367 | g14696 | i0 | 33.8 | 1.1044776119403 | 74 | 41 | 98.5 | 3 | 199 | 2 | 263 | 336 | VDB92379.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 222 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 29749590 | 29749590 | PRJEB7366_P_NODE_7251_length_322_cov_3.198606_g6817_i0 | PRJEB7366 | 7251 | 322 | 3.198606 | 10.29951132 | Hericium alpestre | 135208 | Fungi | Fungi | 75.9 | 6.64e-15 | NR | TFY78958.1 | 135208 | g6817 | i0 | 35.8 | 2.95341614906832 | 106 | 60 | 97.8 | 3 | 315 | 1 | 5 | 103 | TFY78958.1 hypothetical protein EWM64_g5048 [Hericium alpestre] | diamond | 951 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 29805717 | 29805717 | PRJEB7366_P_NODE_19511_length_173_cov_0.898551_g19077_i0 | PRJEB7366 | 19511 | 173 | 0.898551 | 1.55449323 | Agaricales | 5338 | Fungi | Fungi | 66.6 | 5.01e-11 | NR | TFK74494.1 | 181527 | g19077 | i0 | 83.8 | 5.1849710982659 | 37 | 6 | 64.2 | 0 | 113 | 3 | 1 | 37 | TFK74494.1 class III ADH enzyme [Pluteus cervinus] | diamond | 897 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Pluteus | Pluteus cervinus | |
| 29995486 | 29995486 | PRJEB7366_P_NODE_14611_length_206_cov_1.403509_g14177_i0 | PRJEB7366 | 14611 | 206 | 1.403509 | 2.89122854 | Fungi | 4751 | Fungi | Fungi | 97.4 | 3.3e-23 | NR | KAH9979344.1 | 71967 | g14177 | i0 | 63.2 | 32.4029126213592 | 68 | 25 | 99 | 0 | 1 | 204 | 106 | 173 | KAH9979344.1 2-cysteine peroxiredoxin [Lactifluus volemus] | diamond | 6675 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactifluus | Lactifluus volemus | |
| 30413573 | 30413573 | PRJEB7366_P_NODE_14553_length_206_cov_2.064327_g14119_i0 | PRJEB7366 | 14553 | 206 | 2.064327 | 4.25251362 | Cerrena zonata | 2478898 | Fungi | Fungi | 51.6 | 8.3e-6 | NR | KAK7685927.1 | 2478898 | g14119 | i0 | 56.8 | 1.92233009708738 | 44 | 19 | 64.1 | 0 | 56 | 187 | 114 | 157 | KAK7685927.1 ADP-ribosylation factor-like protein 2 [Cerrena zonata] | diamond | 396 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Cerrenaceae | Cerrena | Cerrena zonata | |
| 30539629 | 30539629 | PRJEB7366_P_NODE_13253_length_219_cov_1.505435_g12819_i0 | PRJEB7366 | 13253 | 219 | 1.505435 | 3.29690265 | Pisolithus sp. | 2055164 | Fungi | Fungi | 116 | 3.07e-32 | NR | BBC11680.1 | 2055164 | g12819 | i0 | 74.6 | 2.9041095890411 | 71 | 18 | 97.3 | 0 | 218 | 6 | 9 | 79 | BBC11680.1 Prp46 protein, partial [Pisolithus sp.] | diamond | 636 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus sp. | |
| 30602739 | 30602739 | PRJEB7366_P_NODE_9933_length_263_cov_2.315789_g9499_i0 | PRJEB7366 | 9933 | 263 | 2.315789 | 6.09052507 | Volvariella volvacea WC 439 | 1457512 | Fungi | Fungi | 48.5 | 8.28e-5 | NR | KAF8652896.1 | 1457512 | g9499 | i0 | 55.3 | 0.433460076045627 | 38 | 17 | 43.3 | 0 | 2 | 115 | 4 | 41 | KAF8652896.1 hypothetical protein AX16_004084 [Volvariella volvacea WC 439] | diamond | 114 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pluteaceae | Volvariella | Volvariella volvacea | |
| 31101014 | 31101014 | PRJEB7366_P_NODE_21415_length_163_cov_2.812500_g20981_i0 | PRJEB7366 | 21415 | 163 | 2.8125 | 4.584375 | Fungi | 4751 | Fungi | Fungi | 90.5 | 1.77e-19 | NR | KAF4574595.1 | 28995 | g20981 | i0 | 77.8 | 9.84662576687117 | 54 | 12 | 99.4 | 0 | 1 | 162 | 382 | 435 | KAF4574595.1 Exoglucanase 1 [Pleurotus pulmonarius] | diamond | 1605 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus pulmonarius | |
| 31259246 | 31259246 | PRJEB7366_P_NODE_24695_length_150_cov_2.634783_g24261_i0 | PRJEB7366 | 24695 | 150 | 2.634783 | 3.9521745 | Fungi | 4751 | Fungi | Fungi | 54.7 | 6.18e-7 | NR | XP_027609005.1 | 139825 | g24261 | i0 | 65.9 | 5.88 | 41 | 14 | 82 | 0 | 143 | 21 | 301 | 341 | XP_027609005.1 Metacaspase-1 [Sparassis crispa] | diamond | 882 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Sparassidaceae | Sparassis | Sparassis crispa | |
| 31519624 | 31519624 | PRJEB7366_P_NODE_6896_length_333_cov_2.137584_g6462_i0 | PRJEB7366 | 6896 | 333 | 2.137584 | 7.11815472 | Cutaneotrichosporon spelunceum | 1672016 | Fungi | Fungi | 63.9 | 1.06e-9 | NR | GMK58095.1 | 1672016 | g6462 | i0 | 37.2 | 0.846846846846847 | 94 | 54 | 80.2 | 1 | 272 | 6 | 13 | 106 | GMK58095.1 hypothetical protein CspeluHIS016_0501270 [Cutaneotrichosporon spelunceum] | diamond | 282 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Cutaneotrichosporon | Cutaneotrichosporon spelunceum | |
| 32342241 | 32342241 | PRJEB7366_P_NODE_19899_length_171_cov_0.838235_g19465_i0 | PRJEB7366 | 19899 | 171 | 0.838235 | 1.43338185 | Armillaria nabsnona | 64368 | Fungi | Fungi | 43.1 | 0.0102 | NR | KAK0240980.1 | 64368 | g19465 | i0 | 44.4 | 1.3859649122807 | 45 | 25 | 78.9 | 0 | 146 | 12 | 145 | 189 | KAK0240980.1 hypothetical protein EDD85DRAFT_786757 [Armillaria nabsnona] | diamond | 237 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria nabsnona | |
| 32563754 | 32563754 | PRJEB7366_P_NODE_22939_length_157_cov_1.295082_g22505_i0 | PRJEB7366 | 22939 | 157 | 1.295082 | 2.03327874 | Malassezia cuniculi | 948313 | Fungi | Fungi | 72.8 | 1.41e-13 | NR | WFD37053.1 | 948313 | g22505 | i0 | 76 | 9.61146496815287 | 50 | 12 | 95.5 | 0 | 157 | 8 | 184 | 233 | WFD37053.1 proteasome endopeptidase complex [Malassezia cuniculi] | diamond | 1509 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi |
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);;