contig_metadata
17 rows where bioproject = "PRJNA438111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709358 | 1709358 | PRJNA438111_P_NODE_642_length_1140_cov_7.495050_g464_i0 | PRJNA438111 | 642 | 1140 | 7.49505 | 85.44357 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 525 | 1.1799999999999994e-183 | NR | KAI9143727.1 | 1500003 | g464 | i0 | 68.6 | 21.9421052631579 | 379 | 119 | 99.7 | 0 | 1138 | 2 | 24 | 402 | KAI9143727.1 phosphoglycerate kinase [Paraphysoderma sedebokerense] | diamond | 25014 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 9362823 | 9362823 | PRJNA438111_P_NODE_8988_length_338_cov_3.556634_g8368_i0 | PRJNA438111 | 8988 | 338 | 3.556634 | 12.02142292 | Fungi | 4751 | Fungi | Fungi | 141 | 2.14e-36 | NR | KNE57467.1 | 578462 | g8368 | i0 | 55.4 | 11.7514792899408 | 112 | 50 | 99.4 | 0 | 3 | 338 | 438 | 549 | KNE57467.1 hypothetical protein AMAG_03178 [Allomyces macrogynus ATCC 38327] | diamond | 3972 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 17011406 | 17011406 | PRJNA438111_P_NODE_394_length_1388_cov_9.420898_g260_i0 | PRJNA438111 | 394 | 1388 | 9.420898 | 130.76206424 | Eukaryota | 2759 | Fungi | Fungi | 620 | 2.509999999999999e-217 | NR | KAI9222942.1 | 64508 | g260 | i0 | 70.7 | 25.2341498559078 | 433 | 125 | 93.6 | 1 | 1385 | 87 | 150 | 580 | KAI9222942.1 ATP synthase alpha/beta family, nucleotide-binding domain-containing protein [Blastocladiella britannica] | diamond | 35025 | 620 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27581419 | 27581419 | PRJNA438111_P_NODE_75684_length_161_cov_1.909091_g75059_i0 | PRJNA438111 | 75684 | 161 | 1.909091 | 3.07363651 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 66.6 | 4.55e-11 | NR | KAI9136450.1 | 1500003 | g75059 | i0 | 57.7 | 0.968944099378882 | 52 | 22 | 96.9 | 0 | 161 | 6 | 267 | 318 | KAI9136450.1 putative Na P-type ATPase [Paraphysoderma sedebokerense] | diamond | 156 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27865478 | 27865478 | PRJNA438111_P_NODE_42905_length_190_cov_2.645963_g42280_i0 | PRJNA438111 | 42905 | 190 | 2.645963 | 5.0273297 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 97.8 | 7.859999999999998e-24 | NR | KAI9143895.1 | 1500003 | g42280 | i0 | 72.6 | 3.91578947368421 | 62 | 17 | 97.9 | 0 | 187 | 2 | 71 | 132 | KAI9143895.1 acyl-CoA N-acyltransferase [Paraphysoderma sedebokerense] | diamond | 744 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28118125 | 28118125 | PRJNA438111_P_NODE_6085_length_402_cov_3.085791_g5496_i0 | PRJNA438111 | 6085 | 402 | 3.085791 | 12.40487982 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 144 | 3.61e-38 | NR | KAI9143701.1 | 1500003 | g5496 | i0 | 53.9 | 0.858208955223881 | 115 | 52 | 85.1 | 1 | 1 | 342 | 250 | 364 | KAI9143701.1 protein phosphatase 2A regulatory B subunit [Paraphysoderma sedebokerense] | diamond | 345 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28166208 | 28166208 | PRJNA438111_P_NODE_15245_length_269_cov_2.350000_g14620_i0 | PRJNA438111 | 15245 | 269 | 2.35 | 6.3215 | Allomyces | 28581 | Fungi | Fungi | 53.5 | 8.37e-6 | NR | KAJ3358450.1 | 64505 | g14620 | i0 | 36.1 | 2.94423791821561 | 61 | 37 | 65.8 | 1 | 262 | 86 | 1431 | 1491 | KAJ3358450.1 hypothetical protein GGF32_000406 [Allomyces javanicus] | diamond | 792 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 28560339 | 28560339 | PRJNA438111_P_NODE_10067_length_322_cov_4.744027_g9446_i0 | PRJNA438111 | 10067 | 322 | 4.744027 | 15.27576694 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 81.3 | 3.37e-17 | NR | KAI9172880.1 | 1313167 | g9446 | i0 | 43.3 | 2.70186335403727 | 97 | 53 | 90.4 | 1 | 322 | 32 | 27 | 121 | KAI9172880.1 hypothetical protein H9P43_007011 [Blastocladiella emersonii ATCC 22665] | diamond | 870 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28907316 | 28907316 | PRJNA438111_P_NODE_46628_length_185_cov_5.461538_g46003_i0 | PRJNA438111 | 46628 | 185 | 5.461538 | 10.1038453 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 84.3 | 3.73e-17 | NR | KAI9138115.1 | 1500003 | g46003 | i0 | 61.7 | 4.8972972972973 | 60 | 23 | 97.3 | 0 | 181 | 2 | 105 | 164 | KAI9138115.1 tRNA synthetases class I (M)-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 906 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28907325 | 28907325 | PRJNA438111_P_NODE_60628_length_171_cov_1.802817_g60003_i0 | PRJNA438111 | 60628 | 171 | 1.802817 | 3.08281707 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 55.5 | 4.71e-7 | NR | KAI9141699.1 | 1500003 | g60003 | i0 | 57.7 | 3.66666666666667 | 52 | 19 | 87.7 | 2 | 171 | 22 | 620 | 670 | KAI9141699.1 SNF2 family N-terminal domain-containing protein [Paraphysoderma sedebokerense] | diamond | 627 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29475581 | 29475581 | PRJNA438111_P_NODE_19510_length_242_cov_4.276995_g18885_i0 | PRJNA438111 | 19510 | 242 | 4.276995 | 10.3503279 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 47 | 0.00114 | NR | KAI9141042.1 | 1500003 | g18885 | i0 | 36.2 | 0.71900826446281 | 58 | 36 | 71.9 | 1 | 214 | 41 | 97 | 153 | KAI9141042.1 hypothetical protein BKA69DRAFT_1076897 [Paraphysoderma sedebokerense] | diamond | 174 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30265781 | 30265781 | PRJNA438111_P_NODE_25112_length_217_cov_4.531915_g24487_i0 | PRJNA438111 | 25112 | 217 | 4.531915 | 9.83425555 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 68.2 | 2.94e-13 | NR | KAJ1497547.1 | 945690 | g24487 | i0 | 56.3 | 0.884792626728111 | 64 | 28 | 88.5 | 0 | 194 | 3 | 1 | 64 | KAJ1497547.1 hypothetical protein HMI54_013531 [Coelomomyces lativittatus] | diamond | 192 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30960746 | 30960746 | PRJNA438111_P_NODE_87734_length_152_cov_3.162602_g87109_i0 | PRJNA438111 | 87734 | 152 | 3.162602 | 4.80715504 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 44.3 | 0.00309 | NR | KAI9151179.1 | 1313167 | g87109 | i0 | 46.3 | 0.809210526315789 | 41 | 22 | 80.9 | 0 | 129 | 7 | 314 | 354 | KAI9151179.1 hypothetical protein H9P43_009794 [Blastocladiella emersonii ATCC 22665] | diamond | 123 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31023824 | 31023824 | PRJNA438111_P_NODE_24135_length_221_cov_2.041667_g23510_i0 | PRJNA438111 | 24135 | 221 | 2.041667 | 4.51208407 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 47.8 | 4.82e-4 | NR | KNE69787.1 | 578462 | g23510 | i0 | 43.1 | 2.76923076923077 | 51 | 29 | 69.2 | 0 | 3 | 155 | 461 | 511 | KNE69787.1 hypothetical protein AMAG_14324 [Allomyces macrogynus ATCC 38327] | diamond | 612 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31529874 | 31529874 | PRJNA438111_P_NODE_86196_length_153_cov_3.306452_g85571_i0 | PRJNA438111 | 86196 | 153 | 3.306452 | 5.05887156 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 85.9 | 2.87e-18 | NR | ORZ39971.1 | 765915 | g85571 | i0 | 73.5 | 2.90196078431373 | 49 | 13 | 96.1 | 0 | 151 | 5 | 265 | 313 | ORZ39971.1 rab geranylgeranyltransferase [Catenaria anguillulae PL171] | diamond | 444 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32636365 | 32636365 | PRJNA438111_P_NODE_17160_length_256_cov_2.295154_g16535_i0 | PRJNA438111 | 17160 | 256 | 2.295154 | 5.87559424 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 100 | 1.32e-22 | NR | KAI9139912.1 | 1500003 | g16535 | i0 | 56 | 0.984375 | 84 | 37 | 98.4 | 0 | 254 | 3 | 233 | 316 | KAI9139912.1 pyridoxal phosphate-dependent transferase [Paraphysoderma sedebokerense] | diamond | 252 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32668012 | 32668012 | PRJNA438111_P_NODE_22920_length_226_cov_1.269036_g22295_i0 | PRJNA438111 | 22920 | 226 | 1.269036 | 2.86802136 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 95.5 | 7.840000000000001e-21 | NR | KAI9143714.1 | 1500003 | g22295 | i0 | 60.8 | 1.9646017699115 | 74 | 29 | 98.2 | 0 | 3 | 224 | 979 | 1052 | KAI9143714.1 rab-GTPase-TBC domain-containing protein [Paraphysoderma sedebokerense] | diamond | 444 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;