contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283667 | 283667 | PRJNA1132896_P_NODE_7581_length_249_cov_0.875000_g7490_i0 | PRJNA1132896 | 7581 | 249 | 0.875 | 2.17875 | Ganoderma leucocontextum | 1566825 | Fungi | Fungi | 340 | 4.29e-89 | NTclustered | gi|2724480651|gb|PP467490.1| | 1566825 | g7490 | i0 | 91.6 | 106.570281124498 | 250 | 16 | 100 | 4 | 1 | 249 | 5859 | 6104 | Ganoderma leucocontextum strain H4 intergenic spacer 2, partial sequence; 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S small subunit ribosomal RNA gene, partial sequence | blastn | 26536 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma leucocontextum | |
| 2307095 | 2307095 | PRJNA1132896_P_NODE_1862_length_394_cov_2.149533_g1771_i0 | PRJNA1132896 | 1862 | 394 | 2.149533 | 8.46916002 | Ganoderma | 5314 | Fungi | Fungi | 660 | 0 | NTclustered | gi|560877746|ref|NC_022933.1| | 36075 | g1771 | i0 | 98.153 | 97.2258883248731 | 379 | 6 | 96 | 1 | 1 | 379 | 1140 | 1517 | Ganoderma sinense mitochondrion, complete genome | blastn | 38307 | 660 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma sinense | |
| 2307106 | 2307106 | PRJNA1132896_P_NODE_3862_length_290_cov_3.843318_g3771_i0 | PRJNA1132896 | 3862 | 290 | 3.843318 | 11.1456222 | Ganoderma | 5314 | Fungi | Fungi | 497 | 2.8699999999999993e-136 | NTclustered | gi|2724480650|gb|PP467489.1| | 5315 | g3771 | i0 | 97.586 | 104.351724137931 | 290 | 7 | 100 | 0 | 1 | 290 | 6454 | 6743 | Ganoderma lucidum strain Red Reishi No.6 intergenic spacer 2, partial sequence; 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, intergenic spacer 2, 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30262 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 2834314 | 2834314 | PRJNA1132896_P_NODE_7463_length_249_cov_0.875000_g7372_i0 | PRJNA1132896 | 7463 | 249 | 0.875 | 2.17875 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 147 | 1e-30 | NTclustered | gi|955499337|ref|XM_014803518.1| | 84753 | g7372 | i0 | 84.314 | 32.9799196787149 | 153 | 21 | 61 | 2 | 20 | 172 | 606 | 457 | Moesziomyces antarcticus secY protein (PAN0_002d1352), partial mRNA | blastn | 8212 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 3582269 | 3582269 | PRJNA1132896_P_NODE_4103_length_287_cov_2.144860_g4012_i0 | PRJNA1132896 | 4103 | 287 | 2.14486 | 6.1557482 | Opisthokonta | 33154 | Fungi | Fungi | 484 | 2.2099999999999994e-132 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g4012 | i0 | 99.623 | 89.8710801393728 | 265 | 1 | 92 | 0 | 1 | 265 | 417 | 681 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 25793 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3582285 | 3582285 | PRJNA1132896_P_NODE_663_length_635_cov_2.829181_g573_i0 | PRJNA1132896 | 663 | 635 | 2.829181 | 17.96529935 | Microporus | 158311 | Fungi | Fungi | 1162 | 0 | NTclustered | gi|2250415334|gb|ON715788.1| | 239211 | g573 | i0 | 99.685 | 104.028346456693 | 635 | 2 | 100 | 0 | 1 | 635 | 624 | 1258 | Microporus xanthopus strain N.L. Bougher NLB 1278 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 | 66058 | 1168 | 0.99486301369863 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Microporus | Microporus xanthopus | |
| 4110618 | 4110618 | PRJNA1132896_P_NODE_10044_length_241_cov_1.833333_g9953_i0 | PRJNA1132896 | 10044 | 241 | 1.833333 | 4.41833253 | Malassezia restricta | 76775 | Fungi | Fungi | 134 | 7.530000000000001e-27 | NTclustered | gi|1546635438|ref|XM_027629378.1| | 76775 | g9953 | i0 | 98.684 | 0.688796680497925 | 76 | 0 | 69 | 1 | 91 | 166 | 958 | 1032 | Malassezia restricta pre-mRNA-splicing factor 18 (MRET_2751), partial mRNA | blastn | 166 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4110641 | 4110641 | PRJNA1132896_P_NODE_4504_length_282_cov_1.330144_g4413_i0 | PRJNA1132896 | 4504 | 282 | 1.330144 | 3.75100608 | Trichosporon asahii | 82508 | Fungi | Fungi | 69.4 | 2.58e-7 | NTclustered | gi|930420314|ref|XM_014328955.1| | 1186058 | g4413 | i0 | 97.5 | 7.8794326241134804 | 40 | 1 | 14 | 0 | 177 | 216 | 664 | 625 | Trichosporon asahii var. asahii CBS 2479 translation release factor (A1Q1_00114), partial mRNA | blastn | 2222 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Trichosporon | Trichosporon asahii | |
| 4859807 | 4859807 | PRJNA1132896_P_NODE_4784_length_278_cov_1.487805_g4693_i0 | PRJNA1132896 | 4784 | 278 | 1.487805 | 4.1360979 | Malassezia | 55193 | Fungi | Fungi | 448 | 2.79e-121 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g4693 | i0 | 97.026 | 4.89568345323741 | 269 | 3 | 97 | 3 | 10 | 278 | 13625 | 13888 | Malassezia restricta mitochondrion, complete genome | blastn | 1361 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6661529 | 6661529 | PRJNA1132896_P_NODE_746_length_594_cov_1.168906_g656_i0 | PRJNA1132896 | 746 | 594 | 1.168906 | 6.94330164 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 333 | 1.87e-86 | NTclustered | gi|955480747|ref|XM_014798219.1| | 84753 | g656 | i0 | 77.28 | 23.0723905723906 | 603 | 113 | 99 | 20 | 1 | 591 | 457 | 1047 | Moesziomyces antarcticus p-loop containing nucleoside triphosphate hydrolase protein (PAN0_039d6339), partial mRNA | blastn | 13705 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 7936635 | 7936635 | PRJNA1132896_P_NODE_3527_length_301_cov_1.350877_g3436_i0 | PRJNA1132896 | 3527 | 301 | 1.350877 | 4.06613977 | Coniophora puteana | 80637 | Fungi | Fungi | 195 | 4.4e-45 | NTclustered | gi|628844737|ref|XM_007773228.1| | 741705 | g3436 | i0 | 85.561 | 20.3355481727575 | 187 | 25 | 62 | 2 | 70 | 255 | 367 | 182 | Coniophora puteana RWD-64-598 SS2 uncharacterized protein (CONPUDRAFT_108225), mRNA | blastn | 6121 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Coniophoraceae | Coniophora | Coniophora puteana | |
| 8684840 | 8684840 | PRJNA1132896_P_NODE_10687_length_223_cov_5.146667_g10596_i0 | PRJNA1132896 | 10687 | 223 | 5.146667 | 11.47706741 | Eukaryota | 2759 | Fungi | Fungi | 407 | 3.67e-109 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g10596 | i0 | 99.552 | 100.260089686099 | 223 | 1 | 100 | 0 | 1 | 223 | 1690 | 1468 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 22358 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10487148 | 10487148 | PRJNA1132896_P_NODE_5309_length_270_cov_1.563452_g5218_i0 | PRJNA1132896 | 5309 | 270 | 1.563452 | 4.2213204 | Malassezia restricta | 76775 | Fungi | Fungi | 472 | 1.6e-128 | NTclustered | gi|1546633802|ref|XM_027628561.1| | 76775 | g5218 | i0 | 98.148 | 1.39259259259259 | 270 | 5 | 100 | 0 | 1 | 270 | 576 | 307 | Malassezia restricta RIO kinase 2 (MRET_1934), partial mRNA | blastn | 376 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11235126 | 11235126 | PRJNA1132896_P_NODE_5129_length_273_cov_1.335000_g5038_i0 | PRJNA1132896 | 5129 | 273 | 1.335 | 3.64455 | Basidiomycota | 5204 | Fungi | Fungi | 505 | 1.6e-138 | NTclustered | gi|1732444885|dbj|LC497824.1| | 29899 | g5038 | i0 | 100 | 99.5860805860806 | 273 | 0 | 100 | 0 | 1 | 273 | 562 | 290 | Cystobasidium minutum DMKU2A-1 gene for LSU rRNA, partial sequence | blastn | 27187 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 15586519 | 15586519 | PRJNA1132896_P_NODE_2793_length_332_cov_1.783784_g2702_i0 | PRJNA1132896 | 2793 | 332 | 1.783784 | 5.92216288 | Wallemia mellicola | 1708541 | Fungi | Fungi | 154 | 8.33e-33 | NTclustered | gi|588261452|ref|XM_006959808.1| | 671144 | g2702 | i0 | 80 | 9.05722891566265 | 210 | 40 | 63 | 2 | 100 | 308 | 151 | 359 | Wallemia mellicola CBS 633.66 ribosomal protein S11 mRNA | blastn | 3007 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 17609448 | 17609448 | PRJNA1132896_P_NODE_8314_length_247_cov_0.879310_g8223_i0 | PRJNA1132896 | 8314 | 247 | 0.87931 | 2.1718957 | Malassezia | 55193 | Fungi | Fungi | 446 | 8.759999999999998e-121 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g8223 | i0 | 99.59 | 83.1821862348178 | 244 | 1 | 99 | 0 | 1 | 244 | 1886 | 2129 | Malassezia restricta mitochondrion, complete genome | blastn | 20546 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18883332 | 18883332 | PRJNA1132896_P_NODE_5215_length_272_cov_0.894472_g5124_i0 | PRJNA1132896 | 5215 | 272 | 0.894472 | 2.43296384 | Fungi | 4751 | Fungi | Fungi | 213 | 1.08e-50 | NTclustered | gi|1423586689|ref|XM_025743181.1| | 58919 | g5124 | i0 | 82.917 | 77.5036764705882 | 240 | 37 | 88 | 4 | 11 | 248 | 495 | 732 | Tilletiopsis washingtonensis 14-3-3 protein (FA09DRAFT_331796), mRNA | blastn | 21081 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 20685018 | 20685018 | PRJNA1132896_P_NODE_4997_length_275_cov_1.351485_g4906_i0 | PRJNA1132896 | 4997 | 275 | 1.351485 | 3.71658375 | Malassezia restricta | 76775 | Fungi | Fungi | 481 | 2.72e-131 | NTclustered | gi|1546634080|ref|XM_027628700.1| | 76775 | g4906 | i0 | 98.182 | 1 | 275 | 5 | 100 | 0 | 1 | 275 | 465 | 739 | Malassezia restricta ATP-dependent NAD(P)H-hydrate dehydratase (MRET_2073), partial mRNA | blastn | 275 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25258073 | 25258073 | PRJNA1132896_P_NODE_2440_length_352_cov_1.103943_g2349_i0 | PRJNA1132896 | 2440 | 352 | 1.103943 | 3.88587936 | Agaricomycetes | 155619 | Fungi | Fungi | 606 | 5.659999999999998e-169 | NTclustered | gi|827046364|ref|NC_027188.1| | 29884 | g2349 | i0 | 98.271 | 96.3664772727273 | 347 | 5 | 99 | 1 | 6 | 352 | 77291 | 77636 | Ganoderma applanatum strain CGMCC5.249 mitochondrion, complete genome | blastn | 33921 | 612 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma applanatum |
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);;