contig_metadata
6 rows where bioproject = "PRJNA930380", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17487619 | 17487619 | PRJNA930380_P_NODE_14514_length_226_cov_2.013072_g14461_i0 | PRJNA930380 | 14514 | 226 | 2.013072 | 4.54954272 | Eukaryota | 2759 | Fungi | Fungi | 67.8 | 3.59e-11 | NR | CAG8702384.1 | 1348616 | g14461 | i0 | 59.2 | 3.2787610619469 | 49 | 20 | 65 | 0 | 225 | 79 | 222 | 270 | CAG8702384.1 20424_t:CDS:2 [Dentiscutata erythropus] | diamond | 741 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Dentiscutata | Dentiscutata erythropus | |
| 28098748 | 28098748 | PRJNA930380_P_NODE_11865_length_250_cov_0.870056_g11812_i0 | PRJNA930380 | 11865 | 250 | 0.870056 | 2.17514 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 55.5 | 1.34e-6 | NR | KAG0739128.1 | 64495 | g11812 | i0 | 33.9 | 1.488 | 62 | 41 | 74.4 | 0 | 190 | 5 | 255 | 316 | KAG0739128.1 hypothetical protein G6F23_009177 [Rhizopus arrhizus] | diamond | 372 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 30821875 | 30821875 | PRJNA930380_P_NODE_7434_length_285_cov_1.443396_g7381_i0 | PRJNA930380 | 7434 | 285 | 1.443396 | 4.1136786 | Eukaryota | 2759 | Fungi | Fungi | 90.5 | 1.94e-19 | NR | SAL94816.1 | 4829 | g7381 | i0 | 69.6 | 55.8631578947368 | 56 | 17 | 58.9 | 0 | 282 | 115 | 89 | 144 | SAL94816.1 hypothetical protein, partial, partial [Absidia glauca] | diamond | 15921 | 90.9 | 0.995599559955996 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia glauca | |
| 31580717 | 31580717 | PRJNA930380_P_NODE_2616_length_389_cov_1.348101_g2563_i0 | PRJNA930380 | 2616 | 389 | 1.348101 | 5.24411289 | Fungi | 4751 | Fungi | Fungi | 164 | 6.37e-48 | NR | XP_069237435.1 | 4840 | g2563 | i0 | 68.3 | 47.6143958868895 | 126 | 40 | 97.2 | 0 | 388 | 11 | 56 | 181 | XP_069237435.1 60S ribosomal eL18 domain-containing protein [Rhizomucor pusillus] | diamond | 18522 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 32333183 | 32333183 | PRJNA930380_P_NODE_8719_length_279_cov_1.203883_g8666_i0 | PRJNA930380 | 8719 | 279 | 1.203883 | 3.35883357 | Scutellospora calospora | 85575 | Fungi | Fungi | 68.2 | 6.28e-11 | NR | CAG8492355.1 | 85575 | g8666 | i0 | 39.1 | 0.741935483870968 | 69 | 42 | 74.2 | 0 | 278 | 72 | 376 | 444 | CAG8492355.1 10557_t:CDS:2, partial [Scutellospora calospora] | diamond | 207 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Scutellospora | Scutellospora calospora | |
| 32403219 | 32403219 | PRJNA930380_P_NODE_14059_length_242_cov_0.911243_g14006_i0 | PRJNA930380 | 14059 | 242 | 0.911243 | 2.20520806 | Glomeraceae | 36751 | Fungi | Fungi | 84.3 | 6.6e-17 | NR | PKC63512.1 | 588596 | g14006 | i0 | 54.9 | 8.13223140495868 | 82 | 35 | 99.2 | 1 | 241 | 2 | 325 | 406 | PKC63512.1 hypothetical protein RhiirA1_537713, partial [Rhizophagus irregularis] | diamond | 1968 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis |
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);;