contig_metadata
13 rows where bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1439429 | 1439429 | PRJNA1028258_P_NODE_35222_length_427_cov_1.270950_g34659_i0 | PRJNA1028258 | 35222 | 427 | 1.27095 | 5.4269565 | Fungi | 4751 | Fungi | Fungi | 246 | 2.41e-80 | NR | KAG5461027.1 | 278681 | g34659 | i0 | 80.9 | 8.92271662763466 | 141 | 27 | 99.1 | 0 | 424 | 2 | 1 | 141 | KAG5461027.1 MAG: putative ribosomal protein L10 [Olpidium bornovanus] | diamond | 3810 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 5267178 | 5267178 | PRJNA1028258_P_NODE_20785_length_559_cov_1.681633_g20229_i0 | PRJNA1028258 | 20785 | 559 | 1.681633 | 9.40032847 | Eukaryota | 2759 | Fungi | Fungi | 317 | 1.46e-102 | NR | BAL15353.1 | 70189 | g20229 | i0 | 82.3 | 4.99105545617174 | 186 | 33 | 99.8 | 0 | 1 | 558 | 276 | 461 | BAL15353.1 translation elongation factor 2, partial [Olpidium brassicae] | diamond | 2790 | 317 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 14194502 | 14194502 | PRJNA1028258_P_NODE_95072_length_266_cov_1.106599_g94509_i0 | PRJNA1028258 | 95072 | 266 | 1.106599 | 2.94355334 | Olpidium bornovanus | 278681 | Fungi | Fungi | 75 | 5.19e-9 | NTclustered | gi|358030883|dbj|AB609175.1| | 278681 | g94509 | i0 | 95.745 | 0.176691729323308 | 47 | 1 | 18 | 1 | 217 | 263 | 185 | 230 | Olpidium bornovanus EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19785, clone: 2 | blastn | 47 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 20564480 | 20564480 | PRJNA1028258_P_NODE_121917_length_243_cov_0.844828_g121354_i0 | PRJNA1028258 | 121917 | 243 | 0.844828 | 2.05293204 | Olpidium brassicae | 70189 | Fungi | Fungi | 261 | 3.34e-65 | NTclustered | gi|358030887|dbj|AB609177.1| | 70189 | g121354 | i0 | 86.008 | 75.1316872427983 | 243 | 34 | 100 | 0 | 1 | 243 | 1732 | 1490 | Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 | blastn | 18257 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 24392002 | 24392002 | PRJNA1028258_P_NODE_9840_length_801_cov_2.728142_g9381_i0 | PRJNA1028258 | 9840 | 801 | 2.728142 | 21.85241742 | Olpidium bornovanus | 278681 | Fungi | Fungi | 448 | 8.779999999999999e-121 | NTclustered | gi|358030883|dbj|AB609175.1| | 278681 | g9381 | i0 | 79.274 | 63.7215980024969 | 661 | 121 | 82 | 13 | 1 | 656 | 650 | 1 | Olpidium bornovanus EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19785, clone: 2 | blastn | 51041 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 26718140 | 26718140 | PRJNA1028258_P_NODE_81781_length_285_cov_1.314815_g81218_i0 | PRJNA1028258 | 81781 | 285 | 1.314815 | 3.74722275 | Olpidium bornovanus | 278681 | Fungi | Fungi | 147 | 2.6199999999999994e-42 | NR | KAG5455717.1 | 278681 | g81218 | i0 | 68.1 | 1.97894736842105 | 94 | 30 | 98.9 | 0 | 283 | 2 | 6 | 99 | KAG5455717.1 MAG: putative 60S ribosomal protein RPL8, partial [Olpidium bornovanus] | diamond | 564 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 27121624 | 27121624 | PRJNA1028258_P_NODE_131622_length_235_cov_1.283133_g131059_i0 | PRJNA1028258 | 131622 | 235 | 1.283133 | 3.01536255 | Fungi | 4751 | Fungi | Fungi | 96.7 | 5.56e-22 | NR | KAG5460953.1 | 278681 | g131059 | i0 | 63.8 | 4.40425531914894 | 69 | 25 | 88.1 | 0 | 207 | 1 | 177 | 245 | KAG5460953.1 MAG: HLA-B associated transcript 1, partial [Olpidium bornovanus] | diamond | 1035 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 27501321 | 27501321 | PRJNA1028258_P_NODE_58783_length_332_cov_1.619772_g58220_i0 | PRJNA1028258 | 58783 | 332 | 1.619772 | 5.37764304 | Eukaryota | 2759 | Fungi | Fungi | 132 | 1.01e-36 | NR | KAG5463394.1 | 278681 | g58220 | i0 | 61.1 | 2.92771084337349 | 108 | 42 | 97.6 | 0 | 4 | 327 | 73 | 180 | KAG5463394.1 MAG: 60S ribosomal protein L16, partial [Olpidium bornovanus] | diamond | 972 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 29655639 | 29655639 | PRJNA1028258_P_NODE_146250_length_232_cov_0.871166_g145687_i0 | PRJNA1028258 | 146250 | 232 | 0.871166 | 2.02110512 | Olpidium brassicae | 70189 | Fungi | Fungi | 138 | 4.14e-36 | NR | BAL15353.1 | 70189 | g145687 | i0 | 81.8 | 1.99137931034483 | 77 | 14 | 99.6 | 0 | 232 | 2 | 371 | 447 | BAL15353.1 translation elongation factor 2, partial [Olpidium brassicae] | diamond | 462 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 30312032 | 30312032 | PRJNA1028258_P_NODE_27512_length_484_cov_3.060241_g26952_i0 | PRJNA1028258 | 27512 | 484 | 3.060241 | 14.81156644 | Eukaryota | 2759 | Fungi | Fungi | 145 | 1e-41 | NR | KAG5461717.1 | 278681 | g26952 | i0 | 63.8 | 2.05165289256198 | 105 | 38 | 65.1 | 0 | 407 | 93 | 2 | 106 | KAG5461717.1 MAG: 60S ribosomal protein L33-A-like protein [Olpidium bornovanus] | diamond | 993 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30351604 | 30351604 | PRJNA1028258_P_NODE_90752_length_270_cov_2.298507_g90189_i0 | PRJNA1028258 | 90752 | 270 | 2.298507 | 6.2059689 | Olpidium bornovanus | 278681 | Fungi | Fungi | 114 | 3.89e-27 | NR | BAL15351.1 | 278681 | g90189 | i0 | 60.7 | 0.988888888888889 | 89 | 31 | 98.9 | 2 | 268 | 2 | 186 | 270 | BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus] | diamond | 267 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30793284 | 30793284 | PRJNA1028258_P_NODE_44974_length_377_cov_3.003247_g44411_i0 | PRJNA1028258 | 44974 | 377 | 3.003247 | 11.32224119 | Olpidium bornovanus | 278681 | Fungi | Fungi | 184 | 2.52e-52 | NR | BAL15351.1 | 278681 | g44411 | i0 | 68.8 | 1.9893899204244 | 125 | 39 | 99.5 | 0 | 375 | 1 | 213 | 337 | BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus] | diamond | 750 | 184 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 32026578 | 32026578 | PRJNA1028258_P_NODE_180398_length_218_cov_2.429530_g179835_i0 | PRJNA1028258 | 180398 | 218 | 2.42953 | 5.2963754 | Olpidium bornovanus | 278681 | Fungi | Fungi | 98.6 | 4.13e-23 | NR | KAG5458048.1 | 278681 | g179835 | i0 | 69.6 | 0.94954128440367 | 69 | 21 | 95 | 0 | 12 | 218 | 160 | 228 | KAG5458048.1 MAG: hypothetical protein BJ554DRAFT_1811 [Olpidium bornovanus] | diamond | 207 | 98.6 | 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);;