contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1146366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2841116 | 2841116 | PRJNA1146366_S_NODE_1243_length_303_cov_2.673913_g1240_i0 | PRJNA1146366 | 1243 | 303 | 2.673913 | 8.10195639 | Malassezia restricta | 76775 | Fungi | Fungi | 484 | 2.3499999999999998e-132 | NTclustered | gi|1546632162|ref|XM_027627741.1| | 76775 | g1240 | i0 | 99.254 | 0.884488448844885 | 268 | 2 | 88 | 0 | 36 | 303 | 2337 | 2070 | Malassezia restricta heat shock 70kDa protein 4 (MRET_1114), partial mRNA | blastn | 268 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 2841130 | 2841130 | PRJNA1146366_S_NODE_2323_length_247_cov_0.896552_g2320_i0 | PRJNA1146366 | 2323 | 247 | 0.896552 | 2.21448344 | Malassezia globosa | 76773 | Fungi | Fungi | 446 | 8.759999999999998e-121 | NTclustered | gi|164662081|ref|XM_001732111.1| | 425265 | g2320 | i0 | 99.19 | 3.64372469635628 | 247 | 2 | 100 | 0 | 1 | 247 | 175 | 421 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0756), partial mRNA | blastn | 900 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 4117293 | 4117293 | PRJNA1146366_S_NODE_1964_length_262_cov_2.174603_g1961_i0 | PRJNA1146366 | 1964 | 262 | 2.174603 | 5.69745986 | Malassezia globosa | 76773 | Fungi | Fungi | 392 | 1.2399999999999999e-104 | NTclustered | gi|164655490|ref|XM_001728823.1| | 425265 | g1961 | i0 | 99.083 | 0.83206106870229 | 218 | 2 | 83 | 0 | 45 | 262 | 555 | 338 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4042), partial mRNA | blastn | 218 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 6668184 | 6668184 | PRJNA1146366_S_NODE_1306_length_299_cov_2.345133_g1303_i0 | PRJNA1146366 | 1306 | 299 | 2.345133 | 7.01194767 | Malassezia globosa | 76773 | Fungi | Fungi | 261 | 4.24e-65 | NTclustered | gi|164657351|ref|XM_001729750.1| | 425265 | g1303 | i0 | 99.306 | 0.481605351170569 | 144 | 1 | 48 | 0 | 156 | 299 | 447 | 304 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2788), partial mRNA | blastn | 144 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 10493961 | 10493961 | PRJNA1146366_S_NODE_1309_length_299_cov_1.433628_g1306_i0 | PRJNA1146366 | 1309 | 299 | 1.433628 | 4.28654772 | Malassezia restricta | 76775 | Fungi | Fungi | 342 | 1.4699999999999999e-89 | NTclustered | gi|1546635657|ref|XM_027629471.1| | 76775 | g1306 | i0 | 100 | 0.618729096989967 | 185 | 0 | 62 | 0 | 115 | 299 | 1134 | 950 | Malassezia restricta verprolin, proline-rich actin-associated protein (MRET_2844), partial mRNA | blastn | 185 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11768964 | 11768964 | PRJNA1146366_S_NODE_1210_length_306_cov_1.261803_g1207_i0 | PRJNA1146366 | 1210 | 306 | 1.261803 | 3.86111718 | Malassezia globosa | 76773 | Fungi | Fungi | 206 | 2.0699999999999997e-48 | NTclustered | gi|164656478|ref|XM_001729315.1| | 425265 | g1207 | i0 | 100 | 0.457516339869281 | 111 | 0 | 36 | 0 | 1 | 111 | 2419 | 2529 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3402), partial mRNA | blastn | 140 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 13043980 | 13043980 | PRJNA1146366_S_NODE_2231_length_250_cov_2.627119_g2228_i0 | PRJNA1146366 | 2231 | 250 | 2.627119 | 6.5677975 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 3.1999999999999986e-120 | NTclustered | gi|1546634082|ref|XM_027628701.1| | 76775 | g2228 | i0 | 99.187 | 0.984 | 246 | 2 | 98 | 0 | 5 | 250 | 1243 | 998 | Malassezia restricta uncharacterized protein (MRET_2074), partial mRNA | blastn | 246 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14319222 | 14319222 | PRJNA1146366_S_NODE_552_length_378_cov_2.557377_g549_i0 | PRJNA1146366 | 552 | 378 | 2.557377 | 9.66688506 | Malassezia globosa | 76773 | Fungi | Fungi | 302 | 3.24e-77 | NTclustered | gi|164655482|ref|XM_001728819.1| | 425265 | g549 | i0 | 97.714 | 0.462962962962963 | 175 | 4 | 46 | 0 | 1 | 175 | 948 | 1122 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4038), partial mRNA | blastn | 175 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16867414 | 16867414 | PRJNA1146366_S_NODE_1094_length_315_cov_2.776860_g1091_i0 | PRJNA1146366 | 1094 | 315 | 2.77686 | 8.747109 | Malassezia restricta | 76775 | Fungi | Fungi | 348 | 3.3600000000000004e-91 | NTclustered | gi|1546631760|ref|XM_027627540.1| | 76775 | g1091 | i0 | 99.476 | 1.99365079365079 | 191 | 1 | 61 | 0 | 125 | 315 | 603 | 413 | Malassezia restricta imidazoleglycerol-phosphate dehydratase (MRET_0913), partial mRNA | blastn | 628 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18142039 | 18142039 | PRJNA1146366_S_NODE_815_length_341_cov_2.623134_g812_i0 | PRJNA1146366 | 815 | 341 | 2.623134 | 8.94488694 | Malassezia globosa | 76773 | Fungi | Fungi | 505 | 2.0599999999999996e-138 | NTclustered | gi|164655011|ref|XM_001728586.1| | 425265 | g812 | i0 | 94.242 | 2.90615835777126 | 330 | 19 | 97 | 0 | 1 | 330 | 739 | 1068 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4237), partial mRNA | blastn | 991 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 18142041 | 18142041 | PRJNA1146366_S_NODE_935_length_330_cov_1.750973_g932_i0 | PRJNA1146366 | 935 | 330 | 1.750973 | 5.7782109 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 4.36e-125 | NTclustered | gi|1546637121|ref|XM_027630203.1| | 76775 | g932 | i0 | 100 | 68.1 | 249 | 0 | 75 | 0 | 1 | 249 | 403 | 651 | Malassezia restricta GTP-binding nuclear protein Ran (MRET_3576), partial mRNA | blastn | 22473 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19416377 | 19416377 | PRJNA1146366_S_NODE_2296_length_248_cov_1.760000_g2293_i0 | PRJNA1146366 | 2296 | 248 | 1.76 | 4.3648 | Malassezia restricta | 76775 | Fungi | Fungi | 401 | 1.9299999999999994e-107 | NTclustered | gi|1546638651|ref|XM_027630967.1| | 76775 | g2293 | i0 | 98.673 | 0.911290322580645 | 226 | 3 | 91 | 0 | 23 | 248 | 452 | 227 | Malassezia restricta mitochondrial import inner membrane translocase subunit TIM16 (MRET_4340), partial mRNA | blastn | 226 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20691802 | 20691802 | PRJNA1146366_S_NODE_2077_length_256_cov_1.693989_g2074_i0 | PRJNA1146366 | 2077 | 256 | 1.693989 | 4.33661184 | Malassezia restricta | 76775 | Fungi | Fungi | 150 | 8.019999999999999e-32 | NTclustered | gi|1546637061|ref|XM_027630173.1| | 76775 | g2074 | i0 | 100 | 0.31640625 | 81 | 0 | 32 | 0 | 176 | 256 | 444 | 364 | Malassezia restricta large subunit ribosomal protein L27Ae (MRET_3546), partial mRNA | blastn | 81 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20691809 | 20691809 | PRJNA1146366_S_NODE_2477_length_242_cov_0.923077_g2474_i0 | PRJNA1146366 | 2477 | 242 | 0.923077 | 2.23384634 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|1546638345|ref|XM_027630814.1| | 76775 | g2474 | i0 | 100 | 38.9090909090909 | 242 | 0 | 100 | 0 | 1 | 242 | 115 | 356 | Malassezia restricta histone H2A (MRET_4187), partial mRNA | blastn | 9416 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20691815 | 20691815 | PRJNA1146366_S_NODE_717_length_354_cov_1.711744_g714_i0 | PRJNA1146366 | 717 | 354 | 1.711744 | 6.05957376 | Malassezia restricta | 76775 | Fungi | Fungi | 544 | 4.53e-150 | NTclustered | gi|1546631938|ref|XM_027627629.1| | 76775 | g714 | i0 | 99.333 | 2.5 | 300 | 2 | 85 | 0 | 55 | 354 | 1122 | 823 | Malassezia restricta isocitrate dehydrogenase (NAD+) IDH1 (MRET_1002), partial mRNA | blastn | 885 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21967141 | 21967141 | PRJNA1146366_S_NODE_1538_length_284_cov_1.947867_g1535_i0 | PRJNA1146366 | 1538 | 284 | 1.947867 | 5.53194228 | Malassezia globosa | 76773 | Fungi | Fungi | 346 | 1.07e-90 | NTclustered | gi|164655173|ref|XM_001728666.1| | 425265 | g1535 | i0 | 98.964 | 1.35915492957746 | 193 | 2 | 68 | 0 | 1 | 193 | 1170 | 1362 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4197), partial mRNA | blastn | 386 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 21967145 | 21967145 | PRJNA1146366_S_NODE_1798_length_270_cov_1.497462_g1795_i0 | PRJNA1146366 | 1798 | 270 | 1.497462 | 4.0431474 | Malassezia globosa | 76773 | Fungi | Fungi | 167 | 8.47e-37 | NTclustered | gi|164657433|ref|XM_001729791.1| | 425265 | g1795 | i0 | 98.925 | 0.344444444444444 | 93 | 1 | 34 | 0 | 1 | 93 | 352 | 444 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2829), partial mRNA | blastn | 93 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 23242682 | 23242682 | PRJNA1146366_S_NODE_959_length_328_cov_1.529412_g956_i0 | PRJNA1146366 | 959 | 328 | 1.529412 | 5.01647136 | Malassezia globosa | 76773 | Fungi | Fungi | 601 | 2.4399999999999998e-167 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g956 | i0 | 99.695 | 35.9512195121951 | 328 | 1 | 100 | 0 | 1 | 328 | 1303 | 1630 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 11792 | 601 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24516226 | 24516226 | PRJNA1146366_S_NODE_740_length_352_cov_1.677419_g737_i0 | PRJNA1146366 | 740 | 352 | 1.677419 | 5.90451488 | Malassezia restricta | 76775 | Fungi | Fungi | 387 | 8.03e-103 | NTclustered | gi|1546633170|ref|XM_027628245.1| | 76775 | g737 | i0 | 98.624 | 1.23863636363636 | 218 | 3 | 62 | 0 | 1 | 218 | 920 | 1137 | Malassezia restricta cathepsin D (MRET_1618), partial mRNA | blastn | 436 | 387 | 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);;