contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1218818" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1046290 | 1046290 | PRJNA1218818_P_NODE_13661_length_333_cov_1.776923_g13594_i0 | PRJNA1218818 | 13661 | 333 | 1.776923 | 5.91715359 | Fungi | 4751 | Fungi | Fungi | 121 | 4.77e-33 | NR | KAI9221418.1 | 64508 | g13594 | i0 | 59.8 | 5.24324324324324 | 97 | 39 | 87.4 | 0 | 313 | 23 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 5437041 | 5437041 | PRJNA1218818_P_NODE_27125_length_245_cov_0.866279_g27058_i0 | PRJNA1218818 | 27125 | 245 | 0.866279 | 2.12238355 | Eukaryota | 2759 | Fungi | Fungi | 142 | 1.43e-40 | NR | KAI9220356.1 | 64508 | g27058 | i0 | 80.2 | 35.6938775510204 | 81 | 16 | 99.2 | 0 | 245 | 3 | 84 | 164 | KAI9220356.1 ribosomal protein L15e [Blastocladiella britannica] | diamond | 8745 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 9261670 | 9261670 | PRJNA1218818_P_NODE_16048_length_310_cov_1.299578_g15981_i0 | PRJNA1218818 | 16048 | 310 | 1.299578 | 4.0286918 | Chytridiomycetes | 451435 | Fungi | Fungi | 136 | 1.21e-38 | NR | KAJ3083945.1 | 2724196 | g15981 | i0 | 67.7 | 20.2064516129032 | 93 | 30 | 90 | 0 | 280 | 2 | 5 | 97 | KAJ3083945.1 40S ribosomal protein S19 [Rhizoclosmatium hyalinum] | diamond | 6264 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium hyalinum | |
| 13799688 | 13799688 | PRJNA1218818_P_NODE_19771_length_281_cov_1.197115_g19704_i0 | PRJNA1218818 | 19771 | 281 | 1.197115 | 3.36389315 | Eukaryota | 2759 | Fungi | Fungi | 102 | 2.27e-26 | NR | KAI8852525.1 | 64509 | g19704 | i0 | 69.7 | 29.508896797153 | 66 | 20 | 70.5 | 0 | 251 | 54 | 1 | 66 | KAI8852525.1 ribosomal protein S27-domain-containing protein [Chytridium lagenaria] | diamond | 8292 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 20735150 | 20735150 | PRJNA1218818_P_NODE_19657_length_282_cov_1.095694_g19590_i0 | PRJNA1218818 | 19657 | 282 | 1.095694 | 3.08985708 | Opisthokonta | 33154 | Fungi | Fungi | 107 | 7.030000000000001e-27 | NR | XP_052964020.1 | 110093 | g19590 | i0 | 65.1 | 2.78723404255319 | 86 | 27 | 91.5 | 1 | 23 | 280 | 4 | 86 | XP_052964020.1 ribosomal protein L22/L17 [Polychytrium aggregatum] | diamond | 786 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 27104149 | 27104149 | PRJNA1218818_P_NODE_10042_length_384_cov_1.733119_g9975_i0 | PRJNA1218818 | 10042 | 384 | 1.733119 | 6.65517696 | Lyophyllum shimeji | 47721 | Fungi | Fungi | 54.7 | 1.12e-5 | NR | GLB37172.1 | 47721 | g9975 | i0 | 33.6 | 5.8203125 | 107 | 68 | 82.8 | 3 | 323 | 6 | 268 | 372 | GLB37172.1 putative retrotransposable element tf2 155 kda protein type 1-like [Lyophyllum shimeji] | diamond | 2235 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Lyophyllum | Lyophyllum shimeji | |
| 27420610 | 27420610 | PRJNA1218818_P_NODE_29363_length_231_cov_3.354430_g29296_i0 | PRJNA1218818 | 29363 | 231 | 3.35443 | 7.7487333 | Phycomyces nitens | 269771 | Fungi | Fungi | 111 | 1.46e-29 | NR | KAI9010348.1 | 269771 | g29296 | i0 | 76 | 3.8961038961039 | 75 | 18 | 97.4 | 0 | 225 | 1 | 1 | 75 | KAI9010348.1 50S ribosomal protein L32 [Phycomyces nitens] | diamond | 900 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces nitens | |
| 27767904 | 27767904 | PRJNA1218818_P_NODE_28264_length_242_cov_0.911243_g28197_i0 | PRJNA1218818 | 28264 | 242 | 0.911243 | 2.20520806 | Paraglomus occultum | 144539 | Fungi | Fungi | 125 | 4.86e-35 | NR | CAG8510315.1 | 144539 | g28197 | i0 | 68.8 | 1.98347107438017 | 80 | 25 | 99.2 | 0 | 2 | 241 | 17 | 96 | CAG8510315.1 8229_t:CDS:2 [Paraglomus occultum] | diamond | 480 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus occultum | |
| 28746467 | 28746467 | PRJNA1218818_P_NODE_25567_length_248_cov_0.880000_g25500_i0 | PRJNA1218818 | 25567 | 248 | 0.88 | 2.1824 | Schizothecium vesticola | 314040 | Fungi | Fungi | 43.5 | 0.0215 | NR | KAK0745823.1 | 314040 | g25500 | i0 | 32.3 | 0.75 | 62 | 42 | 75 | 0 | 195 | 10 | 529 | 590 | KAK0745823.1 hypothetical protein B0T18DRAFT_428900 [Schizothecium vesticola] | diamond | 186 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Schizotheciaceae | Schizothecium | Schizothecium vesticola | |
| 29093938 | 29093938 | PRJNA1218818_P_NODE_24668_length_250_cov_0.870056_g24601_i0 | PRJNA1218818 | 24668 | 250 | 0.870056 | 2.17514 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 100 | 2.7e-22 | NR | KAH9256624.1 | 1357716 | g24601 | i0 | 69.3 | 0.9 | 75 | 22 | 90 | 1 | 249 | 25 | 474 | 547 | KAH9256624.1 hypothetical protein BASA81_005128 [Batrachochytrium salamandrivorans] | diamond | 225 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29585873 | 29585873 | PRJNA1218818_P_NODE_24090_length_251_cov_0.865169_g24023_i0 | PRJNA1218818 | 24090 | 251 | 0.865169 | 2.17157419 | Fungi | 4751 | Fungi | Fungi | 43.9 | 0.0163 | NR | EPZ35947.1 | 988480 | g24023 | i0 | 34.1 | 3.27490039840637 | 91 | 50 | 98 | 3 | 6 | 251 | 521 | 610 | EPZ35947.1 ABC-2 family transporter protein domain-containing protein [Rozella allomycis CSF55] | diamond | 822 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29819766 | 29819766 | PRJNA1218818_P_NODE_28411_length_242_cov_0.911243_g28344_i0 | PRJNA1218818 | 28411 | 242 | 0.911243 | 2.20520806 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 122 | 4.8e-30 | NR | XP_069234311.1 | 1052096 | g28344 | i0 | 75 | 0.991735537190083 | 80 | 16 | 95.5 | 2 | 1 | 231 | 1250 | 1328 | XP_069234311.1 uncharacterized protein WHR41_00337 [Cladosporium halotolerans] | diamond | 240 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30577984 | 30577984 | PRJNA1218818_P_NODE_24773_length_250_cov_0.870056_g24706_i0 | PRJNA1218818 | 24773 | 250 | 0.870056 | 2.17514 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 141 | 6.8799999999999995e-37 | NR | KAH9261746.1 | 1357716 | g24706 | i0 | 79.5 | 0.996 | 83 | 17 | 99.6 | 0 | 250 | 2 | 120 | 202 | KAH9261746.1 hypothetical protein BASA81_000402 [Batrachochytrium salamandrivorans] | diamond | 249 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30830980 | 30830980 | PRJNA1218818_P_NODE_24834_length_249_cov_1.750000_g24767_i0 | PRJNA1218818 | 24834 | 249 | 1.75 | 4.3575 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 66.6 | 1.96e-11 | NR | PVU86898.1 | 61424 | g24767 | i0 | 36.6 | 2.87951807228916 | 82 | 51 | 97.6 | 1 | 3 | 245 | 4 | 85 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 717 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 31007797 | 31007797 | PRJNA1218818_P_NODE_24954_length_249_cov_0.875000_g24887_i0 | PRJNA1218818 | 24954 | 249 | 0.875 | 2.17875 | Fungi | 4751 | Fungi | Fungi | 75.5 | 8.48e-14 | NR | CAG8703811.1 | 94023 | g24887 | i0 | 49.4 | 3.26506024096386 | 83 | 36 | 92.8 | 1 | 249 | 19 | 174 | 256 | CAG8703811.1 4893_t:CDS:2 [Acaulospora morrowiae] | diamond | 813 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 31039673 | 31039673 | PRJNA1218818_P_NODE_28995_length_241_cov_0.916667_g28928_i0 | PRJNA1218818 | 28995 | 241 | 0.916667 | 2.20916747 | Fungi | 4751 | Fungi | Fungi | 64.3 | 9.27e-10 | NR | KAG2205482.1 | 97098 | g28928 | i0 | 37.3 | 10.0580912863071 | 83 | 48 | 98.3 | 2 | 238 | 2 | 954 | 1036 | KAG2205482.1 hypothetical protein INT46_007474 [Mucor plumbeus] | diamond | 2424 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 32095812 | 32095812 | PRJNA1218818_P_NODE_25618_length_248_cov_0.880000_g25551_i0 | PRJNA1218818 | 25618 | 248 | 0.88 | 2.1824 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 52.8 | 1.16e-5 | NR | KAH9250884.1 | 1357716 | g25551 | i0 | 60 | 0.483870967741935 | 40 | 15 | 47.2 | 1 | 247 | 131 | 243 | 282 | KAH9250884.1 hypothetical protein BASA81_011272 [Batrachochytrium salamandrivorans] | diamond | 120 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32254411 | 32254411 | PRJNA1218818_P_NODE_28718_length_241_cov_1.416667_g28651_i0 | PRJNA1218818 | 28718 | 241 | 1.416667 | 3.41416747 | Modicella reniformis | 1440133 | Fungi | Fungi | 71.6 | 3.65e-13 | NR | KAG0004842.1 | 1440133 | g28651 | i0 | 75 | 0.547717842323652 | 44 | 11 | 54.8 | 0 | 136 | 5 | 1 | 44 | KAG0004842.1 H(+)-transporting V0 sector ATPase subunit c [Modicella reniformis] | diamond | 132 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Modicella | Modicella reniformis | |
| 32840916 | 32840916 | PRJNA1218818_P_NODE_27900_length_243_cov_0.905882_g27833_i0 | PRJNA1218818 | 27900 | 243 | 0.905882 | 2.20129326 | Chytridiomycota | 4761 | Fungi | Fungi | 130 | 4.429999999999999e-35 | NR | KAJ3239721.1 | 4814 | g27833 | i0 | 82.1 | 22.2962962962963 | 78 | 14 | 96.3 | 0 | 10 | 243 | 54 | 131 | KAJ3239721.1 40S ribosomal protein S3 [Chytriomyces hyalinus] | diamond | 5418 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus |
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);;