contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17630179 | 17630179 | PRJNA1249535_S_NODE_278934_length_264_cov_3.230366_g275551_i0 | PRJNA1249535 | 278934 | 264 | 3.230366 | 8.52816624 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 70.1 | 1.09e-11 | NR | CAD6586852.1 | 2778381 | g275551 | i0 | 56 | 1.125 | 50 | 22 | 56.8 | 0 | 5 | 154 | 464 | 513 | CAD6586852.1 MAG: hypothetical protein CYPHOPRED_003692 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 297 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 26852450 | 26852450 | PRJNA1249535_S_NODE_226561_length_292_cov_3.520548_g223178_i0 | PRJNA1249535 | 226561 | 292 | 3.520548 | 10.28000016 | Trametes sanguinea | 158606 | Fungi | Fungi | 57 | 6.29e-7 | NR | KAJ2982517.1 | 158606 | g223178 | i0 | 35.7 | 2.77397260273973 | 70 | 45 | 71.9 | 0 | 30 | 239 | 100 | 169 | KAJ2982517.1 hypothetical protein NUW54_g10745 [Trametes sanguinea] | diamond | 810 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes sanguinea | |
| 26884060 | 26884060 | PRJNA1249535_S_NODE_292101_length_257_cov_2.119565_g288718_i0 | PRJNA1249535 | 292101 | 257 | 2.119565 | 5.44728205 | Marasmius tenuissimus | 585030 | Fungi | Fungi | 45.1 | 0.00645 | NR | KAJ8084835.1 | 585030 | g288718 | i0 | 35.7 | 1.30739299610895 | 56 | 36 | 65.4 | 0 | 204 | 37 | 253 | 308 | KAJ8084835.1 hypothetical protein PM082_003612 [Marasmius tenuissimus] | diamond | 336 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius tenuissimus | |
| 27105183 | 27105183 | PRJNA1249535_S_NODE_279042_length_264_cov_2.952880_g275659_i0 | PRJNA1249535 | 279042 | 264 | 2.95288 | 7.7956032 | Armillaria gallica | 47427 | Fungi | Fungi | 44.7 | 0.00612 | NR | PBK84335.1 | 47427 | g275659 | i0 | 39 | 0.670454545454545 | 59 | 31 | 61.4 | 1 | 24 | 185 | 48 | 106 | PBK84335.1 hypothetical protein ARMGADRAFT_1037256 [Armillaria gallica] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria gallica | |
| 28291684 | 28291684 | PRJNA1249535_S_NODE_200986_length_305_cov_22.577586_g197603_i0 | PRJNA1249535 | 200986 | 305 | 22.577586 | 68.8616373 | Russulaceae | 5401 | Fungi | Fungi | 44.3 | 0.0223 | NR | KAH9077817.1 | 55514 | g197603 | i0 | 44.4 | 1.32786885245902 | 45 | 25 | 44.3 | 0 | 270 | 136 | 561 | 605 | KAH9077817.1 PLC-like phosphodiesterase [Lactarius deliciosus] | diamond | 405 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius deliciosus | |
| 28558128 | 28558128 | PRJNA1249535_S_NODE_163007_length_327_cov_3.196850_g159624_i0 | PRJNA1249535 | 163007 | 327 | 3.19685 | 10.4536995 | Mycena amicta | 380012 | Fungi | Fungi | 43.9 | 0.0372 | NR | KAJ7063421.1 | 380012 | g159624 | i0 | 46.5 | 0.394495412844037 | 43 | 22 | 39.4 | 1 | 156 | 28 | 158 | 199 | KAJ7063421.1 DHHC palmitoyltransferase-domain-containing protein [Mycena amicta] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena amicta | |
| 29158136 | 29158136 | PRJNA1249535_S_NODE_272449_length_268_cov_1.600000_g269066_i0 | PRJNA1249535 | 272449 | 268 | 1.6 | 4.288 | Tricholomella constricta | 117010 | Fungi | Fungi | 42.7 | 0.0354 | NR | KAF5375388.1 | 117010 | g269066 | i0 | 33.9 | 0.694029850746269 | 62 | 40 | 68.3 | 1 | 19 | 201 | 94 | 155 | KAF5375388.1 hypothetical protein D9615_007944 [Tricholomella constricta] | diamond | 186 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tricholomella | Tricholomella constricta | |
| 29221246 | 29221246 | PRJNA1249535_S_NODE_225229_length_293_cov_2.136364_g221846_i0 | PRJNA1249535 | 225229 | 293 | 2.136364 | 6.25954652 | Naematelia encephala | 71784 | Fungi | Fungi | 43.5 | 0.0349 | NR | ORY29768.1 | 71784 | g221846 | i0 | 34.5 | 0.593856655290102 | 58 | 38 | 59.4 | 0 | 218 | 45 | 404 | 461 | ORY29768.1 major facilitator superfamily domain-containing protein [Naematelia encephala] | diamond | 174 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 29221293 | 29221293 | PRJNA1249535_S_NODE_291249_length_257_cov_4.293478_g287866_i0 | PRJNA1249535 | 291249 | 257 | 4.293478 | 11.03423846 | Mycena floridula | 1033242 | Fungi | Fungi | 56.2 | 6.74e-8 | NR | KAJ7576701.1 | 1033242 | g287866 | i0 | 57.6 | 0.735408560311284 | 33 | 14 | 38.5 | 0 | 2 | 100 | 64 | 96 | KAJ7576701.1 hypothetical protein C8J56DRAFT_972595 [Mycena floridula] | diamond | 189 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena floridula | |
| 30010637 | 30010637 | PRJNA1249535_S_NODE_109151_length_366_cov_2.105802_g105768_i0 | PRJNA1249535 | 109151 | 366 | 2.105802 | 7.70723532 | Meira miltonrushii | 1280837 | Fungi | Fungi | 57.4 | 9.46e-7 | NR | XP_025352275.1 | 1280837 | g105768 | i0 | 31.9 | 0.770491803278688 | 94 | 56 | 70.5 | 1 | 268 | 11 | 203 | 296 | XP_025352275.1 uncharacterized protein FA14DRAFT_114954, partial [Meira miltonrushii] | diamond | 282 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 30168382 | 30168382 | PRJNA1249535_S_NODE_310532_length_247_cov_2.764368_g307149_i0 | PRJNA1249535 | 310532 | 247 | 2.764368 | 6.82798896 | Lentinula raphanica | 153919 | Fungi | Fungi | 43.1 | 0.0234 | NR | KAJ3714395.1 | 153919 | g307149 | i0 | 26 | 0.935222672064777 | 77 | 56 | 92.3 | 1 | 234 | 7 | 100 | 176 | KAJ3714395.1 hypothetical protein C8R42DRAFT_241914 [Lentinula raphanica] | diamond | 231 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula raphanica | |
| 30484569 | 30484569 | PRJNA1249535_S_NODE_278553_length_264_cov_4.554974_g275170_i0 | PRJNA1249535 | 278553 | 264 | 4.554974 | 12.02513136 | Cristinia sonorae | 1940300 | Fungi | Fungi | 43.5 | 0.0249 | NR | KAH8103319.1 | 1940300 | g275170 | i0 | 38.5 | 0.738636363636364 | 65 | 29 | 68.2 | 3 | 196 | 17 | 196 | 254 | KAH8103319.1 cytochrome P450 [Cristinia sonorae] | diamond | 195 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Stephanosporaceae | Cristinia | Cristinia sonorae | |
| 31179205 | 31179205 | PRJNA1249535_S_NODE_127155_length_351_cov_2.474820_g123772_i0 | PRJNA1249535 | 127155 | 351 | 2.47482 | 8.6866182 | Clathrus columnatus | 1419009 | Fungi | Fungi | 43.9 | 0.0408 | NR | GJJ05866.1 | 1419009 | g123772 | i0 | 41.4 | 0.598290598290598 | 70 | 32 | 52.1 | 4 | 271 | 89 | 17 | 86 | GJJ05866.1 hypothetical protein Clacol_000053 [Clathrus columnatus] | diamond | 210 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Phallales | Clathraceae | Clathrus | Clathrus columnatus | |
| 31369529 | 31369529 | PRJNA1249535_S_NODE_225796_length_292_cov_8.452055_g222413_i0 | PRJNA1249535 | 225796 | 292 | 8.452055 | 24.6800006 | Amanita thiersii Skay4 | 235537 | Fungi | Fungi | 43.9 | 0.0253 | NR | PFH50758.1 | 703135 | g222413 | i0 | 48.7 | 0.400684931506849 | 39 | 20 | 40.1 | 0 | 126 | 10 | 271 | 309 | PFH50758.1 hypothetical protein AMATHDRAFT_3613 [Amanita thiersii Skay4041] | diamond | 117 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita thiersii | |
| 31622255 | 31622255 | PRJNA1249535_S_NODE_243556_length_283_cov_3.509524_g240173_i0 | PRJNA1249535 | 243556 | 283 | 3.509524 | 9.93195292 | Fomitopsis schrenkii | 2126942 | Fungi | Fungi | 46.2 | 0.00352 | NR | EPS93851.1 | 2126942 | g240173 | i0 | 39.3 | 0.593639575971731 | 56 | 29 | 54.1 | 1 | 19 | 171 | 2 | 57 | EPS93851.1 hypothetical protein FOMPIDRAFT_1135364 [Fomitopsis schrenkii] | diamond | 168 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis schrenkii | |
| 31640251 | 31640251 | PRJNA1249535_S_NODE_174336_length_320_cov_4.773279_g170953_i0 | PRJNA1249535 | 174336 | 320 | 4.773279 | 15.2744928 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 2.02e-5 | NR | KAJ3502171.1 | 84603 | g170953 | i0 | 34.1 | 3.1875 | 82 | 53 | 75.9 | 1 | 67 | 309 | 281 | 362 | KAJ3502171.1 hypothetical protein NLJ89_g9010 [Agrocybe chaxingu] | diamond | 1020 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe chaxingu | |
| 31703570 | 31703570 | PRJNA1249535_S_NODE_299777_length_253_cov_1.300000_g296394_i0 | PRJNA1249535 | 299777 | 253 | 1.3 | 3.289 | Trametes | 5324 | Fungi | Fungi | 90.1 | 1.23e-20 | NR | CDO68330.1 | 5643 | g296394 | i0 | 69.4 | 9.6403162055336 | 62 | 19 | 73.5 | 0 | 250 | 65 | 62 | 123 | CDO68330.1 hypothetical protein BN946_scf184799.g57 [Trametes cinnabarina] | diamond | 2439 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes cinnabarina | |
| 32114980 | 32114980 | PRJNA1249535_S_NODE_229698_length_290_cov_7.115207_g226315_i0 | PRJNA1249535 | 229698 | 290 | 7.115207 | 20.6341003 | Opisthokonta | 33154 | Fungi | Fungi | 43.5 | 0.0359 | NR | TFY52504.1 | 34475 | g226315 | i0 | 50 | 1.77931034482759 | 38 | 19 | 39.3 | 0 | 41 | 154 | 1210 | 1247 | TFY52504.1 hypothetical protein EVJ58_g9980 [Rhodofomes roseus] | diamond | 516 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Rhodofomes | Rhodofomes roseus | |
| 32178318 | 32178318 | PRJNA1249535_S_NODE_156958_length_331_cov_1.577519_g153575_i0 | PRJNA1249535 | 156958 | 331 | 1.577519 | 5.22158789 | Opisthokonta | 33154 | Fungi | Fungi | 44.7 | 0.0193 | NR | PFH45315.1 | 703135 | g153575 | i0 | 53.1 | 3.27190332326284 | 32 | 15 | 29 | 0 | 183 | 88 | 223 | 254 | PFH45315.1 hypothetical protein AMATHDRAFT_160915 [Amanita thiersii Skay4041] | diamond | 1083 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita thiersii | |
| 32223552 | 32223552 | PRJNA1249535_S_NODE_336798_length_228_cov_2.012903_g333415_i0 | PRJNA1249535 | 336798 | 228 | 2.012903 | 4.5894188400000004 | Lentinula edodes | 5353 | Fungi | Fungi | 42.7 | 0.0304 | NR | GAW07965.1 | 5353 | g333415 | i0 | 42.6 | 0.618421052631579 | 47 | 25 | 61.8 | 1 | 191 | 51 | 293 | 337 | GAW07965.1 retrotransposable element Tf2 protein type [Lentinula edodes] | diamond | 141 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 32431357 | 32431357 | PRJNA1249535_S_NODE_322179_length_241_cov_2.607143_g318796_i0 | PRJNA1249535 | 322179 | 241 | 2.607143 | 6.28321463 | Irpicaceae | 1931355 | Fungi | Fungi | 76.3 | 3.23e-14 | NR | KAI0340285.1 | 1111950 | g318796 | i0 | 75 | 1.19502074688797 | 48 | 12 | 59.8 | 0 | 1 | 144 | 275 | 322 | KAI0340285.1 hypothetical protein BDW22DRAFT_1334411 [Trametopsis cervina] | diamond | 288 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Trametopsis | Trametopsis cervina | |
| 32540114 | 32540114 | PRJNA1249535_S_NODE_333939_length_230_cov_3.891720_g330556_i0 | PRJNA1249535 | 333939 | 230 | 3.89172 | 8.950956 | Rhizoctonia solani | 456999 | Fungi | Fungi | 48.9 | 1.96e-4 | NR | XP_043187348.1 | 456999 | g330556 | i0 | 35.6 | 0.769565217391304 | 59 | 36 | 74.3 | 1 | 210 | 40 | 80 | 138 | XP_043187348.1 uncharacterized protein RhiXN_01706 [Rhizoctonia solani] | diamond | 177 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 32886204 | 32886204 | PRJNA1249535_S_NODE_56820_length_455_cov_5.502618_g53457_i0 | PRJNA1249535 | 56820 | 455 | 5.502618 | 25.0369119 | Coprinopsis sp. MPI-PUGE-AT- | 1859955 | Fungi | Fungi | 45.1 | 0.043 | NR | KAH6879616.1 | 2826081 | g53457 | i0 | 39.2 | 0.336263736263736 | 51 | 31 | 33.6 | 0 | 272 | 120 | 15 | 65 | KAH6879616.1 hypothetical protein BKA70DRAFT_208187 [Coprinopsis sp. MPI-PUGE-AT-0042] | diamond | 153 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis sp. MPI-PUGE-AT-0042 |
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);;