contig_metadata
10 rows where bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4334803 | 4334803 | PRJNA540466_S_NODE_18104_length_414_cov_1.870968_g17555_i0 | PRJNA540466 | 18104 | 414 | 1.870968 | 7.74580752 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 256 | 1.2399999999999998e-85 | NR | KAJ1500207.1 | 945690 | g17555 | i0 | 93.8 | 0.934782608695652 | 129 | 8 | 93.5 | 0 | 403 | 17 | 24 | 152 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 387 | 256 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26888248 | 26888248 | PRJNA540466_S_NODE_9361_length_548_cov_3.153684_g8844_i0 | PRJNA540466 | 9361 | 548 | 3.153684 | 17.28218832 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 80.9 | 3.63e-15 | NR | KAJ1509200.1 | 945690 | g8844 | i0 | 56.7 | 0.366788321167883 | 67 | 29 | 36.7 | 0 | 25 | 225 | 106 | 172 | KAJ1509200.1 GTP-binding protein [Coelomomyces lativittatus] | diamond | 201 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27598421 | 27598421 | PRJNA540466_S_NODE_60804_length_245_cov_2.790698_g60255_i0 | PRJNA540466 | 60804 | 245 | 2.790698 | 6.8372101 | Eukaryota | 2759 | Fungi | Fungi | 85.9 | 2.79e-19 | NR | KAI9221742.1 | 64508 | g60255 | i0 | 65.6 | 3.71020408163265 | 61 | 21 | 74.7 | 0 | 1 | 183 | 66 | 126 | KAI9221742.1 profilin [Blastocladiella britannica] | diamond | 909 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28341137 | 28341137 | PRJNA540466_S_NODE_52026_length_260_cov_1.449198_g51477_i0 | PRJNA540466 | 52026 | 260 | 1.449198 | 3.7679148 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 50.4 | 5.09e-5 | NR | KAI9138812.1 | 1500003 | g51477 | i0 | 35.5 | 2.65384615384615 | 76 | 48 | 87.7 | 1 | 2 | 229 | 23 | 97 | KAI9138812.1 emp24/gp25L/p24 family/GOLD-domain-containing protein [Paraphysoderma sedebokerense] | diamond | 690 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28577003 | 28577003 | PRJNA540466_S_NODE_6647_length_617_cov_4.137868_g6189_i0 | PRJNA540466 | 6647 | 617 | 4.137868 | 25.53064556 | Fungi | 4751 | Fungi | Fungi | 272 | 3.229999999999999e-87 | NR | KAI9151028.1 | 1313167 | g6189 | i0 | 63.9 | 8.80064829821718 | 202 | 64 | 93.8 | 1 | 613 | 35 | 186 | 387 | KAI9151028.1 Serine/threonine-protein phosphatase 2A activator 2 [Blastocladiella emersonii ATCC 22665] | diamond | 5430 | 274 | 0.992700729927007 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28766434 | 28766434 | PRJNA540466_S_NODE_2447_length_814_cov_5.897436_g2153_i0 | PRJNA540466 | 2447 | 814 | 5.897436 | 48.00512904 | Fungi | 4751 | Fungi | Fungi | 169 | 3.52e-45 | NR | KAI9137930.1 | 1500003 | g2153 | i0 | 37.3 | 11.7088452088452 | 244 | 148 | 89.6 | 2 | 7 | 735 | 207 | 446 | KAI9137930.1 ZPR1 zinc-finger domain-containing protein [Paraphysoderma sedebokerense] | diamond | 9531 | 170 | 0.994117647058824 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29067446 | 29067446 | PRJNA540466_S_NODE_32328_length_318_cov_1.485714_g31779_i0 | PRJNA540466 | 32328 | 318 | 1.485714 | 4.72457052 | Blastocladiella britannica | 64508 | Fungi | Fungi | 107 | 3.2900000000000004e-27 | NR | KAI9221742.1 | 64508 | g31779 | i0 | 64 | 2.43396226415094 | 86 | 31 | 81.1 | 0 | 59 | 316 | 1 | 86 | KAI9221742.1 profilin [Blastocladiella britannica] | diamond | 774 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 30741323 | 30741323 | PRJNA540466_S_NODE_64154_length_240_cov_2.994012_g63605_i0 | PRJNA540466 | 64154 | 240 | 2.994012 | 7.1856288 | Blastocladiella britannica | 64508 | Fungi | Fungi | 44.7 | 0.00599 | NR | KAI9223396.1 | 64508 | g63605 | i0 | 40.8 | 1.9375 | 49 | 29 | 61.3 | 0 | 11 | 157 | 50 | 98 | KAI9223396.1 C2 domain-containing protein, partial [Blastocladiella britannica] | diamond | 465 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31198157 | 31198157 | PRJNA540466_S_NODE_40275_length_289_cov_2.023148_g39726_i0 | PRJNA540466 | 40275 | 289 | 2.023148 | 5.84689772 | Eukaryota | 2759 | Fungi | Fungi | 97.1 | 3.09e-23 | NR | KAJ1500207.1 | 945690 | g39726 | i0 | 60 | 2.80276816608997 | 70 | 28 | 72.7 | 0 | 9 | 218 | 83 | 152 | KAJ1500207.1 nucleoside diphosphate kinase [Coelomomyces lativittatus] | diamond | 810 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32195969 | 32195969 | PRJNA540466_S_NODE_49558_length_265_cov_2.031250_g49009_i0 | PRJNA540466 | 49558 | 265 | 2.03125 | 5.3828125 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 55.5 | 2.54e-7 | NR | KAI9188049.1 | 1313167 | g49009 | i0 | 32.9 | 1.94716981132075 | 85 | 54 | 94 | 2 | 12 | 260 | 42 | 125 | KAI9188049.1 Extended synaptotagmin-3 [Blastocladiella emersonii ATCC 22665] | diamond | 516 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;