contig_metadata
13 rows where bioproject = "PRJDB12578", tax_clade = "Opisthokonta" 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 | |
| 28548521 | 28548521 | PRJDB12578_S_NODE_132807_length_223_cov_0.896552_g109749_i0 | PRJDB12578 | 132807 | 223 | 0.896552 | 1.99931096 | Paxillus ammoniavirescens | 1132860 | Fungi | Fungi | 42 | 0.0254 | NR | KAF8843422.1 | 1132860 | g109749 | i0 | 25 | 0.860986547085202 | 64 | 48 | 86.1 | 0 | 192 | 1 | 70 | 133 | KAF8843422.1 hypothetical protein BDN67DRAFT_964545 [Paxillus ammoniavirescens] | diamond | 192 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Paxillaceae | Paxillus | Paxillus ammoniavirescens | |
| 30790658 | 30790658 | PRJDB12578_S_NODE_174254_length_182_cov_1.526316_g151196_i0 | PRJDB12578 | 174254 | 182 | 1.526316 | 2.77789512 | Austropuccinia psidii | 181123 | Fungi | Fungi | 43.9 | 0.00641 | NR | MBW0511442.1 | 1389203 | g151196 | i0 | 44.9 | 0.807692307692308 | 49 | 25 | 77.5 | 1 | 27 | 167 | 359 | 407 | MBW0511442.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 147 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 31296237 | 31296237 | PRJDB12578_S_NODE_144335_length_209_cov_1.281250_g121277_i0 | PRJDB12578 | 144335 | 209 | 1.28125 | 2.6778125 | Sparassis crispa | 139825 | Fungi | Fungi | 55.1 | 1.08e-6 | NR | XP_027620327.1 | 139825 | g121277 | i0 | 58.5 | 2.35406698564593 | 41 | 17 | 58.9 | 0 | 123 | 1 | 1347 | 1387 | XP_027620327.1 hypothetical protein SCP_1600760 [Sparassis crispa] | diamond | 492 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Sparassidaceae | Sparassis | Sparassis crispa | |
| 32213783 | 32213783 | PRJDB12578_S_NODE_158758_length_195_cov_1.068493_g135700_i0 | PRJDB12578 | 158758 | 195 | 1.068493 | 2.08356135 | Sphaerobolus stellatus SS14 | 990650 | Fungi | Fungi | 43.1 | 0.0145 | NR | KIJ25936.1 | 990650 | g135700 | i0 | 43.9 | 0.630769230769231 | 41 | 23 | 63.1 | 0 | 135 | 13 | 278 | 318 | KIJ25936.1 hypothetical protein M422DRAFT_273077 [Sphaerobolus stellatus SS14] | diamond | 123 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Sphaerobolaceae | Sphaerobolus | Sphaerobolus stellatus |
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);;