contig_metadata
16 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8613568 | 8613568 | PRJNA980839_P_NODE_95707_length_373_cov_1.070000_g91923_i0 | PRJNA980839 | 95707 | 373 | 1.07 | 3.9911 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 226 | 7.21e-70 | NR | KAH9252906.1 | 1357716 | g91923 | i0 | 87.9 | 0.997319034852547 | 124 | 15 | 99.7 | 0 | 372 | 1 | 261 | 384 | KAH9252906.1 elongation factor 1-alpha [Batrachochytrium salamandrivorans] | diamond | 372 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 13712827 | 13712827 | PRJNA980839_P_NODE_239131_length_241_cov_0.916667_g235347_i0 | PRJNA980839 | 239131 | 241 | 0.916667 | 2.20916747 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 149 | 8.85e-41 | NR | KAH9253674.1 | 1357716 | g235347 | i0 | 94.9 | 0.983402489626556 | 79 | 4 | 98.3 | 0 | 239 | 3 | 226 | 304 | KAH9253674.1 hypothetical protein BASA81_008292 [Batrachochytrium salamandrivorans] | diamond | 237 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 26677789 | 26677789 | PRJNA980839_P_NODE_221541_length_245_cov_0.895349_g217757_i0 | PRJNA980839 | 221541 | 245 | 0.895349 | 2.19360505 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 52.4 | 1.49e-5 | NR | KAH9259781.1 | 1357716 | g217757 | i0 | 42 | 0.991836734693878 | 81 | 32 | 95.5 | 3 | 4 | 237 | 216 | 284 | KAH9259781.1 hypothetical protein BASA81_002203 [Batrachochytrium salamandrivorans] | diamond | 243 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 26773069 | 26773069 | PRJNA980839_P_NODE_184921_length_259_cov_1.655914_g181137_i0 | PRJNA980839 | 184921 | 259 | 1.655914 | 4.28881726 | Boothiomyces sp. JEL | 2170262 | Fungi | Fungi | 58.5 | 1.7e-8 | NR | KAJ3321118.1 | 2724215 | g181137 | i0 | 43.7 | 1.00772200772201 | 87 | 43 | 97.3 | 3 | 7 | 258 | 33 | 116 | KAJ3321118.1 RNA polymerase B [Boothiomyces sp. JEL0866] | diamond | 261 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces sp. JEL0866 | |
| 27279197 | 27279197 | PRJNA980839_P_NODE_161643_length_277_cov_1.509804_g157859_i0 | PRJNA980839 | 161643 | 277 | 1.509804 | 4.18215708 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 138 | 4.51e-39 | NR | KAH9258220.1 | 1357716 | g157859 | i0 | 78.8 | 0.92057761732852 | 85 | 18 | 92.1 | 0 | 256 | 2 | 85 | 169 | KAH9258220.1 ribosomal protein L13 [Batrachochytrium salamandrivorans] | diamond | 255 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27753041 | 27753041 | PRJNA980839_P_NODE_213844_length_247_cov_0.885057_g210060_i0 | PRJNA980839 | 213844 | 247 | 0.885057 | 2.18609079 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 88.2 | 1.78e-19 | NR | KAH9253763.1 | 1357716 | g210060 | i0 | 54.3 | 1.96761133603239 | 81 | 35 | 98.4 | 1 | 2 | 244 | 13 | 91 | KAH9253763.1 hypothetical protein BASA81_008381 [Batrachochytrium salamandrivorans] | diamond | 486 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27885162 | 27885162 | PRJNA980839_P_NODE_114285_length_334_cov_1.475096_g110501_i0 | PRJNA980839 | 114285 | 334 | 1.475096 | 4.92682064 | Fungi | 4751 | Fungi | Fungi | 89 | 2.79e-20 | NR | KAJ3177749.1 | 109894 | g110501 | i0 | 72.2 | 10.2305389221557 | 54 | 15 | 48.5 | 0 | 3 | 164 | 56 | 109 | KAJ3177749.1 60S ribosomal protein L43 [Geranomyces variabilis] | diamond | 3417 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 28131872 | 28131872 | PRJNA980839_P_NODE_151845_length_285_cov_2.103774_g148061_i0 | PRJNA980839 | 151845 | 285 | 2.103774 | 5.9957559 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 47.4 | 0.0015 | NR | KAH9260649.1 | 1357716 | g148061 | i0 | 36.7 | 0.515789473684211 | 49 | 31 | 51.6 | 0 | 278 | 132 | 2030 | 2078 | KAH9260649.1 hypothetical protein BASA81_001116 [Batrachochytrium salamandrivorans] | diamond | 147 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28257856 | 28257856 | PRJNA980839_P_NODE_177566_length_264_cov_2.633508_g173782_i0 | PRJNA980839 | 177566 | 264 | 2.633508 | 6.95246112 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 98.2 | 1.22e-24 | NR | KAH9254429.1 | 1357716 | g173782 | i0 | 71.6 | 0.761363636363636 | 67 | 19 | 76.1 | 0 | 258 | 58 | 17 | 83 | KAH9254429.1 hypothetical protein BASA81_007542 [Batrachochytrium salamandrivorans] | diamond | 201 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28857833 | 28857833 | PRJNA980839_P_NODE_213888_length_247_cov_0.885057_g210104_i0 | PRJNA980839 | 213888 | 247 | 0.885057 | 2.18609079 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 110 | 3.48e-26 | NR | KAH9255379.1 | 1357716 | g210104 | i0 | 66.7 | 1.02024291497976 | 84 | 26 | 99.6 | 1 | 247 | 2 | 473 | 556 | KAH9255379.1 hypothetical protein BASA81_006498 [Batrachochytrium salamandrivorans] | diamond | 252 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29016092 | 29016092 | PRJNA980839_P_NODE_134588_length_304_cov_1.333333_g130804_i0 | PRJNA980839 | 134588 | 304 | 1.333333 | 4.05333232 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 108 | 1.6e-28 | NR | KAH9258993.1 | 1357716 | g130804 | i0 | 60 | 0.888157894736842 | 90 | 22 | 85.9 | 2 | 27 | 287 | 3 | 81 | KAH9258993.1 hypothetical protein BASA81_002613 [Batrachochytrium salamandrivorans] | diamond | 270 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29520963 | 29520963 | PRJNA980839_P_NODE_233770_length_242_cov_0.911243_g229986_i0 | PRJNA980839 | 233770 | 242 | 0.911243 | 2.20520806 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 89.7 | 5.8e-21 | NR | KAH9251936.1 | 1357716 | g229986 | i0 | 81.5 | 0.669421487603306 | 54 | 10 | 66.9 | 0 | 162 | 1 | 6 | 59 | KAH9251936.1 hypothetical protein BASA81_010140 [Batrachochytrium salamandrivorans] | diamond | 162 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29874427 | 29874427 | PRJNA980839_P_NODE_230811_length_243_cov_0.905882_g227027_i0 | PRJNA980839 | 230811 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | Fungi | Fungi | 46.6 | 0.00151 | NR | TPX36453.1 | 286115 | g227027 | i0 | 71.4 | 2.90123456790123 | 28 | 8 | 34.6 | 0 | 159 | 242 | 1 | 28 | TPX36453.1 hypothetical protein SeMB42_g07069 [Synchytrium endobioticum] | diamond | 705 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 29963142 | 29963142 | PRJNA980839_P_NODE_206891_length_249_cov_0.875000_g203107_i0 | PRJNA980839 | 206891 | 249 | 0.875 | 2.17875 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 100 | 9.03e-23 | NR | KAH9256334.1 | 1357716 | g203107 | i0 | 57.3 | 0.987951807228916 | 82 | 34 | 98.8 | 1 | 249 | 4 | 127 | 207 | KAH9256334.1 hypothetical protein BASA81_005555 [Batrachochytrium salamandrivorans] | diamond | 246 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30942714 | 30942714 | PRJNA980839_P_NODE_244134_length_231_cov_2.556962_g240350_i0 | PRJNA980839 | 244134 | 231 | 2.556962 | 5.90658222 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 128 | 2.12e-32 | NR | KAH9261746.1 | 1357716 | g240350 | i0 | 80.3 | 0.987012987012987 | 76 | 15 | 98.7 | 0 | 228 | 1 | 724 | 799 | KAH9261746.1 hypothetical protein BASA81_000402 [Batrachochytrium salamandrivorans] | diamond | 228 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32744732 | 32744732 | PRJNA980839_P_NODE_231740_length_242_cov_2.467456_g227956_i0 | PRJNA980839 | 231740 | 242 | 2.467456 | 5.97124352 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 130 | 6.95e-33 | NR | KAH9253658.1 | 1357716 | g227956 | i0 | 93.6 | 0.966942148760331 | 78 | 5 | 96.7 | 0 | 241 | 8 | 364 | 441 | KAH9253658.1 ATP-dependent chaperone ClpB [Batrachochytrium salamandrivorans] | diamond | 234 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;