contig_metadata
19 rows where bioproject = "PRJNA906294", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5989545 | 5989545 | PRJNA906294_P_NODE_139325_length_327_cov_8.681102_g135209_i0 | PRJNA906294 | 139325 | 327 | 8.681102 | 28.38720354 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 164 | 1.27e-47 | NR | KAI9189134.1 | 1313167 | g135209 | i0 | 83.9 | 3.34862385321101 | 93 | 15 | 85.3 | 0 | 47 | 325 | 226 | 318 | KAI9189134.1 60S ribosomal protein L43 [Blastocladiella emersonii ATCC 22665] | diamond | 1095 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 7626799 | 7626799 | PRJNA906294_P_NODE_30966_length_991_cov_7.274510_g27630_i0 | PRJNA906294 | 30966 | 991 | 7.27451 | 72.0903941 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 499 | 5.8399999999999984e-176 | NR | KAJ1509686.1 | 945690 | g27630 | i0 | 79 | 3.72351160443996 | 314 | 64 | 94.8 | 2 | 968 | 30 | 1 | 313 | KAJ1509686.1 hypothetical protein HMI54_002183 [Coelomomyces lativittatus] | diamond | 3690 | 499 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 18738221 | 18738221 | PRJNA906294_P_NODE_161895_length_296_cov_1.201794_g157779_i0 | PRJNA906294 | 161895 | 296 | 1.201794 | 3.55731024 | Blastocladiella britannica | 64508 | Fungi | Fungi | 162 | 7.18e-49 | NR | KAI9216707.1 | 64508 | g157779 | i0 | 84.9 | 16.6317567567568 | 86 | 13 | 87.2 | 0 | 1 | 258 | 62 | 147 | KAI9216707.1 ubiquitin-conjugating enzyme [Blastocladiella britannica] | diamond | 4923 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 21289237 | 21289237 | PRJNA906294_P_NODE_186117_length_269_cov_1.397959_g182001_i0 | PRJNA906294 | 186117 | 269 | 1.397959 | 3.76050971 | Fungi | 4751 | Fungi | Fungi | 102 | 5.93e-26 | NR | KAI9221418.1 | 64508 | g182001 | i0 | 59 | 10.4386617100372 | 83 | 34 | 92.6 | 0 | 20 | 268 | 14 | 96 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 2808 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 22563659 | 22563659 | PRJNA906294_P_NODE_157598_length_301_cov_1.614035_g153482_i0 | PRJNA906294 | 157598 | 301 | 1.614035 | 4.85824535 | Eukaryota | 2759 | Fungi | Fungi | 85.5 | 3.68e-17 | NR | ORZ36170.1 | 765915 | g153482 | i0 | 54.8 | 1.32558139534884 | 73 | 33 | 72.8 | 0 | 299 | 81 | 267 | 339 | ORZ36170.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171] | diamond | 399 | 85.9 | 0.9953434225844 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 26802656 | 26802656 | PRJNA906294_P_NODE_106801_length_395_cov_5.236025_g102686_i0 | PRJNA906294 | 106801 | 395 | 5.236025 | 20.68229875 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 237 | 4.08e-78 | NR | KAJ1500207.1 | 945690 | g102686 | i0 | 91.9 | 0.934177215189873 | 123 | 10 | 93.4 | 0 | 25 | 393 | 3 | 125 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 369 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26834574 | 26834574 | PRJNA906294_P_NODE_213681_length_247_cov_0.873563_g209565_i0 | PRJNA906294 | 213681 | 247 | 0.873563 | 2.15770061 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 65.9 | 6.6e-11 | NR | KAJ1501146.1 | 945690 | g209565 | i0 | 48.2 | 2.35627530364372 | 56 | 29 | 68 | 0 | 72 | 239 | 5 | 60 | KAJ1501146.1 hypothetical protein HMI54_010222 [Coelomomyces lativittatus] | diamond | 582 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27979463 | 27979463 | PRJNA906294_P_NODE_120825_length_361_cov_6.010417_g116710_i0 | PRJNA906294 | 120825 | 361 | 6.010417 | 21.69760537 | Fungi | 4751 | Fungi | Fungi | 121 | 6.99e-33 | NR | KAI9221418.1 | 64508 | g116710 | i0 | 59.8 | 4.83656509695291 | 97 | 39 | 80.6 | 0 | 20 | 310 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28603495 | 28603495 | PRJNA906294_P_NODE_152447_length_308_cov_1.425532_g148331_i0 | PRJNA906294 | 152447 | 308 | 1.425532 | 4.39063856 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 156 | 1.03e-42 | NR | KAI9140729.1 | 1500003 | g148331 | i0 | 73.3 | 0.983766233766234 | 101 | 27 | 98.4 | 0 | 303 | 1 | 223 | 323 | KAI9140729.1 acyl-CoA dehydrogenase/oxidase [Paraphysoderma sedebokerense] | diamond | 303 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28982538 | 28982538 | PRJNA906294_P_NODE_222428_length_244_cov_0.888889_g218312_i0 | PRJNA906294 | 222428 | 244 | 0.888889 | 2.16888916 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 134 | 4.31e-36 | NR | KAI9140239.1 | 1500003 | g218312 | i0 | 81.3 | 3.9344262295082 | 80 | 15 | 98.4 | 0 | 243 | 4 | 237 | 316 | KAI9140239.1 fructose-1-6-bisphosphatase [Paraphysoderma sedebokerense] | diamond | 960 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29045598 | 29045598 | PRJNA906294_P_NODE_219668_length_245_cov_0.883721_g215552_i0 | PRJNA906294 | 219668 | 245 | 0.883721 | 2.16511645 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 42.7 | 0.0389 | NR | KNE59853.1 | 578462 | g215552 | i0 | 36.5 | 0.906122448979592 | 74 | 35 | 86.9 | 2 | 218 | 6 | 834 | 898 | KNE59853.1 serine/threonine protein kinase [Allomyces macrogynus ATCC 38327] | diamond | 222 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29992836 | 29992836 | PRJNA906294_P_NODE_165551_length_291_cov_2.004587_g161435_i0 | PRJNA906294 | 165551 | 291 | 2.004587 | 5.83334817 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 130 | 5.93e-36 | NR | KAI9139274.1 | 1500003 | g161435 | i0 | 69 | 3.63917525773196 | 84 | 26 | 86.6 | 0 | 254 | 3 | 4 | 87 | KAI9139274.1 ribosomal L18ae/LX protein domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1059 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31035709 | 31035709 | PRJNA906294_P_NODE_127515_length_348_cov_1.614545_g123399_i0 | PRJNA906294 | 127515 | 348 | 1.614545 | 5.6186166 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 124 | 7.009999999999999e-34 | NR | KAJ1509529.1 | 945690 | g123399 | i0 | 62.5 | 4.93965517241379 | 96 | 36 | 82.8 | 0 | 348 | 61 | 36 | 131 | KAJ1509529.1 60S ribosomal protein L32 [Coelomomyces lativittatus] | diamond | 1719 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 31541429 | 31541429 | PRJNA906294_P_NODE_213796_length_247_cov_0.873563_g209680_i0 | PRJNA906294 | 213796 | 247 | 0.873563 | 2.15770061 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 84.7 | 8.1e-18 | NR | KAJ1499789.1 | 945690 | g209680 | i0 | 49.4 | 0.983805668016194 | 81 | 31 | 98.4 | 1 | 5 | 247 | 47 | 117 | KAJ1499789.1 hypothetical protein HMI54_011410 [Coelomomyces lativittatus] | diamond | 243 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 31699485 | 31699485 | PRJNA906294_P_NODE_168137_length_288_cov_2.032558_g164021_i0 | PRJNA906294 | 168137 | 288 | 2.032558 | 5.85376704 | Allomyces arbusculus | 64504 | Fungi | Fungi | 43.1 | 0.0469 | NR | KAJ3370748.1 | 64504 | g164021 | i0 | 35 | 0.833333333333333 | 80 | 49 | 80.2 | 1 | 239 | 9 | 490 | 569 | KAJ3370748.1 hypothetical protein GGF31_003770 [Allomyces arbusculus] | diamond | 240 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 31896700 | 31896700 | PRJNA906294_P_NODE_165537_length_291_cov_2.064220_g161421_i0 | PRJNA906294 | 165537 | 291 | 2.06422 | 6.0068802 | Blastocladiales | 4805 | Fungi | Fungi | 77.8 | 7.07e-16 | NR | KAI9222453.1 | 64508 | g161421 | i0 | 49.4 | 2.55670103092783 | 83 | 42 | 85.6 | 0 | 1 | 249 | 35 | 117 | KAI9222453.1 ribosomal protein L14-domain-containing protein [Blastocladiella britannica] | diamond | 744 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32174200 | 32174200 | PRJNA906294_P_NODE_139458_length_327_cov_1.862205_g135342_i0 | PRJNA906294 | 139458 | 327 | 1.862205 | 6.08941035 | Blastocladiella britannica | 64508 | Fungi | Fungi | 90.5 | 1.76e-18 | NR | KAI9221306.1 | 64508 | g135342 | i0 | 54.2 | 1.29357798165138 | 72 | 33 | 66.1 | 0 | 327 | 112 | 610 | 681 | KAI9221306.1 transketolase [Blastocladiella britannica] | diamond | 423 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32427209 | 32427209 | PRJNA906294_P_NODE_88799_length_454_cov_3.973753_g84685_i0 | PRJNA906294 | 88799 | 454 | 3.973753 | 18.04083862 | Blastocladiella britannica | 64508 | Fungi | Fungi | 137 | 2e-38 | NR | KAI9222680.1 | 64508 | g84685 | i0 | 65.5 | 4.15638766519824 | 116 | 40 | 76.7 | 0 | 411 | 64 | 3 | 118 | KAI9222680.1 translation protein SH3-like domain-containing protein, partial [Blastocladiella britannica] | diamond | 1887 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32585470 | 32585470 | PRJNA906294_P_NODE_77559_length_505_cov_1.291667_g73450_i0 | PRJNA906294 | 77559 | 505 | 1.291667 | 6.52291835 | Allomyces arbusculus | 64504 | Fungi | Fungi | 62.8 | 5.06e-8 | NR | KAJ3374396.1 | 64504 | g73450 | i0 | 75.6 | 0.914851485148515 | 41 | 10 | 24.4 | 0 | 504 | 382 | 27 | 67 | KAJ3374396.1 Type I HSP40 co-chaperone [Allomyces arbusculus] | diamond | 462 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus |
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);;