contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJDB12578" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2256199 | 2256199 | PRJDB12578_S_NODE_90302_length_330_cov_1.957295_g67244_i0 | PRJDB12578 | 90302 | 330 | 1.957295 | 6.4590735 | Eukaryota | 2759 | Fungi | Fungi | 52.8 | 0.031 | NTclustered | gi|2468672681|ref|NC_072522.1| | 68777 | g67244 | i0 | 100 | 0.424242424242424 | 28 | 0 | 8 | 0 | 104 | 131 | 120654 | 120627 | Cyathus striatus mitochondrion, complete genome | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Cyathus | Cyathus striatus | |
| 2550654 | 2550654 | PRJDB12578_S_NODE_112143_length_259_cov_1.238095_g89085_i0 | PRJDB12578 | 112143 | 259 | 1.238095 | 3.20666605 | Wallemia ichthyophaga | 245174 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|685947557|ref|XM_009269856.1| | 1299270 | g89085 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 173 | 200 | 1747 | 1720 | Wallemia ichthyophaga EXF-994 Polarized growth protein rax2 (J056_004666), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia ichthyophaga | |
| 3830320 | 3830320 | PRJDB12578_S_NODE_203304_length_165_cov_1.793103_g180246_i0 | PRJDB12578 | 203304 | 165 | 1.793103 | 2.95861995 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|599400019|ref|XM_007412100.1| | 747676 | g180246 | i0 | 96.97 | 0.2 | 33 | 0 | 19 | 1 | 31 | 62 | 298 | 330 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_72305), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 6382439 | 6382439 | PRJDB12578_S_NODE_202326_length_166_cov_0.880342_g179268_i0 | PRJDB12578 | 202326 | 166 | 0.880342 | 1.46136772 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 274 | 2.73e-69 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g179268 | i0 | 96.386 | 102.963855421687 | 166 | 6 | 100 | 0 | 1 | 166 | 3828 | 3993 | Cystobasidium laryngis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17092 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 11184118 | 11184118 | PRJDB12578_S_NODE_202669_length_166_cov_0.871795_g179611_i0 | PRJDB12578 | 202669 | 166 | 0.871795 | 1.4471797 | Cryptococcus | 5206 | Fungi | Fungi | 119 | 1.35e-22 | NTclustered | gi|1376263667|ref|XM_569545.2| | 214684 | g179611 | i0 | 85.841 | 2.31325301204819 | 113 | 14 | 67 | 2 | 55 | 166 | 188 | 299 | Cryptococcus neoformans var. neoformans JEC21 chaperone, putative (CNC02520), mRNA | blastn | 384 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus deneoformans | |
| 14029566 | 14029566 | PRJDB12578_S_NODE_130572_length_226_cov_1.152542_g107514_i0 | PRJDB12578 | 130572 | 226 | 1.152542 | 2.60474492 | Rhodotorula graminis | 29898 | Fungi | Fungi | 60.2 | 1.2e-4 | NTclustered | gi|1069919989|ref|XM_018415791.1| | 578459 | g107514 | i0 | 97.143 | 9 | 35 | 1 | 15 | 0 | 18 | 52 | 2853 | 2887 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_51352), partial mRNA | blastn | 2034 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 15302580 | 15302580 | PRJDB12578_S_NODE_104933_length_277_cov_1.127193_g81875_i0 | PRJDB12578 | 104933 | 277 | 1.127193 | 3.12232461 | Trametes versicolor | 5325 | Fungi | Fungi | 54.7 | 0.007 | NTclustered | gi|636615126|ref|XM_008040507.1| | 717944 | g81875 | i0 | 100 | 0.104693140794224 | 29 | 0 | 10 | 0 | 237 | 265 | 1261 | 1233 | Trametes versicolor FP-101664 SS1 uncharacterized protein (TRAVEDRAFT_167944), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 17558786 | 17558786 | PRJDB12578_S_NODE_63334_length_604_cov_2.041441_g40709_i0 | PRJDB12578 | 63334 | 604 | 2.041441 | 12.33030364 | Eukaryota | 2759 | Fungi | Fungi | 58.4 | 0.001 | NTclustered | gi|1859735555|gb|MT644873.1| | 5217 | g40709 | i0 | 100 | 6.60264900662252 | 31 | 0 | 5 | 0 | 574 | 604 | 3884 | 3914 | Tremella mesenterica isolate DM1159 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3988 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 17852817 | 17852817 | PRJDB12578_S_NODE_116035_length_251_cov_1.024752_g92977_i0 | PRJDB12578 | 116035 | 251 | 1.024752 | 2.57212752 | Clavaria fumosa | 264083 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2511645887|emb|OX637807.1| | 264083 | g92977 | i0 | 96.875 | 0.254980079681275 | 32 | 1 | 13 | 0 | 87 | 118 | 251537 | 251568 | Clavaria fumosa genome assembly, organelle: mitochondrion | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Clavariaceae | Clavaria | Clavaria fumosa |
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);;