contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA855894" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2117856 | 2117856 | PRJNA855894_P_NODE_7062_length_609_cov_2.804104_g6941_i0 | PRJNA855894 | 7062 | 609 | 2.804104 | 17.07699336 | Malassezia restricta | 76775 | Fungi | Fungi | 1046 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g6941 | i0 | 97.701 | 106.471264367816 | 609 | 13 | 100 | 1 | 1 | 609 | 1308 | 1915 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 64841 | 1046 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3393054 | 3393054 | PRJNA855894_P_NODE_34423_length_241_cov_1.375000_g34301_i0 | PRJNA855894 | 34423 | 241 | 1.375 | 3.31375 | Malassezia restricta | 76775 | Fungi | Fungi | 446 | 8.519999999999999e-121 | NTclustered | gi|1546631359|ref|XM_027627340.1| | 76775 | g34301 | i0 | 100 | 5.85477178423236 | 241 | 0 | 100 | 0 | 1 | 241 | 559 | 799 | Malassezia restricta solute carrier family 25 (mitochondrial phosphate transporter), member 3 (MRET_0713), partial mRNA | blastn | 1411 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5063095 | 5063095 | PRJNA855894_P_NODE_33584_length_243_cov_0.905882_g33462_i0 | PRJNA855894 | 33584 | 243 | 0.905882 | 2.20129326 | Agaricales | 5338 | Fungi | Fungi | 272 | 1.5399999999999998e-68 | NTclustered | gi|62147561|emb|AJ871568.1| | 109634 | g33462 | i0 | 87.045 | 100.670781893004 | 247 | 24 | 100 | 6 | 1 | 243 | 286 | 528 | Gymnopilus junonius partial 25S rRNA gene, specimen voucher O 171053 | blastn | 24463 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Gymnopilus | Gymnopilus junonius | |
| 6339006 | 6339006 | PRJNA855894_P_NODE_34645_length_241_cov_0.916667_g34523_i0 | PRJNA855894 | 34645 | 241 | 0.916667 | 2.20916747 | Ganoderma | 5314 | Fungi | Fungi | 440 | 3.959999999999999e-119 | NTclustered | gi|77379305|gb|DQ208410.1| | 5315 | g34523 | i0 | 99.585 | 102 | 241 | 1 | 100 | 0 | 1 | 241 | 760 | 520 | Ganoderma lucidum strain IUM00298 large subunit ribosomal RNA gene, partial sequence | blastn | 24582 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 7612952 | 7612952 | PRJNA855894_P_NODE_21586_length_319_cov_1.288618_g21464_i0 | PRJNA855894 | 21586 | 319 | 1.288618 | 4.11069142 | Mycoaciella | 264134 | Fungi | Fungi | 577 | 3.99e-160 | NTclustered | gi|1040718448|dbj|LC134099.1| | 1819074 | g21464 | i0 | 100 | 99.7241379310345 | 312 | 0 | 98 | 0 | 7 | 318 | 1 | 312 | Polyporales sp. JCM 28407 gene for 28S ribosomal RNA, partial sequence | blastn | 31812 | 579 | 0.996545768566494 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporales sp. JCM 28407 | |||
| 8494904 | 8494904 | PRJNA855894_P_NODE_20767_length_327_cov_1.799213_g20645_i0 | PRJNA855894 | 20767 | 327 | 1.799213 | 5.88342651 | Malassezia restricta | 76775 | Fungi | Fungi | 604 | 1.8799999999999993e-168 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g20645 | i0 | 100 | 85.6422018348624 | 327 | 0 | 100 | 0 | 1 | 327 | 3299 | 2973 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 28005 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8495166 | 8495166 | PRJNA855894_P_NODE_30767_length_249_cov_0.875000_g30645_i0 | PRJNA855894 | 30767 | 249 | 0.875 | 2.17875 | Wallemia mellicola | 1708541 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|588259238|ref|XM_006958711.1| | 671144 | g30645 | i0 | 100 | 1.99598393574297 | 249 | 0 | 100 | 0 | 1 | 249 | 1152 | 904 | Wallemia mellicola CBS 633.66 Thiamin diphosphate-binding protein mRNA | blastn | 497 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 11045891 | 11045891 | PRJNA855894_P_NODE_29609_length_251_cov_0.865169_g29487_i0 | PRJNA855894 | 29609 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 464 | 2.47e-126 | NTclustered | gi|1546632778|ref|XM_027628049.1| | 76775 | g29487 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 996 | 746 | Malassezia restricta acyl-CoA oxidase (MRET_1422), partial mRNA | blastn | 251 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11438707 | 11438707 | PRJNA855894_P_NODE_22449_length_311_cov_1.941176_g22327_i0 | PRJNA855894 | 22449 | 311 | 1.941176 | 6.03705736 | Polyporales | 5303 | Fungi | Fungi | 508 | 1.4299999999999999e-139 | NTclustered | gi|1569044146|gb|MK496219.1| | 98765 | g22327 | i0 | 96.141 | 106.726688102894 | 311 | 12 | 100 | 0 | 1 | 311 | 5357 | 5667 | Phlebia centrifuga strain DSM 108282 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 | 33192 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Hermanssonia | Hermanssonia centrifuga | |
| 17420585 | 17420585 | PRJNA855894_P_NODE_34894_length_234_cov_2.763975_g34772_i0 | PRJNA855894 | 34894 | 234 | 2.763975 | 6.4677015 | Malassezia restricta | 76775 | Fungi | Fungi | 433 | 6.41e-117 | NTclustered | gi|1546631850|ref|XM_027627585.1| | 76775 | g34772 | i0 | 100 | 1 | 234 | 0 | 100 | 0 | 1 | 234 | 651 | 884 | Malassezia restricta midasin (MRET_0958), partial mRNA | blastn | 234 | 433 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20361228 | 20361228 | PRJNA855894_P_NODE_17696_length_361_cov_2.881944_g17574_i0 | PRJNA855894 | 17696 | 361 | 2.881944 | 10.40381784 | Agaricomycetes | 155619 | Fungi | Fungi | 599 | 9.749999999999995e-167 | NTclustered | gi|1194457656|gb|KX457680.1| | 5331 | g17574 | i0 | 96.676 | 100 | 361 | 11 | 100 | 1 | 1 | 361 | 904 | 545 | Bjerkandera adusta strain EG40 18S ribosomal RNA gene, partial sequence | blastn | 36100 | 604 | 0.991721854304636 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Bjerkandera | Bjerkandera adusta |
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);;