contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB50765" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5221963 | 5221963 | PRJEB50765_P_NODE_2145_length_195_cov_1.677215_g2121_i0 | PRJEB50765 | 2145 | 195 | 1.677215 | 3.27056925 | Austropuccinia psidii | 181123 | Fungi | Fungi | 122 | 1.4499999999999999e-34 | NR | MBW0489473.1 | 1389203 | g2121 | i0 | 85.9 | 1.98461538461538 | 64 | 9 | 98.5 | 0 | 195 | 4 | 21 | 84 | MBW0489473.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 387 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 5221968 | 5221968 | PRJEB50765_P_NODE_2705_length_169_cov_1.984848_g2681_i0 | PRJEB50765 | 2705 | 169 | 1.984848 | 3.35439312 | Chytriomyces | 109882 | Fungi | Fungi | 99 | 3.53e-24 | NR | TPX69010.1 | 246404 | g2681 | i0 | 82.1 | 4.97041420118343 | 56 | 10 | 99.4 | 0 | 169 | 2 | 82 | 137 | TPX69010.1 hypothetical protein CcCBS67573_g06961 [Chytriomyces confervae] | diamond | 840 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces confervae | |
| 26653398 | 26653398 | PRJEB50765_P_NODE_1881_length_213_cov_1.295455_g1857_i0 | PRJEB50765 | 1881 | 213 | 1.295455 | 2.75931915 | Coemansia sp. RSA 2336 | 2512256 | Fungi | Fungi | 47.8 | 3.62e-4 | NR | KAJ2454281.1 | 2512256 | g1857 | i0 | 69.7 | 0.464788732394366 | 33 | 10 | 46.5 | 0 | 114 | 212 | 26 | 58 | KAJ2454281.1 hypothetical protein EV183_001647 [Coemansia sp. RSA 2336] | diamond | 99 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 2336 | |
| 27343134 | 27343134 | PRJEB50765_P_NODE_2943_length_161_cov_1.459677_g2919_i0 | PRJEB50765 | 2943 | 161 | 1.459677 | 2.35007997 | Fungi | 4751 | Fungi | Fungi | 73.2 | 2.25e-13 | NR | KAF9355797.1 | 1896193 | g2919 | i0 | 64.2 | 19.7515527950311 | 53 | 19 | 98.8 | 0 | 3 | 161 | 727 | 779 | KAF9355797.1 Elongation factor 2 [Mortierella sp. NVP85] | diamond | 3180 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. NVP85 | |
| 27469358 | 27469358 | PRJEB50765_P_NODE_2343_length_185_cov_1.033784_g2319_i0 | PRJEB50765 | 2343 | 185 | 1.033784 | 1.9125004 | Opisthokonta | 33154 | Fungi | Fungi | 82.8 | 1.32e-16 | NR | KAJ3244008.1 | 4814 | g2319 | i0 | 68.4 | 43.9621621621622 | 57 | 18 | 92.4 | 0 | 173 | 3 | 18 | 74 | KAJ3244008.1 T-complex protein 1 subunit delta [Chytriomyces hyalinus] | diamond | 8133 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 27602426 | 27602426 | PRJEB50765_P_NODE_2204_length_191_cov_1.500000_g2180_i0 | PRJEB50765 | 2204 | 191 | 1.5 | 2.865 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 61.6 | 1.53e-9 | NR | ORX94009.1 | 1314790 | g2180 | i0 | 49.2 | 2.96858638743455 | 63 | 32 | 99 | 0 | 2 | 190 | 54 | 116 | ORX94009.1 F1 complex, OSCP/delta subunit of ATPase [Basidiobolus meristosporus CBS 931.73] | diamond | 567 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 27974411 | 27974411 | PRJEB50765_P_NODE_3285_length_151_cov_1.368421_g3261_i0 | PRJEB50765 | 3285 | 151 | 1.368421 | 2.06631571 | Ascomycota | 4890 | Fungi | Fungi | 45.4 | 5.88e-4 | NR | XP_064730136.1 | 1635080 | g3261 | i0 | 34 | 7.86754966887417 | 50 | 33 | 99.3 | 0 | 1 | 150 | 7 | 56 | XP_064730136.1 uncharacterized protein PMZ80_005999 [Knufia obscura] | diamond | 1188 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 28258418 | 28258418 | PRJEB50765_P_NODE_786_length_376_cov_1.362832_g762_i0 | PRJEB50765 | 786 | 376 | 1.362832 | 5.12424832 | Trypetheliaceae | 271822 | Fungi | Fungi | 157 | 9.43e-46 | NR | QIW95448.1 | 286661 | g762 | i0 | 58.5 | 18.6542553191489 | 123 | 51 | 98.1 | 0 | 6 | 374 | 4 | 126 | QIW95448.1 hypothetical protein AMS68_000966 [Peltaster fructicola] | diamond | 7014 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Peltaster | Peltaster fructicola | |||
| 29843999 | 29843999 | PRJEB50765_P_NODE_3111_length_156_cov_0.983193_g3087_i0 | PRJEB50765 | 3111 | 156 | 0.983193 | 1.53378108 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 58.2 | 4.23e-8 | NR | KAI8893489.1 | 382532 | g3087 | i0 | 53.8 | 2 | 52 | 24 | 100 | 0 | 156 | 1 | 462 | 513 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 312 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 29938901 | 29938901 | PRJEB50765_P_NODE_3191_length_153_cov_2.672414_g3167_i0 | PRJEB50765 | 3191 | 153 | 2.672414 | 4.08879342 | Lactarius indigo | 222702 | Fungi | Fungi | 67 | 3.22e-12 | NR | KAI9441372.1 | 222702 | g3167 | i0 | 62 | 1.84313725490196 | 50 | 19 | 98 | 0 | 151 | 2 | 27 | 76 | KAI9441372.1 profilin [Lactarius indigo] | diamond | 282 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius indigo | |
| 30026958 | 30026958 | PRJEB50765_P_NODE_2871_length_163_cov_1.841270_g2847_i0 | PRJEB50765 | 2871 | 163 | 1.84127 | 3.0012701 | Mucorales | 4827 | Fungi | Fungi | 63.5 | 6.27e-11 | NR | XP_052985062.1 | 64656 | g2847 | i0 | 68.1 | 6.05521472392638 | 47 | 9 | 86.5 | 1 | 141 | 1 | 1 | 41 | XP_052985062.1 ribosomal L28e/Mak16 [Zychaea mexicana] | diamond | 987 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 30476003 | 30476003 | PRJEB50765_P_NODE_1853_length_214_cov_3.276836_g1829_i0 | PRJEB50765 | 1853 | 214 | 3.276836 | 7.01242904 | Linderina pennispora | 61395 | Fungi | Fungi | 68.9 | 7.76e-13 | NR | XP_040744554.1 | 61395 | g1829 | i0 | 60 | 1.54205607476636 | 55 | 22 | 77.1 | 0 | 212 | 48 | 80 | 134 | XP_040744554.1 uncharacterized protein DL89DRAFT_322311 [Linderina pennispora] | diamond | 330 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 30721802 | 30721802 | PRJEB50765_P_NODE_1854_length_214_cov_3.056497_g1830_i0 | PRJEB50765 | 1854 | 214 | 3.056497 | 6.54090358 | Fungi | 4751 | Fungi | Fungi | 89.4 | 7.480000000000001e-21 | NR | RCH92629.1 | 4846 | g1830 | i0 | 62.5 | 13.5280373831776 | 64 | 24 | 89.7 | 0 | 193 | 2 | 4 | 67 | RCH92629.1 40S ribosomal protein S19, partial [Rhizopus stolonifer] | diamond | 2895 | 89.7 | 0.996655518394649 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 31290621 | 31290621 | PRJEB50765_P_NODE_2675_length_170_cov_2.315789_g2651_i0 | PRJEB50765 | 2675 | 170 | 2.315789 | 3.9368413 | Hypocreales | 5125 | Fungi | Fungi | 69.7 | 6.08e-13 | NR | KAK0386690.1 | 5046 | g2651 | i0 | 62.5 | 3.93529411764706 | 56 | 21 | 98.8 | 0 | 170 | 3 | 26 | 81 | KAK0386690.1 hypothetical protein NLU13_6524 [Sarocladium strictum] | diamond | 669 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31392538 | 31392538 | PRJEB50765_P_NODE_2156_length_194_cov_2.445860_g2132_i0 | PRJEB50765 | 2156 | 194 | 2.44586 | 4.7449684 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 73.9 | 6.83e-15 | NR | KAG8920536.1 | 2600225 | g2132 | i0 | 53.2 | 0.958762886597938 | 62 | 29 | 95.9 | 0 | 190 | 5 | 40 | 101 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 186 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 31582267 | 31582267 | PRJEB50765_P_NODE_1236_length_278_cov_1.759336_g1212_i0 | PRJEB50765 | 1236 | 278 | 1.759336 | 4.89095408 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 80.5 | 5.29e-17 | NR | ORZ39709.1 | 765915 | g1212 | i0 | 50.6 | 1.80215827338129 | 83 | 41 | 89.6 | 0 | 278 | 30 | 36 | 118 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 501 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32303336 | 32303336 | PRJEB50765_P_NODE_1699_length_227_cov_1.221053_g1675_i0 | PRJEB50765 | 1699 | 227 | 1.221053 | 2.77179031 | root | 1 | Root_unresolved | Root_unresolved | 96.7 | 1.4399999999999994e-23 | NR | KCZ78541.1 | 1240240 | g1675 | i0 | 57.7 | 7.49339207048458 | 71 | 30 | 93.8 | 0 | 11 | 223 | 47 | 117 | KCZ78541.1 hypothetical protein H311_00425 [Anncaliia algerae PRA109] | diamond | 1701 | 97.1 | 0.995880535530381 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 32373212 | 32373212 | PRJEB50765_P_NODE_1259_length_275_cov_2.449580_g1235_i0 | PRJEB50765 | 1259 | 275 | 2.44958 | 6.736345 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 71.6 | 3.17e-13 | NR | PVU86898.1 | 61424 | g1235 | i0 | 37.1 | 0.970909090909091 | 89 | 55 | 96 | 1 | 267 | 4 | 4 | 92 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 267 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 32404784 | 32404784 | PRJEB50765_P_NODE_3199_length_153_cov_1.681034_g3175_i0 | PRJEB50765 | 3199 | 153 | 1.681034 | 2.57198202 | Westerdykella ornata | 318751 | Fungi | Fungi | 49.3 | 4.46e-5 | NR | XP_033654656.1 | 318751 | g3175 | i0 | 53.1 | 2.64705882352941 | 49 | 23 | 96.1 | 0 | 152 | 6 | 50 | 98 | XP_033654656.1 60S ribosomal protein L7 [Westerdykella ornata] | diamond | 405 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Sporormiaceae | Westerdykella | Westerdykella ornata | |
| 32461352 | 32461352 | PRJEB50765_P_NODE_3299_length_151_cov_1.026316_g3275_i0 | PRJEB50765 | 3299 | 151 | 1.026316 | 1.54973716 | Fungi | 4751 | Fungi | Fungi | 44.7 | 0.00206 | NR | KNE70352.1 | 578462 | g3275 | i0 | 42 | 2.66225165562914 | 50 | 29 | 99.3 | 0 | 150 | 1 | 77 | 126 | KNE70352.1 ribosomal protein S3 [Allomyces macrogynus ATCC 38327] | diamond | 402 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32499840 | 32499840 | PRJEB50765_P_NODE_779_length_379_cov_1.906433_g755_i0 | PRJEB50765 | 779 | 379 | 1.906433 | 7.22538107 | Lipomyces arxii | 56418 | Fungi | Fungi | 67.4 | 2.99e-11 | NR | XP_066769882.1 | 56418 | g755 | i0 | 40.5 | 2.02638522427441 | 84 | 50 | 66.5 | 0 | 378 | 127 | 63 | 146 | XP_066769882.1 ribosomal protein S27a-domain-containing protein [Lipomyces arxii] | diamond | 768 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 32808055 | 32808055 | PRJEB50765_P_NODE_1500_length_248_cov_1.284360_g1476_i0 | PRJEB50765 | 1500 | 248 | 1.28436 | 3.1852128 | Fungi | 4751 | Fungi | Fungi | 64.7 | 5.93e-11 | NR | KAI5308241.1 | 51567 | g1476 | i0 | 51.8 | 3.54435483870968 | 56 | 27 | 67.7 | 0 | 243 | 76 | 54 | 109 | KAI5308241.1 40S ribosomal protein S19, partial [Ascosphaera atra] | diamond | 879 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ascosphaeraceae | Ascosphaera | Ascosphaera atra |
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);;