contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5158363 | 5158363 | PRJEB3181_P_NODE_8785_length_286_cov_4.062745_g8521_i0 | PRJEB3181 | 8785 | 286 | 4.062745 | 11.6194507 | Fungi | 4751 | Fungi | Fungi | 107 | 3.3299999999999998e-28 | NR | KAF9787047.1 | 56493 | g8521 | i0 | 88.5 | 15.5874125874126 | 61 | 7 | 64 | 0 | 241 | 59 | 8 | 68 | KAF9787047.1 40S ribosomal protein S28 [Thelephora terrestris] | diamond | 4458 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora terrestris | |
| 14084443 | 14084443 | PRJEB3181_S_NODE_5692_length_256_cov_3.782805_g5399_i0 | PRJEB3181 | 5692 | 256 | 3.782805 | 9.6839808 | Eukaryota | 2759 | Fungi | Fungi | 73.6 | 3.01e-15 | NR | RXK42244.1 | 5217 | g5399 | i0 | 73.3 | 8.3671875 | 45 | 12 | 52.7 | 0 | 254 | 120 | 14 | 58 | RXK42244.1 60S ribosomal protein L39 [Tremella mesenterica] | diamond | 2142 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 26900277 | 26900277 | PRJEB3181_P_NODE_8141_length_296_cov_3.716981_g7878_i0 | PRJEB3181 | 8141 | 296 | 3.716981 | 11.00226376 | Agaricomycetes | 155619 | Fungi | Fungi | 75.1 | 9.39e-15 | NR | RDB28364.1 | 39966 | g7878 | i0 | 56 | 7.59121621621622 | 75 | 29 | 72 | 1 | 296 | 84 | 63 | 137 | RDB28364.1 40S ribosomal protein S24 [Hypsizygus marmoreus] | diamond | 2247 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Hypsizygus | Hypsizygus marmoreus | |
| 27033248 | 27033248 | PRJEB3181_P_NODE_16442_length_206_cov_2.262857_g16178_i0 | PRJEB3181 | 16442 | 206 | 2.262857 | 4.66148542 | Naematelia encephala | 71784 | Fungi | Fungi | 66.6 | 1.09e-12 | NR | ORY35885.1 | 71784 | g16178 | i0 | 65.5 | 1.60194174757282 | 55 | 19 | 80.1 | 0 | 1 | 165 | 12 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 330 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 27033252 | 27033252 | PRJEB3181_P_NODE_20502_length_181_cov_2.000000_g20238_i0 | PRJEB3181 | 20502 | 181 | 2 | 3.62 | Meira miltonrushii | 1280837 | Fungi | Fungi | 80.9 | 5.78e-16 | NR | XP_025355726.1 | 1280837 | g20238 | i0 | 86.4 | 0.729281767955801 | 44 | 6 | 72.9 | 0 | 180 | 49 | 461 | 504 | XP_025355726.1 dihydrolipoamide dehydrogenase [Meira miltonrushii] | diamond | 132 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 27222748 | 27222748 | PRJEB3181_P_NODE_3543_length_406_cov_3.130667_g3306_i0 | PRJEB3181 | 3543 | 406 | 3.130667 | 12.71050802 | Tulasnella sp. 424 | 2600228 | Fungi | Fungi | 59.3 | 9.22e-8 | NR | KAG8956550.1 | 2600228 | g3306 | i0 | 37.8 | 1.64039408866995 | 111 | 55 | 82 | 2 | 404 | 72 | 89 | 185 | KAG8956550.1 hypothetical protein FRC04_000028 [Tulasnella sp. 424] | diamond | 666 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 424 | |
| 27665334 | 27665334 | PRJEB3181_P_NODE_15784_length_211_cov_3.333333_g15520_i0 | PRJEB3181 | 15784 | 211 | 3.333333 | 7.03333263 | Pilatotrama ljubarskyi | 2735509 | Fungi | Fungi | 51.6 | 1.39e-5 | NR | KAI0367404.1 | 2735509 | g15520 | i0 | 58.3 | 1.02369668246445 | 36 | 15 | 51.2 | 0 | 2 | 109 | 203 | 238 | KAI0367404.1 NAD-P-binding protein [Pilatotrama ljubarskyi] | diamond | 216 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Pilatotrama | Pilatotrama ljubarskyi | |
| 28195174 | 28195174 | PRJEB3181_P_NODE_11086_length_255_cov_4.982143_g10822_i0 | PRJEB3181 | 11086 | 255 | 4.982143 | 12.70446465 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 5.47e-6 | NR | KNZ53089.1 | 27349 | g10822 | i0 | 42.9 | 6.58823529411765 | 63 | 35 | 74.1 | 1 | 255 | 67 | 203 | 264 | KNZ53089.1 large subunit ribosomal protein L9e [Puccinia sorghi] | diamond | 1680 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 28391328 | 28391328 | PRJEB3181_P_NODE_22066_length_173_cov_7.154930_g21801_i0 | PRJEB3181 | 22066 | 173 | 7.15493 | 12.3780289 | Mycena vulgaris | 1033282 | Fungi | Fungi | 41.6 | 0.0372 | NR | KAJ6517669.1 | 1033282 | g21801 | i0 | 41.7 | 0.624277456647399 | 36 | 21 | 62.4 | 0 | 167 | 60 | 237 | 272 | KAJ6517669.1 hypothetical protein DFH09DRAFT_1287733 [Mycena vulgaris] | diamond | 108 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena vulgaris | |
| 28486094 | 28486094 | PRJEB3181_P_NODE_15127_length_216_cov_4.335135_g14863_i0 | PRJEB3181 | 15127 | 216 | 4.335135 | 9.3638916 | Botryobasidium botryosum FD-172 SS1 | 930990 | Fungi | Fungi | 44.7 | 0.00115 | NR | KDQ05626.1 | 930990 | g14863 | i0 | 49 | 0.680555555555556 | 49 | 22 | 68.1 | 1 | 50 | 196 | 53 | 98 | KDQ05626.1 hypothetical protein BOTBODRAFT_60891 [Botryobasidium botryosum FD-172 SS1] | diamond | 147 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Botryobasidiaceae | Botryobasidium | Botryobasidium botryosum | |
| 28889898 | 28889898 | PRJEB3181_P_NODE_28328_length_150_cov_1.084034_g28063_i0 | PRJEB3181 | 28328 | 150 | 1.084034 | 1.626051 | Agaricomycetes | 155619 | Fungi | Fungi | 65.9 | 8.47e-13 | NR | KAH8118224.1 | 127956 | g28063 | i0 | 73.5 | 4.78 | 34 | 9 | 68 | 0 | 142 | 41 | 18 | 51 | KAH8118224.1 hypothetical protein DFH11DRAFT_1573104 [Phellopilus nigrolimitatus] | diamond | 717 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellopilus | Phellopilus nigrolimitatus | |
| 28889901 | 28889901 | PRJEB3181_S_NODE_16108_length_162_cov_1.259843_g15815_i0 | PRJEB3181 | 16108 | 162 | 1.259843 | 2.04094566 | Agaricales | 5338 | Fungi | Fungi | 43.9 | 0.00483 | NR | TFK40300.1 | 68775 | g15815 | i0 | 50 | 1.77777777777778 | 48 | 19 | 81.5 | 2 | 5 | 136 | 847 | 893 | TFK40300.1 peroxisomal hydratase-dehydrogenase-epimerase [Crucibulum laeve] | diamond | 288 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Crucibulum | Crucibulum laeve | |
| 29023188 | 29023188 | PRJEB3181_P_NODE_18228_length_194_cov_1.901840_g17964_i0 | PRJEB3181 | 18228 | 194 | 1.90184 | 3.6895696 | Tremellales sp. Tagirdzhanova- | 1920939 | Fungi | Fungi | 71.2 | 1.77e-13 | NR | CAD6566484.1 | 2778382 | g17964 | i0 | 63.6 | 1.71649484536082 | 55 | 20 | 85.1 | 0 | 192 | 28 | 118 | 172 | CAD6566484.1 MAG: hypothetical protein TREMPRED_002648 [Tremellales sp. Tagirdzhanova-0007] | diamond | 333 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellales sp. Tagirdzhanova-0007 | |||
| 29111134 | 29111134 | PRJEB3181_P_NODE_22428_length_172_cov_2.014184_g22163_i0 | PRJEB3181 | 22428 | 172 | 2.014184 | 3.46439648 | Basidiomycota | 5204 | Fungi | Fungi | 47.4 | 2.96e-4 | NR | XP_006460029.1 | 936046 | g22163 | i0 | 62.2 | 1.18604651162791 | 37 | 11 | 64.5 | 1 | 3 | 113 | 226 | 259 | XP_006460029.1 hypothetical protein AGABI2DRAFT_191800 [Agaricus bisporus var. bisporus H97] | diamond | 204 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Agaricus | Agaricus bisporus | |
| 29685563 | 29685563 | PRJEB3181_S_NODE_4790_length_274_cov_5.916318_g4497_i0 | PRJEB3181 | 4790 | 274 | 5.916318 | 16.21071132 | Naematelia encephala | 71784 | Fungi | Fungi | 57.8 | 7.76e-9 | NR | ORY35885.1 | 71784 | g4497 | i0 | 66 | 0.514598540145985 | 47 | 16 | 51.5 | 0 | 3 | 143 | 20 | 66 | ORY35885.1 40S ribosomal protein S30 [Naematelia encephala] | diamond | 141 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Naemateliaceae | Naematelia | Naematelia encephala | |
| 29938631 | 29938631 | PRJEB3181_P_NODE_631_length_688_cov_59.079148_g532_i0 | PRJEB3181 | 631 | 688 | 59.079148000000004 | 406.46453824 | Grifola frondosa | 5627 | Fungi | Fungi | 56.2 | 1.69e-5 | NR | OBZ63473.1 | 5627 | g532 | i0 | 39.9 | 0.645348837209302 | 148 | 63 | 60.6 | 6 | 215 | 631 | 113 | 243 | OBZ63473.1 hypothetical protein A0H81_15005 [Grifola frondosa] | diamond | 444 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Grifolaceae | Grifola | Grifola frondosa | |
| 30096377 | 30096377 | PRJEB3181_S_NODE_8012_length_222_cov_2.176471_g7719_i0 | PRJEB3181 | 8012 | 222 | 2.176471 | 4.83176562 | Blastosporella zonata | 530045 | Fungi | Fungi | 88.2 | 1.27e-19 | NR | KAG6849087.1 | 530045 | g7719 | i0 | 51.9 | 1.04054054054054 | 77 | 30 | 94.6 | 1 | 3 | 212 | 122 | 198 | KAG6849087.1 hypothetical protein C0991_012153, partial [Blastosporella zonata] | diamond | 231 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Blastosporella | Blastosporella zonata | |
| 30222801 | 30222801 | PRJEB3181_P_NODE_23272_length_168_cov_2.401460_g23007_i0 | PRJEB3181 | 23272 | 168 | 2.40146 | 4.0344528 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 100 | 8.61e-23 | NR | KAJ3505704.1 | 752674 | g23007 | i0 | 82.1 | 3 | 56 | 10 | 100 | 0 | 168 | 1 | 670 | 725 | KAJ3505704.1 hypothetical protein NMY22_g17488 [Coprinellus aureogranulatus] | diamond | 504 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus | |
| 30981372 | 30981372 | PRJEB3181_P_NODE_18874_length_190_cov_2.698113_g18610_i0 | PRJEB3181 | 18874 | 190 | 2.698113 | 5.1264147 | Scleroderma yunnanense | 1163567 | Fungi | Fungi | 67.8 | 2.65e-11 | NR | KAL4076989.1 | 1163567 | g18610 | i0 | 54.8 | 9.78947368421053 | 62 | 26 | 97.9 | 1 | 188 | 3 | 1266 | 1325 | KAL4076989.1 Hsp70 protein-domain-containing protein [Scleroderma yunnanense] | diamond | 1860 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Sclerodermataceae | Scleroderma | Scleroderma yunnanense | |
| 31170513 | 31170513 | PRJEB3181_S_NODE_4735_length_276_cov_1.958506_g4442_i0 | PRJEB3181 | 4735 | 276 | 1.958506 | 5.40547656 | Rhodotorula toruloides NP11 | 1130832 | Fungi | Fungi | 49.3 | 9e-5 | NR | XP_016275084.1 | 1130832 | g4442 | i0 | 42.9 | 1.43478260869565 | 63 | 33 | 68.5 | 1 | 250 | 62 | 86 | 145 | XP_016275084.1 nascent polypeptide-associated complex subunit alpha [Rhodotorula toruloides NP11] | diamond | 396 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 31265607 | 31265607 | PRJEB3181_P_NODE_17455_length_199_cov_1.482143_g17191_i0 | PRJEB3181 | 17455 | 199 | 1.482143 | 2.94946457 | Microbotryum lychnidis-dioicae p1A1 Lamole | 683840 | Fungi | Fungi | 44.7 | 0.00449 | NR | KDE08249.1 | 683840 | g17191 | i0 | 41.5 | 3.91959798994975 | 65 | 38 | 98 | 0 | 5 | 199 | 685 | 749 | KDE08249.1 hypothetical protein MVLG_01515 [Microbotryum lychnidis-dioicae p1A1 Lamole] | diamond | 780 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryales | Microbotryaceae | Microbotryum | Microbotryum lychnidis-dioicae | |
| 31423721 | 31423721 | PRJEB3181_P_NODE_9256_length_279_cov_3.947581_g8992_i0 | PRJEB3181 | 9256 | 279 | 3.947581 | 11.01375099 | Rhodotorula toruloides NP11 | 1130832 | Fungi | Fungi | 50.4 | 3.38e-5 | NR | XP_016275084.1 | 1130832 | g8992 | i0 | 42.9 | 1.41935483870968 | 63 | 33 | 67.7 | 1 | 45 | 233 | 86 | 145 | XP_016275084.1 nascent polypeptide-associated complex subunit alpha [Rhodotorula toruloides NP11] | diamond | 396 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 31518759 | 31518759 | PRJEB3181_P_NODE_24256_length_164_cov_1.458647_g23991_i0 | PRJEB3181 | 24256 | 164 | 1.458647 | 2.39218108 | Phellinidium pouzarii | 167371 | Fungi | Fungi | 48.5 | 1.16e-4 | NR | THH05693.1 | 167371 | g23991 | i0 | 51.1 | 3.29268292682927 | 45 | 22 | 82.3 | 0 | 164 | 30 | 200 | 244 | THH05693.1 hypothetical protein EW145_g4608 [Phellinidium pouzarii] | diamond | 540 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellinidium | Phellinidium pouzarii | |
| 32688494 | 32688494 | PRJEB3181_P_NODE_4180_length_384_cov_4.915014_g3934_i0 | PRJEB3181 | 4180 | 384 | 4.915014 | 18.87365376 | Malassezia equina | 1381935 | Fungi | Fungi | 43.1 | 0.0101 | NR | WFD24263.1 | 1381935 | g3934 | i0 | 51.1 | 0.3515625 | 45 | 22 | 35.2 | 0 | 214 | 80 | 16 | 60 | WFD24263.1 60S ribosomal protein L38 [Malassezia equina] | diamond | 135 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia equina | |
| 32720152 | 32720152 | PRJEB3181_P_NODE_21780_length_175_cov_1.090278_g21515_i0 | PRJEB3181 | 21780 | 175 | 1.090278 | 1.9079865 | Trametes versicolor FP-1 | 5325 | Fungi | Fungi | 41.6 | 0.0351 | NR | XP_008035754.1 | 717944 | g21515 | i0 | 81.5 | 0.462857142857143 | 27 | 5 | 46.3 | 0 | 90 | 170 | 77 | 103 | XP_008035754.1 uncharacterized protein TRAVEDRAFT_144284 [Trametes versicolor FP-101664 SS1] | diamond | 81 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor |
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);;