contig_metadata
16 rows where bioproject = "PRJEB2368" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22891 | 22891 | PRJEB2368_P_NODE_14781_length_160_cov_2.894309_g14462_i0 | PRJEB2368 | 14781 | 160 | 2.894309 | 4.6308944 | Candida parapsilosis | 5480 | Fungi | Fungi | 296 | 5.55e-76 | NTclustered | gi|371925444|gb|JQ062882.1| | 5480 | g14462 | i0 | 100 | 51.1125 | 160 | 0 | 100 | 0 | 1 | 160 | 22416 | 22575 | Candida parapsilosis strain CBS 1954 mitochondrion, partial genome | blastn | 8178 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 986337 | 986337 | PRJEB2368_P_NODE_4061_length_392_cov_2.109859_g3749_i0 | PRJEB2368 | 4061 | 392 | 2.109859 | 8.27064728 | Microsporidium | 144516 | Fungi | Fungi | 436 | 8.859999999999998e-118 | NTclustered | gi|1031418200|gb|KU302783.1| | 1850262 | g3749 | i0 | 85.888 | 83.3341836734694 | 411 | 36 | 99 | 15 | 3 | 392 | 566 | 157 | Microsporidia sp. A1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 32667 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidia sp. A1 | |||||
| 1297113 | 1297113 | PRJEB2368_P_NODE_422_length_1274_cov_5.903800_g272_i1 | PRJEB2368 | 422 | 1274 | 5.9038 | 75.214412 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 503 | 2.99e-137 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g272 | i1 | 85.773 | 30.7103610675039 | 485 | 57 | 89 | 11 | 187 | 665 | 2533 | 3011 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 39125 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 5125347 | 5125347 | PRJEB2368_P_NODE_9265_length_287_cov_1.436000_g8947_i0 | PRJEB2368 | 9265 | 287 | 1.436 | 4.12132 | Malassezia globosa | 76773 | Fungi | Fungi | 141 | 5.510000000000001e-29 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8947 | i0 | 100 | 4.79442508710801 | 76 | 0 | 53 | 0 | 212 | 287 | 3859 | 3784 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1376 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 6089477 | 6089477 | PRJEB2368_P_NODE_9745_length_287_cov_1.364000_g9427_i0 | PRJEB2368 | 9745 | 287 | 1.364 | 3.91468 | Ramalina | 56479 | Fungi | Fungi | 52.8 | 0.027 | NTclustered | gi|1069417254|gb|KU496963.1| | 86786 | g9427 | i0 | 100 | 0.195121951219512 | 28 | 0 | 10 | 0 | 20 | 47 | 463 | 490 | Ramalina americana voucher TL022-D04 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Lecanorales | Ramalinaceae | Ramalina | Ramalina americana | |
| 12776486 | 12776486 | PRJEB2368_P_NODE_3051_length_473_cov_2.048165_g2751_i0 | PRJEB2368 | 3051 | 473 | 2.048165 | 9.68782045 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 339 | 3.1499999999999997e-88 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2751 | i0 | 82.836 | 18.3298097251586 | 402 | 46 | 81 | 12 | 86 | 467 | 1848 | 2246 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8670 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15014250 | 15014250 | PRJEB2368_P_NODE_552_length_1142_cov_3.085973_g419_i0 | PRJEB2368 | 552 | 1142 | 3.085973 | 35.24181166 | Ecytonucleospora | 3078583 | Fungi | Fungi | 1003 | 0 | NTclustered | gi|2523179590|gb|OR168077.1| | 646526 | g419 | i0 | 91.565 | 71.8809106830123 | 735 | 50 | 83 | 10 | 169 | 895 | 248 | 978 | Enterocytozoon hepatopenaei strain SHFX4 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 82088 | 1003 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 27910948 | 27910948 | PRJEB2368_P_NODE_10425_length_287_cov_1.216000_g10107_i0 | PRJEB2368 | 10425 | 287 | 1.216 | 3.48992 | Enterocytozoonidae | 27970 | Fungi | Fungi | 43.1 | 0.0276 | NR | OQS54364.1 | 646526 | g10107 | i0 | 83.3 | 0.501742160278746 | 24 | 4 | 25.1 | 0 | 284 | 213 | 13 | 36 | OQS54364.1 Rpl17 [Enterocytozoon hepatopenaei] | diamond | 144 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28517606 | 28517606 | PRJEB2368_P_NODE_12827_length_194_cov_0.993631_g12508_i0 | PRJEB2368 | 12827 | 194 | 0.993631 | 1.92764414 | Tulasnella sp. 4 | 1905295 | Fungi | Fungi | 78.2 | 4.99e-15 | NR | KAG8906897.1 | 2600223 | g12508 | i0 | 66.7 | 4.5 | 57 | 19 | 88.1 | 0 | 24 | 194 | 281 | 337 | KAG8906897.1 hypothetical protein FRB99_005779 [Tulasnella sp. 403] | diamond | 873 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 403 | |
| 28864774 | 28864774 | PRJEB2368_P_NODE_12868_length_192_cov_2.445161_g12549_i0 | PRJEB2368 | 12868 | 192 | 2.445161 | 4.69470912 | Enterospora canceri | 1081671 | Fungi | Fungi | 102 | 2.6e-26 | NR | ORD94087.1 | 1081671 | g12549 | i0 | 74.6 | 0.984375 | 63 | 16 | 98.4 | 0 | 3 | 191 | 12 | 74 | ORD94087.1 RL30 [Enterospora canceri] | diamond | 189 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 28991454 | 28991454 | PRJEB2368_P_NODE_7748_length_287_cov_1.884000_g7430_i0 | PRJEB2368 | 7748 | 287 | 1.884 | 5.40708 | Spraguea lophii 42_11 | 51541 | Fungi | Fungi | 60.1 | 5.01e-8 | NR | EPR79078.1 | 1358809 | g7430 | i0 | 86.2 | 0.303135888501742 | 29 | 4 | 30.3 | 0 | 201 | 287 | 167 | 195 | EPR79078.1 Glutaminyl-tRNA synthetase [Spraguea lophii 42_110] | diamond | 87 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 29590685 | 29590685 | PRJEB2368_P_NODE_1210_length_790_cov_3.034529_g993_i0 | PRJEB2368 | 1210 | 790 | 3.034529 | 23.9727791 | Diploschistes diacapsis | 150877 | Fungi | Fungi | 64.7 | 7.95e-8 | NR | KAI4142025.1 | 150877 | g993 | i0 | 31.6 | 1.51518987341772 | 136 | 85 | 51.3 | 3 | 782 | 378 | 98 | 226 | KAI4142025.1 MAG: hypothetical protein LQ340_007455 [Diploschistes diacapsis] | diamond | 1197 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Diploschistes | Diploschistes diacapsis | |
| 29717065 | 29717065 | PRJEB2368_P_NODE_9690_length_287_cov_1.372000_g9372_i0 | PRJEB2368 | 9690 | 287 | 1.372 | 3.93764 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 45.4 | 0.00655 | NR | EED43820.1 | 481877 | g9372 | i0 | 84 | 0.261324041811847 | 25 | 4 | 26.1 | 0 | 286 | 212 | 145 | 169 | EED43820.1 hypothetical membrane spanning protein [Enterocytozoon bieneusi H348] | diamond | 75 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 30633299 | 30633299 | PRJEB2368_P_NODE_8173_length_287_cov_1.708000_g7855_i0 | PRJEB2368 | 8173 | 287 | 1.708 | 4.90196 | Enterospora canceri | 1081671 | Fungi | Fungi | 50.8 | 9.15e-5 | NR | ORD95157.1 | 1081671 | g7855 | i0 | 80 | 0.261324041811847 | 25 | 5 | 26.1 | 0 | 1 | 75 | 433 | 457 | ORD95157.1 putative isoleucine--tRNA ligase, cytoplasmic [Enterospora canceri] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 31455316 | 31455316 | PRJEB2368_P_NODE_14296_length_166_cov_1.713178_g13977_i0 | PRJEB2368 | 14296 | 166 | 1.713178 | 2.84387548 | Pyronema omphalodes CBS 1 | 337075 | Fungi | Fungi | 92.8 | 2.33e-20 | NR | CCX05784.1 | 1076935 | g13977 | i0 | 71.2 | 4.69879518072289 | 52 | 15 | 94 | 0 | 1 | 156 | 242 | 293 | CCX05784.1 Similar to Exoglucanase 1; acc. no. P13860 [Pyronema omphalodes CBS 100304] | diamond | 780 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 32562795 | 32562795 | PRJEB2368_P_NODE_7859_length_287_cov_1.832000_g7541_i0 | PRJEB2368 | 7859 | 287 | 1.832 | 5.25784 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 50.8 | 1.74e-5 | NR | EED44590.1 | 481877 | g7541 | i0 | 92 | 0.261324041811847 | 25 | 2 | 26.1 | 0 | 286 | 212 | 20 | 44 | EED44590.1 SSU ribosomal protein S17E [Enterocytozoon bieneusi H348] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi |
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);;