contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1202086 | 1202086 | PRJNA753704_P_NODE_8921_length_391_cov_7.122642_g8560_i0 | PRJNA753704 | 8921 | 391 | 7.122642 | 27.84953022 | root | 1 | Root_unresolved | Root_unresolved | 723 | 0 | NTclustered | gi|1546635596|ref|XR_003525368.1| | 76775 | g8560 | i0 | 100 | 100 | 391 | 0 | 100 | 0 | 1 | 391 | 1135 | 745 | Malassezia restricta 18S ribosomal RNA (MRET_r0002), rRNA | blastn | 39100 | 723 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5834703 | 5834703 | PRJNA753704_P_NODE_26085_length_247_cov_0.896552_g25724_i0 | PRJNA753704 | 26085 | 247 | 0.896552 | 2.21448344 | Malassezia restricta | 76775 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|1546631898|ref|XM_027627609.1| | 76775 | g25724 | i0 | 100 | 1 | 247 | 0 | 100 | 0 | 1 | 247 | 2171 | 1925 | Malassezia restricta phospholipase D1/2 (MRET_0982), partial mRNA | blastn | 247 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7109840 | 7109840 | PRJNA753704_P_NODE_28226_length_242_cov_1.627219_g27865_i0 | PRJNA753704 | 28226 | 242 | 1.627219 | 3.93786998 | Malassezia restricta | 76775 | Fungi | Fungi | 403 | 5.22e-108 | NTclustered | gi|1546638285|ref|XM_027630784.1| | 76775 | g27865 | i0 | 96.694 | 1 | 242 | 8 | 100 | 0 | 1 | 242 | 2852 | 3093 | Malassezia restricta elongator complex protein 1 (MRET_4157), partial mRNA | blastn | 242 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10935103 | 10935103 | PRJNA753704_P_NODE_23969_length_252_cov_0.871508_g23608_i0 | PRJNA753704 | 23969 | 252 | 0.871508 | 2.19620016 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 196 | 9.98e-46 | NTclustered | gi|2669745777|ref|XM_062771596.1| | 143232 | g23608 | i0 | 92.701 | 1.61507936507937 | 137 | 9 | 54 | 1 | 111 | 247 | 987 | 852 | Vanrija pseudolonga Serine racemase (SRR), partial mRNA | blastn | 407 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 11405862 | 11405862 | PRJNA753704_P_NODE_23129_length_254_cov_2.585635_g22768_i0 | PRJNA753704 | 23129 | 254 | 2.585635 | 6.5675129 | Fungi | 4751 | Fungi | Fungi | 470 | 5.37e-128 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g22768 | i0 | 100 | 99.9606299212598 | 254 | 0 | 100 | 0 | 1 | 254 | 43 | 296 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 25390 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13484941 | 13484941 | PRJNA753704_P_NODE_31491_length_197_cov_6.669355_g31130_i0 | PRJNA753704 | 31491 | 197 | 6.669355 | 13.13862935 | Malassezia restricta | 76775 | Fungi | Fungi | 333 | 5.44e-87 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g31130 | i0 | 97.449 | 33.6192893401015 | 196 | 4 | 99 | 1 | 1 | 196 | 1675 | 1869 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 6623 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17309173 | 17309173 | PRJNA753704_P_NODE_21874_length_261_cov_1.659574_g21513_i0 | PRJNA753704 | 21874 | 261 | 1.659574 | 4.33148814 | Malassezia restricta | 76775 | Fungi | Fungi | 472 | 1.54e-128 | NTclustered | gi|1546638015|ref|XM_027630649.1| | 76775 | g21513 | i0 | 99.234 | 1 | 261 | 2 | 100 | 0 | 1 | 261 | 1137 | 1397 | Malassezia restricta conserved oligomeric golgi complex subunit 5 (MRET_4022), partial mRNA | blastn | 261 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17309256 | 17309256 | PRJNA753704_P_NODE_27834_length_243_cov_0.917647_g27473_i0 | PRJNA753704 | 27834 | 243 | 0.917647 | 2.22988221 | Malassezia restricta | 76775 | Fungi | Fungi | 339 | 1.4999999999999997e-88 | NTclustered | gi|1546635446|ref|XM_027629382.1| | 76775 | g27473 | i0 | 98.942 | 0.777777777777778 | 189 | 2 | 78 | 0 | 2 | 190 | 189 | 1 | Malassezia restricta diacylglycerol kinase catalytic domain protein (MRET_2755), partial mRNA | blastn | 189 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17309271 | 17309271 | PRJNA753704_P_NODE_28794_length_240_cov_2.131737_g28433_i0 | PRJNA753704 | 28794 | 240 | 2.131737 | 5.1161688 | Panaeolus antillarum | 1033290 | Fungi | Fungi | 132 | 2.7e-26 | NTclustered | gi|2645094623|gb|OR085177.1| | 1033290 | g28433 | i0 | 81.988 | 62.3708333333333 | 161 | 23 | 66 | 4 | 54 | 211 | 884 | 727 | Panaeolus antillarum voucher BR5020167127933 translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 14969 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Galeropsidaceae | Panaeolus | Panaeolus antillarum | |
| 19053848 | 19053848 | PRJNA753704_P_NODE_30735_length_213_cov_6.814286_g30374_i0 | PRJNA753704 | 30735 | 213 | 6.814286 | 14.51442918 | Eukaryota | 2759 | Fungi | Fungi | 394 | 2.7e-105 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g30374 | i0 | 100 | 100.549295774648 | 213 | 0 | 100 | 0 | 1 | 213 | 1686 | 1474 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 21417 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19857965 | 19857965 | PRJNA753704_P_NODE_12636_length_334_cov_4.318008_g12275_i0 | PRJNA753704 | 12636 | 334 | 4.318008 | 14.42214672 | Malassezia restricta | 76775 | Fungi | Fungi | 612 | 1.15e-170 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12275 | i0 | 100 | 84.5119760479042 | 331 | 0 | 99 | 0 | 4 | 334 | 3303 | 2973 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 28227 | 612 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19858125 | 19858125 | PRJNA753704_P_NODE_26136_length_247_cov_0.896552_g25775_i0 | PRJNA753704 | 26136 | 247 | 0.896552 | 2.21448344 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 351 | 1.97e-92 | NTclustered | gi|1423584644|ref|XM_025742999.1| | 58919 | g25775 | i0 | 92.308 | 1 | 247 | 19 | 100 | 0 | 1 | 247 | 5507 | 5261 | Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_331378), mRNA | blastn | 247 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 25428647 | 25428647 | PRJNA753704_P_NODE_16320_length_298_cov_1.284444_g15959_i0 | PRJNA753704 | 16320 | 298 | 1.284444 | 3.82764312 | Malassezia | 55193 | Fungi | Fungi | 551 | 2.239999999999999e-152 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g15959 | i0 | 100 | 41.8691275167785 | 298 | 0 | 100 | 0 | 1 | 298 | 1261 | 964 | Malassezia restricta mitochondrion, complete genome | blastn | 12477 | 551 | 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);;