contig_metadata
11 rows where bioproject = "PRJNA242641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1642221 | 1642221 | PRJNA242641_S_NODE_1102_length_219_cov_15.026316_g1074_i0 | PRJNA242641 | 1102 | 219 | 15.026316 | 32.90763204 | Malasseziomycetes sp. | 2065442 | Fungi | Fungi | 388 | 1.3e-103 | NTclustered | gi|1315691856|gb|MG712118.1| | 2065442 | g1074 | i0 | 98.63 | 100 | 219 | 3 | 100 | 0 | 1 | 219 | 142 | 360 | Malasseziomycetes sp. isolate SN1-68 small subunit ribosomal RNA gene, partial sequence | blastn | 21900 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziomycetes sp. | ||||
| 4884649 | 4884649 | PRJNA242641_S_NODE_2444_length_150_cov_10.090909_g2416_i0 | PRJNA242641 | 2444 | 150 | 10.090909 | 15.1363635 | Bannoa | 111309 | Fungi | Fungi | 255 | 8.680000000000001e-64 | NTclustered | gi|18916369|dbj|AB035718.1| | 111310 | g2416 | i0 | 97.973 | 98.68 | 148 | 2 | 99 | 1 | 3 | 150 | 905 | 759 | Bannoa ogasawarensis genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 26S rRNA, partial and complete sequence, strain: JCM 10331 | blastn | 14802 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Bannoa | Bannoa ogasawarensis | |
| 5470792 | 5470792 | PRJNA242641_S_NODE_1265_length_204_cov_33.445714_g1237_i0 | PRJNA242641 | 1265 | 204 | 33.445714 | 68.22925656 | uncultured Lignosus | 1193702 | Fungi | Fungi | 366 | 5.599999999999998e-97 | NTclustered | gi|453201962|gb|JQ999870.1| | 1193702 | g1237 | i0 | 99.02 | 105.985294117647 | 204 | 2 | 100 | 0 | 1 | 204 | 247 | 44 | Uncultured Lignosus clone GKJWQY101BZ0DZ 28S ribosomal RNA gene, partial sequence | blastn | 21621 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | uncultured Lignosus | ||
| 8709357 | 8709357 | PRJNA242641_S_NODE_1947_length_167_cov_3.014493_g1919_i0 | PRJNA242641 | 1947 | 167 | 3.014493 | 5.03420331 | Symmetrospora | 1798808 | Fungi | Fungi | 309 | 7.53e-80 | NTclustered | gi|1858897746|ref|NG_069416.1| | 5441 | g1919 | i0 | 100 | 100.083832335329 | 167 | 0 | 100 | 0 | 1 | 167 | 637 | 803 | Symmetrospora oryzicola CBS 7228 28S rRNA gene, partial sequence; from TYPE material | blastn | 16714 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Symmetrosporaceae | Symmetrospora | Symmetrospora oryzicola | ||
| 9295509 | 9295509 | PRJNA242641_S_NODE_1408_length_196_cov_2.311377_g1380_i0 | PRJNA242641 | 1408 | 196 | 2.311377 | 4.53029892 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 302 | 1.5200000000000001e-77 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g1380 | i0 | 94.819 | 100.045918367347 | 193 | 10 | 98 | 0 | 1 | 193 | 4010 | 4202 | Cystobasidium laryngis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 19609 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 13810086 | 13810086 | PRJNA242641_S_NODE_1151_length_213_cov_20.934783_g1123_i0 | PRJNA242641 | 1151 | 213 | 20.934783 | 44.59108779 | Opisthokonta | 33154 | Fungi | Fungi | 377 | 2.72e-100 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g1123 | i0 | 98.592 | 106.615023474178 | 213 | 3 | 100 | 0 | 1 | 213 | 1718 | 1930 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 22709 | 377 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 15670225 | 15670225 | PRJNA242641_S_NODE_493_length_327_cov_5.251678_g465_i0 | PRJNA242641 | 493 | 327 | 5.251678 | 17.17298706 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 532 | 9.009999999999999e-147 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g465 | i0 | 96.024 | 100.877675840979 | 327 | 13 | 100 | 0 | 1 | 327 | 4054 | 3728 | Cystobasidium laryngis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 32987 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 16944722 | 16944722 | PRJNA242641_S_NODE_1994_length_165_cov_1.544118_g1966_i0 | PRJNA242641 | 1994 | 165 | 1.544118 | 2.5477947 | Malassezia globosa | 76773 | Fungi | Fungi | 305 | 9.59e-79 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1966 | i0 | 100 | 38.3515151515152 | 165 | 0 | 100 | 0 | 1 | 165 | 1058 | 1222 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 6328 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 21458397 | 21458397 | PRJNA242641_S_NODE_117_length_633_cov_23.360927_g58_i1 | PRJNA242641 | 117 | 633 | 23.360927 | 147.87466791 | Malassezia | 55193 | Fungi | Fungi | 798 | 0 | NTclustered | gi|953821272|gb|KT310070.1| | 76773 | g58 | i1 | 89.465 | 95.4881516587678 | 636 | 62 | 100 | 5 | 1 | 633 | 677 | 44 | Malassezia globosa isolate 1242 large subunit ribosomal RNA gene, partial sequence | blastn | 60444 | 798 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24008629 | 24008629 | PRJNA242641_S_NODE_539_length_314_cov_11.571930_g511_i0 | PRJNA242641 | 539 | 314 | 11.57193 | 36.3358602 | Malassezia | 55193 | Fungi | Fungi | 564 | 3.05e-156 | NTclustered | gi|724086736|gb|KM269160.1| | 76773 | g511 | i0 | 99.045 | 98 | 314 | 3 | 100 | 0 | 1 | 314 | 316 | 3 | Malassezia globosa strain 151.1 28S ribosomal RNA gene, partial sequence | blastn | 30772 | 564 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24593649 | 24593649 | PRJNA242641_S_NODE_780_length_260_cov_13.225108_g752_i0 | PRJNA242641 | 780 | 260 | 13.225108 | 34.3852808 | Malassezia restricta | 76775 | Fungi | Fungi | 381 | 2.659999999999999e-101 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g752 | i0 | 95.781 | 93.0384615384615 | 237 | 8 | 91 | 2 | 25 | 260 | 3209 | 2974 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 24190 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;