contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 312052 | 312052 | PRJNA1164198_P_NODE_7541_length_456_cov_1.313316_g7280_i0 | PRJNA1164198 | 7541 | 456 | 1.313316 | 5.98872096 | Mycotypha africana | 64632 | Fungi | Fungi | 217 | 1.48e-51 | NTclustered | gi|2432561609|ref|XM_053077210.1| | 64632 | g7280 | i0 | 80.919 | 26.7412280701754 | 283 | 46 | 61 | 8 | 26 | 304 | 115 | 393 | Mycotypha africana 40S ribosomal protein S16 (BDF20DRAFT_816965), partial mRNA | blastn | 12194 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 5415083 | 5415083 | PRJNA1164198_P_NODE_29085_length_245_cov_0.906977_g28816_i0 | PRJNA1164198 | 29085 | 245 | 0.906977 | 2.22209365 | Lichtheimia ornata | 688661 | Fungi | Fungi | 272 | 1.56e-68 | NTclustered | gi|2553588547|ref|XM_058488208.1| | 688661 | g28816 | i0 | 86.831 | 199.216326530612 | 243 | 32 | 99 | 0 | 1 | 243 | 765 | 523 | Lichtheimia ornata polyubiquitin (O0I10_008201), partial mRNA | blastn | 48808 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 7965246 | 7965246 | PRJNA1164198_P_NODE_28527_length_246_cov_0.901734_g28258_i0 | PRJNA1164198 | 28527 | 246 | 0.901734 | 2.21826564 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 198 | 2.7e-46 | NTclustered | gi|2323685239|ref|XM_051587778.1| | 1314678 | g28258 | i0 | 84.925 | 55.7235772357724 | 199 | 27 | 80 | 3 | 20 | 217 | 1 | 197 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_233583), partial mRNA | blastn | 13708 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 9239854 | 9239854 | PRJNA1164198_P_NODE_16408_length_305_cov_1.918103_g16139_i0 | PRJNA1164198 | 16408 | 305 | 1.918103 | 5.85021415 | Zychaea mexicana | 64656 | Fungi | Fungi | 147 | 1.27e-30 | NTclustered | gi|2432170872|ref|XM_053127026.1| | 64656 | g16139 | i0 | 81.522 | 17.0065573770492 | 184 | 29 | 59 | 5 | 42 | 222 | 66 | 247 | Zychaea mexicana uncharacterized protein (BDB00DRAFT_872975), partial mRNA | blastn | 5187 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 11790604 | 11790604 | PRJNA1164198_P_NODE_29750_length_244_cov_0.912281_g29481_i0 | PRJNA1164198 | 29750 | 244 | 0.912281 | 2.22596564 | Rhizopus microsporus | 58291 | Fungi | Fungi | 193 | 1.24e-44 | NTclustered | gi|1331194487|ref|XM_023613453.1| | 1340429 | g29481 | i0 | 82.143 | 38.5450819672131 | 224 | 40 | 92 | 0 | 21 | 244 | 214 | 437 | Rhizopus microsporus ATCC 52813 NADH-quinone oxidoreductase (RHIMIDRAFT_287189), partial mRNA | blastn | 9405 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 13065523 | 13065523 | PRJNA1164198_P_NODE_13751_length_334_cov_1.195402_g13482_i0 | PRJNA1164198 | 13751 | 334 | 1.195402 | 3.99264268 | Lichtheimia ornata | 688661 | Fungi | Fungi | 198 | 3.82e-46 | NTclustered | gi|2553553343|ref|XM_058481344.1| | 688661 | g13482 | i0 | 84.058 | 11.6047904191617 | 207 | 31 | 62 | 2 | 17 | 222 | 299 | 94 | Lichtheimia ornata ribosomal protein S8.e (O0I10_001247), partial mRNA | blastn | 3876 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 13065594 | 13065594 | PRJNA1164198_P_NODE_29291_length_244_cov_1.824561_g29022_i0 | PRJNA1164198 | 29291 | 244 | 1.824561 | 4.45192884 | Mycotypha africana | 64632 | Fungi | Fungi | 222 | 1.59e-53 | NTclustered | gi|2432559510|ref|XM_053076877.1| | 64632 | g29022 | i0 | 84.444 | 114.946721311475 | 225 | 35 | 92 | 0 | 20 | 244 | 228 | 4 | Mycotypha africana ubiquitin-60S ribosomal protein L40 (BDF20DRAFT_813442), partial mRNA | blastn | 28047 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana |
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);;