contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1134759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5387420 | 5387420 | PRJNA1134759_P_NODE_53485_length_246_cov_0.901734_g53309_i0 | PRJNA1134759 | 53485 | 246 | 0.901734 | 2.21826564 | Malassezia globosa | 76773 | Fungi | Fungi | 427 | 3.16e-115 | NTclustered | gi|164659903|ref|XM_001731024.1| | 425265 | g53309 | i0 | 97.967 | 1.80081300813008 | 246 | 5 | 100 | 0 | 1 | 246 | 707 | 952 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2075), partial mRNA | blastn | 443 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7937238 | 7937238 | PRJNA1134759_P_NODE_52127_length_248_cov_0.891429_g51951_i0 | PRJNA1134759 | 52127 | 248 | 0.891429 | 2.21074392 | Malassezia restricta | 76775 | Fungi | Fungi | 364 | 2.539999999999999e-96 | NTclustered | gi|1546630023|ref|XM_027626672.1| | 76775 | g51951 | i0 | 93.145 | 1 | 248 | 17 | 100 | 0 | 1 | 248 | 3254 | 3007 | Malassezia restricta protein transport protein SEC31 (MRET_0045), partial mRNA | blastn | 248 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7937249 | 7937249 | PRJNA1134759_P_NODE_53627_length_246_cov_0.901734_g53451_i0 | PRJNA1134759 | 53627 | 246 | 0.901734 | 2.21826564 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|1546636887|ref|XM_027630086.1| | 76775 | g53451 | i0 | 100 | 98.9471544715447 | 246 | 0 | 100 | 0 | 1 | 246 | 983 | 1228 | Malassezia restricta F-type H+-transporting ATPase subunit alpha (MRET_3459), partial mRNA | blastn | 24341 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9212222 | 9212222 | PRJNA1134759_P_NODE_51528_length_249_cov_0.886364_g51352_i0 | PRJNA1134759 | 51528 | 249 | 0.886364 | 2.20704636 | Malassezia restricta | 76775 | Fungi | Fungi | 411 | 3.2299999999999996e-110 | NTclustered | gi|1546633074|ref|XM_027628197.1| | 76775 | g51352 | i0 | 99.556 | 1.04417670682731 | 225 | 1 | 100 | 0 | 25 | 249 | 212 | 436 | Malassezia restricta serine/threonine-protein kinase SRPK3 (MRET_1570), partial mRNA | blastn | 260 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11762789 | 11762789 | PRJNA1134759_P_NODE_50150_length_251_cov_0.876404_g49974_i0 | PRJNA1134759 | 50150 | 251 | 0.876404 | 2.19977404 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 453 | 5.34e-123 | NTclustered | gi|1005506993|gb|KU867873.1| | 1514897 | g49974 | i0 | 99.203 | 99.6772908366534 | 251 | 2 | 100 | 0 | 1 | 251 | 51 | 301 | Malassezia arunalokei strain NCCPF127127 translation elongation factor 1-alpha (tef1) gene, partial cds | blastn | 25019 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 15587112 | 15587112 | PRJNA1134759_P_NODE_54293_length_245_cov_0.906977_g54117_i0 | PRJNA1134759 | 54293 | 245 | 0.906977 | 2.22209365 | Malassezia restricta | 76775 | Fungi | Fungi | 387 | 5.34e-103 | NTclustered | gi|1546638495|ref|XM_027630889.1| | 76775 | g54117 | i0 | 95.102 | 1 | 245 | 12 | 100 | 0 | 1 | 245 | 58 | 302 | Malassezia restricta protein involved in negative regulation of iron regulon transcription (MRET_4262), partial mRNA | blastn | 245 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16861324 | 16861324 | PRJNA1134759_P_NODE_41674_length_269_cov_1.193878_g41498_i0 | PRJNA1134759 | 41674 | 269 | 1.193878 | 3.21153182 | Malassezia globosa | 76773 | Fungi | Fungi | 267 | 8.08e-67 | NTclustered | gi|164661676|ref|XM_001731909.1| | 425265 | g41498 | i0 | 98.667 | 0.951672862453532 | 150 | 2 | 94 | 0 | 120 | 269 | 787 | 638 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_1229), partial mRNA | blastn | 256 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 19410113 | 19410113 | PRJNA1134759_P_NODE_54216_length_245_cov_0.906977_g54040_i0 | PRJNA1134759 | 54216 | 245 | 0.906977 | 2.22209365 | Peniophora lycii | 154539 | Fungi | Fungi | 398 | 2.47e-106 | NTclustered | gi|2192917331|ref|NC_060425.1| | 154539 | g54040 | i0 | 95.918 | 33.6448979591837 | 245 | 10 | 100 | 0 | 1 | 245 | 21203 | 20959 | Peniophora lycii mitochondrion, complete sequence | blastn | 8243 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora lycii | |
| 21960989 | 21960989 | PRJNA1134759_P_NODE_50798_length_250_cov_0.881356_g50622_i0 | PRJNA1134759 | 50798 | 250 | 0.881356 | 2.20339 | Malassezia restricta | 76775 | Fungi | Fungi | 457 | 4.1099999999999985e-124 | NTclustered | gi|1546631449|ref|XM_027627385.1| | 76775 | g50622 | i0 | 99.6 | 1.764 | 250 | 1 | 100 | 0 | 1 | 250 | 3892 | 4141 | Malassezia restricta phosphoribosylformylglycinamidine synthase (MRET_0758), partial mRNA | blastn | 441 | 457 | 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);;