contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11051722 | 11051722 | PRJNA867519_P_NODE_10489_length_352_cov_1.103943_g10335_i0 | PRJNA867519 | 10489 | 352 | 1.103943 | 3.88587936 | Olpidiomycota | 2202805 | Fungi | Fungi | 202 | 1.18e-63 | NR | KAG5458569.1 | 278681 | g10335 | i0 | 84.8 | 6.71590909090909 | 112 | 17 | 95.5 | 0 | 2 | 337 | 88 | 199 | KAG5458569.1 MAG: Mps1 binder-like protein, partial [Olpidium bornovanus] | diamond | 2364 | 204 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 14876132 | 14876132 | PRJNA867519_P_NODE_28372_length_248_cov_0.880000_g28218_i0 | PRJNA867519 | 28372 | 248 | 0.88 | 2.1824 | Fungi | 4751 | Fungi | Fungi | 136 | 3.38e-37 | NR | KAG5459033.1 | 278681 | g28218 | i0 | 75.6 | 34.7177419354839 | 82 | 20 | 99.2 | 0 | 247 | 2 | 189 | 270 | KAG5459033.1 MAG: Dihydrolipoyl dehydrogenase mitochondrial precursor [Olpidium bornovanus] | diamond | 8610 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 18699484 | 18699484 | PRJNA867519_P_NODE_2795_length_611_cov_1.347584_g2645_i0 | PRJNA867519 | 2795 | 611 | 1.347584 | 8.23373824 | Fungi | 4751 | Fungi | Fungi | 343 | 5.7e-118 | NR | KAG5457389.1 | 278681 | g2645 | i0 | 79.8 | 186.378068739771 | 203 | 40 | 99.7 | 1 | 610 | 2 | 7 | 208 | KAG5457389.1 MAG: Tubulin/FtsZ, partial [Olpidium bornovanus] | diamond | 113877 | 346 | 0.991329479768786 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 27181418 | 27181418 | PRJNA867519_P_NODE_7562_length_401_cov_1.878049_g7408_i0 | PRJNA867519 | 7562 | 401 | 1.878049 | 7.53097649 | Olpidium bornovanus | 278681 | Fungi | Fungi | 166 | 3e-48 | NR | KAG5461474.1 | 278681 | g7408 | i0 | 64.6 | 0.972568578553616 | 130 | 46 | 97.3 | 0 | 399 | 10 | 45 | 174 | KAG5461474.1 MAG: dedicator of cytokinesis 6, isoform CRA_e, partial [Olpidium bornovanus] | diamond | 390 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 29802353 | 29802353 | PRJNA867519_P_NODE_22091_length_266_cov_1.595855_g21937_i0 | PRJNA867519 | 22091 | 266 | 1.595855 | 4.2449743 | Olpidium bornovanus | 278681 | Fungi | Fungi | 47.4 | 0.00107 | NR | KAG5457732.1 | 278681 | g21937 | i0 | 47.4 | 1.1390977443609 | 38 | 20 | 42.9 | 0 | 260 | 147 | 266 | 303 | KAG5457732.1 MAG: hypothetical protein BJ554DRAFT_2181, partial [Olpidium bornovanus] | diamond | 303 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30000207 | 30000207 | PRJNA867519_P_NODE_20111_length_275_cov_1.524752_g19957_i0 | PRJNA867519 | 20111 | 275 | 1.524752 | 4.193068 | Fungi | 4751 | Fungi | Fungi | 105 | 5.5e-25 | NR | KAG5459079.1 | 278681 | g19957 | i0 | 54.6 | 6.19636363636364 | 97 | 34 | 94.9 | 1 | 15 | 275 | 160 | 256 | KAG5459079.1 MAG: dedicator of cytokinesis-domain-containing protein [Olpidium bornovanus] | diamond | 1704 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 30466171 | 30466171 | PRJNA867519_P_NODE_16673_length_290_cov_1.797235_g16519_i0 | PRJNA867519 | 16673 | 290 | 1.797235 | 5.2119815 | Olpidium bornovanus | 278681 | Fungi | Fungi | 128 | 9.47e-34 | NR | KAG5459079.1 | 278681 | g16519 | i0 | 56.8 | 0.982758620689655 | 95 | 41 | 98.3 | 0 | 1 | 285 | 13 | 107 | KAG5459079.1 MAG: dedicator of cytokinesis-domain-containing protein [Olpidium bornovanus] | diamond | 285 | 128 | 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);;