contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27374736 | 27374736 | PRJEB14803_P_NODE_43243_length_158_cov_1.300813_g42777_i0 | PRJEB14803 | 43243 | 158 | 1.300813 | 2.05528454 | Olpidiomycetes | 2202807 | Fungi | Fungi | 80.9 | 2.56e-16 | NR | KAG5456221.1 | 278681 | g42777 | i0 | 69.2 | 1.9746835443038 | 52 | 16 | 98.7 | 0 | 2 | 157 | 177 | 228 | KAG5456221.1 MAG: kinase-like domain-containing protein [Olpidium bornovanus] | diamond | 312 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 27507316 | 27507316 | PRJEB14803_P_NODE_7783_length_477_cov_2.694570_g7326_i0 | PRJEB14803 | 7783 | 477 | 2.69457 | 12.8530989 | Olpidium bornovanus | 278681 | Fungi | Fungi | 181 | 1.1099999999999995e-55 | NR | KAG5463535.1 | 278681 | g7326 | i0 | 64.9 | 0.823899371069182 | 131 | 46 | 82.4 | 0 | 465 | 73 | 1 | 131 | KAG5463535.1 MAG: 60S ribosomal protein L32 [Olpidium bornovanus] | diamond | 393 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 27507322 | 27507322 | PRJEB14803_P_NODE_9423_length_424_cov_1.969152_g8959_i0 | PRJEB14803 | 9423 | 424 | 1.969152 | 8.34920448 | Olpidium bornovanus | 278681 | Fungi | Fungi | 111 | 3.18e-26 | NR | KAG5462250.1 | 278681 | g8959 | i0 | 37.9 | 2.0872641509434 | 145 | 84 | 99.8 | 3 | 2 | 424 | 150 | 292 | KAG5462250.1 MAG: hypothetical protein BJ554DRAFT_5449 [Olpidium bornovanus] | diamond | 885 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30001677 | 30001677 | PRJEB14803_P_NODE_3271_length_789_cov_3.372679_g2937_i0 | PRJEB14803 | 3271 | 789 | 3.372679 | 26.61043731 | Olpidium bornovanus | 278681 | Fungi | Fungi | 82.8 | 4.51e-14 | NR | KAG5462665.1 | 278681 | g2937 | i0 | 41.5 | 0.448669201520913 | 118 | 64 | 43 | 2 | 412 | 750 | 177 | 294 | KAG5462665.1 MAG: hypothetical protein BJ554DRAFT_4155 [Olpidium bornovanus] | diamond | 354 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30254578 | 30254578 | PRJEB14803_P_NODE_35752_length_177_cov_1.971831_g35286_i0 | PRJEB14803 | 35752 | 177 | 1.971831 | 3.49014087 | Olpidium bornovanus | 278681 | Fungi | Fungi | 112 | 9.91e-28 | NR | KAG5463111.1 | 278681 | g35286 | i0 | 85.2 | 2.72881355932203 | 54 | 8 | 91.5 | 0 | 164 | 3 | 140 | 193 | KAG5463111.1 MAG: LOW QUALITY PROTEIN: WD40-repeat-containing domain protein, partial [Olpidium bornovanus] | diamond | 483 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 31518517 | 31518517 | PRJEB14803_P_NODE_13236_length_339_cov_2.625000_g12771_i0 | PRJEB14803 | 13236 | 339 | 2.625 | 8.89875 | Olpidium bornovanus | 278681 | Fungi | Fungi | 73.6 | 3.18e-13 | NR | KAG5458708.1 | 278681 | g12771 | i0 | 40.5 | 0.699115044247788 | 79 | 47 | 69.9 | 0 | 335 | 99 | 72 | 150 | KAG5458708.1 MAG: hypothetical protein BJ554DRAFT_1018 [Olpidium bornovanus] | diamond | 237 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 32056163 | 32056163 | PRJEB14803_P_NODE_27318_length_210_cov_1.600000_g26852_i0 | PRJEB14803 | 27318 | 210 | 1.6 | 3.36 | Olpidium bornovanus | 278681 | Fungi | Fungi | 56.2 | 2.96e-7 | NR | KAG5455783.1 | 278681 | g26852 | i0 | 51.7 | 0.828571428571429 | 58 | 28 | 82.9 | 0 | 185 | 12 | 20 | 77 | KAG5455783.1 MAG: choline transporter-like protein, partial [Olpidium bornovanus] | diamond | 174 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 32303255 | 32303255 | PRJEB14803_P_NODE_7099_length_503_cov_2.677350_g6646_i0 | PRJEB14803 | 7099 | 503 | 2.67735 | 13.4670705 | Olpidiomycota | 2202805 | Fungi | Fungi | 203 | 1.93e-60 | NR | KAG5460731.1 | 278681 | g6646 | i0 | 54.1 | 3.03578528827038 | 170 | 74 | 99.6 | 2 | 2 | 502 | 13 | 181 | KAG5460731.1 MAG: nucleotide-diphospho-sugar transferase, partial [Olpidium bornovanus] | diamond | 1527 | 204 | 0.995098039215686 | 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);;