contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA927284" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2177242 | 2177242 | PRJNA927284_P_NODE_8682_length_162_cov_1.736842_g8475_i0 | PRJNA927284 | 8682 | 162 | 1.736842 | 2.81368404 | Malassezia restricta | 76775 | Fungi | Fungi | 294 | 2.03e-75 | NTclustered | gi|1546632402|ref|XM_027627861.1| | 76775 | g8475 | i0 | 100 | 89.1851851851852 | 159 | 0 | 98 | 0 | 1 | 159 | 1113 | 1271 | Malassezia restricta elongation factor 1-alpha (MRET_1234), partial mRNA | blastn | 14448 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3452750 | 3452750 | PRJNA927284_P_NODE_5263_length_247_cov_5.642202_g5056_i0 | PRJNA927284 | 5263 | 247 | 5.642202 | 13.93623894 | Malassezia restricta | 76775 | Fungi | Fungi | 399 | 6.919999999999998e-107 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5056 | i0 | 97.835 | 71.4777327935223 | 231 | 5 | 94 | 0 | 1 | 231 | 3312 | 3082 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17655 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3804598 | 3804598 | PRJNA927284_P_NODE_3503_length_341_cov_4.993590_g3298_i0 | PRJNA927284 | 3503 | 341 | 4.99359 | 17.0281419 | Tremellales | 5234 | Fungi | Fungi | 420 | 7.67e-113 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g3298 | i0 | 88.889 | 144.909090909091 | 351 | 25 | 100 | 10 | 1 | 341 | 3339 | 2993 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 49414 | 424 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 4730323 | 4730323 | PRJNA927284_P_NODE_8004_length_174_cov_1.875862_g7797_i0 | PRJNA927284 | 8004 | 174 | 1.875862 | 3.26399988 | Malassezia restricta | 76775 | Fungi | Fungi | 159 | 8.379999999999998e-35 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g7797 | i0 | 84.571 | 46.6666666666667 | 175 | 12 | 100 | 10 | 1 | 174 | 3152 | 3312 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 8120 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6356603 | 6356603 | PRJNA927284_P_NODE_3445_length_345_cov_17.493671_g3240_i0 | PRJNA927284 | 3445 | 345 | 17.493671 | 60.35316495 | Eukaryota | 2759 | Fungi | Fungi | 348 | 3.72e-91 | NTclustered | gi|2558627581|gb|OR405830.1| | 76775 | g3240 | i0 | 100 | 55.5826086956522 | 188 | 0 | 54 | 0 | 157 | 344 | 304 | 491 | Malassezia restricta strain GSVCC20Z3-2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 19176 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7279942 | 7279942 | PRJNA927284_P_NODE_8126_length_172_cov_1.314685_g7919_i0 | PRJNA927284 | 8126 | 172 | 1.314685 | 2.2612582 | Tapinella panuoides | 80604 | Fungi | Fungi | 93.5 | 8.5e-15 | NTclustered | gi|66864459|gb|DQ071838.1| | 80604 | g7919 | i0 | 85.87 | 59.2325581395349 | 92 | 8 | 53 | 4 | 1 | 91 | 40 | 127 | Tapinella panuoides voucher G480A 28S large subunit ribosomal RNA gene, partial sequence | blastn | 10188 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Tapinellaceae | Tapinella | Tapinella panuoides | |
| 9829661 | 9829661 | PRJNA927284_P_NODE_8648_length_162_cov_4.917293_g8441_i0 | PRJNA927284 | 8648 | 162 | 4.917293 | 7.96601466 | Malassezia restricta | 76775 | Fungi | Fungi | 211 | 2.1e-50 | NTclustered | gi|1546637503|ref|XM_027630394.1| | 76775 | g8441 | i0 | 98.333 | 2.24691358024691 | 120 | 2 | 74 | 0 | 1 | 120 | 160 | 279 | Malassezia restricta uncharacterized protein (MRET_3767), partial mRNA | blastn | 364 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11105458 | 11105458 | PRJNA927284_P_NODE_6329_length_211_cov_4.939560_g6122_i0 | PRJNA927284 | 6329 | 211 | 4.93956 | 10.4224716 | uncultured Basidiomycota | 175244 | Fungi | Fungi | 333 | 5.91e-87 | NTclustered | gi|255339782|gb|FJ889092.1| | 175244 | g6122 | i0 | 95.261 | 100 | 211 | 9 | 100 | 1 | 1 | 211 | 488 | 279 | Uncultured Basidiomycota clone M4.3.2.7 small subunit ribosomal RNA gene, partial sequence | blastn | 21100 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | uncultured Basidiomycota | |||||
| 11456342 | 11456342 | PRJNA927284_P_NODE_5849_length_225_cov_18.556122_g5642_i0 | PRJNA927284 | 5849 | 225 | 18.556122 | 41.7512745 | Basidiomycota | 5204 | Fungi | Fungi | 388 | 1.34e-103 | NTclustered | gi|1859735553|gb|MT644871.1| | 84747 | g5642 | i0 | 97.778 | 105.262222222222 | 225 | 5 | 100 | 0 | 1 | 225 | 5042 | 5266 | Entyloma ficariae isolate DM1162 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23684 | 390 | 0.994871794871795 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Entylomataceae | Entyloma | Entyloma ficariae | |
| 12381024 | 12381024 | PRJNA927284_P_NODE_3290_length_357_cov_8.143293_g3085_i0 | PRJNA927284 | 3290 | 357 | 8.143293 | 29.07155601 | Bullera unica | 57474 | Fungi | Fungi | 638 | 2.04e-178 | NTclustered | gi|1545773604|ref|NG_063531.1| | 57474 | g3085 | i0 | 98.88 | 99.9803921568627 | 357 | 4 | 100 | 0 | 1 | 357 | 569 | 925 | Bullera unica JCM 8932 18S rRNA gene, partial sequence; from TYPE material | blastn | 35693 | 638 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleraceae | Bullera | Bullera unica | |
| 16555063 | 16555063 | PRJNA927284_P_NODE_9353_length_150_cov_2.107438_g9146_i0 | PRJNA927284 | 9353 | 150 | 2.107438 | 3.161157 | Ceratobasidiaceae | 5250 | Fungi | Fungi | 267 | 4.009999999999999e-67 | NTclustered | gi|91983815|gb|DQ369859.1| | 107832 | g9146 | i0 | 98.667 | 100.04 | 150 | 2 | 100 | 0 | 1 | 150 | 594 | 743 | Thanatephorus cucumeris clone GS1Rsol large subunit ribosomal RNA, partial sequence; mitochondrial | blastn | 15006 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Thanatephorus | Thanatephorus cucumeris | |
| 17830070 | 17830070 | PRJNA927284_P_NODE_9194_length_153_cov_1.354839_g8987_i0 | PRJNA927284 | 9194 | 153 | 1.354839 | 2.07290367 | Rhizoctonia | 1322061 | Fungi | Fungi | 189 | 9.16e-44 | NTclustered | gi|2047401327|gb|MW995475.1| | 456999 | g8987 | i0 | 99.048 | 6.17647058823529 | 105 | 1 | 69 | 0 | 49 | 153 | 132999 | 132895 | Rhizoctonia solani strain AG1-IB mitochondrion, complete genome | blastn | 945 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 19104014 | 19104014 | PRJNA927284_P_NODE_2975_length_383_cov_5.079096_g2773_i0 | PRJNA927284 | 2975 | 383 | 5.079096 | 19.45293768 | Agaricomycetes | 155619 | Fungi | Fungi | 353 | 8.94e-93 | NTclustered | gi|1866609494|gb|MT732083.1| | 281719 | g2773 | i0 | 90.11 | 101.55091383812 | 273 | 26 | 71 | 1 | 1 | 272 | 727 | 455 | Polyozellus multiplex voucher TU115322 large subunit ribosomal RNA gene, partial sequence | blastn | 38894 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Polyozellus | Polyozellus multiplex | |
| 23854134 | 23854134 | PRJNA927284_P_NODE_3399_length_349_cov_6.871875_g3194_i0 | PRJNA927284 | 3399 | 349 | 6.871875 | 23.98284375 | Dioszegia hungarica | 4972 | Fungi | Fungi | 394 | 4.75e-105 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g3194 | i0 | 87.252 | 143.796561604585 | 353 | 35 | 100 | 10 | 1 | 349 | 2993 | 3339 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 50185 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 24204101 | 24204101 | PRJNA927284_P_NODE_4219_length_297_cov_7.212687_g4012_i0 | PRJNA927284 | 4219 | 297 | 7.212687 | 21.42168039 | Opisthokonta | 33154 | Fungi | Fungi | 549 | 8.029999999999997e-152 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g4012 | i0 | 100 | 99.8148148148148 | 297 | 0 | 100 | 0 | 1 | 297 | 233 | 529 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 29645 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24204102 | 24204102 | PRJNA927284_P_NODE_4239_length_296_cov_4.988764_g4032_i0 | PRJNA927284 | 4239 | 296 | 4.988764 | 14.76674144 | Tremellales | 5234 | Fungi | Fungi | 436 | 6.489999999999999e-118 | NTclustered | gi|4566326|gb|AF075494.1|AF075494 | 157671 | g4032 | i0 | 93.537 | 99.3108108108108 | 294 | 18 | 99 | 1 | 3 | 296 | 615 | 323 | Cryptococcus sp. CBS 7890 26S ribosomal RNA gene, partial sequence | blastn | 29396 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus sp. CBS 7890 |
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);;