contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA685060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1176003 | 1176003 | PRJNA685060_P_NODE_10701_length_287_cov_3.359813_g10611_i0 | PRJNA685060 | 10701 | 287 | 3.359813 | 9.64266331 | Opisthokonta | 33154 | Fungi | Fungi | 531 | 2.799999999999999e-146 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g10611 | i0 | 100 | 100.094076655052 | 287 | 0 | 100 | 0 | 1 | 287 | 519 | 233 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 28727 | 531 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 1942122 | 1942122 | PRJNA685060_P_NODE_15142_length_247_cov_0.885057_g15052_i0 | PRJNA685060 | 15142 | 247 | 0.885057 | 2.18609079 | Malassezia restricta | 76775 | Fungi | Fungi | 435 | 1.9e-117 | NTclustered | gi|1546637903|ref|XM_027630593.1| | 76775 | g15052 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 2445 | 2199 | Malassezia restricta phospholipid-translocating ATPase (MRET_3966), partial mRNA | blastn | 247 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3217011 | 3217011 | PRJNA685060_P_NODE_13563_length_251_cov_0.865169_g13473_i0 | PRJNA685060 | 13563 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 353 | 5.569999999999998e-93 | NTclustered | gi|1546630269|ref|XM_027626795.1| | 76775 | g13473 | i0 | 92.063 | 1.78486055776892 | 252 | 19 | 100 | 1 | 1 | 251 | 341 | 592 | Malassezia restricta centractin (MRET_0168), partial mRNA | blastn | 448 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4494032 | 4494032 | PRJNA685060_P_NODE_11584_length_275_cov_0.881188_g11494_i0 | PRJNA685060 | 11584 | 275 | 0.881188 | 2.423267 | Malassezia restricta | 76775 | Fungi | Fungi | 479 | 9.78e-131 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g11494 | i0 | 98.182 | 103.061818181818 | 275 | 4 | 100 | 1 | 1 | 275 | 1915 | 1642 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 28342 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13420162 | 13420162 | PRJNA685060_P_NODE_6151_length_386_cov_0.984026_g6061_i0 | PRJNA685060 | 6151 | 386 | 0.984026 | 3.79834036 | Malassezia restricta | 76775 | Fungi | Fungi | 641 | 1.72e-179 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g6061 | i0 | 96.658 | 106.813471502591 | 389 | 8 | 100 | 5 | 1 | 386 | 1501 | 1887 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 41230 | 641 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14695125 | 14695125 | PRJNA685060_P_NODE_16712_length_243_cov_0.905882_g16622_i0 | PRJNA685060 | 16712 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 431 | 2.4099999999999995e-116 | NTclustered | gi|1546636529|ref|XM_027629907.1| | 76775 | g16622 | i0 | 99.163 | 0.983539094650206 | 239 | 2 | 98 | 0 | 5 | 243 | 1 | 239 | Malassezia restricta protoheme IX farnesyltransferase, mitochondrial (MRET_3280), partial mRNA | blastn | 239 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17244174 | 17244174 | PRJNA685060_P_NODE_7714_length_343_cov_1.040741_g7624_i0 | PRJNA685060 | 7714 | 343 | 1.040741 | 3.56974163 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 58.4 | 6.97e-4 | NTclustered | gi|2669736302|ref|XM_062769985.1| | 143232 | g7624 | i0 | 97.059 | 0.551020408163265 | 34 | 1 | 10 | 0 | 170 | 203 | 591 | 624 | Vanrija pseudolonga uncharacterized protein (LOC62_02G003451), partial mRNA | blastn | 189 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 18518249 | 18518249 | PRJNA685060_P_NODE_17635_length_241_cov_0.916667_g17545_i0 | PRJNA685060 | 17635 | 241 | 0.916667 | 2.20916747 | Malassezia restricta | 76775 | Fungi | Fungi | 446 | 8.519999999999999e-121 | NTclustered | gi|1546634612|ref|XM_027628966.1| | 76775 | g17545 | i0 | 100 | 1 | 241 | 0 | 100 | 0 | 1 | 241 | 320 | 80 | Malassezia restricta KH domain protein (MRET_2339), partial mRNA | blastn | 241 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23618979 | 23618979 | PRJNA685060_P_NODE_11319_length_278_cov_1.878049_g11229_i0 | PRJNA685060 | 11319 | 278 | 1.878049 | 5.22097622 | Malassezia restricta | 76775 | Fungi | Fungi | 507 | 4.54e-139 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g11229 | i0 | 99.639 | 73.3597122302158 | 277 | 1 | 99 | 0 | 2 | 278 | 3285 | 3009 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 20394 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23618983 | 23618983 | PRJNA685060_P_NODE_1199_length_903_cov_9.006024_g1128_i0 | PRJNA685060 | 1199 | 903 | 9.006024 | 81.32439672 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 388 | 6.119999999999998e-103 | NTclustered | gi|1423587035|ref|XM_025743209.1| | 58919 | g1128 | i0 | 79.815 | 18.6744186046512 | 540 | 103 | 59 | 6 | 106 | 642 | 55 | 591 | Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA | blastn | 16863 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis |
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);;