contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15862800 | 15862800 | PRJNA575566_P_NODE_26533_length_206_cov_0.882759_g26336_i0 | PRJNA575566 | 26533 | 206 | 0.882759 | 1.81848354 | Eukaryota | 2759 | Fungi | Fungi | 97.8 | 8.270000000000001e-22 | NR | KAI8803233.1 | 109936 | g26336 | i0 | 67.2 | 12.4368932038835 | 67 | 22 | 97.6 | 0 | 3 | 203 | 228 | 294 | KAI8803233.1 cleft lip and palate transmembrane protein 1-domain-containing protein [Cladochytrium replicatum] | diamond | 2562 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 23512260 | 23512260 | PRJNA575566_P_NODE_13299_length_288_cov_1.691630_g13102_i0 | PRJNA575566 | 13299 | 288 | 1.69163 | 4.8718944 | root | 1 | Root_unresolved | Root_unresolved | 110 | 7.099999999999999e-26 | NR | XP_052969573.1 | 110093 | g13102 | i0 | 64.5 | 15.40625 | 76 | 27 | 79.2 | 0 | 60 | 287 | 26 | 101 | XP_052969573.1 G subunit of NADH dehydrogenase [Polychytrium aggregatum] | diamond | 4437 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 27364328 | 27364328 | PRJNA575566_P_NODE_21223_length_227_cov_1.156627_g21026_i0 | PRJNA575566 | 21223 | 227 | 1.156627 | 2.62554329 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 44.3 | 0.00876 | NR | KAJ3189092.1 | 2724198 | g21026 | i0 | 43.6 | 0.726872246696035 | 55 | 31 | 72.7 | 0 | 6 | 170 | 161 | 215 | KAJ3189092.1 hypothetical protein HDU85_002717 [Gaertneriomyces sp. JEL0708] | diamond | 165 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 27364329 | 27364329 | PRJNA575566_P_NODE_25183_length_208_cov_0.870748_g24986_i0 | PRJNA575566 | 25183 | 208 | 0.870748 | 1.81115584 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 102 | 5.19e-26 | NR | KAL2917519.1 | 2732419 | g24986 | i0 | 72.5 | 2.98557692307692 | 69 | 19 | 99.5 | 0 | 2 | 208 | 10 | 78 | KAL2917519.1 60S ribosomal protein L27B [Polyrhizophydium stewartii] | diamond | 621 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 27364339 | 27364339 | PRJNA575566_P_NODE_9543_length_338_cov_1.512635_g9346_i0 | PRJNA575566 | 9543 | 338 | 1.512635 | 5.1127063 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 120 | 7.040000000000001e-29 | NR | ORX88096.1 | 1754192 | g9346 | i0 | 54.8 | 2.76923076923077 | 104 | 47 | 92.3 | 0 | 338 | 27 | 185 | 288 | ORX88096.1 hypothetical protein BCR32DRAFT_288848 [Anaeromyces robustus] | diamond | 936 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 27521810 | 27521810 | PRJNA575566_P_NODE_23263_length_214_cov_1.254902_g23066_i0 | PRJNA575566 | 23263 | 214 | 1.254902 | 2.68549028 | Kappamyces sp. JEL | 2040833 | Fungi | Fungi | 64.7 | 1.74e-10 | NR | KAJ3307245.1 | 2724216 | g23066 | i0 | 61.8 | 0.771028037383178 | 55 | 20 | 75.7 | 1 | 2 | 163 | 171 | 225 | KAJ3307245.1 hypothetical protein HDV03_001730 [Kappamyces sp. JEL0829] | diamond | 165 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0829 | |
| 28798250 | 28798250 | PRJNA575566_P_NODE_16127_length_263_cov_0.950495_g15930_i0 | PRJNA575566 | 16127 | 263 | 0.950495 | 2.49980185 | Chytridiomycetes | 451435 | Fungi | Fungi | 101 | 4.27e-25 | NR | KAJ3224310.1 | 4814 | g15930 | i0 | 57 | 6.26235741444867 | 79 | 34 | 90.1 | 0 | 239 | 3 | 47 | 125 | KAJ3224310.1 hypothetical protein HDU81_008631, partial [Chytriomyces hyalinus] | diamond | 1647 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 30251320 | 30251320 | PRJNA575566_P_NODE_3432_length_561_cov_1.820000_g3236_i0 | PRJNA575566 | 3432 | 561 | 1.82 | 10.2102 | Opisthokonta | 33154 | Fungi | Fungi | 265 | 1.4700000000000001e-86 | NR | KAH9252987.1 | 1357716 | g3236 | i0 | 70.2 | 12.4224598930481 | 178 | 52 | 94.7 | 1 | 554 | 24 | 72 | 249 | KAH9252987.1 hypothetical protein BASA81_009143 [Batrachochytrium salamandrivorans] | diamond | 6969 | 267 | 0.99250936329588 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30553322 | 30553322 | PRJNA575566_P_NODE_21673_length_224_cov_1.294479_g21476_i0 | PRJNA575566 | 21673 | 224 | 1.294479 | 2.89963296 | Clydaea vesicula | 447962 | Fungi | Fungi | 62.8 | 9.22e-10 | NR | KAJ3209591.1 | 447962 | g21476 | i0 | 60.8 | 1.36607142857143 | 51 | 20 | 68.3 | 0 | 2 | 154 | 165 | 215 | KAJ3209591.1 hypothetical protein HK099_008473, partial [Clydaea vesicula] | diamond | 306 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Clydaea | Clydaea vesicula | |
| 30679629 | 30679629 | PRJNA575566_P_NODE_29333_length_202_cov_0.907801_g29136_i0 | PRJNA575566 | 29333 | 202 | 0.907801 | 1.83375802 | Lobulomyces angularis | 109889 | Fungi | Fungi | 53.9 | 2.25e-6 | NR | KAJ3396849.1 | 109889 | g29136 | i0 | 40.9 | 2.56930693069307 | 66 | 39 | 98 | 0 | 3 | 200 | 178 | 243 | KAJ3396849.1 hypothetical protein HDU92_001683 [Lobulomyces angularis] | diamond | 519 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 32134440 | 32134440 | PRJNA575566_P_NODE_29598_length_201_cov_1.221429_g29401_i0 | PRJNA575566 | 29598 | 201 | 1.221429 | 2.45507229 | Chytriomyces sp. MP71 | 1882861 | Fungi | Fungi | 62.4 | 2.27e-9 | NR | KAI8611214.1 | 1882861 | g29401 | i0 | 43.9 | 0.985074626865672 | 66 | 36 | 97 | 1 | 1 | 195 | 109 | 174 | KAI8611214.1 hypothetical protein BC830DRAFT_1172075 [Chytriomyces sp. MP71] | diamond | 198 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces sp. MP71 | |
| 32179718 | 32179718 | PRJNA575566_P_NODE_24438_length_209_cov_0.864865_g24241_i0 | PRJNA575566 | 24438 | 209 | 0.864865 | 1.80756785 | Chytridiomycetes | 451435 | Fungi | Fungi | 80.5 | 1.18e-15 | NR | XP_016610836.1 | 645134 | g24241 | i0 | 52.2 | 8.91387559808612 | 69 | 33 | 99 | 0 | 3 | 209 | 259 | 327 | XP_016610836.1 CAMK protein kinase [Spizellomyces punctatus DAOM BR117] | diamond | 1863 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 32261224 | 32261224 | PRJNA575566_P_NODE_29678_length_201_cov_0.914286_g29481_i0 | PRJNA575566 | 29678 | 201 | 0.914286 | 1.83771486 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 48.9 | 1.48e-4 | NR | KAJ3018445.1 | 2723227 | g29481 | i0 | 43.5 | 1.02985074626866 | 69 | 36 | 100 | 2 | 201 | 1 | 129 | 196 | KAJ3018445.1 hypothetical protein HDU68_011153 [Siphonaria sp. JEL0065] | diamond | 207 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 | |
| 32545884 | 32545884 | PRJNA575566_P_NODE_24839_length_208_cov_0.870748_g24642_i0 | PRJNA575566 | 24839 | 208 | 0.870748 | 1.81115584 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 86.7 | 6.88e-18 | NR | ORX64704.1 | 1754192 | g24642 | i0 | 64.4 | 1.70192307692308 | 59 | 21 | 85.1 | 0 | 1 | 177 | 110 | 168 | ORX64704.1 slu7 protein [Anaeromyces robustus] | diamond | 354 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 32829245 | 32829245 | PRJNA575566_P_NODE_28580_length_203_cov_0.901408_g28383_i0 | PRJNA575566 | 28580 | 203 | 0.901408 | 1.82985824 | Lobulomyces angularis | 109889 | Fungi | Fungi | 54.3 | 1.69e-6 | NR | KAJ3392315.1 | 109889 | g28383 | i0 | 51 | 0.753694581280788 | 51 | 23 | 72.4 | 1 | 176 | 30 | 178 | 228 | KAJ3392315.1 Protein fam49a [Lobulomyces angularis] | diamond | 153 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 32842573 | 32842573 | PRJNA575566_P_NODE_22660_length_217_cov_2.371795_g22463_i0 | PRJNA575566 | 22660 | 217 | 2.371795 | 5.14679515 | Eukaryota | 2759 | Fungi | Fungi | 114 | 3.09e-29 | NR | KAI9014143.1 | 82268 | g22463 | i0 | 77.3 | 16.3548387096774 | 66 | 15 | 91.2 | 0 | 199 | 2 | 1 | 66 | KAI9014143.1 ribosomal family S4e-domain-containing protein [Hyaloraphidium curvatum] | diamond | 3549 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum |
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);;