contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1104180" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11691092 | 11691092 | PRJNA1104180_P_NODE_24330_length_244_cov_0.900585_g24187_i0 | PRJNA1104180 | 24330 | 244 | 0.900585 | 2.1974274 | Sporobolomyces koalae | 500713 | Fungi | Fungi | 108 | 5.450000000000001e-26 | NR | GAA5933186.1 | 500713 | g24187 | i0 | 91.5 | 0.725409836065574 | 59 | 5 | 72.5 | 0 | 230 | 54 | 67 | 125 | GAA5933186.1 hypothetical protein JCM15063_002322 [Sporobolomyces koalae] | diamond | 177 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces koalae | |
| 27699840 | 27699840 | PRJNA1104180_P_NODE_16364_length_270_cov_1.218274_g16222_i0 | PRJNA1104180 | 16364 | 270 | 1.218274 | 3.2893398 | Sporisorium reilianum SRZ2 | 999809 | Fungi | Fungi | 71.2 | 4.59e-12 | NR | CBQ71383.1 | 999809 | g16222 | i0 | 42.4 | 1.02222222222222 | 92 | 37 | 84.4 | 1 | 230 | 3 | 236 | 327 | CBQ71383.1 conserved hypothetical protein [Sporisorium reilianum SRZ2] | diamond | 276 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium reilianum | |
| 28015397 | 28015397 | PRJNA1104180_P_NODE_14085_length_283_cov_0.971429_g13943_i0 | PRJNA1104180 | 14085 | 283 | 0.971429 | 2.74914407 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 63.5 | 2.87e-9 | NR | CAD6583540.1 | 2778381 | g13943 | i0 | 67.3 | 0.519434628975265 | 49 | 13 | 51.9 | 2 | 9 | 155 | 958 | 1003 | CAD6583540.1 MAG: Uridine kinase [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 147 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 28362449 | 28362449 | PRJNA1104180_P_NODE_23626_length_245_cov_1.540698_g23483_i0 | PRJNA1104180 | 23626 | 245 | 1.540698 | 3.7747101 | Malassezia restricta | 76775 | Fungi | Fungi | 132 | 9.799999999999999e-35 | NR | XP_027484470.1 | 76775 | g23483 | i0 | 86.1 | 0.96734693877551 | 79 | 11 | 96.7 | 0 | 9 | 245 | 90 | 168 | XP_027484470.1 putative methyltransferase [Malassezia restricta] | diamond | 237 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28827267 | 28827267 | PRJNA1104180_P_NODE_21608_length_249_cov_0.875000_g21465_i0 | PRJNA1104180 | 21608 | 249 | 0.875 | 2.17875 | Naganishia | 1851509 | Fungi | Fungi | 124 | 4.309999999999999e-31 | NR | KAJ9108881.1 | 89922 | g21465 | i0 | 96.9 | 1.56626506024096 | 65 | 2 | 78.3 | 0 | 2 | 196 | 447 | 511 | KAJ9108881.1 hypothetical protein QFC21_000201 [Naganishia friedmannii] | diamond | 390 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia friedmannii | |
| 29688376 | 29688376 | PRJNA1104180_P_NODE_16490_length_269_cov_1.571429_g16348_i0 | PRJNA1104180 | 16490 | 269 | 1.571429 | 4.22714401 | Meira miltonrushii | 1280837 | Fungi | Fungi | 162 | 4.29e-47 | NR | XP_025353136.1 | 1280837 | g16348 | i0 | 84.3 | 0.992565055762082 | 89 | 14 | 99.3 | 0 | 269 | 3 | 128 | 216 | XP_025353136.1 uncharacterized protein FA14DRAFT_78512 [Meira miltonrushii] | diamond | 267 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 29751566 | 29751566 | PRJNA1104180_P_NODE_24671_length_244_cov_0.900585_g24528_i0 | PRJNA1104180 | 24671 | 244 | 0.900585 | 2.1974274 | Naganishia albida | 100951 | Fungi | Fungi | 164 | 1.5e-45 | NR | KAI5450221.1 | 100951 | g24528 | i0 | 96.3 | 0.995901639344262 | 81 | 3 | 99.6 | 0 | 243 | 1 | 259 | 339 | KAI5450221.1 hypothetical protein NCC49_003238 [Naganishia albida] | diamond | 243 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 29846591 | 29846591 | PRJNA1104180_P_NODE_17611_length_263_cov_1.621053_g17469_i0 | PRJNA1104180 | 17611 | 263 | 1.621053 | 4.26336939 | Vararia minispora EC-137 | 1314806 | Fungi | Fungi | 52.8 | 1.41e-5 | NR | KAI0027002.1 | 1314806 | g17469 | i0 | 43.2 | 8.89733840304183 | 81 | 27 | 92.4 | 1 | 6 | 248 | 603 | 664 | KAI0027002.1 HlyB/MsbA family ABC transporter [Vararia minispora EC-137] | diamond | 2340 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Lachnocladiaceae | Vararia | Vararia minispora | |
| 30794303 | 30794303 | PRJNA1104180_P_NODE_23594_length_245_cov_1.715116_g23451_i0 | PRJNA1104180 | 23594 | 245 | 1.715116 | 4.2020342 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 55.8 | 3.58e-7 | NR | CAD6580253.1 | 2778381 | g23451 | i0 | 63.4 | 0.502040816326531 | 41 | 15 | 50.2 | 0 | 2 | 124 | 118 | 158 | CAD6580253.1 MAG: hypothetical protein CYPHOPRED_001172 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 123 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 31607609 | 31607609 | PRJNA1104180_P_NODE_20416_length_251_cov_0.865169_g20273_i0 | PRJNA1104180 | 20416 | 251 | 0.865169 | 2.17157419 | Rhodotorula | 5533 | Fungi | Fungi | 156 | 3.89e-42 | NR | KAG0662967.1 | 5537 | g20273 | i0 | 100 | 1.9840637450199201 | 83 | 0 | 99.2 | 0 | 251 | 3 | 996 | 1078 | KAG0662967.1 mannose-ethanolamine phosphotransferase gpi13 [Rhodotorula mucilaginosa] | diamond | 498 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 31679438 | 31679438 | PRJNA1104180_P_NODE_23557_length_245_cov_1.790698_g23414_i0 | PRJNA1104180 | 23557 | 245 | 1.790698 | 4.3872101 | Malassezia furfur | 55194 | Fungi | Fungi | 58.5 | 1.03e-7 | NR | KAI3617202.1 | 55194 | g23414 | i0 | 46.8 | 0.942857142857143 | 77 | 33 | 84.5 | 2 | 209 | 3 | 566 | 642 | KAI3617202.1 hypothetical protein CBS9595_003111 [Malassezia furfur] | diamond | 231 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 31711223 | 31711223 | PRJNA1104180_P_NODE_15537_length_274_cov_1.691542_g15395_i0 | PRJNA1104180 | 15537 | 274 | 1.691542 | 4.63482508 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 114 | 8.189999999999998e-30 | NR | WFD14021.1 | 1514897 | g15395 | i0 | 100 | 0.569343065693431 | 52 | 0 | 56.9 | 0 | 117 | 272 | 25 | 76 | WFD14021.1 hypothetical protein MARU1_000016 [Malassezia arunalokei] | diamond | 156 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 32628249 | 32628249 | PRJNA1104180_P_NODE_25300_length_243_cov_0.905882_g25157_i0 | PRJNA1104180 | 25300 | 243 | 0.905882 | 2.20129326 | Leucoagaricus sp. SymC.cos | 1714833 | Fungi | Fungi | 77.8 | 1.47e-14 | NR | KXN85488.1 | 1714833 | g25157 | i0 | 46.3 | 3.34567901234568 | 80 | 37 | 98.8 | 2 | 2 | 241 | 180 | 253 | KXN85488.1 Lysine-specific demethylase 8 [Leucoagaricus sp. SymC.cos] | diamond | 813 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucoagaricus | Leucoagaricus sp. SymC.cos |
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);;