contig_metadata
11 rows where bioproject = "PRJNA379145" and tax_phylum = "Olpidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6778468 | 6778468 | PRJNA379145_P_NODE_27786_length_449_cov_2.199519_g25701_i0 | PRJNA379145 | 27786 | 449 | 2.199519 | 9.87584031 | Olpidium bornovanus | 278681 | Fungi | Fungi | 168 | 1.07e-45 | NR | KAG5455529.1 | 278681 | g25701 | i0 | 54.7 | 3.96213808463252 | 148 | 61 | 98.9 | 3 | 6 | 449 | 251 | 392 | KAG5455529.1 MAG: MCM2/3/5 family-domain-containing protein [Olpidium bornovanus] | diamond | 1779 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 15703393 | 15703393 | PRJNA379145_P_NODE_22373_length_544_cov_2.107632_g20421_i0 | PRJNA379145 | 22373 | 544 | 2.107632 | 11.46551808 | Fungi | 4751 | Fungi | Fungi | 229 | 2.7599999999999996e-73 | NR | KAG5461027.1 | 278681 | g20421 | i0 | 82.6 | 6.55147058823529 | 132 | 23 | 72.8 | 0 | 148 | 543 | 31 | 162 | KAG5461027.1 MAG: putative ribosomal protein L10 [Olpidium bornovanus] | diamond | 3564 | 229 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 28022632 | 28022632 | PRJNA379145_P_NODE_23745_length_518_cov_2.278351_g21752_i0 | PRJNA379145 | 23745 | 518 | 2.278351 | 11.80185818 | Olpidium bornovanus | 278681 | Fungi | Fungi | 73.2 | 1.45e-11 | NR | KAG5459247.1 | 278681 | g21752 | i0 | 37.8 | 0.428571428571429 | 74 | 46 | 42.9 | 0 | 495 | 274 | 228 | 301 | KAG5459247.1 MAG: pre-RNA processing PIH1/Nop17-domain-containing protein [Olpidium bornovanus] | diamond | 222 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 28369806 | 28369806 | PRJNA379145_P_NODE_70886_length_157_cov_2.274194_g68731_i0 | PRJNA379145 | 70886 | 157 | 2.274194 | 3.57048458 | Olpidium bornovanus | 278681 | Fungi | Fungi | 62 | 1.83e-9 | NR | KAG5457713.1 | 278681 | g68731 | i0 | 78.1 | 0.611464968152866 | 32 | 7 | 61.1 | 0 | 97 | 2 | 125 | 156 | KAG5457713.1 MAG: hypothetical protein BJ554DRAFT_2204 [Olpidium bornovanus] | diamond | 96 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 28780198 | 28780198 | PRJNA379145_P_NODE_9007_length_1010_cov_2.506653_g7959_i0 | PRJNA379145 | 9007 | 1010 | 2.506653 | 25.3171953 | Olpidium bornovanus | 278681 | Fungi | Fungi | 72.4 | 7.36e-10 | NR | KAG5457472.1 | 278681 | g7959 | i0 | 44.3 | 0.605940594059406 | 70 | 39 | 20.8 | 0 | 115 | 324 | 311 | 380 | KAG5457472.1 MAG: Pleckstrin homology domain-containing protein, partial [Olpidium bornovanus] | diamond | 612 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 28860380 | 28860380 | PRJNA379145_P_NODE_39388_length_308_cov_2.272727_g37237_i0 | PRJNA379145 | 39388 | 308 | 2.272727 | 6.99999916 | Fungi | 4751 | Fungi | Fungi | 95.9 | 1.7e-20 | NR | KAG5457161.1 | 278681 | g37237 | i0 | 45.5 | 4.07142857142857 | 112 | 49 | 97.4 | 1 | 8 | 307 | 468 | 579 | KAG5457161.1 MAG: Oxoglutarate and iron-dependent oxygenase degradation C-term-domain-containing protein, partial [Olpidium bornovanus] | diamond | 1254 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 29127798 | 29127798 | PRJNA379145_P_NODE_2669_length_1701_cov_4.255396_g2302_i0 | PRJNA379145 | 2669 | 1701 | 4.255396 | 72.38428596 | Olpidium bornovanus | 278681 | Fungi | Fungi | 57.8 | 9.74e-5 | NR | KAG5458536.1 | 278681 | g2302 | i0 | 65.8 | 0.130511463844797 | 38 | 13 | 6.7 | 0 | 1191 | 1304 | 322 | 359 | KAG5458536.1 MAG: hypothetical protein BJ554DRAFT_1218 [Olpidium bornovanus] | diamond | 222 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 29397248 | 29397248 | PRJNA379145_P_NODE_61669_length_183_cov_1.560000_g59515_i0 | PRJNA379145 | 61669 | 183 | 1.56 | 2.8548 | Eukaryota | 2759 | Fungi | Fungi | 64.3 | 1.49e-10 | NR | KAG5461045.1 | 278681 | g59515 | i0 | 58.1 | 5.65573770491803 | 43 | 18 | 70.5 | 0 | 6 | 134 | 179 | 221 | KAG5461045.1 MAG: eukaryotic translation elongation factor 2, partial [Olpidium bornovanus] | diamond | 1035 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30391377 | 30391377 | PRJNA379145_P_NODE_3653_length_1511_cov_7.250338_g3174_i0 | PRJNA379145 | 3653 | 1511 | 7.250338 | 109.55260718 | Olpidium bornovanus | 278681 | Fungi | Fungi | 95.5 | 3.66e-17 | NR | KAG5459610.1 | 278681 | g3174 | i0 | 26.3 | 0.85175380542687 | 285 | 152 | 51.2 | 7 | 334 | 1107 | 121 | 374 | KAG5459610.1 MAG: ankyrin repeat-containing domain protein, partial [Olpidium bornovanus] | diamond | 1287 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30991373 | 30991373 | PRJNA379145_P_NODE_58794_length_193_cov_1.912500_g56640_i0 | PRJNA379145 | 58794 | 193 | 1.9125 | 3.691125 | Olpidium bornovanus | 278681 | Fungi | Fungi | 90.5 | 2.67e-20 | NR | KAG5461469.1 | 278681 | g56640 | i0 | 65.1 | 1.95854922279793 | 63 | 22 | 97.9 | 0 | 191 | 3 | 144 | 206 | KAG5461469.1 MAG: sphingolipid Delta4-desaturase-domain-containing protein [Olpidium bornovanus] | diamond | 378 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 32034893 | 32034893 | PRJNA379145_P_NODE_7158_length_1138_cov_2.808145_g6308_i0 | PRJNA379145 | 7158 | 1138 | 2.808145 | 31.9566901 | Olpidium bornovanus | 278681 | Fungi | Fungi | 193 | 4.09e-53 | NR | KAG5462053.1 | 278681 | g6308 | i0 | 34.6 | 1.95342706502636 | 382 | 202 | 93.3 | 8 | 37 | 1098 | 1 | 362 | KAG5462053.1 MAG: hypothetical protein BJ554DRAFT_5663 [Olpidium bornovanus] | diamond | 2223 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus |
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);;