contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3495150 | 3495150 | PRJNA971676_P_NODE_10363_length_283_cov_1.404762_g10274_i0 | PRJNA971676 | 10363 | 283 | 1.404762 | 3.97547646 | Stereum hirsutum | 40492 | Fungi | Fungi | 97.1 | 1.19e-15 | NTclustered | gi|618814962|ref|XM_007310031.1| | 721885 | g10274 | i0 | 86.364 | 2.20494699646643 | 88 | 12 | 31 | 0 | 60 | 147 | 1142 | 1055 | Stereum hirsutum FP-91666 SS1 L-glutamine D-fructose 6-phosphate amidotransferase (STEHIDRAFT_125654), mRNA | blastn | 624 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 6047770 | 6047770 | PRJNA971676_P_NODE_16925_length_248_cov_0.880000_g16836_i0 | PRJNA971676 | 16925 | 248 | 0.88 | 2.1824 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 298 | 2.61e-76 | NTclustered | gi|808372198|ref|XM_012335809.1| | 1305764 | g16836 | i0 | 88.4 | 1.00806451612903 | 250 | 25 | 100 | 4 | 1 | 248 | 618 | 371 | Pseudozyma hubeiensis SY62 hypothetical protein partial mRNA | blastn | 250 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 7322669 | 7322669 | PRJNA971676_P_NODE_18966_length_246_cov_0.890173_g18877_i0 | PRJNA971676 | 18966 | 246 | 0.890173 | 2.18982558 | Filobasidium floriforme | 5210 | Fungi | Fungi | 235 | 2.06e-57 | NTclustered | gi|2185537784|ref|XM_046180896.1| | 5210 | g18877 | i0 | 99.231 | 0.528455284552846 | 130 | 1 | 53 | 0 | 70 | 199 | 603 | 474 | Filobasidium floriforme glucosidase II beta subunit-like-domain-containing protein (HD553DRAFT_318580), mRNA | blastn | 130 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 7322823 | 7322823 | PRJNA971676_P_NODE_7066_length_327_cov_1.086614_g6977_i0 | PRJNA971676 | 7066 | 327 | 1.086614 | 3.55322778 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 243 | 1.7e-59 | NTclustered | gi|1023181563|ref|XM_016436977.1| | 1365824 | g6977 | i0 | 82.796 | 81.2354740061162 | 279 | 40 | 84 | 8 | 30 | 304 | 347 | 73 | Kalmanozyma brasiliensis GHG001 Histone core (PSEUBRA_002561), partial mRNA | blastn | 26564 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 11148187 | 11148187 | PRJNA971676_P_NODE_15989_length_249_cov_0.875000_g15900_i0 | PRJNA971676 | 15989 | 249 | 0.875 | 2.17875 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 255 | 1.6e-63 | NTclustered | gi|2669720196|ref|XM_062767230.1| | 143232 | g15900 | i0 | 86.383 | 51.2771084337349 | 235 | 30 | 94 | 2 | 16 | 249 | 726 | 493 | Vanrija pseudolonga GTP-binding protein ypt1 (ypt1), mRNA | blastn | 12768 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 13698401 | 13698401 | PRJNA971676_P_NODE_3271_length_435_cov_1.477901_g3182_i0 | PRJNA971676 | 3271 | 435 | 1.477901 | 6.42886935 | Vanrija humicola | 5417 | Fungi | Fungi | 285 | 3.81e-72 | NTclustered | gi|921326975|dbj|AB919762.1| | 5417 | g3182 | i0 | 81.215 | 53.6804597701149 | 362 | 60 | 82 | 8 | 4 | 361 | 838 | 1195 | Vanrija humicola gene for adenosylhomocysteinase, complete sequence, strain: JCM 1457 | blastn | 23351 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 16247618 | 16247618 | PRJNA971676_P_NODE_4973_length_371_cov_0.741611_g4884_i0 | PRJNA971676 | 4973 | 371 | 0.741611 | 2.75137681 | Malassezia restricta | 76775 | Fungi | Fungi | 656 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g4884 | i0 | 98.652 | 99.5687331536388 | 371 | 4 | 100 | 1 | 1 | 371 | 1554 | 1923 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 36940 | 656 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20071471 | 20071471 | PRJNA971676_P_NODE_8036_length_311_cov_1.592437_g7947_i0 | PRJNA971676 | 8036 | 311 | 1.592437 | 4.95247907 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1423581197|ref|XM_025745741.1| | 58919 | g7947 | i0 | 100 | 0.0964630225080386 | 30 | 0 | 10 | 0 | 93 | 122 | 345 | 374 | Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_61677), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 21346748 | 21346748 | PRJNA971676_P_NODE_21977_length_242_cov_1.242604_g21888_i0 | PRJNA971676 | 21977 | 242 | 1.242604 | 3.00710168 | Vanrija albida | 181172 | Fungi | Fungi | 67.6 | 7.78e-7 | NTclustered | gi|2837738689|ref|XM_069355297.1| | 181172 | g21888 | i0 | 95.238 | 2.28512396694215 | 42 | 2 | 17 | 0 | 81 | 122 | 370 | 411 | Vanrija albida histone H3.1 (HHT1_2), partial mRNA | blastn | 553 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida | |
| 22621888 | 22621888 | PRJNA971676_P_NODE_4938_length_372_cov_0.779264_g4849_i0 | PRJNA971676 | 4938 | 372 | 0.779264 | 2.89886208 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 211 | 5.52e-50 | NTclustered | gi|630959635|ref|XM_007878035.1| | 1277687 | g4849 | i0 | 78.161 | 69.5860215053764 | 348 | 64 | 92 | 8 | 1 | 342 | 342 | 1 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_00541), partial mRNA | blastn | 25886 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 23897167 | 23897167 | PRJNA971676_P_NODE_22179_length_242_cov_0.911243_g22090_i0 | PRJNA971676 | 22179 | 242 | 0.911243 | 2.20520806 | Vanrija albida | 181172 | Fungi | Fungi | 154 | 5.81e-33 | NTclustered | gi|2837745264|ref|XM_069356392.1| | 181172 | g22090 | i0 | 83.14 | 42.3223140495868 | 172 | 25 | 70 | 4 | 70 | 239 | 206 | 375 | Vanrija albida translation elongation factor Tu (TUF1), partial mRNA | blastn | 10242 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida |
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);;