contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11497306 | 11497306 | PRJEB11748_P_NODE_44990_length_643_cov_87.594502_g42908_i0 | PRJEB11748 | 44990 | 643 | 87.594502 | 563.23264786 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 215 | 4.43e-68 | NR | KAJ3015774.1 | 1396496 | g42908 | i0 | 68.2 | 0.690513219284603 | 148 | 46 | 69.1 | 1 | 566 | 123 | 1 | 147 | KAJ3015774.1 Lactoylglutathione lyase [Thoreauomyces humboldtii] | diamond | 444 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 17869106 | 17869106 | PRJEB11748_P_NODE_27735_length_849_cov_17.276650_g25969_i0 | PRJEB11748 | 27735 | 849 | 17.27665 | 146.6787585 | Fungi | 4751 | Fungi | Fungi | 219 | 1.6099999999999999e-68 | NR | XP_006680941.1 | 684364 | g25969 | i0 | 90.9 | 36.2614840989399 | 121 | 11 | 42.8 | 0 | 840 | 478 | 30 | 150 | XP_006680941.1 uncharacterized protein BATDEDRAFT_90434 [Batrachochytrium dendrobatidis JAM81] | diamond | 30786 | 221 | 0.990950226244344 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 22968961 | 22968961 | PRJEB11748_P_NODE_263859_length_238_cov_12.259887_g261676_i0 | PRJEB11748 | 263859 | 238 | 12.259887 | 29.17853106 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 75.9 | 2.47e-15 | NR | KAJ3231220.1 | 4814 | g261676 | i0 | 60.3 | 7.70168067226891 | 68 | 24 | 84.5 | 3 | 217 | 17 | 75 | 140 | KAJ3231220.1 40s ribosomal protein L44e [Chytriomyces hyalinus] | diamond | 1833 | 76.3 | 0.99475753604194 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 27444093 | 27444093 | PRJEB11748_P_NODE_359783_length_192_cov_25.687023_g357600_i0 | PRJEB11748 | 359783 | 192 | 25.687023 | 49.31908416 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 90.9 | 2.06e-19 | NR | KAH9254398.1 | 1357716 | g357600 | i0 | 72.4 | 0.90625 | 58 | 13 | 85.9 | 1 | 24 | 188 | 806 | 863 | KAH9254398.1 hypothetical protein BASA81_007511 [Batrachochytrium salamandrivorans] | diamond | 174 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27728185 | 27728185 | PRJEB11748_P_NODE_167724_length_314_cov_12.798419_g165541_i0 | PRJEB11748 | 167724 | 314 | 12.798419 | 40.18703566 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 86.7 | 2.98e-17 | NR | KAJ3275968.1 | 2735257 | g165541 | i0 | 74 | 0.477707006369427 | 50 | 13 | 47.8 | 0 | 292 | 143 | 446 | 495 | KAJ3275968.1 hypothetical protein HK104_003809 [Borealophlyctis nickersoniae] | diamond | 150 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae | |
| 28138687 | 28138687 | PRJEB11748_P_NODE_51685_length_596_cov_6.910280_g49576_i0 | PRJEB11748 | 51685 | 596 | 6.91028 | 41.1852688 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 63.2 | 9.08e-8 | NR | KAJ3087548.1 | 2654861 | g49576 | i0 | 58.9 | 0.281879194630872 | 56 | 19 | 27.2 | 2 | 374 | 535 | 57 | 110 | KAJ3087548.1 hypothetical protein HK102_010817 [Quaeritorhiza haematococci] | diamond | 168 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 28574125 | 28574125 | PRJEB11748_P_NODE_340227_length_202_cov_4.879433_g338044_i0 | PRJEB11748 | 340227 | 202 | 4.879433 | 9.85645466 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0158 | NR | RKO88668.1 | 388810 | g338044 | i0 | 71.4 | 7.64851485148515 | 28 | 8 | 41.6 | 0 | 98 | 181 | 9 | 36 | RKO88668.1 hypothetical protein BDK51DRAFT_36230 [Blyttiomyces helicus] | diamond | 1545 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces helicus | |||
| 28706748 | 28706748 | PRJEB11748_P_NODE_221507_length_266_cov_5.590244_g219324_i0 | PRJEB11748 | 221507 | 266 | 5.590244 | 14.87004904 | Chytriomyces sp. MP71 | 1882861 | Fungi | Fungi | 85.1 | 2.46e-19 | NR | KAI8611562.1 | 1882861 | g219324 | i0 | 60.3 | 5.33458646616541 | 63 | 25 | 71.1 | 0 | 189 | 1 | 6 | 68 | KAI8611562.1 ubiquitin-like protein Atg12 [Chytriomyces sp. MP71] | diamond | 1419 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces sp. MP71 | |
| 28921328 | 28921328 | PRJEB11748_P_NODE_257528_length_242_cov_3.900552_g255345_i0 | PRJEB11748 | 257528 | 242 | 3.900552 | 9.43933584 | Fungi | 4751 | Fungi | Fungi | 120 | 5.500000000000001e-30 | NR | TPX70427.1 | 117820 | g255345 | i0 | 79.7 | 21.5702479338843 | 69 | 14 | 85.5 | 0 | 3 | 209 | 408 | 476 | TPX70427.1 hypothetical protein SpCBS45565_g01760 [Spizellomyces sp. 'palustris'] | diamond | 5220 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 29748280 | 29748280 | PRJEB11748_P_NODE_195891_length_287_cov_3.765487_g193708_i0 | PRJEB11748 | 195891 | 287 | 3.765487 | 10.80694769 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 102 | 5.93e-26 | NR | KXS13505.1 | 1344416 | g193708 | i0 | 81.8 | 1.37979094076655 | 66 | 12 | 69 | 0 | 33 | 230 | 50 | 115 | KXS13505.1 ribosomal protein L36e [Gonapodya prolifera JEL478] | diamond | 396 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 30222386 | 30222386 | PRJEB11748_P_NODE_264452_length_238_cov_3.570621_g262269_i0 | PRJEB11748 | 264452 | 238 | 3.570621 | 8.49807798 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 90.9 | 4.68e-20 | NR | KAI9014143.1 | 82268 | g262269 | i0 | 68.3 | 4.73949579831933 | 63 | 16 | 74.4 | 1 | 2 | 178 | 197 | 259 | KAI9014143.1 ribosomal family S4e-domain-containing protein [Hyaloraphidium curvatum] | diamond | 1128 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30285982 | 30285982 | PRJEB11748_P_NODE_15772_length_1180_cov_7.928508_g14463_i0 | PRJEB11748 | 15772 | 1180 | 7.928508 | 93.5563944 | Phlyctochytrium planicorne | 261098 | Fungi | Fungi | 78.6 | 1.03e-11 | NR | KAJ3099763.1 | 261098 | g14463 | i0 | 30.2 | 0.874576271186441 | 179 | 121 | 45 | 2 | 813 | 283 | 244 | 420 | KAJ3099763.1 hypothetical protein HDU97_002789 [Phlyctochytrium planicorne] | diamond | 1032 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium planicorne | |
| 30569844 | 30569844 | PRJEB11748_P_NODE_75693_length_484_cov_2.330969_g73536_i0 | PRJEB11748 | 75693 | 484 | 2.330969 | 11.28188996 | Boothiomyces sp. JEL | 2170262 | Fungi | Fungi | 155 | 1.58e-43 | NR | KAJ3320513.1 | 2724215 | g73536 | i0 | 81 | 0.520661157024793 | 84 | 16 | 52.1 | 0 | 481 | 230 | 148 | 231 | KAJ3320513.1 snoRNA-binding rRNA-processing protein imp4 [Boothiomyces sp. JEL0866] | diamond | 252 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces sp. JEL0866 | |
| 31771083 | 31771083 | PRJEB11748_P_NODE_118517_length_381_cov_7.559375_g116342_i0 | PRJEB11748 | 118517 | 381 | 7.559375 | 28.80121875 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 105 | 7.399999999999998e-25 | NR | KAJ1543824.1 | 1604274 | g116342 | i0 | 51 | 1.50393700787402 | 96 | 47 | 75.6 | 0 | 3 | 290 | 189 | 284 | KAJ1543824.1 hypothetical protein HK405_009045 [Cladochytrium tenue] | diamond | 573 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 31859770 | 31859770 | PRJEB11748_P_NODE_233557_length_257_cov_33.448980_g231374_i0 | PRJEB11748 | 233557 | 257 | 33.44898 | 85.9638786 | Batrachochytrium | 100474 | Fungi | Fungi | 45.1 | 0.00682 | NR | KAL5033526.1 | 109871 | g231374 | i0 | 33.8 | 1.5875486381323 | 68 | 45 | 79.4 | 0 | 210 | 7 | 116 | 183 | KAL5033526.1 hypothetical protein RTP6_001481 [Batrachochytrium dendrobatidis] | diamond | 408 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 32176560 | 32176560 | PRJEB11748_P_NODE_55618_length_572_cov_4.317025_g53497_i0 | PRJEB11748 | 55618 | 572 | 4.317025 | 24.693383 | Chytridiomycetes | 451435 | Fungi | Fungi | 201 | 1.32e-60 | NR | KAJ3050614.1 | 64517 | g53497 | i0 | 59.2 | 3.28321678321678 | 157 | 59 | 82.3 | 1 | 572 | 102 | 148 | 299 | KAJ3050614.1 hypothetical protein HK097_008393 [Rhizophlyctis rosea] | diamond | 1878 | 203 | 0.990147783251232 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;