contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1625926 | 1625926 | PRJNA1245487_P_NODE_9802_length_382_cov_2.103560_g9464_i0 | PRJNA1245487 | 9802 | 382 | 2.10356 | 8.0355992 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 163 | 3.3200000000000002e-49 | NR | XP_052928041.1 | 1396493 | g9464 | i0 | 65.9 | 3.95026178010471 | 126 | 42 | 99 | 1 | 2 | 379 | 2 | 126 | XP_052928041.1 ribosomal protein L32e [Fimicolochytrium jonesii] | diamond | 1509 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 15654026 | 15654026 | PRJNA1245487_P_NODE_1173_length_1070_cov_2.583751_g943_i0 | PRJNA1245487 | 1173 | 1070 | 2.583751 | 27.6461357 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 274 | 1.3699999999999999e-81 | NR | KAI8893489.1 | 382532 | g943 | i0 | 61.8 | 3.02803738317757 | 220 | 81 | 61.7 | 1 | 1069 | 410 | 405 | 621 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 3240 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 17628977 | 17628977 | PRJNA1245487_P_NODE_11214_length_352_cov_1.172043_g10876_i0 | PRJNA1245487 | 11214 | 352 | 1.172043 | 4.12559136 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 124 | 4.5199999999999995e-30 | NR | KAI9337955.1 | 110081 | g10876 | i0 | 55.2 | 7.88352272727273 | 116 | 51 | 98.9 | 1 | 349 | 2 | 352 | 466 | KAI9337955.1 hypothetical protein BDR26DRAFT_863348 [Obelidium mucronatum] | diamond | 2775 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 18202911 | 18202911 | PRJNA1245487_P_NODE_7435_length_452_cov_1.337731_g7099_i0 | PRJNA1245487 | 7435 | 452 | 1.337731 | 6.04654412 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 155 | 4.12e-45 | NR | KXS17504.1 | 1344416 | g7099 | i0 | 59.3 | 1.8783185840708 | 145 | 59 | 96.2 | 0 | 437 | 3 | 1 | 145 | KXS17504.1 hypothetical protein M427DRAFT_54448 [Gonapodya prolifera JEL478] | diamond | 849 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 19477295 | 19477295 | PRJNA1245487_P_NODE_596_length_1363_cov_3.513178_g432_i0 | PRJNA1245487 | 596 | 1363 | 3.513178 | 47.88461614 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 369 | 1.9699999999999998e-116 | NR | KAI8893489.1 | 382532 | g432 | i0 | 50.4 | 1.74761555392516 | 393 | 188 | 85 | 4 | 1159 | 2 | 25 | 417 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 2382 | 369 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 27453014 | 27453014 | PRJNA1245487_P_NODE_20823_length_246_cov_1.791908_g20485_i0 | PRJNA1245487 | 20823 | 246 | 1.791908 | 4.40809368 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 126 | 1.4e-35 | NR | KAJ3176463.1 | 2724198 | g20485 | i0 | 80.2 | 0.98780487804878 | 81 | 16 | 98.8 | 0 | 2 | 244 | 15 | 95 | KAJ3176463.1 hypothetical protein HDU85_006886, partial [Gaertneriomyces sp. JEL0708] | diamond | 243 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 27768789 | 27768789 | PRJNA1245487_P_NODE_21504_length_244_cov_0.912281_g21166_i0 | PRJNA1245487 | 21504 | 244 | 0.912281 | 2.22596564 | Gaertneriomyces sp. JEL | 1983341 | Fungi | Fungi | 62 | 4.91e-9 | NR | KAJ3175031.1 | 2724198 | g21166 | i0 | 70 | 0.491803278688525 | 40 | 10 | 49.2 | 1 | 239 | 120 | 275 | 312 | KAJ3175031.1 F-actin-capping protein subunit alpha, partial [Gaertneriomyces sp. JEL0708] | diamond | 120 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces sp. JEL0708 | |
| 28354904 | 28354904 | PRJNA1245487_P_NODE_9326_length_395_cov_1.847826_g8988_i0 | PRJNA1245487 | 9326 | 395 | 1.847826 | 7.2989127 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 82 | 3.66e-15 | NR | KAJ3126910.1 | 109957 | g8988 | i0 | 51.2 | 1.24556962025316 | 82 | 39 | 61.5 | 1 | 153 | 395 | 278 | 359 | KAJ3126910.1 hypothetical protein HK100_010029, partial [Physocladia obscura] | diamond | 492 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 29347348 | 29347348 | PRJNA1245487_P_NODE_13309_length_315_cov_2.256198_g12971_i0 | PRJNA1245487 | 13309 | 315 | 2.256198 | 7.1070237 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 79 | 8.25e-16 | NR | TPX43675.1 | 286115 | g12971 | i0 | 49 | 0.990476190476191 | 104 | 51 | 97.1 | 2 | 3 | 308 | 2 | 105 | TPX43675.1 hypothetical protein SeMB42_g04635 [Synchytrium endobioticum] | diamond | 312 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 30849929 | 30849929 | PRJNA1245487_P_NODE_9654_length_386_cov_1.386581_g9316_i0 | PRJNA1245487 | 9654 | 386 | 1.386581 | 5.35220266 | Fungi | 4751 | Fungi | Fungi | 119 | 3.67e-31 | NR | KAJ3099803.1 | 109957 | g9316 | i0 | 57.9 | 8.3160621761658 | 107 | 45 | 83.2 | 0 | 3 | 323 | 84 | 190 | KAJ3099803.1 60S ribosomal protein L16B [Physocladia obscura] | diamond | 3210 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 30990000 | 30990000 | PRJNA1245487_P_NODE_16594_length_275_cov_1.153465_g16256_i0 | PRJNA1245487 | 16594 | 275 | 1.153465 | 3.17202875 | Podochytrium sp. JEL | 2750441 | Fungi | Fungi | 89.4 | 2.28e-18 | NR | KAJ3069575.1 | 2724200 | g16256 | i0 | 57.6 | 2.35636363636364 | 66 | 28 | 72 | 0 | 202 | 5 | 56 | 121 | KAJ3069575.1 hypothetical protein HDU98_007367 [Podochytrium sp. JEL0797] | diamond | 648 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Podochytrium | Podochytrium sp. JEL0797 | |
| 31956527 | 31956527 | PRJNA1245487_P_NODE_20977_length_246_cov_0.901734_g20639_i0 | PRJNA1245487 | 20977 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 7.47e-8 | NR | KAI8808190.1 | 109936 | g20639 | i0 | 43.5 | 4.28048780487805 | 62 | 35 | 75.6 | 0 | 244 | 59 | 204 | 265 | KAI8808190.1 appr-1-p processing enzyme family protein [Cladochytrium replicatum] | diamond | 1053 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum |
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);;