contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27586539 | 27586539 | PRJNA635397_P_NODE_35124_length_267_cov_1.608247_g34670_i0 | PRJNA635397 | 35124 | 267 | 1.608247 | 4.29401949 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 44.7 | 0.0098 | NR | VDC02855.1 | 718367 | g34670 | i0 | 33.7 | 1 | 89 | 50 | 89.9 | 1 | 244 | 5 | 180 | 268 | VDC02855.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 267 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 27693991 | 27693991 | PRJNA635397_P_NODE_40864_length_250_cov_0.875706_g40410_i0 | PRJNA635397 | 40864 | 250 | 0.875706 | 2.189265 | Eukaryota | 2759 | Fungi | Fungi | 43.5 | 0.0205 | NR | KAA1081951.1 | 56615 | g40410 | i0 | 33.3 | 8.712 | 60 | 35 | 66 | 1 | 242 | 78 | 310 | 369 | KAA1081951.1 hypothetical protein PGTUg99_030349 [Puccinia graminis f. sp. tritici] | diamond | 2178 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 27870529 | 27870529 | PRJNA635397_P_NODE_41345_length_249_cov_0.886364_g40891_i0 | PRJNA635397 | 41345 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 152 | 2.73e-41 | NR | XP_027483557.1 | 76775 | g40891 | i0 | 88 | 1 | 83 | 10 | 100 | 0 | 1 | 249 | 212 | 294 | XP_027483557.1 5-oxoprolinase (ATP-hydrolyzing) [Malassezia restricta] | diamond | 249 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 27965268 | 27965268 | PRJNA635397_P_NODE_45245_length_244_cov_0.894737_g44791_i0 | PRJNA635397 | 45245 | 244 | 0.894737 | 2.18315828 | Malassezia restricta | 76775 | Fungi | Fungi | 134 | 1.6999999999999998e-36 | NR | XP_027485440.1 | 76775 | g44791 | i0 | 79.5 | 2.02868852459016 | 78 | 16 | 95.9 | 0 | 2 | 235 | 177 | 254 | XP_027485440.1 maintenance of ploidy protein MOB2 [Malassezia restricta] | diamond | 495 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28470660 | 28470660 | PRJNA635397_P_NODE_33846_length_272_cov_1.849246_g33392_i0 | PRJNA635397 | 33846 | 272 | 1.849246 | 5.02994912 | Gautieria morchelliformis | 112417 | Fungi | Fungi | 43.9 | 0.02 | NR | KAF8528737.1 | 112417 | g33392 | i0 | 36.8 | 0.75 | 68 | 41 | 72.8 | 1 | 205 | 8 | 154 | 221 | KAF8528737.1 major facilitator superfamily domain-containing protein [Gautieria morchelliformis] | diamond | 204 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gomphales | Gomphaceae | Gautieria | Gautieria morchelliformis | |
| 29386298 | 29386298 | PRJNA635397_P_NODE_15029_length_428_cov_2.870423_g14575_i0 | PRJNA635397 | 15029 | 428 | 2.870423 | 12.28541044 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 116 | 2.99e-30 | NR | KAG8920536.1 | 2600225 | g14575 | i0 | 50 | 0.911214953271028 | 130 | 61 | 88.3 | 1 | 419 | 42 | 6 | 135 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 390 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 29386313 | 29386313 | PRJNA635397_P_NODE_36849_length_260_cov_2.213904_g36395_i0 | PRJNA635397 | 36849 | 260 | 2.213904 | 5.7561504 | Sporisorium graminicola | 280036 | Fungi | Fungi | 43.5 | 0.0244 | NR | XP_029737108.1 | 280036 | g36395 | i0 | 40.9 | 0.761538461538461 | 66 | 38 | 75 | 1 | 48 | 242 | 114 | 179 | XP_029737108.1 hypothetical protein EX895_006203 [Sporisorium graminicola] | diamond | 198 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium graminicola | |
| 29828120 | 29828120 | PRJNA635397_P_NODE_40771_length_250_cov_0.875706_g40317_i0 | PRJNA635397 | 40771 | 250 | 0.875706 | 2.189265 | Malassezia psittaci | 1821823 | Fungi | Fungi | 151 | 1.58e-40 | NR | WFD41885.1 | 1821823 | g40317 | i0 | 88 | 0.996 | 83 | 10 | 99.6 | 0 | 1 | 249 | 246 | 328 | WFD41885.1 long-chain-fatty-acid--CoA ligase [Malassezia psittaci] | diamond | 249 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia psittaci | |
| 30302537 | 30302537 | PRJNA635397_P_NODE_10192_length_547_cov_3.023207_g9742_i0 | PRJNA635397 | 10192 | 547 | 3.023207 | 16.53694229 | Artomyces pyxidatus | 48021 | Fungi | Fungi | 48.5 | 0.00392 | NR | KAI0055551.1 | 48021 | g9742 | i0 | 35.1 | 0.515539305301645 | 94 | 58 | 50.5 | 3 | 167 | 442 | 51 | 143 | KAI0055551.1 hypothetical protein BV25DRAFT_1921744 [Artomyces pyxidatus] | diamond | 282 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Auriscalpiaceae | Artomyces | Artomyces pyxidatus | |
| 31154858 | 31154858 | PRJNA635397_P_NODE_44575_length_245_cov_0.860465_g44121_i0 | PRJNA635397 | 44575 | 245 | 0.860465 | 2.10813925 | Pyrrhoderma noxium | 2282107 | Fungi | Fungi | 127 | 4.69e-32 | NR | PAV19693.1 | 2282107 | g44121 | i0 | 71.3 | 6.84489795918367 | 80 | 23 | 98 | 0 | 3 | 242 | 268 | 347 | PAV19693.1 reverse transcriptase-rnase h-integrase [Pyrrhoderma noxium] | diamond | 1677 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Pyrrhoderma | Pyrrhoderma noxium | |
| 31344994 | 31344994 | PRJNA635397_P_NODE_35896_length_264_cov_1.607330_g35442_i0 | PRJNA635397 | 35896 | 264 | 1.60733 | 4.2433512 | Rhodocollybia butyracea | 206335 | Fungi | Fungi | 44.7 | 0.00979 | NR | KAF9068633.1 | 206335 | g35442 | i0 | 42.3 | 0.590909090909091 | 52 | 28 | 59.1 | 1 | 260 | 105 | 102 | 151 | KAF9068633.1 hypothetical protein BDP27DRAFT_1327031 [Rhodocollybia butyracea] | diamond | 156 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Rhodocollybia | Rhodocollybia butyracea | |
| 32199099 | 32199099 | PRJNA635397_P_NODE_43178_length_246_cov_1.919075_g42724_i0 | PRJNA635397 | 43178 | 246 | 1.919075 | 4.7209245 | Athelia psychrophila | 1759441 | Fungi | Fungi | 43.9 | 0.0147 | NR | KZP12821.1 | 1759441 | g42724 | i0 | 38.5 | 0.792682926829268 | 65 | 38 | 79.3 | 1 | 232 | 38 | 274 | 336 | KZP12821.1 hypothetical protein FIBSPDRAFT_151440 [Athelia psychrophila] | diamond | 195 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Atheliales | Atheliaceae | Athelia | Athelia psychrophila | |
| 32230892 | 32230892 | PRJNA635397_P_NODE_40738_length_250_cov_0.881356_g40284_i0 | PRJNA635397 | 40738 | 250 | 0.881356 | 2.20339 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 73.6 | 5.54e-13 | NR | AYO42221.1 | 425264 | g40284 | i0 | 86 | 0.516 | 43 | 6 | 51.6 | 0 | 120 | 248 | 1 | 43 | AYO42221.1 hypothetical protein DNF11_1271 [Malassezia restricta CBS 7877] | diamond | 129 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 32275022 | 32275022 | PRJNA635397_P_NODE_38178_length_255_cov_2.274725_g37724_i0 | PRJNA635397 | 38178 | 255 | 2.274725 | 5.80054875 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 2.56e-20 | NR | KAG0151791.1 | 708437 | g37724 | i0 | 55 | 3.81176470588235 | 80 | 30 | 94.1 | 1 | 11 | 250 | 62 | 135 | KAG0151791.1 hypothetical protein CROQUDRAFT_650846 [Cronartium quercuum f. sp. fusiforme G11] | diamond | 972 | 92 | 0.996739130434783 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Coleosporiaceae | Cronartium | Cronartium quercuum | |
| 32325975 | 32325975 | PRJNA635397_P_NODE_47959_length_229_cov_2.173077_g47505_i0 | PRJNA635397 | 47959 | 229 | 2.173077 | 4.97634633 | Mycena floridula | 1033242 | Fungi | Fungi | 42.4 | 0.0425 | NR | KAJ7593286.1 | 1033242 | g47505 | i0 | 42.5 | 1.04803493449782 | 40 | 21 | 49.8 | 1 | 66 | 179 | 996 | 1035 | KAJ7593286.1 hypothetical protein C8J56DRAFT_779295 [Mycena floridula] | diamond | 240 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena floridula | |
| 32483930 | 32483930 | PRJNA635397_P_NODE_45979_length_243_cov_0.905882_g45525_i0 | PRJNA635397 | 45979 | 243 | 0.905882 | 2.20129326 | Coprinellus aureogranulatus | 752674 | Fungi | Fungi | 43.1 | 0.0272 | NR | KAJ3544178.1 | 752674 | g45525 | i0 | 30.2 | 0.654320987654321 | 53 | 37 | 65.4 | 0 | 11 | 169 | 596 | 648 | KAJ3544178.1 hypothetical protein NMY22_g2872 [Coprinellus aureogranulatus] | diamond | 159 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus aureogranulatus |
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);;