contig_metadata
8 rows where bioproject = "PRJNA904835", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2158574 | 2158574 | PRJNA904835_P_NODE_40102_length_299_cov_1.362832_g39846_i0 | PRJNA904835 | 40102 | 299 | 1.362832 | 4.07486768 | Mycotypha africana | 64632 | Fungi | Fungi | 54.7 | 0.008 | NTclustered | gi|2432559338|ref|XM_053078582.1| | 64632 | g39846 | i0 | 100 | 0.658862876254181 | 29 | 0 | 10 | 0 | 163 | 191 | 307 | 335 | Mycotypha africana uncharacterized protein (BDF20DRAFT_832874), partial mRNA | blastn | 197 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 14910708 | 14910708 | PRJNA904835_P_NODE_26652_length_384_cov_0.954984_g26396_i0 | PRJNA904835 | 26652 | 384 | 0.954984 | 3.66713856 | Eukaryota | 2759 | Fungi | Fungi | 203 | 2.24e-58 | NR | CAG8519310.1 | 4874 | g26396 | i0 | 75.8 | 19.8984375 | 128 | 31 | 100 | 0 | 384 | 1 | 337 | 464 | CAG8519310.1 6912_t:CDS:2 [Gigaspora margarita] | diamond | 7641 | 204 | 0.995098039215686 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 27316508 | 27316508 | PRJNA904835_P_NODE_37063_length_315_cov_1.272727_g36807_i0 | PRJNA904835 | 37063 | 315 | 1.272727 | 4.00909005 | Fungi | 4751 | Fungi | Fungi | 74.7 | 5.02e-13 | NR | CAG8441990.1 | 144530 | g36807 | i0 | 47.8 | 7.05714285714286 | 69 | 35 | 65.7 | 1 | 105 | 311 | 489 | 556 | CAG8441990.1 2526_t:CDS:10 [Ambispora gerdemannii] | diamond | 2223 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora gerdemannii | |
| 28887385 | 28887385 | PRJNA904835_P_NODE_22928_length_418_cov_1.084058_g22673_i0 | PRJNA904835 | 22928 | 418 | 1.084058 | 4.53136244 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 102 | 4.81e-22 | NR | CAB4463824.1 | 588596 | g22673 | i0 | 38.5 | 2.78468899521531 | 130 | 80 | 93.3 | 0 | 411 | 22 | 517 | 646 | CAB4463824.1 unnamed protein product [Rhizophagus irregularis] | diamond | 1164 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 29266231 | 29266231 | PRJNA904835_P_NODE_55149_length_246_cov_0.890173_g54893_i0 | PRJNA904835 | 55149 | 246 | 0.890173 | 2.18982558 | Halteromyces radiatus | 101107 | Fungi | Fungi | 72 | 5.39e-13 | NR | XP_051398182.1 | 101107 | g54893 | i0 | 42.5 | 2.84146341463415 | 80 | 44 | 96.3 | 2 | 242 | 6 | 1 | 79 | XP_051398182.1 WD40-repeat-containing domain protein [Halteromyces radiatus] | diamond | 699 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 29526651 | 29526651 | PRJNA904835_P_NODE_6370_length_863_cov_1.845570_g6168_i0 | PRJNA904835 | 6370 | 863 | 1.84557 | 15.9272691 | Glomeromycetes | 214506 | Fungi | Fungi | 218 | 1.15e-61 | NR | CAG8481170.1 | 4874 | g6168 | i0 | 44.6 | 9.56662804171495 | 269 | 137 | 92.8 | 3 | 63 | 863 | 266 | 524 | CAG8481170.1 2479_t:CDS:2 [Gigaspora margarita] | diamond | 8256 | 219 | 0.995433789954338 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 30189743 | 30189743 | PRJNA904835_P_NODE_18232_length_478_cov_1.128395_g17977_i0 | PRJNA904835 | 18232 | 478 | 1.128395 | 5.3937281 | Mortierellaceae | 4854 | Fungi | Fungi | 48.1 | 0.00549 | NR | KAI9231952.1 | 64523 | g17977 | i0 | 54.3 | 0.658995815899582 | 35 | 16 | 22 | 0 | 477 | 373 | 2 | 36 | KAI9231952.1 MAG: hypothetical protein BYD32DRAFT_441390 [Podila humilis] | diamond | 315 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila humilis | |
| 31762586 | 31762586 | PRJNA904835_P_NODE_27537_length_377_cov_1.013158_g27281_i0 | PRJNA904835 | 27537 | 377 | 1.013158 | 3.81960566 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 49.3 | 8.17e-4 | NR | CAG8534814.1 | 94023 | g27281 | i0 | 30.3 | 0.970822281167109 | 122 | 78 | 94.7 | 5 | 4 | 360 | 46 | 163 | CAG8534814.1 6778_t:CDS:2 [Acaulospora morrowiae] | diamond | 366 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae |
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);;