contig_metadata
9 rows where bioproject = "PRJNA1111448", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10420865 | 10420865 | PRJNA1111448_S_NODE_111609_length_259_cov_1.924731_g110786_i0 | PRJNA1111448 | 111609 | 259 | 1.924731 | 4.98505329 | Fungi | 4751 | Fungi | Fungi | 133 | 1.35e-38 | NR | KAF9277580.1 | 64518 | g110786 | i0 | 82.7 | 74.5945945945946 | 75 | 13 | 86.9 | 0 | 2 | 226 | 5 | 79 | KAF9277580.1 60S ribosomal protein L23 [Mortierella alpina] | diamond | 19320 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina | |
| 10421457 | 10421457 | PRJNA1111448_S_NODE_41809_length_369_cov_1.108108_g40986_i0 | PRJNA1111448 | 41809 | 369 | 1.108108 | 4.08891852 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 147 | 1.0699999999999998e-41 | NR | XP_069253582.1 | 911321 | g40986 | i0 | 65.9 | 1.02439024390244 | 126 | 38 | 99.2 | 3 | 367 | 2 | 110 | 234 | XP_069253582.1 60S ribosomal protein eL6 [Calcarisporiella thermophila] | diamond | 378 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 27099385 | 27099385 | PRJNA1111448_S_NODE_136322_length_242_cov_1.715976_g135499_i0 | PRJNA1111448 | 136322 | 242 | 1.715976 | 4.15266192 | Linnemannia zychae | 979765 | Fungi | Fungi | 57 | 3.38e-7 | NR | KAF9915400.1 | 979765 | g135499 | i0 | 47.1 | 1.25206611570248 | 51 | 27 | 63.2 | 0 | 171 | 19 | 399 | 449 | KAF9915400.1 hypothetical protein FBU30_002029 [Linnemannia zychae] | diamond | 303 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia zychae | |
| 28322283 | 28322283 | PRJNA1111448_S_NODE_60846_length_326_cov_1.521739_g60023_i0 | PRJNA1111448 | 60846 | 326 | 1.521739 | 4.96086914 | Mortierellaceae | 4854 | Fungi | Fungi | 102 | 1.08e-22 | NR | KAF9999864.1 | 101097 | g60023 | i0 | 49 | 11.6411042944785 | 96 | 48 | 87.4 | 1 | 321 | 37 | 327 | 422 | KAF9999864.1 Carnitine O-acetyltransferase mitochondrial, partial [Entomortierella chlamydospora] | diamond | 3795 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella chlamydospora | |
| 28764276 | 28764276 | PRJNA1111448_S_NODE_135447_length_243_cov_0.905882_g134624_i0 | PRJNA1111448 | 135447 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | Fungi | Fungi | 99.4 | 1.08e-22 | NR | XP_051426604.1 | 64574 | g134624 | i0 | 63.2 | 27.679012345679 | 68 | 25 | 84 | 0 | 239 | 36 | 283 | 350 | XP_051426604.1 G-protein beta subunit [Radiomyces spectabilis] | diamond | 6726 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 29246714 | 29246714 | PRJNA1111448_S_NODE_46429_length_356_cov_4.063604_g45606_i0 | PRJNA1111448 | 46429 | 356 | 4.063604 | 14.46643024 | Paraglomus occultum | 144539 | Fungi | Fungi | 144 | 4.27e-40 | NR | CAG8552819.1 | 144539 | g45606 | i0 | 66 | 1.68539325842697 | 100 | 34 | 84.3 | 0 | 6 | 305 | 156 | 255 | CAG8552819.1 6621_t:CDS:2 [Paraglomus occultum] | diamond | 600 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus occultum | |
| 29269332 | 29269332 | PRJNA1111448_S_NODE_63749_length_321_cov_1.209677_g62926_i0 | PRJNA1111448 | 63749 | 321 | 1.209677 | 3.88306317 | Endogonomycetes | 2212702 | Fungi | Fungi | 66.2 | 5.32e-10 | NR | XP_069249862.1 | 911321 | g62926 | i0 | 43.5 | 1.57943925233645 | 69 | 38 | 64.5 | 1 | 319 | 113 | 1182 | 1249 | XP_069249862.1 uncharacterized protein VTP21DRAFT_2614 [Calcarisporiella thermophila] | diamond | 507 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 29301199 | 29301199 | PRJNA1111448_S_NODE_111029_length_260_cov_1.235294_g110206_i0 | PRJNA1111448 | 111029 | 260 | 1.235294 | 3.2117644 | Eukaryota | 2759 | Fungi | Fungi | 112 | 2.01e-26 | NR | KAG0334330.1 | 64523 | g110206 | i0 | 59.3 | 23.7576923076923 | 86 | 34 | 99.2 | 1 | 258 | 1 | 1620 | 1704 | KAG0334330.1 rRNA biogenesis protein rrp5 [Podila humilis] | diamond | 6177 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila humilis | |
| 30817329 | 30817329 | PRJNA1111448_S_NODE_75394_length_302_cov_1.943231_g74571_i0 | PRJNA1111448 | 75394 | 302 | 1.943231 | 5.86855762 | Mortierellomycetes | 2212732 | Fungi | Fungi | 71.6 | 4.88e-12 | NR | XP_069252801.1 | 911321 | g74571 | i0 | 46.2 | 2.32450331125828 | 78 | 41 | 76.5 | 1 | 60 | 290 | 222 | 299 | XP_069252801.1 uncharacterized protein VTP21DRAFT_11251 [Calcarisporiella thermophila] | diamond | 702 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila |
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);;