contig_metadata
15 rows where bioproject = "PRJNA484127", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14477398 | 14477398 | PRJNA484127_P_NODE_6792_length_447_cov_1.213904_g6644_i0 | PRJNA484127 | 6792 | 447 | 1.213904 | 5.42615088 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 219 | 4.029999999999999e-52 | NTclustered | gi|2432155310|ref|XM_053111519.1| | 110093 | g6644 | i0 | 80.756 | 48.006711409396 | 291 | 46 | 64 | 10 | 13 | 298 | 131 | 416 | Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA | blastn | 21459 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 26743821 | 26743821 | PRJNA484127_P_NODE_36421_length_245_cov_0.906977_g36272_i0 | PRJNA484127 | 36421 | 245 | 0.906977 | 2.22209365 | Chytridiaceae | 4812 | Fungi | Fungi | 84.3 | 1.27e-18 | NR | KAI8847197.1 | 64509 | g36272 | i0 | 67.2 | 2.97551020408163 | 61 | 20 | 74.7 | 0 | 184 | 2 | 5 | 65 | KAI8847197.1 Rpl14 protein [Chytridium lagenaria] | diamond | 729 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 27029094 | 27029094 | PRJNA484127_P_NODE_13002_length_346_cov_1.476190_g12853_i0 | PRJNA484127 | 13002 | 346 | 1.47619 | 5.1076174 | Opisthokonta | 33154 | Fungi | Fungi | 144 | 2.27e-40 | NR | KAI8815332.1 | 109936 | g12853 | i0 | 52.6 | 27.6589595375723 | 114 | 54 | 98.8 | 0 | 3 | 344 | 87 | 200 | KAI8815332.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Cladochytrium replicatum] | diamond | 9570 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 27360966 | 27360966 | PRJNA484127_P_NODE_38063_length_243_cov_0.917647_g37914_i0 | PRJNA484127 | 38063 | 243 | 0.917647 | 2.22988221 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 49.7 | 9.9e-5 | NR | KAH9258182.1 | 1357716 | g37914 | i0 | 36.5 | 1.04938271604938 | 85 | 44 | 100 | 3 | 1 | 243 | 88 | 166 | KAH9258182.1 hypothetical protein BASA81_003766 [Batrachochytrium salamandrivorans] | diamond | 255 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28181473 | 28181473 | PRJNA484127_P_NODE_29686_length_253_cov_0.866667_g29537_i0 | PRJNA484127 | 29686 | 253 | 0.866667 | 2.19266751 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 67.4 | 3.94e-12 | NR | KAH9255059.1 | 1357716 | g29537 | i0 | 48.1 | 1.92094861660079 | 79 | 15 | 93.7 | 1 | 238 | 2 | 1 | 53 | KAH9255059.1 hypothetical protein BASA81_006818 [Batrachochytrium salamandrivorans] | diamond | 486 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28687161 | 28687161 | PRJNA484127_P_NODE_12827_length_348_cov_1.309091_g12678_i0 | PRJNA484127 | 12827 | 348 | 1.309091 | 4.55563668 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 208 | 5.759999999999999e-67 | NR | KAH9261549.1 | 1357716 | g12678 | i0 | 90.5 | 1 | 116 | 11 | 100 | 0 | 1 | 348 | 6 | 121 | KAH9261549.1 40S ribosomal protein [Batrachochytrium salamandrivorans] | diamond | 348 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28750075 | 28750075 | PRJNA484127_P_NODE_29807_length_253_cov_0.866667_g29658_i0 | PRJNA484127 | 29807 | 253 | 0.866667 | 2.19266751 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 51.6 | 3.17e-5 | NR | KAH9260123.1 | 1357716 | g29658 | i0 | 39.5 | 2.72727272727273 | 81 | 34 | 83 | 2 | 219 | 10 | 469 | 545 | KAH9260123.1 hypothetical protein BASA81_001898 [Batrachochytrium salamandrivorans] | diamond | 690 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29696890 | 29696890 | PRJNA484127_P_NODE_38810_length_242_cov_0.923077_g38661_i0 | PRJNA484127 | 38810 | 242 | 0.923077 | 2.23384634 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 74.3 | 9.6e-14 | NR | KAJ3185971.1 | 2724198 | g38661 | i0 | 46.1 | 0.942148760330578 | 76 | 41 | 94.2 | 0 | 235 | 8 | 62 | 137 | KAJ3185971.1 hypothetical protein HDU85_000885 [Gaertneriomyces sp. JEL0708] | diamond | 228 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 30092193 | 30092193 | PRJNA484127_P_NODE_5872_length_475_cov_1.552239_g5724_i0 | PRJNA484127 | 5872 | 475 | 1.552239 | 7.37313525 | Chytridiomycetes | 451435 | Fungi | Fungi | 152 | 8.32e-40 | NR | KAI9099792.1 | 1117335 | g5724 | i0 | 49 | 1.88210526315789 | 147 | 74 | 92.8 | 1 | 467 | 27 | 428 | 573 | KAI9099792.1 nitrous oxide reductase [Phlyctochytrium arcticum] | diamond | 894 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium arcticum | |
| 30314071 | 30314071 | PRJNA484127_P_NODE_24252_length_274_cov_1.069652_g24103_i0 | PRJNA484127 | 24252 | 274 | 1.069652 | 2.93084648 | Fungi | 4751 | Fungi | Fungi | 68.9 | 8.09e-12 | NR | KAJ3205921.1 | 447962 | g24103 | i0 | 61.3 | 4.06204379562044 | 62 | 21 | 67.9 | 1 | 274 | 89 | 109 | 167 | KAJ3205921.1 60S ribosomal protein L19, partial [Clydaea vesicula] | diamond | 1113 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Clydaea | Clydaea vesicula | |
| 31008663 | 31008663 | PRJNA484127_P_NODE_13114_length_345_cov_1.375000_g12965_i0 | PRJNA484127 | 13114 | 345 | 1.375 | 4.74375 | Opisthokonta | 33154 | Fungi | Fungi | 178 | 4.14e-52 | NR | KAI8808358.1 | 109936 | g12965 | i0 | 71.9 | 50.5565217391304 | 114 | 32 | 99.1 | 0 | 344 | 3 | 252 | 365 | KAI8808358.1 P-loop containing nucleoside triphosphate hydrolase protein [Cladochytrium replicatum] | diamond | 17442 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 31640918 | 31640918 | PRJNA484127_P_NODE_26736_length_263_cov_2.047368_g26587_i0 | PRJNA484127 | 26736 | 263 | 2.047368 | 5.38457784 | Eukaryota | 2759 | Fungi | Fungi | 107 | 1.86e-27 | NR | KAJ3395875.1 | 109889 | g26587 | i0 | 72.2 | 4.106463878327 | 72 | 18 | 79.8 | 1 | 54 | 263 | 1 | 72 | KAJ3395875.1 60S ribosomal protein L12 [Lobulomyces angularis] | diamond | 1080 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 32036149 | 32036149 | PRJNA484127_P_NODE_32918_length_249_cov_0.886364_g32769_i0 | PRJNA484127 | 32918 | 249 | 0.886364 | 2.20704636 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 96.7 | 1.9e-22 | NR | KAH9255591.1 | 1357716 | g32769 | i0 | 52.3 | 1.06024096385542 | 88 | 35 | 100 | 2 | 1 | 249 | 56 | 141 | KAH9255591.1 hypothetical protein BASA81_006421 [Batrachochytrium salamandrivorans] | diamond | 264 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32416001 | 32416001 | PRJNA484127_P_NODE_37079_length_244_cov_0.912281_g36930_i0 | PRJNA484127 | 37079 | 244 | 0.912281 | 2.22596564 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 56.6 | 4.94e-7 | NR | KAI9362431.1 | 2211651 | g36930 | i0 | 48.3 | 0.713114754098361 | 58 | 30 | 71.3 | 0 | 183 | 10 | 406 | 463 | KAI9362431.1 cullin-4B-like protein [Zopfochytrium polystomum] | diamond | 174 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 32684348 | 32684348 | PRJNA484127_P_NODE_5660_length_482_cov_3.958435_g5512_i0 | PRJNA484127 | 5660 | 482 | 3.958435 | 19.0796567 | Neocallimastix | 4756 | Fungi | Fungi | 144 | 7.65e-41 | NR | ORY83434.1 | 1754190 | g5512 | i0 | 48.9 | 4.25103734439834 | 137 | 70 | 85.3 | 0 | 54 | 464 | 1 | 137 | ORY83434.1 hypothetical protein LY90DRAFT_522171 [Neocallimastix californiae] | diamond | 2049 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix californiae |
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);;