contig_metadata
21 rows where bioproject = "PRJNA689790", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3219613 | 3219613 | PRJNA689790_S_NODE_4843_length_275_cov_1.663866_g4728_i0 | PRJNA689790 | 4843 | 275 | 1.663866 | 4.5756315 | Eukaryota | 2759 | Fungi | Fungi | 148 | 6.79e-41 | NR | KNE67396.1 | 578462 | g4728 | i0 | 79.1 | 4.96363636363636 | 91 | 19 | 99.3 | 0 | 273 | 1 | 305 | 395 | KNE67396.1 ketol-acid reductoisomerase [Allomyces macrogynus ATCC 38327] | diamond | 1365 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 7047304 | 7047304 | PRJNA689790_S_NODE_12866_length_167_cov_1.769231_g12751_i0 | PRJNA689790 | 12866 | 167 | 1.769231 | 2.95461577 | Fungi | 4751 | Fungi | Fungi | 94.7 | 1.71e-22 | NR | KAI9216776.1 | 64508 | g12751 | i0 | 85.5 | 9.88023952095808 | 55 | 8 | 98.8 | 0 | 1 | 165 | 52 | 106 | KAI9216776.1 ribosomal protein S8e/ribosomal biogenesis NSA2 [Blastocladiella britannica] | diamond | 1650 | 95.1 | 0.995793901156677 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 15971470 | 15971470 | PRJNA689790_S_NODE_4433_length_288_cov_2.641434_g4318_i0 | PRJNA689790 | 4433 | 288 | 2.641434 | 7.60732992 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 139 | 1.99e-28 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g4318 | i0 | 78.261 | 8.19444444444444 | 230 | 40 | 78 | 8 | 64 | 288 | 3159 | 2935 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 2360 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 21071206 | 21071206 | PRJNA689790_S_NODE_9997_length_187_cov_2.406667_g9882_i0 | PRJNA689790 | 9997 | 187 | 2.406667 | 4.50046729 | Allomyces macrogynus | 28583 | Fungi | Fungi | 339 | 1.1e-88 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g9882 | i0 | 99.465 | 35.2299465240642 | 187 | 0 | 100 | 1 | 1 | 187 | 1776 | 1961 | Allomyces macrogynus mitochondrion, complete genome | blastn | 6588 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 26872672 | 26872672 | PRJNA689790_S_NODE_9001_length_197_cov_1.893750_g8886_i0 | PRJNA689790 | 9001 | 197 | 1.89375 | 3.7306875 | Allomyces | 28581 | Fungi | Fungi | 73.9 | 1.14e-13 | NR | KAJ3373364.1 | 64504 | g8886 | i0 | 59.6 | 2.66497461928934 | 57 | 22 | 86.8 | 1 | 26 | 196 | 113 | 168 | KAJ3373364.1 hypothetical protein GGF31_000797 [Allomyces arbusculus] | diamond | 525 | 74.3 | 0.994616419919246 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 27998502 | 27998502 | PRJNA689790_S_NODE_3125_length_355_cov_1.735849_g3010_i0 | PRJNA689790 | 3125 | 355 | 1.735849 | 6.16226395 | Allomyces arbusculus | 64504 | Fungi | Fungi | 168 | 6.93e-49 | NR | KAJ3365191.1 | 64504 | g3010 | i0 | 70.1 | 2.96619718309859 | 117 | 35 | 98.9 | 0 | 3 | 353 | 152 | 268 | KAJ3365191.1 hypothetical protein GGF31_008599 [Allomyces arbusculus] | diamond | 1053 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 28104368 | 28104368 | PRJNA689790_S_NODE_13705_length_163_cov_0.928571_g13590_i0 | PRJNA689790 | 13705 | 163 | 0.928571 | 1.51357073 | root | 1 | Root_unresolved | Root_unresolved | 90.5 | 1.84e-19 | NR | ORZ36412.1 | 765915 | g13590 | i0 | 77.8 | 36.7730061349693 | 54 | 12 | 99.4 | 0 | 2 | 163 | 415 | 468 | ORZ36412.1 carboxyl transferase [Catenaria anguillulae PL171] | diamond | 5994 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28282271 | 28282271 | PRJNA689790_S_NODE_6686_length_230_cov_2.279793_g6571_i0 | PRJNA689790 | 6686 | 230 | 2.279793 | 5.2435239 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 70.5 | 3.08e-13 | NR | KAI9138492.1 | 1500003 | g6571 | i0 | 40.8 | 1.9695652173913 | 76 | 45 | 99.1 | 0 | 230 | 3 | 27 | 102 | KAI9138492.1 nascent polypeptide-associated complex subunit beta [Paraphysoderma sedebokerense] | diamond | 453 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28661473 | 28661473 | PRJNA689790_S_NODE_6687_length_230_cov_2.222798_g6572_i0 | PRJNA689790 | 6687 | 230 | 2.222798 | 5.1124354 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 41.6 | 0.0498 | NR | KNE70846.1 | 578462 | g6572 | i0 | 86.4 | 0.28695652173913 | 22 | 3 | 28.7 | 0 | 1 | 66 | 141 | 162 | KNE70846.1 hypothetical protein AMAG_20187 [Allomyces macrogynus ATCC 38327] | diamond | 66 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28818918 | 28818918 | PRJNA689790_S_NODE_11448_length_176_cov_1.122302_g11333_i0 | PRJNA689790 | 11448 | 176 | 1.122302 | 1.97525152 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 110 | 2.74e-26 | NR | KNE68106.1 | 578462 | g11333 | i0 | 92.9 | 1.90909090909091 | 56 | 4 | 95.5 | 0 | 173 | 6 | 517 | 572 | KNE68106.1 hypothetical protein AMAG_13277 [Allomyces macrogynus ATCC 38327] | diamond | 336 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29387727 | 29387727 | PRJNA689790_S_NODE_6869_length_226_cov_3.084656_g6754_i0 | PRJNA689790 | 6869 | 226 | 3.084656 | 6.97132256 | Allomyces javanicus | 64505 | Fungi | Fungi | 124 | 2.6699999999999996e-35 | NR | KAJ3358191.1 | 64505 | g6754 | i0 | 80.8 | 0.969026548672566 | 73 | 14 | 96.9 | 0 | 7 | 225 | 4 | 76 | KAJ3358191.1 hypothetical protein GGF32_000697 [Allomyces javanicus] | diamond | 219 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 29513683 | 29513683 | PRJNA689790_S_NODE_16710_length_150_cov_4.185841_g16595_i0 | PRJNA689790 | 16710 | 150 | 4.185841 | 6.2787615 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 86.7 | 2.45e-18 | NR | KAI9142157.1 | 1500003 | g16595 | i0 | 77.6 | 2.94 | 49 | 11 | 98 | 0 | 3 | 149 | 169 | 217 | KAI9142157.1 6-phosphogluconate dehydrogenase [Paraphysoderma sedebokerense] | diamond | 441 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29513693 | 29513693 | PRJNA689790_S_NODE_7110_length_222_cov_2.810811_g6995_i0 | PRJNA689790 | 7110 | 222 | 2.810811 | 6.24000042 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 132 | 1.02e-36 | NR | KNE57602.1 | 578462 | g6995 | i0 | 100 | 0.986486486486487 | 73 | 0 | 98.6 | 0 | 220 | 2 | 119 | 191 | KNE57602.1 hypothetical protein AMAG_03292 [Allomyces macrogynus ATCC 38327] | diamond | 219 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29556786 | 29556786 | PRJNA689790_S_NODE_15790_length_154_cov_1.290598_g15675_i0 | PRJNA689790 | 15790 | 154 | 1.290598 | 1.98752092 | Allomyces | 28581 | Fungi | Fungi | 50.4 | 2.12e-5 | NR | KAJ3361684.1 | 64504 | g15675 | i0 | 88.5 | 1.51948051948052 | 26 | 3 | 50.6 | 0 | 154 | 77 | 533 | 558 | KAJ3361684.1 hypothetical protein GGF31_002047 [Allomyces arbusculus] | diamond | 234 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 29671381 | 29671381 | PRJNA689790_S_NODE_16570_length_151_cov_1.368421_g16455_i0 | PRJNA689790 | 16570 | 151 | 1.368421 | 2.06631571 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 96.7 | 5.0600000000000005e-22 | NR | KNE60076.1 | 578462 | g16455 | i0 | 98 | 1.98675496688742 | 50 | 1 | 99.3 | 0 | 150 | 1 | 62 | 111 | KNE60076.1 hypothetical protein AMAG_05507 [Allomyces macrogynus ATCC 38327] | diamond | 300 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29734586 | 29734586 | PRJNA689790_S_NODE_470_length_1066_cov_7.260447_g424_i0 | PRJNA689790 | 470 | 1066 | 7.260447 | 77.39636502 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 422 | 1.5499999999999995e-144 | NR | KNE58244.1 | 578462 | g424 | i0 | 62.8 | 2.89587242026266 | 344 | 120 | 96.2 | 3 | 41 | 1066 | 1 | 338 | KNE58244.1 hypothetical protein AMAG_18391 [Allomyces macrogynus ATCC 38327] | diamond | 3087 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30062095 | 30062095 | PRJNA689790_S_NODE_11711_length_174_cov_1.423358_g11596_i0 | PRJNA689790 | 11711 | 174 | 1.423358 | 2.47664292 | Allomyces | 28581 | Fungi | Fungi | 100 | 4.709999999999999e-23 | NR | KAJ3361684.1 | 64504 | g11596 | i0 | 91.2 | 3.93103448275862 | 57 | 5 | 98.3 | 0 | 173 | 3 | 409 | 465 | KAJ3361684.1 hypothetical protein GGF31_002047 [Allomyces arbusculus] | diamond | 684 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30398789 | 30398789 | PRJNA689790_S_NODE_14953_length_157_cov_1.500000_g14838_i0 | PRJNA689790 | 14953 | 157 | 1.5 | 2.355 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 98.6 | 5.44e-24 | NR | KNE57602.1 | 578462 | g14838 | i0 | 92.3 | 0.993630573248408 | 52 | 4 | 99.4 | 0 | 2 | 157 | 47 | 98 | KNE57602.1 hypothetical protein AMAG_03292 [Allomyces macrogynus ATCC 38327] | diamond | 156 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30567438 | 30567438 | PRJNA689790_S_NODE_5793_length_249_cov_1.339623_g5678_i0 | PRJNA689790 | 5793 | 249 | 1.339623 | 3.33566127 | Allomyces | 28581 | Fungi | Fungi | 85.9 | 1.04e-18 | NR | KAJ3371196.1 | 64504 | g5678 | i0 | 82.2 | 1.62650602409639 | 45 | 8 | 54.2 | 0 | 3 | 137 | 144 | 188 | KAJ3371196.1 hypothetical protein GGF31_003619 [Allomyces arbusculus] | diamond | 405 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30872177 | 30872177 | PRJNA689790_S_NODE_11674_length_174_cov_1.985401_g11559_i0 | PRJNA689790 | 11674 | 174 | 1.985401 | 3.45459774 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 87.8 | 1.9e-18 | NR | KNE71220.1 | 578462 | g11559 | i0 | 81.8 | 0.948275862068966 | 55 | 10 | 94.8 | 0 | 172 | 8 | 113 | 167 | KNE71220.1 hypothetical protein AMAG_15876 [Allomyces macrogynus ATCC 38327] | diamond | 165 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32401909 | 32401909 | PRJNA689790_S_NODE_9819_length_189_cov_1.282895_g9704_i0 | PRJNA689790 | 9819 | 189 | 1.282895 | 2.42467155 | Fungi | 4751 | Fungi | Fungi | 74.7 | 9.5e-14 | NR | ORZ38254.1 | 765915 | g9704 | i0 | 52.5 | 9.76190476190476 | 61 | 29 | 96.8 | 0 | 187 | 5 | 234 | 294 | ORZ38254.1 Fimbrin, actin-bundling protein [Catenaria anguillulae PL171] | diamond | 1845 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;