contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904518 | 1904518 | PRJNA662254_P_NODE_60962_length_243_cov_0.905882_g60311_i0 | PRJNA662254 | 60962 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 383 | 6.84e-102 | NTclustered | gi|1546635192|ref|XM_027629255.1| | 76775 | g60311 | i0 | 95.062 | 1.16872427983539 | 243 | 12 | 100 | 0 | 1 | 243 | 3023 | 2781 | Malassezia restricta ATP-dependent RNA helicase DHX29 (MRET_2628), partial mRNA | blastn | 284 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4456173 | 4456173 | PRJNA662254_P_NODE_31284_length_297_cov_1.250000_g30633_i0 | PRJNA662254 | 31284 | 297 | 1.25 | 3.7125 | Suillus clintonianus | 1904413 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2033558000|ref|XM_041358223.1| | 1904413 | g30633 | i0 | 100 | 0.101010101010101 | 30 | 0 | 10 | 0 | 255 | 284 | 195 | 166 | Suillus clintonianus uncharacterized protein (DEU56DRAFT_919096), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus clintonianus | |
| 4456348 | 4456348 | PRJNA662254_P_NODE_65544_length_241_cov_0.916667_g64893_i0 | PRJNA662254 | 65544 | 241 | 0.916667 | 2.20916747 | Malassezia restricta | 76775 | Fungi | Fungi | 435 | 1.84e-117 | NTclustered | gi|1546631802|ref|XM_027627561.1| | 76775 | g64893 | i0 | 99.17 | 1 | 241 | 2 | 100 | 0 | 1 | 241 | 803 | 1043 | Malassezia restricta solute carrier family 39 (zinc transporter), member 1/2/3 (MRET_0934), partial mRNA | blastn | 241 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4990239 | 4990239 | PRJNA662254_P_NODE_5244_length_758_cov_1.788321_g4665_i0 | PRJNA662254 | 5244 | 758 | 1.788321 | 13.55547318 | Cryptococcus | 5206 | Fungi | Fungi | 62.1 | 1.26e-4 | NTclustered | gi|1376259644|ref|XM_024656270.1| | 214684 | g4665 | i0 | 97.222 | 1.84564643799472 | 36 | 1 | 5 | 0 | 378 | 413 | 1853 | 1818 | Cryptococcus neoformans var. neoformans JEC21 hypothetical protein (CNA04360), mRNA | blastn | 1399 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus deneoformans | |
| 14657189 | 14657189 | PRJNA662254_P_NODE_23812_length_338_cov_1.147170_g23161_i0 | PRJNA662254 | 23812 | 338 | 1.14717 | 3.8774346 | Malassezia restricta | 76775 | Fungi | Fungi | 614 | 3.2499999999999993e-171 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g23161 | i0 | 99.408 | 97.3550295857988 | 338 | 2 | 100 | 0 | 1 | 338 | 1865 | 1528 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 32906 | 614 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14657307 | 14657307 | PRJNA662254_P_NODE_55772_length_246_cov_0.890173_g55121_i0 | PRJNA662254 | 55772 | 246 | 0.890173 | 2.18982558 | Trametes versicolor | 5325 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|636618714|ref|XM_008042301.1| | 717944 | g55121 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 57 | 84 | 1968 | 1941 | Trametes versicolor FP-101664 SS1 actin-like ATPase domain-containing protein (TRAVEDRAFT_128065), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 15931082 | 15931082 | PRJNA662254_P_NODE_18653_length_379_cov_1.643791_g18002_i0 | PRJNA662254 | 18653 | 379 | 1.643791 | 6.22996789 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 231 | 4.3199999999999985e-56 | NTclustered | gi|630959971|ref|XM_007878203.1| | 1277687 | g18002 | i0 | 80.519 | 16.4775725593668 | 308 | 55 | 81 | 5 | 64 | 369 | 10 | 314 | Pseudozyma flocculosa PF-1 calmodulin (PFL1_00701), partial mRNA | blastn | 6245 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 19013490 | 19013490 | PRJNA662254_P_NODE_32855_length_290_cov_1.345622_g32204_i0 | PRJNA662254 | 32855 | 290 | 1.345622 | 3.9023038 | Basidiomycota | 5204 | Fungi | Fungi | 315 | 3.1e-81 | NTclustered | gi|2594587104|ref|XM_060264525.1| | 223818 | g32204 | i0 | 86.207 | 8.58965517241379 | 290 | 40 | 100 | 0 | 1 | 290 | 717 | 428 | Malassezia japonica cross-pathway control WD-repeat protein cpc2 (cpc2), partial mRNA | blastn | 2491 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 20288322 | 20288322 | PRJNA662254_P_NODE_66276_length_235_cov_2.376543_g65625_i0 | PRJNA662254 | 66276 | 235 | 2.376543 | 5.58487605 | Opisthokonta | 33154 | Fungi | Fungi | 93.5 | 1.24e-14 | NTclustered | gi|1557918162|ref|XM_027763834.1| | 139825 | g65625 | i0 | 88.312 | 1.58723404255319 | 77 | 9 | 33 | 0 | 120 | 196 | 181 | 257 | Sparassis crispa Histone H2B (SCP_1401270), partial mRNA | blastn | 373 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Sparassidaceae | Sparassis | Sparassis crispa | |
| 21030831 | 21030831 | PRJNA662254_P_NODE_41437_length_261_cov_1.228723_g40786_i0 | PRJNA662254 | 41437 | 261 | 1.228723 | 3.20696703 | Kockovaella imperatae | 4999 | Fungi | Fungi | 178 | 3.759999999999999e-40 | NTclustered | gi|1227123063|ref|XM_022013500.1| | 4999 | g40786 | i0 | 79.528 | 80.3563218390805 | 254 | 48 | 97 | 4 | 7 | 258 | 477 | 226 | Kockovaella imperatae putative cytoplasmic chaperone (BD324DRAFT_581403), partial mRNA | blastn | 20973 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 22305526 | 22305526 | PRJNA662254_P_NODE_27378_length_316_cov_2.185185_g26727_i0 | PRJNA662254 | 27378 | 316 | 2.185185 | 6.9051846 | Kwoniella europaea | 1247712 | Fungi | Fungi | 239 | 2.12e-58 | NTclustered | gi|2752984423|ref|XM_066225644.1| | 1423913 | g26727 | i0 | 81.188 | 76.1487341772152 | 303 | 52 | 95 | 5 | 2 | 301 | 91 | 391 | Kwoniella europaea PYCC6329 GTP-binding protein ypt1 (V865_001830), partial mRNA | blastn | 24063 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella europaea | |
| 25388416 | 25388416 | PRJNA662254_P_NODE_61420_length_243_cov_0.905882_g60769_i0 | PRJNA662254 | 61420 | 243 | 0.905882 | 2.20129326 | Agaricales | 5338 | Fungi | Fungi | 113 | 9.91e-21 | NTclustered | gi|1139717310|gb|KY432826.1| | 67700 | g60769 | i0 | 98.438 | 26.3374485596708 | 64 | 1 | 26 | 0 | 180 | 243 | 88 | 25 | Amanita citrina voucher NYBG:0007 28S ribosomal RNA gene, partial sequence | blastn | 6400 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita citrina |
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);;