contig_metadata
13 rows where bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2276035 | 2276035 | PRJNA1002816_P_NODE_5202_length_497_cov_1.162736_g5042_i0 | PRJNA1002816 | 5202 | 497 | 1.162736 | 5.77879792 | Fungi | 4751 | Fungi | Fungi | 207 | 3.65e-63 | NR | KAI7865813.1 | 101115 | g5042 | i0 | 63.7 | 5.420523138833 | 157 | 54 | 94.8 | 2 | 493 | 23 | 1 | 154 | KAI7865813.1 glyceraldehyde-3-phosphate dehydrogenase [Spinellus fusiger] | diamond | 2694 | 209 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Spinellus | Spinellus fusiger | |
| 7805321 | 7805321 | PRJNA1002816_P_NODE_11747_length_323_cov_1.964000_g11587_i0 | PRJNA1002816 | 11747 | 323 | 1.964 | 6.34372 | Opisthokonta | 33154 | Fungi | Fungi | 183 | 6.88e-52 | NR | KAF0480383.1 | 4874 | g11587 | i0 | 82.2 | 10.8761609907121 | 107 | 19 | 99.4 | 0 | 1 | 321 | 590 | 696 | KAF0480383.1 elongation factor 1-alpha [Gigaspora margarita] | diamond | 3513 | 184 | 0.994565217391304 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 7805567 | 7805567 | PRJNA1002816_P_NODE_6907_length_431_cov_1.628492_g6747_i0 | PRJNA1002816 | 6907 | 431 | 1.628492 | 7.01880052 | Fungi | 4751 | Fungi | Fungi | 199 | 1.7600000000000001e-59 | NR | KAG0223645.1 | 90253 | g6747 | i0 | 67.8 | 97.1276102088167 | 143 | 46 | 99.5 | 0 | 430 | 2 | 229 | 371 | KAG0223645.1 26S proteasome regulatory subunit 6A [Actinomortierella wolfii] | diamond | 41862 | 199 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Actinomortierella | Actinomortierella wolfii | |
| 10356014 | 10356014 | PRJNA1002816_P_NODE_15909_length_270_cov_1.172589_g15749_i0 | PRJNA1002816 | 15909 | 270 | 1.172589 | 3.1659903 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 97.1 | 1.13e-15 | NTclustered | gi|1069963725|ref|XM_018438763.1| | 763407 | g15749 | i0 | 96.552 | 4.76666666666667 | 58 | 2 | 21 | 0 | 1 | 58 | 1275 | 1332 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 1287 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 15455396 | 15455396 | PRJNA1002816_P_NODE_10573_length_343_cov_1.066667_g10413_i0 | PRJNA1002816 | 10573 | 343 | 1.066667 | 3.65866781 | Halteromyces radiatus | 101107 | Fungi | Fungi | 91.6 | 6.87e-14 | NTclustered | gi|2323723214|ref|XM_051544668.1| | 101107 | g10413 | i0 | 98.077 | 9.54518950437318 | 52 | 1 | 15 | 0 | 3 | 54 | 465 | 516 | Halteromyces radiatus 40S ribosomal protein S18 (BX664DRAFT_328813), mRNA | blastn | 3274 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 16729719 | 16729719 | PRJNA1002816_P_NODE_13314_length_302_cov_1.344978_g13154_i0 | PRJNA1002816 | 13314 | 302 | 1.344978 | 4.06183356 | Mycotypha africana | 64632 | Fungi | Fungi | 167 | 9.619999999999998e-37 | NTclustered | gi|2432569705|ref|XM_053081713.1| | 64632 | g13154 | i0 | 82.234 | 1.0364238410596 | 197 | 31 | 65 | 4 | 1 | 195 | 368 | 174 | Mycotypha africana 40S ribosomal protein S13 (BDF20DRAFT_882264), mRNA | blastn | 313 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 27879886 | 27879886 | PRJNA1002816_P_NODE_19185_length_246_cov_0.890173_g19025_i0 | PRJNA1002816 | 19185 | 246 | 0.890173 | 2.18982558 | Fungi | 4751 | Fungi | Fungi | 94 | 1.31e-20 | NR | RUP43445.1 | 994334 | g19025 | i0 | 60 | 7.68292682926829 | 80 | 30 | 97.6 | 1 | 1 | 240 | 189 | 266 | RUP43445.1 RNA 3'-terminal phosphate cyclase/enolpyruvate transferase [Jimgerdemannia flammicorona] | diamond | 1890 | 94.7 | 0.992608236536431 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 28416776 | 28416776 | PRJNA1002816_P_NODE_10266_length_348_cov_1.465455_g10106_i0 | PRJNA1002816 | 10266 | 348 | 1.465455 | 5.0997834 | Mucoromycota | 1913637 | Fungi | Fungi | 139 | 3.41e-38 | NR | XP_069238133.1 | 4840 | g10106 | i0 | 60 | 15.8620689655172 | 115 | 46 | 99.1 | 0 | 2 | 346 | 41 | 155 | XP_069238133.1 60S ribosomal protein eL8 [Rhizomucor pusillus] | diamond | 5520 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 29395467 | 29395467 | PRJNA1002816_P_NODE_9509_length_363_cov_1.062069_g9349_i0 | PRJNA1002816 | 9509 | 363 | 1.062069 | 3.85531047 | Fungi | 4751 | Fungi | Fungi | 180 | 5.809999999999999e-54 | NR | KAI9308655.1 | 76405 | g9349 | i0 | 72.3 | 25.7768595041322 | 119 | 33 | 98.3 | 0 | 357 | 1 | 18 | 136 | KAI9308655.1 ribosomal protein S2, flavodoxin-like domain-containing protein [Cunninghamella echinulata] | diamond | 9357 | 181 | 0.994475138121547 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Cunninghamella | Cunninghamella echinulata | |
| 29869104 | 29869104 | PRJNA1002816_P_NODE_16951_length_257_cov_1.293478_g16791_i0 | PRJNA1002816 | 16951 | 257 | 1.293478 | 3.32423846 | Paraglomus | 144537 | Fungi | Fungi | 137 | 5.04e-37 | NR | CAG8549005.1 | 144538 | g16791 | i0 | 74.1 | 13.8910505836576 | 85 | 22 | 99.2 | 0 | 257 | 3 | 68 | 152 | CAG8549005.1 10224_t:CDS:2 [Paraglomus brasilianum] | diamond | 3570 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus brasilianum | |
| 30919297 | 30919297 | PRJNA1002816_P_NODE_19274_length_246_cov_0.890173_g19114_i0 | PRJNA1002816 | 19274 | 246 | 0.890173 | 2.18982558 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 115 | 3.32e-30 | NR | XP_069252398.1 | 911321 | g19114 | i0 | 78.8 | 5.81707317073171 | 80 | 17 | 97.6 | 0 | 245 | 6 | 19 | 98 | XP_069252398.1 60S ribosomal protein eL13 [Calcarisporiella thermophila] | diamond | 1431 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 31677830 | 31677830 | PRJNA1002816_P_NODE_19377_length_245_cov_1.383721_g19217_i0 | PRJNA1002816 | 19377 | 245 | 1.383721 | 3.39011645 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 94.7 | 1.88e-20 | NR | XP_051421593.1 | 64574 | g19217 | i0 | 71.9 | 1.56734693877551 | 64 | 18 | 78.4 | 0 | 195 | 4 | 233 | 296 | XP_051421593.1 uncharacterized protein BYT42DRAFT_547388 [Radiomyces spectabilis] | diamond | 384 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 32469116 | 32469116 | PRJNA1002816_P_NODE_18039_length_250_cov_0.870056_g17879_i0 | PRJNA1002816 | 18039 | 250 | 0.870056 | 2.17514 | Pilaira anomala | 64641 | Fungi | Fungi | 79.7 | 3.83e-15 | NR | KAI9366630.1 | 64641 | g17879 | i0 | 43.5 | 3 | 85 | 43 | 96 | 2 | 1 | 240 | 408 | 492 | KAI9366630.1 cytochrome P450 [Pilaira anomala] | diamond | 750 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Pilaira | Pilaira anomala |
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);;