contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6223369 | 6223369 | PRJNA549880_P_NODE_8465_length_278_cov_1.785366_g8372_i0 | PRJNA549880 | 8465 | 278 | 1.785366 | 4.96331748 | Erythrobasidium | 5413 | Fungi | Fungi | 505 | 1.63e-138 | NTclustered | gi|6782424|gb|AF131058.1| | 5414 | g8372 | i0 | 99.638 | 98.3812949640288 | 276 | 1 | 99 | 0 | 3 | 278 | 304 | 29 | Erythrobasidium hasegawianum strain JCM 1545 large subunit ribosomal RNA gene, partial sequence | blastn | 27350 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Erythrobasidiales | Erythrobasidiaceae | Erythrobasidium | Erythrobasidium hasegawianum | |
| 6889533 | 6889533 | PRJNA549880_P_NODE_13046_length_246_cov_0.890173_g12953_i0 | PRJNA549880 | 13046 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 296 | 9.3e-76 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12953 | i0 | 98.235 | 69.6951219512195 | 170 | 2 | 69 | 1 | 1 | 170 | 3041 | 3209 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 17145 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6889667 | 6889667 | PRJNA549880_P_NODE_5126_length_340_cov_1.205993_g5033_i0 | PRJNA549880 | 5126 | 340 | 1.205993 | 4.1003762 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 196 | 1.4e-45 | NTclustered | gi|1423576474|ref|XM_025742275.1| | 58919 | g5033 | i0 | 85.87 | 14.8117647058824 | 184 | 26 | 54 | 0 | 81 | 264 | 85 | 268 | Tilletiopsis washingtonensis putative 40S ribosomal protein S27 (FA09DRAFT_329678), mRNA | blastn | 5036 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 9440288 | 9440288 | PRJNA549880_P_NODE_4108_length_370_cov_3.225589_g4015_i0 | PRJNA549880 | 4108 | 370 | 3.225589 | 11.9346793 | Malassezia restricta | 76775 | Fungi | Fungi | 676 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g4015 | i0 | 99.73 | 106.197297297297 | 370 | 0 | 100 | 1 | 1 | 370 | 1875 | 1507 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 39293 | 676 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13265653 | 13265653 | PRJNA549880_P_NODE_11891_length_248_cov_0.880000_g11798_i0 | PRJNA549880 | 11891 | 248 | 0.88 | 2.1824 | Dioszegia hungarica | 4972 | Fungi | Fungi | 279 | 9.45e-71 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g11798 | i0 | 87.302 | 146.685483870968 | 252 | 22 | 100 | 8 | 1 | 248 | 3055 | 3300 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 36378 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 15814758 | 15814758 | PRJNA549880_P_NODE_5493_length_332_cov_1.185328_g5400_i0 | PRJNA549880 | 5493 | 332 | 1.185328 | 3.93528896 | Lentinus tigrinus | 5365 | Fungi | Fungi | 204 | 8.159999999999998e-48 | NTclustered | gi|2797420667|ref|XM_067684631.1| | 1328758 | g5400 | i0 | 81.369 | 60.2560240963855 | 263 | 37 | 78 | 9 | 1 | 260 | 275 | 22 | Lentinus tigrinus ALCF2SS1-7 40S ribosomal protein uS5 (L226DRAFT_572002), partial mRNA | blastn | 20005 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 18363371 | 18363371 | PRJNA549880_P_NODE_12015_length_248_cov_0.880000_g11922_i0 | PRJNA549880 | 12015 | 248 | 0.88 | 2.1824 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 398 | 2.5e-106 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g11922 | i0 | 95.918 | 144.899193548387 | 245 | 10 | 99 | 0 | 4 | 248 | 3904 | 3660 | 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 | 35935 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis |
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);;