contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 302657 | 302657 | PRJNA1156092_P_NODE_14921_length_300_cov_2.035242_g14791_i0 | PRJNA1156092 | 14921 | 300 | 2.035242 | 6.105726 | Flammulina velutipes | 38945 | Fungi | Fungi | 555 | 1.7399999999999995e-153 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g14791 | i0 | 100 | 106.263333333333 | 300 | 0 | 100 | 0 | 1 | 300 | 5510 | 5809 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 31879 | 555 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 1577301 | 1577301 | PRJNA1156092_P_NODE_15262_length_297_cov_2.375000_g15132_i0 | PRJNA1156092 | 15262 | 297 | 2.375 | 7.05375 | Flammulina velutipes | 38945 | Fungi | Fungi | 545 | 1.04e-150 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g15132 | i0 | 100 | 99.4882154882155 | 295 | 0 | 99 | 0 | 1 | 295 | 565 | 859 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 29548 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 1577318 | 1577318 | PRJNA1156092_P_NODE_16422_length_288_cov_2.041860_g16292_i0 | PRJNA1156092 | 16422 | 288 | 2.04186 | 5.8805568 | Malassezia restricta | 76775 | Fungi | Fungi | 381 | 2.9899999999999995e-101 | NTclustered | gi|1546636729|ref|XM_027630007.1| | 76775 | g16292 | i0 | 98.605 | 0.746527777777778 | 215 | 3 | 75 | 0 | 1 | 215 | 689 | 903 | Malassezia restricta exosome complex component RRP43 (MRET_3380), partial mRNA | blastn | 215 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 1577522 | 1577522 | PRJNA1156092_P_NODE_29302_length_244_cov_0.900585_g29172_i0 | PRJNA1156092 | 29302 | 244 | 0.900585 | 2.1974274 | Filobasidium floriforme | 5210 | Fungi | Fungi | 440 | 4.019999999999999e-119 | NTclustered | gi|2185524693|ref|XM_046179184.1| | 5210 | g29172 | i0 | 99.18 | 10.1393442622951 | 244 | 2 | 100 | 0 | 1 | 244 | 767 | 524 | Filobasidium floriforme putative Sec61p-like protein (HD553DRAFT_305696), mRNA | blastn | 2474 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 2853803 | 2853803 | PRJNA1156092_P_NODE_23643_length_250_cov_0.870056_g23513_i0 | PRJNA1156092 | 23643 | 250 | 0.870056 | 2.17514 | Malassezia restricta | 76775 | Fungi | Fungi | 407 | 4.1899999999999994e-109 | NTclustered | gi|1546635152|ref|XM_027629235.1| | 76775 | g23513 | i0 | 96 | 1 | 250 | 10 | 100 | 0 | 1 | 250 | 2117 | 2366 | Malassezia restricta chitin synthase (MRET_2608), partial mRNA | blastn | 250 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 4129707 | 4129707 | PRJNA1156092_P_NODE_21424_length_253_cov_2.250000_g21294_i0 | PRJNA1156092 | 21424 | 253 | 2.25 | 5.6925 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 119 | 2.23e-22 | NTclustered | gi|1423585092|ref|XM_025745445.1| | 58919 | g21294 | i0 | 83.333 | 10 | 132 | 18 | 52 | 2 | 8 | 138 | 812 | 684 | Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_362183), mRNA | blastn | 2530 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 5405927 | 5405927 | PRJNA1156092_P_NODE_27265_length_246_cov_0.890173_g27135_i0 | PRJNA1156092 | 27265 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 438 | 1.4599999999999996e-118 | NTclustered | gi|1546630381|ref|XM_027626851.1| | 76775 | g27135 | i0 | 98.78 | 1 | 246 | 3 | 100 | 0 | 1 | 246 | 721 | 476 | Malassezia restricta cytochrome c oxidase subunit 15 (MRET_0224), partial mRNA | blastn | 246 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6680803 | 6680803 | PRJNA1156092_P_NODE_33086_length_226_cov_3.013072_g32956_i0 | PRJNA1156092 | 33086 | 226 | 3.013072 | 6.80954272 | Flammulina velutipes | 38945 | Fungi | Fungi | 418 | 1.7199999999999998e-112 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g32956 | i0 | 100 | 102.146017699115 | 226 | 0 | 100 | 0 | 1 | 226 | 4201 | 3976 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 23085 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 9230883 | 9230883 | PRJNA1156092_P_NODE_2728_length_600_cov_1.481973_g2601_i0 | PRJNA1156092 | 2728 | 600 | 1.481973 | 8.891838 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 56.5 | 0.005 | NTclustered | gi|1423581197|ref|XM_025745741.1| | 58919 | g2601 | i0 | 100 | 0.05 | 30 | 0 | 5 | 0 | 494 | 523 | 345 | 374 | Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_61677), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 10506405 | 10506405 | PRJNA1156092_P_NODE_10989_length_338_cov_1.162264_g10859_i0 | PRJNA1156092 | 10989 | 338 | 1.162264 | 3.92845232 | Kwoniella mangrovensis | 463800 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2736858893|ref|XM_065517900.1| | 1296122 | g10859 | i0 | 100 | 0.0887573964497041 | 30 | 0 | 9 | 0 | 45 | 74 | 376 | 405 | Kwoniella mangroviensis CBS 8507 uncharacterized protein (I203_106099), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella mangrovensis | |
| 11240493 | 11240493 | PRJNA1156092_P_NODE_19369_length_268_cov_1.153846_g19239_i0 | PRJNA1156092 | 19369 | 268 | 1.153846 | 3.09230728 | Opisthokonta | 33154 | Fungi | Fungi | 479 | 9.499999999999996e-131 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g19239 | i0 | 98.881 | 89.4925373134328 | 268 | 3 | 100 | 0 | 1 | 268 | 445 | 712 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23984 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 11781739 | 11781739 | PRJNA1156092_P_NODE_9930_length_351_cov_4.712230_g9800_i0 | PRJNA1156092 | 9930 | 351 | 4.71223 | 16.5399273 | Malassezia restricta | 76775 | Fungi | Fungi | 647 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g9800 | i0 | 100 | 90.7492877492877 | 350 | 0 | 99 | 0 | 1 | 350 | 3008 | 3357 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 31853 | 647 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13056311 | 13056311 | PRJNA1156092_P_NODE_15111_length_299_cov_1.022124_g14981_i0 | PRJNA1156092 | 15111 | 299 | 1.022124 | 3.05615076 | Fomitopsis serialis | 139415 | Fungi | Fungi | 52.8 | 0.028 | NTclustered | gi|2234713581|ref|XM_048039832.1| | 139415 | g14981 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 83 | 110 | 738 | 711 | Antrodia serialis uncharacterized protein (B0H18DRAFT_867070), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis serialis | |
| 13056440 | 13056440 | PRJNA1156092_P_NODE_22231_length_251_cov_0.865169_g22101_i0 | PRJNA1156092 | 22231 | 251 | 0.865169 | 2.17157419 | Malassezia globosa | 76773 | Fungi | Fungi | 459 | 1.1499999999999996e-124 | NTclustered | gi|164659433|ref|XM_001730789.1| | 425265 | g22101 | i0 | 99.602 | 1 | 251 | 1 | 100 | 0 | 1 | 251 | 764 | 514 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_1840), partial mRNA | blastn | 251 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 13056485 | 13056485 | PRJNA1156092_P_NODE_24671_length_249_cov_0.875000_g24541_i0 | PRJNA1156092 | 24671 | 249 | 0.875 | 2.17875 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|1546631079|ref|XM_027627200.1| | 76775 | g24541 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 692 | 940 | Malassezia restricta mitochondrial splicing suppressor protein 51 (MRET_0573), partial mRNA | blastn | 249 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16879686 | 16879686 | PRJNA1156092_P_NODE_11174_length_336_cov_1.334601_g11044_i0 | PRJNA1156092 | 11174 | 336 | 1.334601 | 4.48425936 | Rhodotorula graminis | 29898 | Fungi | Fungi | 244 | 4.87e-60 | NTclustered | gi|1069924879|ref|XM_018414273.1| | 578459 | g11044 | i0 | 82.971 | 4.23511904761905 | 276 | 41 | 81 | 5 | 1 | 273 | 309 | 37 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_43715), partial mRNA | blastn | 1423 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 18154777 | 18154777 | PRJNA1156092_P_NODE_5255_length_452_cov_2.192612_g5125_i0 | PRJNA1156092 | 5255 | 452 | 2.192612 | 9.91060624 | Malassezia restricta | 76775 | Fungi | Fungi | 835 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5125 | i0 | 100 | 106.280973451327 | 452 | 0 | 100 | 0 | 1 | 452 | 1462 | 1913 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 48039 | 835 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24528578 | 24528578 | PRJNA1156092_P_NODE_12680_length_321_cov_1.145161_g12550_i0 | PRJNA1156092 | 12680 | 321 | 1.145161 | 3.67596681 | Kwoniella dejecticola | 324770 | Fungi | Fungi | 222 | 2.17e-53 | NTclustered | gi|1069913867|ref|XM_018411470.1| | 1296121 | g12550 | i0 | 79.43 | 65.9906542056075 | 316 | 63 | 98 | 2 | 1 | 315 | 141 | 455 | Kwoniella dejecticola CBS 10117 40S ribosomal protein uS11 (I303_106532), partial mRNA | blastn | 21183 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dejecticola | |
| 24528662 | 24528662 | PRJNA1156092_P_NODE_17420_length_281_cov_1.764423_g17290_i0 | PRJNA1156092 | 17420 | 281 | 1.764423 | 4.95802863 | Malassezia restricta | 76775 | Fungi | Fungi | 486 | 5.989999999999999e-133 | NTclustered | gi|1546638203|ref|XM_027630743.1| | 76775 | g17290 | i0 | 97.865 | 1 | 281 | 6 | 100 | 0 | 1 | 281 | 880 | 600 | Malassezia restricta thioredoxin reductase (MRET_4116), partial mRNA | blastn | 281 | 486 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25263655 | 25263655 | PRJNA1156092_P_NODE_9540_length_357_cov_1.415493_g9410_i0 | PRJNA1156092 | 9540 | 357 | 1.415493 | 5.05331001 | Flammulina | 38944 | Fungi | Fungi | 636 | 7.339999999999998e-178 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g9410 | i0 | 99.15 | 98.4873949579832 | 353 | 3 | 99 | 0 | 5 | 357 | 2904 | 2552 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 35160 | 636 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes |
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);;