contig_metadata
12 rows where bioproject = "PRJNA591127", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3116017 | 3116017 | PRJNA591127_P_NODE_25303_length_167_cov_1.200000_g25134_i0 | PRJNA591127 | 25303 | 167 | 1.2 | 2.004 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 99.8 | 1.7799999999999994e-24 | NR | KAH9254165.1 | 1357716 | g25134 | i0 | 81.5 | 0.970059880239521 | 54 | 10 | 97 | 0 | 163 | 2 | 93 | 146 | KAH9254165.1 hypothetical protein BASA81_007754 [Batrachochytrium salamandrivorans] | diamond | 162 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 17142603 | 17142603 | PRJNA591127_P_NODE_10594_length_226_cov_2.396825_g10426_i0 | PRJNA591127 | 10594 | 226 | 2.396825 | 5.4168245 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 100 | 7.08e-17 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g10426 | i0 | 87.5 | 9.80088495575221 | 88 | 9 | 38 | 2 | 4 | 89 | 6198 | 6111 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 2215 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 18417013 | 18417013 | PRJNA591127_P_NODE_3475_length_385_cov_5.640805_g3307_i0 | PRJNA591127 | 3475 | 385 | 5.640805 | 21.71709925 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 97.8 | 9.890000000000002e-21 | NR | KAJ3201667.1 | 109932 | g3307 | i0 | 52.7 | 5.89090909090909 | 93 | 31 | 62.3 | 1 | 309 | 70 | 502 | 594 | KAJ3201667.1 hypothetical protein HDU82_007948 [Entophlyctis luteolus] | diamond | 2268 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 18990126 | 18990126 | PRJNA591127_P_NODE_20775_length_196_cov_1.735849_g20606_i0 | PRJNA591127 | 20775 | 196 | 1.735849 | 3.40226404 | Chytridium | 4813 | Fungi | Fungi | 117 | 5.93e-22 | NTclustered | gi|82398596|gb|DQ273831.1| | 355335 | g20606 | i0 | 84 | 62.9897959183673 | 125 | 16 | 63 | 4 | 18 | 140 | 1615 | 1737 | Chytridium sp. JEL341 isolate AFTOL-ID 1531 28S ribosomal RNA gene, partial sequence | blastn | 12346 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium sp. JEL341 | |
| 23517484 | 23517484 | PRJNA591127_P_NODE_28439_length_152_cov_1.408696_g28270_i0 | PRJNA591127 | 28439 | 152 | 1.408696 | 2.14121792 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 204 | 3.2399999999999996e-48 | NTclustered | gi|1027029543|ref|XR_001677161.1| | 645134 | g28270 | i0 | 93.478 | 62.5723684210526 | 138 | 8 | 90 | 1 | 16 | 152 | 4073 | 3936 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA | blastn | 9511 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 30377899 | 30377899 | PRJNA591127_P_NODE_18352_length_197_cov_2.237500_g18183_i0 | PRJNA591127 | 18352 | 197 | 2.2375 | 4.407875 | Neocallimastigaceae | 29007 | Fungi | Fungi | 42.4 | 0.0282 | NR | ORX55442.1 | 1754191 | g18183 | i0 | 62.5 | 0.715736040609137 | 24 | 9 | 36.5 | 0 | 5 | 76 | 23 | 46 | ORX55442.1 hypothetical protein BCR36DRAFT_321574 [Piromyces finnis] | diamond | 141 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces finnis | |
| 30901255 | 30901255 | PRJNA591127_P_NODE_4694_length_336_cov_4.374582_g4526_i0 | PRJNA591127 | 4694 | 336 | 4.374582 | 14.69859552 | Physocladia obscura | 109957 | Fungi | Fungi | 70.1 | 3.94e-12 | NR | KAJ3099803.1 | 109957 | g4526 | i0 | 54.4 | 1.21428571428571 | 68 | 31 | 60.7 | 0 | 3 | 206 | 123 | 190 | KAJ3099803.1 60S ribosomal protein L16B [Physocladia obscura] | diamond | 408 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 30946395 | 30946395 | PRJNA591127_P_NODE_21374_length_192_cov_7.309677_g21205_i0 | PRJNA591127 | 21374 | 192 | 7.309677 | 14.03457984 | Fungi | 4751 | Fungi | Fungi | 70.1 | 6.32e-13 | NR | KAI8916505.1 | 109895 | g21205 | i0 | 60 | 11.359375 | 60 | 23 | 93.8 | 1 | 188 | 9 | 103 | 161 | KAI8916505.1 ribosomal protein L6, alpha-beta domain-containing protein [Powellomyces hirtus] | diamond | 2181 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 30964512 | 30964512 | PRJNA591127_P_NODE_32014_length_150_cov_2.805310_g31845_i0 | PRJNA591127 | 32014 | 150 | 2.80531 | 4.207965 | Entophlyctis helioformis | 281842 | Fungi | Fungi | 57.8 | 5.06e-8 | NR | KAI8918865.1 | 281842 | g31845 | i0 | 65 | 4.98 | 40 | 9 | 70 | 1 | 5 | 109 | 378 | 417 | KAI8918865.1 heat shock protein 70 family [Entophlyctis helioformis] | diamond | 747 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 31596957 | 31596957 | PRJNA591127_P_NODE_9196_length_242_cov_6.165854_g9028_i0 | PRJNA591127 | 9196 | 242 | 6.165854 | 14.92136668 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 85.1 | 5.11e-19 | NR | XP_052928041.1 | 1396493 | g9028 | i0 | 57.5 | 1.98347107438017 | 80 | 26 | 90.5 | 2 | 24 | 242 | 1 | 79 | XP_052928041.1 ribosomal protein L32e [Fimicolochytrium jonesii] | diamond | 480 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 32703254 | 32703254 | PRJNA591127_P_NODE_30260_length_151_cov_3.008772_g30091_i0 | PRJNA591127 | 30260 | 151 | 3.008772 | 4.54324572 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 52.8 | 3.09e-6 | NR | KAJ3014875.1 | 1396496 | g30091 | i0 | 44.7 | 0.933774834437086 | 47 | 26 | 93.4 | 0 | 151 | 11 | 135 | 181 | KAJ3014875.1 Programmed cell death protein 2 [Thoreauomyces humboldtii] | diamond | 141 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 32735026 | 32735026 | PRJNA591127_P_NODE_23800_length_176_cov_1.611511_g23631_i0 | PRJNA591127 | 23800 | 176 | 1.611511 | 2.83625936 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 75.9 | 7.71e-16 | NR | ORX85857.1 | 1754192 | g23631 | i0 | 72 | 0.852272727272727 | 50 | 14 | 85.2 | 0 | 1 | 150 | 74 | 123 | ORX85857.1 nucleic acid-binding protein [Anaeromyces robustus] | diamond | 150 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus |
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);;