contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26636710 | 26636710 | PRJNA603943_P_NODE_1501_length_1106_cov_7.540174_g1375_i0 | PRJNA603943 | 1501 | 1106 | 7.540174 | 83.39432444 | Termitomyces sp. Mi166# | 1916073 | Fungi | Fungi | 181 | 1.88e-50 | NR | KAG6872773.1 | 2053460 | g1375 | i0 | 37.5 | 1.66817359855335 | 312 | 171 | 79.7 | 7 | 1038 | 157 | 5 | 310 | KAG6872773.1 hypothetical protein C0995_006693 [Termitomyces sp. Mi166#008] | diamond | 1845 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Termitomyces | Termitomyces sp. Mi166#008 | |
| 27364767 | 27364767 | PRJNA603943_P_NODE_58823_length_248_cov_0.880000_g58631_i0 | PRJNA603943 | 58823 | 248 | 0.88 | 2.1824 | Melanogaster broomeanus | 2655010 | Fungi | Fungi | 42.7 | 0.0406 | NR | KAF9245846.1 | 2655010 | g58631 | i0 | 47.5 | 0.483870967741935 | 40 | 21 | 48.4 | 0 | 198 | 79 | 965 | 1004 | KAF9245846.1 P-loop containing nucleoside triphosphate hydrolase protein [Melanogaster broomeanus] | diamond | 120 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Melanogastraceae | Melanogaster | Melanogaster broomeanus | |
| 27396209 | 27396209 | PRJNA603943_P_NODE_1543_length_1094_cov_2.456415_g1417_i0 | PRJNA603943 | 1543 | 1094 | 2.456415 | 26.8731801 | Termitomyces sp. Mi166# | 1916073 | Fungi | Fungi | 182 | 8.5e-51 | NR | KAG6872773.1 | 2053460 | g1417 | i0 | 36.6 | 1.68647166361974 | 314 | 175 | 81.2 | 7 | 47 | 934 | 3 | 310 | KAG6872773.1 hypothetical protein C0995_006693 [Termitomyces sp. Mi166#008] | diamond | 1845 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Termitomyces | Termitomyces sp. Mi166#008 | |
| 27743649 | 27743649 | PRJNA603943_P_NODE_61324_length_246_cov_0.890173_g61132_i0 | PRJNA603943 | 61324 | 246 | 0.890173 | 2.18982558 | Microbotryomycetes sp. JL221 | 2987685 | Fungi | Fungi | 46.2 | 0.00227 | NR | KAK4056973.1 | 2987685 | g61132 | i0 | 34.7 | 0.914634146341463 | 75 | 47 | 91.5 | 1 | 20 | 244 | 176 | 248 | KAK4056973.1 hypothetical protein OIO90_001873 [Microbotryomycetes sp. JL221] | diamond | 225 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryomycetes sp. JL221 | ||||
| 28532902 | 28532902 | PRJNA603943_P_NODE_61687_length_246_cov_0.890173_g61495_i0 | PRJNA603943 | 61687 | 246 | 0.890173 | 2.18982558 | Amanita polypyramis BW_CC | 1457511 | Fungi | Fungi | 79.3 | 5.18e-15 | NR | KAF8630323.1 | 1457511 | g61495 | i0 | 50.7 | 4.5609756097561 | 75 | 37 | 91.5 | 0 | 243 | 19 | 720 | 794 | KAF8630323.1 hypothetical protein AX15_002996 [Amanita polypyramis BW_CC] | diamond | 1122 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita polypyramis | |
| 29038114 | 29038114 | PRJNA603943_P_NODE_26568_length_344_cov_1.498155_g26376_i0 | PRJNA603943 | 26568 | 344 | 1.498155 | 5.1536532 | Rhodotorula pacifica | 1495444 | Fungi | Fungi | 94 | 4.89e-21 | NR | GAA5977238.1 | 1495444 | g26376 | i0 | 50 | 2.99127906976744 | 114 | 48 | 99.4 | 2 | 342 | 1 | 114 | 218 | GAA5977238.1 hypothetical protein JCM10908_004904 [Rhodotorula pacifica] | diamond | 1029 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula pacifica | |
| 29385324 | 29385324 | PRJNA603943_P_NODE_49109_length_262_cov_1.523810_g48917_i0 | PRJNA603943 | 49109 | 262 | 1.52381 | 3.9923822 | Agrocybe pediades | 84607 | Fungi | Fungi | 41.2 | 0.0327 | NR | KAF9561969.1 | 84607 | g48917 | i0 | 54.8 | 0.480916030534351 | 42 | 18 | 48.1 | 1 | 10 | 135 | 3 | 43 | KAF9561969.1 hypothetical protein CPC08DRAFT_634678 [Agrocybe pediades] | diamond | 126 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe pediades | |
| 29556173 | 29556173 | PRJNA603943_P_NODE_56430_length_249_cov_0.875000_g56238_i0 | PRJNA603943 | 56430 | 249 | 0.875 | 2.17875 | Polyporales | 5303 | Fungi | Fungi | 119 | 5.769999999999999e-32 | NR | XP_047882236.1 | 378194 | g56238 | i0 | 93.3 | 11.7469879518072 | 60 | 4 | 72.3 | 0 | 182 | 3 | 89 | 148 | XP_047882236.1 RNA-binding protein [Epithele typhae] | diamond | 2925 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Epitheliaceae | Epithele | Epithele typhae | |
| 29890599 | 29890599 | PRJNA603943_P_NODE_58511_length_248_cov_0.880000_g58319_i0 | PRJNA603943 | 58511 | 248 | 0.88 | 2.1824 | Agrocybe pediades | 84607 | Fungi | Fungi | 68.9 | 2.32e-11 | NR | KAF9559217.1 | 84607 | g58319 | i0 | 75 | 0.967741935483871 | 40 | 10 | 48.4 | 0 | 248 | 129 | 550 | 589 | KAF9559217.1 lysyl-tRNA synthetase [Agrocybe pediades] | diamond | 240 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe pediades | |
| 31135544 | 31135544 | PRJNA603943_P_NODE_1515_length_1102_cov_8.907677_g1389_i0 | PRJNA603943 | 1515 | 1102 | 8.907677 | 98.16260054 | Lyophyllaceae | 930979 | Fungi | Fungi | 180 | 5.09e-50 | NR | KAG6908273.1 | 117070 | g1389 | i0 | 36.8 | 3.09255898366606 | 310 | 171 | 80 | 7 | 62 | 943 | 10 | 310 | KAG6908273.1 hypothetical protein DXG01_005538 [Tephrocybe rancida] | diamond | 3408 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tephrocybe | Tephrocybe rancida | |
| 31597200 | 31597200 | PRJNA603943_P_NODE_57096_length_249_cov_0.875000_g56904_i0 | PRJNA603943 | 57096 | 249 | 0.875 | 2.17875 | Hydnomerulius pinastri MD-312 | 994086 | Fungi | Fungi | 67.8 | 5.98e-11 | NR | KIJ60075.1 | 994086 | g56904 | i0 | 43 | 0.951807228915663 | 79 | 45 | 95.2 | 0 | 247 | 11 | 636 | 714 | KIJ60075.1 hypothetical protein HYDPIDRAFT_32650 [Hydnomerulius pinastri MD-312] | diamond | 237 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Leucogyrophana | Leucogyrophana pinastri | ||
| 31736595 | 31736595 | PRJNA603943_P_NODE_60097_length_247_cov_0.885057_g59905_i0 | PRJNA603943 | 60097 | 247 | 0.885057 | 2.18609079 | Cryptococcaceae | 1884633 | Fungi | Fungi | 52.4 | 1.65e-5 | NR | XP_065725136.1 | 1296100 | g59905 | i0 | 51.8 | 10.5303643724696 | 56 | 25 | 65.6 | 1 | 2 | 163 | 4773 | 4828 | XP_065725136.1 uncharacterized protein I302_100339 [Kwoniella bestiolae CBS 10118] | diamond | 2601 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella bestiolae | |
| 31958111 | 31958111 | PRJNA603943_P_NODE_23397_length_361_cov_1.350694_g23205_i0 | PRJNA603943 | 23397 | 361 | 1.350694 | 4.87600534 | Pleurotus | 5320 | Fungi | Fungi | 57.4 | 9.7e-7 | NR | KAF9498178.1 | 5323 | g23205 | i0 | 62.5 | 1.32963988919668 | 40 | 12 | 30.7 | 1 | 6 | 116 | 156 | 195 | KAF9498178.1 hypothetical protein BDN71DRAFT_1443925 [Pleurotus eryngii] | diamond | 480 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus eryngii | |
| 32716879 | 32716879 | PRJNA603943_P_NODE_67300_length_243_cov_0.905882_g67108_i0 | PRJNA603943 | 67300 | 243 | 0.905882 | 2.20129326 | Polyporales | 5303 | Fungi | Fungi | 85.1 | 4.53e-17 | NR | KAJ3559522.1 | 194682 | g67108 | i0 | 55.7 | 6.72839506172839 | 70 | 31 | 86.4 | 0 | 238 | 29 | 639 | 708 | KAJ3559522.1 hypothetical protein NM688_g295 [Phlebia brevispora] | diamond | 1635 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Phlebia | Phlebia brevispora | |
| 32829651 | 32829651 | PRJNA603943_P_NODE_39100_length_295_cov_1.040541_g38908_i0 | PRJNA603943 | 39100 | 295 | 1.040541 | 3.06959595 | Clathrus columnatus | 1419009 | Fungi | Fungi | 79.7 | 7.24e-15 | NR | GJJ08739.1 | 1419009 | g38908 | i0 | 43.8 | 7.64745762711864 | 96 | 52 | 97.6 | 2 | 7 | 294 | 853 | 946 | GJJ08739.1 hypothetical protein Clacol_002958 [Clathrus columnatus] | diamond | 2256 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Phallales | Clathraceae | Clathrus | Clathrus columnatus |
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);;