contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA672101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1165488 | 1165488 | PRJNA672101_S_NODE_8561_length_361_cov_3.871528_g8530_i0 | PRJNA672101 | 8561 | 361 | 3.871528 | 13.97621608 | Eukaryota | 2759 | Fungi | Fungi | 199 | 4.85e-60 | NR | XP_051421304.1 | 64574 | g8530 | i0 | 84.9 | 84.9639889196676 | 119 | 18 | 98.9 | 0 | 360 | 4 | 148 | 266 | XP_051421304.1 heat shock protein 70 family [Radiomyces spectabilis] | diamond | 30672 | 199 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 13395813 | 13395813 | PRJNA672101_S_NODE_12411_length_329_cov_3.500000_g12380_i0 | PRJNA672101 | 12411 | 329 | 3.5 | 11.515 | Rhizopus delemar | 936053 | Fungi | Fungi | 100 | 5.42e-22 | NR | KAG1459944.1 | 936053 | g12380 | i0 | 62.7 | 1.50455927051672 | 83 | 29 | 75.7 | 1 | 4 | 252 | 394 | 474 | KAG1459944.1 hypothetical protein G6F55_004455 [Rhizopus delemar] | diamond | 495 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 14671084 | 14671084 | PRJNA672101_S_NODE_32652_length_242_cov_2.307692_g32621_i0 | PRJNA672101 | 32652 | 242 | 2.307692 | 5.58461464 | Fungi | 4751 | Fungi | Fungi | 129 | 6.82e-33 | NR | KAF0477076.1 | 4874 | g32621 | i0 | 81.3 | 23.801652892562 | 80 | 14 | 99.2 | 1 | 3 | 242 | 182 | 260 | KAF0477076.1 integrator complex subunit 11 [Gigaspora margarita] | diamond | 5760 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 27030383 | 27030383 | PRJNA672101_S_NODE_24702_length_265_cov_2.552083_g24671_i0 | PRJNA672101 | 24702 | 265 | 2.552083 | 6.76301995 | Lichtheimiaceae | 499202 | Fungi | Fungi | 86.7 | 1.69e-17 | NR | XP_052984423.1 | 64656 | g24671 | i0 | 52.6 | 3.47547169811321 | 76 | 31 | 83.8 | 2 | 251 | 30 | 155 | 227 | XP_052984423.1 Hsp90 protein-domain-containing protein [Zychaea mexicana] | diamond | 921 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 27062038 | 27062038 | PRJNA672101_S_NODE_26722_length_257_cov_5.108696_g26691_i0 | PRJNA672101 | 26722 | 257 | 5.108696 | 13.12934872 | Eukaryota | 2759 | Fungi | Fungi | 73.2 | 1.6e-13 | NR | XP_069242443.1 | 4840 | g26691 | i0 | 55.6 | 6.91050583657588 | 63 | 27 | 73.5 | 1 | 252 | 64 | 121 | 182 | XP_069242443.1 uncharacterized protein VTP01DRAFT_7978 [Rhizomucor pusillus] | diamond | 1776 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 29020320 | 29020320 | PRJNA672101_S_NODE_15768_length_307_cov_2.837607_g15737_i0 | PRJNA672101 | 15768 | 307 | 2.837607 | 8.71145349 | Fungi | 4751 | Fungi | Fungi | 99 | 1.27e-22 | NR | KAG2182944.1 | 44442 | g15737 | i0 | 70 | 8.20846905537459 | 70 | 20 | 67.4 | 1 | 1 | 207 | 76 | 145 | KAG2182944.1 hypothetical protein INT44_005925 [Umbelopsis vinacea] | diamond | 2520 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis vinacea | |
| 29134617 | 29134617 | PRJNA672101_S_NODE_26529_length_258_cov_1.881081_g26498_i0 | PRJNA672101 | 26529 | 258 | 1.881081 | 4.85318898 | Diversispora epigaea | 1348612 | Fungi | Fungi | 129 | 1.02e-32 | NR | RHZ49594.1 | 1348612 | g26498 | i0 | 73.7 | 2.65116279069767 | 76 | 20 | 88.4 | 0 | 254 | 27 | 535 | 610 | RHZ49594.1 hypothetical protein Glove_519g71 [Diversispora epigaea] | diamond | 684 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Diversisporaceae | Diversispora | Diversispora epigaea | |
| 29588032 | 29588032 | PRJNA672101_S_NODE_5070_length_406_cov_3.336336_g5039_i0 | PRJNA672101 | 5070 | 406 | 3.336336 | 13.54552416 | Opisthokonta | 33154 | Fungi | Fungi | 106 | 3.51e-25 | NR | KAL0092708.1 | 4837 | g5039 | i0 | 53.3 | 8.39408866995074 | 105 | 46 | 76.8 | 2 | 353 | 42 | 69 | 171 | KAL0092708.1 3-hydroxyacyl-CoA dehydrogenase [Phycomyces blakesleeanus] | diamond | 3408 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 31535707 | 31535707 | PRJNA672101_S_NODE_6456_length_385_cov_3.868590_g6425_i0 | PRJNA672101 | 6456 | 385 | 3.86859 | 14.8940715 | Chlamydoabsidia padenii | 90267 | Fungi | Fungi | 52.4 | 4.65e-5 | NR | KAI8340187.1 | 90267 | g6425 | i0 | 50 | 0.88051948051948 | 44 | 22 | 34.3 | 0 | 236 | 367 | 125 | 168 | KAI8340187.1 signal recognition particle receptor beta subunit-domain-containing protein [Chlamydoabsidia padenii] | diamond | 339 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Chlamydoabsidia | Chlamydoabsidia padenii | |
| 32073292 | 32073292 | PRJNA672101_S_NODE_6238_length_388_cov_3.917460_g6207_i0 | PRJNA672101 | 6238 | 388 | 3.91746 | 15.1997448 | Entrophospora candida | 984092 | Fungi | Fungi | 118 | 1.14e-30 | NR | CAG8538841.1 | 984092 | g6207 | i0 | 62.5 | 3.68041237113402 | 88 | 33 | 68 | 0 | 49 | 312 | 101 | 188 | CAG8538841.1 7380_t:CDS:2 [Entrophospora candida] | diamond | 1428 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora candida | |
| 32389668 | 32389668 | PRJNA672101_S_NODE_25359_length_263_cov_1.215789_g25328_i0 | PRJNA672101 | 25359 | 263 | 1.215789 | 3.19752507 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 48.9 | 3.13e-4 | NR | XP_069235786.1 | 4840 | g25328 | i0 | 68.6 | 1.15209125475285 | 35 | 10 | 39.9 | 1 | 175 | 71 | 454 | 487 | XP_069235786.1 uncharacterized protein VTP01DRAFT_5186 [Rhizomucor pusillus] | diamond | 303 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 32484745 | 32484745 | PRJNA672101_S_NODE_14139_length_317_cov_5.545082_g14108_i0 | PRJNA672101 | 14139 | 317 | 5.545082 | 17.57790994 | Diversispora epigaea | 1348612 | Fungi | Fungi | 165 | 3.0199999999999996e-47 | NR | RHZ64114.1 | 1348612 | g14108 | i0 | 74.8 | 31.3438485804416 | 103 | 26 | 97.5 | 0 | 7 | 315 | 104 | 206 | RHZ64114.1 hypothetical protein Glove_326g181 [Diversispora epigaea] | diamond | 9936 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Diversisporaceae | Diversispora | Diversispora epigaea | |
| 32780119 | 32780119 | PRJNA672101_S_NODE_31080_length_246_cov_0.890173_g31049_i0 | PRJNA672101 | 31080 | 246 | 0.890173 | 2.18982558 | Fungi | 4751 | Fungi | Fungi | 71.6 | 5.23e-13 | NR | ORZ23375.1 | 90262 | g31049 | i0 | 65.9 | 7.35365853658537 | 44 | 15 | 53.7 | 0 | 209 | 78 | 123 | 166 | ORZ23375.1 DNL zinc finger-domain-containing protein [Absidia repens] | diamond | 1809 | 71.6 | 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);;