contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA454154" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17019261 | 17019261 | PRJNA454154_S_NODE_314_length_194_cov_4.796178_g311_i0 | PRJNA454154 | 314 | 194 | 4.796178 | 9.30458532 | Fungi | 4751 | Fungi | Fungi | 131 | 2.4e-35 | NR | KAF0412162.1 | 4874 | g311 | i0 | 95.3 | 18.7731958762887 | 64 | 3 | 99 | 0 | 193 | 2 | 275 | 338 | KAF0412162.1 guanine nucleotide-binding protein, beta subunit [Gigaspora margarita] | diamond | 3642 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 27029070 | 27029070 | PRJNA454154_S_NODE_242_length_211_cov_3.603448_g239_i0 | PRJNA454154 | 242 | 211 | 3.603448 | 7.60327528 | Lichtheimia | 688353 | Fungi | Fungi | 62 | 3.97e-9 | NR | CDH57367.1 | 1263082 | g239 | i0 | 65.9 | 3.04265402843602 | 44 | 15 | 62.6 | 0 | 5 | 136 | 99 | 142 | CDH57367.1 beta-partial [Lichtheimia corymbifera JMRC:FSU:9682] | diamond | 642 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia corymbifera | |
| 27739874 | 27739874 | PRJNA454154_S_NODE_684_length_150_cov_3.530973_g681_i0 | PRJNA454154 | 684 | 150 | 3.530973 | 5.2964595 | Paraglomus brasilianum | 144538 | Fungi | Fungi | 63.2 | 1.55e-10 | NR | CAG8461428.1 | 144538 | g681 | i0 | 67.4 | 0.92 | 46 | 15 | 92 | 0 | 149 | 12 | 130 | 175 | CAG8461428.1 635_t:CDS:2 [Paraglomus brasilianum] | diamond | 138 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus brasilianum | |
| 28749904 | 28749904 | PRJNA454154_S_NODE_387_length_184_cov_2.639456_g384_i0 | PRJNA454154 | 387 | 184 | 2.639456 | 4.85659904 | Umbelopsis isabellina | 91625 | Fungi | Fungi | 76.3 | 1.72e-14 | NR | KAG2174921.1 | 91625 | g384 | i0 | 94.6 | 3.6195652173913 | 37 | 2 | 60.3 | 0 | 3 | 113 | 312 | 348 | KAG2174921.1 hypothetical protein INT43_005983 [Umbelopsis isabellina] | diamond | 666 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 30187008 | 30187008 | PRJNA454154_S_NODE_452_length_176_cov_1.201439_g449_i0 | PRJNA454154 | 452 | 176 | 1.201439 | 2.11453264 | root | 1 | Root_unresolved | Root_unresolved | 74.7 | 8.01e-14 | NR | XP_069252149.1 | 911321 | g449 | i0 | 56.1 | 6.98863636363636 | 57 | 25 | 97.2 | 0 | 173 | 3 | 570 | 626 | XP_069252149.1 uncharacterized protein VTP21DRAFT_11518 [Calcarisporiella thermophila] | diamond | 1230 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 31735690 | 31735690 | PRJNA454154_S_NODE_657_length_152_cov_3.495652_g654_i0 | PRJNA454154 | 657 | 152 | 3.495652 | 5.31339104 | Fungi | 4751 | Fungi | Fungi | 48.5 | 6.23e-5 | NR | KAF9158302.1 | 1343610 | g654 | i0 | 58.3 | 6.27631578947368 | 36 | 15 | 71.1 | 0 | 152 | 45 | 158 | 193 | KAF9158302.1 hypothetical protein DFQ26_007793 [Actinomortierella ambigua] | diamond | 954 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Actinomortierella | Actinomortierella ambigua | |
| 31798950 | 31798950 | PRJNA454154_S_NODE_377_length_185_cov_3.527027_g374_i0 | PRJNA454154 | 377 | 185 | 3.527027 | 6.52499995 | Fungi | 4751 | Fungi | Fungi | 75.1 | 6.79e-15 | NR | ORZ24333.1 | 90262 | g374 | i0 | 79.5 | 3.63243243243243 | 44 | 9 | 71.4 | 0 | 6 | 137 | 144 | 187 | ORZ24333.1 ribosomal protein L6, alpha-beta domain-containing protein [Absidia repens] | diamond | 672 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia repens |
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);;