contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 448719 | 448719 | PRJNA484127_P_NODE_36101_length_245_cov_0.906977_g35952_i0 | PRJNA484127 | 36101 | 245 | 0.906977 | 2.22209365 | Malassezia vespertilionis | 2020962 | Fungi | Fungi | 96.7 | 4.16e-21 | NR | XP_056063317.1 | 2020962 | g35952 | i0 | 63.8 | 1.95918367346939 | 80 | 29 | 98 | 0 | 244 | 5 | 2150 | 2229 | XP_056063317.1 Carbamoyl-phosphate synthase [Malassezia vespertilionis] | diamond | 480 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia vespertilionis | |
| 2999313 | 2999313 | PRJNA484127_P_NODE_28923_length_255_cov_1.791209_g28774_i0 | PRJNA484127 | 28923 | 255 | 1.791209 | 4.56758295 | Gymnopilus junonius | 109634 | Fungi | Fungi | 106 | 3.76e-26 | NR | KAF8913828.1 | 109634 | g28774 | i0 | 64.3 | 2.96470588235294 | 84 | 25 | 98.8 | 1 | 254 | 3 | 102 | 180 | KAF8913828.1 40S ribosomal protein S1 [Gymnopilus junonius] | diamond | 756 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Gymnopilus | Gymnopilus junonius | |
| 22125179 | 22125179 | PRJNA484127_P_NODE_36298_length_245_cov_0.906977_g36149_i0 | PRJNA484127 | 36298 | 245 | 0.906977 | 2.22209365 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 152 | 1.06e-40 | NR | CAD6575288.1 | 2778381 | g36149 | i0 | 87.7 | 1.97142857142857 | 81 | 9 | 99.2 | 1 | 2 | 244 | 702 | 781 | CAD6575288.1 MAG: NADP-dependent alcohol dehydrogenase [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 483 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 24674567 | 24674567 | PRJNA484127_P_NODE_24980_length_270_cov_2.649746_g24831_i0 | PRJNA484127 | 24980 | 270 | 2.649746 | 7.1543142 | Opisthokonta | 33154 | Fungi | Fungi | 154 | 5.76e-42 | NR | KAJ3919624.1 | 5353 | g24831 | i0 | 79.8 | 112.488888888889 | 89 | 18 | 98.9 | 0 | 3 | 269 | 118 | 206 | KAJ3919624.1 histone deacetylase [Lentinula edodes] | diamond | 30372 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 26680761 | 26680761 | PRJNA484127_P_NODE_14041_length_336_cov_1.247148_g13892_i0 | PRJNA484127 | 14041 | 336 | 1.247148 | 4.19041728 | Fungi | 4751 | Fungi | Fungi | 73.2 | 1.59e-12 | NR | ORY66939.1 | 106004 | g13892 | i0 | 78.6 | 6.73214285714286 | 42 | 9 | 37.5 | 0 | 3 | 128 | 306 | 347 | ORY66939.1 heterotrimeric G-protein beta subunit (G-beta, Gpb) [Leucosporidium creatinivorum] | diamond | 2262 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum | |
| 27123675 | 27123675 | PRJNA484127_P_NODE_27982_length_259_cov_1.247312_g27833_i0 | PRJNA484127 | 27982 | 259 | 1.247312 | 3.23053808 | Boletales | 68889 | Fungi | Fungi | 68.9 | 2.71e-11 | NR | KIK94357.1 | 930991 | g27833 | i0 | 63 | 8.75675675675676 | 54 | 20 | 62.5 | 0 | 95 | 256 | 20 | 73 | KIK94357.1 hypothetical protein PAXRUDRAFT_828075 [Paxillus rubicundulus Ve08.2h10] | diamond | 2268 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Paxillaceae | Paxillus | Paxillus rubicundulus | |
| 27487088 | 27487088 | PRJNA484127_P_NODE_24143_length_274_cov_1.552239_g23994_i0 | PRJNA484127 | 24143 | 274 | 1.552239 | 4.25313486 | Schizophyllum commune | 5334 | Fungi | Fungi | 139 | 5.86e-36 | NR | KAL1667074.1 | 5334 | g23994 | i0 | 71.4 | 11.9014598540146 | 91 | 26 | 99.6 | 0 | 273 | 1 | 576 | 666 | KAL1667074.1 hypothetical protein GGF50DRAFT_86962 [Schizophyllum commune] | diamond | 3261 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum commune | |
| 27676788 | 27676788 | PRJNA484127_P_NODE_31524_length_251_cov_0.876404_g31375_i0 | PRJNA484127 | 31524 | 251 | 0.876404 | 2.19977404 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 147 | 3.0099999999999993e-40 | NR | XP_066820774.1 | 1397322 | g31375 | i0 | 83.1 | 0.99203187250996006 | 83 | 14 | 99.2 | 0 | 3 | 251 | 143 | 225 | XP_066820774.1 FMN-linked oxidoreductase [Cystobasidium minutum MCA 4210] | diamond | 249 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 29254982 | 29254982 | PRJNA484127_P_NODE_18989_length_301_cov_1.179825_g18840_i0 | PRJNA484127 | 18989 | 301 | 1.179825 | 3.55127325 | Mycena galopus ATCC 62 | 41248 | Fungi | Fungi | 91.3 | 5.82e-19 | NR | KAF8214284.1 | 1314675 | g18840 | i0 | 47.8 | 0.916943521594684 | 92 | 45 | 90.7 | 3 | 7 | 279 | 173 | 262 | KAF8214284.1 glycoside hydrolase superfamily [Mycena galopus ATCC 62051] | diamond | 276 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena galopus | |
| 30155275 | 30155275 | PRJNA484127_P_NODE_7412_length_431_cov_1.449721_g7264_i0 | PRJNA484127 | 7412 | 431 | 1.449721 | 6.2482975100000004 | Eukaryota | 2759 | Fungi | Fungi | 115 | 5.0100000000000005e-27 | NR | GAA6015512.1 | 86839 | g7264 | i0 | 44.5 | 9.7169373549884 | 128 | 68 | 89.1 | 1 | 44 | 427 | 66 | 190 | GAA6015512.1 hypothetical protein JCM8202_002496 [Rhodotorula sphaerocarpa] | diamond | 4188 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sphaerocarpa | |
| 30329578 | 30329578 | PRJNA484127_P_NODE_30912_length_251_cov_1.898876_g30763_i0 | PRJNA484127 | 30912 | 251 | 1.898876 | 4.76617876 | Schizopora paradoxa | 27342 | Fungi | Fungi | 47.8 | 6.77e-4 | NR | KLO06315.1 | 27342 | g30763 | i0 | 38.8 | 1.17131474103586 | 98 | 40 | 96.8 | 2 | 249 | 7 | 130 | 224 | KLO06315.1 hypothetical protein SCHPADRAFT_910418 [Schizopora paradoxa] | diamond | 294 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 30708155 | 30708155 | PRJNA484127_P_NODE_8634_length_405_cov_1.683735_g8485_i0 | PRJNA484127 | 8634 | 405 | 1.683735 | 6.81912675 | Melampsora larici-populina 98AG31 | 747676 | Fungi | Fungi | 44.7 | 0.0458 | NR | XP_007410801.1 | 747676 | g8485 | i0 | 31.2 | 1.04444444444444 | 141 | 78 | 90.4 | 2 | 388 | 23 | 805 | 945 | XP_007410801.1 Hypothetical protein MELLADRAFT_77966 [Melampsora larici-populina 98AG31] | diamond | 423 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 31024205 | 31024205 | PRJNA484127_P_NODE_23495_length_277_cov_1.529412_g23346_i0 | PRJNA484127 | 23495 | 277 | 1.529412 | 4.23647124 | Auriculariopsis ampla | 97359 | Fungi | Fungi | 61.6 | 3.51e-9 | NR | TRM61859.1 | 97359 | g23346 | i0 | 42.6 | 1.9927797833935 | 94 | 47 | 98.6 | 3 | 275 | 3 | 80 | 169 | TRM61859.1 NAC domain-containing protein [Schizophyllum amplum] | diamond | 552 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum amplum | |
| 31245319 | 31245319 | PRJNA484127_P_NODE_25015_length_270_cov_2.091371_g24866_i0 | PRJNA484127 | 25015 | 270 | 2.091371 | 5.6467017 | Mycena capillaripes | 230804 | Fungi | Fungi | 130 | 9.349999999999999e-35 | NR | KAJ6577455.1 | 230804 | g24866 | i0 | 61.1 | 1 | 90 | 35 | 100 | 0 | 270 | 1 | 148 | 237 | KAJ6577455.1 hypothetical protein B0H19DRAFT_1120025 [Mycena capillaripes] | diamond | 270 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena capillaripes | |
| 31372072 | 31372072 | PRJNA484127_P_NODE_21056_length_289_cov_1.439815_g20907_i0 | PRJNA484127 | 21056 | 289 | 1.439815 | 4.16106535 | Mycena olivaceomarginata | 230810 | Fungi | Fungi | 47 | 0.00194 | NR | KAJ7890993.1 | 230810 | g20907 | i0 | 34.9 | 0.892733564013841 | 86 | 52 | 87.2 | 2 | 34 | 285 | 191 | 274 | KAJ7890993.1 hypothetical protein B0H14DRAFT_2561102 [Mycena olivaceomarginata] | diamond | 258 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena olivaceomarginata | |
| 31466931 | 31466931 | PRJNA484127_P_NODE_30716_length_252_cov_0.871508_g30567_i0 | PRJNA484127 | 30716 | 252 | 0.871508 | 2.19620016 | Auricularia subglabra TFB-1 | 1331295 | Fungi | Fungi | 62.8 | 3.87e-9 | NR | EJD48939.1 | 717982 | g30567 | i0 | 33.3 | 1.97619047619048 | 84 | 55 | 98.8 | 1 | 252 | 4 | 2709 | 2792 | EJD48939.1 hypothetical protein AURDEDRAFT_150681 [Auricularia subglabra TFB-10046 SS5] | diamond | 498 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia subglabra |
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);;