contig_metadata
17 rows where bioproject = "PRJNA688352", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942928 | 1942928 | PRJNA688352_P_NODE_9902_length_246_cov_0.890173_g9799_i0 | PRJNA688352 | 9902 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 3.14e-120 | NTclustered | gi|1546632568|ref|XM_027627944.1| | 76775 | g9799 | i0 | 99.588 | 0.98780487804878 | 243 | 1 | 99 | 0 | 1 | 243 | 3347 | 3589 | Malassezia restricta coatomer subunit alpha (MRET_1317), partial mRNA | blastn | 243 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2451991 | 2451991 | PRJNA688352_P_NODE_12942_length_209_cov_12.580882_g12839_i0 | PRJNA688352 | 12942 | 209 | 12.580882 | 26.29404338 | Basidiomycota | 5204 | Fungi | Fungi | 387 | 4.42e-103 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12839 | i0 | 100 | 99.9952153110048 | 209 | 0 | 100 | 0 | 1 | 209 | 2822 | 2614 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 20899 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3217777 | 3217777 | PRJNA688352_P_NODE_4643_length_299_cov_2.659292_g4540_i0 | PRJNA688352 | 4643 | 299 | 2.659292 | 7.95128308 | Malassezia globosa | 76773 | Fungi | Fungi | 553 | 6.25e-153 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g4540 | i0 | 100 | 57.5183946488294 | 299 | 0 | 100 | 0 | 1 | 299 | 2963 | 2665 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 17198 | 553 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 3217815 | 3217815 | PRJNA688352_P_NODE_823_length_657_cov_3.294521_g723_i0 | PRJNA688352 | 823 | 657 | 3.294521 | 21.64500297 | Malassezia globosa | 76773 | Fungi | Fungi | 1136 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g723 | i0 | 97.869 | 84.3287671232877 | 657 | 14 | 100 | 0 | 1 | 657 | 29539 | 30195 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 55404 | 1136 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 3728529 | 3728529 | PRJNA688352_P_NODE_1763_length_448_cov_1.656000_g1660_i0 | PRJNA688352 | 1763 | 448 | 1.656 | 7.41888 | Agaricomycetes | 155619 | Fungi | Fungi | 636 | 9.419999999999999e-178 | NTclustered | gi|1859735543|gb|MT644861.1| | 112237 | g1660 | i0 | 92.428 | 106.203125 | 449 | 29 | 100 | 3 | 1 | 448 | 4125 | 3681 | Amylostereum laevigatum isolate DM1181 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 | 47579 | 641 | 0.992199687987519 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum laevigatum | |
| 4494861 | 4494861 | PRJNA688352_P_NODE_9844_length_246_cov_0.890173_g9741_i0 | PRJNA688352 | 9844 | 246 | 0.890173 | 2.18982558 | Malassezia globosa | 76773 | Fungi | Fungi | 405 | 1.48e-108 | NTclustered | gi|164658585|ref|XM_001730366.1| | 425265 | g9741 | i0 | 96.341 | 1 | 246 | 9 | 100 | 0 | 1 | 246 | 178 | 423 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2214), partial mRNA | blastn | 246 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 5770472 | 5770472 | PRJNA688352_P_NODE_1105_length_566_cov_1.894523_g1003_i0 | PRJNA688352 | 1105 | 566 | 1.894523 | 10.72300018 | Malassezia globosa | 76773 | Fungi | Fungi | 1035 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1003 | i0 | 99.647 | 47.4734982332156 | 566 | 2 | 100 | 0 | 1 | 566 | 1173 | 1738 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 26870 | 1035 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7045532 | 7045532 | PRJNA688352_P_NODE_6606_length_258_cov_1.664865_g6503_i0 | PRJNA688352 | 6606 | 258 | 1.664865 | 4.2953517 | Bartheletia paradoxa | 669517 | Fungi | Fungi | 477 | 3.2699999999999985e-130 | NTclustered | gi|514996142|gb|KF147790.1| | 669517 | g6503 | i0 | 100 | 18.1782945736434 | 258 | 0 | 100 | 0 | 1 | 258 | 302 | 45 | Bartheletia paradoxa strain RB 3118 ATPase subunit 6 (ATP6) gene, partial cds; mitochondrial | blastn | 4690 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Bartheletiomycetes | Bartheletiales | Bartheletiaceae | Bartheletia | Bartheletia paradoxa | |
| 7045541 | 7045541 | PRJNA688352_P_NODE_766_length_679_cov_2.834983_g666_i0 | PRJNA688352 | 766 | 679 | 2.834983 | 19.24953457 | Malassezia globosa | 76773 | Fungi | Fungi | 1210 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g666 | i0 | 98.824 | 63.4256259204713 | 680 | 6 | 100 | 2 | 1 | 679 | 961 | 283 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 43066 | 1210 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9595449 | 9595449 | PRJNA688352_P_NODE_4168_length_312_cov_1.451883_g4065_i0 | PRJNA688352 | 4168 | 312 | 1.451883 | 4.52987496 | Malassezia globosa | 76773 | Fungi | Fungi | 577 | 3.89e-160 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g4065 | i0 | 100 | 50.0705128205128 | 312 | 0 | 100 | 0 | 1 | 312 | 30713 | 30402 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 15622 | 577 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 15205431 | 15205431 | PRJNA688352_P_NODE_4972_length_291_cov_1.889908_g4869_i0 | PRJNA688352 | 4972 | 291 | 1.889908 | 5.49963228 | Malassezia | 55193 | Fungi | Fungi | 538 | 1.6999999999999994e-148 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g4869 | i0 | 100 | 56.8797250859106 | 291 | 0 | 100 | 0 | 1 | 291 | 33610 | 33320 | Malassezia restricta mitochondrion, complete genome | blastn | 16552 | 538 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18519010 | 18519010 | PRJNA688352_P_NODE_9775_length_246_cov_0.890173_g9672_i0 | PRJNA688352 | 9775 | 246 | 0.890173 | 2.18982558 | Malassezia globosa | 76773 | Fungi | Fungi | 418 | 1.9e-112 | NTclustered | gi|164661076|ref|XM_001731609.1| | 425265 | g9672 | i0 | 100 | 0.91869918699187 | 226 | 0 | 92 | 0 | 2 | 227 | 226 | 1 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0929), partial mRNA | blastn | 226 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 23619703 | 23619703 | PRJNA688352_P_NODE_12679_length_233_cov_4.768750_g12576_i0 | PRJNA688352 | 12679 | 233 | 4.76875 | 11.1111875 | Malassezia restricta | 76775 | Fungi | Fungi | 431 | 2.2899999999999996e-116 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12576 | i0 | 100 | 103.768240343348 | 233 | 0 | 100 | 0 | 1 | 233 | 2652 | 2420 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 24178 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24893005 | 24893005 | PRJNA688352_P_NODE_1880_length_432_cov_2.181058_g1777_i0 | PRJNA688352 | 1880 | 432 | 2.181058 | 9.42217056 | Malassezia globosa | 76773 | Fungi | Fungi | 741 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1777 | i0 | 97.685 | 66.8796296296296 | 432 | 9 | 100 | 1 | 1 | 432 | 1945 | 2375 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 28892 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 27726013 | 27726013 | PRJNA688352_P_NODE_10564_length_244_cov_0.900585_g10461_i0 | PRJNA688352 | 10564 | 244 | 0.900585 | 2.1974274 | Russulales | 452342 | Fungi | Fungi | 96.3 | 5.3100000000000005e-21 | NR | KAI0051775.1 | 40419 | g10461 | i0 | 65.4 | 3.94672131147541 | 81 | 28 | 99.6 | 0 | 2 | 244 | 39 | 119 | KAI0051775.1 hypothetical protein FA95DRAFT_202400 [Auriscalpium vulgare] | diamond | 963 | 96.7 | 0.995863495346432 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Auriscalpiaceae | Auriscalpium | Auriscalpium vulgare | |
| 27745853 | 27745853 | PRJNA688352_P_NODE_11724_length_242_cov_0.911243_g11621_i0 | PRJNA688352 | 11724 | 242 | 0.911243 | 2.20520806 | Exobasidium rhododendri | 63378 | Fungi | Fungi | 88.2 | 3.41e-18 | NR | UZJ57338.1 | 63378 | g11621 | i0 | 79.4 | 0.78099173553719 | 63 | 13 | 78.1 | 0 | 233 | 45 | 93 | 155 | UZJ57338.1 hypothetical protein CBS101457_006658 [Exobasidium rhododendri] | diamond | 189 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 30019230 | 30019230 | PRJNA688352_P_NODE_5331_length_283_cov_1.466667_g5228_i0 | PRJNA688352 | 5331 | 283 | 1.466667 | 4.15066761 | Botryobasidium botryosum FD-172 SS1 | 930990 | Fungi | Fungi | 46.2 | 0.00361 | NR | KDQ15872.1 | 930990 | g5228 | i0 | 34 | 1.02826855123675 | 97 | 52 | 90.1 | 2 | 261 | 7 | 267 | 363 | KDQ15872.1 hypothetical protein BOTBODRAFT_31331 [Botryobasidium botryosum FD-172 SS1] | diamond | 291 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Botryobasidiaceae | Botryobasidium | Botryobasidium botryosum |
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);;