contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2900245 | 2900245 | PRJNA1240805_P_NODE_203_length_1024_cov_12.697436_g178_i0 | PRJNA1240805 | 203 | 1024 | 12.697436 | 130.02174464 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 579 | 3.66e-207 | NR | GHJ90081.1 | 104408 | g178 | i0 | 92.3 | 0.9111328125 | 311 | 24 | 91.1 | 0 | 1002 | 70 | 1 | 311 | GHJ90081.1 hypothetical protein NliqN6_6483 [Naganishia liquefaciens] | diamond | 933 | 579 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 13103227 | 13103227 | PRJNA1240805_P_NODE_1391_length_420_cov_14.835580_g1342_i0 | PRJNA1240805 | 1391 | 420 | 14.83558 | 62.309436 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 135 | 9.89e-34 | NR | GHJ86438.1 | 104408 | g1342 | i0 | 92.2 | 0.55 | 77 | 6 | 55 | 0 | 399 | 169 | 910 | 986 | GHJ86438.1 hypothetical protein NliqN6_2840 [Naganishia liquefaciens] | diamond | 231 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 16926660 | 16926660 | PRJNA1240805_P_NODE_254_length_913_cov_5.304398_g226_i0 | PRJNA1240805 | 254 | 913 | 5.304398 | 48.42915374 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 410 | 2.39e-142 | NR | GHJ87733.1 | 104408 | g226 | i0 | 89.6 | 0.759036144578313 | 231 | 24 | 75.9 | 0 | 831 | 139 | 1 | 231 | GHJ87733.1 hypothetical protein NliqN6_4135 [Naganishia liquefaciens] | diamond | 693 | 410 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 17628234 | 17628234 | PRJNA1240805_P_NODE_114_length_1244_cov_14.835983_g98_i0 | PRJNA1240805 | 114 | 1244 | 14.835983 | 184.55962852 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 428 | 3.8e-132 | NR | GHJ86219.1 | 104408 | g98 | i0 | 75.7 | 0.754823151125402 | 313 | 70 | 74.3 | 3 | 24 | 947 | 1501 | 1812 | GHJ86219.1 hypothetical protein NliqN6_2621 [Naganishia liquefaciens] | diamond | 939 | 428 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 26775358 | 26775358 | PRJNA1240805_P_NODE_221_length_983_cov_12.336188_g194_i0 | PRJNA1240805 | 221 | 983 | 12.336188 | 121.26472804 | Naganishia | 1851509 | Fungi | Fungi | 308 | 6.060000000000001e-91 | NR | KAJ9097629.1 | 89922 | g194 | i0 | 72.9 | 1.39471007121058 | 229 | 60 | 69.3 | 2 | 960 | 280 | 1417 | 1645 | KAJ9097629.1 hypothetical protein QFC21_004665 [Naganishia friedmannii] | diamond | 1371 | 308 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia friedmannii | |
| 27073530 | 27073530 | PRJNA1240805_P_NODE_6842_length_175_cov_5.515873_g6793_i0 | PRJNA1240805 | 6842 | 175 | 5.515873 | 9.65277775 | Tilletia horrida | 155126 | Fungi | Fungi | 48.1 | 1.89e-4 | NR | KAK0544641.1 | 155126 | g6793 | i0 | 72.4 | 0.497142857142857 | 29 | 8 | 49.7 | 0 | 153 | 67 | 666 | 694 | KAK0544641.1 Serine carboxypeptidase S28 [Tilletia horrida] | diamond | 87 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Tilletiales | Tilletiaceae | Tilletia | Tilletia horrida | |
| 27168173 | 27168173 | PRJNA1240805_P_NODE_4062_length_229_cov_1.672222_g4013_i0 | PRJNA1240805 | 4062 | 229 | 1.672222 | 3.82938838 | Filobasidium floriforme | 5210 | Fungi | Fungi | 60.1 | 6.32e-10 | NR | KAG7566939.1 | 5210 | g4013 | i0 | 73.7 | 0.497816593886463 | 38 | 10 | 49.8 | 0 | 228 | 115 | 33 | 70 | KAG7566939.1 hypothetical protein FFLO_01318 [Filobasidium floriforme] | diamond | 114 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 28241952 | 28241952 | PRJNA1240805_P_NODE_3806_length_237_cov_3.845745_g3757_i0 | PRJNA1240805 | 3806 | 237 | 3.845745 | 9.11441565 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 43.9 | 0.0125 | NR | KAI0738338.1 | 1140402 | g3757 | i0 | 61.5 | 0.493670886075949 | 39 | 14 | 49.4 | 1 | 119 | 3 | 65 | 102 | KAI0738338.1 hypothetical protein C8Q80DRAFT_272388 [Daedaleopsis nitida] | diamond | 117 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 28336868 | 28336868 | PRJNA1240805_P_NODE_1686_length_376_cov_9.535168_g1637_i0 | PRJNA1240805 | 1686 | 376 | 9.535168 | 35.85223168 | Naganishia cerealis | 610337 | Fungi | Fungi | 97.4 | 7.550000000000001e-21 | NR | KAJ9092061.1 | 610337 | g1637 | i0 | 82.3 | 0.49468085106383 | 62 | 11 | 49.5 | 0 | 23 | 208 | 388 | 449 | KAJ9092061.1 hypothetical protein QFC19_008835 [Naganishia cerealis] | diamond | 186 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia cerealis | |
| 28400016 | 28400016 | PRJNA1240805_P_NODE_366_length_788_cov_22.893099_g333_i0 | PRJNA1240805 | 366 | 788 | 22.893099 | 180.39762012 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 180 | 3.2399999999999996e-48 | NR | KAI0757141.1 | 1140402 | g333 | i0 | 94.1 | 0.384517766497462 | 101 | 6 | 38.5 | 0 | 122 | 424 | 1 | 101 | KAI0757141.1 hypothetical protein C8Q80DRAFT_1116385 [Daedaleopsis nitida] | diamond | 303 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 29000290 | 29000290 | PRJNA1240805_P_NODE_2948_length_274_cov_1.968889_g2899_i0 | PRJNA1240805 | 2948 | 274 | 1.968889 | 5.39475586 | Ceratobasidium sp. UAMH 1175 | 1768090 | Fungi | Fungi | 52 | 2.93e-5 | NR | KAG9074419.1 | 2601501 | g2899 | i0 | 96.2 | 0.284671532846715 | 26 | 1 | 28.5 | 0 | 264 | 187 | 415 | 440 | KAG9074419.1 hypothetical protein FS749_014022, partial [Ceratobasidium sp. UAMH 11750] | diamond | 78 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. UAMH 11750 | |
| 29094765 | 29094765 | PRJNA1240805_P_NODE_968_length_507_cov_24.259825_g921_i0 | PRJNA1240805 | 968 | 507 | 24.259825 | 122.99731275 | Naganishia adeliensis | 92952 | Fungi | Fungi | 237 | 1.36e-77 | NR | KAJ9110210.1 | 92952 | g921 | i0 | 87.1 | 1.46745562130178 | 132 | 17 | 78.1 | 0 | 70 | 465 | 1 | 132 | KAJ9110210.1 hypothetical protein QFC20_003062 [Naganishia adeliensis] | diamond | 744 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia adeliensis | |
| 29189517 | 29189517 | PRJNA1240805_P_NODE_649_length_616_cov_2.121693_g603_i0 | PRJNA1240805 | 649 | 616 | 2.121693 | 13.06962888 | Daedaleopsis nitida | 1140402 | Fungi | Fungi | 104 | 5.0499999999999995e-25 | NR | KAI0742903.1 | 1140402 | g603 | i0 | 62.4 | 0.413961038961039 | 85 | 25 | 38 | 2 | 469 | 236 | 27 | 111 | KAI0742903.1 hypothetical protein C8Q80DRAFT_939915 [Daedaleopsis nitida] | diamond | 255 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Daedaleopsis | Daedaleopsis nitida | |
| 29252270 | 29252270 | PRJNA1240805_P_NODE_109_length_1281_cov_12.219968_g95_i0 | PRJNA1240805 | 109 | 1281 | 12.219968 | 156.53779008 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 596 | 3.759999999999999e-212 | NR | GHJ90339.1 | 104408 | g95 | i0 | 86.4 | 0.789227166276347 | 337 | 46 | 78.9 | 0 | 203 | 1213 | 1 | 337 | GHJ90339.1 hypothetical protein NliqN6_6741 [Naganishia liquefaciens] | diamond | 1011 | 596 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 29410282 | 29410282 | PRJNA1240805_P_NODE_409_length_745_cov_17.478448_g373_i0 | PRJNA1240805 | 409 | 745 | 17.478448 | 130.2144376 | Ceratobasidium sp. 395 | 2600204 | Fungi | Fungi | 226 | 1.65e-69 | NR | KAG8699349.1 | 2600204 | g373 | i0 | 79.9 | 1.98120805369128 | 164 | 21 | 64 | 3 | 725 | 249 | 147 | 303 | KAG8699349.1 hypothetical protein FRC09_006669 [Ceratobasidium sp. 395] | diamond | 1476 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 395 | |
| 29757545 | 29757545 | PRJNA1240805_P_NODE_711_length_587_cov_15.195167_g665_i0 | PRJNA1240805 | 711 | 587 | 15.195167 | 89.19563029 | Ceratobasidium sp. 414 | 2600205 | Fungi | Fungi | 116 | 7.440000000000001e-29 | NR | KAG8734490.1 | 2600205 | g665 | i0 | 40.2 | 0.914821124361158 | 179 | 63 | 70 | 4 | 489 | 79 | 20 | 196 | KAG8734490.1 hypothetical protein FRC10_011701 [Ceratobasidium sp. 414] | diamond | 537 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 414 | |
| 29978777 | 29978777 | PRJNA1240805_P_NODE_2591_length_294_cov_7.767347_g2542_i0 | PRJNA1240805 | 2591 | 294 | 7.767347 | 22.83600018 | Naganishia vaughanmartiniae | 1424756 | Fungi | Fungi | 87 | 5.87e-19 | NR | KAJ9123425.1 | 1424756 | g2542 | i0 | 83.7 | 0.5 | 49 | 8 | 50 | 0 | 211 | 65 | 135 | 183 | KAJ9123425.1 hypothetical protein QFC22_001627 [Naganishia vaughanmartiniae] | diamond | 147 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia vaughanmartiniae | |
| 30376484 | 30376484 | PRJNA1240805_P_NODE_2012_length_341_cov_4.561644_g1963_i0 | PRJNA1240805 | 2012 | 341 | 4.561644 | 15.55520604 | Sporobolomyces | 5429 | Fungi | Fungi | 70.9 | 4e-13 | NR | GAA6012139.1 | 183961 | g1963 | i0 | 71 | 1.08211143695015 | 62 | 17 | 54.5 | 1 | 194 | 9 | 53 | 113 | GAA6012139.1 hypothetical protein JCM11491_001761 [Sporobolomyces phaffii] | diamond | 369 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 30831794 | 30831794 | PRJNA1240805_P_NODE_1174_length_460_cov_15.021898_g1126_i0 | PRJNA1240805 | 1174 | 460 | 15.021898 | 69.1007308 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 138 | 2.62e-39 | NR | GHJ89931.1 | 104408 | g1126 | i0 | 76.4 | 0.691304347826087 | 106 | 22 | 69.1 | 1 | 48 | 365 | 1 | 103 | GHJ89931.1 hypothetical protein NliqN6_6333 [Naganishia liquefaciens] | diamond | 318 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 30958368 | 30958368 | PRJNA1240805_P_NODE_874_length_536_cov_6.308008_g827_i0 | PRJNA1240805 | 874 | 536 | 6.308008 | 33.81092288 | Naganishia albida | 100951 | Fungi | Fungi | 291 | 7.829999999999997e-88 | NR | KAI5448964.1 | 100951 | g827 | i0 | 95.4 | 2.56902985074627 | 153 | 7 | 85.6 | 0 | 515 | 57 | 1331 | 1483 | KAI5448964.1 rRNA biogenesis protein rrp5, variant 2 [Naganishia albida] | diamond | 1377 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 32255271 | 32255271 | PRJNA1240805_P_NODE_1998_length_342_cov_10.972696_g1949_i0 | PRJNA1240805 | 1998 | 342 | 10.972696 | 37.52662032 | Malassezia japonica | 223818 | Fungi | Fungi | 48.9 | 4.69e-4 | NR | XP_060120851.1 | 223818 | g1949 | i0 | 75.8 | 0.578947368421053 | 33 | 8 | 28.9 | 0 | 321 | 223 | 172 | 204 | XP_060120851.1 60S ribosomal protein L16A [Malassezia japonica] | diamond | 198 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 32620788 | 32620788 | PRJNA1240805_P_NODE_3100_length_265_cov_4.759259_g3051_i0 | PRJNA1240805 | 3100 | 265 | 4.759259 | 12.61203635 | Ceratobasidium | 5251 | Fungi | Fungi | 110 | 3.82e-28 | NR | KAF8610427.1 | 305860 | g3051 | i0 | 71.3 | 1.78867924528302 | 80 | 22 | 89.4 | 1 | 1 | 237 | 117 | 196 | KAF8610427.1 hypothetical protein BDV93DRAFT_568477 [Ceratobasidium sp. AG-I] | diamond | 474 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-I |
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);;